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):

A. For weeks 1-4

B. For weeks 2-5

C. For weeks 3-6

D. For weeks 4-7

E. What do you think would be Lea's best estimate of next Thursday night's (week8) RevPAR? Explain your answer.

1. 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

2. How many rooms does Nigar forecast will be occupied on Tuesday night?
4. What is Nigar's occupancy % forecast for Tuesday night?
6. Assume Nigar's forecasted ADR for the night is $160.99. What would be her estimated total room revenue for this date?
8. Given the forecasted ADR, what would be forecasted RevPAR for this date?