Occupancy rate calculator

The calculation, and the trap inside it

Occupancy is room nights sold divided by room nights available. Available nights are rooms multiplied by days, so a 32-room property over a 30-day month has 960 of them — and if you sold 636, you ran at 66.3%.

The trap is in the numerator. Room nights are not bookings. A guest who takes one room for four nights is four room nights, and a property that counts reservations instead will report roughly a third of its true occupancy and then spend a season worrying about a problem it does not have. If your figure looks impossibly low, this is almost always why.

Why a percentage is a bad unit for a decision

“We are at 66%” does not tell you whether to spend ₱40,000 on a promotion. “Each point is 9.6 nights, which at our rate is ₱37,000 a month” does — and it is the same fact, converted into the currency the decision is actually made in.

That conversion is what the third figure above is for. It reframes the whole question: a listing that lifts you two points over a year is not a marketing line, it is a number you can compare against what the listing costs. Most of the arguments hoteliers have about occupancy are really arguments about money that nobody has converted yet.

Seasonality, and why an annual average misleads

A Philippine property with a pronounced season does not experience its average. Run at 88% from December to May and 41% through the habagat months and the year averages somewhere in the sixties — a figure that describes no month you actually lived through and hides both the months where you should have charged more and the months where the payroll was the problem.

Calculate it per month. Compare each month against the same month last year rather than against the month before, so the seasonality cancels out instead of drowning the signal. A property that only ever looks at the annual number is flying on an instrument that averages the mountain and the valley into level ground.

What high occupancy costs

Every occupied room consumes linen, water, power, amenities and about the same amount of housekeeping time whether it was sold at ₱2,000 or ₱5,000. This is why occupancy bought with discounts is more expensive than it looks: the revenue falls with the rate while the cost per occupied room does not move at all.

It is also why the honest answer to “what occupancy should I target” is that the question is the wrong shape. There is a rate at which filling the last few rooms costs you money, and finding it matters more than any target.

Questions, answered

How do you calculate hotel occupancy rate?

Divide the room nights you sold by the room nights you had available, then multiply by 100. Available nights are rooms × days: a 32-room property over 30 days has 960 available nights, so 636 sold is 66.3%.

Is occupancy the number I should be trying to raise?

Not on its own. Occupancy is easy to raise by cutting rates, and a full property earning less than a half-full one is a real outcome, not a hypothetical. Raise RevPAR — occupancy is one of the two things that moves it.

What is a good occupancy rate for a small Philippine hotel?

It depends on where you are and when. A Puerto Galera resort lives with a wide gap between the dry-season peak and the habagat months, and a healthy annual average there looks different from a city hotel with steady weekday business. Compare against your own last year rather than a national figure.

Should I count a room that is out of service?

Most operators exclude a room that genuinely cannot be sold — under renovation, flooded, awaiting a part. The important thing is consistency, because switching between definitions makes your own trend unreadable.