ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
Ed Fund Total Compensation Tool Version 042320
2
For Employees during Fiscal Year 2019-20
3
INSTRUCTIONS:
4
This form is view-only. In order to use this form you must make a copy by clicking File > Make A Copy
5
Use this sheet to estimate total compensation (all role costs, including fringe) for employees you want to hire. Note an approximate age is required in order to estimate health premiums.
6
Totals are shown from Column Z onwards. The "Output Sheet' Tab of this spreadsheet gives more details on all the fringe benefits and taxes assessed as part of employment.
7
ONCE YOU'VE CREATED YOUR OWN COPY OF THIS SHEET, FILL OUT THE CELLS HIGHLIGHTED IN GREEN BELOW.
8
9
No.NamePositionApprox AgeStart DateEnd Date (leave blank if no end date)Hours Per WeekHourly Rate (If Salaried, Divide salary by 2080)SalaryWeeks of WorkEmployee TypePart Time or Full TimeHealth Benefit Eligible?Gross WagesUI/ETT/SDISoc SecMedicareEmployer Tax SubtotalMedicalDentalVisionGroup LifeBenefit SubtotalWorkers CompYearly VacationTOTAL COMPENSATIONWith Ed Fund Administration FeeEffective Fringe Rate"Loaded" Hourly Rate (total cost per hour)W/C Rate
10
1$0.0052.00RegularPart TimeNO$0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.00$0.00$0.00$0.00$475.00#DIV/0!3.00%
11
2$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
12
3$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
13
4$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
14
5$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
15
6$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
16
7$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
17
10$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
18
11$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
19
12$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
20
13$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
21
14$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
22
15$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
23
16$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
24
17$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
25
18$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
26
19$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
27
20$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
28
21$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
29
22$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
30
23$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
31
24$0.0052.00RegularPart TimeNO0.00$0.00$0.00$0.00$0.00N/AN/AN/AN/A$0.000.00$0.00$0.00$475.00#DIV/0!3.00%
32
Total payroll and benefits
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$10,450.00
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100