Extracted text (via pymupdf)
1863 characters
Exhibit A El Mirage Animal Control Cost Analysis FY24 PD Revised.xlsx Direct FTE Calculation Total Cost Allocation El Mirage Cost Allocation Basis Previous Analysis Increase (Decrease) % Increase (Decrease) Salary & Benefits (4 ACOs) 376,602 $ 22% 82,853 $ Incident/Call Activity 71,236 $ 11,617 $ 16% Overtime 3,435 $ 22% 756 $ Incident/Call Activity 1,150 $ (394) $ -34% Standby Pay 13,760 $ 22% 3,027 $ Incident/Call Activity 3,180 $ (153) $ -5% Shift Differential 903 $ 22% 199 $ Incident/Call Activity 174 $ 25 $ 14% 86,834 $ 75,739 $ 11,095 $ 15% Direct Non-Personnel Costs Total Cost Allocation El Mirage Cost Allocation Basis Vehicle Replacement 24,840 $ 22% 5,465 $ Incident/Call Activity 4,831 $ 634 $ 13% Fuel and Maintenance 28,931 $ 22% 6,365 $ Incident/Call Activity 5,094 $ 1,271 $ 25% Equipment Replacement 7,088 $ 22% 1,559 $ Incident/Call Activity 715 $ 844 $ 118% Cell Phone Service 3,200 $ 22% 704 $ Incident/Call Activity 627 $ 77 $ 12% Maricopa County Service Agreement 21,841 $ 22% 4,805 $ Incident/Call Activity 739 $ 4,066 $ 550% 18,898 $ 12,005 $ 6,893 $ 57% Indirect FTE Calculation Total Cost Allocation El Mirage Cost Allocation Basis Supervision (1 Sergeant) 204,910 $ 5.50% 11,270 $ Supervision and Incident/Call Activity 9,581 $ 1,689 $ 18% 11,270 $ 9,581 $ 1,689 $ 18% Total Costs Attributable to El Mirage FY2024 117,002 $ 97,326 $ 19,676 $ 20% Subtotal: Subtotal: Subtotal: 3/1/2023 Exhibit A