# Question: Consider the airline overbooking problem discussed in Sec 28 5 The

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

(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

## Relevant Questions

Consider the historical data contained in the Excel File “Sales Data 1” on this website. Use ASPE to fit continuous distributions to these data. (a) Which distribution provides the closest fit to the data? What are the ...Susan is a ticket scalper. She buys tickets for Los Angeles Lakers games before the beginning of the season for $100 each. Since the games all sell out, Susan is able to sell the tickets for $150 on game day. Tickets that ...The leading brewery on the West Coast (labeled A) has hired an OR analyst to analyze its market position. It is particularly concerned about its major competitor (labeled B). The analyst believes that brand switching can be ...Reconsider Prob. 29.6-2. Now suppose that the manufacturer keeps a spare machine that only is used when the primary machine is being repaired. During a repair day, the spare machine has a probability of 0.1 of breaking down, ...Suppose that a communications network transmits binary digits, 0 or 1, where each digit is transmitted 10 times in succession. During each transmission, the probability is 0.995 that the digit entered will be transmitted ...Post your question