Consider a three-city airline network from A to C with a stop at B. There are two
Question:
Consider a three-city airline network from A to C with a stop at B. There are two classes per itinerary, with the fares and expected ODF demands shown in the following table:
The airline has 100 seats on the leg from A to B and 120 seats on the leg from B to C.
a) Suppose that the airline company wants to use the deterministic linear programming method to determine the partitioned booking limits. Formulate this problem as a linear program, and solve it using Excel.
b) Suppose that the airline company wants to use the virtual nesting method to determine the nested booking limits. The manager decides that each leg (A to B, and B to C) has three buckets, defined as follows: Bucket 1: Net leg fares > 275 Bucket 2: Net leg fares between 200 and 275 Bucket 3: Net leg fares < 200 Please use the sensitivity report from part a) to find the opportunity cost for each leg’s seat, then calculate the net leg fares and index buckets.
c) Given the indexed buckets for the leg from A to B in part b), use EMSR-b to find the nested booking limits for this leg. Assume all ODF’s demands follow a normal distribution with a standard deviation equal to 5. (Hint: the fair price for the bucket is the mean demand weighted average net leg fare.)
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg