100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.6 TrustPilot
logo-home
Study guide

Excel bestand compleet

Rating
-
Sold
3
Pages
44
Uploaded on
03-07-2019
Written in
2018/2019

Excel bestand compleet 4OPS haal makkelijk een voldoende!

Institution
Course

Content preview

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

AUA 2 3 8514
BJL 2 5104 25.03
BON 2 8420
BVC 1 5068 12.65
CUN 2 1 8956
CUR 2 3 8466
DKR 1 4978 12.15
DWC 2 5606 27.83
HOG 1 1 8214
MBJ 1 8540
MIA 3 8052
PBM 1 1 8122
POP 1 2 7886
PUJ 1 2 7832
SFB 1 7854
SID 1 5006 12.05
SXM 1 7494
VRA 1 2 8382
SID-VXE 1 5175 12.67
HRG-ZNZ 1 8026 20.12

Weekly totals 122.5

FHs per year 6370
max per aircraft 4500


Input for fixed cost B737 B767 B787

Nr of aircraft 2 4 3

Flthrs per aircraft 3185 4219.02 5386.39111

Nr of crews 18 34 34

Crews per aircraft 9 8.5 11.3333333

ASK's per year(x1000) 472,688 2,047,920 2,242,399 4,763,008

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


hours per week Crews per week ASK's per week


B767 B787 B737 B767 B787 B737

38.64 57.25 4 6
4 1868064
38.57 4
2 927444
41.33 19.87 4 2
39.67 55.75 4 6
2 910974
4 2051796
18.97 18.07 2 2
18.88 2
52.2 6
19.23 18.18 2 2
18.93 34.67 2 4
18.83 34.67 2 4
17.57 2
2 916098
16.92 2
20.60 36.5 2 4
2 947025
2 1468758

324.54 310.75333333 18 34 34 9090159

16876.08 16159.173333
5000 6000

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


's per week


B767 B787

4750812 7841394


4698360


4997448 2749492
4724028 7797186




2291706 2521698
2621780
6739524
2266038 2493454
2200194 4842004
2185128 4808848
2191266


2300658
2338578 5146548




39383082 43123062

, Assumptions for calculation of cost per seat on AMS-SID-AMS

Input from network B737-800

Nr of aircraft 2
Flthrs per aircraft 3,185
ASK's per year(x1000) 472,688
Aircraft data B737-800

MTOW [kgs] 78,900
Available Seats 183
Insured value [€] € 32,000,000.00
Lease rental [€ per month] € 350,000.00
Maintenance cost [€ per year] € 2,512,200.00
airframe base maintenance € 1,096,000.00
engines+APU € 484,000.00
components € 535,000.00

line maintenance € 13,200.00
engineering+documentation € 6,000.00
indirect cost € 180,000.00

Cycle Maintenance cost [€ per cycle] € 318.00
Airport data B737-800

AMS Landing/TO charge [€ per flight] € 1,500.00
AMS Ramp handling [€ per flight] € 1,700.00
AMS Airport tax [€ per passenger] € 30.00
AMS Fuel price [$ per gallon] $ 1.85

AMS Terminal Navigation Charge [€] € 55.00
DES Landing/TO charge [$ per flight] $ 662.36
DES Ramp handling [$ per flight] $ 1,400.00
DES Airport tax [$ per passenger] $ 30.00
DES Fuel price [$ per gallon] $ 2.0182
DES Terminal Navigation Charge [€] € 55.00

INT Landing/TO charge [$ per flight] -
INT Ramp handling [$ per flight] -
INT Airport tax [$ per passenger] -
INT Fuel price [$ per gallon] -
INT Terminal Navigation Charge [€] -
Trip data (input from flight plan) B737-800

AMS-DES-AMS distance [nm] 5,006
AMS-DES-AMS flight hours 12.05

Written for

Institution
Study
Course

Document information

Uploaded on
July 3, 2019
Number of pages
44
Written in
2018/2019
Type
Study guide

Subjects

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
highmileclub Hogeschool van Amsterdam
Follow You need to be logged in order to follow users or courses
Sold
119
Member since
9 year
Number of followers
85
Documents
45
Last sold
1 year ago
Aviation Student Rescuer

I like to help aviation students achieve a good grade and a prosperous future.

3.8

20 reviews

5
5
4
7
3
7
2
0
1
1

Trending documents

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions