The airlines value tree
Airline value is yield times load factor against a largely fixed cost of flying. The seat expires at departure, which makes every driver in this tree a question about timing.
01 The same tree, this industry
Where the money is made and lost here
The structure does not change: value is profit plus how well that profit becomes cash, profit is revenue minus cost, and revenue is price times quantity. What changes is which drivers sit underneath each branch, and which system holds them. If you have not read the general version, start with the Enterprise Value Tree and come back.
This is the most perishable tree in the set. The product ceases to exist at a known moment, so price is a function of time-to-departure, and the cost of an empty seat is the entire revenue it would have carried. Almost nothing here can be corrected after the fact.
Every driver below names the metric it lands on. Follow one and you get its formula, the system the number lives in, and the ways it is commonly misread.
02 Price
What decides the price you actually get
Yield by booking curve
The same seat has dozens of prices depending on when it sells. Revenue management is pricing, executed hourly.
Average net price net_revenue ÷ unitsPriceFare mix and cabin
What proportion of the cabin sells at which fare class, which decides RASK more than the headline fare does.
Price realisation net_revenue ÷ list_revenuePriceAncillary revenue
Bags, seats, boarding and everything else — high margin, and increasingly the difference between profit and loss.
Attach rate orders_containing_the_attached_item ÷ eligible_ordersPriceDistribution channel cost
Direct against GDS and agency, where a few points of channel mix is a real margin lever.
Cost to serve (delivery + service + returns + order_handling) ÷ customers or ordersPriceCorporate and interline contracts
Negotiated volume at negotiated rates, settled long after the flight.
Price realisation net_revenue ÷ list_revenuePriceDisruption compensation
A regulatory price on operational failure, incurred per passenger and rarely attributed to the route that caused it.
Contribution margin (net_revenue − variable_cost) ÷ net_revenue03 Quantity
What decides how much you sell
Load factor
The proportion of capacity sold. Half of the revenue equation and the more visible half.
Capacity utilisation actual_output ÷ practical_capacityVolumeCapacity deployed
Seats flown by route and season — a decision made months ahead against demand that moves weekly.
Capacity utilisation actual_output ÷ practical_capacityVolumeNetwork and route mix
Which routes get the aircraft, which is the airline version of allocating the constraint.
Contribution margin (net_revenue − variable_cost) ÷ net_revenueVolumeOn-time performance
A service metric that feeds directly into repeat booking and into cost through disruption.
On time in full orders_delivered_on_time_and_complete ÷ total_ordersVolumeLoyalty and repeat booking
The base that survives a price war, and the data asset most airlines under-use.
Purchase frequency orders_in_period ÷ active_customersVolumeAircraft utilisation
Block hours per aircraft per day: the productivity of the most expensive asset you own.
Capacity utilisation actual_output ÷ practical_capacity04 Cost
What it takes to operate
Fuel and burn
The largest variable line, moved by price, by route and by how the aircraft is actually flown.
Energy per unit energy_consumed_kWh ÷ units_producedCostCrew
Rostered against a schedule, constrained by regulation, and expensive the moment the schedule breaks.
Cost per hire (external_cost + internal_cost) ÷ hiresCostMaintenance
Planned and unplanned, where an AOG event costs far more than the repair itself.
Mean time to repair total_downtime_hours ÷ number_of_failuresCostAirport and handling charges
Fixed per turn, which makes turnaround time a direct cost driver.
Cost to serve (delivery + service + returns + order_handling) ÷ customers or ordersCostDisruption cost
Rebooking, accommodation and compensation — concentrated in a few routes and a few days.
Returns rate units_returned ÷ units_soldCostDistribution cost
Commission and GDS fees per booking, varying by channel and by market.
Customer acquisition cost (sales_cost + marketing_cost) ÷ new_customers_won05 Cash
Where the cash actually sits
Forward bookings
Cash received before the flight: negative working capital, and a liability until the seat is flown.
Cash conversion cycle dso + dio − dpoCashFleet ownership and leases
The capital structure decision that shapes the whole cost base.
Net debt to EBITDA (total_debt − cash_and_equivalents) ÷ EBITDACashMaintenance reserves
Cash committed against future events on a schedule set by hours flown.
Capex intensity capital_expenditure ÷ net_revenueCashFuel hedging
Margin calls and settlement timing, which can dominate short-term cash regardless of trading.
Free cash flow operating_cash_flow − capital_expenditureCashSpares and rotables
High-value inventory positioned across stations, easy to duplicate and hard to see.
Days inventory outstanding (inventory_value ÷ cogs) × days_in_periodCashReturn on capital
The measure that judges fleet and network decisions against what they consumed.
Return on capital employed EBIT ÷ (total_assets − current_liabilities)06 Where the numbers live
The systems behind the branches
A value tree is only usable once each box maps to a system and a record. These are the six that matter most in airlines: what each one is actually for, the records inside it the tree depends on, and which branch it feeds.
| System | What it holds | Key records | Feeds |
|---|---|---|---|
| PSS / reservations | Bookings, passengers, fares and every change made to them — the commercial record of the flight. | Booking, Passenger, Fare, Segment, Ancillary | Price, quantity, cash |
| Revenue management | Forecast demand, availability and the fare classes released against it, hour by hour. | Forecast, Bid price, Class availability, Departure | Price, quantity |
| Flight operations | What actually flew: times, delays, fuel burn and the crew who operated it. | Flight leg, Delay code, Fuel record, Crew pairing | Cost, quantity |
| MRO / engineering | Aircraft condition, work packages and the AOG events that break the schedule. | Aircraft, Work package, Component, AOG event | Cost, cash |
| Crew management | Rosters, legality, standby and the disruption recovery that consumes them. | Crew member, Roster, Duty, Standby assignment | Cost |
| Loyalty | The member record, the earn and burn, and the identity that ties bookings together over time. | Member, Tier, Accrual, Redemption | Quantity, price |
Almost every hard question in airlines needs two of these joined. That join — not the calculation — is the work.
07 Where it leaks
Value lost between two systems
These are the losses that no single system can see, because the evidence is split across two of them. Each one is a real number that stays invisible until the join exists — which is why the tree is an integration exercise before it is an analysis one.
| Where value leaks | Why it happens | The join that finds it |
|---|---|---|
| Revenue accounting learns after revenue management decides | RM optimises against forecast; revenue accounting settles weeks later. The feedback loop that would improve the forecast is a manual reconciliation. | Join settled revenue by fare class back to the RM forecast that released it |
| Disruption cost never attributed to the route | Compensation, accommodation and rebooking are absorbed centrally while route profitability is judged on schedule revenue and planned cost. | Join delay codes and disruption spend to the flight leg and route P&L |
| Ancillary revenue measured in total, not by channel | Bag and seat revenue vary hugely by channel, market and fare type, and the aggregate hides which combination is worth promoting. | Join ancillary purchases to booking channel, fare class and passenger segment |
| The passenger who is not a member | The same traveller books direct, through an agency and as a corporate passenger, so frequency and lifetime value are computed on fragments. | Resolve passenger identity across PSS, loyalty and corporate contracts |
| Fuel burn against the plan that assumed it | Actual burn is captured per leg; the plan lives in scheduling. Route economics use planned burn long after actual burn diverged. | Join actual fuel records by leg to planned burn and route costing |
08 Worked example
Full flights, thin margin
Load factor rose two points and operating margin fell. The tree separates it: the load was bought with fare mix, ancillary attachment fell as the direct channel share dropped, and disruption on two routes cost more than the additional passengers earned — a cost absorbed centrally and never charged to the route that caused it.
| Component | Effect | What sits behind it |
|---|---|---|
| Load factor | +€3.2m | Two points, largely in the lowest fare classes |
| Fare mix | −€2.6m | The load was bought, not won |
| Ancillary attachment | −€0.9m | Channel mix moved away from direct |
| Fuel | −€0.7m | Burn above plan on two route groups |
| Disruption | −€1.4m | Concentrated in two routes over eleven days |
| Net | −€2.4m | Fuller aircraft, worse economics |
Illustrative figures, shown to demonstrate the split. The point is the shape of the walk, not the numbers — on your own data the same bridge is built from your ledger.
09 Diagnostics
Six questions to ask in airlines
Ask them of your own team before anyone asks them of you. In most organisations at least two of these cannot be answered without a manual exercise, and those two are the plan.
- Can you produce route profitability including disruption cost, or only planned cost?
- Does revenue management see settled revenue by fare class, and how quickly?
- What is ancillary revenue per passenger by channel, and which combination is growing?
- Can you tie a passenger's bookings together across direct, agency and corporate channels?
- When an aircraft goes AOG, can you value the disruption in contribution rather than in maintenance cost?
- Is aircraft utilisation limited by demand, by crew, or by maintenance — and does one report show all three?
10 The metrics behind it
Definitions for every box
11 Questions
Frequently asked
Why is timing the defining feature of this tree?
Because the product expires. A seat unsold at departure is worth nothing and cannot be inventoried, so every pricing and capacity decision is made against a countdown rather than against a market in general.
What is the most valuable join in an airline?
Flight operations to route profitability. Delay codes, fuel records and disruption spend all exist; joining them to the route P&L is what turns operational data into a network decision.
How should ancillary revenue be governed?
Per passenger, by channel and fare type, with the same discipline as the fare itself. Reported as a total it grows without anyone knowing which change caused it.
Does this tree fit a cargo or charter operation?
The cost and cash branches transfer almost unchanged. The quantity branch changes: load factor becomes weight and volume utilisation, and the booking curve is replaced by contract and spot mix.
See this tree on your own data
Connect the systems above, define each box once, and the tree stops being a slide.