High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,900,000 Low 28,000 $ 18,900,000 Fuel: High 44,000 445,896,000 Low 28,000 283,752,000 Airplane maintenance: High 44,000 15,920,000 Low 28,000 11,872,000 Required: Download Excel spreadsheet Use the high-low method to answer the following questions. If an answer is zero, enter "0". If required, round your answers to nearest dollar. 1. What is the variable rate for airplane depreciation? per flight hour What is the fixed cost for airplane depreciation? What is the variable rate for airplane depreciation? per flight hour What is the fixed cost for airplane depreciation? 2. What is the cost formula for airplane depreciation? Total cost of airplane depreciation = 5 3. What is the variable rate for fuel? $ per flight hour What is the fixed cost for fuel? 4. What is the cost formula for fuel? Total cost of fuel s 5. What is the variable rate for airplane maintenance? per flight hour What is the fixed cost for airplane maintenance? 6. What is the cost formula for airplane maintenance? Total cost of airplane maintenance = $ + ($ x ) 7. Using the three cost formulas that you developed, predict the cost of each resource in a month with 36,000 airplane flight hours. (Note: Do not round intermediate calculations.) Total cost of airplane depreciation Total cost of fuel Total cost of airplane maintenance