| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | Real Cost of New Team Member (estimated) | |||||
3 | ||||||
4 | Input a $-amount for any cell that is outlined with a dotted border for the calculator to work ---> | |||||
5 | An "R" before the input is a Required value and a "O" is Optional | |||||
6 | All inputs should be $-money based | |||||
7 | National Average Costs | |||||
8 | R | What is the expected yearly salary for your employee? | Use this area to contextualize the question | |||
9 | ||||||
10 | PRE-HIRE | |||||
11 | R | What are your recruitment costs? | $0 | $3,665/hire | ||
12 | O | Do you plan on having a background check? | $0 | $20-100/hire | ||
13 | O | Do you plan on drug testing? | $0 | $30-50/test | ||
14 | PRE-HIRE SUBTOTAL | $0 | $3715-$3815 | |||
15 | ||||||
16 | TAX/COMPLIANCE | |||||
17 | Unemployment Insurance (6.2% of first $7,000) | $434 | $434 | |||
18 | Year End Tax Prep (W-2) | $50 | $50 | |||
19 | FICA Payroll Tax (Social Security) | $0 | 6.2% of Salary | |||
20 | Medicare | $0 | 1.45% of Salary | |||
21 | TAX/COMPLIANCE SUBTOTAL | $484 | ||||
22 | ||||||
23 | ||||||
24 | OVERHEAD/ADMINISTRATION | |||||
25 | O | Bi-Weekly Payroll Processing | $0 | @ $85/month avg | ||
26 | R | What are your onboarding or training costs? | $0 | $1,200 | ||
27 | SUBTOTAL | $0 | $2,220 | |||
28 | ||||||
29 | ||||||
30 | BENEFITS | |||||
31 | R | Health Insurance/Year | 3600 average for individual not family plan | |||
32 | SUBTOTAL | |||||
33 | ||||||
34 | APPROXIMATE TOTAL | $484 | Estimate depending on state and average calculations | |||
35 | ||||||
36 | You are done, nice work =) Go Kick Some Ass | |||||