Hotel Cancellation Revenue Impact Calculator
Model the net revenue effect of guest cancellations and overbooking strategies on a hotel's booking portfolio. Use this to set optimal overbooking levels and cancellation policy thresholds.
About this calculator
Cancellations erode hotel revenue, but strategic overbooking can partially recover those losses — at the cost of occasionally 'walking' guests to a competing property. The formula is: Net Revenue = totalBookings × averageRoomRate − (totalBookings × (cancellationRate / 100) × averageRoomRate) + (totalBookings × overbookingRate × (averageRoomRate − walkCost)). The first term is gross revenue if all bookings stayed. The second term subtracts revenue lost to cancellations. The third term adds back the net gain from overbooking: rooms filled by overbooked guests generate averageRoomRate, but each walked guest incurs a walkCost (relocation, compensation). The overbookingRate should not exceed the cancellationRate to minimize the risk of walking paying guests.
How to use
A hotel has 200 bookings at an average rate of $120. Historical cancellation rate is 15%, and the manager uses an overbooking rate of 0.10 (10%). Walk cost per guest is $180. Step 1: Gross revenue = 200 × $120 = $24,000. Step 2: Cancellation loss = 200 × 0.15 × $120 = $3,600. Step 3: Overbooking gain = 200 × 0.10 × ($120 − $180) = 200 × 0.10 × (−$60) = −$1,200. Step 4: Net revenue = $24,000 − $3,600 + (−$1,200) = $19,200. The negative overbooking gain signals the walk cost exceeds the room rate — reduce the overbooking rate.
Frequently asked questions
How does overbooking help hotels recover revenue lost to cancellations?
When a hotel overbooks by accepting more reservations than available rooms, it hedges against the predictable shortfall caused by last-minute cancellations and no-shows. If cancellations occur as expected, the overbooked rooms fill the gap and revenue is preserved. The risk is that if fewer guests cancel than anticipated, the hotel must walk the excess guests — paying for their alternative accommodation and potentially damaging brand loyalty. The goal is to match the overbooking rate as closely as possible to the historical cancellation rate.
What is a walk cost in hotel revenue management and what does it include?
A walk cost is the total expense a hotel incurs when it must relocate a guest with a confirmed reservation to another property due to overbooking. It typically includes the cost of one night at a comparable or superior hotel, ground transportation, a meal voucher or cash compensation, and sometimes a complimentary future stay. Walk costs frequently exceed the room rate, which is why unchecked overbooking strategies can quickly become loss-making, as this calculator illustrates.
What cancellation rate should hotels use when setting their overbooking strategy?
Hotels should use a rolling 12-month historical cancellation rate segmented by booking channel, lead time, and season — not a simple overall average. Rates typically range from 10% to 30% depending on whether the booking allows free cancellation. The safest approach is to set the overbooking buffer at or slightly below the lower bound of the expected cancellation range for that specific arrival date, and adjust dynamically as the check-in date approaches and actual cancellations materialize.