Work Sheet – Forecasting
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):
Rooms Forecast Report for Tuesday
Total rooms available 200
Net availability
Adjustments
+ Early departures 10
+ No-shows 5
Total forecast sold or Reserved
Calculate the total forecast sold or Reserved
Questions