|
EXHIBIT B
<br />Fiscal Year 2023 12/31/2018 EXHIBIT C
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />2018 2019 2020 2021 2022 2022 2023 in Budget
<br />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 978,966$ $988,887 1,122,633$ 1,291,961$ 1,285,431$ 1,317,831$ 1,365,843$ 6.26%
<br />Assumes $3.00 increase in quarterly flat fee, 2.5 % increase in usage rates and 5% less in usage volume
<br />billed.
<br />701-3715-0-0-00 WATER ON/OFF FEES 180 45 203 1,095 200 250 250 25.00% No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 5,876 8,400 7,456 7,194 6,000 6,760 7,000 16.67% No change in rate
<br />TOTAL 985,022$ $997,332 $1,130,292 $1,300,250 $1,291,631 $1,324,841 $1,373,093 6.31%
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 324,816$ 338,881$ 334,093$ 310,612$ 363,281$ 362,068$ 383,323 5.52% INCLUDES ESTIMATED 2023 WAGE ADJUSTMENT
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 25,579 31,252 23,931 21,284 28,347 27,800 20,400 -28.03% FROM DEPT SUMMARIES OT
<br />701-4115-80-0000 WT POST BENEFIT PAYOUT 3,571 1,158 - - - - - 0.00%
<br />701-4121-80-0000 WT PERA 25,585 26,438 26,460 25,096 29,372 30,223 30,279 3.09% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-80-0000 WT FICA/MEDICARE 25,238 27,033 26,798 24,291 29,960 28,252 30,885 3.09% BASED ON ER 7.65% OF GROSS
<br />701-4131-80-0000 WT INSURANCE HEALTH 53,462 56,141 56,881 53,813 58,525 54,874 61,598 5.25% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF ELECTIONS
<br />701-4135-80-0000 WT INSURANCE WC 9,265 9,175 9,769 12,545 12,357 10,655 10,301 -16.64% BASED ON 2023/2023 RENEWAL
<br />701-4211-80-0000 WT OFFICE SUPPLIES 633 (27,781) 354 511 800 625 750 -6.25% 2023 PROJECTED RUN RATE
<br />701-4212-80-0000 WT MOTOR FUELS 6,015 5,762 4,908 5,688 5,927 5,164 7,475 26.12% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT 837 538 2,896 140 1,000 650 1,000 0.00% 2023 PROJECTED RUN RATE
<br />701-4226-80-0000 WT GENERAL SUPPLIES 5,649 12,081 3,013 12,083 13,000 23,000 25,500 96.15% More meter radios battery @ end of life
<br />701-4300-80-0000 WT AUDITOR 7,443 7,476 6,706 7,799 8,250 7,996 8,268 0.22% BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 22,801 22,990 32,157 32,654 34,035 33,500 35,175 3.35% BASED ON CONTRACTED IT /SW SPREADSHEET (SPLIT W/701-4308-85)
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 2,194 3,871 4,906 3,739 15,458 7,200 9,500 -38.54% 2023 Includes Invoice Cloud admin fees
<br />701-4310-80-0100 WT METER READING FEES 7,970 8,217 8,470 8,725 8,990 8,986 9,435 4.96% Sensus fees /estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 10,275 9,860 9,548 8,662 11,970 6,300 7,600 -36.51% BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 4,638 19,884 6,788 7,056 13,500 28,500 15,000 11.11% Budgeted for 1 major main break annually
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 3,789 6,727 6,988 2,187 4,500 3,300 4,500 0.00% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE 38 117 - - - - - 0.00% MOVED PRODUCTION COSTS
<br />701-4381-80-0000 WT TRAINING, CONF. & MTG. 1,113 923 46 (390) 750 500 525 -30.00% 2023 PROJECTED RUN RATE
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 326 438 436 313 400 482 500 25.00% 2023 PROJECTED RUN RATE
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES - - - - 250 227 250 0.00% 2023 PROJECTED RUN RATE
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 2,476 2,738 4,599 3,596 4,600 4,175 4,400 -4.35% 2023 PROJECTED RUN RATE
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 15,457 9,717 3,286 4,175 5,650 3,350 4,250 -24.78% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />TOTAL 559,170$ 573,636$ 573,031$ 544,579$ 650,921$ 647,827$ 670,914$ 3.07%
<br />WATER OPERATIONS
|