The process that will be used is to present the forecast from the first week to explain and demonstrate how a forecast is prepared and how it is used. Information will then be given for the second week that will include changes from the first week that increase the volume and revenue or decrease the volume and revenue.

You are required to prepare the second week forecast.

The third week will be presented again as an example with changes to the first week forecast, either a busier or a slower week.

You are required to prepare the third week forecast.

The fourth week forecast will be a quiz where you are expected to prepare the fourth week forecast.

This process will be followed for room forecasts, restaurant forecasts, and room service forecasts.

Rooms Sold Forecasting Workshot-600 Rooms Wok - 1. Period Ost Plast Saturday Sunday Monday Tiesniedres The 300 400 100 180 150 10 10 130 330 150 2.100 MARKET SEGMENT TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations GROUP ROOMS Dette Groups Tentative Prospective Groups Total Group Reservations TOTAL ROOMS SOLD OCCUPANCY PERCENTAGE Arrivals Check-ins Departures/Check-outs 20 20 898 898 $ $ $ 30 90 300 190 150 420 500 22 12100 150 140 120 50 000 600 Se 510 250 2.700 100% 280 1090 100 140 200 31.7% 50 160 25.0% 100 320 50 Room Revenge Forecasting Worksheet 1W 1 Period Saturday Sunday Monday ay hesday 330 390 The forecast for each of these segments is prepared in different ways. The transient confirmed or guaranteed room reservations are generated from the Yield Management or Demand Tracking system of the hotel for each day. The Hotel Reservation Manager then projects or forecasts the number of additional reservations expected between the current date and the day of arrival, including same-day walk-ins, and adds that to the confirmed reservations to forecast the total rooms sold for the day. The group rooms forecast is generated by the group booking report, which provides the number of definite group rooms booked per day. The Director of Sales then determines the number of tentative or prospective group rooms that are in negotiations that have a high probability of becoming definites. Adding total tentatives or to-be-booked to total definites will result in the forecasted group rooms sold for the week. When the total rooms sold forecast for the week is completed, average room rates are projected for each segment for each day. Total room revenues are then calculated by multiplying rooms sold times the average room rate for each day for each segment and then adding them together to get the total rooms revenue forecast by day for the next week. The weekly forecast will include rooms sold, occupancy percentage, average room rate, and total room revenue for each day of the week and for the total week. The hotel selling strategy team then reviews and approves the weekly forecast. The steps to prepare a room forecast are as follows: 1. Identify confirmed transient reservations and definite group reservations for each day (DOA) from the yield management report and group rooms report. 2. Project the number of expected additional transient reservations and tentative group reservations for each day. 3. Calculate the daily average room rate for transient and for group rooms sold. Calculate the daily room revenue for transient and group rooms by multiplying the daily number of rooms sold by the average room rate for each segment. 5. Add the daily rooms sold for each day of the week to get the total rooms sold for the week. the total daily revenue for each day of the week to get the total room revenue for the week. 7. Calculate the average weekly room rate by dividing total room revenue for the week by total rooms sold for the week. 8. Calculate the daily and weekly occupancy percentage by dividing daily rooms sold by total hotel rooms. 9. Double-check the amounts by adding the daily rooms sold or revenue across and comparing it by adding the transient and group market segment down to get the same total rooms sold for the week and the total room revenue for the week. Apply this process to the following weekly problem sets to calculate total weekly room revenues. Following are worksheets and weekly forecasts. 160 $ 110 $17.600 130 $ 110 $14.300 440 $ 145 563.800 200 $ 110 2.100 $ 133.55 $280.450 $42.900 $65.250 554,600 MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 150 30 $ 100 $ 3.000 20 $ 100 $ 2,000 90 $ 120 $10.800 50 $ 100 $ 5.000 600 $120.00 $72.050 $18.750 $17.500 $15.000 510 190 317 $108.42 $20.600 420 70.0% 4. 150 25.0 $108.62 $16.300 500 100% $140.00 $84.000 580 96.7 $140.17 $81300 250 2.700 54.3% $108.00 $130.56 $27.000 $352.500 $53.700 50.600 6. Add the total Rooms Sold Forecasting Workshot-600 Rooms Wok - 1. Period Ost Plast Saturday Sunday Monday Tiesniedres The 300 400 100 180 150 10 10 130 330 150 2.100 MARKET SEGMENT TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations GROUP ROOMS Dette Groups Tentative Prospective Groups Total Group Reservations TOTAL ROOMS SOLD OCCUPANCY PERCENTAGE Arrivals Check-ins Departures/Check-outs 20 20 898 898 $ $ $ 30 90 300 190 150 420 500 22 12100 150 140 120 50 000 600 Se 510 250 2.700 100% 280 1090 100 140 200 31.7% 50 160 25.0% 100 320 50 Room Revenge Forecasting Worksheet 1W 1 Period Saturday Sunday Monday ay hesday 330 390 The forecast for each of these segments is prepared in different ways. The transient confirmed or guaranteed room reservations are generated from the Yield Management or Demand Tracking system of the hotel for each day. The Hotel Reservation Manager then projects or forecasts the number of additional reservations expected between the current date and the day of arrival, including same-day walk-ins, and adds that to the confirmed reservations to forecast the total rooms sold for the day. The group rooms forecast is generated by the group booking report, which provides the number of definite group rooms booked per day. The Director of Sales then determines the number of tentative or prospective group rooms that are in negotiations that have a high probability of becoming definites. Adding total tentatives or to-be-booked to total definites will result in the forecasted group rooms sold for the week. When the total rooms sold forecast for the week is completed, average room rates are projected for each segment for each day. Total room revenues are then calculated by multiplying rooms sold times the average room rate for each day for each segment and then adding them together to get the total rooms revenue forecast by day for the next week. The weekly forecast will include rooms sold, occupancy percentage, average room rate, and total room revenue for each day of the week and for the total week. The hotel selling strategy team then reviews and approves the weekly forecast. The steps to prepare a room forecast are as follows: 1. Identify confirmed transient reservations and definite group reservations for each day (DOA) from the yield management report and group rooms report. 2. Project the number of expected additional transient reservations and tentative group reservations for each day. 3. Calculate the daily average room rate for transient and for group rooms sold. Calculate the daily room revenue for transient and group rooms by multiplying the daily number of rooms sold by the average room rate for each segment. 5. Add the daily rooms sold for each day of the week to get the total rooms sold for the week. the total daily revenue for each day of the week to get the total room revenue for the week. 7. Calculate the average weekly room rate by dividing total room revenue for the week by total rooms sold for the week. 8. Calculate the daily and weekly occupancy percentage by dividing daily rooms sold by total hotel rooms. 9. Double-check the amounts by adding the daily rooms sold or revenue across and comparing it by adding the transient and group market segment down to get the same total rooms sold for the week and the total room revenue for the week. Apply this process to the following weekly problem sets to calculate total weekly room revenues. Following are worksheets and weekly forecasts. 160 $ 110 $17.600 130 $ 110 $14.300 440 $ 145 563.800 200 $ 110 2.100 $ 133.55 $280.450 $42.900 $65.250 554,600 MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 150 30 $ 100 $ 3.000 20 $ 100 $ 2,000 90 $ 120 $10.800 50 $ 100 $ 5.000 600 $120.00 $72.050 $18.750 $17.500 $15.000 510 190 317 $108.42 $20.600 420 70.0% 4. 150 25.0 $108.62 $16.300 500 100% $140.00 $84.000 580 96.7 $140.17 $81300 250 2.700 54.3% $108.00 $130.56 $27.000 $352.500 $53.700 50.600 6. Add the total