Occupancy by Slot: Bookings by Weekday and Time Band, Revenue per Available Slot
This lesson is part of the course
In this lesson
You count one room's bookings by weekday and time band with COUNTIFS, compare them with the slots on offer, and work out the occupancy of the week, the evening occupancy and the revenue per available slot.
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
- Slots per Day: Game Length, Reset Time and Opening Hours Locked
- Occupancy by Slot: Bookings by Weekday and Time Band, Revenue per Available Slot Locked
- Group Pricing: Price per Person by Group Size, Minimum Charges and Revenue per Player Locked
- Staffing: Game Masters per Concurrent Game and Staff Cost per Game Locked
- No-Shows & Deposits: No-Show Rates, Deposit Rules and Revenue Protected Locked
- Add-Ons & Corporate Bookings: Attach Rates, Margins and Profit per Booking Locked
- Seasonality: Monthly Demand, Staff Hours and Marketing Spend per Booking Locked
- New-Room Case: Build Cost, Expected Bookings, Payback and NPV Locked