Key points
- Define an occupied room night and keep the convention consistent over time.
- Separate measured, estimated and missing data.
- Read ratios alongside absolute quantities, included services and events during the period.
1. Set a stable boundary and denominator
The operations lead defines the period, buildings and activities included in each measure. A main meter may cover guest rooms, a restaurant, pool and laundry. Its occupied-room ratio therefore describes that whole boundary, rather than the physical use of one guest in a room. Record included activities and any changes to them.
Here, an occupied room night means one room occupied for one night, regardless of the number of people staying in it. Document the treatment of complimentary rooms, staff rooms and other special cases. Do not mix this denominator with guest nights or available room nights. The convention needs to be understood by whoever produces the occupancy extract.
2. Keep a table that exposes data quality
| Measure | Numerator | Source | Quality check |
|---|---|---|---|
| Water | Volume in m³ during the period | Meter or invoice with a known boundary | Dates, units and actual or estimated reading |
| Energy | kWh for each energy stream tracked | Reading or invoice | Period and any documented conversion |
| Selected supply item | Quantity used in a stable unit | Recorded use or stock reconciliation | Product, concentration and non-consumption movements |
| Occupancy | Occupied room nights | Authorised PMS extract | Matching period and consistent convention |
Assign an owner to each reading. An empty cell remains missing rather than becoming zero. An estimated invoice retains that label until corrected. Preserve the original value and explain revisions so a future reader can understand why an earlier ratio changed. Align billing periods before combining quantities in the same reporting row.
3. Calculate ratios with units visible
Water litres per occupied room night = water volume in m³ × 1,000 ÷ occupied room nights. For energy, divide the boundary’s kWh by the same occupied room nights. For a supply item, divide the quantity actually used, in the selected unit, by that denominator.
When consumption comes from stock reconciliation, use opening stock + receipts − closing stock − non-consumption issues. Classify transfers, returns and corrections consistently. A large purchase does not necessarily represent immediate use. Avoid adding incompatible products or units simply to produce one indicator. A change in product concentration also needs explanation before comparing quantities.
Fictional example for one period and boundary: 300 m³ of water, 45,000 kWh, 900 units of the selected item and 1,500 occupied room nights produce 200 litres, 30 kWh and 0.6 units per occupied room night. These are illustrative arithmetic results, not benchmarks or claims about an actual hotel.
4. Explain a change before attributing it to an action
Attach an events log covering renovation, an area closure, a reported leak, a laundry change, restaurant activity, unusual weather or a product change. If occupancy falls while some uses remain stable, the ratio can rise without demonstrating a change in housekeeping practice. Keep the absolute quantity visible so the team can see both effects.
The World Sustainable Hospitality Alliance’s HWMI methodology includes water measurement per occupied room per day. The table here is a simplified internal tracker; use the complete methodology before claiming HWMI application. Comparing hotels requires comparable boundaries and conventions, rather than a judgement based on the ratio alone.
5. Connect the observation to a verifiable action
When a change appears unusual, the owner first checks the reading, period and denominator. Where needed, they then open an action: verify a meter, have a competent professional investigate a reported leak or clarify a stock movement. Closure retains the finding, correction and next measurement to review. A task completion is not yet evidence of a consumption reduction.
If there are no occupied rooms, display absolute quantities and “ratio not calculable”; do not divide by zero. The tracker can support the RoomChecking solution for operations directors without promising reductions or attributing automatic utility measurement to the software. An emissions inventory requires a separate method and relevant conversion factors.
Frequently asked questions
Can two hotels be compared directly using the ratio?
Only after checking boundaries, services, periods and conventions. A pool, on-site laundry or substantial restaurant operation can change what the ratio represents.
Should all estimated data be excluded?
Not necessarily. Label estimates, explain the method and replace them when readings become available. This keeps limitations visible without hiding missing information.