COPS Wage Worksheet RR.xlsx

Personnel Name
Rank
Exempt 
Status
Annual 
Salary
Medicare 
%
Medicare 
$
Workers 
Comp %
Workers Comp 
$
Retirement 
% Employee 
contribution
Retirement 
$ Employee 
contribution
Retirement 
% Employer 
contribution
Retirement 
$ Employer 
contribution
Life, 
AD&D, ST 
Disability 
$
Health 
Insurance
Dental 
Insurance
Vision 
Insurance
Total 
Benefits
Total employer 
cost
Total employer 
cost for 4 police 
officers requested
New Sworn Police Officer - year one
Other
Non Exempt
70,000.00
$   
1.45%
$1,015.00
3.15%
$2,205.00
9.94%
$6,958.00
26.75%
$18,725.00
186.96
$   
19,506.05
$    
1,381.88
$    
139.17
$          
$43,159.06
113,159.06
$            
452,636.22
$              
New Sworn Police Officer - year 2
Other
Non Exempt
73,500.00
$   
1.45%
$1,065.75
3.15%
$2,315.25
9.94%
$7,305.90
26.75%
$19,661.25
196.31
$   
20,481.35
$    
1,450.97
$    
146.13
$          
$52,622.91
118,817.01
$            
475,268.03
$              
New Sworn Police Officer - year 3
Other
Non Exempt
77,175.00
$   
1.45%
$2,238.08
3.15%
$2,431.01
9.94%
$7,671.20
26.75%
$20,644.31
206.12
$   
21,505.42
$    
1,523.52
$    
153.43
$          
$56,373.09
125,876.90
$            
503,507.58
$              
1,431,412
$                 
Grant Funding
500,000.00
35%
Buckeye Share
931,412
$                    
65%
Maximum COPS funding is $125,000 over a 3 year period.
31.35%
Max $ of grant for 4 SPO 
500,000.00
COPS 2023 Wage Worksheet
Police Department Name
Buckeye Police Department

Health Premiums
Monthly 
Health
Monthly 
Dental
Monthly 
Vision
Emp
898.14
53.49
5.91
EMP+Sp
1613.98
108.50
11.24
Emp+Children
1524.23
123.10
11.84
Emp+Fam
2,465.67
175.55
17.4
6,502.02
460.63
46.39
Average
1,625.50
115.16
11.60