Question

Consider the airline overbooking problem discussed in Sec. 28.5. The spreadsheet model is available on this website. The parameter analysis report generated in Sec. 28.7 (see Fig. 28.32) for this problem suggests that 185 is the best number of reservations to accept in order to maximize profit, but the only numbers considered were a multiple of five.
(a) Refine the search by generating a parameter analysis report for this overbooking problem that considers all integer values for the number of reservations to accept between 180 and 190.
(b) Generate a trend chart for the 11 forecasts considered in part a.
(c) Use ASPE’s Solver to search for the number of reservations to accept that maximizes the airline’s mean profit. Assume that the number of reservations to accept may be any integer value between 150 and 200.
In Figure 28.32


$1.99
Sales0
Views23
Comments0
  • CreatedSeptember 22, 2015
  • Files Included
Post your question
5000