Rooms Sold Forecasting Worksheet SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total MARKET SEGMENT TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations 170 20 190 150 25 175 330 45 375 201 0 125 40 0 40 30 25 30 0 0 20 0 0 GROUP ROOMS Definate Group #1 Definate Group #2 Definate Group #3 Definate Group #4 Tenative Group #1 Total Group Reservations 0 0 0 40 40 40 20 0 0 0 0 50 30 30 0 0 0 0 70 50 0 40 70 55 80 TOTAL ROOM RESERVATIONS 230 245 Week 3 of January 2018 Another busy week for Flagstaff Hotel For the third week of January 2018, the hotel is forecasting a busier week and more rooms sold (than week 1). To prepare for the third week rooms sold forecast, have the first week's rooms sold forecast when making changes to week three numbers (below). (Keep in mind that weekdays in lodging are Sunday thru Thursday, weekend is Friday, Saturday) 1. Increase the third week's rooms sold forecast (using week 1 forecast) as follows: a) Increase weekday transient room reservations 30 per day b) Increase weekday transient room reservation pickup 15 per day c) Increase weekend transient room reservations 20 per day d) Increase weekend transient room reservation pickup 10 per day Rooms Sold Forecasting Worksheet-600 Rooms 1 Week Offset Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total MARKET SEGMENT TRANSIENT ROOMS Reservations Bocked Reservations Pickup Total Transient Reservations 300 150 10 160 120 10 130 30 330 400 50 450 400 40 440 350 40 390 180 20 200 1,900 200 2,100 2. Intert the following group room blocks into the spreadsheet (already done for you) GROUP ROOMS Definate Group 51 40 40 25 20 Definate Group #2 30 30 20 Definate Group #3 40 Definate Group #4 Tenative Group #1 1 888 40 40 50 20 30 50 3. Insert the Week 3 rooms sold (transient rooms sold, group rooms sold, total rooms sold) onto the week 3 room revenue forecasting worksheet (tab). For questions 4-6, see the room revenue forecasting tab at the bottom Room Revenue Forecasting Worksheet SUNDAY MONDAY TUESDAY SATURDAY WEDNESDAY THURSDAY FRIDAY Total MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 1901 $110 $20,9001 175 $110 3751 $130 $145 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue 40 $100 $4,000 701 $100 551 $120 $125 TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 230 38.33% $108.26 $24,900 3. Again, enter the week 3 rooms sold for the rooms sold tab (worksheet) onto the week 3 room revenue forecasting tab (worksheet). 4. Use the same average daily rates (ADRs) as WEEK 1 for both the transient and group rooms sold (weekdays/weekend only, not totals). 5. Calculate the total room revenue (transient, group, and total) for Week 3, and complete the week 3 room revenue forecasting worksheet (fill in all the orange cells). Room Revenue Forecasting Worksheet 1 Week MARKET SEGMENT Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 160 $ 110 $17,600 130 $ 110 $14,300 330 $ 130 $42,900 450 $ 145 $65,250 440 $ 145 $63,800 390 $ 140 $54,600 200 $ 110 $22,000 2.100 $ 133.55 $280,450 30 $ $ 100 $ 3,000 20 $ 100 $ $ 2,000 90 $ 120 $10,800 150 $ 125 $18,750 140 $ 125 $17,500 120 $ 125 $15,000 50 $ 100 $ $ 5,000 600 $ 120.08 $ 72,050 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Solc Occupancy Percentage Average Rate Total Room Revenue 190 31.796 $108.42 $20,600 $ 150 25.0% $108.67 $16,300 420 70.0% $127.86 $53,700 600 100% $140.00 $84.000 580 96.7% $140.17 $81,300 510 85.0% $136.47 $69.600 250 41.7% $108.00 $27,000 2,700 64.3% $ 130.56 $352,500 Rooms Sold Forecasting Worksheet SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total MARKET SEGMENT TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations 170 20 190 150 25 175 330 45 375 201 0 125 40 0 40 30 25 30 0 0 20 0 0 GROUP ROOMS Definate Group #1 Definate Group #2 Definate Group #3 Definate Group #4 Tenative Group #1 Total Group Reservations 0 0 0 40 40 40 20 0 0 0 0 50 30 30 0 0 0 0 70 50 0 40 70 55 80 TOTAL ROOM RESERVATIONS 230 245 Week 3 of January 2018 Another busy week for Flagstaff Hotel For the third week of January 2018, the hotel is forecasting a busier week and more rooms sold (than week 1). To prepare for the third week rooms sold forecast, have the first week's rooms sold forecast when making changes to week three numbers (below). (Keep in mind that weekdays in lodging are Sunday thru Thursday, weekend is Friday, Saturday) 1. Increase the third week's rooms sold forecast (using week 1 forecast) as follows: a) Increase weekday transient room reservations 30 per day b) Increase weekday transient room reservation pickup 15 per day c) Increase weekend transient room reservations 20 per day d) Increase weekend transient room reservation pickup 10 per day Rooms Sold Forecasting Worksheet-600 Rooms 1 Week Offset Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total MARKET SEGMENT TRANSIENT ROOMS Reservations Bocked Reservations Pickup Total Transient Reservations 300 150 10 160 120 10 130 30 330 400 50 450 400 40 440 350 40 390 180 20 200 1,900 200 2,100 2. Intert the following group room blocks into the spreadsheet (already done for you) GROUP ROOMS Definate Group 51 40 40 25 20 Definate Group #2 30 30 20 Definate Group #3 40 Definate Group #4 Tenative Group #1 1 888 40 40 50 20 30 50 3. Insert the Week 3 rooms sold (transient rooms sold, group rooms sold, total rooms sold) onto the week 3 room revenue forecasting worksheet (tab). For questions 4-6, see the room revenue forecasting tab at the bottom Room Revenue Forecasting Worksheet SUNDAY MONDAY TUESDAY SATURDAY WEDNESDAY THURSDAY FRIDAY Total MARKET SEGMENT TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 1901 $110 $20,9001 175 $110 3751 $130 $145 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue 40 $100 $4,000 701 $100 551 $120 $125 TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 230 38.33% $108.26 $24,900 3. Again, enter the week 3 rooms sold for the rooms sold tab (worksheet) onto the week 3 room revenue forecasting tab (worksheet). 4. Use the same average daily rates (ADRs) as WEEK 1 for both the transient and group rooms sold (weekdays/weekend only, not totals). 5. Calculate the total room revenue (transient, group, and total) for Week 3, and complete the week 3 room revenue forecasting worksheet (fill in all the orange cells). Room Revenue Forecasting Worksheet 1 Week MARKET SEGMENT Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 160 $ 110 $17,600 130 $ 110 $14,300 330 $ 130 $42,900 450 $ 145 $65,250 440 $ 145 $63,800 390 $ 140 $54,600 200 $ 110 $22,000 2.100 $ 133.55 $280,450 30 $ $ 100 $ 3,000 20 $ 100 $ $ 2,000 90 $ 120 $10,800 150 $ 125 $18,750 140 $ 125 $17,500 120 $ 125 $15,000 50 $ 100 $ $ 5,000 600 $ 120.08 $ 72,050 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Solc Occupancy Percentage Average Rate Total Room Revenue 190 31.796 $108.42 $20,600 $ 150 25.0% $108.67 $16,300 420 70.0% $127.86 $53,700 600 100% $140.00 $84.000 580 96.7% $140.17 $81,300 510 85.0% $136.47 $69.600 250 41.7% $108.00 $27,000 2,700 64.3% $ 130.56 $352,500