8-13-2012 12:14 PM CITY OF ELK RIVER PAGE: 21
<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 /> Personal Services
<br /> 101-4-3150-4101 Regular Pay 166,050.00 12,772.80 85,977.08 51.78 80,072.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 6,703.99 55.63 5,346.01
<br /> 101-4-3150-4105 FICA 10,300.00 747.56 5,445.62 52.87 4,854.38
<br /> 101-4-3150-4107 Medicare 2,400.00 174.84 1,273.58 53.07 1,126.42
<br /> 101-4-3150-4108 Insurance 23,400.00 1,778.00 11,809.61 50.47 11,590.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 114,524.19 52.37 104,175.81
<br /> Supplies
<br /> 101-4-3150-4219 Operating Supplies 20,200.00 501.35 4,063.29 20.12 16,136.71
<br /> 101-4-3150-4221 Equipment Parts 6,000.00 0.00 0.00 0.00 6,000.00
<br /> TOTAL Supplies 26,200.00 501.35 4,063.29 15.51 22,136.71
<br /> Other Services & Charges
<br /> 101-4-3150-4417 Uniform Rental 3,000.00 246.53 1,573.69 52.46 1,426.31
<br /> TOTAL Other Services & Charges 3,000.00 246.53 1,573.69 52.46 1,426.31
<br /> Capital Outlay
<br /> TOTAL Equipment Services 247,900.00 17,147.10 120,161.17 48.47 127,738.83
<br /> Engineering
<br /> Personal Services
<br /> 101-4-3300-4101 Regular Pay 79,250.00 7,171.66 49,379.38 62.31 29,870.62
<br /> 101-4-3300-4104 PERA 5,750.00 519.94 3,829.94 66.61 1,920.06
<br /> 101-4-3300-4105 FICA 4,900.00 429.84 3,171.67 64.73 1,728.33
<br /> 101-4-3300-4107 Medicare 1,150.00 100.53 741.77 64.50 408.23
<br /> 101-4-3300-4108 Insurance 14,050.00 521.00 3,647.00 25.96 10,403.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 8,742.97 61,202.51 57.93 44,447.49
<br /> Supplies
<br /> 101-4-3300-4201 Office Supplies 500.00 4.21 42.29 8.46 457.71
<br /> 101-4-3300-4212 Fuels & Lubs 600.00 45.81 139.36 23.23 460.64
<br /> 101-4-3300-4219 Operating Supplies 1,000.00 145.61 161.61 16.16 838.39
<br /> TOTAL Supplies 2,100.00 195.63 343.26 16.35 1,756.74
<br /> Other Services & Charges
<br /> 101-4-3300-4319 Other Professional Services 13,500.00 946.00 1,231.69 9.12 12,268.31
<br /> 101-4-3300-4321 Telephone 700.00 31.84 141.79 20.26 558.21
<br /> 101-4-3300-4322 Postage 150.00 0.00 33.51 22.34 116.49
<br /> 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 46.62 262.12 9.71 2,437.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 190.48 1,630.53 20.90 6,169.47
<br />
|