Hotel Displacement Calculator: How It Works

A hotel displacement calculator estimates the financial impact of turning away a potential guest booking because a room is already occupied or reserved. You enter the room rate, the number of nights, and the probability that the room would have been sold, and it returns the expected revenue loss. This helps hotel managers decide whether to accept a discounted group booking or a free-night redemption instead of holding the room for a higher-paying guest.

Formula

The calculator uses the standard expected-value formula for displacement:

Expected Loss = Room Rate × Number of Nights × Probability of Selling

• Room Rate – the average daily rate (ADR) you would have charged the displaced guest, in your local currency (USD in the default).
• Number of Nights – the length of stay you are giving up.
• Probability of Selling – the likelihood (0–100%) that the room would have been booked by another guest at that rate. This is often based on historical occupancy or demand forecasts.

The result is the expected revenue you lose, not the actual loss. It accounts for the chance that the room might have stayed empty anyway.

Worked Example

Using the default values from the calculator above:

1. Room rate = $150 per night
2. Nights = 2
3. Probability = 80% (0.80)

Step 1: Multiply the rate by the nights to get the total potential revenue: $150 × 2 = $300.

Step 2: Multiply that by the probability: $300 × 0.80 = $240.

So the expected displacement loss is $240.00. That means, on average, you would lose $240 of revenue if you give up that room for a two-night stay at $150 per night with an 80% chance of selling it to someone else.

Why Use a Displacement Calculator

Hotels face displacement decisions regularly. Common scenarios include:

• Accepting a group booking at a discounted rate when rooms are limited.
• Honoring a free-night reward from a loyalty program.
• Extending a current guest’s stay past their checkout date.
• Blocking rooms for a wedding or event at a fixed price.

In each case, you are weighing the guaranteed revenue from the new request against the potential revenue from a future booking. The calculator turns that trade-off into a single number you can compare with the offer on the table.

How to Choose the Probability

The probability of selling is the most subjective input. It depends on your property, season, and demand patterns. Here are some practical ways to estimate it:

• Use your historical occupancy for the same day of week and season.
• Check your booking pace (how far out reservations are coming in).
• Look at competitor occupancy and local events.
• If you have a revenue management system, use its forecasted occupancy.

When uncertain, run the calculation with a range of probabilities (e.g., 60%, 70%, 80%) to see how sensitive the decision is. If the offer is still profitable at the low end, it is likely a safe accept.

Common Mistakes and Misconceptions

One frequent error is using the current rate instead of the rate the displaced guest would have paid. If you are displacing a future booking, use the forecasted rate for that date, not today’s rate.

Another mistake is treating the probability as 100% when it is not. The whole point of the expected value is to reflect uncertainty. Overestimating the probability inflates the loss and may cause you to reject a good offer.

A common misconception is that displacement loss equals the room rate times nights. That is only true if the room is guaranteed to sell. The calculator corrects that by scaling the loss by the probability.

Also, remember that this calculator only measures revenue, not profit. It does not account for variable costs like housekeeping, utilities, or booking commissions. If those costs are significant, subtract them from the rate before using the calculator.

Limitations and Additional Factors

This tool gives a clean revenue estimate, but real decisions involve more than that. Consider these factors:

• Ancillary spending – a guest may spend on food, spa, or parking. That extra revenue is not in the formula.
• Length of stay – a group might stay longer than the displaced guest, which could offset the loss.
• Future business – a large group may bring repeat customers or positive reviews.
• Contractual obligations – some rates (like corporate or government) cannot be displaced.

The calculator is best used as a starting point, not the final word. Combine it with your judgment and knowledge of your market.

Frequently Asked Questions

What if the probability is 100%?

If you are certain the room will sell at the full rate, the expected loss equals the full revenue (rate × nights). That is the maximum possible displacement cost. Use that as a worst-case scenario.

Should I use the net rate or the rate before taxes?

Use the rate you actually receive, typically the room rate before taxes and fees. Taxes are collected and passed on, so they are not revenue to you. If you have variable costs, subtract them to get the net revenue per night.

How does this apply to free-night redemptions?

For a free-night reward, the rate is $0, so the expected loss is $0. But you still incur housekeeping costs and may displace a paying guest. In that case, the displacement cost is the variable cost plus the opportunity cost of the room, which the calculator does not capture. Many hotels treat free nights as a cost of loyalty programs.

Can I use this for a single night or multiple rooms?

Yes. For multiple rooms, multiply the result by the number of rooms. For a single night, set nights to 1. The formula works the same way.

What is a good probability to use if I have no data?

If you have no historical data, start with 50% as a neutral assumption. Then run a sensitivity analysis with 30% and 70% to see how much the decision changes. If the offer is still good at 70%, you are likely safe.

Does this calculator account for overbooking?

No. Overbooking is a separate strategy where you sell more rooms than you have, betting that some guests will cancel. This calculator assumes you are deciding whether to accept a request that would displace an existing or potential booking. Overbooking risk is not included.

Related

• Percent to bps Calculator: Convert % to Basis Points
• Displacement Hull Speed Calculator & Formula
• Displacement Length Ratio Calculator: D/L Ratio

in rate | Room rate per night | USD | 150 | 0
in nights | Number of nights | - | 2 | 1
in prob | Probability room would sell | % | 80 | 0
out loss | Expected displacement loss | USD | rate * nights * (prob / 100) | 2