Calculator Inputs
Example Data Table
| Scenario | Total Units | Reserved | Out of Service | Available | Occupied | Occupancy % |
|---|---|---|---|---|---|---|
| Residence Hall A | 120 | 8 | 5 | 107 | 92 | 85.98% |
| Apartment Block B | 80 | 4 | 2 | 74 | 61 | 82.43% |
| Clinic Ward C | 60 | 3 | 1 | 56 | 49 | 87.50% |
| Hotel Floor D | 150 | 10 | 6 | 134 | 111 | 82.84% |
Formula Used
1. Occupancy Percentage
Occupancy Percentage = (Occupied Units ÷ Available Units) × 100
2. Available Units
Available Units = Total Units − Reserved Units − Out of Service Units
3. Vacancy Percentage
Vacancy Percentage = (Vacant Units ÷ Available Units) × 100
4. Physical Occupancy Percentage
Physical Occupancy Percentage = (Occupied Units ÷ Total Units) × 100
5. Room-Night Occupancy
Room-Night Occupancy = (Occupied Room-Nights ÷ Available Room-Nights) × 100
This calculator supports inventory-style occupancy and time-based room-night occupancy, making it useful for housing, hospitality, healthcare, and utilization planning problems.
How to Use This Calculator
- Select Units Based or Room-Night Based calculation mode.
- Enter your inventory values, exclusions, and performance targets.
- Click Calculate Occupancy Percentage.
- Review the result cards shown above the form.
- Inspect the chart for a quick performance comparison.
- Use the CSV or PDF buttons to export the result summary.
- Compare current performance against target and previous occupancy.
- Use the additional-needed output for planning and forecasting.
8 FAQs
1. What does occupancy percentage measure?
It measures how much available capacity is actually in use. Higher values usually indicate stronger utilization, while lower values suggest unused inventory or weaker demand.
2. Why are reserved and out-of-service units excluded?
Those units are not truly available for assignment or sale. Excluding them gives a more realistic occupancy percentage based on usable inventory only.
3. What is the difference between physical and available occupancy?
Physical occupancy uses total units as the denominator. Available occupancy uses only usable units. Available occupancy is often more accurate for operational decisions.
4. When should I use room-night inputs?
Use room-night inputs when performance spans several days, weeks, or months. This method is common in hotels, hospitals, hostels, and other time-based occupancy settings.
5. Can this calculator help with forecasting?
Yes. It shows target gaps and additional occupied units or room-nights needed. That makes planning, staffing, pricing, and utilization decisions easier.
6. What happens if occupied units exceed available units?
The calculator flags it as an error. Occupied values should never be larger than usable inventory because that would distort the occupancy percentage.
7. Is this useful outside hospitality?
Yes. It can be used for apartments, dormitories, classrooms, wards, seats, desks, storage bays, and many other capacity management problems.
8. Why compare current occupancy with a previous rate?
Comparing with a previous rate highlights improvement or decline. It helps reveal momentum, seasonal change, and whether recent actions improved utilization.