|
<br /> 3-14-2018 02:36 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: FEBRUARY 28TH, 2018
<br />101-GENERAL FUND
<br />Public Works 16.67% 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 0.00 0.00 4,500.00
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 10,352.76 16,747.69 27.37 44,452.31
<br />101-4-3120-4217 Uniform Allowance 6,600.00 0.00 ( 52.90) 0.80- 6,652.90
<br />101-4-3120-4219 Operating Supplies 55,300.00 4,597.98 4,669.80 8.44 50,630.20
<br />101-4-3120-4221 Equipment Parts 52,000.00 3,405.04 3,497.97 6.73 48,502.03
<br />101-4-3120-4226 Street Signs 31,000.00 1,430.29 1,430.29 4.61 29,569.71
<br /> TOTAL Supplies 210,600.00 19,786.07 26,292.85 12.48 184,307.15
<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 706.03 706.03 9.35 6,843.97
<br />101-4-3120-4322 Postage 100.00 0.00 0.00 0.00 100.00
<br />101-4-3120-4331 Travel, Conferences & Schools 5,100.00 120.00 120.00 2.35 4,980.00
<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.26 5,851.26 6.31 86,948.74
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 907.65 930.60 4.05 22,069.40
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 419.48 419.48 4.66 8,580.52
<br />101-4-3120-4409 Contractual Services 65,500.00 40.78 40.78 0.06 65,459.22
<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 512.00 512.00 102.40 ( 12.00)
<br />101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 18,550.00 16.67 92,750.00
<br /> TOTAL Other Services & Charges 332,700.00 17,782.20 31,148.15 9.36 301,551.85
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,333,250.00 66,942.44 112,889.50 8.47 1,220,360.50
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 134,700.00 17,842.54 35,799.09 26.58 98,900.91
<br />101-4-3130-4102 Overtime Pay 20,000.00 7,422.98 12,866.27 64.33 7,133.73
<br />101-4-3130-4104 PERA 11,200.00 1,967.69 3,671.08 32.78 7,528.92
<br />101-4-3130-4105 FICA 9,600.00 1,645.94 2,982.06 31.06 6,617.94
<br />101-4-3130-4107 Medicare 2,250.00 384.93 697.39 31.00 1,552.61
<br />101-4-3130-4108 Insurance 18,900.00 2,594.76 5,189.52 27.46 13,710.48
<br />101-4-3130-4109 Workers Comp 9,050.00 0.00 2,485.50 27.46 6,564.50
<br /> TOTAL Personal Services 205,700.00 31,858.84 63,690.91 30.96 142,009.09
|