QUEEN CREEK FY2015.PDF

MARICOPA COUNTY SHERIFF'S OFFICE
JOSEPH M. ARPAIO
SHERIFF
February 18,2014
The Hon Gail Barney
Mayor of the Town of Queen Creek
22350 S. Ellsworth Road
Queen Creek, AZ 85142
Dear Mayor Barney:
Subject: Annual Notification Law Enforcement Services Costs
Contract #C-50-11-106-M-00
Enclosed per the terms of our Intergovernmental Agreement is the updated Worksheet Exhibit A. detailing charges for
service for FY 2015 that take effect July 1,2014. This is a cost recovery agreement.
The annual amount is: $3,735,810. This is an increase of more than 10% over last year and is 100%attributable to
pay. In July of2013, Sheriffs sworn employees received market pay adjustments. These were the first pay increases
since 2007. This increased the average pay in the various market ranges considerably. In addition, the variable
benefits (retirement and FICAlMedicare) rate increased to 43.52% from 38.08%. I am enclosing a copy ofa schedule
that shows the positions costs by classification to provide better context for the increase.
Although the cost of ammunition nearly doubled per FTE, the overall supply costs decreased for the Town of Queen
Creek as did the communications and information technology, and the vehicles and equipment charges.
Feel free to contact me or my staff with questions or additional information regarding this worksheet. We appreciate
being the Law Enforcement agency of choice for your Town's public safety.
rSln7Jfi_
~1BOhn
Chief Financial Officer
LB/SRBlsrb
Enclosure
Copies: Chief Deputy Gerard A. Sheridan
Mr. John Kross, Town Manager
Chief Scott R Freeman, Administration
Deputy Chief David Trombi, Patrol and Enforcement Support Bureau
Captain Randy Brice, District VI Commander
Ms. Suzanne Baier, Finance Manager, Sheriffs Business Services
Mr. Joe LaFortune, Town Marshal
550 W Jackson Street • Phoenix, Arizona 85003
(602) 876-1000 • Statewide Toll Free 1-800-352-4553 • WWW.MCSO.ORG

Worksheet Exhibit A.
Town of Queen Creek
Maricopa County Sheriffs Office
Law Enforcement Reimbursement Costs and Charges
FY2015
(July 1, 2014 through June 30, 2015)
BEATS 4.00
Total Contract Cost $3,735,810
Part 1 Personnel Services $3458639 , ,
Annual Hours Budgeted 2088
Fixed Fringe
$8904 + Wkrs
Hourly Variable Hourly Plus Comp and Annualized
Position FTE Rate Fringe Rate Variable Fringe Unemp $714 FY 2015
Patrol Beat Deputies 20.00 $27.03 43.52% $38.79 $ 9,618 $1,812,375
Detectives 2.38 $28.46 43.52% $40.85 $ 9,618 $225,872
Sergeants 5.00 $37.43 43.52% $53.72 $ 9,618 $608,922
Lieutenants 1.35 $45.21 43.52% $64.89 $ 9,618 $196,528
Captain 1.00 $61.30 43.52% $87.98 $ 9,618 $193,316
Community Police Deputy 1.00 $27.03 43.52% $38.79 $ 9,618 $90,619
School Resource Officer 1.00 $27.03 43.52% $38.79 $ 9,618 $90,619
Clerical Office Assistant 1.00 $13.97 19.20% $16.65 $ 9,618 $44,388
Dispatcher (TCO) $87,340
Sub Total Salary and Benefits $3,349,979
Staffing Allocation Factor FTE Staffing Requirements
24 hour / 7 day post 5.00 FTE 0.50 Detectives 1 Beat
8 hour / 7 day post 1.67 FTE 1.00 Sergeant for 9 Deputies
8 hour / 5 day post 1.19 FTE 1.00 Lieutenant for 18 Deputies
1.00 Captain for 30 Deputies
0.14 Clerical for 1 Beat
0.14 Trnsprt Deputy 1 Beat
Special Pay
(DeputieslDetectives/Sgts. ) FTEs Cost
Overtime 29.38 $1,568.44
Shift Differential 29.38 862.42
Regular Over Budget 29.38 1,267.58
$3,698.44 Includes 43.52% Variable Benefits 108,660
Sub Total Personnel Services $3,458,639
P art 2. S uppues r and Rent $ 55, 6 31
Applicable FTE's 32.73 FTE total minus Dispatch
Supply Cost 324.56 Per applicable FTE 10,624
Ammunition 618.24 Per Sworn FTE 31.73 19,620
Uniform Allowance 800.00 Per Sworn FTE 31.73 25,388
Sub Total Supplies and Rent $55,631

