|
<br /> 5-16-2018 11:29 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: APRIL 30TH, 2018
<br />101-GENERAL FUND
<br />Public Works 33.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 153.00 199.07 4.42 4,300.93
<br />101-4-3120-4212 Fuels & Lubes 61,200.00 10,723.62 34,543.17 56.44 26,656.83
<br />101-4-3120-4217 Uniform Allowance 6,600.00 0.00 587.14 8.90 6,012.86
<br />101-4-3120-4219 Operating Supplies 55,300.00 6,268.93 13,612.10 24.62 41,687.90
<br />101-4-3120-4221 Equipment Parts 52,000.00 1,709.32 7,524.23 14.47 44,475.77
<br />101-4-3120-4226 Street Signs 31,000.00 4,608.94 5,962.40 19.23 25,037.60
<br /> TOTAL Supplies 210,600.00 23,463.81 62,428.11 29.64 148,171.89
<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 649.87 1,808.40 23.95 5,741.60
<br />101-4-3120-4322 Postage 100.00 4.20 30.88 30.88 69.12
<br />101-4-3120-4331 Travel, Conferences & Schools 5,100.00 1,513.24 2,012.35 39.46 3,087.65
<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 3,623.00 7,246.00 48.31 7,754.00
<br />101-4-3120-4389 Utilities 92,800.00 9,377.08 21,029.97 22.66 71,770.03
<br />101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 3,476.59 5,337.14 23.20 17,662.86
<br />101-4-3120-4404 Equip Repair/Maint Services 9,000.00 3,172.72 9,424.78 104.72 ( 424.78)
<br />101-4-3120-4409 Contractual Services 65,500.00 1,296.59 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 0.00 512.00 102.40 ( 12.00)
<br />101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 37,100.00 33.33 74,200.00
<br /> TOTAL Other Services & Charges 332,700.00 32,388.29 86,273.59 25.93 246,426.41
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,355,450.00 89,953.62 281,954.56 20.80 1,073,495.44
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 134,700.00 22,104.38 79,256.28 58.84 55,443.72
<br />101-4-3130-4102 Overtime Pay 20,000.00 9,079.32 36,068.40 180.34 ( 16,068.40)
<br />101-4-3130-4104 PERA 11,200.00 2,319.50 8,562.73 76.45 2,637.27
<br />101-4-3130-4105 FICA 9,600.00 1,903.92 7,050.29 73.44 2,549.71
<br />101-4-3130-4107 Medicare 2,250.00 445.29 1,648.85 73.28 601.15
<br />101-4-3130-4108 Insurance 18,900.00 3,313.26 11,802.43 62.45 7,097.57
<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 39,165.67 149,359.98 72.61 56,340.02
|