Skip to content
Calc.

Hotel Overbooking Strategy Calculator

Estimate how many reservations a hotel can accept beyond its room count from the no-show rate, average daily rate, cost of walking a guest and a risk setting. A planning rule of thumb.

Last updated: September 2026

Reservations to Accept

127 rooms

Formula below · 1 source (ecornell-impact.cornell.edu) · Updated Sep 2026

Compare with similar

About this calculator

Hotels overbook because some guests never arrive. Selling those rooms again earns the average daily rate (ADR); getting it wrong means "walking" a guest to another hotel at your expense. This calculator uses a simple planning rule:

reservations = ⌊rooms + rooms × no-show rate × (1 − hold-back) − walk cost ÷ ADR⌋

It adds back the expected no-shows, keeps a safety share of them unsold (5%, 8% or 12% by risk setting), and takes off walk cost ÷ ADR rooms so that expensive walks mean less overbooking. With the defaults (120 rooms, 8% no-shows, $150 ADR, $250 walk cost, moderate): 120 + 9.6 × 0.92 − 1.67 = 127.2, so accept 127 reservations, 7 over capacity.

The textbook method

Revenue managers often set overbooking with the newsvendor critical ratio. An empty room loses the ADR; a walked guest costs the walk cost. Overbook x rooms where the chance that at least x guests fail to show is about walk cost ÷ (walk cost + ADR). With $250 and $150 that is 0.625: oversell only as many rooms as you have a 62.5% chance of seeing no-shows for. The tile shows the complementary ratio ADR ÷ (ADR + walk). Doing this properly needs the night-by-night distribution of no-shows from your own history, which this calculator does not have, so use its answer as a starting point.

Walk costs include the other hotel's room, transport, a goodwill gesture and the risk of losing a loyal guest, which is why many hotels set them well above the ADR.

How to use

Enter your rooms, historical no-show rate, ADR, full cost of walking a guest, and a risk setting. Example 1 (the defaults): 120 + 120 × 0.08 × 0.92 − 250 ÷ 150 = 127.17, accept 127 reservations. Example 2: 200 rooms, 10% no-shows, $250 ADR, $400 walk cost, moderate: 200 + 18.4 − 1.6 = 216.8, accept 216 (16 over capacity). Example 3: the same hotel on the conservative setting: 200 + 17.6 − 1.6 = 216.0, also 216; on the aggressive setting 200 + 19 − 1.6 = 217.4, accept 217.

Frequently asked questions

What does the risk setting do?

It holds back a share of the expected no-shows from resale: 5% (aggressive), 8% (moderate) or 12% (conservative). Holding back more means fewer walked guests but more empty rooms on nights when everyone shows up.

What should the walk cost include?

The room at the other hotel, taxi or transfer, any compensation or points, staff time, and an allowance for lost future business. Many hotels put the true cost well above one night's ADR.

What no-show rate should I use?

Your own history for the same day of week and season, counting no-shows and late cancellations that free a room too late to resell. Rates differ a lot between business, leisure and group-heavy nights.

Is overbooking legal?

In most places, yes, but you must honour the booking by finding the guest comparable accommodation. Check local consumer rules and your brand standards.

Related calculators

Sources & references

How we check our calculators

Think a result is wrong? Report a problem with this calculator.