4OPS Excel

Long haul network of TUI ---------Input from flight plans-----------------------


Round trip from weekly frequency return Flight hours per week


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

AUA 2 3 8514 39
BJL 2 5104 26
BON 2 8420 38.66666652
BVC 1 5068 13.1
CUN 2 1 8956 41
CUR 2 3 8466 42.1
DKR 1 4978 12.6
DWC 2 5606 26.66666668
HOG 1 1 8216 18.83333332
MBJ 1 8540
MIA 3 8052 55.5
PMB 1 1 8122 19.8
POP 1 2 7886 19.6
PUJ 1 2 7832 18
SFB 1 7854 17.57
SID 1 5006 12.36
SXM 1 7494
VRA 1 2 8382 19.16666666
SID-VXE 1 5344 13.833333333
HRG-ZAN 1 8026 18.033333333

totals per week 122.59333335 329.20013317

Flthrs/year 6374.8533340232 17118.406924663

, max per aircraft 4500 5000


Input for fixed cost B737 B767 B787

Nr of aircraft 2 4 3

Flthrs per aircraft 3187 4280 5657

Nr of crews 18 34 34

Crews per aircraft 9 9 11

ASM's per year(x1000) 474,296 2,047,949 2,242,431

Totaal ASM (x 1000) 4,764,677