|
Fiscal Year 2021 12/31/2018
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT A
<br />2016 2017 2018 2019 2020 2020 2021 in Budget
<br />WATER OPERATIONS
<br />PRODUCTION OPERATING EXPENDITURES
<br />701-4110-85-0000 REGULAR EMPLOYEE 56,678 58,161 60,139 62,559 66,075 64,411 66,806 1.11% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS
<br />701-4111-85-0000 OVERTIME EMPLOYEE 712 1,024 367 936 1,050 1,800 1,500 42.86% FROM DEPT SUMMARIES OT
<br />701-4121-85-0000 PERA 4,768 4,900 5,078 5,458 5,034 4,966 5,123 1.76% BASED ON CURRENT PERA FUNDING RATE 7.5%
<br />701-4122-85-0000 FICA/MEDICARE 4,875 4,973 5,156 5,589 5,135 5,065 5,225 1.76% BASED ON ER 7.65% OF GROSS
<br />701-4131-85-0000 INSURANCE HEALTH 9,235 10,126 11,036 10,339 11,000 12,828 14,020 27.45% SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />701-4135-85-0000 WTR FILT INSURANCE WC 4,328 3,776 3,587 3,505 3,533 3,749 5,128 45.15% BASED ON 2019/2020 RENEWAL
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 3,146 396 772 644 1,301 855 925 -28.87% 2021 PROJECTED RUN RATE
<br />701-4226-85-0000 GENERAL SUPPLIES 52,187 55,746 55,429 46,794 56,500 51,750 56,500 0.00% VARIOUS TREATMENT CHEMICALS
<br />701-4226-85-0001 CARBON SUPPLY USAGE - 2,654 35,240 33,523 32,500 35,000 35,000 7.69% AMORTIZATION COST FOR CARBON BASED ON # OF GALLONS TREATED
<br />701-4226-85-0200 UV BULB SUPPLY USAGE - - 112,418 112,337 112,400 112,400 112,400 0.00% AMORTIZATION COST FOR BULBS ASSUMING 3 YEAR LIFE
<br />701-4226-85-0003 PEROXIDE SUPPILES - 27,930 27,920 33,000 28,533 30,000 -9.09% PEROIXIDE / AOP PROCESS
<br />701-4303-85-0000 ENGINEER EXPENSES 13,628 1,952 4,587 1,722 3,500 1,500 1,700 -51.43% 2021 PROJECTED RUN RATE
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS - 12,387 12,644 12,626 14,325 12,400 12,772 -10.84% WATER TESTING / LAB COSTS
<br />701-4309-85-0000 CONTRACTED IT & SFTW SUPPORT 330 - 3,659 2,657 3,238 2,740 2,830 -12.59% MDM FEE and security monitoring
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 386 330 345 690 570 690 720 26.32% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4325-85-0000 COMMUNICATIONS 149 2,143 2,694 2,596 2,550 2,325 2,405 -5.69% added patec previously in sewer budget
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 11,748 14,140 28,468 8,962 14,500 12,950 13,500 -6.90% 2021 PROJECTED RUN RATE
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 9,554 5,724 2,656 1,502 2,805 1,450 2,250 -19.79% 2021 PROJECTED RUN RATE
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY - 14,067 16,552 19,498 19,160 17,297 16,750 -12.58% BASED ON 2020/2021 RENEWAL
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 15,527 112,035 129,272 129,626 135,813 140,668 146,295 7.72% 2021 PROJECTED RUN RATE
<br />TOTAL 187,251 304,534 518,027 489,484 523,988 513,377 531,849 1.50%
<br /> OPERATING INCOME (LOSS)130,430$ 104,281$ (92,175)$ (94,590)$ (30,837)$ (11,606)$ 17,609$
<br />OTHER (INCOME) / EXPENSE
<br />701-3891-0-0-00 WT MISCELLANEOUS INCOME (2,495) (12,559) (4,350) (7,460) (550) (550) (550)
<br />701-3620-0-1-00 WT INTEREST INCOME (23,907) (16,714) (24,620) (28,476) (23,000) (12,000) (7,500)
<br />701-3713-0-0-00 WT WATER CONNECTION FEES (7,650) (23,850) (25,700) (1,750) (34,000) (1,750) (34,000)
<br />701-3910-0-0-00 WT SALE OF ASSETS (1,170) - - - - - -
<br />701-4335-80-0000 WT BKUP RESTORATION COSTS - - - - - - -
<br />701-4499-80-0000 WT MISCELLANEOUS EXPENSE 172 1,572 1,362 650 650 650 650
<br />TOTAL (35,050)$ (51,551)$ (53,309)$ (37,036)$ (56,900)$ (13,650)$ (41,400)$
<br />OPERATING INCOME BEFORE DEPRECIATION 165,480$ 155,832$ (38,866)$ (57,554)$ 26,063$ 2,044$ 59,009$
|