|
<br /> 8-16-2017 07:42 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JULY 31ST, 2017
<br />101-GENERAL FUND
<br />Public Works 58.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 63.98 1,211.53 20.89 4,588.47
<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 61,833.31 58.33 44,166.69
<br /> TOTAL Other Services & Charges 332,350.00 28,883.90 161,771.29 48.67 170,578.71
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 97,126.19 729,085.20 55.88 575,714.80
<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 ( 1,942.98) 69,076.81 74.84 23,223.19
<br /> TOTAL Supplies 92,300.00 ( 1,942.98) 69,076.81 74.84 23,223.19
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 ( 1,942.98) 124,050.15 40.55 181,899.85
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 9,067.60 64,788.56 55.30 52,361.44
<br />101-4-3150-4102 Overtime Pay 3,000.00 0.00 931.76 31.06 2,068.24
<br />101-4-3150-4104 PERA 9,000.00 680.07 4,929.02 54.77 4,070.98
<br />101-4-3150-4105 FICA 7,450.00 546.03 3,967.84 53.26 3,482.16
<br />101-4-3150-4107 Medicare 1,750.00 127.70 927.96 53.03 822.04
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 9,359.00 58.86 6,541.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 11,758.40 86,935.14 55.14 70,714.86
|