Could you please help me figure out the values for each space?

• Attachment 1
• Attachment 2

Use the following Excel screenshot and information to answer the following TWO questions .Questions are INDEPENDENT .The following table lists some of the major airports in Canada and the United States . Column Acontains the airport name , followed by the two-letter abbreviation of the province / state where*the airport is located , and the three- letter IATA code . For example , Vancouver Airport is located in*the province of &C , and it has YVR as its three- letter IATA code .2AirportProvince / State*ICAO CodeAbbreviation Province / State*3Vancouver BC YVRBritish ColumbiaCYVRABAlbertaCalgary AB YYCAlbertaCYYCBCBritish Columbia5Newark NJ EWRNew JerseyKEWVRONOntario*6Seattle Tacoma WA SEA WashingtonKSEAWAWashingtonToronto Pearson ON YYZ OntarioCYYZNJNew Jersey8| Los Angeles CA LAXCaliforniaKLAXMIDMaryland9OROregon10CACaliforniaTiana was asked to use the look up table EZ : F10 to extract the full name of the province / statewhere each airport is located . For example , if the two – letter abbreviation is AE ( refer to row 4 ) .then Alberta should be displayed . She typed up a formula in cell B.3 , and subsequently draggeddown the formula to complete the rest of the column without manually changing it .Complete the following formula in cell B.3 .CONSTRAINTS FOR THIS QUESTION :". The ONLY thing that can go in each blank is either a FUNCTION name ( such as , but not limitedto , VLOOKUP , COUNTIES , etc. ) or a NUMBER .. You may NOT enter any cell references or any value other than a function name or a number .( A3 ,1 . 21 , S E $ 3 : 5 8$10 ,* FALSE ]

Required information

[The following information applies to the questions displayed below.]

Tastyfreeze Company is a small producer of fruit-flavored frozen desserts. For many years, its products have had strong regional sales because of brand recognition; however, other companies have begun marketing similar products in the area, and price competition has become increasingly important. Dan O’Mara, the company’s controller, is planning to implement a standard cost system for Tastyfreeze and has gathered considerable information from his coworkers about production and materials requirements for Tastyfreeze’s products. Dan believes that the use of standard costs will allow the company to improve cost control, make better pricing decisions, and enhance strategic management.

Tastyfreeze’s most popular product is raspberry sherbet. The sherbet is produced in 10-gallon batches, each of which requires 4 quarts of good raspberries and 10 gallons of other ingredients. The fresh raspberries are sorted by hand before they enter the production process. Because of imperfections in the raspberries and normal spoilage, 1 quart of berries is discarded for every 4 accepted. The standard direct labor time for sorting to obtain 1 quart of acceptable raspberries is 6 minutes. The acceptable raspberries are then blended with the other ingredients; blending requires 18 minutes of direct labor time per batch. After blending, the sherbet is packaged in quart containers. Dan has gathered the following price information:

• Tastyfreeze purchases raspberries for $7 per quart. All other ingredients cost $3.10 per gallon.
• Direct labor is paid at the rate of $24 per hour.
• The total packaging cost (labor and materials) for the sherbet is $0.55 per quart.

Required:

1.Develop the standard cost for the direct cost components of a 10-gallon batch of raspberry sherbet. For each direct cost component, the standard cost should identify the following: (Do not round intermediate calculations. Round your answers to 2 decimal places.)

a. Standard quantity.

b. Standard rate (or price).

c. Standard cost per 10-gallon batch