Workflow · Finance close · Opening soon
Restaurant food cost percentage
See weekly food cost percentage by location from exported sales and purchase files. Compare food purchases with food sales using the same location key.
Someone typed
“calculate food cost percentage by week: food purchases divided by food sales, by location”
The agent read it as
Calculate food cost percentage by week: Weekly food purchases by location divided by Weekly food sales by location, by location.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Weekly food sales by location
CSV export · 24 rows
File
Weekly food purchases by location
CSV export · 24 rows
Step
Make sales location key
Step 1
Step
Make purchase location key
Step 2
Join
Bring in food purchases
24 of 24 paired
Step
Calculate food cost percentage
Step 4
Result
Weekly Location Food Cost
24 rows
Schedule
Runs when you say
Proposed
- FileWeekly food sales by locationCSV export · 24 rows
- FileWeekly food purchases by locationCSV export · 24 rows
- StepMake sales location keyStep 1
- StepMake purchase location keyStep 2
- JoinBring in food purchases24 of 24 paired
- StepCalculate food cost percentageStep 4
- ResultWeekly Location Food Cost24 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 24 of 24 rows.
- Download Weekly food sales by location sample (24 rows)Toast: Reports > Sales > Sales Summary > Export
- Download Weekly food purchases by location sample (24 rows)Toast: Reports > Purchasing > Purchases Summary > Export
What you get back
The result of that run, the rows to look at first.
Weekly Location Food CostSample data24 rows
| Location | Week | Food cost percentage | Food purchases | Food sales |
|---|---|---|---|---|
| Harbor Grill | 2026-09-21 | 27.14 | 7,600 | 28,000 |
| Lakeside Kitchen | 2026-09-21 | 23.64 | 5,200 | 22,000 |
| Midtown Market | 2026-09-21 | 26.15 | 6,800 | 26,000 |
| Harbor Grill | 2026-09-28 | 26.91 | 7,400 | 27,500 |
| Lakeside Kitchen | 2026-09-28 | 23.72 | 5,100 | 21,500 |
| Midtown Market | 2026-09-28 | 27.06 | 6,900 | 25,500 |
| Harbor Grill | 2026-10-05 | 26.90 | 7,800 | 29,000 |
| Lakeside Kitchen | 2026-10-05 | 23.48 | 5,400 | 23,000 |
| Midtown Market | 2026-10-05 | 26.30 | 7,100 | 27,000 |
| Harbor Grill | 2026-10-12 | 26.89 | 8,200 | 30,500 |
| Lakeside Kitchen | 2026-10-12 | 13.89 | 2,500 | 18,000 |
| Midtown Market | 2026-10-12 | 26.42 | 7,000 | 26,500 |
How do you calculate food cost percentage by week?
Export weekly food sales and weekly food purchases from Toast. Match both files by location, then divide food purchases by food sales for each week and location. The result is a weekly food cost percentage by location.
How it works
How to use the Weekly Location Food Cost 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.
Weekly Location Food Cost: questions
Which export should you use?
Use the export that includes weekly food sales by location, and the export that includes weekly food purchases by location. If your source file has different column names, map the columns that hold location, week, purchases, and sales.
What happens to rows that do not match?
Rows that do not match on the location key stay out of the percentage result. You can review those rows in the source files, then fix the location names or keys and run the workflow again.
How do you change the rules?
Change the rule text in plain words, for example, use a different location key, a different week field, or a different formula. Then rerun the workflow so it applies the new rules to the exported files.
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