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.
Any help gratefully received.
Thanks from New Zealand!