|
EXHIBIT A
<br />Fiscal Year 2025 12/31/2022
<br />ACTUAL ACTUAL ACTUAL ACTUAL EST. ACTUAL BUDGET
<br />2020 2021 2022 2023 2024 2025 PW Usage %Fixed %AD Usage %Fixed %TOTAL
<br />WATER EXPENSES
<br />PW ADMINISTRATIVE COSTS
<br />PRODUCTION EXPENSES
<br />701-4110-85-0000 REGULAR EMPLOYEE 64,387 73,307 71,312 76,611 78,889 87,396 87,396 87,396 100%- 0%87,396
<br />701-4111-85-0000 OVERTIME EMPLOYEE 1,946 717 283 1,500 20,409 17,307 17,307 17,307 100%- 0%17,307
<br />701-4121-85-0000 PERA 5,451 6,156 5,812 5,858 5,917 6,180 6,180 6,180 100%- 0%6,180
<br />701-4122-85-0000 FICA/MEDICARE 5,663 6,233 5,907 5,975 6,035 7,627 7,627 7,627 100%- 0%7,627
<br />701-4131-85-0000 INSURANCE HEALTH 12,828 15,634 14,261 15,264 14,573 14,705 14,705 14,705 100%- 0%14,705
<br />701-4135-85-0000 WTR FILT INSURANCE WC 3,782 4,913 4,124 3,987 4,459 2,884 2,884 2,884 100%- 0%2,884
<br />701-4221-85-0000 SUPPLIES- EQUIPMENT 213 20 45 1,000 500 500 500 500 100%- 0%500
<br />701-4226-85-0000 CHEMICAL SUPPLIES 39,540 45,991 47,124 58,213 59,336 64,083 64,083 64,083 100%- 0%64,083
<br />701-4226-85-0001 CARBON SUPPLY USAGE 35,990 15,948 26 15,000 30,171 30,774 30,774 30,774 100%- 0%30,774
<br />701-4226-85-0200 UV BULB SUPPLY USAGE 68,698 729 4,161 25,000 15,000 43,800 43,800 43,800 100%- 0%43,800
<br />701-4226-85-0003 PEROXIDE SUPPILES 28,007 15,948 45,432 46,993 41,584 43,039 43,039 43,039 100%- 0%43,039
<br />701-4303-85-0000 ENGINEER EXPENSES 525 2,274 10,566 2,250 11,742 4,000 4,000 - 0%4,000 100%4,000
<br />701-4308-85-0000 WATER QUALITY PROTECTION COSTS 6,718 5,547 8,763 8,386 10,194 10,500 10,500 10,500 100%- 0%10,500
<br />701-4310-85-0000 MISC CONTRACTED SERVICES 690 345 3,369 9,961 1,600 1,750 1,750 1,750 100%- 0%1,750
<br />701-4325-85-0000 COMMUNICATIONS 5,210 2,305 3,839 5,928 5,178 3,640 3,640 3,640 100%- 0%3,640
<br />701-4339-85-0000 EQUIP REPAIRS & MAINTENANCE 16,988 26,353 44,363 30,000 40,129 35,000 35,000 35,000 100%- 0%35,000
<br />701-4340-85-0000 BLDG REPAIRS & MAINTENANCE 1,017 300 323 650 844 950 950 950 100%- 0%950
<br />701-4351-85-0000 PL NOTICES & PUBLICATIONS - - - - - - - 100%0%-
<br />701-4365-85-0000 INSURANCE PROPERTY / LIABILITY 17,664 11,637 11,024 13,430 18,036 18,366 18,366 14,693 80%3,673 20%18,366
<br />701-4381-85-0000 ELECTRIC AND GAS UTILITIES 138,429 141,375 172,666 190,000 156,855 167,835 167,835 167,835 100%- 0%167,835
<br />701-4310-90-0000 FIBER LAN/OPTIC CNTRCT SVC 4,246 4,241 4,241 4,351 4,351 4,470 4,470 - 0%4,470 100%4,470
<br />TOTAL PRODUCTION 457,990 379,973 457,642 520,357 525,801 564,806 564,806 552,662$ 98%12,143 2%- - - - 564,806
<br />TOTAL OPERATING EXPENSES 1,036,561 926,732 1,111,211 1,144,773 1,210,289 1,304,578 1,100,416 709,442 77%390,974 42%204,162 20,156 2%184,005 20%1,304,578
<br />564,806
<br />DEPRECIATION EXPENSE
<br />WT DEPRECIATION TREATMENT PLANTS 153,964 145,524 143,589 178,693 180,456 180,456 180,456 180,456 100%- 0%180,456
<br />WT DEPRECIATION MAINTENANCE EQUIP 163,751 148,964 153,248 190,451 191,927 191,927 191,927 57,578 30%134,349 70%191,927
<br />WT DEPRECIATION WATERMAINS 202,650 233,647 225,670 229,188 237,519 237,519 237,519 71,256 30%166,263 70%237,519
<br />TOTAL DEPRECIATION 520,366 528,135 522,507 598,332 609,902 609,902 609,902 309,290 51%300,612 49%- - - - 609,902
<br />TOTAL OVERALL EXPENSES 1,556,927 1,454,867 1,633,718 1,743,105 1,820,191 1,914,481 1,710,318 1,018,732 86%691,587 59%204,162 20,156 2%184,005 16%1,914,480
<br />FIXED 574,981 44%300,612 49%875,593 46%337,963.00$ 0.39$
<br />USAGE 729,598 56%309,290 51%1,038,888 54%$827,828.00 143,589.00$
<br />1,304,579 100%609,902 100%1,914,481 100%
<br /> OPERATING
<br />NO ADMINISTRATIVE COSTS INCLUDED
<br />DEPRECIATION OVERALL
<br />NO ADMINISTRATIVE COSTS INCLUDED
<br />23
|