Hotel Group Displacement Analysis Calculator

What is a displacement analysis and when does it actually apply?

It compares the profit a group brings against the profit of the individual bookings it pushes out of the same dates. And the qualifier matters more than the definition: it only applies when the group plus your forecast transient demand exceeds the rooms you have.

That single condition is where most hand calculations go wrong. If a Tuesday runs 70 rooms of transient demand against 120 available, a 26-room group displaces nobody. Those rooms are pure incremental business and the group should be credited with all of them.

The calculator's defaults show a four-night window. Tuesday is open — 70 transient against 120 rooms, zero displacement. Wednesday, Thursday and Friday are constrained, displacing 1.1, 14.1 and 21.1 rooms respectively as demand climbs into the weekend. Three of four nights are constrained, total displacement 36.3 room nights.

Apply displacement flatly across the block and you'd charge the group for roughly 78 room nights of lost transient instead of 36. That more than doubles the apparent cost and kills groups that should be signed.

The other half of the qualifier is the forecast itself. Group rates are agreed in advance and known with certainty; transient demand is an estimate. Be honest about which side of this analysis is a fact and which is a projection, because the displacement number inherits all the uncertainty in your forecast.

Why does comparing the group rate to your ADR give the wrong answer?

Because it compares revenue on one side to revenue on the other and ignores that the two segments have completely different cost structures and completely different ancillary spend.

The calculator's defaults show the reversal cleanly. The rate-to-rate shortcut: group room revenue of $13,050 against displaced transient room revenue of $13,925. The group loses by $875, so decline.

Run it on contribution and the answer flips. Group contribution is $9,904.95 — room revenue after wash, less commission, less variable cost, plus $38 a room night of food, beverage and meeting space contribution. Net cost of displacement is $7,584.77 — displaced transient contribution, plus room-type dilution, less cutoff recapture. Net value of accepting: $2,320.18. Accept.

The shortcut misses $3,195 of value and reaches the opposite conclusion.

This is the canonical trap in the field, and the direction is consistent: rate-to-rate systematically undervalues groups. Groups carry lower acquisition cost than OTA-sourced transient, they spend on food and beverage and meeting space, and they wash. Transient rates are higher but carry higher acquisition costs, and transient ancillary contribution is far less predictable.

Use contribution on both sides — revenue minus variable cost — especially once you're adding revenue streams like F&B and meeting space that carry different margins.

What is group wash and how much does it change the numbers?

Wash is the gap between the block on the contract and the rooms the group actually picks up. Nobody fills a block completely, and analysing the contracted number overstates both the group's value and the displacement it causes.

At the defaults a 90 room-night block washes 13%, so the hotel actually houses 78.3 room nights and 11.7 return to inventory.

Wash cuts both ways and the calculator handles both. It reduces group revenue, from $13,050 contracted to $11,353.50 actual. But it also reduces displacement — the constrained-night test runs on picked-up rooms, not contracted ones — and it creates cutoff recapture, where the released rooms go back on sale and late demand takes some of them. Recapturing half of the washed rooms at the average displaced contribution of $233.33 is worth $1,364.95.

Two contract terms make wash manageable rather than merely painful:

• Cutoff date. It determines how much runway you have to resell released rooms — the calculator's recapture assumption is only credible if the cutoff is early enough for the demand to still be there.
• Attrition clause. It sets the threshold below which the group pays for rooms it didn't use.

Write both into the contract before anyone signs. A 13% wash with a 30-day cutoff is a manageable forecast; the same wash discovered at 7 days is a hole.

How do I work out the rate I should be quoting?

Solve for the rate at which net value is exactly zero, then quote above it. That's your floor, and knowing it changes how the negotiation goes.

The break-even is the net cost of displacement spread across the room nights you'll actually house, plus variable cost, less the ancillary contribution the group brings, all grossed up for commission. At the defaults that's $112.08.

Add a target premium — 10 to 15% is the common guidance — and the recommended quote lands at $125.52 on a 12% premium.

The group is offering $145. So there's $32.92 of headroom per room night, 29% above break-even. That reframes the conversation entirely: sales can discount toward $125 and still clear the target, or hold at $145 knowing exactly how much room exists if the planner pushes.

Without the break-even number, that negotiation runs on instinct, and instinct tends to concede in the wrong places — usually giving away rate while leaving attrition and cutoff terms untouched, when the terms are often worth more than the couple of dollars on the rate.

One thing to check before quoting: the break-even is sensitive to the ancillary assumption. A group with a heavy banquet programme has a much lower break-even room rate than a rooms-only block, and quoting both from the same floor leaves money behind on one and loses the other.

What does this calculator not model?

Four things, and the first two can be material.

• Shoulder-night spillover. The model only displaces on the nights you enter. In reality a sold-out Thursday can cost you Tuesday and Wednesday room nights from guests who wanted a longer stay and booked elsewhere entirely. You can approximate this by entering the shoulder nights with their own demand and ADR, which the defaults do for Tuesday — but the calculator won't automatically infer lost length-of-stay patterns.
• Room type detail. The block is treated as generic rooms. In practice groups take standards and leave you holding suites, which then move at a discount or not at all. That's entered here as a single room-type dilution cost, $480 at the defaults. A hotel with a wide rate spread across room types needs a finer analysis.
• Rate integrity and future business. A low group rate that leaks onto public channels damages your rate position beyond these dates, and a repeat group has value this single-stay analysis cannot see. Both are real and neither is in the arithmetic.
• Cancellation risk. Group business is contracted, which is why it feels safe, but contracts get cancelled and the attrition clause is the only thing standing between you and an empty block on a date you turned transient away for.

Treat the output as the financial floor of the decision, not the whole decision.