"6. Mikel Nordsem is the front office manager at the Plaza Hotel. The hotel has 950 rooms and its market consists primarily of business travelers. Mikel has determined to do a better job of forecasting the number of rooms he will sell and occupancy percentage he will have each day. With a better forecast, he reasons that he can have the appropriate number of staff on hand to quickly serve all the guests who arrive. Complete the following forecast, and then answer Mikel's important questions. Date: May 1Day: Wednesday Total rooms available 950 Outoforder rooms 10 Net Availability Stayovers 104 Reservations (Arrivals) 376 Rooms Sold or Reserved Forecasted Adjustments: Noshows 95 Early departures 19 Overstays 15 Total Forecast Sold or Reserved After Adjustments Occupancy Forecast % What is Mikel's net availability for rooms on May 1? How many rooms sold or reserved will Mikel have? After he makes adjustments for noshows, early departures, and overstays, what will be Mikel's total forecast in rooms? Based on his calculations, what is Mikel's occupancy forecast for May 1?

use Excel/table to extrapolate the forecast to 7 days after Wednesday)"