MCSO APPROPRIATION ADJU CALCULATIONSRV.XLSX
Extracted text (via pymupdf_layout)
4571 characters
Compliance Budget Estimate Operating Costs - Total Non-Recurring Costs - Total Supplies/ General Detention Com- Computer Radio General Detention FTE Rate Salary Benefits Services Total Cost Fund Fund puters Cost Radios Cost Weapo Total Fund Fund Sworn Sergeant 2.00 $ 37.39 $ 156,141 $ 91,678 $ 8,000 $ 255,819 $ 255,819 $ - 2 $ 4,200 2 $ 15,000 $ 3,000 $ 22,200 $ 22,200 $ - Detention Sergeant 1.00 27.13 56,647 20,857 4,000 $ 81,504 - 81,504 1 2,100 1 7,500 - 9,600 - 9,600 Legal Support Specialist 3.00 19.91 124,716 50,720 12,000 $ 187,436 187,436 - 3 6,300 - - - 6,300 6,300 - Administrative Supervisor 1.00 22.60 47,189 17,988 4,000 $ 69,177 69,177 - 1 2,100 - - - 2,100 2,100 - $ 384,693 $ 181,242 $ 28,000 $ 593,936 $ 512,432 $ 81,504 $ 14,700 $ 3 $ 22,500 $ 3,000 $ 40,200 $ 30,600 $ 9,600 General Detention General Detention 81,504 Fund Fund Fund Fund Compliance: FY 2015: 427,026 Compliance: FY 2015: 30,600 Target: 85,405 Target: - EIS: FY 2015: 67,920 EIS: FY 2015: 9,600 Target: 13,584 Target: - $ 512,432 Bureau of Internal Oversight Need immediately (10 months): Vehicle Deten- Supplies/ General Detention Cost Compu- Compu- Radio Weapons General tion FTE Rate Salary Benefits Services Total Cost Fund Fund Vehicles (w/MDC) ters ter Cost Radios Cost Cost Total Fund Fund Deputy Chief 1.00 $ 64.54 $ 134,760 $ 72,659 $ 4,000 $ 211,418 $ 105,709 $ 105,709 $ - 1 $ 2,100 $ - $ - $ 2,100 $ 2,100 - Sworn Captain 1.00 55.28 115,425 63,511 4,000 182,936 182,936 - 1.00 60,250 1 2,100 1 7,500 1,500 71,350 71,350 - Sworn Lieutenant 2.00 46.67 194,887 110,009 8,000 312,895 312,895 - 2.00 120,500 2 4,200 2 15,000 3,000 142,700 142,700 - Sworn Sergeant 1.00 37.39 78,070 45,839 4,000 127,909 127,909 - 1.00 60,250 1 2,100 1 7,500 1,500 71,350 71,350 - Detention Sergeant 1.00 27.13 56,647 20,857 4,000 81,504 - 81,504 1.00 60,250 1 2,100 1 7,500 1,500 71,350 - 71,350 Legal Assistant 1.00 22.60 47,189 17,988 4,000 69,177 34,588 34,588 - - 1 2,100 - - - 2,100 2,100 - Auditor (specialized) 1.00 32.10 67,025 21,806 4,000 92,831 92,831 - - - 1 2,100 - - - 2,100 2,100 - 8.00 $ 694,002 $ 352,669 $ 32,000 $ 1,078,671 $ 856,869 $ 221,801 5.00 $ 301,250 8 $ 16,800 5 $ 37,500 $ 7,500 $ 363,050 $ 291,700 $ 71,350 79% 21% 241,000 FY 2015: 714,058 184,835 FY 2015: $ 291,700 $ 71,350 Target: 142,812 36,967 Target: - - Need in Jaunary (6 months): Deten- Supplies/ General Detention Vehicle Cost Compu- Compu- Radio Weapons General tion FTE Rate Salary Benefits Services Total Cost Fund Fund 1 Vehicles (w/MDC) ters ter Cost Radios Cost Cost Total Fund Fund Auditor (specialized)* 1.00 32.10 67,025 21,806 4,000 92,831 46,416 46,416 - - 1 2,100 - - - 2,100 2,100 - Office Assistant S 1.00 16.00 33,408 15,335 4,000 52,743 52,743 - - - 1 2,100 - - - 2,100 2,100 - 2.00 $ 100,433 $ 37,141 $ 8,000 $ 145,574 $ 99,159 $ 46,416 - - 2.00 $ 4,200 - $ - $ - $ 4,200 $ 4,200 $ - *formerly a Management Analyst FY 2015: 49,579 23,208 FY 2015: $ 4,200 Target: 49,579 23,208 Target: - Absorb if possible: Vehicle Deten- Supplies/ General Detention Cost Compu- Compu- Radio Weapons General tion FTE Rate Salary Benefits Services Total Cost Fund Fund Vehicles (w/MDC) ters ter Cost Radios Cost Cost Total Fund Fund Attorney 1.00 45.15 94,273 27,052 4,000 125,325 62,662 62,662 - - 1 2,100 - - - 2,100 2,100 - Auditor (specialized) 1.00 32.10 67,025 21,806 4,000 92,831 92,831 - - - 1 2,100 - - - 2,100 2,100 - 2.00 $ 161,298 $ 48,858 $ 8,000 $ 218,156 $ 155,493 $ 62,662 $ - $ 4,200 $ - $ - $ 4,200 $ 4,200 $ - Deten- General Detention General tion Fund Fund Fund Fund FY 2015: 763,637 208,042 FY 2015: 295,900 71,350 Target 192,391 60,175 Target: - - FY2016 $ 956,028 $ 268,217 Operating One Time Totals: GF DF GF DF Compliance 427,026 67,920 30,600 9,600 Int Oversight 763,637 208,042 295,900 71,350 1,190,663 275,962 326,500 80,950 Expenditure Impact by Fiscal Year: FY 2015 FY 2016 GF 1,517,163 1,468,460 DF 356,912 349,721 TOTAL $ 1,874,076 $ 1,818,181 2 NOT BUDGETED ORG PAS 701 750 801 Operating 804 920 FY 2015 GF 5006 RCOM 273,371 133,655 20,000 427,026 15,600 15,000 FY 2015 GF 5007 RCOM 488,777 251,860 23,000 763,637 24,900 30,000 1,190,663 40,500 45,000 NOT BUDGETED ORG PAS 701 750 801 Operating 804 920 FY 2015 DF 5006 RCOM 47,206 17,381 3,333 67,920 2,100 7,500 FY 2015 DF 5007 RCOM 139,774 60,602 7,666 208,042 3,600 7,500 275,962 5,700 15,000 FY 2016 5006 RCOM 512,432 MEL0 FY 2016 5007 RCOM 956,028 MEL0 FY 2016 5006 RCOM 81,504 MEL0 FY 2016 5007 RCOM 268,217 930 One Time - 30,600 241,000 295,900 241,000 326,500 930 One Time - 9,600 60,250 71,350 60,250 80,950