12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: NOVEMBER 30TH, 2012
<br /> 101-GENERAL FUND
<br /> Public Works 91.67% OF YEAR COMP.
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> 101-4-3120-4389 Utilities 36,000.00 3,210.72 31,784.10 88.29 4,215.90
<br /> 101-4-3120-4401 Bldg Repair/Maint Services 4,500.00 0.00 1,774.97 39.44 2,725.03
<br /> 101-4-3120-4404 Equip Repair/Maint Services 5,000.00 5,432.19 6,553.29 131.07 ( 1,553.29)
<br /> 101-4-3120-4409 Contractual Services 419,000.00 ( 24,327.91) 346,571.45 82.71 72,428.55
<br /> 101-4-3120-4415 Equipment Rental 5,500.00 96.19 1,348.84 24.52 4,151.16
<br /> 101-4-3120-4417 Uniform Rental 4,700.00 844.39 2,500.59 53.20 2,199.41
<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 471.00 94.20 29.00
<br /> 101-4-3120-4460 Equip Replacement Charge 95,750.00 7,979.17 87,770.87 91.67 7,979.13
<br /> TOTAL Other Services & Charges 600,950.00 4,030.39 504,832.56 84.01 96,117.44
<br /> Capital Outlay
<br /> TOTAL Street Maintenance 1,505,300.00 78,058.23 1,352,465.45 89.85 152,834.55
<br /> Snow Removal
<br /> Personal Services
<br /> 101-4-3130-4101 Regular Pay 100,300.00 0.00 36,949.19 36.84 63,350.81
<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,498.17 41.89 4,851.83
<br /> 101-4-3130-4105 FICA 8,000.00 0.00 3,035.71 37.95 4,964.29
<br /> 101-4-3130-4107 Medicare 1,900.00 0.00 709.93 37.36 1,190.07
<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 6,305.25 82.42 1,344.75
<br /> TOTAL Personal Services 172,400.00 0.00 68,067.22 39.48 104,332.78
<br /> Supplies
<br /> 101-4-3130-4219 Operating Supplies 96,000.00 2,337.62 35,650.54 37.14 60,349.46
<br /> TOTAL Supplies 96,000.00 2,337.62 35,650.54 37.14 60,349.46
<br /> Other Services & Charges
<br /> Capital Outlay
<br /> 101-4-3130-4560 Equipment 20,000.00 0.00 18,622.70 93.11 1,377.30
<br /> TOTAL Capital Outlay 20,000.00 0.00 18,622.70 93.11 1,377.30
<br /> TOTAL Snow Removal 288,400.00 2,337.62 122,340.46 42.42 166,059.54
<br /> Equipment Services
<br />
|