How To Calculate Occupancy Percentage For Hotel Rooms

A hotel manager wants to know how the weekend went. The property has 80 rooms and sold 68 of them on Saturday night. Occupancy percentage turns that into a number the whole team reads the same way. The math is quick, but the inputs must share one time window, or the rate misleads: a single night of sold rooms should never be divided by a month of open rooms. This guide walks through that weekend and pairs with the Ownership Percentage Calculator as a related business ratio tool, not an exact occupancy calculator.

How Do You Score A Night’s Occupancy?

Take the Saturday above: 68 rooms sold out of 80 open. Divide sold by open and multiply by 100: (68 ÷ 80) × 100 = 85 percent. That single figure lets the manager compare Saturday with last week, with the same night last year, or with the hotel down the road, as long as every figure uses rooms sold over rooms open for the same span.

Four checks keep it honest: match the dates, so a one-night count is not divided by a month of supply; fix the room base, deciding once whether closed rooms count and writing that rule beside the rate; keep price out, since a full hotel can still earn less when rooms sell too cheap; and treat the rate as a first check, because the math shows how many rooms sold, not why.

What Is The Occupancy Percentage Formula?

The occupancy rate formula compares used room base with total open room base. For a hotel, use used rooms or rooms sold as the numerator, and open rooms as the base. STR defines hotel occupancy as rooms sold divided by rooms open, multiplied by 100, which matches the standard hospitality convention.

Formula: occupancy rate = (used rooms ÷ open rooms) × 100.

Use rooms sold when the focus is hotel trading performance. Use used rooms when you are measuring physical use inside a site, such as student housing, office units, or event rooms. Keep complimentary rooms, out-of-order rooms, staff rooms, and blocked rooms consistent with the reporting rule your business uses.

How Do You Choose The Right Occupancy Inputs?

Occupancy rate only works when the numerator and base cover the same room base. If a hotel has 40 rooms open for 30 nights, the maximum room nights are 40 × 30 = 1,200 open room nights. If the hotel sold 900 room nights during the same month, then 900 is the used or sold room-night count.

For a single day, the input can be as simple as rooms sold and rooms open. For a month, use room nights instead of room count, because each room can be open on many nights. If rooms are closed for repair, decide whether your report treats them as unopen room base or as unsold rooms, then keep that rule consistent.

How Can You Calculate Occupancy In Excel?

Excel can work out occupancy rate with a basic division formula. Put used rooms or used room nights in one cell, put open rooms or open room nights in another cell, then divide the first value by the second. Microsoft explains that Excel rates are calculated as amount divided by total, then displayed with percent formatting.

Use this setup:

1. Put used room nights in cell A2.
2. Put open room nights in cell B2.
3. Enter =A2/B2 in cell C2.
4. Format C2 as Percentage.
5. Use one decimal place if your report needs a clean team view.

What Does Occupancy Percentage Tell A Hotel?

Occupancy rate tells a hotel how much open room supply was used, but it does not explain price, sales, or profit. A high rate can still produce weak results if rooms sell at heavy discounts. A lower rate can produce stronger sales if average daily rate rises enough to offset fewer sold rooms.

This is why hotel managers often review occupancy beside average daily rate and sales per open room. Occupancy answers the room base question. It does not answer whether the site priced rooms well, controlled costs, or served the right mix of guests.

Worked example: occupied room nights = 900, available room nights = 1,200.

Occupancy percentage = (900 ÷ 1,200) × 100. 900 ÷ 1,200 = 0.75. 0.75 × 100 = 75. Result: the occupancy rate is 75%, shown as 75.0% if the report uses one decimal.

When Should Occupancy Percentage Be Used?

Use occupancy rate when you need to compare occupancy across days, weeks, months, or properties. The metric works for hotels, short-stay rentals, rooms in a clinic, event spaces, or any business with a fixed number of units open for use. It helps teams spot soft spans and compare actual demand with room base.

Do not use occupancy rate as a profit measure. Occupancy ignores the rate charged, the cost to service each room, and the mix between paid, comped, and discounted stays. For financial decisions, pair occupancy with sales and cost metrics, then review the local market context. See the Finance Calculators hub for related tools.

Sources And Notes For Occupancy Percentage

• STR, Global Hotel Review glossary: occupancy is rooms sold divided by rooms available multiplied by 100
• Microsoft Support, Calculate percentages in Excel

This guide is for educational estimates only and is not accounting, legal, tax, or financial advice. Ask a qualified expert before making business decisions.