Hotel Overbooking Strategy Calculator
Calculates the optimal number of bookings to accept beyond your room count, balancing no-show revenue recovery against the cost of walking a guest. Ideal for revenue managers setting daily or seasonal overbooking limits.
Last updated: September 2026
Formula below · 1 source (Wikipedia) · Updated Sep 2026
Compare with similar
About this calculator
Overbooking is a deliberate revenue strategy: hotels accept more reservations than available rooms because a predictable share of guests will cancel or not show. The optimal overbooking level adds expected no-show rooms back to inventory while subtracting a penalty term for the financial risk of walking a guest. The formula is: Bookings = FLOOR(totalRooms + (totalRooms × (noShowRate / 100) × (1 − riskTolerance)) − (walkCost / averageRate)). The no-show component scales with your historical rate, less the share you hold back for safety (5% aggressive, 8% moderate, 12% conservative). The walkCost / averageRate term penalizes overbooking when the cost of relocating a displaced guest is high relative to your room rate. The floor function ensures you never accept a fractional booking count.
How to use
Assume 200 rooms, a 10% historical no-show rate, a $250 average daily rate, a $400 walk cost, and the Moderate setting (0.08). Step 1 — No-show rooms: 200 × 0.10 × (1 − 0.08) = 200 × 0.10 × 0.92 = 18.4. Step 2 — Walk penalty: $400 / $250 = 1.6 rooms. Step 3 — Optimal bookings: FLOOR(200 + 18.4 − 1.6) = FLOOR(216.8) = 216. The hotel should accept up to 216 reservations. The Conservative setting (0.12) holds back more of the expected no-shows: 200 × 0.10 × 0.88 = 17.6, so FLOOR(200 + 17.6 − 1.6) = 216 — the same here; the setting matters more for larger hotels or higher no-show rates.
Frequently asked questions
How does risk tolerance affect the overbooking calculation?
The risk setting is the share of expected no-shows you hold back rather than resell: Aggressive holds back 5%, Moderate 8% and Conservative 12%. Holding back more means accepting fewer extra bookings and walking fewer guests. Choose the conservative setting during holidays or when nearby hotels are full, because a walk is then more costly.
What costs should be included in the walk cost input?
Walking a guest means you cannot accommodate their confirmed reservation and must relocate them to a comparable hotel at your expense. Walk cost should include the full cost of one night at the alternative property, any rate difference you cover, complimentary transportation, a meal or amenity voucher, and a loyalty points adjustment. Soft costs like negative reviews and future lost bookings are harder to quantify but are real. A conservative walk cost estimate protects your brand reputation and keeps the penalty term in the formula meaningful.
When is overbooking most beneficial for a hotel?
Overbooking delivers the greatest financial benefit when no-show and last-minute cancellation rates are high and predictable, such as during corporate travel seasons or leisure peak periods with flexible-rate bookings. It is less appropriate when most reservations are prepaid or non-refundable, because those guests are highly likely to arrive. Properties in markets with limited nearby alternatives also face higher walk costs, which the formula automatically penalizes. Regular review of your historical no-show data by segment and season makes the strategy far more precise.