10-09-2012 02:00 PM CITY OF ELK RIVER PAGE: 21
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: SEPTEMBER 30TH, 2012
<br /> 101-GENLE_L FUND
<br /> Public Works 75.00% 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 117,909.08 71.01 48,140.92
<br /> 101-4-3150-4102 Overtime Pay 0.00 0.00 232.56 0.00 ( 232.56)
<br /> 101-4-3150-4104 PERA 12,050.00 926.02 9,019.04 74.85 3,030.96
<br /> 101-4-3150-4105 FICA 10,300.00 747.56 7,336.70 71.23 2,963.30
<br /> 101-4-3150-4107 Medicare 2,400.00 174.84 1,715.85 71.49 684.15
<br /> 101-4-3150-4108 Insurance 23,400.00 1,778.00 15,365.61 65.67 8,034.39
<br /> 101-4-3150-4109 Workers Comp 4,500.00 0.00 3,081.75 68.48 1,418.25
<br /> TOTAL Personal Services 218,700.00 16,399.22 154,660.59 70.72 64,039.41
<br /> Supplies
<br /> 101-4-3150-4219 Operating Supplies 20,200.00 499.32 5,263.94 26.06 14,936.06
<br /> 101-4-3150-4221 Equipment Parts 6,000.00 0.00 299.00 4.98 5,701.00
<br /> TOTAL Supplies 26,200.00 499.32 5,562.94 21.23 20,637.06
<br /> Other Services & Charges
<br /> 101-4-3150-4417 Uniform Rental 3,000.00 250.03 2,097.07 69.90 902.93
<br /> TOTAL Other Services & Charges 3,000.00 250.03 2,097.07 69.90 902.93
<br /> Capital Outlay
<br /> TOTAL Equipment Services 247,900.00 17,148.57 162,320.60 65.48 85,579.40
<br /> Engineering
<br /> Personal Services
<br /> 101-4-3300-4101 Regular Pay 79,250.00 11,105.66 72,447.29 91.42 6,802.71
<br /> 101-4-3300-4104 PERA 5,750.00 805.16 5,502.36 95.69 247.64
<br /> 101-4-3300-4105 FICA 4,900.00 673.75 4,572.28 93.31 327.72
<br /> 101-4-3300-4107 Medicare 1,150.00 157.58 1,069.35 92.99 80.65
<br /> 101-4-3300-4108 Insurance 14,050.00 521.00 4,689.00 33.37 9,361.00
<br /> 101-4-3300-4109 Workers Comp 550.00 0.00 432.75 78.68 117.25
<br /> TOTAL Personal Services 105,650.00 13,263.15 88,713.03 83.97 16,936.97
<br /> Supplies
<br /> 101-4-3300-4201 Office Supplies 500.00 11.80 73.18 14.64 426.82
<br /> 101-4-3300-4212 Fuels & Lubs 600.00 0.00 199.84 33.31 400.16
<br /> 101-4-3300-4219 Operating Supplies 1,000.00 0.00 161.61 16.16 838.39
<br /> TOTAL Supplies 2,100.00 11.80 434.63 20.70 1,665.37
<br /> Other Services & Charges
<br /> 101-4-3300-4319 Other Professional Services 13,500.00 0.00 2,144.34 15.88 11,355.66
<br /> 101-4-3300-4321 Telephone 700.00 32.14 208.62 29.80 491.38
<br /> 101-4-3300-4322 Postage 150.00 16.80 50.31 33.54 99.69
<br /> 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 235.00 497.12 18.41 2,202.88
<br /> 101-4-3300-4361 Insurance 200.00 0.00 91.00 45.50 109.00
<br /> 101-4-3300-4404 Equip Repair/Maint Services 7,800.00 191.49 2,016.95 25.86 5,783.05
<br />
|