Worksheet Exhibit A.
Town of Queen Creek
Maricopa County Sheriffs Office
Law Enforcement Reimbursement Costs and Charges
FY2015
Part 3. Communications and Information Technology (ITl $47,965
Sworn FTEs 31.73
DispatchCosts See Personnel Services Part 1 for Cost
InformationSystemMaintenance;
UserSupport;VerizonWireless 25,240 Proportionate based on Patrol Costs $25,240
Monthly Radio and MDC Charges 22,725 Monthly Charges Per Unit by Sworn FTE 31.73 & Vehicle_l11l 22,725
Sub Total Communications and IT $47,965
Part 4. Vehicles and Equipment $1735 ,74
Vehicle Cost with Warranty $ 38,659 Vehicle life 125,000 miles
Equipment Costs $ 11,822 Equipment life 343,750
Per Mile Annual
Crown Vic Patrol Vehicles Rate Miles Costs
Mileage Rate $0.431 224,256 $96,654 $96,654
Vehicle Depreciation $0.309 224,256 $69,295 69,295
Equipment Depreciation $0.034 224,256 $7,625 7,625
Sub Total Vehicles and Equipment $173,574
Part 5. One-Time Costs
This section is reserved for cost reimbursement of replacement or new equipment items that have been identified as
necessary for Law Enforcement Service delivery that are not otherwise funded in the Sheriffs operational budget. (Requires
amendment.)
Part 6. Indirect Cost Recovery
This section is reserved for items identified by Maricopa County that are necessary for full cost recovery. When
the methodology is detemined, the Agreement will be amended and the rate will be included in this section.
2

FY 15 Salary Comparisons
Using ADP Payroll Download limited to the MCSO Patrol Districts
Previous FY 2015 Previous
Previous FY 2015 Hourly Hourly Hourly FY 2015 Hourly
Average Average Variable Variable Average Base Average Base
Hourly Hourly Benefits Benefits Rate Plus Variable Plus Variable %
Classifications Base Pay Base Pay Rate Charge Benefits Benefits Change
Patrol Beat Deputies (LEO's PATR) $24.79 $27.03 38.08% 43.52% $34.23 $38.79 13.33%
Detectives (LEO's INVT) $25.94 $28.46 38.08% 43.52% $35.82 $40.85 14.04%
Sergeants $33.40 $37.43 38.08% 43.52% $46.12 $53.72 16.48%
Lieutenants $40.18 $45.21 38.08% 43.52% $55.48 $64.89 16.95%
Captain $50.06 $61.30 38.08% 43.52% $69.12 $87.98 27.28%
Community Police Deputy (LEO) $24.79 $27.03 38.08% 43.52% $34.23 $38.79 13.33%
Swing Shift Deputy (LEO) $24.79 $27.03 38.08% 43.52% $34.23 $38.79 13.33%
Traffic Enforcement (LEO) $24.79 $27.03 38.08% 43.52% $34.23 $38.79 13.33%
School Resource Officer (LEO) $24.79 $27.03 38.08% 43.52% $34.23 $38.79 13.33%
Clerical Office Assistant $12.89 $13.97 18.80% 19.20% $15.31 $16.65 8.74%
Dispatcher (TCO) $17.99 $20.62 18.80% 19.20% $21.37 $24.58 15.01%