4OPS-IO1-Plannen van een vlucht (EXCEL bestand - cijfer 8.2)

INTRO
Snelkoppeling Excel tabbladen
Network
Assumptions
Total Cost
Maintenance
Ownership cost
Airport landing charge
Navigation charge
Fuel
Ground cost
Indirect cost
Besparing

,
, ---------Input from flight plans-----------------------


Round trip from weekly frequency return Flight hours per week

Amsterdam to: B737 B767 B787 distance [nm] B737 B767

AUA - groep 16 2 3 8514 41
BJL groep 16 2 5104 25
BON- groep 2 2 8420 40
BVC groep 2 1 5068
CUN - groep 8 2 1 8956 43.6
CUR - groep 4 2 3 8466 39.464
DKR - groep 6 1 5243 12.054
DWC - groep 1 2 5976 27.83
HOG - groep 1 1 8214 18
MBJ - groep 5 1 8540
MIA - groep 3 3 8052 55.5
PBM groep 3 1 1 8122 19.23
POP groep 5 1 7886 18.93
PUJ groep 5 1 2 7832 16.57
SFB groep 4 1 7854 17.566
SID groep 8 1 5006 12.366
SXM - groepje 7 1 7636
VRA - groepje 7 1 2 8678 19,9
SID-VXE 1 5248 13.7
HRG-ZAN 1 8026 19.12

totals per week 110.1 309.9

Flthrs/year 5723.6 16112.9

, max per aircraft 4500 5000


Input for fixed cost B737 B767 B787

Nr of aircraft 2 4 2

Flthrs per aircraft 2862 4028 5772

Nr of crews 18 34 30

Crews per aircraft 9 9 15

ASM's per year(x1000) 439,982 2,052,215 2,002,333

Totaal ASM (x 1000) 4,494,530

,--------------- ---------Assessment by group------------- ---------To be calculated by group-------------


Crews per week ASM's per week PAX

B787 B737 B767 B787 B737 B767 B787 B737

58.5 4 6 4750812 7841394 183
4 1868064
4 4698360
2 0 0 927444
18.766 0 4 2 4997448 2749492
55.74 4 6 4724028 7797186
2
4 2258928
16.68 2 2 2291706 2521698
19.5 2 2621780
6 6739524
18.18 2 2 2266038 2493454
0.00 2 2200194 0
34.63 2 4 2185128 4808848
2 2191266
2 946134
17,5 2 2344252
39,8 2 4 2421162 5328292
2 991872
2 1468758

222.0 18 34 30 8,461,200 39,465,666 38,506,396

11544.1

, 6000