Ramsey County Sheriff's Office
<br />Contract Police Services: Administrative Overhead
<br /># of Employees 1 1 1 0 3 1 2 1
<br />Pro Rata Share 13.53%13.53%13.53%0.00%13.53%12.42%12.42%12.42%12.42%12.42%
<br />Account Description Accountant Principal Accountant Principal
<br />Total Accountant Senior Accountant Senior Total Accountant Accountant Total Personnel Transactions
<br />Assistant
<br />Personnel Transactions
<br />Assistant Total Deputy Sheriff Deputy Sheriff Total Deputy Commander Deputy Commander
<br />Total
<br />Investigative
<br />Assistant
<br />Investigative
<br />Assistant Total IS LAN Specialist IS LAN Specialist
<br />Total Training Supplies Training Supplies Admin Central Support
<br />Overhead Total
<br />Personnel Services
<br />411101 Annual 117,328.43$ 15,869.26$ 96,423.76$ 13,041.79$ 85,720.37$ 11,594.11$ 109,387.20$ 40,747.34$ 141,046.72$ 17,513.56$ 79,380.31$ 9,856.53$ 85,558.97$ 10,623.73$ -$ 119,246.32$
<br />411104 Overtime -$ - -$ - -$ - 18,595.82 6,927.05 23,977.94 2,977.31 - - - - - 9,904.35
<br />411112 Deferred Compensation 260.00$ 35.17 260.00$ 35.17 260.00$ 35.17 260.00 96.85 260.00 32.28 260.00 32.28 260.00 32.28 - 299.20
<br />411117 Salary Differential & Premium Pay -$ - -$ - -$ - 5,469.36 2,037.37 7,052.34 875.68 - - - - - 2,913.04
<br />411201 PERA 8,799.63$ 1,190.19 7,231.78$ 978.13 6,429.03$ 869.56 22,653.00 8,438.37 29,209.36 3,626.88 5,953.52 739.24 6,416.92 796.78 - 16,639.16
<br />411202 FICA - Social Sec 7,274.36$ 983.89 5,978.27$ 808.59 5,314.66$ 718.83 - - - - 4,921.58 611.11 5,304.66 658.67 - 3,781.10
<br />411203 FICA - Medicare 1,701.26$ 230.10 1,398.14$ 189.11 1,242.95$ 168.11 1,855.75 691.28 2,392.86 297.12 1,151.01 142.92 1,240.61 154.04 - 1,872.68
<br />411306 Life Insurance 78.00$ 10.55 78.00$ 10.55 78.00$ 10.55 78.00 29.06 78.00 9.69 78.00 9.69 78.00 9.69 - 89.76
<br />411307 Long-Term Disability 111.46$ 15.08 91.60$ 12.39 81.43$ 11.01 103.92 38.71 133.99 16.64 75.41 9.36 81.28 10.09 - 113.28
<br />411309 Health Care Savings Plan 300.00$ 40.58 300.00$ 40.58 300.00$ 40.58 300.00 111.75 300.00 37.25 300.00 37.25 300.00 37.25 - 345.23
<br />411301 Health & Welfare Insurance 21,999.08$ 2,975.49 18,079.45$ 2,445.34 16,072.57$ 2,173.90 20,510.10 7,640.13 26,446.26 3,283.79 14,883.81 1,848.10 16,042.31 1,991.95 - 22,358.69
<br />411310 OPEB Liability 7,039.71$ 952.16 5,785.43$ 782.51 5,143.22$ 695.65 7,678.98 2,860.46 9,901.48 1,229.45 4,762.82 591.39 5,133.54 637.42 - 7,749.04
<br /> Total: Personnel Services 164,891.93$ 22,302.46$ 135,626.44$ 18,344.15$ 120,642.23$ 16,317.46$ 186,892.13$ 69,618.36$ 240,798.95$ 29,899.65$ 111,766.46$ 13,877.88$ 120,416.28$ 14,951.91$ -$ -$ 185,311.86$
<br />Other Services & Charges
<br />421801 Workers Compensation Expenses -$
<br />423111 Employee Training/Development - - - - - - - - - - - - - - - -
<br /> Total: Other Services & Charges -$ -$ 0 0 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br />Supplies
<br />421603 Printing & Stationary 15,000.00 2,028.82 2,028.82
<br />421701 Postage 17,000.00 2,299.33 2,299.33
<br />421709 Cable Television Services 8,500.00$ 1,149.67$ 1,149.67
<br />423309 Records Storage/Retriev Fees 1,200.00 162.31 162.31
<br />424501 Mileage 200.00 27.05 27.05
<br />424507 Messenger Service 8,500.00$ 1,149.67$ 1,149.67
<br />424604 Reim For Damaged Pers Prop 1,000.00 135.25 135.25
<br />424620 Books Periodicals & Subscriptn 2,500.00 338.14 338.14
<br />432001 Bottled Water 7,000.00 946.78 946.78
<br />431105 Uniforms and Clothing 985.00$ 366.92$ 1,000.00$ 124.17$ -$ -$ 491.09
<br />431115 Instructional Supplies 10,000.00 1,241.69 1,241.69
<br />431302 Law Enforcement Supplies 80,000.00 9,933.48 9,933.48
<br />431304 Firearm Supplies 80,000.00 9,933.48 9,933.48
<br /> Total: Supplies -$ -$ -$ -$ -$ -$ -$ -$ 985.00$ 366.92$ 1,000.00$ 124.17$ -$ -$ -$ -$ 170,000.00$ 21,108.65$ 29,836.76$
<br />Capital Outlay
<br />44x
<br /> Total: Capital Outlay -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br />Total Annual Cost 164,891.93$ 22,302.46$ 135,626.44$ 18,344.15$ 120,642.23$ 16,317.46$ -$ -$ 187,877.13$ 69,985.27$ 241,798.95$ 30,023.82$ 111,766.46$ 13,877.88$ 120,416.28$ 14,951.91$ 170,000.00$ 21,108.65$ 215,148.62$
<br /># of Employees 1 1 4.5
<br />Pro Rata Share 57.55%57.55%57.55%57.55%
<br />Account Description Undersheriff Undersheriff Total Deputy Commander Deputy Commander Total Deputy Sergeant Deputy Sergeant Total Other Budgeted Patrol
<br />Costs
<br />Other Budgeted Patrol
<br />Costs Total
<br />Patrol Support
<br />Overhead Total
<br />Personnel Services
<br />411101 Annual 159,625.29$ 91,859.84$ 141,046.72$ 81,168.39$ 129,103.52$ 334,329.40$ -$ 507,357.63$
<br />411104 Overtime 27,136.30$ 15,616.17 23,977.94$ 13,798.63 21,947.60$ 56,836.00 - 86,250.80
<br />411112 Deferred Compensation 260.00$ 149.62 260.00$ 149.62 260.00$ 673.30 - 972.55
<br />411117 Salary Differential & Premium Pay -$ - 7,052.34$ 4,058.42 6,455.18$ 16,716.47 - 20,774.89
<br />411201 PERA 33,056.80$ 19,023.25 29,209.36$ 16,809.16 26,736.05$ 69,236.28 - 105,068.69
<br />411202 FICA - Social Sec -$ - -$ - -$ - - -
<br />411203 FICA - Medicare 2,708.04$ 1,558.40 2,392.86$ 1,377.02 2,190.24$ 5,671.90 - 8,607.32
<br />411306 Life Insurance 78.00$ 44.89 78.00$ 44.89 78.00$ 201.99 - 291.76
<br />411307 Long-Term Disability 151.64$ 87.27 133.99$ 77.11 122.65$ 317.61 - 481.99
<br />411309 Health Care Savings Plan 300.00$ 172.64 300.00$ 172.64 300.00$ 776.89 - 1,122.17
<br />411301 Health & Welfare Insurance 29,929.74$ 17,223.72 26,446.26$ 15,219.07 24,206.91$ 62,686.76 - 95,129.56
<br />411310 OPEB Liability 11,205.70$ 6,448.56 9,901.48$ 5,698.02 9,063.07$ 23,469.92 - 35,616.51
<br /> Total: Personnel Services 264,451.52$ 152,184.36$ 240,798.95$ 138,572.98$ 220,463.21$ 570,916.52$ -$ -$ 861,673.86$
<br />Other Services & Charges
<br />421317 Animal Health Services 20,000.00$ 11,509.43$ 11,509.43$
<br />421514 Investigating Service 2,500.00 1,438.68 1,438.68
<br />421801 Workers Compensation
<br />422201 Laundry & Sanitation Service - -
<br />422402 Buildings & Office Space
<br />422403 Parking Space - - -
<br />422502 Equipment & Machinery Rental 15,000.00 8,632.08 8,632.08
<br />423111 Employee Training/Development - - - - - - 5,000.00 2,877.36 2,877.36
<br />423305 Towing Charges 30,000.00 17,264.15 17,264.15
<br />424601 Other Services - - -
<br /> Total: Other Services & Charges -$ -$ 0 0 -$ -$ 72,500.00$ 41,721.70$ 41,721.70$
<br />Supplies
<br />431101 Office Supplies 20,000.00$ 11,509.43$ 11,509.43$
<br />431105 Uniforms and Clothing 1,000.00 575.47 1,000.00 575.47 985.00 2,550.78 - - 3,701.72
<br />431205 First Aid Supplies 10,000.00 5,754.72 5,754.72
<br />431301 Investigation Supplies 3,000.00 1,726.42 1,726.42
<br />431302 Law Enforcement Supplies 15,000.00 8,632.08 8,632.08
<br />431303 Identification Supplies 1,000.00 575.47 575.47
<br />431501 Bldg Materials & Supplies 5,000.00 2,877.36 2,877.36
<br />431701 Custodial Supplies 500.00 287.74 287.74
<br />432103 Misc Supplies & Materials 3,500.00 2,014.15 2,014.15
<br />432104 Canine Supplies 15,000.00 8,632.08 8,632.08
<br /> Total: Supplies 1,000.00$ 575.47$ 1,000.00$ 575.47$ 985.00$ 2,550.78$ 73,000.00$ 42,009.43$ 45,711.16$
<br />Capital Outlay
<br />443101 Equipment Costs- Current Expense 10,000.00$ 5,754.72$ 5,754.72$
<br /> Total: Capital Outlay -$ -$ -$ -$ -$ -$ 10,000.00$ 5,754.72$ 5,754.72$
<br />Total Annual Cost 265,451.52$ 152,759.84$ 241,798.95$ 139,148.45$ 221,448.21$ 573,467.30$ 155,500.00$ 89,485.85$ 954,861.44$
<br />TOTAL 1,170,010.06$
<br />Per Employee 19,180.49$
<br />Employee Statistical Data
<br />Assigned Employees % of Dept Total
<br />Department Personnel Total 451 100%
<br />% of Division
<br />Patrol Division Personnel 106 23.50%100%
<br />Contract Cities Personnel 61 13.53%57.55%
<br />% of Sworn
<br />Sworn Personnel Total 239 52.99%100%
<br />Contract Cities Sworn Personnel 56 12.42%23.43%
<br />Moved to Services tab as it is a direct RC charge
<br />Moved to Services tab as it is a direct RC charge
<br />Training Supplies
<br />480401
<br />480101
<br />Human Resources & PayrollFinance Admin Services & Supplies Training Body & Squad Cameras
<br />Moved to Services Tab as it is a direct RC charge
|