Calculator
Formula Used
Occupied Rooms per Day = Total Rooms × Occupancy Rate
Guest Nights = Occupied Rooms per Day × Average Guests per Room × Days
Occupied Room Nights = Occupied Rooms per Day × Days
Base Liters = Guest Room + Laundry + Kitchen + Housekeeping + Staff + Pool/Spa + Landscaping + Cooling + Other Facilities
Leak Liters = Base Liters × Leak and Loss Allowance
Gross Liters = Base Liters + Leak Liters
Reuse Savings Liters = Gross Liters × Reuse/Recycling Savings
Net Liters = Gross Liters − Reuse Savings Liters
Net Cubic Meters = Net Liters ÷ 1000
Total Cost = (Net m³ × Water Tariff) + (Net m³ × Wastewater Surcharge) + Prorated Fixed Monthly Charge
How to Use This Calculator
- Enter room inventory, occupancy rate, and billing period days.
- Add hotel operating assumptions for guests, staff, laundry, kitchens, housekeeping, and facilities.
- Include leak allowance, recycling savings, tariff, wastewater fee, and fixed monthly charge.
- Click Calculate Water Cost to show the result block above the form.
- Review consumption totals, cost drivers, room-night cost, and the category chart.
- Use the CSV or PDF buttons to keep a shareable report.
Example Data Table
This sample scenario uses the default values already loaded in the calculator.
| Category | Example Liters | Example m³ | Share of Gross Use | Estimated Cost Share |
|---|---|---|---|---|
| Guest Rooms | 1,111,968.00 | 1,111.97 | 55.38% | $3,097.01 |
| Laundry | 308,880.00 | 308.88 | 15.38% | $860.28 |
| Kitchen | 162,162.00 | 162.16 | 8.08% | $451.65 |
| Housekeeping | 78,624.00 | 78.62 | 3.92% | $218.98 |
| Staff Use | 64,800.00 | 64.80 | 3.23% | $180.48 |
| Pool & Spa | 66,000.00 | 66.00 | 3.29% | $183.82 |
| Landscaping | 48,000.00 | 48.00 | 2.39% | $133.69 |
| Cooling Systems | 54,000.00 | 54.00 | 2.69% | $150.40 |
| Other Facilities | 18,000.00 | 18.00 | 0.90% | $50.13 |
| Leaks & Losses | 95,621.70 | 95.62 | 4.76% | $266.32 |
| Total | 2,008,055.70 | 2,008.06 | 100.00% | $5,592.75 |
FAQs
1. What does this calculator estimate?
It estimates hotel water consumption and utility cost for a selected billing period. It combines guest demand, operations, facilities, leaks, recycling savings, and tariffs into one forecast.
2. Why are liters converted to cubic meters?
Most water utilities bill in cubic meters. Converting liters to m³ lets the calculator apply tariffs and wastewater charges in the same units that invoices usually use.
3. Should I include leak allowance?
Yes, when your site has old piping, irrigation issues, or meter variance. Adding a leak percentage helps the estimate reflect real billed usage instead of ideal consumption only.
4. What counts as reuse or recycling savings?
This can represent greywater reuse, linen reuse programs, low-flow retrofits, or recycling loops. Enter the percent reduction you expect after gross water use is calculated.
5. Can this work for resorts and serviced apartments?
Yes. Adjust room count, guest mix, amenity demand, and facility liters per day. Resorts often need higher pool, landscaping, and cooling assumptions than city hotels.
6. Why is cost per occupied room night useful?
It shows how water expense scales with sold inventory. Revenue managers and operators can compare this figure with ADR, housekeeping standards, and sustainability targets.
7. Does the calculator support fixed utility charges?
Yes. The fixed monthly charge is prorated by billing days and added to variable water and wastewater charges, giving a more realistic total bill estimate.
8. Are results exact utility invoice values?
No. They are planning estimates. Actual invoices may include tiered pricing, taxes, minimum fees, seasonal rules, meter timing, or special local service charges.