airline ticketing problem - 3 variables.

• Sep 21st 2012, 11:30 PM
BuddhsNZ
airline ticketing problem - 3 variables.
Apologies if I have posted this in the wrong forum... open to suggestions if you think it should be moved elsewhere. Thanks.

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.