|
Fiscal Year 2018 EXHIBIT C
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST ACTUAL BUDGET
<br />2013 2014 2015 2016 2017 2017 2018
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 849,032$ 914,442$ 947,618$ 1,005,329$ 1,092,556$ 1,098,338$ 1,175,081$ 6.9% blended rate increase
<br />TOTAL 849,032$ 914,442$ 947,618$ 1,005,329$ 1,092,556$ 1,098,338$ 1,175,081$
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 184,517$ 187,990$ 200,036$ 203,152$ 211,649$ 211,649$ 221,195$ AD/PW
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 4,307 4,800 20,390 15,398 18,653 18,653 19,026
<br />701-4121-75-0000 SS PERA 14,056 14,223 15,100 15,730 17,273 17,273 18,017 7.50%
<br />701-4122-75-0000 SS FICA/MEDICARE 14,519 14,517 15,205 15,791 17,618 17,618 18,377 7.65%
<br />701-4131-75-0000 SS INSURANCE HEALTH 31,999 35,406 40,215 42,862 43,224 39,400 41,841 AD/PW see dept summ-HI
<br />701-4135-75-0000 SS INSURANCE WC 2,191 2,818 4,522 5,314 5,292 4,685 3,000 Dept Summ-WC
<br />701-4211-75-0000 SS OFFICE SUPPLIES - 30 - - 150 150 150
<br />701-4212-75-0000 SS MOTOR FUELS 12,034 12,049 8,710 6,221 7,464 6,864 8,583 based on average mileage and 3.5% increase in cost per gallon
<br />701-4226-75-0000 SS GENERAL SUPPLIES 3,021 4,805 4,704 3,128 1,850 950 1,250 2017 average run rate less postage costs moved
<br />701-4300-75-0000 SS AUDITOR 6,141 6,200 4,933 5,880 6,120 6,153 7,250 BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 11,230 9,997 7,668 8,148 10,428 13,500 14,065 BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 7,079 4,659 2,428 331 400 400 4,700 BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />701-4325-75-0000 SS COMMUNICATIONS 6,501 4,599 5,112 3,964 4,170 3,390 3,320 BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS - 8,785 - - 10,000 - 10,000 Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 12,937 11,894 15,700 2,487 11,770 17,525 13,500 2018 based on average run rate
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG.1,923 625 885 934 1,100 1,100 1,100 2017 based on average run rate
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS - 340 245 - 575 575 575
<br />701-4342-75-0000 SS MEMBERSHIP & DUES - - - - - - - Inflate 2%
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 1,245 1,914 1,688 1,681 3,987 4,250 4,335 2016 actual plus 2%
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 27,010 28,385 16,118 13,100 9,791 9,791 9,777 from prop/casu est
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 588,795 620,470 593,381 576,237 643,390 643,390 708,567 MCES amount for 2017
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,211 8,051 6,581 10,301 9,833 9,833 10,226 4% rate increase estimate
<br />TOTAL 937,717$ 982,557$ 963,621$ 930,659$ 1,034,737$ 1,027,148$ 1,118,854$
<br /> OPERATING INCOME (LOSS)(88,684)$ (68,115)$ (16,003)$ 74,670$ 57,819$ 71,190$ 56,227$
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (98,600)$ (6,800)$ (5,950)$ (7,650)$ (850)$ -$ -$ Moved to Utilities Infrastructure
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (557)(653)(16,001)(6,305)(650)(650)(650)
<br />701-3910-0-0-00 SS SALE OF ASSETS 0 0 0 (180)
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 19 1,625 813 90 100 100 100 Inflate 2%
<br />TOTAL (99,138)$ (5,828)$ (21,139)$ (14,045)$ (1,400)$ (550)$ (550)$
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 10,454$ (62,287)$ 5,135$ 88,715$ 59,219$ 71,740$ 56,777$
<br />SEWER OPERATIONS
|