Results 1 to 2 of 2

Math Help - Airline Ticket Price Problem - 3 variables.

  1. #1
    Newbie
    Joined
    Sep 2012
    From
    New Zealand
    Posts
    2

    Airline Ticket Price Problem - 3 variables.

    So my problem is this:

    I have to determine the best pricing structure for a 'simulated airline'.
    There are 3 types of ticket;
    Business Class seats @ $160 each, Premium Economy Class seats @ $125 each, and Super Saver Class seats @ $75 each.
    A MINimum of 10% of the seats must be Business Class;
    A MINimum of 50% must be Premium Economy Class tickets;
    A MAXimum of 20% can be Super Saver Class tickets.
    Of the Business Class seats it is predicted that only 52% will be sold, 65% of the Premium Economy Class tickets will be sold, and 76% of the Super Saver Class tickets will sell.

    So the question is this... if I only have 108 seats on the aircraft what will be the best breakdown of tickets to get the maximum return given the restrictions on seat type allocations, expected sale %'s and different ticket costs?

    So far I have only managed to work out an Excel based solution, using trial and error to work out the best results... but there must be a mathematical way of doing/illustrating this.

    Any help gratefully received.
    Thanks from New Zealand!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    May 2010
    Posts
    1,027
    Thanks
    28

    Re: Airline Ticket Price Problem - 3 variables.

    first up, allocate the seats you have no choice about:
    at least 10.8 (round up to 11) seats must be business
    at least 54 seats must be premium
    at 21.6 (round up to 22) must be super saver

    So we have allocated 11 + 54 + 22 = 87 seats so far.

    How to allocate the remaining 21 seats
    The expected revenue from an extra business seat is 52% * 160 = $83.20
    The expected revenue from an extra premium seat is 65% * 125 = $81.25
    The expected revenue from an extra super saver seat is 76% * 75 = $57.00

    So, assuming you want to maximise expected revenue, how do you think the remaining seats should be allocated?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 1
    Last Post: January 12th 2012, 09:34 PM
  2. Replies: 0
    Last Post: August 12th 2011, 05:09 PM
  3. Lottery Ticket Word Problem
    Posted in the Advanced Statistics Forum
    Replies: 7
    Last Post: October 4th 2009, 05:33 PM
  4. Airline overbooking problem
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: August 2nd 2009, 04:44 PM
  5. Airline Report Problem
    Posted in the Statistics Forum
    Replies: 8
    Last Post: April 19th 2009, 08:50 PM

Search Tags


/mathhelpforum @mathhelpforum