Free tool
Hotel Overbooking Calculator: How Many Rooms to Overbook
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.
Last reviewed · Published by Global Lux Agency
Recommended overbooking
7 extra bookings
Accept up to 107 bookings for 100 rooms. Show rate 92%; critical ratio 33.3% (revenue ÷ revenue + walk cost).
| Extra | Shows | Walk risk | Walks | Gain |
|---|---|---|---|---|
| 1 | 92.92 | 0% | 0 | £414 |
| 2 | 93.84 | 0.2% | 0 | £825 |
| 3 | 94.76 | 0.9% | 0.01 | £1,227 |
| 4 | 95.68 | 2.9% | 0.04 | £1,602 |
| 5 | 96.6 | 7.1% | 0.11 | £1,924 |
| 6 | 97.52 | 14% | 0.24 | £2,156 |
| 7 recommended | 98.44 | 23.9% | 0.47 | £2,263 |
| 8 | 99.36 | 35.9% | 0.81 | £2,218 |
| 9 | 100.28 | 48.9% | 1.27 | £2,011 |
| 10 | 101.2 | 61.5% | 1.85 | £1,648 |
| 11 | 102.12 | 72.6% | 2.52 | £1,148 |
| 12 | 103.04 | 81.5% | 3.28 | £540 |
An estimate from a simple model: it assumes guests arrive independently and that demand fills the extra bookings. Groups and events arrive or cancel together, so be more cautious on those nights, and never walk a VIP or a returning guest when you can avoid it.
How the calculation works
- Show rate. 100% less your no-show and late-cancellation rates. Each booking is treated as turning up independently with that probability, so the number of arrivals follows a binomial distribution.
- Each overbooking level. For rooms + 0, 1, 2 and so on bookings, the tool works out the full probability of every possible number of arrivals. From that it gets the expected rooms occupied, the chance that more guests arrive than you have rooms, and the expected number of walks.
- Expected gain. Revenue per room × expected rooms occupied, less walk cost × expected walks, compared with not overbooking at all.
- Recommendation. The level with the highest expected gain. This is the newsvendor critical-ratio rule: one more booking is worth taking while the chance that all your rooms are already needed is below revenue ÷ (revenue + walk cost). When two levels tie, the tool picks the smaller.
Walking guests at a luxury hotel
The arithmetic treats every walk as a cost you can count. At luxury level the real cost is often larger: a walked VIP, honeymooner or loyal returning guest can be lost for good, and the story travels. Put that into the walk cost, plan who would be walked first (usually a single-night stay with a booking that can be honoured at a comparable sister property), and keep the overbooking level lower on nights with VIP arrivals, events or groups.
What the tool doesn’t do
- It doesn’t supply no-show or cancellation rates: no reliable published average exists for luxury hotels. Use your own history for comparable nights.
- It doesn’t model groups or correlated cancellations, multi-night stays, or room types. Run it separately for a room type if you overbook by type.
- It doesn’t forecast demand. It assumes the extra bookings will come if you accept them.
Questions & answers
How many rooms should a hotel overbook?
What should the cost of walking a guest include?
Where do the no-show and late-cancellation rates come from?
Does a no-show fee change the answer?
What does the model assume?
Sources & data
Every figure this tool uses by default is listed here with where it came from and when we last checked it. Spotted something out of date? Tell us.
- Overbooking as a newsvendor problem (critical ratio rule)Revenue-management teaching treats the overbooking level as a single decision taken before the number of no-shows is known: the newsvendor model, where the optimum sets the probability of having too few no-shows equal to the critical ratio of the underage cost (an empty room that could have been sold) to the sum of the underage and overage (walked guest) costs. Lecture examples often model no-shows as Poisson; this tool models each booking as showing independently (binomial), which gives the same marginal rule. Practitioner sources word the formula differently (some add a fare ratio), so treat it as a planning model, not a forecast.
Cite or link to this tool
Writing about this topic? You are welcome to link to or cite this tool.
For brands & suppliers
Reach the people planning luxury travel
Our tools are used by advisors, hotels, DMCs and travellers at the moment they are planning and pricing. Sponsorships, featured listings and custom tools are available.
Work with us