Hotel forecasting, without the spreadsheet theater
You were not hired to rebuild last night's model. You were hired to find the next €50,000.
It is Monday morning. Somebody asks how next week is pacing against budget, and the room goes quiet because the answer lives in three places that do not agree. This guide gives you one forecasting cycle the whole team can run from, the four questions it must answer, and the posts that go deep on each one.
The Forecast Is Not a Report
A forecast that arrives after the decision window is a record, not a forecast. Most hotels run forecasting as a weekly assembly job: pull the PMS, paste into a sheet, compare to last year, send the PDF. By the time the file lands, the booking pattern has already moved.Forecasting stops being a document and starts being a shared view of the future that every commercial role plans against. Sales sees the same gap as Revenue. Marketing sees the same opportunity as Operations. The argument over whose number is right disappears, because there is only one number.
Read next: Hotel Economics: The Role of Supply and Demand in Setting Rates
Four questions every forecast must answer
What is on the books right now, and where is it pacing?
OTB and pace tell you what demand has already committed to. They are the difference between a forecast and a guess.
How to improve and develop forecasting in hotelsWhat is the booking pattern telling you about what comes next?
Day-of-week, lead time, and channel pickup are the signals competitors miss when they read the dashboard yearly instead of weekly.
Total Revenue Forecasting: The Key to Maximizing ProfitsHow does your forecast compare to the budget?
Budget is the target. Forecast is the truth. The space between them is the work.
Beyond Budgeting: Why Forecasting Drives Success in Hotels.What can go wrong, and what would you do about it first?
The forecast that ignores downside is the one that surprises the owner at month-end.
Hotel Revenue Management: What Could Possibly Go Wrong?Where most forecasts quietly break
Three failure points show up in nearly every hotel that has ever asked us to look. They are not technology problems. They are habits the technology has been hiding.
- SINGLE-USER FORECASTING The Revenue Manager builds the model. The GM, Sales, and Marketing get a PDF. None of them owns the number because none of them touched it.
- COMP-SET DRIFT The comp set was set in 2019, the market has shifted, and nobody has rebuilt it. The forecast benchmarks against a market that no longer exists. Winning Over the Competition: How to Select the Right Comp Set.
- NO RISK IN THE MODEL Revenue gets forecast confidently. Proactive Business Risk Management in Hotels.
The Problem Behind the Three Biggest Problems
How This Hub Fits Into PORM
This page sits on the demand side of Profit-Oriented Revenue Management. Forecasting tells you what is coming. The other half of PORM tells you what the response should be when profit, not just revenue, is the goal.
Demand Calendar runs this forecasting cycle as one shared view, with OTB, pace, pickup, budget, and last year on the same screen for every property and every revenue stream. The team plans against one number instead of arguing about three, which gives you back the hours you were supposed to spend on the role you were hired for.
Every forecast that arrives after the booking window has closed costs the same thing: the action you could have taken if it had arrived in time. The question is not whether your forecast is accurate. The question is whether it is fast enough to matter.
READ THE FULL FRAMEWORK
The PORM whitepaper was co-authored with HSMAI and
the Singapore Institute of Technology.
