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

ReservationsToAccept 150 155 160 165 170 175 180 185 190 195 200 Mean S5.789 $6,896 $7,968 $9,001 $9.982 $10,880 11,592 $11,912 $11.712 $11.124 $10,395 6 I0 12