|
<br /> 6-14-2017 06:02 PM CITY OF ELK RIVER PAGE: 22
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MAY 31ST, 2017
<br />101-GENERAL FUND
<br />Public Works 41.67% OF YEAR COMP.
<br />
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br />DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />___________________________________________________________________________________________________________________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Engineering 218,500.00 17,033.07 84,102.12 38.49 134,397.88
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Public Works 2,025,300.00 149,451.73 762,773.23 37.66 1,262,526.77
<br />Parks Department
<br />================
<br />Personal Services
<br />101-4-5110-4101 Regular Pay 405,150.00 31,406.76 149,232.70 36.83 255,917.30
<br />101-4-5110-4102 Overtime Pay 6,600.00 81.71 1,370.61 20.77 5,229.39
<br />101-4-5110-4103 Part-time Pay 68,250.00 3,120.00 3,120.00 4.57 65,130.00
<br />101-4-5110-4104 PERA 30,900.00 2,408.66 11,342.68 36.71 19,557.32
<br />101-4-5110-4105 FICA 29,250.00 1,994.71 8,826.75 30.18 20,423.25
<br />101-4-5110-4107 Medicare 6,900.00 466.49 2,058.15 29.83 4,841.85
<br />101-4-5110-4108 Insurance 79,300.00 6,476.50 32,382.50 40.84 46,917.50
<br />101-4-5110-4109 Workers Comp 12,250.00 0.00 7,657.00 62.51 4,593.00
<br />101-4-5110-4110 Re-employment Compensation 0.00 2,225.00 2,225.00 0.00 ( 2,225.00)
<br /> TOTAL Personal Services 638,600.00 48,179.83 218,215.39 34.17 420,384.61
<br />Supplies
<br />101-4-5110-4212 Fuels & Lubes 25,000.00 194.26 5,231.11 20.92 19,768.89
<br />101-4-5110-4217 Uniform Allowance 3,800.00 464.95 1,446.03 38.05 2,353.97
<br />101-4-5110-4219 Operating Supplies 97,000.00 9,987.35 25,245.86 26.03 71,754.14
<br />101-4-5110-4221 Equipment Parts 27,000.00 2,469.80 5,982.88 22.16 21,017.12
<br /> TOTAL Supplies 152,800.00 13,116.36 37,905.88 24.81 114,894.12
<br />Other Services & Charges
<br />101-4-5110-4321 Telephone 5,050.00 272.17 1,131.35 22.40 3,918.65
<br />101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00
<br />101-4-5110-4331 Travel, Conferences & Schools 4,800.00 674.00 1,267.50 26.41 3,532.50
<br />101-4-5110-4361 Insurance 33,500.00 0.00 16,425.50 49.03 17,074.50
<br />101-4-5110-4389 Utilities 76,000.00 2,660.08 10,288.29 13.54 65,711.71
<br />101-4-5110-4401 Bldg Repair/Maint Services 2,000.00 1,069.00 3,322.56 166.13 ( 1,322.56)
<br />101-4-5110-4404 Equip Repair/Maint Services 16,500.00 750.00 1,796.78 10.89 14,703.22
<br />101-4-5110-4409 Contractual Services 45,100.00 1,847.79 3,538.79 7.85 41,561.21
<br />101-4-5110-4415 Equipment Rental 22,200.00 939.46 6,938.46 31.25 15,261.54
<br />101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 21,375.00 41.67 29,925.00
<br /> TOTAL Other Services & Charges 256,550.00 12,487.50 66,084.23 25.76 190,465.77
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Parks Department 1,047,950.00 73,783.69 322,205.50 30.75 725,744.50
|