Instructions 1. Enter the discount rate (i) in cell C18 (enter as a decimal, e.g., 0.10). The yearly discount factor equal to 1/(1+i)^year is automatically computed and entered in column B. 2. Enter the fuel gallons burned per block hour in cells 118 and 018. 3. Enter the Block Hours per year (number of hours the representative aircraft type is flown in a year) for each aircraft type in 119 and 019. 4. Enter the total maintenance cost per block hour in 120 and 020. 5. Enter the seating capacity (number of seats per aircraft) in 121 and 021. 6. Enter the Speed in Miles per Block Hour in 122 and 022. 7. Enter the Purchase Price (including all cost needed to place the aircraft in service) in 123 and 023 8. Enter the Sale or Salvage Price in year 16 in 124 and 024. 9. Enter the estimated fuel price for each year in the column C31 through C45. The spreadsheet will automatically compute: 1) The Discount Factor for years 1 through 16, 2) The total fuel cost for years 1 through 15, 3) total maintenance cost for year one, 4) total operating costs for each year, 5) total net present cost per year, 6) total available seat miles (ASM) for the 15 years, 7) net present cost per seat mile over the 15 year operating plan. The maintenance costs for years 2 through 15 must be computed and entered Note: In this spreadsheet cash outflows are positive and inflows are negative. The spreadsheet converts the sales price to a negative. Parameters B-767-300 Operating Costs & Statistics B-787-9 Operating Costs & Statistics Discount Rate = Gallons/Block Hour = Gallons/Block Hour = Block Hours/year = Block Hours/year = Maintenance Cost/Block Hour = Maintenance Cost/Block Hour = Number of Seats = Number of Seats = Block hour Speed = Block Hour Speed = Purchase Price = Purchase Price = Sale Price in year 16 = Sale Price in year 16 = B-767 capital and direct operating cost B-787 capital and direct operating cost Year Discount Fuel S/gal Purchase Fuel Maint Total Annual NPV Purchase Fuel Maint Total Annual NPV Factor Price Cost Costs Operating Price Cost Costs Operating 0 1.000 0 0 1 1.000 0 0 0 0 0 0 1.000 0 0 0 0 0 1.000 0 0 0 0 5 1000 0 0 0 on 1.000 O 0 O 0 7 1.000 o 0 0. 0 1.000 o 9 1.OOO 10 1 000 O 11 1.000 12 1.000 0 13 1.000 o o o O 14 1.000 15 1.000 16 1.000 Net Present Value Cost = O Net Present Value Cost = B-767 NP CASM #DIV/O! B-787 NP CASM #DIV/01Operating Cost per Block Hour ($) $1,142.12 Flight Crew Cost $1,567.54 $1,609 94 $1,593.93 $1,568.25 Fuel Cost 2,587.78 2,489.48 2,596.15 2 666.81 2,449.43 Other Costs 34.30 80.22 5.76 30.05 181.71 Total Flying Cost 189.61 $4,179.64 $4,195.84 4 265.11 $3,773.26 Direct Maint. - Airframe 486.13 559.24 306.75 711.32 891.77 Direct Maint. - Engines 238.44 373.59 324.62 3.12 85.03 Total Direct Maintenance 724.57 932.84 631 37 714.44 976.80 Maintenance Burden 304.13 469.83 231.31 286.02 543.00 Total Maintenance Costs $1,028.70 1,402.67 $862.68 $1 000.46 $1,519.81 Deprecation 6.10.26 486.02 616.39 747.79 286.90 Aircraft Rent 213.48 483.65 103.63 80.04 1047.56 Total Cost per Block Hour $6,042.06 $6,551.98 $5 778.53 $6 093.40 $6,627.52 Ratios and Operating Indicators Cost per Available Seat Mile - 6.120 7.074 5.73g 6.390 5.660 Fuel Cost per ASM - 2.620 2.680 2.57 2.80 2.090 Total Cost per ASM ex. Fuel - 3.50# 4.380 3.150 3.59 3.57 Utilization - Block Hours per Day 11.07 9.17 12.40 10.79 9.17 Speed - Miles per Block Hour 463 449 466 452 Seats per Aircraft 213.2 206.4 216.5 202.6 259.0 Gallons of Fuel per Block Hour 1 560 1 522 567 1,588 1 490 Gallons per Block hour/per Seat 7.32 7.38 7.24 7.84 5.75 Fuel Cost per Gallon - $ $1.66 $1.64 $1.66 $1.68 $1.64 Average Flight Stage - miles 3 277 2,609 3 563 3,582 2 364 The Airline Monitor August 2018MBAA 523 Written Assignment 2 Aircraft Performance Data and Operating Costs The Airline Monitor Commercial Alrcraft Data Base Aircraft Types: 767-300ER/767-400 Year 2017 U.S. Block Hour Operating Costs by Alrcraft 767-300ER System Operations Total Delta American United WestJet All Services 767-300ER (6 300s) Operating Data Revenue Pass. Miles (mil.) 43,036.2 7,195.9 23,138.3 9,999.9 2,702.2 Available Seat Miles (mil.) 52,769.6 8,943.5 27 541.1 13,152.6 3,132.5 Load Factor 81.6% 80.5% 84.0% 76.0% 86.3% Revenue Miles (0000 247 516 43 332 127,181 64.906 12 096 Revenue Hours 494 445 87 829 253 ,616 128,203 24,797 Block Hours 534,111 96 445 272 978 137,913 26,775 Aircraft Days 48 232 10 521 22 014 12,777 2 920 Revenue Departures 75 540 16,608 35 ,695 18,120 5,117 Gallons of Fuel (000) 833,413 146 837 427 ,694 218,992 39 889 Number of Aircraft 132.1 28.8 60.3 35.0 Year End Pass. Fleet & % measured 160 82.6% Financial Data 1000 Flight Crew Expense $837 239 $155 270 $435,107 $216,282 $30 580 Fuel Expense 1,382,162 240 098 708 ,693 367 ,788 65 584 Total Flying Expense 2,237 ,719 403 , 105 1,145 371 588,214 101 029 Direct Maint. - Airframe 259 ,649 53 936 83 735 98, 100 23 877 Direct Maint. - Engines 127 ,353 36 031 88 615 430 2 277 Total Direct Maintenance 387 001 89 967 172 350 98,530 26,154 Maintenance Burden 162 440 45 313 63,142 39 ,446 14 539 Depreciation 325 947 46 874 168 260 103,131 7 682 Aircraft Rent 114022 46 646 28, 289 11 038 28 049 Total Operating Exp. $3,227,129 $631 ,906 $1 577 412 $840,359 $177 452