|
<br />11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: OCTOBER 31ST, 2017
<br />101-GENERAL FUND
<br />Public Works 83.33% 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 0.00 3,516.75 117.23 ( 516.75)
<br />101-4-3120-4417 Uniform Rental 5,800.00 496.86 2,549.69 43.96 3,250.31
<br />101-4-3120-4433 Dues & Subscriptions 350.00 0.00 530.00 151.43 ( 180.00)
<br />101-4-3120-4437 Taxes & Licenses 150.00 0.00 95.00 63.33 55.00
<br />101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 88,333.30 83.33 17,666.70
<br /> TOTAL Other Services & Charges 332,350.00 61,306.70 272,732.06 82.06 59,617.94
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 119,589.58 1,063,110.39 81.48 241,689.61
<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 6,264.00 71.18 2,536.00
<br /> TOTAL Personal Services 213,650.00 0.00 54,973.34 25.73 158,676.66
<br />Supplies
<br />101-4-3130-4219 Operating Supplies 92,300.00 75.93 69,301.98 75.08 22,998.02
<br /> TOTAL Supplies 92,300.00 75.93 69,301.98 75.08 22,998.02
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 75.93 124,275.32 40.62 181,674.68
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 9,124.80 92,256.65 78.75 24,893.35
<br />101-4-3150-4102 Overtime Pay 3,000.00 234.22 1,411.92 47.06 1,588.08
<br />101-4-3150-4104 PERA 9,000.00 701.93 7,025.15 78.06 1,974.85
<br />101-4-3150-4105 FICA 7,450.00 564.10 5,652.14 75.87 1,797.86
<br />101-4-3150-4107 Medicare 1,750.00 131.92 1,321.87 75.54 428.13
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 13,370.00 84.09 2,530.00
<br />101-4-3150-4109 Workers Comp 3,400.00 0.00 2,031.00 59.74 1,369.00
<br /> TOTAL Personal Services 157,650.00 12,093.97 123,068.73 78.06 34,581.27
|