Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Depreciation and maintenance cost per mile:
Fuel
Crew salaries
2. Monthly Ground Number of Arriv./Depart.
Personnel Arrivals/ Rate per
Terminal City Cost per City Departures =City
Charlotte
Pittsburgh
Detroit
San Francisco
Total
3.
Flight 101 Flight 102 Flight 103
Passenger revenue (passengers x ticket price)
Fuel, crew, and depr. costs (miles x rate)
Ground personnel (sum of arriv./depart. charges)
Flight Profitability Report
Cells with non-gray backgrounds are protected and cannot be edited.
For Three Representative Flights
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
Depreciation and maintenance cost per mile:
2. Monthly Ground Number of Arriv./Depart.
Personnel Arrivals/ Rate per
Terminal City Cost per City Departures =City
Flight 101 Flight 102 Flight 103
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Flight Profitability Report
For Three Representative Flights