Workflow · People · Opening soon

Labor cost as percent of sales

Use your Toast weekly labor cost by location and weekly sales by location exports. The workflow matches the same location and week, then calculates labor cost share.

Book a demo

Someone typed

“calculate labor cost as a percentage of sales by location and week”

The agent read it as

Calculate labor cost as a percentage of sales by location and week from Toast weekly labor cost by location and Toast weekly sales by location.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

File

Toast weekly sales by location

CSV export · 24 rows

File

Toast weekly labor cost by location

CSV export · 24 rows

Step

Prepare sales keys

Step 1

Step

Prepare labor keys

Step 2

Join

Add weekly labor cost

24 of 24 paired

Step

Calculate labor share

Step 4

Result

Weekly Labor Cost Share

24 rows

Schedule

Runs when you say

Proposed

File
Toast weekly sales by location
CSV export · 24 rows
File
Toast weekly labor cost by location
CSV export · 24 rows
Step
Prepare sales keys
Step 1
Step
Prepare labor keys
Step 2
Join
Add weekly labor cost
24 of 24 paired
Step
Calculate labor share
Step 4
Result
Weekly Labor Cost Share
24 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 24 rows came out, and the join paired 24 of 24 rows.

Download Toast weekly sales by location sample (24 rows)Toast: Reports > Sales > Sales Summary > Export
Download Toast weekly labor cost by location sample (24 rows)Toast: Reports > Labor > Labor Summary > Export

What you get back

The result of that run, the rows to look at first.

Weekly Labor Cost ShareSample data24 rows

Location	Week	Labor cost % of sales	Labor Cost	Net Sales
Harbor Street	2026-09-16	26.9	11,320	42,150
Midtown	2026-09-16	24.2	9,400	38,840
Riverview	2026-09-16	30.5	10,850	35,620
Harbor Street	2026-09-23	27.4	12,010	43,890
Midtown	2026-09-23	24.7	9,905	40,110
Riverview	2026-09-23	30.2	11,240	37,250
Harbor Street	2026-09-30	28.8	12,880	44,780
Midtown	2026-09-30	12	4,750	39,560
Riverview	2026-09-30	32.1	11,610	36,190
Harbor Street	2026-10-07	29.1	13,340	45,910
Midtown	2026-10-07	24.5	10,120	41,240
Riverview	2026-10-07	31.8	12,030	37,880

24 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you calculate labor cost as a percentage of sales by location and week?

Export your weekly labor cost by location and weekly sales by location from Toast, then upload both files. The workflow prepares the location and week keys, adds labor cost to sales, and calculates labor cost share for each location and week. You get labor cost share by location and week as the result.

How it works

How to use the Weekly Labor Cost Share 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 Labor Cost Share: questions

What export files should you use?

Use the exported files that contain weekly labor by location and weekly sales by location. The rows need a location and a week so they can be matched.

What happens to rows that do not match?

Rows that do not have a matching location and week in the other file are left out of the combined result. Only rows that can be matched are used for the calculation.

How do you change the rules?

You change the rules in words by editing which columns are used to match rows and what calculation is applied after the match. Then rerun the workflow with the updated instructions.