How to calculate RevPAR? Hotel occupancy rate, ADR and RevPAR formulas
How to calculate RevPAR? Occupancy rate, ADR and RevPAR formulas with a small hotel example, which indicator to use for which decision, and common mistakes.
RevPAR is calculated by dividing a hotel’s total room revenue in a period by the number of rooms available for sale in the same period; the same result also comes from multiplying occupancy rate by ADR. Occupancy rate is the ratio of rooms sold to rooms available, and ADR is room revenue divided by rooms sold. Read together, the three indicators support more balanced pricing and occupancy decisions.
A hotel owner is comparing two months. In July nearly all the rooms were full but the till did not fill as much as expected; in August fewer rooms were sold but revenue looks better. Which month was more successful? Occupancy alone does not answer, because it ignores the price; average price alone does not answer, because it does not say how many rooms stayed empty. That is why in hospitality three indicators are read together: occupancy rate, ADR and RevPAR.
RevPAR (Revenue Per Available Room) is the revenue per room available for sale, found by dividing a hotel’s total room revenue in a period by the number of rooms available for sale in the same period. In this article we calculate the formulas of the three indicators step by step on a hypothetical hotel, and list which one to look at for which decision and the common mistakes.
How is occupancy rate calculated?
Occupancy rate is found by dividing the number of room nights sold by the number of room nights available for sale and converting the result to a percentage. The room nights available for sale are the number of rooms multiplied by the number of days. For example, in a 40-room hotel, in a 30-day month the room nights available for sale are 40 × 30 = 1,200. If 900 room nights were sold this month, occupancy is 900 ÷ 1,200 = 0.75, that is, 75 percent.
What is ADR and how is it calculated?
ADR (Average Daily Rate) is found by dividing room revenue by the number of room nights sold. The formula is room revenue ÷ room nights sold. What matters is that the denominator is sold rooms; empty rooms do not affect ADR. If the example hotel’s room revenue this month is 1,350,000, ADR is 1,350,000 ÷ 900 = 1,500.
How is RevPAR calculated? Two ways, the same result
You can find RevPAR in two ways: divide total room revenue by the number of room nights available for sale, or multiply the occupancy rate by ADR. For the same hypothetical hotel, the two ways give the same result.
| Indicator | Formula | Sample calculation | Result |
|---|---|---|---|
| Occupancy rate | Room nights sold ÷ room nights available | 900 ÷ 1,200 | 0.75 (75 percent) |
| ADR | Room revenue ÷ room nights sold | 1,350,000 ÷ 900 | 1,500 |
| RevPAR (way 1) | Room revenue ÷ room nights available | 1,350,000 ÷ 1,200 | 1,125 |
| RevPAR (way 2) | Occupancy × ADR | 0.75 × 1,500 | 1,125 |
Comparing two hotels: why look at RevPAR?
Hypothetical hotel A runs at 80 percent occupancy and an ADR of 1,000; hotel B at 60 percent occupancy and an ADR of 1,500. Someone looking at occupancy finds A successful, someone looking at price finds B successful. RevPAR comes out at 0.80 × 1,000 = 800 for A and 0.60 × 1,500 = 900 for B. For every room available for sale, B produces more revenue. Still, RevPAR does not show cost: if the cleaning, staff and energy cost per occupied room differs, the profitability ranking can change. That is why RevPAR is a compass that shows direction, not a profit statement.
Why should weekdays and weekends be read separately?
A single monthly RevPAR hides the differences within the same month. In a hypothetical hotel, if weekday occupancy is 60 percent and ADR is 1,100, weekday RevPAR is 660; if weekend occupancy is 95 percent and ADR is 1,800, weekend RevPAR is 1,710. The monthly average falls somewhere between the two and does not tell you that the rooms left empty on weekdays are the real problem. The shorter the periods and the narrower the segments for which the indicator is calculated, the more accurate the decision: look by day, weekend, season, room type and sales channel.
Which indicator to look at for which decision?
| Decision | Indicator to look at first | Why |
|---|---|---|
| Raising prices | ADR and occupancy together | If occupancy falls as the price rises, you need to check whether RevPAR is going up. |
| Running a promotion | Occupancy and RevPAR | RevPAR shows whether the rise in occupancy makes up for the price cut. |
| Comparing two periods | RevPAR | It combines occupancy and price in one figure. |
| Evaluating channels | ADR by channel | Channels that bring the same occupancy can have different average prices. |
| Comparing with last year | RevPAR with the same definitions | If the definition of available rooms changes from year to year, the comparison breaks. |
Common mistakes in the calculation
- Averaging daily occupancy percentages: period occupancy is found by dividing total room nights sold by total room nights available for sale.
- Using total revenue instead of room revenue: revenue such as restaurant and spa does not go into ADR and RevPAR.
- Counting out-of-service rooms one month and not the next: whichever you choose, use it consistently.
- Not deciding how to count complimentary or comped rooms.
- Mixing amounts with and without tax: choose a single method for revenue.
- Posting cancellation and no-show revenue to the wrong period.
What are the limits of these three indicators?
None of them gives the full picture on its own. An ADR calculated before channel commission is deducted shows net earnings higher than they are. In packages such as half board, whether the meal price is included in room revenue directly affects ADR. When the room type mix changes, for example when more suites are sold, ADR goes up, but you cannot see whether this is a price rise or a shift in the product mix. So write the definitions down once, use the same method in every period and note any changes.
Tracking occupancy, ADR and RevPAR in Excel
A daily sheet is enough: the date, rooms available for sale, rooms sold and room revenue columns are inputs, and the occupancy, ADR and RevPAR columns are formulas. At month end, take the column totals and recalculate the percentages from the totals. This setup works well in a small hotel where data is entered regularly from one place. Trouble starts when the number of rooms sold is carried by hand from one source and revenue from another, and when a breakdown by channel is wanted: a day is skipped, a cancellation is not deducted and the figures do not match. At that point it becomes hard to trust the numbers in the sheet.
| Column | What is entered | Formula |
|---|---|---|
| A: Date | The date of the day | Entered by hand |
| B: Rooms available | The number of rooms that can be sold that day | Entered by hand (according to your out-of-service decision) |
| C: Rooms sold | The number of rooms occupied that night | By hand or taken from the system |
| D: Room revenue | Accommodation revenue only | By hand or taken from the system |
| E: Occupancy | The share of rooms sold | =C÷B |
| F: ADR | Revenue per room sold | =D÷C |
| Month total: RevPAR | Total room revenue ÷ total rooms available | =total of D ÷ total of B |
- At month end, take the totals of columns B, C and D; do not average the daily percentages.
- Recalculate occupancy, ADR and RevPAR from these totals.
- Compare the number of rooms sold in the reservation record with the total in the sheet; if there is a difference, find it day by day.
- Do the same calculation for the same month last year and make sure the definitions have stayed the same.
How does YazSis hotel management support these indicators?
In the Reservation & Hotel Management platform, the reservation, room assignment, stay transactions and folio sit in the same record; occupancy, average rate, revenue, channel and operations indicators can be compared. Reports cover payment, balance, revenue and occupancy indicators. RevPAR is a result calculated from these indicators; we do not claim that there is a separate RevPAR screen in the platform, but having the required inputs come reliably from a single source makes the calculation easier. Which indicator to look at for which decision is for you to decide as the management team; the system’s job is to keep the numbers that will support that decision consistent and up to date.
If you want to measure where the reservation is taken, without moving reporting to Excel, you can request a demo on the hotel management page.
Frequently asked questions
Are ADR and average room price the same thing?
ADR is room revenue divided by the number of room nights sold. In some reports “average price” may be defined differently; make sure the denominator is sold rooms.
If RevPAR is high, is the hotel profitable?
Not necessarily. RevPAR is a revenue indicator; it does not include cost. If the cleaning, staff and energy cost per occupied room differs, the profitability ranking can change.
What occupancy percentage counts as good?
There is no universal threshold; it varies with the type of property, the location and the season. We do not give a number; compare with your own past periods and with similar properties using the same definitions.
Are out-of-service rooms included in the rooms available for sale?
This is a matter of definition and varies by business. Whichever you choose, use it consistently; otherwise periods cannot be compared.
Does a hotel management system calculate RevPAR?
The YazSis hotel platform reports occupancy, average rate and revenue indicators; RevPAR is a result calculated from these indicators.
More articles
How to do a warehouse stock count: methods, error sources and RFID in logistics
A truck is waiting at the dock, the list says 24 pallets, and the count says 23. We explain warehouse count methods, error sources and how to check before shipment without slowing down, including with RFID.
November 20, 2026 · 8 min readKOSGEB SME Digital Transformation Support in Turkey: eligibility, application, preparation
KOSGEB’s SME Digital Transformation Support Programme in Turkey is not a cash grant but support for interest costs. We summarise the official conditions, the application steps and the process inventory to prepare before applying.
November 20, 2026 · 9 min readWhat is IoT and what is it for? The Internet of Things in production and warehousing
IoT turns a physical event into data at its source and carries it to software. We explain the chain from sensor to screen in production and warehousing, the use cases, and the questions to ask before you start.
November 20, 2026 · 8 min read