# Hotel Overbooking Calculator: How Many Rooms to Overbook

> Work out how many extra bookings to accept for a night from your no-show and late-cancellation rates, room revenue and the cost of walking a guest.

The hotel overbooking calculator estimates how many extra bookings a hotel can accept for a night, from its own no-show and late-cancellation history, the revenue from an extra room and the cost of walking a guest. See the chance of a walk and the expected gain at each level.

- Use the tool: https://globalluxagency.com/tools/hotel-overbooking-calculator
- For: Hotels
- Price: free, no sign-up; calculations run in the browser and nothing is stored
- Last updated: 2026-11-14
- Publisher: Luxury Travel Tools by Global Lux Agency (https://globalluxagency.com)

Estimate only. Results are indicative and based on the inputs you provide and any published sources listed on this page. Always confirm figures with your supplier.

## Frequently asked questions

### How many rooms should a hotel overbook?

Keep accepting extra bookings while the chance that every room is needed stays below revenue ÷ (revenue + walk cost). With a £450 room and a £900 walk cost that ratio is a third. For a 100-room hotel where 8% of bookings fail to arrive or cancel too late, that works out at about 7 extra bookings, with roughly a 24% chance of walking at least one guest and an expected gain of about £2,260 for the night. Raise the walk cost to £2,700 and it drops to 5, with about a 7% chance of a walk.

### What should the cost of walking a guest include?

Everything it costs you: the room at the hotel you send the guest to (often at short notice and a higher rate), transport there and back, any first night or upgrade you waive, a gesture such as dinner or a credit, and compensation you have promised. For luxury guests also weigh the lifetime value at risk if a loyal guest or a VIP is walked. Most luxury hotels set this figure high, which pushes the recommendation down.

### Where do the no-show and late-cancellation rates come from?

From your own history for comparable nights: the same day of the week, season, segment and booking channel. Measure both as a share of the bookings still on the books on the morning of arrival. The defaults in the tool are examples only; no reliable published average exists for luxury hotels, and rates vary widely between groups, leisure and corporate business.

### Does a no-show fee change the answer?

The tool treats a no-show as revenue lost from that room. If you charge no-shows the first night, a no-show still leaves the room empty, but you keep part of the revenue, so the case for overbooking is a little weaker. Enter the revenue you would gain from re-selling the room, not the full rate, to reflect that.

### What does the model assume?

That every booking turns up or not independently, with the same probability, and that demand is strong enough to fill the extra bookings you accept. In practice groups and wedding blocks arrive or cancel together, which makes walks more likely than the model shows, so be more cautious on those nights.

## Related tools

- [RevPAR Calculator: ADR, Occupancy, TRevPAR and GOPPAR](https://globalluxagency.com/tools/revpar-calculator): Calculate hotel RevPAR, ADR, occupancy, TRevPAR and GOPPAR for any period, check RevPAR = ADR × occupancy, and see the rate needed to hit a target.
- [Hotel Upsell Revenue Calculator](https://globalluxagency.com/tools/hotel-upsell-revenue-calculator): Estimate hotel upsell revenue and profit from upgrades, late check-out, spa, dining and transfers, after platform fees, with uplift per arrival and RevPAR.
- [Direct Booking vs OTA Savings Calculator](https://globalluxagency.com/tools/direct-booking-vs-ota-calculator): Work out what OTA commission costs your hotel, the net revenue per booking by channel, the gain from shifting bookings direct and your break-even.

## Sources and default figures

- **Overbooking as a newsvendor problem (critical ratio rule):** {"rule":"keep adding bookings while P(shows ≥ rooms) < revenue ÷ (revenue + walk cost)","criticalRatio":"underage cost ÷ (underage cost + overage cost)"} formula. Confidence: medium; last verified 2026-11-13. Source: [Revenue management: overbooking as a newsvendor problem (lecture notes)](https://ocw.snu.ac.kr/sites/default/files/NOTE/15th.pdf) (Seoul National University OpenCourseWare).
