Chapter 10. Forecasting A Very important Management Tool 223 This problem set is worth 25 points and can be done individually or in a group. Follow the same steps as in fore asting the second week. Following are the changes to be used in forecasting the third week 1. Begin with the first week rooms sold forecast. All changes will be made to those numbers. 2. Increase the third weeks rooms sold forecast as follows: A. Increase weekday transient room reservations 30 per day B. Increase weekday transient pickup reservations 15 per day. C. Increase weekend transient room reservations 20 per day. D. Increase weekend transient pickup reservations 10 per day 3. Third week group room blocks are as follows: Problem Set 2 25 Points Week 3 of Period 1 Another Busy Week x 297 Sat Sun Mon Tue Wed Thurs Fri Total #1 20 40 Definite group 40 40 140 30 30 20 #2 #1 80 140 40 40 40 20 Tentative group 70 70 40 #2 180 4. Complete the total rooms sold forecasting worksheet. 5. Enter the Week 3 rooms sold from the rooms sold worksheet onto the Week 3 room revenue forecasting worksheet. 6. Use the same daily average rates as Week 1 for both the transient and group rooms sold. 7. Calculate the total room revenue by day for Week 3 and complete the Week 3 room revenue forecasting worksheet the daily and weekly totals from the room revenue forecasting worksheet. Turn HOONES SOLD FORECASTING WORKSHEET 15. POINT PROBLEM SET WEEK 1 PERIOD Todd Bar Sunday Monday Tuesday Thursday MARKET SEGMENT TRANSANT ROOM New Pickup Team GRUPOS Deep trein Group Tentative Group 1 Tentative G2 Total Group TOTAL ROOM RIRVATIONS OCCUPANCY PIERCINTAGE Checkins Chuck Chats ROOM REVENUE HORECASTING WORKS 25-POINT PROBLEM SET WEEK PERIOD Eriday Saturday Sunday Monday Tuesday Wednesday Thursday Friday. Total MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rexoms Sodd Average Rate Total Group Revenue TOTAL REVENUE Total Room Sold Occupancy Percentage Average Kate Total Rocur Revenue 197 Chapter 10. Forecasting A Very important Management Tool 223 This problem set is worth 25 points and can be done individually or in a group. Follow the same steps as in fore asting the second week. Following are the changes to be used in forecasting the third week 1. Begin with the first week rooms sold forecast. All changes will be made to those numbers. 2. Increase the third weeks rooms sold forecast as follows: A. Increase weekday transient room reservations 30 per day B. Increase weekday transient pickup reservations 15 per day. C. Increase weekend transient room reservations 20 per day. D. Increase weekend transient pickup reservations 10 per day 3. Third week group room blocks are as follows: Problem Set 2 25 Points Week 3 of Period 1 Another Busy Week x 297 Sat Sun Mon Tue Wed Thurs Fri Total #1 20 40 Definite group 40 40 140 30 30 20 #2 #1 80 140 40 40 40 20 Tentative group 70 70 40 #2 180 4. Complete the total rooms sold forecasting worksheet. 5. Enter the Week 3 rooms sold from the rooms sold worksheet onto the Week 3 room revenue forecasting worksheet. 6. Use the same daily average rates as Week 1 for both the transient and group rooms sold. 7. Calculate the total room revenue by day for Week 3 and complete the Week 3 room revenue forecasting worksheet the daily and weekly totals from the room revenue forecasting worksheet. Turn HOONES SOLD FORECASTING WORKSHEET 15. POINT PROBLEM SET WEEK 1 PERIOD Todd Bar Sunday Monday Tuesday Thursday MARKET SEGMENT TRANSANT ROOM New Pickup Team GRUPOS Deep trein Group Tentative Group 1 Tentative G2 Total Group TOTAL ROOM RIRVATIONS OCCUPANCY PIERCINTAGE Checkins Chuck Chats ROOM REVENUE HORECASTING WORKS 25-POINT PROBLEM SET WEEK PERIOD Eriday Saturday Sunday Monday Tuesday Wednesday Thursday Friday. Total MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rexoms Sodd Average Rate Total Group Revenue TOTAL REVENUE Total Room Sold Occupancy Percentage Average Kate Total Rocur Revenue 197