ZOOM IN AND YOULL SEE THE QUESTION BETTER

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