Group Pricing: Price per Person by Group Size, Minimum Charges and Revenue per Player
This lesson is part of the course
In this lesson
You look up the price per person for each group size with XLOOKUP, apply a minimum charge per booking with MAX, add up a month of revenue with SUMPRODUCT and work out the average revenue per player.
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