8-13-2012 12:14 PM CITY OF ELK RIVER PAGE: 22
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JULY 31ST, 2012
<br /> 101-GENERAL FUND
<br /> Public Works 58.33% OF YEAR COMP.
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 437.50 58.33 312.50
<br /> TOTAL Other Services & Charges 25,800.00 1,277.44 3,828.14 14.84 21,971.86
<br /> Capital Outlay _
<br /> TOTAL Engineering 133,550.00 10,216.04 65,373.91 48.95 68,176.09
<br /> TOTAL Public Works 2,175,150.00 118,544.82 933,424.67 42.91 1,241,725.33
<br /> Parks Department
<br /> Personal Services
<br /> 101-4-5110-4101 Regular Pay 344,300.00 23,400.85 177,922.30 51.68 166,377.70
<br /> 101-4-5110-4102 Overtime Pay 6,600.00 939.99 1,292.39 19.58 5,307.61
<br /> 101-4-5110-4103 Part-time Pay 58,250.00 13,939.24 34,352.19 58.97 23,897.81
<br /> 101-4-5110-4104 PERA 26,900.00 1,995.30 14,235.46 52.92 12,664.54
<br /> 101-4-5110-4105 FICA 25,500.00 2,263.14 13,391.45 52.52 12,108.55
<br /> 101-4-5110-4107 Medicare 6,000.00 529.27 3,131.78 52.20 2,868.22
<br /> 101-4-5110-4108 Insurance 46,200.00 3,357.36 25,585.52 55.38 20,614.48
<br /> 101-4-5110-4109 Workers Comp 10,850.00 0.00 7,746.00 71.39 3,104.00
<br /> 101-4-5110-4110 Re-employment Compensation 0.00 0.00 1,350.87 0.00 ( 1,350.87)
<br /> TOTAL Personal Services 524,600.00 46,425.15 279,007.96 53.18 245,592.04
<br /> Supplies
<br /> 101-4-5110-4212 Fuels & Lubs 39,100.00 2,273.83 14,187.34 36.28 24,912.66
<br /> 101-4-5110-4217 Uniform Allowance 3,200.00 18.75 1,304.23 40.76 1,895.77
<br /> 101-4-5110-4219 Operating Supplies 78,250.00 3,866.22 47,590.03 60.82 30,659.97
<br /> 101-4-5110-4221 Equipment Parts 13,000.00 2,281.21 13,150.85 101.16 ( 150.85)
<br /> TOTAL Supplies 133,550.00 8,440.01 76,232.45 57.08 57,317.55
<br /> Other Services & Charges
<br /> 101-4-5110-4321 Telephone 3,800.00 430.41 1,654.81 43.55 2,145.19
<br /> 101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00
<br /> 101-4-5110-4331 Travel, Conferences & Schools 3,150.00 0.00 2,206.91 70.06 943.09
<br /> 101-4-5110-4361 Insurance 27,600.00 0.00 12,020.50 43.55 15,579.50
<br /> 101-4-5110-4389 Utilities 24,700.00 1,495.17 4,361.77 17.66 20,338.23
<br /> 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 25.65 0.64 3,974.35
<br /> 101-4-5110-4404 Equip Repair/Maint Services 13,100.00 1,272.44 5,710.92 43.59 7,389.08
<br /> 101-4-5110-4409 Contractual Services 7,300.00 2,003.50 3,552.97 48.67 3,747.03
<br /> 101-4-5110-4415 Equipment Rental 20,500.00 1,609.38 5,718.26 27.89 14,781.74
<br /> 101-4-5110-4460 Equip Replacement Charge 51,450.00 4,287.50 30,012.50 58.33 21,437.50
<br /> TOTAL Other Services & Charges 155,650.00 11,098.40 65,264.29 41.93 90,385.71
<br />
|