Blue Skies Airline provides passenger airline service, using small jets. The airline connects four major cities: Atlanta,
Question:
Fuel...................................................$1,450,000
Ground personnel...............................693,250
Crew salaries........................................710,000
Depreciation.........................................360,000
_________
Total costs........................................$3,213,250
_________
Blue Skies management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs:
The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation:
Three recent representative flights have been selected for the profitability study. Their characteristics are as follows:
1. Determine the fuel, crew, and depreciation cost per mile flown.
2. Determine the cost per arrival or departure by terminal city.
3. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.
4. Evaluate flight profitability by determining the break-even number of passengers required for each flight assuming all the costs of a flight are fixed. Round to the nearest whole number.
Step by Step Answer:
Financial and Managerial Accounting Using Excel for Success
ISBN: 978-1111993979
1st edition
Authors: James Reeve, Carl S. Warren, Jonathan Duchac