|
<br /> 8-16-2017 07:42 AM CITY OF ELK RIVER PAGE: 22
<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 />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Engineering 218,500.00 17,260.85 126,049.29 57.69 92,450.71
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Public Works 2,025,300.00 124,507.60 1,078,788.62 53.27 946,511.38
<br />Parks Department
<br />================
<br />Personal Services
<br />101-4-5110-4101 Regular Pay 405,150.00 28,698.27 223,436.81 55.15 181,713.19
<br />101-4-5110-4102 Overtime Pay 6,600.00 337.97 2,767.91 41.94 3,832.09
<br />101-4-5110-4103 Part-time Pay 68,250.00 11,835.00 33,738.00 49.43 34,512.00
<br />101-4-5110-4104 PERA 30,900.00 2,177.04 16,914.08 54.74 13,985.92
<br />101-4-5110-4105 FICA 29,250.00 2,363.59 15,173.95 51.88 14,076.05
<br />101-4-5110-4107 Medicare 6,900.00 552.77 3,542.58 51.34 3,357.42
<br />101-4-5110-4108 Insurance 79,300.00 6,094.00 44,284.50 55.84 35,015.50
<br />101-4-5110-4109 Workers Comp 12,250.00 0.00 11,485.50 93.76 764.50
<br />101-4-5110-4110 Re-employment Compensation 0.00 0.00 2,225.00 0.00 ( 2,225.00)
<br /> TOTAL Personal Services 638,600.00 52,058.64 353,568.33 55.37 285,031.67
<br />Supplies
<br />101-4-5110-4212 Fuels & Lubes 25,000.00 2,947.23 10,936.51 43.75 14,063.49
<br />101-4-5110-4217 Uniform Allowance 3,800.00 0.00 1,471.00 38.71 2,329.00
<br />101-4-5110-4219 Operating Supplies 97,000.00 5,166.24 44,058.25 45.42 52,941.75
<br />101-4-5110-4221 Equipment Parts 27,000.00 1,316.91 10,175.77 37.69 16,824.23
<br /> TOTAL Supplies 152,800.00 9,430.38 66,641.53 43.61 86,158.47
<br />Other Services & Charges
<br />101-4-5110-4321 Telephone 5,050.00 393.77 1,926.68 38.15 3,123.32
<br />101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00
<br />101-4-5110-4331 Travel, Conferences & Schools 4,800.00 0.00 1,394.46 29.05 3,405.54
<br />101-4-5110-4361 Insurance 33,500.00 0.00 16,425.50 49.03 17,074.50
<br />101-4-5110-4389 Utilities 76,000.00 9,741.30 25,464.96 33.51 50,535.04
<br />101-4-5110-4401 Bldg Repair/Maint Services 2,000.00 0.00 3,450.06 172.50 ( 1,450.06)
<br />101-4-5110-4404 Equip Repair/Maint Services 16,500.00 646.53 2,676.26 16.22 13,823.74
<br />101-4-5110-4409 Contractual Services 45,100.00 6,358.56 12,867.69 28.53 32,232.31
<br />101-4-5110-4415 Equipment Rental 22,200.00 0.00 10,133.46 45.65 12,066.54
<br />101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 29,925.00 58.33 21,375.00
<br /> TOTAL Other Services & Charges 256,550.00 21,415.16 104,264.07 40.64 152,285.93
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Parks Department 1,047,950.00 82,904.18 524,473.93 50.05 523,476.07
|