Calculation guide
Use room-only revenue and room nights from the same period. Exclude food, beverage and other revenue. Use available room nights after out-of-inventory adjustments.
revpar = revenue/available; occupancy = 100*sold/available
Inputs
Room revenue
Example entry 120000 (in the selected currency).
Available room nights
Example entry 1000. Minimum 1.0. Use whole numbers.
Sold room nights
Example entry 750. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Room revenue | 120,000 |
| Available room nights | 1,000 |
| Sold room nights | 750 |
| Result | Value |
|---|---|
| Revenue per available room night | 120 |
| Room occupancy | 75% |
Calculation steps
Revenue per available room night = (Room revenue ÷ Available room nights)
(120,000 ÷ 1,000) = 120
Room occupancy = ((100 × Sold room nights) ÷ Available room nights)
((100 × 750) ÷ 1,000) = 75%
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Room revenue | 120,000 | 132,000 | Revenue per available room night | 120 | 132 |
| Available room nights | 1,000 | 1,100 | Revenue per available room night | 120 | 109.090909 |
| Sold room nights | 750 | 825 | Room occupancy | 75% | 82.5% |
