= 13.21. Consider the airline overbooking problem discussed in Section 13.6. The spreadsheet model is available on the MS Courseware CD-ROM packaged with the textbook. The Decision Table generated in Section 13.8 (see Figure 13.50) 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 Decision Table 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 OptQuest 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.