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
- Hotel Staffing Requirements Calculator
- Hotel Group Booking Pricing Calculator
- Hotel Renovation ROI Calculator
- Hotel Revenue Per Available Room (RevPAR) Calculator
- Hotel Food & Beverage Cost Calculator
- Hotel Break-Even Analysis Calculator
- Hotel Housekeeping Time Calculator
- Hotel Housekeeping Productivity Calculator
Sources & references
Think a result is wrong? Report a problem with this calculator.