Enter Hotel Performance Data
Formula Used
Average Daily Rate: ADR = (Gross Room Revenue − Discounts − Included Taxes) ÷ Paid Rooms Sold
Effective Available Room Nights: Total Rooms × Days in Period − Out-of-Order Room Nights
Overall Occupancy: (Paid Rooms Sold + Complimentary Rooms) ÷ Effective Available Room Nights × 100
Paid Occupancy: Paid Rooms Sold ÷ Effective Available Room Nights × 100
RevPAR: Net Room Revenue ÷ Effective Available Room Nights
Target Revenue on Actual Paid Rooms: Target ADR × Paid Rooms Sold
ADR Variance vs Target: Actual ADR − Target ADR
Market ADR Index: Actual ADR ÷ Market ADR × 100
How to Use This Calculator
- Enter the reporting start date and the number of days in the review period.
- Add gross room revenue, then subtract discounts, refunds, and included taxes.
- Input paid rooms sold, complimentary rooms, total rooms, and any out-of-order room nights.
- Enter target ADR, market ADR, and weekend uplift for benchmarking and chart modeling.
- Press Calculate ADR to see results, chart trends, and exportable daily data.
Example Data Table
| Date | Paid Rooms Sold | Complimentary Rooms | Net Room Revenue | ADR | Occupancy | RevPAR |
|---|---|---|---|---|---|---|
| 2026-03-01 | 16 | 1 | $3,360.00 | $210.00 | 70.83% | $175.00 |
| 2026-03-02 | 15 | 0 | $3,075.00 | $205.00 | 62.50% | $153.75 |
| 2026-03-03 | 18 | 1 | $3,870.00 | $215.00 | 79.17% | $193.50 |
| 2026-03-04 | 20 | 1 | $4,400.00 | $220.00 | 87.50% | $220.00 |
| 2026-03-05 | 14 | 0 | $2,940.00 | $210.00 | 58.33% | $147.00 |
This sample table is illustrative. Your calculated daily table is generated after submission and can be exported.
Frequently Asked Questions
1. What does ADR measure?
ADR measures the average room revenue earned from paid occupied rooms only. It shows how effectively a hotel sells room nights, excluding complimentary stays and non-room revenue.
2. Why are taxes removed from ADR?
Taxes usually pass through the hotel and do not reflect pricing power. Removing included taxes gives a cleaner pricing metric for rate strategy, trend analysis, and market comparison.
3. Are complimentary rooms included in ADR?
No. Complimentary rooms affect occupancy but not ADR because ADR only uses paid rooms sold in the denominator. This keeps the pricing metric focused on paying demand.
4. What is the difference between ADR and RevPAR?
ADR measures average price on paid occupied rooms. RevPAR measures room revenue across all effective available room nights. RevPAR combines pricing and occupancy performance into one figure.
5. Why track out-of-order room nights?
Out-of-order room nights reduce true inventory. Adjusting for them improves occupancy and RevPAR accuracy, especially during maintenance, renovations, or seasonal room closures.
6. Can I use this for weekly or monthly periods?
Yes. Enter the correct number of days for your reporting window and use totals for revenue, paid rooms, comps, and unavailable inventory from that same period.
7. What is a good ADR target?
A good target depends on market demand, positioning, seasonality, distribution mix, and competition. Compare current ADR with internal goals, prior periods, and market ADR benchmarks.
8. Why does the chart show daily values from period totals?
The chart models daily distribution from the totals you enter. It helps with planning and visualization when exact day-by-day records are not supplied in the form.