1
answer
3
watching
1,333
views
19 Jun 2021
Work Sheet – Forecasting
- Lea Ray is the revenue manager at the 200-room Hilton Garden Inn. She tracks her occupancy and ADR on a daily basis. The following data represent her hotel’s Thursday- night performance for the past seven weeks
Thursday
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Occ. %
69.5
73.5
66.5
72.0
72.5
69.0
77.0
ADR
$151.50
$145.95
$161.50
$178.50
$179.95
$129.95
$159.95
Using that historical data, calculate her average Occupancy %, ADR, and RevPAR for these trailing periods (using the moving average):
- For weeks 1–4
- For weeks 2–5
- For weeks 3–6
- For weeks 4–7
- What do you think would be Lea’s best estimate of next Thursday night’s (week8) RevPAR? Explain your answer.
- Nigar Patel prepares a daily Rooms Forecast Report that is shared with the housekeeping, food and beverage, and front desk managers of the 200-room Comfort Inn she both owns and manages. Today is Monday. Help Nigar complete Tuesday’s Rooms Forecast Report using the following information she has compiled from historical records, current PMS data, and her own insight into rooms sales-related events likely to occur today. When you have completed the forecast, answer the questions that follow
Rooms Forecast Report for Tuesday
Total rooms available 200
- Out of order rooms 0
Net availability
- Stayovers 85
- Reservations ( Arrivals) 60
Adjustments
+ Early departures 10
- Overstays 15
+ No-shows 5
Total forecast sold or Reserved
Calculate the total forecast sold or Reserved
Questions
- How many rooms does Nigar forecast will be occupied on Tuesday night?
- What is Nigar’s occupancy % forecast for Tuesday night?
- Assume Nigar’s forecasted ADR for the night is $160.99. What would be her estimated total room revenue for this date?
- Given the forecasted ADR, what would be forecasted R
Work Sheet – Forecasting
- Lea Ray is the revenue manager at the 200-room Hilton Garden Inn. She tracks her occupancy and ADR on a daily basis. The following data represent her hotel’s Thursday- night performance for the past seven weeks
Thursday
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Occ. %
69.5
73.5
66.5
72.0
72.5
69.0
77.0
ADR
$151.50
$145.95
$161.50
$178.50
$179.95
$129.95
$159.95
Using that historical data, calculate her average Occupancy %, ADR, and RevPAR for these trailing periods (using the moving average):
- For weeks 1–4
- For weeks 2–5
- For weeks 3–6
- For weeks 4–7
- What do you think would be Lea’s best estimate of next Thursday night’s (week8) RevPAR? Explain your answer.
- Nigar Patel prepares a daily Rooms Forecast Report that is shared with the housekeeping, food and beverage, and front desk managers of the 200-room Comfort Inn she both owns and manages. Today is Monday. Help Nigar complete Tuesday’s Rooms Forecast Report using the following information she has compiled from historical records, current PMS data, and her own insight into rooms sales-related events likely to occur today. When you have completed the forecast, answer the questions that follow
Rooms Forecast Report for Tuesday
Total rooms available 200
- Out of order rooms 0
Net availability
- Stayovers 85
- Reservations ( Arrivals) 60
Adjustments
+ Early departures 10
- Overstays 15
+ No-shows 5
Total forecast sold or Reserved
Calculate the total forecast sold or Reserved
Questions
- How many rooms does Nigar forecast will be occupied on Tuesday night?
- What is Nigar’s occupancy % forecast for Tuesday night?
- Assume Nigar’s forecasted ADR for the night is $160.99. What would be her estimated total room revenue for this date?
- Given the forecasted ADR, what would be forecasted R
Read by 24 people
7 Oct 2021