|
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 />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 938,997$ 978,966$ $988,887 1,122,633$ 1,172,342$ 1,278,784$ 1,285,431$ 9.65% Includes the 2022 phase in of flat rate increase along with 2% increase in usage rates
<br />701-3715-0-0-00 WATER ON/OFF FEES 915 180 45 203 500 250 200 -60.00% No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 5,876 5,876 8,400 7,456 6,000 6,476 6,000 0.00% No change in rate
<br />TOTAL 945,788$ 985,022$ $997,332 $1,130,292 $1,178,842 $1,285,510 $1,291,631 9.57%
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 317,302$ 324,816$ 338,881$ 334,093$ 354,121$ 313,802$ 358,197$ 1.15% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENT
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 21,329 25,579 31,252 23,931 27,521 22,847 28,347 3.00% FROM DEPT SUMMARIES OT
<br />701-4121-80-0000 WT PERA 23,892 25,585 26,438 26,460 28,623 25,249 28,991 1.28% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-80-0000 WT FICA/MEDICARE 24,164 25,238 27,033 26,798 29,196 25,754 29,571 1.28% BASED ON ER 7.65% OF GROSS
<br />701-4131-80-0000 WT INSURANCE HEALTH 51,904 53,462 56,141 56,881 61,958 54,487 59,231 -4.40% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />701-4135-80-0000 WT INSURANCE WC 9,895 9,265 9,175 9,769 13,636 12,690 13,423 -1.56% BASED ON 2021/2022 RENEWAL
<br />701-4211-80-0000 WT OFFICE SUPPLIES 585 633 (27,781) 354 800 750 800 0.00% 2022 PROJECTED RUN RATE
<br />701-4212-80-0000 WT MOTOR FUELS 4,557 6,015 5,762 4,908 6,532 6,502 7,250 10.99% 2021 contracted cost per gal $1.98 / 2022 projection $2.41 / 3yr avg usage
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT 118 837 538 2,896 625 550 1,000 60.00% 2022 PROJECTED RUN RATE
<br />701-4226-80-0000 WT GENERAL SUPPLIES 3,396 5,649 12,081 3,013 11,500 11,196 12,000 4.35% More meter radios battery @ end of life
<br />701-4300-80-0000 WT AUDITOR 8,324 7,443 7,476 6,706 8,072 7,800 8,250 2.21% BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 20,640 22,801 22,990 32,157 32,700 32,414 34,035 4.08% BASED ON CONTRACTED IT /SW SPREADSHEET (SPLIT W/701-4308-85)
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 4,307 2,194 3,871 4,906 3,328 7,156 15,458 364.49% 2022 Includes Invoice Cloud admin fees
<br />701-4310-80-0100 WT METER READING FEES 10,232 7,970 8,217 8,470 8,724 8,725 8,990 3.05% Sensus fees /estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 9,255 10,275 9,860 9,548 10,800 9,031 10,770 -0.28% BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 5,548 4,638 19,884 6,788 13,500 9,067 13,500 0.00% Budgeted for 1 major main break annually
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 4,752 3,789 6,727 6,988 4,250 3,750 4,500 5.88% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE - 38 117 - - - - MOVED PRODUCTION COSTS
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG. 1,002 1,113 923 46 1,100 150 750 -31.82% 2022 PROJECTED RUN RATE
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 414 326 438 436 400 - 400 0.00% 2022 PROJECTED RUN RATE
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES - - - - 525 250 250 -52.38% 2022 PROJECTED RUN RATE
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 3,840 2,476 2,738 4,599 4,400 4,450 4,600 4.55% 2022 PROJECTED RUN RATE
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 11,519 15,457 9,717 3,286 3,417 5,305 5,650 65.35% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />TOTAL 536,974$ 559,170$ 573,636$ 573,031$ 625,728$ 561,925$ 645,962$ 3.23%
<br />WATER OPERATIONS
|