|
<br />12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 22
<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 />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Engineering 218,500.00 16,461.44 194,822.66 89.16 23,677.34
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Public Works 2,025,300.00 160,091.11 1,673,548.15 82.63 351,751.85
<br />Parks Department
<br />================
<br />Personal Services
<br />101-4-5110-4101 Regular Pay 405,150.00 32,367.03 352,979.48 87.12 52,170.52
<br />101-4-5110-4102 Overtime Pay 6,600.00 464.64 4,208.13 63.76 2,391.87
<br />101-4-5110-4103 Part-time Pay 68,250.00 1,824.00 51,858.96 75.98 16,391.04
<br />101-4-5110-4104 PERA 30,900.00 2,462.06 26,683.53 86.35 4,216.47
<br />101-4-5110-4105 FICA 29,250.00 2,006.81 23,846.04 81.52 5,403.96
<br />101-4-5110-4107 Medicare 6,900.00 469.33 5,570.72 80.74 1,329.28
<br />101-4-5110-4108 Insurance 79,300.00 5,799.50 67,482.50 85.10 11,817.50
<br />101-4-5110-4109 Workers Comp 12,250.00 4,572.25 16,057.75 131.08 ( 3,807.75)
<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 49,965.62 550,912.11 86.27 87,687.89
<br />Supplies
<br />101-4-5110-4212 Fuels & Lubes 25,000.00 1,192.97 17,851.45 71.41 7,148.55
<br />101-4-5110-4217 Uniform Allowance 3,800.00 120.00 2,808.05 73.90 991.95
<br />101-4-5110-4219 Operating Supplies 97,000.00 9,828.94 85,751.41 88.40 11,248.59
<br />101-4-5110-4221 Equipment Parts 27,000.00 92.28 17,547.49 64.99 9,452.51
<br /> TOTAL Supplies 152,800.00 11,234.19 123,958.40 81.12 28,841.60
<br />Other Services & Charges
<br />101-4-5110-4321 Telephone 5,050.00 422.87 3,491.07 69.13 1,558.93
<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 476.12 2,951.70 61.49 1,848.30
<br />101-4-5110-4361 Insurance 33,500.00 0.00 32,492.50 96.99 1,007.50
<br />101-4-5110-4389 Utilities 76,000.00 7,610.07 73,869.01 97.20 2,130.99
<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 2,372.85 9,330.57 56.55 7,169.43
<br />101-4-5110-4409 Contractual Services 45,100.00 3,163.52 29,558.07 65.54 15,541.93
<br />101-4-5110-4415 Equipment Rental 22,200.00 1,425.00 24,055.09 108.36 ( 1,855.09)
<br />101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 47,025.00 91.67 4,275.00
<br /> TOTAL Other Services & Charges 256,550.00 19,745.43 226,223.07 88.18 30,326.93
<br />Capital Outlay _____________ _____________ _____________ _______ _____________
<br />___________________________________________________________________________________________________________________
<br /> TOTAL Parks Department 1,047,950.00 80,945.24 901,093.58 85.99 146,856.42
|