WORKSHEETS EXHIBIT A FY2019 5_4BEATS.PDF

Worksheet Exhibit A.
Contingent Upon Contract Approval
Costs Effective January 1, 2019--1/2 of Operating ($3,562.041.74) plus one time payable in FY 2019
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY2019
Updated Annualization 5.4 Beats
BEATS 5.4
Total Contract Cost $7,406,000.48
Operating $7,124,083.48
One-time $281,917.00
Part 1. Personnel Services $6,543,202.41
Annual Hours Budgeted 2088
FY 2019 Hourly
FY 2019 Variable FY 2019 Hourly
Average Benefits Rate Average Base FY 2019 Fixed
Hourly Base Charge (FY Plus Variable Benefit (FY Annualized
Position FTE Pay 2018 Rates) Benefits 2018 Rates) FY 2019
Patrol Beat Deputies 27.00 $28.05 60.44% $45.00 $11,400.00 $2,844,912.81
Detectives 3 $29.24 60.44% $46.91 $11,400.00 $328,060.88
Sergeants 8.00 $38.93 60.44% $62.46 $11,400.00 $1,134,520.01
Lieutenants 2.00 $49.15 60.44% $78.86 $11,400.00 $352,103.74
Captain 1.00 $60.43 60.44% $96.95 $11,400.00 $213,839.73
Community Police Deputy 3.00 $28.05 60.44% $45.00 $11,400.00 $316,101.42
School Resource Officer 2.19 $28.05 60.44% $45.00 $11,400.00 $230,754.04
*Crime Analyst 1.00 $24.13 19.15% $28.75 $11,400.00 $71,431.87
Clerical/Administrative Assistan 2.00 $16.52 19.15% $19.68 $11,400.00 $104,998.63
Worker's Comp 49.19 $510.85 (Fund-Wide Allocation per FTE) $25,128.71
Unemployment 49.19 $20.40 (Fund-Wide Allocation per FTE) $1,003.48
Dispatch 4.95 (FTE is a total cost equivalent not to be used in other calculations.) $315,583.70
Sub Total Salary and Benefits $5,938,439.02
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 9 Deputies
1.00 Lieutenant for 18 Deputies
1.00 Captain for 30 Deputies
0.14 Clerical for 1 Beat
Special Pay
(Deputies/Detectives/Sgts.) FTEs Rate Per FTE Cost Includes 60.44% Variable Benefits
Overtime 43.19 11,545.87 $ 498,666.13
Shift Differential 43.19 1,078.52 $ 46,581.45
Regular Over Budget 43.19 1,378.00 $ 59,515.82
$ 604,763.40
Sub Total Special Pay $ 604,763.40
Part 2. Supplies and Rent $59,604.80
Applicable FTE's 49.19 FTE total minus Dispatch
Supply Cost 454.47 Per applicable FTE 22,355.38
Ammunition 9.77 Per Sworn FTE 46 449.42
Uniform Allowance 800.00 Per Sworn FTE 46 36,800.00
Sub Total Supplies and Rent $59,604.80
1

Worksheet Exhibit A.
Contingent Upon Contract Approval
Costs Effective January 1, 2019--1/2 of Operating ($3,562.041.74) plus one time payable in FY 2019
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY2019
Updated Annualization 5.4 Beats
Part 3. Communications and Information Technology (IT) $234,005.42
Sworn FTEs 46.00
Information System Service 166,755.74 Annual Cost 166,755.74
iPhone Monthly Charges 51.79 Per month Devices 18 11,186.64
Monthly Radio Charges
Vehicles 43.22 Per Month (2) per Vehicle Vehicles 21 $21,782.88
Monthly Radio Charges Sworn 43.22 Per Month per Sworn FTE $23,857.44
MDC Charges 41.36 Per Vehicle per month Vehicles 21 $10,422.72
Sub Total Communications and IT $234,005.42
Part 4. Vehicles and Equipment $287,270.85
Vehicle Cost with Warranty $ 37,520 Vehicle life 125,000 miles (combined average)
Equipment Costs (Lights;
Push Bar; Etc.) $ 12,577 Equipment life 343,750
Annual
Crown Vic Patrol Vehicles Per Mile Rate Miles Costs
Mileage Rate $0.328 432,148 $141,744.54 141,744.54
Vehicle Depreciation $0.300 432,148 $129,715.03 129,715.03
Equipment Depreciation $0.037 432,148 $15,811.27 15,811.27
Sub Total Vehicles and Equipment $287,270.85
Part 5. One-Time Costs--see next page
These items will billed separately and based on final actual cost. Amounts shown are estimates. $281,917.00
Part 6. Indirect Cost Recovery
This section is reserved for items identified by Maricopa County that are necessary for full cost recovery.
2

Worksheet Exhibit A.
Contingent Upon Contract Approval
Costs Effective January 1, 2019--1/2 of Operating ($3,562.041.74) plus one time payable in FY 2019
Town of Queen Creek
Maricopa County Sheriff's Office
Law Enforcement Reimbursement Costs and Charges
FY2019
Updated Annualization 5.4 Beats
Part 5. One-Time Costs
These items will billed separately and based on final actual cost. Amounts shown are estimates.
Unit Cost Estimated
Category Estimated Units Amount
Vehicles
Vehicle--Patrol SUV $ 45,052 3 $ 135,156
Vehicle Dock for Laptop,
printer, scanner, radio antenna
connectivity $ 1,902 3 $ 5,706
Mobile Radio Unit $ 6,500 3 $ 19,500
VHF Radio Unit $ 3,500 3 $ 10,500
Radio Unit Programming Charg $ 45 3 $ 135
Equipment Services Get
Ready Charges Parts and
Installation (Multiple Items
including
Lights/Sirens/Wiring/Push
Bar/Prisoner Cages). $ 17,346 3 $ 52,038
Decaling $ 726 3 $ 2,178
Moving Radar Detection $ 1,570 3 $ 4,710
Subtotal $ 229,923
Computing Equipment
Laptop, Dock, and Adapter $ 3,600 3 $ 10,800
Subtotal $ 10,800
Personal Communications
Motorola Radio $ 7,700 3 $ 23,100
Programming Charge $ 45 3 $ 135
Sgt and Above I-Phone $ 263 1 $ 263
Deputy Cell Phone $ 160 2 $ 320
Subtotal $ 23,818
Office Issue Officer Safety
Taser and holster $ 1,483 3 $ 4,449
Body Camera $ 1,209 3 $ 3,627
Patrol Rifle w/case and optics $ 1,700 3 $ 5,100
Patrol Service Pistol $ 750 3 $ 2,250
Body Armor $ 650 3 $ 1,950
Subtotal $ 17,376
Estimated
Total $ 281,917
3