|
<br /> 6-14-2017 06:02 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MAY 31ST, 2017
<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 />101-4-3120-4415 Equipment Rental 3,000.00 724.00 3,266.75 108.89 ( 266.75)
<br />101-4-3120-4417 Uniform Rental 5,800.00 158.65 797.16 13.74 5,002.84
<br />101-4-3120-4433 Dues & Subscriptions 350.00 50.00 387.50 110.71 ( 37.50)
<br />101-4-3120-4437 Taxes & Licenses 150.00 0.00 70.00 46.67 80.00
<br />101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 44,166.65 41.67 61,833.35
<br /> TOTAL Other Services & Charges 332,350.00 28,232.71 108,109.88 32.53 224,240.12
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 97,703.64 486,068.52 37.25 818,731.48
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 140,000.00 0.00 28,971.62 20.69 111,028.38
<br />101-4-3130-4102 Overtime Pay 20,000.00 0.00 9,305.79 46.53 10,694.21
<br />101-4-3130-4104 PERA 11,550.00 0.00 2,533.71 21.94 9,016.29
<br />101-4-3130-4105 FICA 9,950.00 0.00 2,124.26 21.35 7,825.74
<br />101-4-3130-4107 Medicare 2,300.00 0.00 502.96 21.87 1,797.04
<br />101-4-3130-4108 Insurance 21,050.00 0.00 5,271.00 25.04 15,779.00
<br />101-4-3130-4109 Workers Comp 8,800.00 0.00 4,176.00 47.45 4,624.00
<br /> TOTAL Personal Services 213,650.00 0.00 52,885.34 24.75 160,764.66
<br />Supplies
<br />101-4-3130-4219 Operating Supplies 92,300.00 20,682.44 70,947.81 76.87 21,352.19
<br /> TOTAL Supplies 92,300.00 20,682.44 70,947.81 76.87 21,352.19
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 20,682.44 123,833.15 40.47 182,116.85
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 8,896.00 42,236.42 36.05 74,913.58
<br />101-4-3150-4102 Overtime Pay 3,000.00 638.98 638.98 21.30 2,361.02
<br />101-4-3150-4104 PERA 9,000.00 715.12 3,215.65 35.73 5,784.35
<br />101-4-3150-4105 FICA 7,450.00 575.02 2,582.61 34.67 4,867.39
<br />101-4-3150-4107 Medicare 1,750.00 134.47 603.99 34.51 1,146.01
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 6,685.00 42.04 9,215.00
<br />101-4-3150-4109 Workers Comp 3,400.00 0.00 1,354.00 39.82 2,046.00
<br /> TOTAL Personal Services 157,650.00 12,296.59 57,316.65 36.36 100,333.35
|