|
Fiscal Year 2019 14 EXHIBIT A
<br />ACTUAL ACTUAL ACTUAL BUDGET ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />2014 2015 2016 2017 2017 2018 2018 2019 in Budget
<br />WATER OPERATIONS
<br />PRODUCTION OPERATING EXPENDITURES
<br />701-4110-85-0000 REGULAR EMPLOYEE 56,678 58,446 58,161 60,633 59,861 62,436 2.97%AD/PW wages
<br />701-4111-85-0000 OVERTIME EMPLOYEE 712 850 1,024 850 550 850 0.00%
<br />701-4121-85-0000 PERA 4,768 4,383 4,900 4,611 4,531 4,746 2.93%
<br />701-4122-85-0000 FICA/MEDICARE 4,875 4,471 4,973 4,703 4,621 4,841 2.93%
<br />701-4131-85-0000 INSURANCE HEALTH 9,235 9,578 10,126 11,037 11,037 11,848 7.35%SPLIT 10% PREMUIM INCREASE IN 2019
<br />701-4135-85-0000 WTR FILT INSURANCE WC 4,328 4,721 3,776 3,964 3,587 3,749 -5.42%
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 3,146 3,500 396 1,650 1,250 1,275 -22.73%based on run rates
<br />701-4226-85-0000 GENERAL SUPPLIES 52,187 45,000 55,746 55,632 59,228 61,005 9.66%
<br />701-4226-85-0001 CARBON SUPPLY USAGE - 27,000 2,654 27,000 27,000 27,000 0.00%
<br />701-4226-85-0002 UV BULB SUPPLY USAGE - 13,300 - 13,300 13,300 13,300 0.00%
<br />701-4226-85-0003 PEROXIDE SUPPILES - - 9,058 27,930 36,400 301.85%Peroixide use/cost higher than budgeted
<br />701-4303-85-0000 ENGINEER EXPENSES 13,628 11,500 1,952 11,500 5,500 6,000 -47.83%Based on current run rates / AOP completion impact
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS - 1,250 12,387 10,000 12,150 12,350 23.50%pace testing INT RESCH costs
<br />701-4309-85-0000 CONTRACTED IT & SFTW SUPPORT 330 - - 2,925 3,095 3,174 8.52%MDM FEE and security monitoring
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 386 - 330 450 345 375 -16.67%
<br />701-4325-85-0000 COMMUNICATIONS 149 175 2,143 1,852 2,425 2,500 34.99%added patec previously in sewer budget
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 11,748 24,750 14,140 14,500 30,000 16,500 13.79%2018 scada controls repairs
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 9,554 12,500 5,724 6,750 2,500 2,750 -59.26%Based on current run rates / AOP completion impact
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY - 15,713 14,067 16,591 18,052 20,023 20.69%BASED ON 2018/2019 RENEWAL
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 15,527 121,300 112,035 118,892 136,520 140,600 18.26%Based on new run rates with AOP process
<br />TOTAL - - 187,251 358,438 304,534 375,898 423,482 431,723
<br /> OPERATING INCOME (LOSS)273,790$ 279,163$ 130,430$ 67,377$ 104,281$ 104,567$ 11,610$ 43,166$
<br />OTHER (INCOME) / EXPENSE
<br />701-3891-0-0-00 WT MISCELLANEOUS INCOME (2,529) (390) (2,495) (550) (12,559) (550) (550) (550)
<br />701-3620-0-1-00 WT INTEREST INCOME - (499) (23,907) (11,500) (16,714) (13,605) (15,105) (16,500)
<br />701-3713-0-0-00 WT WATER CONNECTION FEES (3,600) (3,180) (7,650) (450) (23,850) - (22,100) (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 - 10,000 5,000 10,000
<br />701-4499-80-0000 WT MISCELLANEOUS EXPENSE 1,915 1,632 172 650 1,572 650 650 650
<br />TOTAL (4,214)$ (2,437)$ (35,050)$ (1,850)$ (51,551)$ (3,505)$ (32,105)$ (40,400)$
<br />OPERATING INCOME BEFORE DEPRECIATION 278,004$ 281,600$ 165,480$ 69,227$ 155,832$ 108,072$ 43,715$ 83,566$
<br /> PRIOR TO 2016 PRODUCTION
<br />COSTS ACCOUNTED FOR IN
<br />SEPARATE FUND
|