8-13-2012 12:14 PM CITY OF ELK RIVER PAGE: 20
<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 8 OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> 101-4-3120-4389 Utilities 36,000.00 2,706.00 20,426.43 56.74 15,573.57
<br /> 101-4-3120-4401 Bldg Repair/Maint Services 4,500.00 80.77 1,494.20 33.20 3,005.80
<br /> 101-4-3120-4404 Equip Repair/Maint Services 5,000.00 1.33 827.32 16.55 4,172.68
<br /> 101-4-3120-4409 Contractual Services 419,000.00 1,771.36 40,054.71 9.56 378,945.29
<br /> 101-4-3120-4415 Equipment Rental 5,500.00 425.19 964.08 17.53 4,535.92
<br /> 101-4-3120-4417 Uniform Rental 4,700.00 420.46 1,187.41 25.26 3,512.59
<br /> 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 286.25 81.79 63.75
<br /> 101-4-3120-4437 Taxes & Licenses 500.00 0.00 446.00 89.20 54.00
<br /> 101-4-3120-4460 Equip Replacement Charge 95,750.00 7,979.17 55,854.19 58.33 39,895.81
<br /> TOTAL Other Services & Charges 600,950.00 14,044.96 134,502.27 22.38 466,447.73
<br /> Capital Outlay
<br /> TOTAL Street Maintenance 1,505,300.00 89,937.23 648,453.64 43.08 856,846.36
<br /> Snow Removal
<br /> Personal Services
<br /> 101-4-3130-4101 Regular Pay 100,300.00 0.00 36,833.84 36.72 63,466.16
<br /> 101-4-3130-4102 Overtime Pay 20,000.00 0.00 6,537.25 32.69 13,462.75
<br /> 101-4-3130-4103 Part-time Pay 9,100.00 0.00 4,821.54 52.98 4,278.46
<br /> 101-4-3130-4104 PERA 8,350.00 0.00 3,489.80 41.79 4,860.20
<br /> 101-4-3130-4105 FICA 8,000.00 0.00 3,028.56 37.86 4,971.44
<br /> 101-4-3130-4107 Medicare 1,900.00 0.00 708.26 37.28 1,191.74
<br /> 101-4-3130-4108 Insurance 17,100.00 0.00 6,210.18 36.32 10,889.82
<br /> 101-4-3130-4109 Workers Comp 7,650.00 0.00 4,589.25 59.99 3,060.75
<br /> TOTAL Personal Services 172,400.00 0.00 66,218.68 38.41 106,181.32
<br /> Supplies
<br /> 101-4-3130-4219 Operating Supplies 96,000.00 1,244.45 33,217.27 34.60 62,782.73
<br /> TOTAL Supplies 96,000.00 1,244.45 33,217.27 34.60 62,782.73
<br /> Other Services & Charges
<br /> Capital Outlay
<br /> 101-4-3130-4560 Equipment 20,000.00 0.00 0.00 0.00 20,000.00
<br /> TOTAL Capital Outlay 20,000.00 0.00 0.00 0.00 20,000.00
<br /> TOTAL Snow Removal 288,400.00 1,244.45 99,435.95 34.48 188,964.05
<br /> Equipment Services
<br />
|