Occupancy, ADR and RevPAR answer three different questions: how many available room nights were sold, what room revenue each sold room night earned on average, and what room revenue each available room night earned. This original fictional exercise helps a front-office trainee explain the numbers without confusing sales with profit.
Start with three matching inputs
Use room nights sold, room nights available and room revenue for the same hotel, dates, currency and reporting basis. For this exercise, all sold rooms are paid overnight stays; there are no complimentary rooms, house-use rooms or inventory exclusions. The supplied revenue is room revenue only, excluding taxes and other departments. These are exercise assumptions, not instructions to alter a hotel's reporting rules.
The Cloudbeds occupancy guide explains the basic relationships. In our exercise:
- Occupancy: room nights sold ÷ room nights available × 100.
- ADR, average daily rate: room revenue ÷ room nights sold.
- RevPAR, revenue per available room: room revenue ÷ room nights available.
Work through one night
A fictional hotel has 40 available rooms on Monday. It sells 20 room nights and earns AED 6,000 in room revenue. A room occupied by two people still contributes one room night here; guest count is not our denominator.
- Occupancy: 20 ÷ 40 × 100 = 50%.
- ADR: 6,000 ÷ 20 = AED 300.
- RevPAR: 6,000 ÷ 40 = AED 150.
Check the relationship using occupancy as a decimal: 300 × 0.50 = 150. Multiplying 300 by 50 would produce the wrong result. A useful spoken explanation is: “Half our available room nights sold. Each sold room night earned AED 300 on average; spreading the revenue across all available room nights gives AED 150.”
Combine two days using totals
On Tuesday the same hotel has 40 available room nights, sells 30 and earns AED 12,000. Tuesday's occupancy is 75%, ADR is AED 400 and RevPAR is AED 300. To describe both days together, add the original inputs before dividing.
- Available room nights: 40 + 40 = 80.
- Sold room nights: 20 + 30 = 50.
- Room revenue: 6,000 + 12,000 = AED 18,000.
- Two-day occupancy: 50 ÷ 80 × 100 = 62.5%.
- Two-day ADR: 18,000 ÷ 50 = AED 360.
- Two-day RevPAR: 18,000 ÷ 80 = AED 225.
A simple average of the daily ADRs gives AED 350, which is incorrect for this combined period: Tuesday sold more room nights at its higher average rate. As a cross-check, 360 × 0.625 = 225. Keep full precision during calculation and round the final displayed currency values.
Explain the limits before judging performance
These figures contain no operating expenses, so they do not establish profit. They also do not explain why demand or rates changed. Avoid inventing a market benchmark from this exercise.
For a real report, confirm the field definitions with the authorized report owner. Oracle's OPERA Cloud documentation shows configurable treatments for complimentary, house-use and unavailable rooms. Do not mix differently defined reports. If a denominator is zero or missing, investigate it rather than presenting a normal calculated average.
Practise by explaining why AED 350 is wrong without looking at the answer, then explore HCA front-office training for broader reception skills.
Explore HCA front-office training
