Skip to content
Workflow · People · Opening soon

Labor burden rate

Export your yearly payroll summary from Gusto and your workers comp rate list. Mammoth matches the role data, adds workers comp rates, then calculates each employee's labor burden rate, including payroll taxes, benefits, and workers comp.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Gusto payroll summary for the year
    CSV export · 15 rows
  2. File
    Gusto workers comp rate list
    CSV export · 15 rows
  3. Step
    Make payroll role key
    Step 2
  4. Step
    Make comp role key
    Step 1
  5. Join
    Add workers comp rates
    15 of 15 paired
  6. Step
    Calculate burden and hourly cost
    Step 4
  7. Result
    Employee Labor Burden
    15 rows
  8. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Employee Labor BurdenSample data15 rows
EmployeeLabor burden rate (%)Burdened hourly costLabor burdenWorkers compEmployer taxesBenefitsGross wagesHoursPayroll roleRate per 100 dollars of wages
Avery Lin19.783.8226,532.48564.4810,36815,600134,4001,920Senior Engineer0.4
Bianca Torres17.256.2615,530.95162.436,968.528,40090,2401,880Account Manager0.2
Caleb Nguyen18.459.2016,918.80220.807,0989,60092,0001,840Product Designer0.2
Diana Patel20.536.1610,834.08163.684,070.406,60052,8001,760Customer Support Specialist0.3
Ethan Brooks20.926.619,125.59487.873,357.725,28043,5601,980Warehouse Associate1.1
Farah Ahmed1942.8812,509.73124.835,064.907,32065,7001,824Marketing Coordinator0.2
Gabriel Stone19.164.3120,616.60291.608,32512,000108,0002,000Operations Manager0.3
Hana Kim20.450.5714,396.0277.625,438.408,88070,5601,680Bookkeeper0.1
Isaac Romero2035.9911,619.181,012.684,486.506,12058,2001,940Field Technician1.7
Jules Carter18.453.2814,152.77123.125,929.658,10076,9501,710HR Generalist0.2
Keira Shah19.151.0815,272.61111.996,160.629,00079,9951,865Sales Representative0.1
Leo Bennett18.559.2416,499.25178.506,870.759,45089,2501,785Data Analyst0.2
15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Employee Labor Burden workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your yearly payroll summary from Gusto and your workers comp rate list. Mammoth matches the role data, adds workers comp rates, then calculates each employee's labor burden rate, including payroll taxes, benefits, and workers comp. The output gives you burden as a percent of wages and as a burdened hourly cost.
Which export file should you use?
Use the payroll summary export for the year and the workers comp rate list export. If a workflow needs more than one file, upload each export separately.
What happens to rows that do not match?
Rows that do not match a rule are left out of that step's result unless you add a rule for them. You can review those rows and decide whether to fix the source data or change the matching rule.
How do you change the rules?
Change the rules by editing the matching words, the mapped columns, or the calculation steps. You can make the match broader or narrower, then rerun the workflow on the same exports.

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.

Early access opens shortly. Check back soon.

Workflows like this

Match payroll to time sheets, track headcount and hiring, and see what changed since last month.

All people and payroll workflows →