ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
Calculation of personnel compensation costs - 2021 updates
2
Days
Hours for Full Time
3
Yearly365
4
Weekend Days104
5
Week Days/Year2612088
6
Vacation1080
7
Holiday864
8
Sick 540
9
*Work Days/Year2381904
10
*estimate of work days/year based on assumption that 2 weeks vacation and 1 week sick is taken each year.
11
Base Hrly Wage Rate$12.00 $13.00 $14.00 $15.00 $16.00 $17.00 $18.00 $19.00 $20.00 $21.00 $22.00 $23.00 $24.00 $25.00 $26.00 $27.00 $28.00 $29.00 $30.00 $31.00 $32.00 $33.00 $34.00 $35.00 $36.00 $37.00 $38.00 $39.00 $40.00
12
Employer Paid Payroll Taxes
13
Social Security6.20%$0.74 $0.81 $0.87 $0.93 $0.99 $1.05 $1.12 $1.18 $1.24 $1.30 $1.36 $1.43 $1.49 $1.55 $1.61 $1.67 $1.74 $1.80 $1.86 $1.92 $1.98 $2.05 $2.11 $2.17 $2.23 $2.29 $2.36 $2.42 $2.48
14
Medicare1.45%$0.17 $0.19 $0.20 $0.22 $0.23 $0.25 $0.26 $0.28 $0.29 $0.30 $0.32 $0.33 $0.35 $0.36 $0.38 $0.39 $0.41 $0.42 $0.44 $0.45 $0.46 $0.48 $0.49 $0.51 $0.52 $0.54 $0.55 $0.57 $0.58
15
Unemployement3.40%$0.41 $0.44 $0.48 $0.51 $0.54 $0.58 $0.61 $0.65 $0.68 $0.71 $0.75 $0.78 $0.82 $0.85 $0.88 $0.92 $0.95 $0.99 $1.02 $1.05 $1.09 $1.12 $1.16 $1.19 $1.22 $1.26 $1.29 $1.33 $1.36
16
OR-WBF Assessment -Worker's Benefit ($/hr)
$ 0.022 $0.26 $0.29 $0.31 $0.33 $0.35 $0.37 $0.40 $0.42 $0.44 $0.46 $0.48 $0.51 $0.53 $0.55 $0.57 $0.59 $0.62 $0.64 $0.66 $0.68 $0.70 $0.73 $0.75 $0.77 $0.79 $0.81 $0.84 $0.86 $0.88
17
Sub-total$1.59 $1.72 $1.86 $1.99 $2.12 $2.25 $2.39 $2.52 $2.65 $2.78 $2.92 $3.05 $3.18 $3.31 $3.45 $3.58 $3.71 $3.84 $3.98 $4.11 $4.24 $4.37 $4.51 $4.64 $4.77 $4.90 $5.04 $5.17 $5.30
18
Workers Comp.
19
8810 Office0.12%$0.01 $0.02 $0.02 $0.02 $0.02 $0.02 $0.02 $0.02 $0.02 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.03 $0.04 $0.04 $0.04 $0.04 $0.04 $0.04 $0.04 $0.04 $0.05 $0.05 $0.05
20
8742 Field Rep0.20%$0.02 $0.03 $0.03 $0.03 $0.03 $0.03 $0.04 $0.04 $0.04 $0.04 $0.04 $0.05 $0.05 $0.05 $0.05 $0.05 $0.06 $0.06 $0.06 $0.06 $0.06 $0.07 $0.07 $0.07 $0.07 $0.07 $0.08 $0.08 $0.08
21
8602 Survey1.41%$0.17 $0.18 $0.20 $0.21 $0.23 $0.24 $0.25 $0.27 $0.28 $0.30 $0.31 $0.32 $0.34 $0.35 $0.37 $0.38 $0.39 $0.41 $0.42 $0.44 $0.45 $0.47 $0.48 $0.49 $0.51 $0.52 $0.54 $0.55 $0.56
22
0042 Landscaping5.09%$0.61 $0.66 $0.71 $0.76 $0.81 $0.87 $0.92 $0.97 $1.02 $1.07 $1.12 $1.17 $1.22 $1.27 $1.32 $1.37 $1.43 $1.48 $1.53 $1.58 $1.63 $1.68 $1.73 $1.78 $1.83 $1.88 $1.93 $1.99 $2.04
23
6400 Fencing5.64%$0.68 $0.73 $0.79 $0.85 $0.90 $0.96 $1.02 $1.07 $1.13 $1.18 $1.24 $1.30 $1.35 $1.41 $1.47 $1.52 $1.58 $1.64 $1.69 $1.75 $1.80 $1.86 $1.92 $1.97 $2.03 $2.09 $2.14 $2.20 $2.26
24
0124 Tree Planting Reforestation6.24%$0.75 $0.81 $0.87 $0.94 $1.00 $1.06 $1.12 $1.19 $1.25 $1.31 $1.37 $1.44 $1.50 $1.56 $1.62 $1.68 $1.75 $1.81 $1.87 $1.93 $2.00 $2.06 $2.12 $2.18 $2.25 $2.31 $2.37 $2.43 $2.50
25
Sub-total
26
Average WC Allocation3.12%$0.37 $0.41 $0.44 $0.47 $0.50 $0.53 $0.56 $0.59 $0.62 $0.65 $0.69 $0.72 $0.75 $0.78 $0.81 $0.84 $0.87 $0.90 $0.94 $0.97 $1.00 $1.03 $1.06 $1.09 $1.12 $1.15 $1.18 $1.22 $1.25
27
Benefits Costs
28
Vacation4.2%$0.19 $0.20 $0.22 $0.23 $0.25 $0.26 $0.28 $0.30 $0.31 $0.33 $0.34 $0.36 $0.37 $0.39 $0.40 $0.42 $0.44 $0.45 $0.47 $0.48 $0.50 $0.51 $0.53 $0.54 $0.56 $0.58 $0.59 $0.61 $0.62
29
Holiday3.4%$0.17 $0.19 $0.20 $0.22 $0.23 $0.25 $0.26 $0.27 $0.29 $0.30 $0.32 $0.33 $0.35 $0.36 $0.38 $0.39 $0.40 $0.42 $0.43 $0.45 $0.46 $0.48 $0.49 $0.51 $0.52 $0.53 $0.55 $0.56 $0.58
30
Sick 2.1%$0.15 $0.17 $0.18 $0.19 $0.20 $0.22 $0.23 $0.24 $0.26 $0.27 $0.28 $0.29 $0.31 $0.32 $0.33 $0.35 $0.36 $0.37 $0.38 $0.40 $0.41 $0.42 $0.43 $0.45 $0.46 $0.47 $0.49 $0.50 $0.51
31
Retirement (CoqWA will match 3%)3.00%$0.36 $0.39 $0.42 $0.45 $0.48 $0.51 $0.54 $0.57 $0.60 $0.63 $0.66 $0.69 $0.72 $0.75 $0.78 $0.81 $0.84 $0.87 $0.90 $0.93 $0.96 $0.99 $1.02 $1.05 $1.08 $1.11 $1.14 $1.17 $1.20
32
Short Term Disability Coverage ($/Month) (CoqWA pays full)$40 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25 $0.25
33
Health ($/Month) (CoqWA pays full)$500 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18 $3.18
34
Sub-total$4.31 $4.38 $4.45 $4.52 $4.60 $4.67 $4.74 $4.82 $4.89 $4.96 $5.03 $5.11 $5.18 $5.25 $5.33 $5.40 $5.47 $5.54 $5.62 $5.69 $5.76 $5.83 $5.91 $5.98 $6.05 $6.13 $6.20 $6.27 $6.34
35
36
Total Hourly Cost for Benefit Elgible$18.27 $19.51 $20.74 $21.98 $23.22 $24.45 $25.69 $26.93 $28.16 $29.40 $30.63 $31.87 $33.11 $34.34 $35.58 $36.82 $38.05 $39.29 $40.53 $41.76 $43.00 $44.24 $45.47 $46.71 $47.95 $49.18 $50.42 $51.65 $52.89
37
Total Monthly Cost for Benefit Elgible$3,164 $3,378 $3,593 $3,807 $4,021 $4,235 $4,449 $4,663 $4,878 $5,092 $5,306 $5,520 $5,734 $5,948 $6,163 $6,377 $6,591 $6,805 $7,019 $7,233 $7,447 $7,662 $7,876 $8,090 $8,304 $8,518 $8,732 $8,947 $9,161
38
39
% Benefits to wages$12.00 $13.00 $14.00 $15.00 $16.00 $17.00 $18.00 $19.00 $20.00 $21.00 $22.00 $23.00 $24.00 $25.00 $26.00 $27.00 $28.00 $29.00 $30.00 $31.00 $32.00 $33.00 $34.00 $35.00 $36.00 $37.00 $38.00 $39.00 $40.00
40
$4.31 $4.38 $4.45 $4.52 $4.60 $4.67 $4.74 $4.82 $4.89 $4.96 $5.03 $5.11 $5.18 $5.25 $5.33 $5.40 $5.47 $5.54 $5.62 $5.69 $5.76 $5.83 $5.91 $5.98 $6.05 $6.13 $6.20 $6.27 $6.34
41
36%34%32%30%29%27%26%25%24%24%23%22%22%21%20%20%20%19%19%18%18%18%17%17%17%17%16%16%16%
42
43
Not Benefit Eligible Positions
44
Sick Time Only4.28%$0.60 $0.65 $0.70 $0.75 $0.80 $0.85 $0.90 $0.95 $1.00 $1.05 $1.10 $1.15 $1.20 $1.25 $1.29 $1.34 $1.39 $1.44 $1.49 $1.54 $1.59 $1.64 $1.69 $1.74 $1.79 $1.84 $1.89 $1.94 $1.99
45
Total Hourly Cost For Non Benefit Elgible
$2.56 $2.78 $2.99 $3.20 $3.42 $3.63 $3.84 $4.06 $4.27 $4.48 $4.70 $4.91 $5.12 $5.34 $5.55 $5.76 $5.98 $6.19 $6.40 $6.62 $6.83 $7.04 $7.26 $7.47 $7.68 $7.90 $8.11 $8.33 $8.54
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