Hi Peter,
The cargo calc is the stumbling block to a certain extent unless we have data already from previous route with the same a/c as the cargo is on a sliding scalar for a/c cargo capacity vs distance. I've broached the subject with Konny to see what we can come up with and I've asked if he can put the Post Flight financial summary for income pax/cargo onto the preflight briefing. He is going to try and implement this in a few days so you should be able to do some calcs to see the break-even point for each flight. We'll have to see exactly what info appears.
For the time being the basics are as follows :-
Income from tickets (PAX x Ticketprice )
Fuel cost (Fuel Price x 1.234 x kgs Fuel Bought )
Crew and Catering cost ( PAX x v$5 )
Cargo income (variable v$/100nm x distance x kgs cargo)
Deducting the costs of fuel and crew/catering from the ticket and cargo revenue will give you the
airline income for the flight. If at this point the figure is in profit then bonuses and pilot salary are applied :-
Bonuses as a % of airline income for the flight
1 x sim rate = 20%
2 x sim rate = 10%
4 x sim rate = 5%
8 + sim rate = nil bonus
The bonuses are then added to the airline income and the pilot salary is paid as a percentage of this total and then deducted to give a 'Gross Profit' for the flight. The multiplier is then applied to this Gross Profit figure to give you the final financial outcome for your flight. If the airline income was zero then bonuses would be zero regardless of sim rate used. Likewise, pilot salary would be zero as there were no earnings for the flight.
I've included the 'full' details for info, but the bottom line is that the pax and cargo income added together must be greater than the expenses of fuel and crew/catering costs
On your particular flight the pax/cargo revenue was v$55506 + v$27018 = v$82524
Crew and catering costs were v$870. Taking v$870 from v$82524 leaves you v$81654 to buy fuel to keep you at break even.
If you'd have bought 49014kgs fuel it would have cost v$81652. Add this to the crew catering costs gives you a v$2 airline income for the flight plus a bonus of 40cents less pilot salary of 36cents (v$2.4 x 15%) to give v$2 Gross profit.
Using the multiplier of 300 you'd have made v$600.
If the fuel pickup had been 48000kgs then the figures improve quite substantially :-
55506 + 27018 = 82524 Revenue
870 + 79963 = 80833 costs
Airline income = 82524 - 80833 = 1691v$
Bonus 1691 x 20% = 338v$
Pilot salary (15% of 1691 + 338) = -304v$
Gross profit for flight 1691 + 338 - 304 = 1725 v$
Multiplier 300 x 1725 = 517,500v$
The 'unknown' variable is the cargo income that we get for a flight. If Konny comes up with what he's promised, we'll shortly know upfront what we can expect as a cargo and pax income so some fine tuning can be done to the fuel loads to accurately predict fiancial outcomes for our flights.
I'm sure that you will have read and digested all that and I'll be testing you on it later
. As I said earlier, it's swings and roundabouts but you can make a difference with a little bit of planning. I guess the headwinds that you were expecting didn't turn up.
.
Rgds
John
Btw.. I try and leave between 500kg and a 1000kg in my Argosy's.. depending on where I'm going next and how much the fuel is there. Four ton is a gift!! 