Plane Comparisons

[unsaid]

I made an excel sheet with some planes comparing almost all financial aspects. Your thougts please? These are of Air Travel Boom current prices. I can't attach excel sheets, so I took a screen shot.

[attachment expired]

[unsaid]

plane comparisons are made using boeing 753 as standard. cost weights are made using their share in my current company. Of course, the percentages change from company to company, short haul companies or all long haul companies would experience different weighted costs. Also, my company is based in LAX, a company in China would have different labour costs and so on, so you have to change these costs to fit your company. If someone can tell me how to attach excel files, I can attach this file.

[JumboShrimp]

Maybe you can attach the same way you attached the picture.  It may not display, but it may be downloadable.

I was also thinking about creating somewhat comprehensive cost model.  I would like to download your spreadsheet with formulas...

[unsaid]

no, it specifically says I can only attach gif, jpg or png files.

[juanchopancho]

upload to yousendit.com and post the link here, or rapidshare.com etc, etc

[unsaid]

http://rapidshare.com/files/409355846/Airwaysim.xls

[unsaid]

I just realised the cost difference between a 753 and a 739 regarding waiting times.
A 753 needs 115 minutes at 1%, when a 739 needs 70 minutes.
When we calculate it as two short routes per day for each plane,
A 753 can travel a total of 3000 nm(1 X 1000 nm trip + 1 X 2000 nm trip).
A 739 can travel a total of 3500 nm(1 X 1500 nm trip + 1 X 2000 nm trip).

When you calculate the price of 1 y seat, you have a difference of 14% in 739's favor.
I will factor in this price difference at the excel sheet.
Any more ideas before I put in 20 more planes?

[JumboShrimp]

Looks like an interesting idea.  You may have up to 6 columns labeleds "stops" and calculate distance the aircraft can travel per day given the speed and  turnaround.

Also, it would be useful to have throughput, meaning pax * miles.

All inclusive costs are probably more tricky.  But pilots * pilot salary, cabin crew * salary can be calculated.

[JumboShrimp]

The question I always wonder about (but have not gone the extra mile to figure out the answer) is this:

Suppose I have an uncontested route being served by 2 Dash-8 Q400.  Is it more economical to serve that route by 1 737-700 or 2 Dash-8 Q400?

I know, kind of heuristically that longer the route, more it favors faster jet with a longer turnaround, but there is a breakeven point where 2 would roughly match.  And, I guess, 1 flight would spend less on slot charges, ground handling.  But it would be interesting to be able to figure out the cost exactly.

[Curse]

It always is the best solution to fly the biggest aircraft. This mainly is because of the huge staff costs one route creates - if it is a Dash8-Q400 or a A380 makes no difference.

[JumboShrimp]

It always is the best solution to fly the biggest aircraft. This mainly is because of the huge staff costs one route creates - if it is a Dash8-Q400 or a A380 makes no difference.

I started to do just that last few months game time.  I started to get some 767-400ER.  It seems like a decent, very under-appreciated plane, hence, not much wait to get them.  But (comperatively) long turnaround puts some limits to "fly the biggest aircraft".  When comparing a small jet, say 737-700 vs. Dash-8, 737 makes up for the longer turnaround in first 100 miles of flight.  767 never does.  So I hesitate to use them on shorter routes, since I don't really know where the breakeven point is.

[Curse]

Example:

Fly from A to B and return with a Dash8-Q400 takes you 2 hours (1% delay turn-around).

A B737 may need for the same route 2:20 because of turn-around.

But you need 3x Dash8-Q400 to get the same pax - what is 6 hours compared to 2:20. Even if the B737 takes 5 hours it would be faster.


Always if there is no competition. If there is competition frequency > all

[JumboShrimp]

This mainly is because of the huge staff costs one route creates - if it is a Dash8-Q400 or a A380 makes no difference.

On this, I was always wondering how ground staff and flights corelate.  Per flight, per destination, per size if the aircraft?  Which of the ground based staff costs are strictly per flight (or route)?

Pilot and cabin crew seems to just depend on how many planes you have, and does not seem to depend on flights.

[JumboShrimp]

I made a quick spreadsheets comparing just the flight crew cost (pilots and cabin crew) of 737-900 vs. 767-400ER.  The columns are flight time in hours - approximated, since their speed is approximately the same.  Surprisingly, the breakeven is at around 1 hour flight time.  767 obviously suffers because of longer turnaround.  I approximated turnaround to 1 hr for 737, 2 hrs for 767.  I really should have gone by equal percentage of delay...

[attachment expired]

[Curse]

Pilot and cabin crew seems to just depend on how many planes you have, and does not seem to depend on flights.

You pay for them at the moment the aircraft has one route.

Is this only a very short flight once a week or if the aircraft is 24/7 in the air makes no difference.