Question: Please do not use chatgpt.. please mathematically explain your answer. Granite State Airlines serves the route between New York City and Portsmouth with one flight

Please do not use chatgpt.. please mathematically explain your answer.
Granite State Airlines serves the route between New York City and Portsmouth with
one flight per day on a 100-seat aircraft. The one-way fare for low-fare tickets is $100 and a one-way fare for high-fare tickets is $150. Low-fare tickets can be booked up until one week in advance and all low-fare passengers book before all high-fare passengers. The airline estimates that the high-fare demand is normally distributed with a mean of 56 passengers and a standard deviation of 23, while low-fare-fare demand is normally distributed with a mean of 88 passengers and a standard deviation of 44. Normal random variables can take negative
values, but we will ignore this possibility.
(a) What is the optimal booking limit to impose on the low-fare demand? You can directly use the result that we derived in class and keep the booking limit and all demands fractional.
(b) The airline has been setting a booking limit of 35 on low-fare demand. What is the
expected revenue per flight under this booking limit? Use simulation to answer this question. In Excel, the function =norminv(rand(),\mu ,\sigma ) returns a sample from the normal distribution with mean \mu and standard deviation \sigma . You can use =max(norminv(rand(),56,23),0) and=max(norminv(rand(),88,44),0) to generate samples of high-fare and low-fare demands. Let D1 and D2 be the samples of low-fare and high-fare demands. The total revenue with a booking limit of 35 is given by 100\times min{35, D1}+150\times min{100 min{35, D1}, D2}. This computation gives one sample of the total revenue corresponding to a given sample of (D1, D2).
You can generate many samples of D1 and D2 and take the average of the total revenues over many samples. You can place all of the preceding formulas in one row of an Excel spreadsheet and copy these lines for many rows to generate many samples.
(c) What is the total expected revenue gain from the optimal booking limit over the original booking limit of 35? Continue using simulation as in Part (b) to estimate the total expected revenue from the optimal booking limit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!