Restaurant Seat & Table Management: RevPASH, Table Turns, Party-Size Mix, Reservations vs Walk-Ins, No-Shows & Floor-Plan Optimisation
Earn more from the seats you already have. You will measure revenue per available seat hour, seat occupancy and table turns by daypart, match table sizes to party sizes, set reservation slot lengths, handle no-shows and walk-ins and test a new floor plan, all with fictional restaurants and every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course works through the seat and table numbers of a fictional 64-seat bistro in spreadsheet labs that check every cell. You turn a covers log into seat hours and seat occupancy by daypart with SUMIFS, calculate RevPASH and build a day-by-hour heat map with AVERAGEIFS, measure dining minutes and table turns, and match party sizes to the smallest table that fits with XLOOKUP. You set reservation slot lengths, count how many bookings fit an evening with INT and flag overlaps, pool no-show rates, size overbooking with a probability table, compare a floor plan with more combinable 2-tops and finish with a daypart dashboard, status labels and a chart.
Lessons
- Available Seat Hours and Seat Occupancy by Daypart Pro
- RevPASH: Revenue per Available Seat Hour, by Day and Hour Pro
- Table Turns and Dining Duration by Party Size Pro
- Party-Size Mix vs Table Sizes: Empty Seats and Seat Efficiency Pro
- Reservation Slots: Slot Length by Party Size and How Many Bookings Fit Pro
- No-Shows, Overbooking and the Walk-In Share Pro
- Floor Plan Scenarios: 2-Tops vs 4-Tops and Combinable Tables Pro
- Daypart Dashboard: RevPASH, Occupancy, Status and the Weakest Hours Pro