4. FY2022 QUEEN CREEK ANNUAL COST WORKSHEET.PDF

Worksheet Exhibit A. 
BEATS
6.0
Unfilled
-1.0
Operating
7,823,708.02
$  
3% Indirect
234,711.24
Sub Total
8,058,419.26
$  
One Time
0.00
Contract Cost Annualized
8,058,419.26
$  
Contract Cost for end date of December 31, 2021
4,029,209.63
$  
Part 1.  Personnel Services
$7,109,583.48
Annual Hours Budgeted
2088
Position
FTE
FY 2022 
Average 
Hourly Base 
Pay
FY 2022 Hourly 
Variable Benefits 
Rate Charge
FY 2022 
Hourly 
Average Base 
Plus Variable 
Benefits
FY 2022 
Fixed Benefi 
(6 Months)
Annualized
FY 2022
Patrol Beat Deputies
30.00
$30.00
72.68%
$51.80
$12,768
3,627,830.27
$  
Beat 6 Positions Unfilled
-5.00
$30.00
72.68%
$51.80
$12,768
(604,638.38)
$    
Detectives
3.00
$28.96
72.68%
$50.00
$12,768
351,474.56
$     
Sergeants
8.00
$40.82
72.68%
$70.49
$12,768
1,279,608.96
$  
Lieutenants
2.00
$50.98
72.68%
$88.03
$12,768
393,149.28
$     
Captain
1.00
$59.72
72.68%
$103.13
$12,768
228,112.47
$     
Community Police Deputy
3.00
$30.00
72.68%
$51.80
$12,768
362,783.03
$     
School Resource Officer
2.19
$30.00
72.68%
$51.80
$12,768
264,831.61
$     
*Crime Analyst
1.00
$25.00
19.87%
$29.97
$12,768
75,345.36
$       
Clerical/Administrative Assistant
1.00
$18.28
19.87%
$21.91
$12,768
58,523.78
$       
Worker's Comp
46.19
$606.77
(Fund-Wide Allocation per FTE) Divided by 2
28,026.74
Unemployment
46.19
$8.30
(Fund-Wide Allocation per FTE) Divided by 2
383.22
Dispatch  
3.26 (FTE is a total cost equivalent not to be used in other calculations.)
229,891.48
Sub Total Salary and Benefits
6,295,322.38
$  
Staffing Allocation Factor
FTE Staffing Requirements
24 hour / 7 day post
5.00 FTE
5.00 Deputies
1 Beat
8 hour / 7 day post
1.67 FTE
0.50 Detectives
1 Beat
8 hour / 5 day post
1.19 FTE
1.00 Sergeant for
8 Deputies
1.00 Lieutenant for
18 Deputies
1.00 Captain for
30 Deputies
0.14 Clerical for
1 Beat
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY 2022
Annualized Beginning July 1, 2021 
1

Worksheet Exhibit A. 
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY 2022
Annualized Beginning July 1, 2021 
Special Pay
(Deputies/Detectives/Sgts.)
Eligible 
Sworn FTEs
District Rate 
Per FTE
Cost
Cost Includes 72.68% Variable Benefits
Overtime
41.19
$17,169.71 
707,220.35
$             
Shift Differential
41.19
$1,102.84 
45,425.86
$               
Regular Over Budget
41.19
$1,495.87 
61,614.89
$               
Sub Total Special Pay
814,261.10
$     
Part 2.  Supplies and Rent
74,407.33
$    
Applicable FTE's
46.19 FTE total minus Dispatch
Supply Cost (By District)
$480.91 Per applicable FTE
22,213.23
$       
Ammunition
$381.13 Per Sworn FTE
44.19
16,842.10
         
Uniform Allowance
$800.00 Per Sworn FTE
44.19
35,352.00
         
74,407.33
$       
Part 3.  Communications and Information Technology (IT)
379,897.65
$  
Sworn FTEs 
44.19
Information System Service
196,552.16
196,552.16
$     
Monthly Radio Charges Vehicles
$135.35 Per Month (12); 2 per Vehicle
Vehicles
21
68,216.40
Monthly Radio Charges Sworn
$135.35 Per Month (12) per Sworn FTE
Sworn FTE
44.19
71,773.40
Deputy Laptop Connection
$41.36 Per Month (12) per Sworn FTE
Sworn FTE
44.19
21,932.38
I-Phone Monthly Charge
$40.40 Per Month (12) per Device per Sworn FTE
Sworn FTE
44.19
21,423.31
379,897.65
$     
Part 4.  Vehicles and Equipment
259,819.56
$  
Vehicle Cost with Warranty
41,829.02
$  
Vehicle life 125,000 miles
Equipment Costs (Lights; Push 
Bar; Etc.)
18,742.46
$  
Equipment life 343,750
Component
Per Mile Rate
12 Months
 Miles
Costs
 
Mileage Rate
$0.404 
327,577
132,341.11
$             
132,341.11
$     
Vehicle Depreciation
$0.335 
327,577
109,617.80
$             
109,617.80
Equipment Depreciation
$0.055 
327,577
17,860.65
$               
17,860.65
259,819.56
$     
Sub Total Communications and IT
Sub Total Vehicles and Equipment
Sub Total Supplies and Rent
2

Worksheet Exhibit A. 
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY 2022
Annualized Beginning July 1, 2021 
-
$               
 $    234,711.24 
Part 6.  Indirect Cost Recovery
Indirect costs are recovered at 3% for Sections 1 - 4.
Part 5.  One-Time Costs  
There will be no one-time costs associated with this worksheet.  The addition of 6th Beat Staffing from FY 19 and 20  could not be 
met.  
3