|
Ramsey County Sheriff's OfficeContract Police Services: Administrative Overhead# of Employees111 2 3121Pro Rata Share12.97% 12.97% 12.97% 12.97% 12.97% 11.65% 11.65% 11.65% 11.65% 11.65%Account Description Accountant IV Accountant IV Total Accountant II Accountant II Total Account Specialist 2Account Specialist 2 TotalPersonnel Transactions AssistantPersonnel Transactions Assistant TotalDeputy Sheriff Deputy Sheriff Total Deputy CommanderDeputy Commander TotalInvestigative AssistantInvestigative Assistant TotalIS LAN SpecialistIS LAN Specialist TotalTraining Supplies Training SuppliesAdmin Central Support Overhead TotalPersonnel Services411101 Annual 107,632.45$ 13,956.74$ 88,366.87$ 11,458.56$ 60,955.21$ 7,904.08$ 83,387.20$ 29,139.70$ 130,083.20$ 15,152.55$ 76,618.87$ 8,924.84$ 85,177.75$ 9,921.80$ ‐$ 96,458.27$ 411104 Overtime ‐$ ‐ ‐$ ‐ ‐$ ‐ 14,175.82 4,953.75 22,114.14 2,575.93 ‐ ‐ ‐ ‐ ‐ 7,529.68 411112 Deferred Compensation 420.00$ 54.46 420.00$ 54.46 420.00$ 54.46 300.00 104.84 420.00 48.92 420.00 48.92 420.00 48.92 ‐ 414.99 411117 Salary Differential & Premium Pay ‐$ ‐ ‐$ ‐ ‐$ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 411201 PERA 8,103.93$ 1,050.84 6,659.02$ 863.48 4,603.14$ 596.89 17,321.76 6,053.10 27,013.27 3,146.60 5,777.92 673.03 6,419.83 747.80 ‐ 13,131.74 411202 FICA ‐ Social Sec 6,673.21$ 865.32 5,478.75$ 710.43 3,779.22$ 490.05 ‐ ‐ ‐ ‐ 4,750.37 553.34 5,281.02 615.15 ‐ 3,234.29 411203 FICA ‐ Medicare 1,566.76$ 203.16 1,287.41$ 166.94 889.94$ 115.40 1,419.01 495.88 2,212.95 257.77 1,117.06 130.12 1,241.17 144.58 ‐ 1,513.84 411306 Life Insurance 95.00$ 12.32 95.00$ 12.32 95.00$ 12.32 95.00 33.20 95.00 11.07 95.00 11.07 95.00 11.07 ‐ 103.35 411307 Long‐Term Disability 87.60$ 11.36 87.60$ 11.36 87.60$ 11.36 87.60 30.61 87.60 10.20 87.60 10.20 87.60 10.20 ‐ 95.30 411309 Health Care Savings Plan 315.00$ 40.85 315.00$ 40.85 315.00$ 40.85 315.00 110.08 315.00 36.69 315.00 36.69 315.00 36.69 ‐ 342.69 411301 Health & Welfare Insurance 19,642.92$ 2,547.10 16,126.95$ 2,091.19 11,124.33$ 1,442.50 15,218.16 5,318.00 23,740.18 2,765.34 13,982.94 1,628.78 15,544.94 1,810.73 ‐ 17,603.63 411310 OPEB Liability 6,457.95$ 837.40 5,302.01$ 687.51 3,657.31$ 474.24 5,853.78 2,045.61 9,131.84 1,063.71 4,597.13 535.49 5,110.66 595.31 ‐ 6,239.28 Total: Personnel Services 150,994.83$ 19,579.55$ 124,138.60$ 16,097.09$ 85,926.75$ 11,142.15$ 138,173.34$ 48,284.75$ 215,213.19$ 25,068.79$ 107,761.90$ 12,552.49$ 119,692.97$ 13,942.26$ ‐$ ‐$ 146,667.07$ Other Services & Charges421801 Workers Compensation Expenses ‐$ 423111 Employee Training/Development 300.00 38.90 300.00 38.90 300.00 38.90 300.00 104.84 ‐ ‐ 300.00 34.95 300.00 34.95 ‐ 291.43 Total: Other Services & Charges 300.00$ 38.90$ 300 38.9010989300.00$ 38.90$ 300.00$ 104.84$ ‐$ ‐$ 300.00$ 34.95$ 300.00$ 34.95$ ‐$ ‐$ 291.43$ Supplies421603 Printing & Stationary 15,000.00 1,945.05 1,945.05 421701 Postage 17,000.00 2,204.40 2,204.40 421709 Cable Television Services 8,500.00$ 1,102.20$ 1,102.20 423309 Records Storage/Retriev Fees 1,200.00 155.60 155.60 424501 Mileage 200.00 25.93 25.93 424507 Messenger Service 8,500.00$ 1,102.20$ 1,102.20 424604 Reim For Damaged Pers Prop 1,000.00 129.67 129.67 424620 Books Periodicals & Subscriptn 2,500.00 324.18 324.18 432001 Bottled Water 7,000.00 907.69 907.69 431105 Uniforms and Clothing 900.00$ 314.51$ 900.00$ 104.84$ ‐$ ‐$ 419.34 431115 Instructional Supplies 10,000.00 1,164.84 1,164.84 431302 Law Enforcement Supplies 80,000.00 9,318.68 9,318.68 431304 Firearm Supplies 80,000.00 9,318.68 9,318.68 Total: Supplies ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ 900.00$ 314.51$ 900.00$ 104.84$ ‐$ ‐$ ‐$ ‐$ 170,000.00$ 19,802.20$ 28,118.46$ Capital Outlay44x Total: Capital Outlay ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Total Annual Cost151,294.83$ 19,618.45$ 124,438.60$ 16,135.99$ 86,226.75$ 11,181.05$ ‐$ ‐$ 139,373.34$ 48,704.09$ 216,113.19$ 25,173.62$ 108,061.90$ 12,587.43$ 119,992.97$ 13,977.20$ 170,000.00$ 19,802.20$ 175,076.96$ # of Employees1 1 4.5Pro Rata Share55.14% 55.14% 55.14% 55.14%Account Description Undersheriff Undersheriff Total Deputy Commander Deputy Commander Total Deputy Sergeant Deputy Sergeant TotalOther Budgeted Patrol CostsOther Budgeted Patrol Costs TotalPatrol Support Overhead TotalPersonnel Services411101 Annual 162,317.82$ 89,502.35$ 130,083.20$ 71,728.12$ 114,649.60$ 284,481.02$ ‐$ 445,711.48$ 411104 Overtime 27,594.03$ 15,215.40 22,114.14$ 12,193.78 19,490.43$ 48,361.77 ‐ 75,770.95 411112 Deferred Compensation 420.00$ 231.59 420.00$ 231.59 420.00$ 1,042.15 ‐ 1,505.33 411117 Salary Differential & Premium Pay ‐$ ‐ ‐$ ‐ ‐$ ‐ ‐ ‐ 411201 PERA 33,688.74$ 18,576.03 27,013.27$ 14,895.17 23,817.13$ 59,097.63 ‐ 92,568.83 411202 FICA ‐ Social Sec ‐$ ‐ ‐$ ‐ ‐$ ‐ ‐ ‐ 411203 FICA ‐ Medicare 2,759.81$ 1,521.77 2,212.95$ 1,220.23 1,951.12$ 4,841.33 ‐ 7,583.32 411306 Life Insurance 95.00$ 52.38 95.00$ 52.38 95.00$ 235.72 ‐ 340.49 411307 Long‐Term Disability 87.60$ 48.30 87.60$ 48.30 87.60$ 217.36 ‐ 313.97 411309 Health Care Savings Plan 315.00$ 173.69 315.00$ 173.69 315.00$ 781.61 ‐ 1,129.00 411301 Health & Welfare Insurance 29,623.00$ 16,334.18 23,740.18$ 13,090.38 20,923.55$ 51,917.79 ‐ 81,342.35 411310 OPEB Liability 11,394.71$ 6,283.06 9,131.84$ 5,035.31 8,048.40$ 19,970.57 ‐ 31,288.95 Total: Personnel Services 268,295.71$ 147,938.75$ 215,213.19$ 118,668.96$ 189,797.83$ 470,946.96$ ‐$ ‐$ 737,554.67$ Other Services & Charges421317 Animal Health Services 20,000.00$ 11,028.04$ 11,028.04$ 421514 Investigating Service 2,500.00 1,378.50 1,378.50 421801 Workers Compensation 422201 Laundry & Sanitation Service ‐ ‐ 422402 Buildings & Office Space 422403 Parking Space ‐ ‐ ‐ 422502 Equipment & Machinery Rental 15,000.00 8,271.03 8,271.03 423111 Employee Training/Development ‐ ‐ ‐ ‐ 300.00 1,350.00 5,000.00 2,757.01 4,107.01 423305 Towing Charges 30,000.00 16,542.06 16,542.06 424601 Other Services ‐ ‐ ‐ Total: Other Services & Charges ‐$ ‐$ 00300.00$ 1,350.00$ 72,500.00$ 39,976.64$ 41,326.64$ Supplies431101 Office Supplies 20,000.00$ 11,028.04$ 11,028.04$ 431105 Uniforms and Clothing 900.00 496.26 900.00 496.26 900.00 2,233.18 ‐ ‐ 3,225.70 431205 First Aid Supplies 10,000.00 5,514.02 5,514.02 431301 Investigation Supplies 3,000.00 1,654.21 1,654.21 431302 Law Enforcement Supplies 15,000.00 8,271.03 8,271.03 431303 Identification Supplies 1,000.00 551.40 551.40 431501 Bldg Materials & Supplies 5,000.00 2,757.01 2,757.01 431701 Custodial Supplies 500.00 275.70 275.70 432103 Misc Supplies & Materials 3,500.00 1,929.91 1,929.91 432104 Canine Supplies 15,000.00 8,271.03 8,271.03 Total: Supplies 900.00$ 496.26$ 900.00$ 496.26$ 900.00$ 2,233.18$ 73,000.00$ 40,252.34$ 43,478.04$ Capital Outlay443101 Equipment Costs‐ Current Expense 10,000.00$ 5,514.02$ 5,514.02$ Total: Capital Outlay ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ 10,000.00$ 5,514.02$ 5,514.02$ Total Annual Cost269,195.71$ 148,435.02$ 216,113.19$ 119,165.22$ 190,997.83$ 474,530.13$ 155,500.00$ 85,742.99$ 827,873.36$ TOTAL 1,002,950.32$ Per Employee16,999.16$ Employee Statistical DataAssigned Employees% of Dept TotalDepartment Personnel Total455100%% of Division103Patrol Division Personnel10723.52% 100%63Contract Cities Personnel5912.97% 55.14%% of Sworn239Sworn Personnel Total23952.53% 100%58Contract Cities Sworn Personnel5311.65% 22.18%Moved to Services tab as it is a direct RC chargeMoved to Services tab as it is a direct RC chargeTraining Supplies480401480101Human Resources & PayrollFinanceAdmin Services & Supplies Training Body & Squad CamerasMoved to Services Tab as it is a direct RC charge
|