Hotel Forecasting: How to Forecast Occupancy From Booking Pickup

A hotel forecast answers a simple question: how many rooms will we sell on each future date, and at what rate? A good forecast lets you set prices early, plan staffing and decide on group requests with confidence. This guide shows a practical way to forecast occupancy using booking pickup, with a method you can run in a spreadsheet.

What you need

• Rooms on the books (OTB) for each future date, today.
• The same figure from last year, at the same number of days before arrival.
• Final rooms sold last year for the matching dates.

Match dates by day of week, not by calendar date: compare a Saturday with the matching Saturday last year.

The pickup method

The idea is simple: the rooms you will still pick up between now and arrival are similar to what you picked up last year in the same period.

Forecast = rooms on the books today + expected pickup

Expected pickup = last year's final rooms sold − last year's rooms on the books at the same point

A worked example

A 60-room hotel forecasts a Saturday 30 days from now:

• On the books today: 32 rooms
• Last year, 30 days before the matching Saturday: 28 rooms
• Last year's final result: 51 rooms

Expected pickup = 51 − 28 = 23 rooms

Forecast = 32 + 23 = 55 rooms (92% occupancy)

Because you are 4 rooms ahead of last year with 30 days to go, this date has room for a higher rate.

Adjusting the forecast

Last year is a guide, not a promise. Adjust for:

• Events and holidays that moved dates, such as Nyepi, Eid or school holidays.
• Groups booked last year that will not repeat, or new groups this year.
• Capacity changes, such as rooms out of order or a renovation.
• Market changes, such as new flights, a new competitor or a weak source market.

Never let the forecast exceed the rooms you actually have available.

Using the forecast for pricing

Once you have a forecast per date, compare it with your capacity:

• Forecast near or above capacity: raise rates in steps and protect the date with restrictions.
• Forecast around your normal level: hold the rate and watch pace.
• Forecast well below normal: check your compset and visibility first, then consider an offer.

Re-run the forecast at least weekly for the next 90 days and daily for the next 14 days. Pickup changes quickly close to arrival.

Common mistakes

• Comparing calendar dates instead of matching weekdays.
• Using last year's final result without looking at the pickup curve.
• Forgetting that last year may have had a group that will not come back.
• Forecasting once a month and then pricing on an old number.

How Revbot helps

Revbot builds this forecast automatically from your PMS data: pace against last year for every date, pickup curves and a monthly forecast, so you can see which dates need a higher rate and which need attention. The pricing engine then uses the same data to set rates within your limits.

Quick checklist

• Pull rooms on the books for the next 90 days.
• Match each date with the same weekday last year.
• Calculate expected pickup and the forecast per date.
• Adjust for events, groups and capacity.
• Use the forecast to set rates, and repeat weekly.

Want a pickup-based forecast for your hotel without the spreadsheet? Request a free 7-day demo.