Your Revenue Manager has been with you for eleven years and runs every forecast through an Excel workbook they built themselves. The workbook has 14 tabs, hidden columns, named ranges, and 3 macros, and the only documentation is in their heads. Here is what GMs miss when they call that situation "stable" instead of "exposed."
The Strategy Is Not Yours. It's Theirs.
You think you own the forecasting process because you pay for it. You don't. The Revenue Manager owns it. Every decision, every override, every seasonal adjustment lives inside formulas no one else can audit.
Ask your RM to take three weeks off in August. Watch what happens. The forecast either freezes or someone makes a guess and writes it in pencil.
The Real Cost Sits in Three Places
Succession risk shows up in budgets that suddenly get revised in Q1, forecasts that drift after a key person takes leave, and onboarding costs when the next hire spends six months reverse-engineering the previous person's logic. None of these line items appear in the P&L. All of them cost real money.
A junior hire walking into that situation does not need to be smarter than the previous Revenue Manager. They need a system that already holds the strategy.
What "Living in One Person's Excel" Actually Costs You
Three numbers a GM should put on paper before the next budget meeting:
- Knowledge transfer time — how many weeks would a new hire need to match the current forecast accuracy
- Cross-team trust — how often does Sales, Finance, or Marketing get a different number from Revenue Management for the same week
- Decision latency — how long between "we need a revised forecast" and "the revised forecast is in our hands."
If any of these answers make you uncomfortable, the spreadsheet is not the asset you think it is.
The Fix Is Not a Faster Calculator
The temptation is to give the RM a better tool so they can work faster. That misses the point. Speed is not the problem. Ownership is the problem. The strategy needs to live in a place where Sales, Finance, Revenue Management, and the GM all see the same forecast, comment on the same numbers, and pick up where the last person left off.
A new hire on day one should open the system and see the strategy that the team built together. Don't inherit a folder of Excel files and a phone number to call when something breaks.
What a Junior Hire Should Walk Into
The day a new Revenue Manager starts, three things should already be true. The forecast for the next twelve months is on the books and visible to every team. Last year's commentary on why decisions were made is searchable. The budget, target, and actuals are in a single view that nobody has to rebuild.
Demand Calendar gives hotel teams a single place to forecast demand, plan together, and act first, so the strategy stays even when the people change.
Book a Strategy Call → demandcalendar.com/book-a-call
