|
<br />10-11-2017 03:49 PM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: SEPTEMBER 30TH, 2017
<br />101-GENERAL FUND
<br />Public Works 75.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 0.00 3,516.75 117.23 ( 516.75)
<br />101-4-3120-4417 Uniform Rental 5,800.00 400.56 2,052.83 35.39 3,747.17
<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 25.00 95.00 63.33 55.00
<br />101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 79,499.97 75.00 26,500.03
<br /> TOTAL Other Services & Charges 332,350.00 24,697.55 211,425.36 63.62 120,924.64
<br />Capital Outla y _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 99,778.68 943,580.69 72.32 361,219.31
<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 74.84 69,226.05 75.00 23,073.95
<br /> TOTAL Supplies 92,300.00 74.84 69,226.05 75.00 23,073.95
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outla y _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 74.84 124,199.39 40.59 181,750.61
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 9,218.49 83,131.85 70.96 34,018.15
<br />101-4-3150-4102 Overtime Pay 3,000.00 245.94 1,177.70 39.26 1,822.30
<br />101-4-3150-4104 PERA 9,000.00 709.84 6,323.22 70.26 2,676.78
<br />101-4-3150-4105 FICA 7,450.00 570.63 5,088.04 68.30 2,361.96
<br />101-4-3150-4107 Medicare 1,750.00 133.46 1,189.95 68.00 560.05
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 12,033.00 75.68 3,867.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,215.36 110,974.76 70.39 46,675.24
|