Restaurant sales by menu item
“use the toast sales export and cost list to calc gross profit as net sales minus standard cost times sold, then show items by quantity and gross profit and label star, plowhorse, puzzle, or dog”
use the Toast menu item sales export and Toast menu item cost list to calc gross profit as net sales minus standard cost times sold, then show items by quantity and gross profit and label star, plowhorse, puzzle, or dog, using 70% of average quantity and average unit gross profit as the standard cutoffs.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileToast menu item sales exportCSV export · 24 rows
- FileToast menu item cost listCSV export · 8 rows
- StepTotal sales by itemStep 1
- StepMake cost item keyStep 2
- JoinBring in standard cost8 of 8 paired
- StepClassify menu itemsStep 4
- ResultMenu Item Profitability8 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows.
- Download Toast menu item sales export sample (24 rows)Toast: Reports > Sales > Sales by Menu Item > Export
- Download Toast menu item cost list sample (8 rows)Toast: Back Office > Menus > Menu Items > Export
What you get back
The result of that run, the rows to look at first.
| Menu Item | Quantity sold | Gross profit | Menu label | Unit gross profit | Net sales | Standard cost |
|---|---|---|---|---|---|---|
| Beet Salad | 9 | 68.40 | Dog | 7.60 | 117 | 5.40 |
| Braised Short Rib | 16 | 320.12 | Puzzle | 20.01 | 516.12 | 12.25 |
| Seasonal Lobster Roll | 4 | 70 | Puzzle | 17.50 | 128 | 14.50 |
| House Fries | 84 | 359.20 | Plowhorse | 4.28 | 413.80 | 0.65 |
| Craft Soda | 48 | 172.80 | Plowhorse | 3.60 | 189.60 | 0.35 |
| Grilled Chicken Sandwich | 27 | 259.14 | Plowhorse | 9.60 | 423.84 | 6.10 |
| Tomato Soup | 24 | 184.32 | Plowhorse | 7.68 | 213.12 | 1.20 |
| Margherita Pizza | 22 | 264.32 | Star | 12.01 | 369.92 | 4.80 |
How do you rank menu items by quantity sold and gross profit?
Upload the Toast menu item sales export and the Toast menu item cost list export. Mammoth calculates gross profit as net sales minus standard cost times quantity sold, then sorts items by quantity sold and gross profit and labels each one as a star, plowhorse, puzzle, or dog using 70% of average quantity and average unit gross profit as the cutoffs.
How it works
How to use the Menu Item Profitability workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Menu Item Profitability: questions
What export should I use from Toast?
What happens to rows that do not match?
How do I change the classification rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent