|
<br />12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 20
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: NOVEMBER 30TH, 2017
<br />101-GENERAL FUND
<br />Public Works 91.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 0.00 3,516.75 117.23 ( 516.75)
<br />101-4-3120-4417 Uniform Rental 5,800.00 638.88 3,188.57 54.98 2,611.43
<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 97,166.63 91.67 8,833.37
<br /> TOTAL Other Services & Charges 332,350.00 27,751.70 300,483.76 90.41 31,866.24
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Street Maintenance 1,304,800.00 128,704.65 1,191,616.53 91.33 113,183.47
<br />Snow Removal
<br />============
<br />Personal Services
<br />101-4-3130-4101 Regular Pay 140,000.00 301.04 29,272.66 20.91 110,727.34
<br />101-4-3130-4102 Overtime Pay 20,000.00 1,201.24 10,507.03 52.54 9,492.97
<br />101-4-3130-4104 PERA 11,550.00 113.43 2,647.14 22.92 8,902.86
<br />101-4-3130-4105 FICA 9,950.00 88.83 2,213.09 22.24 7,736.91
<br />101-4-3130-4107 Medicare 2,300.00 20.78 523.74 22.77 1,776.26
<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,485.50 8,749.50 99.43 50.50
<br /> TOTAL Personal Services 213,650.00 4,210.82 59,184.16 27.70 154,465.84
<br />Supplies
<br />101-4-3130-4219 Operating Supplies 92,300.00 72.75 69,374.73 75.16 22,925.27
<br /> TOTAL Supplies 92,300.00 72.75 69,374.73 75.16 22,925.27
<br />Other Services & Charges _____________ _____________ _____________ _______ _____________
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Snow Removal 305,950.00 4,283.57 128,558.89 42.02 177,391.11
<br />Equipment Services
<br />==================
<br />Personal Services
<br />101-4-3150-4101 Regular Pay 117,150.00 9,124.80 101,381.45 86.54 15,768.55
<br />101-4-3150-4102 Overtime Pay 3,000.00 0.00 1,411.92 47.06 1,588.08
<br />101-4-3150-4104 PERA 9,000.00 684.36 7,709.51 85.66 1,290.49
<br />101-4-3150-4105 FICA 7,450.00 549.57 6,201.71 83.24 1,248.29
<br />101-4-3150-4107 Medicare 1,750.00 128.53 1,450.40 82.88 299.60
<br />101-4-3150-4108 Insurance 15,900.00 1,337.00 14,707.00 92.50 1,193.00
<br />101-4-3150-4109 Workers Comp 3,400.00 808.50 2,839.50 83.51 560.50
<br /> TOTAL Personal Services 157,650.00 12,632.76 135,701.49 86.08 21,948.51
|