|
EXHIBIT A
<br />Fiscal Year 2023 14
<br /> ACTUAL ACTUAL ACTUAL ACTUAL EST. ACTUAL BUDGET
<br />2018 2019 2020 2021 2022 2023 PW Usage %Fixed %AD Usage %Fixed %TOTAL
<br />DISTRIBUTION EXPENSES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 324,816$ 338,881$ 334,093$ 310,612$ 362,068$ 383,323$ 270,233 81,070 30%189,163 70%113,090 11,309 10%101,781 90%383,323
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 25,579 31,252 23,931 21,284 27,800 20,400 14,381 4,314 30%10,067 70%6,019 602 10%5,417 90%20,400
<br />701-4115-80-0000 WT POST BENEFIT PAYOUT 3,571 1,158 - - - - - - - - - - - - - - -
<br />701-4121-80-0000 WT PERA 25,585 26,438 26,460 25,096 30,223 30,279 21,346 6,404 30%14,942 70%8,933 893 10%8,040 90%30,279
<br />701-4122-80-0000 WT FICA/MEDICARE 25,238 27,033 26,798 24,291 28,252 30,885 21,773 6,532 30%15,241 70%9,112 911 10%8,201 90%30,885
<br />701-4131-80-0000 WT INSURANCE HEALTH 53,462 56,141 56,881 53,813 54,874 61,598 43,425 13,028 30%30,398 70%18,173 1,817 10%16,356 90%61,598
<br />701-4135-80-0000 WT INSURANCE WC 9,265 9,175 9,769 12,545 10,655 10,301 10,301 3,090 30%7,211 70%- - - - - 10,301
<br />701-4211-80-0000 WT OFFICE SUPPLIES 633 1,020 354 511 625 750 - - - - - 750 75 10%675 90%750
<br />701-4212-80-0000 WT MOTOR FUELS 6,015 5,762 4,908 5,688 5,164 7,475 7,475 2,243 30%5,233 70%- - - - - 7,475
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT 837 538 2,896 140 650 1,000 1,000 300 30%700 70%- - - - - 1,000
<br />701-4226-80-0000 WT GENERAL SUPPLIES 5,649 12,081 3,013 12,083 23,000 25,500 25,500 7,650 30%17,850 70%- - - - - 25,500
<br />701-4300-80-0000 WT AUDITOR 7,443 7,476 6,706 7,799 7,996 8,268 - - - - - 8,268 827 10%7,441 90%8,268
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 22,801 22,990 32,157 32,654 33,500 35,175 18,564 1,856 10%16,708 90%16,611 1,661 10%14,950 90%35,175
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 2,194 3,871 4,906 3,739 7,200 9,500 9,500 950 10%8,550 90%- - - - - 9,500
<br />701-4310-80-0100 WT METER READING FEES 7,970 8,217 8,470 8,725 8,986 9,435 9,435 - - 9,435 100%- - - - - 9,435
<br />701-4325-80-0000 WT COMMUNICATIONS 10,275 9,860 9,548 8,662 6,300 7,600 7,600 7,613 100%(13) 0%- - - - - 7,600
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 4,638 19,884 6,788 7,056 28,500 15,000 15,000 4,500 30%10,500 70%- - - - - 15,000
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 3,789 6,727 6,988 2,187 3,300 4,500 4,500 1,350 30%3,150 70%- - - - - 4,500
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE 38 117 - - - - - - 30%- 70%- - - - - -
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG. 1,113 923 46 (390) 500 525 525 - - 525 100%- - - - - 525
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 326 438 436 313 482 500 500 - - 500 100%- - - - - 500
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES - - - - 227 250 250 - - 250 100%- - - - - 250
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 2,476 2,738 4,599 3,596 4,175 4,400 - - - - - 4,400 220 5%4,180 95%4,400
<br />701-4365-80-0000 WT INSURANCE PROPERTY / LIABILILITY - - 0 - - - - - - - - - - - - - -
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 15,457 9,717 3,286 4,175 3,350 4,250 4,250 1,275 30%2,975 70%- - - - - 4,250
<br />701-4499-80-0000 WT MISCELLANEOUS EXPENSE 1,362 650 5,540 2,180 750 650 650 195 30%455 70%- - - - - 650
<br />TOTAL DISTRIBUTION 560,531$ 603,087$ 578,571$ 546,759$ 648,577$ 671,564$ 486,209$ 142,370$ 29%343,839$ 71%185,355$ 18,316$ 10%167,040$ 90%671,564
<br />WATER EXPENSES
<br />PW ADMINISTRATIVE COSTS
|