RevPASH: Revenue per Available Seat Hour, by Day and Hour
This lesson is part of the course
In this lesson
You calculate RevPASH for six evenings, build a day × hour RevPASH grid with AVERAGEIFS and mixed references, find the Saturday average check and turn the grid into a heat map.
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
- Available Seat Hours and Seat Occupancy by Daypart Locked
- RevPASH: Revenue per Available Seat Hour, by Day and Hour Locked
- Table Turns and Dining Duration by Party Size Locked
- Party-Size Mix vs Table Sizes: Empty Seats and Seat Efficiency Locked
- Reservation Slots: Slot Length by Party Size and How Many Bookings Fit Locked
- No-Shows, Overbooking and the Walk-In Share Locked
- Floor Plan Scenarios: 2-Tops vs 4-Tops and Combinable Tables Locked
- Daypart Dashboard: RevPASH, Occupancy, Status and the Weakest Hours Locked