|
<br /> 7-11-2018 07:37 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JUNE 30TH, 2018
<br />101-GENERAL FUND
<br />Public Works 50.00% OF YEAR COMP.
<br />
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br />DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />___________________________________________________________________________________________________________________
<br />Supplies
<br />101-4-3120-4201 Office Supplies 4,500.00 16.92 219.46 4.88 4,280.54
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 ( 982.57) 28,361.78 46.34 32,838.22
<br />101-4-3120-4217 Uniform Allowance 6,600.00 0.00 1,421.16 21.53 5,178.84
<br />101-4-3120-4219 Operating Supplies 55,300.00 8,617.49 24,661.06 44.60 30,638.94
<br />101-4-3120-4221 Equipment Parts 52,000.00 4,441.56 16,860.35 32.42 35,139.65
<br />101-4-3120-4226 Street Signs 31,000.00 914.00 6,809.70 21.97 24,190.30
<br /> TOTAL Supplies 210,600.00 13,007.40 78,333.51 37.20 132,266.49
<br />Other Services & Charges
<br />101-4-3120-4319 Other Professional Services 300.00 0.00 0.00 0.00 300.00
<br />101-4-3120-4321 Telephone 7,550.00 653.58 2,879.74 38.14 4,670.26
<br />101-4-3120-4322 Postage 100.00 0.00 30.88 30.88 69.12
<br />101-4-3120-4331 Travel, Conferences & Schools 5,100.00 377.10 3,533.59 69.29 1,566.41
<br />101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00
<br />101-4-3120-4361 Insurance 15,000.00 0.00 7,246.00 48.31 7,754.00
<br />101-4-3120-4389 Utilities 92,800.00 5,837.27 31,416.18 33.85 61,383.82
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 22.95 12,144.61 52.80 10,855.39
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 2,085.03 13,084.81 145.39 ( 4,084.81)
<br />101-4-3120-4409 Contractual Services 65,500.00 150.00 1,527.07 2.33 63,972.93
<br />101-4-3120-4415 Equipment Rental 2,000.00 729.00 729.00 36.45 1,271.00
<br />101-4-3120-4433 Dues & Subscriptions 350.00 245.00 640.00 182.86 ( 290.00)
<br />101-4-3120-4437 Taxes & Licenses 500.00 0.00 524.00 104.80 ( 24.00)
<br />101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 55,650.00 50.00 55,650.00
<br /> TOTAL Other Services & Charges 332,700.00 19,374.93 129,405.88 38.90 203,294.12
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,355,450.00 119,711.43 474,475.91 35.01 880,974.09
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 134,700.00 0.00 89,395.55 66.37 45,304.45
<br />101-4-3130-4102 Overtime Pay 20,000.00 0.00 42,477.35 212.39 ( 22,477.35)
<br />101-4-3130-4104 PERA 11,200.00 0.00 9,829.46 87.76 1,370.54
<br />101-4-3130-4105 FICA 9,600.00 0.00 8,080.27 84.17 1,519.73
<br />101-4-3130-4107 Medicare 2,250.00 0.00 1,884.94 83.78 365.06
<br />101-4-3130-4108 Insurance 18,900.00 0.00 13,459.06 71.21 5,440.94
<br />101-4-3130-4109 Workers Comp 9,050.00 0.00 4,971.00 54.93 4,079.00
<br /> TOTAL Personal Services 205,700.00 0.00 170,097.63 82.69 35,602.37
|