How to use the occupancy rate calculator
This calculator estimates how effectively a hotel, serviced apartment building, vacation-rental portfolio, hostel, or similar lodging property uses the rooms that are available for sale. It starts with room inventory and produces occupancy rate, vacancy rate, room-night totals, estimated room revenue, revenue per available room, and a like-for-like market comparison. The calculation is most useful when every input describes the same operating period and the room counts are measured consistently.
What each input means
Period controls the reporting horizon. Daily uses one day, weekly uses seven days, monthly uses 30 days, and yearly uses 365 days. Choose Custom when you need an exact number of days, such as a 28-day accounting period or a 92-day season. The period does not change the occupancy percentage when daily room counts are constant; it scales room-nights and revenue totals.
Rooms occupied per day is the average number of sellable rooms used by guests on a typical day in the selected period. For a monthly report, divide total occupied room-nights by the number of days rather than entering the month’s cumulative bookings. A higher value raises occupancy, revenue, and RevPAR. It cannot exceed rooms available for sale.
Rooms unavailable per day covers rooms taken out of inventory for maintenance, renovation, safety issues, owner use, or other operational restrictions. These rooms are excluded from the occupancy denominator because they could not be sold. Use an average daily figure when availability changed during the period. Entering every physical room as available can understate operational occupancy.
Total rooms is the property’s full physical inventory. It must be greater than the unavailable count. Adding rooms without adding demand lowers occupancy; taking rooms out of service reduces sellable capacity and may increase the occupancy percentage even though it does not create more guests.
Average daily rate (ADR) is the average room revenue per occupied room-night, excluding taxes and non-room revenue unless your internal reporting convention says otherwise. ADR drives room revenue and RevPAR but does not change occupancy. Use a realized rate, not a posted rack rate. The average daily rate overview explains how ADR is commonly interpreted.
Competitor or market occupancy is optional. Enter a percentage from a comparable property set, destination report, management account, or other credible benchmark. A useful benchmark should match the same location, property type, quality tier, and period. Seasonal resorts should not compare a peak month with an annual average.
How the formulas work
Occupancy rate = Occupied rooms ÷ Available rooms × 100
Room revenue = Occupied rooms × ADR × Period days
RevPAR = Room revenue ÷ Available room-nights
Available room-nights equal available rooms multiplied by period days. Occupied room-nights use the same structure. RevPAR can also be calculated as ADR multiplied by occupancy expressed as a decimal. Because RevPAR combines price and utilization, it is often a more complete revenue-efficiency measure than occupancy alone. Industry practitioners commonly track occupancy, ADR, and RevPAR together rather than treating any one metric as sufficient.
How to read the results
Occupancy rate is the share of sellable rooms occupied. A high percentage may indicate strong demand, constrained capacity, or aggressive discounting; it is not automatically proof of high profitability. A zero rate means no rooms are occupied, while a rate near 100% may justify reviewing pricing and displacement of higher-value demand.
Available rooms per day shows the denominator used in the calculation. Occupied room-nights scales daily occupancy across the reporting period. Room revenue is a planning estimate based on average occupancy and ADR; it excludes food and beverage, parking, resort fees, cancellations, taxes, commissions, and other adjustments unless those amounts are embedded in the rate.
RevPAR measures room revenue per sellable room-night. It falls when either occupancy or ADR declines. Vacancy rate is the complement of occupancy and helps visualize unused sellable capacity. Revenue below full occupancy is the theoretical difference between current room revenue and revenue at 100% occupancy at the same ADR. It is not a guaranteed opportunity because full occupancy may require lower pricing or additional distribution costs.
The donut chart shows occupied and vacant sellable rooms from the same model used by the results and Excel workbook. The comparison table applies the market occupancy percentage to your current available-room inventory and ADR. Positive differences mean your property is above the benchmark; negative differences mean it is below. Review percentage-point differences separately from dollar differences.
Practical interpretation and common mistakes
Do not compare properties using occupancy alone. A hotel with lower occupancy can produce stronger revenue if its ADR is sufficiently higher. Also avoid mixing rooms sold with guests, reservations, or beds: the numerator and denominator must use the same unit. For monthly or annual reporting, use room-nights rather than a simple count of reservations. Long stays occupy multiple room-nights, while a canceled reservation may occupy none.
Operational definitions matter. Some organizations exclude complimentary rooms, house use, or out-of-order inventory differently. Keep a documented policy and apply it consistently. The U.S. Census Bureau’s Economic Census provides broader industry context, while the U.S. Bureau of Labor Statistics publishes information about lodging management operations. For hospitality-focused research and operating concepts, the Cornell Center for Hospitality Research is another useful resource.
Use scenario analysis rather than chasing a single “good” occupancy number. Test how a price increase, temporary room closure, or demand change affects RevPAR and total room revenue. A balanced strategy seeks the best economic outcome after distribution costs, labor, maintenance, and guest experience—not simply the highest possible percentage.