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.

1. Your hotel operation

Enter the number of reception team members on a typical shift. This describes the team’s capacity and does not automatically increase estimated revenue.

Annual revenue uses your opening days. The monthly result is the annual average divided by 12, including closed months. Occupancy is the average during opening days.

Use occupancy and average stay for the opening period. Room categories are distinct room types, not the room count. Hotel type, star category and team size provide context; they do not apply automatic revenue multipliers.

2. Your upgrade scenario

Nights per upgrade cannot exceed the average stay. Validate the actual availability of higher room categories.

3. Services and extras

Only include additional revenue separate from the upgrade, to avoid double counting.

4. Comparison and return

Compare the same period and product scope. Validate the baseline and margin against hotel data.

These are your investment and cost assumptions, not HBD fees. Without an investment amount, ROI and payback are not calculated.

Your scenario.

Editable example · Not a forecast or a guarantee of results.

Estimated average monthly revenue—
Estimated annual revenue—
Estimated revenue for the period—
Difference against current upselling revenue—
Incremental contribution after costs—
Period ROI, after initial investment—
Investment payback, assuming a constant rate—

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.

  1. 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.
  2. Upgrades sold = stays × eligibility × offer rate × conversion. With only one room category, no category upgrade is estimated; extras remain included.
  3. Upgrade revenue = upgrades sold × supplement per night × nights per upgrade.
  4. Extras revenue = stays × extras purchase rate × average revenue per purchase.
  5. Estimated revenue = upgrades + extras. Difference = estimated revenue − current upselling revenue for the same period.
  6. Incremental contribution = difference × assumed margin − additional recurring costs.
  7. 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.