|
<br /> 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MAY 31ST, 2018
<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 />Supplies
<br />101-4-3120-4201 Office Supplies 4,500.00 3.47 202.54 4.50 4,297.46
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 ( 4,896.39) 29,646.78 48.44 31,553.22
<br />101-4-3120-4217 Uniform Allowance 6,600.00 834.02 1,421.16 21.53 5,178.84
<br />101-4-3120-4219 Operating Supplies 55,300.00 2,431.47 16,043.57 29.01 39,256.43
<br />101-4-3120-4221 Equipment Parts 52,000.00 4,894.56 12,418.79 23.88 39,581.21
<br />101-4-3120-4226 Street Signs 31,000.00 ( 66.70) 5,895.70 19.02 25,104.30
<br /> TOTAL Supplies 210,600.00 3,200.43 65,628.54 31.16 144,971.46
<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 417.76 2,226.16 29.49 5,323.84
<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 1,144.14 3,156.49 61.89 1,943.51
<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 4,548.94 25,578.91 27.56 67,221.09
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 6,784.52 12,121.66 52.70 10,878.34
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 1,575.00 10,999.78 122.22 ( 1,999.78)
<br />101-4-3120-4409 Contractual Services 65,500.00 0.00 1,377.07 2.10 64,122.93
<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 12.00 524.00 104.80 ( 24.00)
<br />101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 46,375.00 41.67 64,925.00
<br /> TOTAL Other Services & Charges 332,700.00 23,757.36 110,030.95 33.07 222,669.05
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,355,450.00 73,112.35 355,066.91 26.20 1,000,383.09
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 134,700.00 10,139.27 89,395.55 66.37 45,304.45
<br />101-4-3130-4102 Overtime Pay 20,000.00 6,408.95 42,477.35 212.39 ( 22,477.35)
<br />101-4-3130-4104 PERA 11,200.00 1,266.73 9,829.46 87.76 1,370.54
<br />101-4-3130-4105 FICA 9,600.00 1,029.98 8,080.27 84.17 1,519.73
<br />101-4-3130-4107 Medicare 2,250.00 236.09 1,884.94 83.78 365.06
<br />101-4-3130-4108 Insurance 18,900.00 1,656.63 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 20,737.65 170,097.63 82.69 35,602.37
|