Calculator Inputs
Example Data Table
| Variable | Example Value | Purpose |
|---|---|---|
| Rooms Available | 120 | Total sellable rooms for the day. |
| Expected Occupancy | 78% | Projected share of occupied rooms. |
| ADR | $145 | Current average room selling price. |
| Demand Index | 1.08 | Shows demand pressure versus normal conditions. |
| Ancillary Revenue | $28 | Average extra spending per guest night. |
| Fixed Operating Cost | $9,600 | Daily fixed labor and overhead baseline. |
Formula Used
- Booked Rooms = Rooms Available × Expected Occupancy
- Net Rooms Sold = Booked Rooms × (1 − Cancellation Rate)
- Guest Nights = Net Rooms Sold × Average Length of Stay
- Room Revenue = Net Rooms Sold × ADR
- Recommended ADR = ADR × (0.45 + 0.35 × Demand Index + 0.20 × Seasonality Factor)
- Ancillary Revenue = Guest Nights × Ancillary Revenue per Guest Night
- Gross Revenue = Room Revenue + Ancillary Revenue
- Total Cost = Fixed Cost + Variable Cost + Distribution Cost
- RevPAR = Room Revenue ÷ Rooms Available
- TRevPAR = Gross Revenue ÷ Rooms Available
- GOPPAR = Net Operating Profit ÷ Rooms Available
- Break-even Occupancy = Break-even Rooms ÷ Rooms Available
How to Use This Calculator
- Enter your total sellable rooms for the analysis period.
- Fill current pricing, occupancy, and competitor rate assumptions.
- Add demand, seasonality, channel cost, and cancellation values.
- Include ancillary revenue and operating cost assumptions.
- Click Optimize Revenue to generate performance metrics.
- Review the result cards above the form.
- Export your result set as CSV or PDF.
- Adjust inputs to compare scenarios and pricing strategies.