ZOOM IN AND YOULL SEE IT BETTER

Rooms Sold Forecasting Worksheet Week 3 of January 2018 MARKET SEGMENT SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total 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). TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations 170 20 190 150 25 175 330 45 375 1. Increase the third week's rooms sold forecast (using week 1 forecast) as follows (Keep in mind that weekdays in lodging are Sunday thru Thursday, weekend is Friday, Saturday) 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 125 25 30 0 0 0 0 GROUP ROOMS Definate Group #1 Definate Group #2 Definate Group #3 Definate Group #4 Tenative Group #1 Total Group Reservations 40 0 0 0 40 40 30 0 0 0 0 701 OOO 201 20 40 0 0 801 0 0 0 40 50 ol 40 30 70 20 30 50 Rcoms Sold Forecasting Worksheet-600 Rooms 1 Week 1 551 Offset Friday TOTAL ROOM RESERVATIONS 2301 245 Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total MARKET SEGMENT TRANSIENT ROOMS Reservations Bocked Reservations Pickup Total Transient Reservations 150 10 160 120 10 130 300 30 330 400 50 450 400 40 440 350 40 390 180 20 200 1,900 200 2.100 40 2. Intert the following group room blocks into the spreadsheet (already done for you) GROUP ROOMS Definate Group #1 40 25 20 Definate Group 2 30 30 20 Definate Group #3 40 40 Definate Group #4 Tenative Group #1 40 30 70 20 30 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 MARKET SEGMENT SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total 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). 375 TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 190 $110 $20,900 175 $110 $130 $145 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 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue 70 $1001 55 $1201 MARKET SEGMENT Saturday Sunday Monday Tuesday Wednesday Thursday 401 $100 $4,000 Friday Total $125 160 $ 110 $17,600 130 $ 110 $14,300 330 S 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 TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 230 38.33% $108.26 $24,900 TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Solc Occupancy Percentage Average Rate Total Room Revenue 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 190 31.7% $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.096 $136.47 $69,600 250 41.7% $108.00 $27,000 2,700 64.3% $ 130.56 $352,500 Rooms Sold Forecasting Worksheet Week 3 of January 2018 MARKET SEGMENT SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total 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). TRANSIENT ROOMS Reservations Booked Reservations Pickup Total Transient Reservations 170 20 190 150 25 175 330 45 375 1. Increase the third week's rooms sold forecast (using week 1 forecast) as follows (Keep in mind that weekdays in lodging are Sunday thru Thursday, weekend is Friday, Saturday) 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 125 25 30 0 0 0 0 GROUP ROOMS Definate Group #1 Definate Group #2 Definate Group #3 Definate Group #4 Tenative Group #1 Total Group Reservations 40 0 0 0 40 40 30 0 0 0 0 701 OOO 201 20 40 0 0 801 0 0 0 40 50 ol 40 30 70 20 30 50 Rcoms Sold Forecasting Worksheet-600 Rooms 1 Week 1 551 Offset Friday TOTAL ROOM RESERVATIONS 2301 245 Saturday Sunday Monday Tuesday Wednesday Thursday Friday Total MARKET SEGMENT TRANSIENT ROOMS Reservations Bocked Reservations Pickup Total Transient Reservations 150 10 160 120 10 130 300 30 330 400 50 450 400 40 440 350 40 390 180 20 200 1,900 200 2.100 40 2. Intert the following group room blocks into the spreadsheet (already done for you) GROUP ROOMS Definate Group #1 40 25 20 Definate Group 2 30 30 20 Definate Group #3 40 40 Definate Group #4 Tenative Group #1 40 30 70 20 30 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 MARKET SEGMENT SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total 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). 375 TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue 190 $110 $20,900 175 $110 $130 $145 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 GROUP REVENUE Rooms Sold Average Rate Total Group Revenue 70 $1001 55 $1201 MARKET SEGMENT Saturday Sunday Monday Tuesday Wednesday Thursday 401 $100 $4,000 Friday Total $125 160 $ 110 $17,600 130 $ 110 $14,300 330 S 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 TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue 230 38.33% $108.26 $24,900 TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Solc Occupancy Percentage Average Rate Total Room Revenue 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 190 31.7% $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.096 $136.47 $69,600 250 41.7% $108.00 $27,000 2,700 64.3% $ 130.56 $352,500