Host Stand, Seating Rotation & Waitlist Quote Kit: Host Log, Waitlist Quote Times and Server Rotation in Excel and Word
Full description
For restaurant hosts, outlet managers and food and beverage directors who want guests quoted an honest wait and servers seated fairly. The workbook logs every party (225 sample parties over 5 evenings), quotes walk-in waits from parties ahead, average table turn and tables in service, and compares each quote with the actual wait. It shows covers by server against the average, covers by section, the reservation and walk-in mix by hour, the walk-away rate and the no-show rate with a hold policy. The Word guide sets the host stand procedure: set-up checklist, 12 greeting scripts, reservation and phone scripts, seating rules, the quote method with a worked example read from the workbook, hold rules and printable forms.
What is inside
- Host_Stand_Rotation_and_Waitlist_Kit.xlsx: 7 tabs, 2,233 formulas, 2 native charts, 13 drop-down and input rules
- Host Log: 225 sample parties plus 50 spare rows, 19 columns with wait, quote error, dwell and turn checks
- Quote Engine: live quote for 3 table bands, a 10-row quote grid, quote accuracy by band, no-show rate and hold policy
- Rotation: 8 servers with fairness index and next-up order, 4 sections, 5-hour reservation and walk-in mix
- Dashboard: 7 KPI tiles, a check tile, a nightly table and 2 charts; 8 integrity checks
- Host_Stand_Procedure_and_Scripts.docx and PDF: 8 pages with set-up checklist, 12 greeting scripts, quote method, hold policy, end-of-shift checklist and 3 forms
- README.txt and LICENSE-and-Terms.txt
How it works
- Enter your table bands, turn times and quote rules on Settings.
- Log each party at the stand; type parties ahead on Quote Engine and say the quote shown.
- Seat the next party with the server at the top of the Next-up order on Rotation.
- Review quote accuracy, walk-aways, no-shows and the hour mix on the Dashboard each week.
Details
- Formats: 1 Excel workbook (.xlsx), 1 Word guide (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 3 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures.
- Turn times, quote rules and thresholds are examples. Use your own floor data and verify local requirements, including rules on keeping guest contact details.
- Single-user license. Do not redistribute.
FAQ
How is the quote calculated?
Parties ahead times the average turn for the table band, divided by the tables of that size in service, plus a buffer, rounded up to the next 5 minutes. Every value is an input on Settings.
Can I use it for more than one outlet?
Use one copy of the workbook per outlet. Settings hold one floor plan.
What does the fairness index measure?
A server's covers divided by the average covers per server. The heavy and light limits are inputs.
How many parties can the log hold?
The sample has 225 parties and 50 spare rows. Insert rows above the last row to add more; formulas copy down.
Do I need macros?
No. Every result is a standard worksheet formula.
