1 question 3 parts , please answer the question in the formatnof the excel document , fill in the gray empty spaces with the same vocabulary as the excel sheet, thankyou

Airborne is a small airline operating out of Boise, Idaho. Its three flights travel to Salt Lake City, Reno, and Portland. The owner of the airline wants to assess the full cost of operating each flight. As part of this assessment, the costs of two support departments (maintenance and baggage) must be allocated to the three flights. The two support departments that support all three flights are located in Boise (any maintenance or baggage costs at the destination airports are directly traceable to the individual flights). Budgeted and actual data for the year are as follows for the support departments and the three flights: Support Centers Maintenance Baggage Salt Lake City Flights Reno Portland $240,000 $ 30,000 SI 50.000 $ 64,000 $20,000 $ 5,000 2.000 10,000 $18,000 S10,000 4,000 15.000 Budgeted data: Fixed overhead Variable overhead Hours of flight time Number of passengers Actual data: Fixed overhead Variable overhead Hours of flight time Number of passengers "Normal activity levels $30,000 $ 6,000 2,000 5,000 $29.500 $ 5,800 2.500 6,000 $235.000 S 80,000 $156,000 $ 33,000 $22,000 $ 6,200 1,800 8,000 $17,000 $11,000 4,200 16,000 Round all allocation ratios and variable rates to four significant digits. Round all allocated amounts to the nearest dollar. Required: 1. Using the direct method, allocate the support service costs to each flight, assuming that the objective is to determine the cost of operating each flight. 2. Using the direct method, allocate the support service costs to each flight, assuming that the objective is to evaluate performance. Do any costs remain in the two support departments after the allocation? If so, how much? Explain. Name: 2 3 o appropriate amounts in the gray-shaded cells or select from the drop-down list. Essay answers will not be graded. 4 5 Allocation Ratios for Fbced Costs 6 SLC Reno Portland Total 7 Hours of flight time 8 Percentage 9 10 No. of passengers 11 Percentage 12 13 Variable rates: Maintenance Baggage 14 Expected cost 15 Activity level 16 17 Allocation Based on Budgeted Activity 18 SLC Reno Portland 19 Maintenance-fixed 20 Cost 21 Percentage 22 Maintenance var: 23 Rate: 24 Flight hrs. 25 26 Baggage-fixed 27 Cost 28 Percentago 29 Baggage-var: 30 Rate: 31 Passengers 32 Totals 33 34 35 Allocation Based on Actual Activity 36 SLC Reno Portland 37 Maintenance fixed 38 Cost 39 Percentage 40 Maintenance var: 41 Rate 42 Flight hrs. 43 44 Baggage fixed 45 Cost 46 Percortage 47 Baggage- 48 Rate: 49 Passengers 50 Totals 51 52 53 Do any costs remain in the two support departments ? 54 56 (Key essay answer here] 56