Labor burden rate
“calculate each employee's labor burden rate: payroll taxes, benefits and workers comp on top of wages, as a percent of wages and as a burdened hourly cost”
Calculate each employee's labor burden rate: payroll taxes, benefits and workers comp on top of wages, as a percent of wages and as a burdened hourly cost, using Gusto payroll summary for the year and Gusto workers comp rate list.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileGusto payroll summary for the yearCSV export · 15 rows
- FileGusto workers comp rate listCSV export · 15 rows
- StepMake payroll role keyStep 2
- StepMake comp role keyStep 1
- JoinAdd workers comp rates15 of 15 paired
- StepCalculate burden and hourly costStep 4
- ResultEmployee Labor Burden15 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out, and the join paired 15 of 15 rows.
- Download Gusto payroll summary for the year sample (15 rows)Gusto: Payroll > Reports > Payroll Summary > Export CSV
- Download Gusto workers comp rate list sample (15 rows)Gusto: Company > Insurance > Workers' Compensation > Rate details > Export
What you get back
The result of that run, the rows to look at first.
| Employee | Labor burden rate (%) | Burdened hourly cost | Labor burden | Workers comp | Employer taxes | Benefits | Gross wages | Hours | Payroll role | Rate per 100 dollars of wages |
|---|---|---|---|---|---|---|---|---|---|---|
| Avery Lin | 19.7 | 83.82 | 26,532.48 | 564.48 | 10,368 | 15,600 | 134,400 | 1,920 | Senior Engineer | 0.4 |
| Bianca Torres | 17.2 | 56.26 | 15,530.95 | 162.43 | 6,968.52 | 8,400 | 90,240 | 1,880 | Account Manager | 0.2 |
| Caleb Nguyen | 18.4 | 59.20 | 16,918.80 | 220.80 | 7,098 | 9,600 | 92,000 | 1,840 | Product Designer | 0.2 |
| Diana Patel | 20.5 | 36.16 | 10,834.08 | 163.68 | 4,070.40 | 6,600 | 52,800 | 1,760 | Customer Support Specialist | 0.3 |
| Ethan Brooks | 20.9 | 26.61 | 9,125.59 | 487.87 | 3,357.72 | 5,280 | 43,560 | 1,980 | Warehouse Associate | 1.1 |
| Farah Ahmed | 19 | 42.88 | 12,509.73 | 124.83 | 5,064.90 | 7,320 | 65,700 | 1,824 | Marketing Coordinator | 0.2 |
| Gabriel Stone | 19.1 | 64.31 | 20,616.60 | 291.60 | 8,325 | 12,000 | 108,000 | 2,000 | Operations Manager | 0.3 |
| Hana Kim | 20.4 | 50.57 | 14,396.02 | 77.62 | 5,438.40 | 8,880 | 70,560 | 1,680 | Bookkeeper | 0.1 |
| Isaac Romero | 20 | 35.99 | 11,619.18 | 1,012.68 | 4,486.50 | 6,120 | 58,200 | 1,940 | Field Technician | 1.7 |
| Jules Carter | 18.4 | 53.28 | 14,152.77 | 123.12 | 5,929.65 | 8,100 | 76,950 | 1,710 | HR Generalist | 0.2 |
| Keira Shah | 19.1 | 51.08 | 15,272.61 | 111.99 | 6,160.62 | 9,000 | 79,995 | 1,865 | Sales Representative | 0.1 |
| Leo Bennett | 18.5 | 59.24 | 16,499.25 | 178.50 | 6,870.75 | 9,450 | 89,250 | 1,785 | Data Analyst | 0.2 |
How it works
How to use the Employee Labor Burden 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.
Employee Labor Burden: questions
How do you calculate labor burden rate from Gusto exports?
Which export file should you use?
What happens to rows that do not match?
How do you change the 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
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- First pass yield by lineCalculate first pass yield for each production line and week from an Excel export of your production log.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent