HBD tool for Front Desk
Revenue calculator
and return from hotel upselling.
Keep an initial reference and build a scenario with your hotel's data. Explore estimated average monthly and annual revenue, the difference against current revenue and contribution after costs.
Initial values are an example, not an HBD assessment or recommendation. Change them to reflect your hotel.
Your scenario.
Editable example · Not a forecast or a guarantee of results.
Annual: specified opening days using average occupancy and stay while open. Monthly average: annual ÷ 12, including closed months. It does not represent each month or model within-season variations or implementation ramp-up.
Review with HBD ↗Calculations run in your browser and are not stored or sent automatically.
How it is calculated.
- Stays in the period = rooms × days × average annual occupancy ÷ average annual stay. Annual revenue is calculated over annual opening days; the monthly average is annual revenue divided by 12.
- Upgrades sold = stays × eligibility × offer rate × conversion. With only one room category, no category upgrade is estimated; extras remain included.
- Upgrade revenue = upgrades sold × supplement per night × nights per upgrade.
- Extras revenue = stays × extras purchase rate × average revenue per purchase.
- Estimated revenue = upgrades + extras. Difference = estimated revenue − current upselling revenue for the same period.
- Incremental contribution = difference × assumed margin − additional recurring costs.
- Period ROI = (incremental contribution − initial investment) ÷ initial investment. Payback = investment ÷ incremental contribution, multiplied by the number of days in the period.
Rates are applied as proportions. Fractional amounts represent expected values. The number of room categories does not alone determine upgrade availability. With two or more categories, validate eligibility and supplements; no category multiplier is applied. In all-inclusive hotels, only count extras outside the contracted package. This model simplifies margins and availability: validate seasonality, products, costs, taxes, cancellations and the baseline before making decisions. An observed difference alone is not attributable incremental programme revenue. Payback assumes a constant rate, excludes implementation ramp-up and is not shown if contribution is zero or negative.
Quick reference: the original HBD calculator
This reference retains the original HBD calculator's coefficients. They are not validated benchmarks or hotel targets, so they are shown separately from the editable scenario.
Monthly reference: —
Formula: rooms × occupancy × coefficient. Monthly coefficients per occupied room: 3★, 13.5–91.5; 4★, 19.5–167.5; 5★, 24–272. The original calculator's truncation to whole euros is retained.
Calculator ↗