- Joined
- Aug 27, 2004
- Posts
- 17,746
- Qantas
- LT Gold
- Virgin
- Red
- Oneworld
- Sapphire
While I was bored this afternoon (supposed to be studying for an exam next week), my mind drifted to wondering just how much of the fuel costs for a flight are actually covered by the fuel surcharge. So using some QF examples, I plugged some assumptions and some facts into a speadsheet for some interesting results.
Obviously the numbers are affected by numerous factors, including the route flown (affects the fuel surcharge revenue, fuel burn etc), the aircraft type used (number of passengers, fuel burn rate etc) and the actual cost of fuel. So here are some of my assumptions used in my calculations:
So here is what I found:
So from this it can be seen that for some short-haul domestic services, QF is possibly recovering its entire fuel bill for the flight from the fuel surcharges. But for some long-haul flights it is well short of recovering the full amount.
But if we assume that the price is Jet fuel varies in a similar manner to petrol prices with the movement in crude oil prices, by my estimates petrol prices have risen around 30% in the time since the airline's started to apply fuel surcharges. So it would be reasonable to expect that on average the fuel surcharge should cover about 30% of the cost of the fuel. As can be seen from the last column, some missions are below this mark, but many are significantly above it.
And we must remember that this is a very simple analysis and does not consider things like hedging etc.
If anyone sees and glaring errors in my assumptions or calculations, please let me know.
Obviously the numbers are affected by numerous factors, including the route flown (affects the fuel surcharge revenue, fuel burn etc), the aircraft type used (number of passengers, fuel burn rate etc) and the actual cost of fuel. So here are some of my assumptions used in my calculations:
- Jet fuel cost is about $1.25/kg. Fuel burn is usually calculated in weight/hour so I have used kg for fuel costs, which would relate to about $1/litre with a specific gravity of 0.8 for Jet Fuel.
- Fuel burn is more or less proportional to aircraft weight. Using the baseline of a fully loaded 747-400ER burning 29,000lb/hr (13,154kg/hr), fuel burn was estimated based on an average mission weight and that burn rate. This assumes modern aircraft burn fuel at about the same rate per weight of the aircraft. I am assured by a 747 captain that this is a reasonable assumption.
- The aircraft is operating with an average 80% load factor.
So here is what I found:
Code:
Route AC Type Surcharge Pax Revenue Time Avg Weight Fuel (Kg) Fuel Cost Difference % Cover
BNE-SYD 737-800 $ 33.20 134 $ 4,449 1 155,000 2,241 $ 2,801 -$ 1,648 159%
MEL-SYD 767-300 $ 33.20 200 $ 6,640 1 290,000 4,192 $ 5,240 -$ 1,400 127%
SYD-PER 737-800 $ 33.20 134 $ 4,449 4 164,000 9,483 $ 11,853 $ 7,405 38%
SYD-PER 747-300 $ 33.20 360 $11,952 4 720,000 41,631 $ 52,039 $ 40,087 23%
SYD-AKL 767-300 $ 62.00 200 $12,400 3 330,000 14,311 $ 17,888 $ 5,488 69%
BNE-AKL 737-800 $ 62.00 134 $ 8,308 3 160,000 6,939 $ 8,673 $ 365 96%
MEL-AKL 747-400 $ 62.00 330 $20,460 3.5 650,000 32,886 $ 41,107 $ 20,647 50%
SYD-LAX 747-400 $135.00 274 $36,990 13.5 710,000 138,554 $173,192 $136,202 21%
BNE-SIN A330-300 $107.00 238 $25,466 7.8 410,000 46,228 $ 57,785 $ 32,319 44%
MEL-SIN 747-400 $107.00 303 $32,421 7.3 700,000 73,867 $ 92,333 $ 59,912 35%
BNE-HKG 767-300 $ 76.54 200 $15,308 8.75 340,000 43,004 $ 53,756 $ 38,448 28%
But if we assume that the price is Jet fuel varies in a similar manner to petrol prices with the movement in crude oil prices, by my estimates petrol prices have risen around 30% in the time since the airline's started to apply fuel surcharges. So it would be reasonable to expect that on average the fuel surcharge should cover about 30% of the cost of the fuel. As can be seen from the last column, some missions are below this mark, but many are significantly above it.
And we must remember that this is a very simple analysis and does not consider things like hedging etc.
If anyone sees and glaring errors in my assumptions or calculations, please let me know.