|
<br /> 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 22
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MAY 31ST, 2018
<br />101-GENERAL FUND
<br />Public Works 41.67% OF YEAR COMP.
<br />
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br />DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />___________________________________________________________________________________________________________________
<br />Personal Services
<br />101-4-3300-4101 Regular Pay 174,650.00 13,433.22 63,807.78 36.53 110,842.22
<br />101-4-3300-4104 PERA 13,100.00 1,007.50 4,785.61 36.53 8,314.39
<br />101-4-3300-4105 FICA 10,850.00 864.48 4,106.28 37.85 6,743.72
<br />101-4-3300-4107 Medicare 2,550.00 202.18 960.34 37.66 1,589.66
<br />101-4-3300-4108 Insurance 20,000.00 609.00 3,045.00 15.23 16,955.00
<br />101-4-3300-4109 Workers Comp 600.00 0.00 334.00 55.67 266.00
<br /> TOTAL Personal Services 221,750.00 16,116.38 77,039.01 34.74 144,710.99
<br />Supplies
<br />101-4-3300-4201 Office Supplies 150.00 6.95 56.63 37.75 93.37
<br />101-4-3300-4212 Fuels & Lubes 1,000.00 77.38 113.32 11.33 886.68
<br />101-4-3300-4219 Operating Supplies 1,500.00 0.00 35.43 2.36 1,464.57
<br /> TOTAL Supplies 2,650.00 84.33 205.38 7.75 2,444.62
<br />Other Services & Charges
<br />101-4-3300-4319 Other Professional Services 4,000.00 608.00 608.00 15.20 3,392.00
<br />101-4-3300-4321 Telephone 1,450.00 94.63 376.25 25.95 1,073.75
<br />101-4-3300-4322 Postage 200.00 0.00 3.79 1.90 196.21
<br />101-4-3300-4331 Travel, Conferences & Schools 1,650.00 122.50 376.02 22.79 1,273.98
<br />101-4-3300-4361 Insurance 100.00 0.00 40.00 40.00 60.00
<br />101-4-3300-4404 Equip Repair/Maint Services 1,500.00 0.00 0.00 0.00 1,500.00
<br />101-4-3300-4460 Equip Replacement Charge 900.00 75.00 375.00 41.67 525.00
<br /> TOTAL Other Services & Charges 9,800.00 900.13 1,779.06 18.15 8,020.94
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Engineering 234,200.00 17,100.84 79,023.45 33.74 155,176.55
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Public Works 2,098,750.00 128,033.41 740,500.12 35.28 1,358,249.88
<br />Parks Department
<br />================
<br />Personal Services
<br />101-4-5110-4101 Regular Pay 440,600.00 31,560.70 146,601.86 33.27 293,998.14
<br />101-4-5110-4102 Overtime Pay 6,500.00 2,365.83 5,030.17 77.39 1,469.83
<br />101-4-5110-4103 Part-time Pay 68,250.00 960.00 960.00 1.41 67,290.00
<br />101-4-5110-4104 PERA 33,550.00 2,544.47 11,346.32 33.82 22,203.68
<br />101-4-5110-4105 FICA 31,450.00 2,066.44 9,022.06 28.69 22,427.94
<br />101-4-5110-4107 Medicare 7,350.00 483.26 2,109.97 28.71 5,240.03
<br />101-4-5110-4108 Insurance 83,550.00 7,516.50 35,799.00 42.85 47,751.00
<br />101-4-5110-4109 Workers Comp 17,100.00 0.00 9,144.50 53.48 7,955.50
<br />101-4-5110-4110 Re-employment Compensation 0.00 1,794.00 1,794.00 0.00 ( 1,794.00)
<br /> TOTAL Personal Services 688,350.00 49,291.20 221,807.88 32.22 466,542.12
|