Hotel cost per occupied room calculator

Enter a period’s rooms-department costs and occupied room nights. This returns variable CPOR, total CPOR, the per-room contribution of each cost line and what is left over against ADR.

Period costs and volume

Rooms sold in the period, not room count

USD
USD

Burdened, including overtime

USD
USD
USD
USD
USD

Commissions, transport, breakage

USD

Salaried management, contracts, systems

Cost per occupied room
$27.23

total CPOR across 4,440 occupied room nights

Variable CPOR
$25.09
Total rooms cost
$120,900
ADR
$165.54
Contribution per room
$140.45
Rooms cost as % of revenue
16.4%

Cost per occupied room by line

Rooms-department cost lines per occupied room
Cost linePeriod costPer occupied roomShare
Housekeeping labor$62,000$13.9651.3%
Front office labor$21,000$4.7317.4%
Laundry and linen$12,500$2.8210.3%
Guest supplies and amenities$8,200$1.856.8%
Cleaning supplies$3,100$0.702.6%
Other variable rooms cost$4,600$1.043.8%
Fixed rooms cost$9,500$2.147.9%

What a cost per occupied room calculator does

A CPOR calculator divides rooms-department cost by occupied room nights so cost can be compared across months with different occupancy. Splitting variable from fixed cost matters: variable CPOR is the number to use when deciding whether a discounted room is worth selling, while total CPOR is the number to report against ADR.

Where CPOR usually goes wrong

Three habits distort it: using rooms available instead of rooms sold, using unburdened wages so labor looks 20–30% cheaper than it is, and quietly folding property overhead into a department figure so this month cannot be compared with last. Decide the definition once, write it down, and keep it stable. The housekeeping CPOR calculator handles the labor line in detail, and the laundry cost calculator produces the laundry line you should paste in here.

How this calculator works

Calculation steps used by this tool
OutputFormula
Variable rooms costHousekeeping + front office + laundry + guest supplies + cleaning supplies + other variable
Total rooms costVariable rooms cost + fixed rooms cost
Variable CPORVariable rooms cost ÷ occupied room nights
Total CPORTotal rooms cost ÷ occupied room nights
ADRRooms revenue ÷ occupied room nights
Contribution per roomADR − variable CPOR

Assumptions and limits

  • Department scope only. Sales, marketing, admin, utilities, insurance and property taxes sit below the rooms department and are excluded here. Adding them gives a property cost per room, not a rooms CPOR.
  • Costs must be burdened. Enter labor with taxes and benefits included, or CPOR will read low. The housekeeping CPOR calculator applies a benefit load for you.
  • Occupied room nights, not rooms. A 180-room hotel at 82% for 30 days sells roughly 4,430 room nights; using 180 makes the number meaningless.
  • Contribution is not profit. ADR minus variable CPOR ignores distribution commission netting, taxes and any fixed cost below the line.

Cost per occupied room questions