ProfessorCarlinClarke.com
  • Home
  • AVSC 1010: Survey of Aviation
  • AVSC 1050: Aviation Administration
  • AVSC 2120: Personal Finance
  • AVSC 2150: Air Transportation Mgmt
  • AVSC 3060: Airline Management
  • AVSC 3110: Aviation Security
  • AVSC 410G: Ethical Issues in Aviation

Fleet Assignment - Part 2

11/15/2012

3 Comments

 

Spill and Contribution

Wolverine Airlines has provided the following suggested fleetings for markets A-B, B-C, and A-C in Tables 1-4. Use the information in the tables to calculate the spill costs associated with each fleeting. Calculate the operational cost, spill cost and contribution for each fleeting. 
Picture
Step 1: Pull the information out of the tables so you can see the whole picture:
 
We have 2 flights: Flight 1 and Flight 2
Flight 1: 100 pax traveling, fares per are $250.00
Flight 2: 150 pax traveling, fares per are $300.00
Flight 1 & 2 combined: 125 pax traveling, fares per are $450.00

We have 4 Fleets:
Fleet 1: operates A320 on flight 1 and 2
Fleet 2: operates A320 on flight 1, B757 on flight 2
Etc.

First we need to calculate the operating costs:

Fleet 1, which operates on both flights costs: 10,000 for flight 1 and 15,000 for flight 2. Add those to total the operating costs.

Do the same for fleets 2-4.

To calculate the Spill Cost we are looking for the revenue lost when the flight cannot accommodate the passenger demand. As the Spill figures are given, we only need to calculate the loss:

So for Fleet 1, 75 pax traveling A-C are spilled. Take the fare cost of that leg ($450) and multiply it by 75 =    then do the same for leg B-C at 50 pax spilled (50 x 300) and add the figures together = $48,750.00

 
Contribution is the profit, or maximum potential revenue, minus the spill cost and operating costs....

So for Fleet 1 again, to find the max potential revenue we need to multiply the number of passengers booked on all flights by the fares:

A-B leg = 100 pax, no spill x $250 = $25,000
A-C leg = 125 pax booked – 75 pax spill = 50 pax total x $450 fare = $22,500
B-C leg = 150 pax – 50 pax spill = 100 pax total x $300 fare = $30,000
Total max potential revenue is then: $22,500 + $30,000 + $25,000 = $77,550.

Add Spill cost and operating costs for Fleet 1 = $25,000 + $48,750 = $73,750.00

Now subtract Spill and operating costs from the max potential revenue =  $3,750.00

 
…. Okay, now it's your turn. ;)
3 Comments
payday loans link
10/12/2013 11:23:08 am

If you paint in your mind a picture of bright and happy expectations, you put yourself into a condition conducive to your goal.

Reply
Confused
5/27/2016 11:13:06 am

Why are you subtracting the spill twice? You subtract it when calculating the total revenue and then again when subtracting operating costs.

Reply
Carlin
8/16/2016 08:10:08 am

Hi Confused,

Sorry for the lengthy delay... I have been away for the summer.

I think where you might be getting confused is that we are dealing with 2 sets of equations, sort of.

To find the Contribution we have to know our Profit and what our expenses (operations) and losses (spill) are and compare it against our actual revenue.

So, we add the expenses and losses together and then subtract that from the MPR.

the spill is being ADDED to the operations cost as total expenses and then subtracted by the MPR.

So, spill is kind of all over the place here, but the figures are being added and subtracted appropriately.

Reply



Leave a Reply.

    Author

    Carlin Clarke, MCA
    Adjunct Faculty
    Utah Valley University
    College of Aviation and Public Services

    Archives

    November 2012

    Categories

    All
    Fleet Assignment Pt. 1
    Fleet Assignment Pt. 2
    Revenue Management Pt. 1
    Revenue Management Pt. 2
    Spill And Contribution

    RSS Feed

Powered by Create your own unique website with customizable templates.