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 seat aircraft. The oneway fare for lowfare tickets is $ and a oneway fare for highfare tickets is $ Lowfare tickets can be booked up until one week in advance and all lowfare passengers book before all highfare passengers. The airline estimates that the highfare demand is normally distributed with a mean of passengers and a standard deviation of while lowfarefare demand is normally distributed with a mean of passengers and a standard deviation of Normal random variables can take negative
values, but we will ignore this possibility.
a What is the optimal booking limit to impose on the lowfare 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 on lowfare demand. What is the
expected revenue per flight under this booking limit Use simulation to answer this question. In Excel, the function norminvrandmu sigma returns a sample from the normal distribution with mean mu and standard deviation sigma You can use maxnorminvrand andmaxnorminvrand to generate samples of highfare and lowfare demands. Let D and D be the samples of lowfare and highfare demands. The total revenue with a booking limit of is given by times min Dtimes min min D D This computation gives one sample of the total revenue corresponding to a given sample of D D
You can generate many samples of D and D 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
