|
EXHIBIT A
<br />Fiscal Year 2022
<br />ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET
<br />2019 2020 2021 2021 2022 PW Usage %Fixed %AD Usage %Fixed %TOTAL
<br />WATER EXPENSES
<br />PW ADMINISTRATIVE COSTS
<br />PRODUCTION EXPENSES
<br />701-4110-85-0000 REGULAR EMPLOYEE 62,559 64,387 66,806 66,806 68,769 68,769 68,769 100%- 0%68,769
<br />701-4111-85-0000 OVERTIME EMPLOYEE 936 1,946 1,500 1,725 1,777 1,777 1,777 100%- 0%1,777
<br />701-4121-85-0000 PERA 5,458 5,451 5,123 5,140 5,291 5,291 5,291 100%- 0%5,291
<br />701-4122-85-0000 FICA/MEDICARE 5,589 5,663 5,225 5,243 5,397 5,397 5,397 100%- 0%5,397
<br />701-4131-85-0000 INSURANCE HEALTH 10,339 12,828 14,020 16,267 13,599 13,599 13,599 100%- 0%13,599
<br />701-4135-85-0000 WTR FILT INSURANCE WC 3,505 3,782 5,278 4,913 5,200 5,200 5,200 100%- 0%5,200
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 644 213 925 200 1,000 1,000 1,000 100%- 0%1,000
<br />701-4226-85-0000 CHEMICAL SUPPLIES 46,794 39,540 56,500 46,000 48,760 48,760 48,760 100%- 0%48,760
<br />701-4226-85-0001 CARBON SUPPLY USAGE 33,523 35,990 35,000 45,000 36,500 36,500 36,500 100%- 0%36,500
<br />701-4226-85-0200 UV BULB SUPPLY USAGE 112,337 68,698 112,400 112,400 115,000 115,000 115,000 100%- 0%115,000
<br />701-4226-85-0003 PEROXIDE SUPPILES 27,920 28,007 30,000 15,500 31,000 31,000 31,000 100%- 0%31,000
<br />701-4303-85-0000 ENGINEER EXPENSES 1,722 525 1,700 2,525 2,250 2,250 - 0%2,250 100%2,250
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS 12,626 6,718 12,772 6,176 7,107 7,107 7,107 100%- 0%7,107
<br />701-4309-85-0000 CONTRACTED IT & SFTW SUPPORT 2,657 - 2,830 2,900 3,100 3,100 3,100 100%- 0%3,100
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 690 690 720 7,020 9,031 9,031 9,031 100%- 0%9,031
<br />701-4325-85-0000 COMMUNICATIONS 2,596 5,210 2,405 5,700 5,928 5,928 5,928 100%- 0%5,928
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 8,962 16,988 13,500 28,500 17,500 17,500 17,500 100%- 0%17,500
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 1,502 1,017 2,250 1,500 1,750 1,750 1,750 100%- 0%1,750
<br />701-4351-85-0000 PL NOTICES & PUBLICATIONS - - - - - - - 100% 0%-
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY 19,498 17,664 16,750 13,500 7,800 7,800 6,240 80%1,560 20%7,800
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 129,626 138,429 143,966 148,163 154,000 154,000 154,000 100%- 0%154,000
<br />701-4310-90-0000 FIBER LAN/OPTIC CNTRCT SVC - 4,246 4,224 4,224 4,351 4,351 - 0%4,351 100%4,351
<br />TOTAL PRODUCTION 489,484 457,990 533,894 539,401 545,109 545,109 536,948$ 99%8,161 1%- - - - 545,109
<br />TOTAL OPERATING EXPENSES 1,092,572 1,036,561 1,160,272 1,101,976 1,191,721 1,003,371 668,887 73%334,484 36%188,350 18,605 2%169,745 18%1,191,721
<br />545,109
<br />DEPRECIATION EXPENSE
<br />WT DEPRECIATION TREATMENT PLANTS 145,232 149,543 153,853 153,853 157,700 157,700 157,700 100%- 0%157,700
<br />WT DEPRECIATION MAINTENANCE EQUIP 76,358 78,624 80,891 80,891 82,913 82,913 24,874 30%58,039 70%82,913
<br />WT DEPRECIATION WATERMAINS 283,776 292,199 300,622 300,622 308,137 308,137 92,441 30%215,696 70%308,137
<br />TOTAL DEPRECIATION 505,366 520,366 535,366 535,366 548,750 548,750 275,015 50%273,735 50%- - - - 548,750
<br />TOTAL OVERALL EXPENSES 1,597,938 1,556,927 1,695,638 1,637,342 1,740,471 1,552,121 943,902 80%608,219 51%188,350 18,605 2%169,745 14%1,740,471
<br />FIXED 504,229 42%273,735 50%777,964 45%337,963.00$ 0.43$
<br />USAGE 687,492 58%275,015 50%962,507 55%$827,828.00 0.86$
<br />1,191,721 100%548,750 100%1,740,471 100%
<br />NO ADMINISTRATIVE COSTS INCLUDED
<br />NO ADMINISTRATIVE COSTS INCLUDED
<br />DEPRECIATION OPERATING OVERALL
|