|
Fiscal Year 2019 9 EXHIBIT B
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST ACTUAL BUDGET
<br />2014 2015 2016 2017 2018 2018 2019
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 914,442$ 947,618$ 1,005,329$ 1,098,938$ 1,174,957$ 1,131,590$ 1,213,153$ 6.9% blended rate increase
<br />TOTAL 914,442$ 947,618$ 1,005,329$ 1,098,938$ 1,174,957$ 1,131,590$ 1,213,153$
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 187,990$ 200,036$ 203,152$ 218,382$ 221,309$ 211,454$ 223,934$ AD/PW wages
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 4,800 20,390 15,398 18,028 19,026 21,521 22,274
<br />701-4121-75-0000 SS PERA 14,223 15,100 15,730 16,431 18,025 17,473 18,466 7.50%
<br />701-4122-75-0000 SS FICA/MEDICARE 14,517 15,205 15,791 16,437 18,386 17,823 18,835 7.65%
<br />701-4131-75-0000 SS INSURANCE HEALTH 35,406 40,215 42,862 41,725 41,841 42,160 45,205 SPLIT 10% PREMUIM INCREASE IN 2019
<br />701-4135-75-0000 SS INSURANCE WC 2,818 4,522 5,314 4,685 3,000 4,575 4,687 BASED ON 2018/2019 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES 30 - - - 150 150 150
<br />701-4212-75-0000 SS MOTOR FUELS 12,049 8,710 6,221 6,825 8,583 8,583 10,396 based on average mileage and 3.5% increase in cost per gallon
<br />701-4226-75-0000 SS GENERAL SUPPLIES 4,805 4,704 3,128 (120) 1,250 1,250 1,250 2017 average run rate less postage costs moved
<br />701-4300-75-0000 SS AUDITOR 6,200 4,933 5,880 6,785 7,250 7,250 7,420 BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 9,997 7,668 8,148 12,205 14,065 14,065 15,405 BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 4,659 2,428 331 273 4,700 4,650 4,700 BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />701-4325-75-0000 SS COMMUNICATIONS 4,599 5,112 3,964 3,136 3,320 3,150 3,408 BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 8,785 - - - 10,000 10,000 10,000 Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 11,894 15,700 2,487 17,438 13,500 18,670 13,500 2018 significant repair to Vactor
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG.625 885 934 205 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 - - - 238 - - - Inflate 2%
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 1,914 1,688 1,681 4,303 4,335 4,000 4,335 Timing of postage fills vary
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 28,385 16,118 13,100 9,352 9,777 9,777 11,134 BASED ON 2018/2019 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE620,470 593,381 576,237 643,390 708,567 708,567 733,670 MCES amount for 2019, 3.54% increase
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,051 6,581 10,301 9,654 10,226 8,361 9,866 Xcel increase 2.2% plus Center Point increase
<br />TOTAL 982,557$ 963,621$ 930,659$ 1,029,372$ 1,118,985$ 1,115,154$ 1,160,310$
<br /> OPERATING INCOME (LOSS)(68,115)$ (16,003)$ 74,670$ 69,566$ 55,971$ 16,436$ 52,843$
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (6,800)$ (5,950)$ (7,650)$ (23,800)$ -$ (22,100)$ (34,000)$
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (653) (16,001) (6,305) (12,559) (650) (650) (650)
<br />701-3910-0-0-00 SS SALE OF ASSETS 0 0 (180) 0
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 1,625 813 90 170 100 100 100
<br />TOTAL (5,828)$ (21,139)$ (14,045)$ (36,189)$ (550)$ (22,650)$ (34,550)$
<br />NET INCOME (LOSS) BEFORE DEPRECIATION (62,287)$ 5,135$ 88,715$ 105,754$ 56,521$ 39,086$ 87,393$
<br />SEWER OPERATIONS
|