|
<br /> 4-11-2018 03:36 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MARCH 31ST, 2018
<br />101-GENERAL FUND
<br />Public Works 25.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 46.07 46.07 1.02 4,453.93
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 16,612.31 23,819.55 38.92 37,380.45
<br />101-4-3120-4217 Uniform Allowance 6,600.00 640.04 587.14 8.90 6,012.86
<br />101-4-3120-4219 Operating Supplies 55,300.00 2,673.37 7,343.17 13.28 47,956.83
<br />101-4-3120-4221 Equipment Parts 52,000.00 2,316.94 5,814.91 11.18 46,185.09
<br />101-4-3120-4226 Street Signs 31,000.00 ( 76.83) 1,353.46 4.37 29,646.54
<br /> TOTAL Supplies 210,600.00 22,211.90 38,964.30 18.50 171,635.70
<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 452.50 1,158.53 15.34 6,391.47
<br />101-4-3120-4322 Postage 100.00 26.68 26.68 26.68 73.32
<br />101-4-3120-4331 Travel, Conferences & Schools 5,100.00 379.11 499.11 9.79 4,600.89
<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 3,623.00 24.15 11,377.00
<br />101-4-3120-4389 Utilities 92,800.00 5,801.63 11,652.89 12.56 81,147.11
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 929.95 1,860.55 8.09 21,139.45
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 5,832.58 6,252.06 69.47 2,747.94
<br />101-4-3120-4409 Contractual Services 65,500.00 39.70 80.48 0.12 65,419.52
<br />101-4-3120-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00
<br />101-4-3120-4433 Dues & Subscriptions 350.00 0.00 395.00 112.86 ( 45.00)
<br />101-4-3120-4437 Taxes & Licenses 500.00 0.00 512.00 102.40 ( 12.00)
<br />101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 27,825.00 25.00 83,475.00
<br /> TOTAL Other Services & Charges 332,700.00 22,737.15 53,885.30 16.20 278,814.70
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,333,250.00 88,651.89 192,000.94 14.40 1,141,249.06
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 134,700.00 21,352.81 57,151.90 42.43 77,548.10
<br />101-4-3130-4102 Overtime Pay 20,000.00 14,122.81 26,989.08 134.95 ( 6,989.08)
<br />101-4-3130-4104 PERA 11,200.00 2,572.15 6,243.23 55.74 4,956.77
<br />101-4-3130-4105 FICA 9,600.00 2,164.31 5,146.37 53.61 4,453.63
<br />101-4-3130-4107 Medicare 2,250.00 506.17 1,203.56 53.49 1,046.44
<br />101-4-3130-4108 Insurance 18,900.00 3,299.65 8,489.17 44.92 10,410.83
<br />101-4-3130-4109 Workers Comp 9,050.00 2,485.50 4,971.00 54.93 4,079.00
<br /> TOTAL Personal Services 205,700.00 46,503.40 110,194.31 53.57 95,505.69
|