Case &ContrastFree calculators

Hospitality & room contribution

Hotel Rate & Occupancy Calculator

Compare two entered ADR/occupancy scenarios after a channel-fee percentage and variable occupied-room cost. Demand remains your assumption.

35 / COMPARE ROOM SCENARIOS

Your numbers.
A clearer decision.

Free to use. No signup.
Inputs stay in this browser.

Starting values are illustrative. Use your own costs, rates and assumptions.

INPUT GROUP 01

Common available room-nights and costs

INPUT GROUP 02

Room demand and rate assumptions

Check the assumptions before acting on a result.

Read the method and example

YOUR CALCULATION

Room contribution compares expected room revenue after entered channel and occupied-room costs.

Current room contribution

$87,150.00

Proposed room contribution

$89,700.00

Room contribution change

$2,550.00

Current RevPAR

$84.00

Continuous proposed occupancy estimate

63.15%

Estimates positive baseline contribution at the proposed per-night contribution; may exceed 100%. Separate cent-rounding can change exact equality.

Room-revenue and contribution scenarios

Room-revenue and contribution scenarios
ScenarioExpected occupied nightsRoom revenueChannel feesOccupied-night costsRoom contribution
Current1,050$126,000.00$12,600.00$26,250.00$87,150.00
Proposed975$126,750.00$12,675.00$24,375.00$89,700.00

Keep the calculation

Saving is optional and stays on this device. Unsaved edits are not kept when you leave. CSV includes every input and the current results.

Illustrative inputs loaded. Replace them with your own assumptions.

How the hotel rate & occupancy calculator works

Available room-nights = rooms × days. Expected occupied nights = availability × occupancy percent ÷ 100 and may be fractional. Room revenue is expected occupied nights × ADR. Channel fees and variable occupied-night costs are deducted to calculate room contribution.

Each scenario rounds room revenue, channel fees and variable room-night costs separately to cents before contribution. Contribution is before fixed operating and ownership costs; it is not hotel net profit or GOPPAR. RevPAR divides room revenue by available room-nights and is undefined when none are available.

The occupancy threshold is a continuous model estimate: rounded baseline contribution divided by availability and unrounded proposed contribution per occupied night. It is shown only when both contributions are positive and availability is nonzero, and can exceed 100%. Separate cent-rounding may make this estimate insufficient at exact equality; it is not the exact smallest occupancy that meets a target. Occupancy is an entered assumption, not a demand forecast or optimized rate.

Worked example

Fifty rooms over 30 days provide 1,500 room-nights. At ADR 120 and 70% occupancy, revenue is 126,000. After 10% channel fees and 25 per occupied night, contribution is 87,150. ADR 130 at 65% occupancy gives revenue 126,750 and contribution 89,700, an increase of 2,550. At 70% proposed occupancy, contribution becomes 96,600.

Sources and assumptions

The source material explains the underlying calculation or pricing structure. Entered prices, costs, schedules and scenario choices are your assumptions; this tool does not obtain supplier quotes or predict actual results.

  • Hotel Room Performance Metrics

    Calculate occupancy, room ADR and RevPAR from a constant available-room count, whole period days and matching stayed-room revenue.

  • Hotel Booking Channel Net Revenue

    Compare two channel fee schedules on the same completed stay, with acquisition and variable room-night costs kept separate.

  • Supplier Quantity Discount Decision

    Compare purchase cash, holding costs and ending inventory value for two orders that cover the same entered use.

  • Restaurant Prime Cost

    Build a reduced food/beverage usage cost and add period labor. Compare costs with the same period sales without assuming an industry target.

Calculation methods, testing and sources · Practical calculation guides