|
Fiscal Year 2020 12/31/2018 14
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT A
<br />2015 2016 2017 2018 2019 2019 2020 in Budget
<br />WATER OPERATIONS
<br />PRODUCTION OPERATING EXPENDITURES
<br />701-4110-85-0000 REGULAR EMPLOYEE 56,678 58,161 60,139 62,285 61,799 66,075 6.08% AD/PW wages
<br />701-4111-85-0000 OVERTIME EMPLOYEE 712 1,024 367 850 1,250 1,050 23.53% based on run rates
<br />701-4121-85-0000 PERA 4,768 4,900 5,078 4,735 4,729 5,034 6.32% 7.50%
<br />701-4122-85-0000 FICA/MEDICARE 4,875 4,973 5,156 4,830 4,823 5,135 6.32% 7.65%
<br />701-4131-85-0000 INSURANCE HEALTH 9,235 10,126 11,036 11,848 10,337 11,000 -7.16% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />701-4135-85-0000 WTR FILT INSURANCE WC 4,328 3,776 3,587 3,749 3,749 3,533 -5.76% BASED ON 2019/2020 RENEWAL
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 3,146 396 772 1,275 1,275 1,301 2.00% based on run rates
<br />701-4226-85-0000 GENERAL SUPPLIES 52,187 55,746 55,429 57,092 45,600 56,500 -1.04% VARIOUS TREATMENT CHEMICALS
<br />701-4226-85-0001 CARBON SUPPLY USAGE - 2,654 35,240 27,000 33,500 32,500 20.37% AMORTIZATION COST FOR CARBON BASED ON # OF GALLONS TREATED
<br />701-4226-85-0200 UV BULB SUPPLY USAGE - - 112,418 13,300 112,400 112,400 745.11% AMORTIZATION COST FOR BULBS ASSUMING 3YEAR LIFE
<br />701-4226-85-0003 PEROXIDE SUPPILES - 27,930 36,400 28,500 33,000 -9.34% PEROIXIDE
<br />701-4303-85-0000 ENGINEER EXPENSES 13,628 1,952 4,587 6,000 3,200 3,500 -41.67% Based on current run rates / AOP completion impact
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS - 12,387 12,644 12,350 13,750 14,325 15.99% WATER TESTING / LAB COSTS
<br />701-4309-85-0000 CONTRACTED IT & SFTW SUPPORT 330 - 3,659 3,174 3,174 3,238 2.00% MDM FEE and security monitoring
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 386 330 345 375 690 570 52.00% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4325-85-0000 COMMUNICATIONS 149 2,143 2,694 2,500 2,500 2,550 2.00% added patec previously in sewer budget
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 11,748 14,140 28,468 16,500 13,854 14,500 -12.12% 2018 scada controls repairs
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 9,554 5,724 2,656 2,750 2,750 2,805 2.00% Based on current run rates / AOP completion impact
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY - 14,067 16,552 20,023 20,023 19,160 -4.31% BASED ON 2019/2020 RENEWAL
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 15,527 112,035 129,272 140,600 132,500 135,813 -3.41% Based on new run rates with AOP process
<br />TOTAL - 187,251 304,534 518,027 427,636 500,403 523,988 22.53%
<br /> OPERATING INCOME (LOSS)279,163$ 130,430$ 104,281$ (92,175)$ 44,736$ (63,197)$ (28,283)$
<br />OTHER (INCOME) / EXPENSE
<br />701-3891-0-0-00 WT MISCELLANEOUS INCOME (390) (2,495) (12,559) (4,350) (550) (550) (550)
<br />701-3620-0-1-00 WT INTEREST INCOME (499) (23,907) (16,714) (24,620) (16,500) (25,000) (23,000)
<br />701-3713-0-0-00 WT WATER CONNECTION FEES (3,180) (7,650) (23,850) (25,700) (34,000) (34,000) (34,000)
<br />701-3910-0-0-00 WT SALE OF ASSETS - (1,170) - - - - -
<br />701-4335-80-0000 WT BKUP RESTORATION COSTS - - - - 10,000 - -
<br />701-4499-80-0000 WT MISCELLANEOUS EXPENSE 1,632 172 1,572 1,362 650 650 650
<br />TOTAL (2,437)$ (35,050)$ (51,551)$ (53,309)$ (40,400)$ (58,900)$ (56,900)$
<br />OPERATING INCOME BEFORE DEPRECIATION 281,600$ 165,480$ 155,832$ (38,866)$ 85,136$ (4,297)$ 28,617$
<br /> PRIOR TO
<br />2016
<br />PRODUCTION
<br />COSTS
<br />ACCOUNTED
<br />FOR IN
<br />SEPARATE
<br />FUND
|