Using excel formulas, what is the break even calculation in yellow Variable Costs ($/flight hr.) Fuel Lubricants

Using excel formulas, what is the break even calculation in yellow

  

Transcribed Image Text:

Variable Costs ($/flight hr.) Fuel Lubricants Overhaul reserve Operating Data Total flight hours Total Fixed Costs ($/year) 55.00 Maintenance & repair 3.00 Tie-down (allocated) 20.00 Insurance 78.00 180 Total Break-Even Formula 5,000 1,200 1,100 7,300 Dollar Benefit/(Loss) per year (2,440) Fixed Costs - [(Total Hours) x (Revenue/hr. - Variable Cost/hr.)] = 0 Base Case - Break-Even Revenue/Hour Fixed Costs Total Hours Required Revenue/hr. A-20% Higher FC Fixed Costs Total Hours Required Revenue/hr. B - 10% IIigher VC Fixed Costs Total Hours Required Revenue/hr. A+B Fixed Costs Total Hours Required Revenue/hr. 140 Flight Hours Fixed Costs Total Hours Required Revenue/hr. Difference to Base Case Variable Costs ($/flight hr.) Fuel Lubricants Overhaul reserve Operating Data Total flight hours Total Fixed Costs ($/year) 55.00 Maintenance & repair 3.00 Tie-down (allocated) 20.00 Insurance 78.00 180 Total Break-Even Formula 5,000 1,200 1,100 7,300 Dollar Benefit/(Loss) per year (2,440) Fixed Costs - [(Total Hours) x (Revenue/hr. - Variable Cost/hr.)] = 0 Base Case - Break-Even Revenue/Hour Fixed Costs Total Hours Required Revenue/hr. A-20% Higher FC Fixed Costs Total Hours Required Revenue/hr. B - 10% IIigher VC Fixed Costs Total Hours Required Revenue/hr. A+B Fixed Costs Total Hours Required Revenue/hr. 140 Flight Hours Fixed Costs Total Hours Required Revenue/hr. Difference to Base Case

Answer rating: 100% (QA)

Variable costsflight Hr Fuel Lubricants Overhaul Reserve TOTAL Total Flight Hours ANSWER Base Case B... View the full answer