CrotchHugger

Competition Summary

Passenger Demand and Market Share

As far as I understand, the main factors that affect how passengers choose their airlines when a route is over supplied are:

1. Price
2. Frequency
3. Route Reputation

These assumptions are based on Yuxi's responses in this post http://www.airline-e...oute-reputation

Now, if we apply these assumptions to the practical example as shown in the images, Airline B (red) should get the largest share in the route. Since they have the highest reputation and frequency, while having the same price as the other competitors. The supply offered by Airline B also exceeds the demand of the route.

However, the truth is Airline A is having the largest share in the route. 5% is not much, but the issue is I see no reason at all for that to be the case. Is this an error in the route reputation display? Is there a random factor that is in play behind the scenes? Is Airline A supported by the Illuminati?

*Honestly, why bother at all if there is literally nothing you can do to win over the passengers as a non budget airlines?*

Firstly, this has nothing to do with $1 tickets to get unlimited connecting pax.

Consider the following scenario: 

Have a hub in airport A.

Open a route A to B, oversupply it by a lot, making most of the pax blue.

Open a route A to C, oversupply it as well.

Now the question, would route A->B now has less blue pax because they are used in route A->C? Or are they completely separate and draw from different pools of connecting pax?

AE Aircraft Efficiency Spreadsheet (Fabulous Ver.)
AE Aircraft Efficiency Spreadsheet (Boring Ver.)
 
Greetings all.

Posting a spread as my first post will probably mark myself as a meta-gamer. But hey, real airlines have experts in the field calculating profitability in a far greater scale than this.  I applaud those who role-play as real airlines, but this is necessary for airlines to make an informed choice on their aircraft rather than just out of familiarity with popular aircrafts. We can't have Boeing and Airbus monopolise the market when Comac offers great price and fuel efficiency, just because of protectionism, could we?
 
It is currently still far from complete and would greatly benefit from any contributions. It is very possible that my formulas are incorrect, do PM me or post here if that is the case. Instructions and descriptions are included in the notes of the sheet.

 
I hope that, with the help of the community, this could truly become the definitive aircraft efficiency reference sheet.

With 355 aircraft in the spreadsheet. The spreadsheet is now considered complete. It might still contain input errors and incorrect formulas, but I have taken every effort to reduce that to a minimum. Special thanks to a kind AE user who gave their valuable feedback that contributed to the correction of a core formula.

 
 
As of March 10, the spreadsheet is fully protected. If you wish to sort or otherwise edit the spreadsheet, make a copy by going File>Make a copy...
 
Considerations:

• The efficiency does not account for turn time, which can be huge on short hauls.
• Supposedly, aircraft have varying speed and fuel flow throughout the flight during ascent and descent. This is not calculated.
• Depreciation can affect the cost by varying degrees. Because of this, I have no plans to make a rate of return calculation for purchased planes. I welcome anyone to take up the challenge though.
• Costly planes with large passenger capacity can be useful due to limited gates and its leasing cost.

Solvable unsolved Issues:

• Winglet variants are hard to include due to it not being on the "browse aircraft" menu.
• The increase of maintenance as aircraft ages is unknown.