Hotel Occupancy Forecast
Hotel occupancy forecast chart that plots 7 days of occupancy % and room revenue against an 80% target to flag weak nights for pricing and staffing. Free, no sign-up, runs in your browser.
Input Data
7-Day Outlook
Chart preview is available after the page loads. Here is the 7-day data summary:
| Day | Occupancy | Revenue |
|---|---|---|
| Mon | 45% | $4,500 |
| Tue | 55% | $5,500 |
| Wed | 65% | $7,200 |
| Thu | 80% | $9,600 |
| Fri | 95% | $12,000 |
| Sat | 98% | $13,500 |
| Sun | 60% | $6,000 |
What this occupancy forecast is useful for
An occupancy forecast is most valuable when it drives operations: staffing, housekeeping sequencing, maintenance windows, and rate decisions. This simple 7-day outlook lets you plug in expected occupancy and room revenue to visualize peaks and troughs.
For best results, update on-the-books numbers daily, then overlay pickup patterns from the last 4–8 weeks. If you see a day trending under target, you can adjust pricing, distribution, or promotions early—before you’re forced into last-minute discounts.
Practical workflow
- Enter updated occupancy and expected room revenue for each day.
- Click “Update Chart” and scan for days below your internal target line.
- Decide one action per low day (rate, channel visibility, packages, sales outreach).
What is a hotel occupancy forecast?
A hotel occupancy forecast is an estimate of the percentage of rooms that will be sold on each upcoming night, usually paired with expected room revenue. It measures future demand from rooms already on the books plus the pickup you expect before arrival. Hoteliers use it to plan staffing, housekeeping and purchasing, and to spot weak nights early enough to act on rate or distribution.
Formula
Occupancy % = rooms sold ÷ rooms available × 100; ADR = room revenue ÷ rooms sold
This tool charts the occupancy and revenue figures you enter against an 80% target line; it does not generate the forecast for you. Use these formulas to turn your on-the-books numbers into the values you enter and compare.
Worked example: the default week
- The default data runs from 45% occupancy on Monday up to 95% on Friday and 98% on Saturday, then 60% on Sunday.
- Average occupancy for the week is (45 + 55 + 65 + 80 + 95 + 98 + 60) ÷ 7 = 498 ÷ 7 ≈ 71.1%.
- Total room revenue is $4,500 + $5,500 + $7,200 + $9,600 + $12,000 + $13,500 + $6,000 = $58,300.
- Four nights (Mon, Tue, Wed, Sun) sit below the 80% target line; Thursday is exactly on it.
- For a 100-room hotel, Monday is 45 rooms for $4,500, an ADR of $100, while Saturday is 98 rooms for $13,500, an ADR of about $137.76.
This is a weekend-driven profile: the soft weekdays, not the already-full weekend, are where pricing, packages or group sales would add the most revenue.
How to read your forecast
- Bars near 100% occupancy are compression nights: hold or raise rate and consider minimum-stay rules rather than discounting.
- Nights well below target with time remaining are candidates for targeted promotions, extra channel visibility or corporate and group outreach.
- Compare revenue with occupancy: if revenue rises faster than occupancy, ADR is rising too; if not, you may be filling rooms with low rates.
- Use peaks and troughs to schedule housekeeping and front-desk staff, and plan maintenance or deep cleans on the quietest nights.
Frequently asked questions
How do you calculate hotel occupancy?
Divide the number of rooms sold by the number of rooms available for sale, then multiply by 100. Out-of-order rooms are usually excluded from rooms available, and hotels treat complimentary rooms differently, so pick one method and stay consistent.
What is a good occupancy rate for a hotel?
It depends on your market, season and cost structure, so there is no single benchmark. A more useful target is the occupancy you need to break even at your current ADR, plus a margin.
How far ahead should a hotel forecast occupancy?
Short-range forecasts of 7–14 days drive staffing and day-to-day pricing, while 30–90 day forecasts support rate strategy and marketing. Many hotels update the short range daily and the longer range weekly.
What is pickup in a hotel forecast?
Pickup is the number of new room nights booked for a future date over a period, such as the last 7 days. Comparing current pickup with the same lead time in past periods shows whether a date is pacing ahead of or behind normal.