|
12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 21
<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 /> Personal Services
<br /> 101-4-3150-4101 Regular Pay 166,050.00 12,772.80 143,454.68 86.39 22,595.32
<br /> 101-4-3150-4102 Overtime Pay 0.00 0.00 348.84 0.00 ( 348.84)
<br /> 101-4-3150-4104 PERA 12,050.00 926.02 10,879.51 90.29 1,170.49
<br /> 101-4-3150-4105 FICA 10,300.00 747.56 8,839.03 85.82 1,460.97
<br /> 101-4-3150-4107 Medicare 2,400.00 174.84 2,067.22 86.13 332.78
<br /> 101-4-3150-4108 Insurance 23,400.00 1,778.00 18,921.61 80.86 4,478.39
<br /> 101-4-3150-4109 Workers Comp 4,500.00 0.00 4,235.75 94.13 264.25
<br /> TOTAL Personal Services 218,700.00 16,399.22 188,746.64 86.30 29,953.36
<br /> Supplies
<br /> 101-4-3150-4219 Operating Supplies 20,200.00 433.13 6,513.93 32.25 13,686.07
<br /> 101-4-3150-4221 Equipment Parts 6,000.00 2,700.00 4,394.36 73.24 1,605.64
<br /> TOTAL Supplies 26,200.00 3,133.13 10,908.29 41.63 15,291.71
<br /> Other Services & Charges
<br /> 101-4-3150-4417 Uniform Rental 3,000.00 295.07 2,614.32 87.14 385.68
<br /> TOTAL Other Services & Charges 3,000.00 295.07 2,614.32 87.14 385.68
<br /> Capital Outlay
<br /> TOTAL Equipment Services 247,900.00 19,827.42 202,269.25 81.59 45,630.75
<br /> Engineering
<br /> Personal Services
<br /> 101-4-3300-4101 Regular Pay 79,250.00 11,305.50 95,058.29 119.95 ( 15,808.29)
<br /> 101-4-3300-4104 PERA 5,750.00 819.64 7,141.64 124.20 ( 1,391.64)
<br /> 101-4-3300-4105 FICA 4,900.00 686.14 5,944.56 121.32 ( 1,044.56)
<br /> 101-4-3300-4107 Medicare 1,150.00 160.48 1,390.31 120.90 ( 240.31)
<br /> 101-4-3300-4108 Insurance 14,050.00 1,042.00 7,294.00 51.91 6,756.00
<br /> 101-4-3300-4109 Workers Comp 550.00 0.00 597.00 108.55 ( 47.00)
<br /> TOTAL Personal Services 105,650.00 14,013.76 117,425.80 111.15 ( 11,775.80)
<br /> Supplies
<br /> 101-4-3300-4201 Office Supplies 500.00 5.33 150.06 30.01 349.94
<br /> 101-4-3300-4212 Fuels & Lubs 600.00 108.07 358.27 59.71 241.73
<br /> 101-4-3300-4219 Operating Supplies 1,000.00 41.72 1,565.99 156.60 ( 565.99)
<br /> TOTAL Supplies 2,100.00 155.12 2,074.32 98.78 25.68
<br /> Other Services & Charges
<br /> 101-4-3300-4319 Other Professional Services 13,500.00 0.00 3,488.34 25.84 10,011.66
<br /> 101-4-3300-4321 Telephone 700.00 355.55 618.80 88.40 81.20
<br /> 101-4-3300-4322 Postage 150.00 0.00 50.31 33.54 99.69
<br /> 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 75.48 572.60 21.21 2,127.40
<br /> 101-4-3300-4361 Insurance 200.00 101.00 192.00 96.00 8.00
<br /> 101-4-3300-4404 Equip Repair/Maint Services 7,800.00 196.00 2,497.08 32.01 5,302.92
<br />
|