|
Fiscal Year 2022 12/31/2018 EXHIBIT C
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT B
<br />2017 2018 2019 2020 2021 2021 2022 in Budget
<br />WATER OPERATIONS
<br />PRODUCTION OPERATING EXPENDITURES
<br />701-4110-85-0000 REGULAR EMPLOYEE 58,161 60,139 62,559 64,387 66,806 66,806 68,769 2.94% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENT
<br />701-4111-85-0000 OVERTIME EMPLOYEE 1,024 367 936 1,946 1,500 1,725 1,777 18.45% FROM DEPT SUMMARIES OT
<br />701-4121-85-0000 PERA 4,900 5,078 5,458 5,451 5,123 5,140 5,291 3.28% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-85-0000 FICA/MEDICARE 4,973 5,156 5,589 5,663 5,225 5,243 5,397 3.28% BASED ON ER 7.65% OF GROSS
<br />701-4131-85-0000 INSURANCE HEALTH 10,126 11,036 10,339 12,828 14,020 16,267 13,599 -3.00% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />701-4135-85-0000 WTR FILT INSURANCE WC 3,776 3,587 3,505 3,782 5,278 4,913 5,200 -1.48% 2022 PROJECTED RUN RATE
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 396 772 644 213 925 200 1,000 8.11% BASED ON 2021/2022 RENEWAL
<br />701-4226-85-0000 GENERAL SUPPLIES 55,746 55,429 46,794 39,540 56,500 46,000 48,760 -13.70% VARIOUS TREATMENT CHEMICALS
<br />701-4226-85-0001 CARBON SUPPLY USAGE 2,654 35,240 33,523 35,990 35,000 45,000 36,500 4.29% AMORTIZATION COST FOR CARBON BASED ON # OF GALLONS TREATED
<br />701-4226-85-0200 UV BULB SUPPLY USAGE - 112,418 112,337 68,698 112,400 112,400 115,000 2.31% AMORTIZATION COST FOR BULBS ASSUMING 3 YEAR LIFE
<br />701-4226-85-0003 PEROXIDE SUPPILES - 27,930 27,920 28,007 30,000 15,950 32,538 8.46% PEROIXIDE / AOP PROCESS - 2021 single delivery
<br />701-4303-85-0000 ENGINEER EXPENSES 1,952 4,587 1,722 525 1,700 2,525 2,250 32.35% 2022 PROJECTED RUN RATE
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS 12,387 12,644 12,626 6,718 12,772 6,176 7,107 -44.36% WATER TESTING / LAB COSTS
<br />701-4309-85-0000 CONTRACTED IT & SFTW SUPPORT - 3,659 2,657 - 2,830 2,900 3,100 9.54% MDM FEE and security monitoring
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 330 345 690 690 720 7,020 9,031 1154.31% 2021/2022 Includes Invoice Cloud admin/CC fees
<br />701-4325-85-0000 COMMUNICATIONS 2,143 2,694 2,596 5,210 2,405 5,700 5,928 146.49% added patec previously in sewer budget
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 14,140 28,468 8,962 16,988 13,500 28,500 17,500 29.63% 2022 PROJECTED RUN RATE
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 5,724 2,656 1,502 1,017 2,250 1,500 1,750 -22.22% 2022 PROJECTED RUN RATE
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY 14,067 16,552 19,498 17,664 16,750 13,500 7,800 -53.43% BASED ON 2020/2021 RENEWAL
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 112,035 129,272 129,626 138,429 143,966 148,163 154,000 6.97% 2022 PROJECTED RUN RATE
<br />TOTAL 304,534 518,027 489,484 453,744 529,670 535,627 542,296 2.38%
<br /> OPERATING INCOME (LOSS)104,281$ (92,175)$ (65,788)$ 103,517$ 23,444$ 187,958$ 103,373$ 340.94%
<br />OTHER (INCOME) / EXPENSE
<br />701-3891-0-0-00 WT MISCELLANEOUS INCOME (12,559) (4,350) (7,460) (901) (550) (150) (150) -72.73%
<br />701-3620-0-1-00 WT INTEREST INCOME (16,714) (24,620) (28,476) (27,781) (7,500) (12,450) (6,250) -16.67%
<br />701-3713-0-0-00 WT WATER CONNECTION FEES (23,850) (25,700) (1,750) - (34,000) - - -100.00% CONNECTION FEES RECORDED TO UTILITY INFRASTRUCTURE FUND IN 2021
<br />701-3910-0-0-00 WT SALE OF ASSETS - - - (1,520) - (5,932) (3,500) 0.00%
<br />701-4335-80-0000 WT BKUP RESTORATION COSTS - - - 1,165 - - - 0.00%
<br />701-4499-80-0000 WT MISCELLANEOUS EXPENSE 1,572 1,362 650 5,540 650 650 650 0.00%
<br />701-4310-90-0000 FIBER LAN/OPTIC CNTRCT SVC 0 0 0 4,246 4,224 4,224 4,351 3.00%
<br />TOTAL (51,551) (53,309) (37,036) (19,251) (37,176) (13,658) (4,899) -86.82%
<br />OPERATING INCOME BEFORE DEPRECIATION 155,832$ (38,866)$ (28,752)$ 122,768$ 60,620$ 201,616$ 108,272$ 78.61%
|