Suggestive Selling Script Book & Check Average Uplift Tracker: Server Upselling Scripts, Attach Rate Tracker and Check Average Uplift Calculator for Restaurants
Full description
For restaurant managers, food and beverage trainers and supervisors who want servers to offer the right item at the right moment, and want proof that it pays. The Word script book holds 19 selling standards and 36 scripts in six groups: starters, sides, desserts, beverages, wine and add-ons. Each script is a hook, a detail line and a closing line that offers a choice of two, with a pairing and a note on when not to use it. The main workbook logs covers, net sales, offers and items sold for each server and shift, compares check average before and after training, subtracts the uplift of untrained servers, and turns the result into incremental sales, gross profit and payback. The companion workbook runs a contest on one shift.
What is inside
- Check_Average_Uplift_Tracker.xlsx: 10 tabs, 3,980 formulas, 3 native charts, 18 drop-down and input rules, 9 integrity checks
- Script Library: 36 scripts in 6 groups with word count and rehearsal count; Rehearsal Plan: 20 sample sessions with coverage by group
- Server Log: 368 sample shifts plus 60 spare rows, 5 attach categories; Server Scorecard: 12 servers plus 6 spare rows with uplift, offers, conversion, rank and weakest category
- Uplift Analysis: trained against control, value and payback, attach by category, like-for-like mix, weekly trend and a scenario table; Dashboard with 9 tiles and 3 charts; Method with 12 rows
- Shift_Contest_Sheet.xlsx: 4 tabs, 293 formulas, contest set-up with a pre-shift checklist, tally sheet for 12 servers, leaderboard with awards and 6 checks
- Suggestive_Selling_Script_Book.docx and PDF: 9 pages with 19 standards, 36 scripts, a printable tally sheet, equations, a worked example, a four-week plan and contest rules
- README.txt and LICENSE-and-Terms.txt
How it works
- Set the baseline and post dates, targets, margin and costs on Settings, and list the servers.
- Train with the script book and rehearse one script a day.
- Enter one row per server and shift, with offers and items sold.
- Read the scorecard and the uplift analysis, and run a contest with the companion sheet.
Details
- Formats: 2 Excel workbooks (.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
- 4 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures.
- Targets, margin and costs are examples: set your own. An uplift is only credible when the baseline and the post period are alike.
- Single-user license. Do not redistribute.
FAQ
How is the uplift calculated?
Post check average minus baseline check average, as a share of the baseline. Untrained servers act as a control group, and their uplift is subtracted so a season effect does not count as selling.
Can I change the scripts?
Yes. The 36 scripts are editable on Script Library, and the word limit on Settings flags scripts that are too long.
What does the contest sheet do?
It tallies one shift for up to 12 servers, awards points per item and a bonus for the target check average, and ranks qualified servers.
How many shifts can I enter?
The sample has 368 rows and 60 spare rows. Insert rows above the last row and copy the formulas down; the named ranges stretch with the rows.
Do I need macros?
No. Every result is a standard worksheet formula.
