Extracted text (via pymupdf)
6430 characters
Exhibit A FINAL El Mirage Animal Control Cost Analysis FY27 2.18.26.xlsx Direct FTE Calculation Total Cost Allocation El Mirage Cost Allocation Basis Salary & Benefits (4 ACOs) 421,005 $ 18% 77,114 $ Incident/Call Activity Overtime 21,115 $ 18% 3,868 $ Incident/Call Activity Shift Differential 575 $ 18% 105 $ Incident/Call Activity 81,087 $ Direct Non-Personnel Costs Total Cost Allocation El Mirage Cost Allocation Basis Vehicle Replacement 64,286 $ 18% 11,775 $ Incident/Call Activity Fuel and Maintenance 41,351 $ 18% 7,574 $ Incident/Call Activity Equipment Replacement 14,034 $ 18% 2,571 $ Incident/Call Activity Cell Phone Service 3,200 $ 18% 586 $ Incident/Call Activity Arizona Humane Society and Misc. 72,055 $ 18% 13,198 $ Incident/Call Activity 35,704 $ Indirect FTE Calculation Total Cost Allocation El Mirage Cost Allocation Basis Supervision (1 Sergeant) 256,063 $ 9.16% 23,451 $ Supervision and Incident/Call Activity 23,451 $ Total Costs Attributable to El Mirage FY2027 140,242 $ FY2028 145,739 $ 4% FY2029 152,962 $ 5% Explanations for FY27 changes: Direct FTE: 9% increase ($5,999): Step increases, COLA, PEHP Direct Non-Personnel: 2% decrease ($-236) Increase to vehicle replacement costs and cell phone service offset with savings in fuel a Overall 7% increase ($5,852) Explanations for FY28-29 changes: Step increase and 1% COLA, PEHP 2% increase to supplies and services Increase to retirement and medical Subtotal: Subtotal: Subtotal: 2/19/2026 Exhibit A Exhibit A Detail FINAL El Mirage Animal Control Cost Analysis FY27 2.18.26.xlsx Direct FTE Calculation Detail 4 FY2027* FY2028* FY2029* 310,992 $ 326,921 $ 343,933 $ 110,013 $ 116,047 $ 123,472 $ 421,005 $ 442,968 $ 467,405 $ Other Salary Expenses Type FY2023 FY2024 FY2025 FY27 Estimate* FY28 Estimate* FY29 Estimate* Overtime 12,085 $ 24,053 $ 22,434 $ 21,115 $ 22,836 $ 24,698 $ Stand By - $ - $ - $ - $ - $ - $ Shift Differential - $ - $ 1,595 $ 575 $ 622 $ 672 $ Non-Personnel Costs Calculation Detail Vehicle Replacement # of Vehicles in fleet 3 3/4 Ton Truck (Includes kennel boxes, radios, and MDCs) Current calculation Today's cost 150,000 $ Est. Fully Equipped Purchase Price 7 Useful Life (Years) 21,429 $ Annual Replacement Cost 64,286 $ Total x 3 Fuel and Maintenance Asset # FY2023 FY2024 FY2025 FY27 Estimate** FY28 Estimate** FY29 Estimate** 8221 17,234 $ 8,744 $ 15,182 $ 15,997 $ 16,317 $ 16,643 $ 8222 11,747 $ 11,769 $ 14,826 $ 15,622 $ 15,934 $ 16,253 $ 8464 (Repl. 7719) 4,920 $ 6,956 $ 9,236 $ 9,732 $ 9,926 $ 10,125 $ Average Per Vehicle: 13,784 $ 14,059 $ 14,340 $ FY27 Estimate** FY28 Estimate** FY29 Estimate** Estimate for Fleet: 41,351 $ 42,178 $ 43,021 $ Equipment Replacement Item Quantity Amount Total Useful Life (Years) Annual Replacement Cost Portable Radio 4 10,700 $ 42,800 $ 7 6,114 $ Snares 4 250 $ 1,000 $ 2 500 $ Snake Gloves 4 200 $ 800 $ 2 400 $ Tasers/Body Camera 4 6,900 $ 27,600 $ 5 5,520 $ Microchip Scanner 4 450 $ 1,800 $ 2 900 $ Nets 4 150 $ 600 $ 1 600 $ Total: 14,034 $ 14,788 $ 15,582 $ FY27 Estimate** FY28 Estimate** FY29 Estimate** Cell Phone Service* Item Quantity Amount FY27 Estimate** FY28 Estimate** FY29 Estimate** Cell Phone 4 800 $ 3,200 $ 3,372 $ 3,553 $ *Annual contract amount AZ Humane Society & Misc Expenses FY2024 FY2025 FY27 Estimate** FY28 Estimate** FY29 Estimate** Incl. vet service, cat pickup, animal 20,561 $ 53,555 $ 72,055 $ 75,658 $ 79,441 $ ACO Supervisor (Police Sergeant) FY27 Estimate** FY28 Estimate** FY29 Estimate** Allocation calculated by # of units overseen Salary Estimate 174,939 $ 180,030 $ 185,170 $ 4 # of Units Supervised (Including Animal Control) Benefits Estimate 81,124 $ 84,624 $ 87,704 $ 25% Animal Control Unit Allocation Total Compensation Estimate 256,063 $ 264,654 $ 272,875 $ 4.58% El Mirage Allocation Allocation calculated by # of employees supervised (Currently using) 8 # of Employees Supervised in All Units 4 # of Animal Control Employees 50% Animal Control Unit Allocation 9.16% El Mirage Allocation Additional Cost Allocation Calculations Surprise El Mirage Surprise El Mirage Surprise El Mirage Call- Animal Bite 136 38 124 18 147 17 Call- Barking Incident 429 1 338 2 591 0 Call- Other Animal Incident 1,907 406 1,997 448 2,129 439 Impound Animal 623 233 497 184 610 181 Surrender Animal to County 395 172 391 108 325 134 Total Call Activity: 2,472 445 2,459 468 2,867 456 Allocation: 85% 15% 84% 16% 86% 14% 15% *This calculation uses today's cost for estimated replacement cost *This is based off of estimate provided by Brandi Clark 12/03/2025 2023-2025 Average El Mirage % Activity FY2023 FY2024 FY2025 Indirect FTE Calculation Detail # of FTEs Total Compensation Estimate Benefits Estimate Salary Estimate 2/19/2026 2 Exhibit A Detail Exhibit A Detail FINAL El Mirage Animal Control Cost Analysis FY27 2.18.26.xlsx Total of All Activity: 3,490 850 3,347 760 3,802 771 Allocation: 80% 20% 81% 19% 83% 17% 18% 2/19/2026 3 Exhibit A Detail