Business planning guide

Hotel Plan: How Much Volume Can a Higher Room Rate Lose?

Evaluate a hotel rate change against lost room-nights and the correct usable inventory.

Independent Hotel Financial Model

On this page
Illustration of a guest bedroom with a neatly made bed, luggage bench and sitting area.

A room-rate increase helps only if the remaining room contribution covers the volume it loses. Compare sold nights, net realized rate and costs together; neither occupancy nor headline ADR establishes property profit.

Separate installed and saleable room-nights

Original assumptions, $ for one 30-day month. Twenty rooms create 600 installed room-nights. Maintenance removes 60, leaving 540 saleable nights. Selling 360 nights is 60% of installed inventory but 66.67% of saleable inventory. Both percentages describe the same sales, so use a labelled denominator.

Assume realized net room revenue of $110 per sold night, $30 variable service cost and $26,000 standing operating commitments. Channel mix is held constant in this illustration; actual commissions and acquisition costs must be included consistently in the selected net rate or cost, once.

A $120 rate needs 320 nights to match the old result

Assumed monthly rate-volume alternatives, $
Measure$110 /360 nights$120 /320 nights$120 /300 nights
Room sales39,60038,40036,000
Variable costs10,8009,6009,000
Contribution28,80028,80027,000
Selected operating result2,8002,8001,000

At $120, contribution is $90 per sold night. Matching the old $28,800 contribution requires 320 nights. Raising price while losing only 40 nights holds the selected result; losing 60 nights lowers it by $1,800. That is a sensitivity boundary, not evidence demand will respond in either way.

Do not improve occupancy by shrinking the denominator

If further closures leave 390 saleable nights while 360 are still sold, saleable occupancy rises to 92.31%. Sales have not increased. Add actual renovation payments, room displacement and any changed staffing cost rather than interpreting the higher percentage as a financial improvement.

Date booking deposits, refunds, payroll, suppliers and channel settlements separately. The baseline $2,800 result is not an estimate of starting cash; its $36,800 operating payments can fall before receipts. Use service and housekeeping records alongside the Hotel Financial Model, which connects room inventory, occupancy, rates, costs and investment in the broader forecast.

Scope & limitations

Assumed constant room/channel mix and costs; demand response, channel fees, closures, tax, financing and capital spending require actual evidence.

Explore available financial tools