|
<br /> 7-12-2017 07:25 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JUNE 30TH, 2017
<br />101-GENERAL FUND
<br />Public Works 50.00% 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 250.00 3,516.75 117.23 ( 516.75)
<br />101-4-3120-4417 Uniform Rental 5,800.00 350.39 1,147.55 19.79 4,652.45
<br />101-4-3120-4433 Dues & Subscriptions 350.00 0.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 52,999.98 50.00 53,000.02
<br /> TOTAL Other Services & Charges 332,350.00 24,777.51 132,887.39 39.98 199,462.61
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 146,015.62 631,959.01 48.43 672,840.99
<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 2,088.00 6,264.00 71.18 2,536.00
<br /> TOTAL Personal Services 213,650.00 2,088.00 54,973.34 25.73 158,676.66
<br />Supplies
<br />101-4-3130-4219 Operating Supplies 92,300.00 71.98 71,019.79 76.94 21,280.21
<br /> TOTAL Supplies 92,300.00 71.98 71,019.79 76.94 21,280.21
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 2,159.98 125,993.13 41.18 179,956.87
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 13,484.54 55,720.96 47.56 61,429.04
<br />101-4-3150-4102 Overtime Pay 3,000.00 292.78 931.76 31.06 2,068.24
<br />101-4-3150-4104 PERA 9,000.00 1,033.30 4,248.95 47.21 4,751.05
<br />101-4-3150-4105 FICA 7,450.00 839.20 3,421.81 45.93 4,028.19
<br />101-4-3150-4107 Medicare 1,750.00 196.27 800.26 45.73 949.74
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 8,022.00 50.45 7,878.00
<br />101-4-3150-4109 Workers Comp 3,400.00 677.00 2,031.00 59.74 1,369.00
<br /> TOTAL Personal Services 157,650.00 17,860.09 75,176.74 47.69 82,473.26
|