SVPP Buckeye Budget excel submission.xlsx

City of Buckeye Personnel
Rank
Exempt 
Status
New Civilian Personnel - year 1
Other
Non Exempt
New Civilian Personnel - year 2
Other
Non Exempt
New Civilian Personnel - year 3
Other
Non Exempt
Supplies
Quantity
Cost per unit
Video Surveillance System - Outdoor Dome
110
1,307.99
$    
Video Surveillance System - Indoor Ceiling Mount Dome
110
537.42
$       
Video Surveillance System - Indoor Wall Mount Dome
110
642.79
$       
Ballistic window film (priced per sq. ft.)
300
220.00
$       
Ballistic foldable shields
20
900.00
$       
Total
Total salary and benefits
271,493.30
$  
Total Supplies
390,968.29
$  
Total Budget
662,461.59
$  
Grant Funding
496,846.19
$  
75%
Buckeye Share
165,615.40
$  
25%
Total

Annual 
Salary
Medicare %
Medicare $
SSA %
SSA $
Total Fringe
80,000.00
$   
1.45%
$1,160.00
0.062
4,960.00
$    
$6,120.00
84,000.00
$   
1.45%
$1,218.00
0.062
5,208.00
$    
$6,426.00
88,200.00
$   
1.45%
$1,278.90
0.062
5,468.40
$    
$6,747.30
Subtotal
Sales Tax
Total
143,878.90
$ 
9.3%
157,259.64
$
59,116.20
$   
9.3%
64,614.01
$  
70,706.90
$   
9.3%
77,282.64
$  
66,000.00
$   
9.3%
72,138.00
$  
18,000.00
$   
9.3%
19,674.00
$  
357,702.00
$ 
390,968.29
$

Total employer cost
86,120.00
$                       
90,426.00
$                       
94,947.30
$                       
271,493.30
$