Calculator Inputs
Enter operating assumptions for the chosen period. Results appear above this form after submission.
Example Data Table
| Scenario | Total Rooms | Days | ADR | Ancillary Revenue | Variable Cost | Ancillary Variable Cost | Fixed Costs | Occupancy | Break-even Occupancy | Expected Profit |
|---|---|---|---|---|---|---|---|---|---|---|
| Base Hotel Example | 100 | 30 | $120.00 | $10.00 | $35.00 | $5.00 | $150,000.00 | 65.00% | 55.56% | $25,500.00 |
| Premium Rate | 100 | 30 | $145.00 | $14.00 | $38.00 | $5.00 | $150,000.00 | 62.00% | 45.39% | $55,740.00 |
| Higher Cost Pressure | 100 | 30 | $120.00 | $10.00 | $48.00 | $7.00 | $150,000.00 | 65.00% | 67.87% | -$6,300.00 |
Formula Used
Available Room Nights = Total Rooms × Analysis Days
Revenue per Occupied Room = Average Daily Rate + Ancillary Revenue per Occupied Room
Variable Cost per Occupied Room = Variable Room Cost + Ancillary Variable Cost
Contribution per Occupied Room = Revenue per Occupied Room − Variable Cost per Occupied Room
Break-even Room Nights = Fixed Costs ÷ Contribution per Occupied Room
Break-even Occupancy % = Break-even Room Nights ÷ Available Room Nights × 100
Expected Occupied Room Nights = Expected Occupancy % × Available Room Nights
Expected Profit = (Expected Occupied Room Nights × Contribution per Occupied Room) − Fixed Costs
This structure works well when fixed costs stay constant over the chosen period and variable costs rise mainly with each occupied room.
How to Use This Calculator
- Enter the total number of sellable rooms in the property.
- Set the number of days in the period you want to analyze.
- Enter the average daily rate earned from each occupied room.
- Add ancillary revenue such as breakfast, resort fees, or parking per occupied room.
- Enter room-related variable costs and ancillary variable costs per occupied room.
- Input fixed operating costs for the full period, such as rent, salaries, insurance, and utilities.
- Enter your expected occupancy percentage for a forecast scenario.
- Press the calculate button to see break-even room nights, occupancy, revenue, and projected profit.
- Use the graph to understand how profitability changes as occupancy rises or falls.
- Download the result as CSV or PDF for reporting, budgeting, or team discussion.
Frequently Asked Questions
1. What does break-even mean for a hotel room business?
Break-even is the occupancy level where total contribution from sold rooms exactly covers fixed operating costs. At this point, the property neither earns profit nor records loss for the selected period.
2. Why use room nights instead of only revenue?
Room nights connect demand, capacity, and pricing in one measure. They help managers see how many occupied units are required, not just how much sales revenue must be collected.
3. What counts as fixed costs in this model?
Fixed costs usually include expenses that do not change much with short-term occupancy, such as rent, property taxes, core salaries, insurance, software subscriptions, and baseline utilities.
4. What counts as variable costs per occupied room?
Variable costs include housekeeping supplies, laundry, room amenities, booking commissions, guest consumables, and other expenses that increase when more rooms are occupied.
5. Should ancillary revenue be included?
Yes, when it is reliably tied to occupied rooms. Examples include breakfast income, parking fees, service charges, or resort fees earned mainly from guests staying during the period.
6. Why can the calculator show no valid break-even result?
That happens when contribution per occupied room is zero or negative. In that case, each additional occupied room does not help cover fixed costs, so break-even becomes impossible.
7. How does the expected occupancy field help planning?
It compares your forecast to the break-even line. This shows whether the selected pricing and cost structure are likely to produce profit, loss, or only a thin safety margin.
8. Can I use this for monthly or seasonal analysis?
Yes. Change the analysis days and fixed costs to match the exact period. This makes the tool useful for monthly budgets, peak seasons, off-seasons, and promotion planning.