4 replies to this topic

[morgrong]

 Aircraft.xls   2.48MB   288 downloads

 

Configuer Seats

 seats_rate.jpg   14.73KB   5 downloads

 

IFE Costs

 costs_IFE.jpg   29.89KB   6 downloads

 

Aircraft Data

 A.jpg   236.28KB   3 downloads

 B.jpg   562.92KB   1 downloads

 

Profit

 C.jpg   267.59KB   2 downloads

 

 

 

 

 

 

(accurate)

Flight Crew($) Per Flight(R/T)     = count Flight Crew(?) * pay(h)  * R/T Flight Time(not R/T Block Time)

Cabin Crew($) Per Flight(R/T)     = count Cabin Crew(?) * pay(h) * R/T Flight Time(not R/T Block Time)

 

Other Fees($) Per Flight(R/T) =

  + Seats(F+C+Y) * FeesPerSeat

  + mile * FeesPerMile

Domestic flight

  FeesPerSeat = 18

  FeesPerMile  = 3

International flight

  FeesPerSeat = 32.4

  FeesPerMile  = 5.4

 

IFS Cost($) Per Flight(R/T) = IFE Cost + IFS Cost

IFE Cost =

  + IFE-CPF(F) * 20%  + ( IFE-CTI(F) * 2% * F Seats)

  + IFE-CPF( * 20%  + ( IFE-CTI( * 2% * B Seats)

  + IFE-CPF(E) * 20%  + ( IFE-CTI(E) * 2% * E Seats)

 

IFE      In-Flight Entertainment

CPF    Costs per Flight

CTI     Costs to Install (per Seat)

 

 

 

(not accurate)

Fuel Cost($) Per Flight(R/T) = distance * 2 * Aircraft Fuel Cost($ Per Mile)

Aircraft Fuel Cost($ Per Mile) = Fuel Flow * 0.2666 / Speed

 

Landing Fees($) Per Flight(R/T) = ?

[OKla]

Now everyone will use efficient aircraft only...

[Alfrenzo]

Lovely, thanks!

[TheGreatOP]

Now everyone will use efficient aircraft only...

That's kind of the point...

[Crane Airlines CEO]

run me throgh a example please. what goes where