The formula for calculating the Average Room Rate in hotels is as follows:
Average room rate = Total rooms revenue ÷ Number of rooms sold.
When calculating, hoteliers generally include only revenue-generating rooms and exclude any complimentary rooms or out-of-order rooms, which do not contribute to room revenue.
For example, imagine a 10-room bed-and-breakfast with the following situation:
- Rooms sold: 8 rooms on a Saturday
- Total room revenue: $2,400
Now apply the ARR formula:
- ARR = Total Room Revenue ÷ Number of Rooms Sold
- ARR = $2,400 ÷ 8 rooms
- ARR = $300
So, the Average Room Rate for that night is $300, which means that, on average, each occupied room earned $300.
Occasionally, hotel managers may include occupied, but non-revenue-generating rooms. Imagine that two additional rooms were occupied by staff or given as complimentary that night, the manager might calculate ARR as:
$2,400 ÷ 10 = $240
In this case, the ARR drops to $240 when non-revenue rooms are included, showing how complimentary or staff rooms affect overall room performance.
Hoteliers typically track ARR (or ADR) at regular intervals to gauge performance over time. It’s a simple but powerful formula that helps hotel managers spot trends in revenue early and respond quickly to changing conditions in the market.