Reference no: EM131639117

Resource - Airplane Flight Hours And Total Cost

Airplane depreciation: High 44,000  $ 18,200,000 Low 28,000  $ 18,200,000 

Fuel: High 44,000  445,896,000 Low 28,000   283,752,000

Airplane maintenance: High 44,000  16,600,000 Low 28,000  11,776,000

1) Develop an annual cost for fuel by making a formula.

2) Develop an annual cost formula for airplane maintenance

3) Using the three annual cost formulas that you developed, predict the cost of each resource in a year with 489,000 airplane flight hours.

4) Total annual cost of airplane depreciation

5) Total annual cost of fuel

6) Total annual cost of airplane maintenance