Scribd
Upload
127 views2 pages

Labor Burden Calculation: Data Input

This document outlines the components used to calculate an employee's total labor burden, including their annual gross wages, applicable tax rates, and costs for benefits like insurance, paid time off, and workers compensation. Key details include the employee's hourly rate and weekly hours, applicable tax rates for FUTA, SUTA and FICA, and benefit costs for items such as health insurance, paid holidays, vacation, and sick time. The calculation determines the total annual cost to the company for the employee and the additional cost per hour of work once benefits and taxes are included.

Uploaded by

selvamejia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
127 views2 pages

Labor Burden Calculation: Data Input

This document outlines the components used to calculate an employee's total labor burden, including their annual gross wages, applicable tax rates, and costs for benefits like insurance, paid time off, and workers compensation. Key details include the employee's hourly rate and weekly hours, applicable tax rates for FUTA, SUTA and FICA, and benefit costs for items such as health insurance, paid holidays, vacation, and sick time. The calculation determines the total annual cost to the company for the employee and the additional cost per hour of work once benefits and taxes are included.

Uploaded by

selvamejia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 2

Labor Burden Calculation

Data Input:
Employee's Name
Hours per Week - Straight Time
Hours per Week - Overtime
Weeks per Year
Average Hourly Rate

40.00
0.00
52.00

Bonus and/or Incentives


Other Compensation - Description
Other Compensation

0.00

Federal Unemployment Rate (FUTA)


FUTA Maximum Compensation
State Unemployment Rate (SUTA)
SUTA Maximum Compensation
FICA Rate
FICA Maximum Compensation
Workers' Compensation Rate
Workers' Compensation Max Comp
Other Description
Other Rate

0.80%
7,000.00
3.13%
7,000.00
7.65%
75,000.00
3.00%

Insurance 1 - Description
Cost
Insurance 2 - Description
Cost
Insurance 3 - Description
Cost
Insurance 4 - Description
Cost
Other Cost Description
Other Cost Amount (Monthly)
Holiday Pay Days
Holiday Hours per Day
Vacation Pay Days
Vacation Hours per Day
Sick Pay Days
Sick Pay Hours per Day
Break/Clean-up Hours per day
Other - Description
Other Days per Year
Other Hours per Day

0.00
0.00
8.00
0.00
8.00
0.00
8.00
0.50

Labor Burden Calculation


0.00
1 Annual Gross Wages
Overtime
2 Bonus and/or Incentives
3

Hours
40.00
0.00

# Weeks
52.00
52.00

Ave Rate
0.00
0.00

4 Total Annual Pay

0.00
Max

5 Burden Uplift
a
FUTA
b
SUTA
c
FICA
d
Workers' Comp
e
f

Amount
0.00
0.00
0.00

Rate
0.00
0.00
0.00
0.00

0.80%
3.13%
7.65%
3.00%

Total Burden

0.00
0.00
0.00
0.00

0.00

6 Subtotal (Line 4 and Line 5)

0.00
Mo Amount

8
9 Total Annual Company Cost

0.00
Days

10
11
12
13
14
15

Annual Paid Hours


Holiday Pay
Vacation Pay
Sick Pay
Breaks

n/a
0.00
0.00
0.00
260.00
0.00

Hours
n/a
8.00
8.00
8.00
0.50

16 Total Productive Hours


Line 9 / Line 16

1,950.00
Cost to Company for Each Hour ON THE JOB

Labor Burden Rate

0.00
#DIV/0!

RECAP
Total Amount paid to you and to others on your behalf
Total Annual Gross Salary/Wages (from above)
Additional amount paid by the Company on your behalf
Additional cost per hour ON THE JOB (including overtime premium pay)

Confidential

Hours
2,080.00
0.00
0.00
0.00
-130.00

07/02/2016 By Art House

0.00
0.00
0.00
0.00

Page 2

You might also like