July looks ahead of the same time last year. Good news, on the surface. But ahead doesn't say whether the higher average rate is real pricing power or just a richer mix of segments this year. It doesn't say what the month will actually finish at, or whether the building can even hold the demand still to come.
The Number That Hides Its Own Story
Today, a revenue manager reconstructs that picture by hand across cross-tabs, or skips it and decides on the blunt monthly number alone. HSMAI's benchmarking study puts a number on the cost: less than half of RM time goes to revenue-generating work, and a large share of the rest goes to reformatting the same data for different audiences. Every hour of that is pricing headroom left on the table, effort spent chasing a channel that can't help, and a lead that quietly erodes while the topline number still looks fine.
Volume, Mix, and Rate: Know What's Real
The variance between this year and last year splits into three parts that reconcile exactly: volume, mix, and rate. Volume holds steady as the baseline. Mix and rate redistribute the rest, showing how much of the change came from booking more rooms, a different blend of segments and channels, or genuine pricing power. Add them up, and they equal the total variance, every time, at whatever level you group by. That's the answer to the question every revenue manager asks first: is this ADR lift real, or did we just sell more of the expensive room type this month? Now it's shown, not guessed.
Six Variables, Every Month, By Hand
Doing one clean variance decomposition is manageable in a spreadsheet on a quiet afternoon. Doing it for real means repeating the same volume, mix, and rate split, correctly reconciled, across segment, feeder market, distribution channel, rate code, room type, and length of stay, then running the same forward pickup projection for each of those six cuts, every month, for every property you manage. That's twelve reconciled calculations at minimum, each one only trustworthy if the last one carried no error into it. Past a certain scale, that isn't a time problem anymore. It's practically impossible to hold all six variables correctly in a spreadsheet without something slipping, and that's exactly where a monthly number gets decided on instinct instead of evidence. Demand Calendar runs all twelve automatically, every month, so the decision in front of you is built on what actually happened across all six variables, not the two you had time to check by hand.
What the Month Is Likely to Become
Knowing what happened is half the job. Knowing what's still coming is the other half. The forward outlook projects the rest of the month from last year's remaining pickup at the same lead time, adjusted for how each source is actually pacing right now, and shows it as a range rather than a single number. In one property's July, for example: 2,988 rooms on the books, projected to land around 3,618 if the rest books like last year, with a realistic range of 3,509 to 3,681. Each distribution channel gets tagged as still filling or effectively booked, so you know where the remaining upside and the remaining risk actually sit.
Where the Room Actually Runs Out
A projection means nothing if the hotel can't physically hold it. Capacity awareness caps each room type's expected pickup at what's actually left to sell, computed night by night. That catches the case that costs real money: a room type running ahead of last year's pace but closing in on sell-out, which means the demand exists, but the building can't take it at the current rate. That's a pricing conversation with your RMS, not a channel-mix problem. Or it's a channel that's still filling but supplying rooms you'd sell anyway, which is a distribution cost worth questioning. Either way, the lever and the stakes are named. The rate decision stays with you and your RMS.
Walking Into the Meeting Already Explained
The real payoff isn't the chart. It's the meeting where you don't have to defend a number nobody else built. When the variance is already reconciled and the forward range is already shown, your analysis stops needing a translator. The team looks at the same explanation you do, together, before anyone asks the question out loud.
Three things to do this month:
- Pull last month's ahead-of-last-year number and check whether it was rate or mix. If you can't answer in under a minute, that's the exact gap this closes.
- Find the room type running furthest ahead of last year's pace and confirm it still has capacity left to sell before you assume the upside is real.
- Bring the reconciled variance and the range, not just the headline number, into your next revenue meeting.
On-the-books explained does not set your rate, your length-of-stay controls, or your channel decisions. It shows you what drove the variance, what the month is likely to become, and where the constraint sits, and leaves the decision with you.
Ask your Demand Calendar contact about early access to on-the-books explained, or book a 30-minute walkthrough and see it built on your own numbers.
