|
<br /> 8-15-2018 07:39 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JULY 31ST, 2018
<br />101-GENERAL FUND
<br />Public Works 58.33% 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 0.00 219.46 4.88 4,280.54
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 5,025.12 33,386.90 54.55 27,813.10
<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,667.30 33,328.36 60.27 21,971.64
<br />101-4-3120-4221 Equipment Parts 52,000.00 5,671.35 22,531.70 43.33 29,468.30
<br />101-4-3120-4226 Street Signs 31,000.00 168.30 6,978.00 22.51 24,022.00
<br /> TOTAL Supplies 210,600.00 19,532.07 97,865.58 46.47 112,734.42
<br />Other Services & Charges
<br />101-4-3120-4319 Other Professional Services 300.00 123.00 123.00 41.00 177.00
<br />101-4-3120-4321 Telephone 7,550.00 432.71 3,312.45 43.87 4,237.55
<br />101-4-3120-4322 Postage 100.00 8.94 39.82 39.82 60.18
<br />101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 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 6,144.48 37,560.66 40.47 55,239.34
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 823.20 12,967.81 56.38 10,032.19
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 13,084.81 145.39 ( 4,084.81)
<br />101-4-3120-4409 Contractual Services 65,500.00 12,520.08 14,047.15 21.45 51,452.85
<br />101-4-3120-4415 Equipment Rental 2,000.00 0.00 729.00 36.45 1,271.00
<br />101-4-3120-4433 Dues & Subscriptions 350.00 0.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 64,925.00 58.33 46,375.00
<br /> TOTAL Other Services & Charges 332,700.00 29,327.41 158,733.29 47.71 173,966.71
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,355,450.00 117,593.55 592,069.46 43.68 763,380.54
<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 2,485.50 7,456.50 82.39 1,593.50
<br /> TOTAL Personal Services 205,700.00 2,485.50 172,583.13 83.90 33,116.87
|