Seasonal Occupancy: Occupied Nights by Month and Unit Type
This lesson is part of the course
In this lesson
You calculate occupancy for every month and unit type, pool July across the whole site and the glamping units across the season with SUMIFS, and count the rows that reach a fictional high-occupancy level.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Unit Mix: Pitches, Glamping Units and Available Nights Locked
- Seasonal Occupancy: Occupied Nights by Month and Unit Type Locked
- Rate Ladders: Season, Weekday vs Weekend and Length-of-Stay Discounts Locked
- Revenue per Available Unit-Night and Extras per Stay Locked
- Cost per Occupied Night: Utilities, Cleaning, Laundry and Commissions Locked
- Staffing by Season: Hours per Occupied Unit and Rota Cost Locked
- New Glamping Units: Investment, NPV, Payback and Break-Even Occupancy Locked
- Capstone: Season Dashboard by Month and Unit Type Locked