|
Fiscal Year 2021 12/31/2018
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT A
<br />2016 2017 2018 2019 2020 2020 2021 in Budget
<br />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 911,902$ 938,997$ 978,966$ $988,887 $1,088,000 $1,087,693 $1,172,342 9.99% Includes the 2021 phase in of flat rate increase along with 2% increase in usage rates
<br />701-3715-0-0-00 WATER ON/OFF FEES 525 915 180 45 550 550 500 0.00% No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 5,500 5,876 5,876 8,400 6,000 3,000 6,000 -9.22% No change in rate
<br />TOTAL 917,927$ 945,788$ 985,022$ $997,332 $1,094,550 $1,091,243 $1,178,842 9.85%
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 298,315$ 317,302$ 324,816$ 338,881$ 343,643$ 340,850 354,121 3.05% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS / STAFF TURNOVER FROM 2020
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 16,381 21,329 25,579 31,252 26,910 24,662 28,361 5.39% FROM DEPT SUMMARIES OT
<br />701-4121-80-0000 WT PERA 23,433 23,892 25,585 26,438 27,791 26,699 28,686 3.22% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-80-0000 WT FICA/MEDICARE 23,637 24,164 25,238 27,033 28,347 27,233 29,260 3.22% BASED ON ER 7.65% OF GROSS
<br />701-4131-80-0000 WT INSURANCE HEALTH 58,664 51,904 53,462 56,141 55,553 56,538 61,883 11.39% SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />701-4135-80-0000 WT INSURANCE WC 11,559 9,895 9,265 9,175 9,128 9,685 13,264 45.31% BASED ON 2019/2020 RENEWAL
<br />701-4211-80-0000 WT OFFICE SUPPLIES 721 585 633 1,020 750 725 800 6.67% 2021 PROJECTED RUN RATE
<br />701-4212-80-0000 WT MOTOR FUELS 4,152 4,557 6,015 5,762 6,756 5,305 6,532 -3.32% 2020 contracted cost per gal $2.13 / 2021 projection $2.28 / 3yr avg usage
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT 762 118 837 538 575 836 625 8.70% 2021 PROJECTED RUN RATE
<br />701-4226-80-0000 WT GENERAL SUPPLIES 4,253 3,396 5,649 12,081 9,500 8,865 11,500 21.05% More meter radios battery @ end of life
<br />701-4300-80-0000 WT AUDITOR 7,350 8,324 7,443 7,476 7,601 7,076 8,072 6.20% BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 21,693 20,640 22,801 22,990 27,615 32,136 32,700 18.41% BASED ON CONTRACTED IT /SW SPREADSHEET (SPLIT W/701-4308-85)
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 326 4,307 2,194 3,871 4,416 2,712 3,328 -24.64% BASED ON Misc CONTRACTED SERVIES spreadsheet
<br />701-4310-80-0100 WT METER READING FEES 7,500 10,232 7,970 8,217 8,470 8,470 8,724 3.00% Sensus fees /estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 10,391 9,255 10,275 9,860 10,200 10,280 10,800 5.88% BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 1,104 5,548 4,638 19,884 11,730 11,795 13,500 15.09% Budgeted for 1 major main break annually
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 5,039 4,752 3,789 6,727 3,500 4,021 4,250 21.43% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE - - 38 117 - - - 0.00% MOVED PRODUCTION COSTS
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG. 1,295 1,002 1,113 923 650 650 1,100 69.23% 2021 PROJECTED RUN RATE
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 371 414 326 438 450 450 400 -11.11% 2021 PROJECTED RUN RATE
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES 491 - - - 510 510 525 2.94% 2021 PROJECTED RUN RATE
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 1,681 3,840 2,476 2,738 4,422 3,672 4,400 -0.49% 2021 PROJECTED RUN RATE
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 86,619 11,519 15,457 9,717 12,881 6,300 6,552 -49.13% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />TOTAL 600,246$ 536,974$ 559,170$ 602,437$ 601,399$ 589,471 629,383 1.28%
<br />WATER OPERATIONS
|