|
Fiscal Year 2020 12/31/2018 14
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT A
<br />2015 2016 2017 2018 2019 2019 2020 in Budget
<br />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 891,132$ 911,902$ 938,997$ 978,966$ $1,059,007 $1,001,233 $1,088,454 2.78% Includes the 2020 phase in of flat rate increase
<br />701-3715-0-0-00 WATER ON/OFF FEES 450 525 915 180 550 550 550 0.00% No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 5,650 5,500 5,876 5,876 6,609 8,391 6,000 -9.22%
<br />TOTAL 897,232$ 917,927$ 945,788$ 985,022$ $1,066,166 $1,010,174 $1,095,004 2.70%
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 286,793$ 298,315$ 317,302$ 324,816$ 340,306$ 322,858$ 343,643$ 0.98% AD/PW wages, 2019 actual reflects staff turnover
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 17,235 16,381 21,329 25,579 25,000 28,000 26,910 7.64% Dept summ-pw OT includes split of pump duty
<br />701-4115-80-0000 WT POST BENEFIT PAYOUT - 2,095 - 3,571 - - - 0.00%
<br />701-4121-80-0000 WT PERA 23,514 23,433 23,892 25,585 27,398 26,314 27,791 1.44% 7.50%
<br />701-4122-80-0000 WT FICA/MEDICARE 22,135 23,637 24,164 25,238 27,946 26,841 28,347 1.44% 7.65%
<br />701-4131-80-0000 WT INSURANCE HEALTH 53,691 58,664 51,904 53,462 56,439 56,143 55,553 -1.57% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />701-4135-80-0000 WT INSURANCE WC 9,712 11,559 9,895 9,265 9,686 9,686 9,128 -5.76% BASED ON 2019/2020 RENEWAL
<br />701-4211-80-0000 WT OFFICE SUPPLIES 785 721 585 633 675 950 750 11.11% based on run rates
<br />701-4212-80-0000 WT MOTOR FUELS 5,834 4,152 4,557 6,015 6,930 5,665 6,756 -2.51% 2019 contracted cost per gallon $2.10/2020 projection $2.88/3yr avg usage +1%
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT - 762 118 837 500 675 575 15.00% based on run rates
<br />701-4226-80-0000 WT GENERAL SUPPLIES 3,416 4,253 3,396 5,649 5,350 10,573 9,500 77.57% More meter radios battery @ end of life
<br />701-4300-80-0000 WT AUDITOR 6,167 7,350 8,324 7,443 7,420 7,420 7,601 2.44% BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 19,592 21,693 20,640 22,801 25,962 25,116 27,615 6.37% BASED ON CONTRACTED IT /SW SPREADSHEET (SPLIT W/701-4308-85)
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 2,428 326 4,307 2,194 2,271 2,181 2,316 2.00% BASED ON Misc CONTRACTED SERVIES spreadsheet
<br />701-4310-80-0100 WT METER READING FEES 5,017 7,500 10,232 7,970 8,209 8,217 8,470 3.18% Sensus fees /estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 9,949 10,391 9,255 10,275 9,810 10,498 10,200 3.98% BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 24,925 1,104 5,548 4,638 11,500 10,690 11,730 2.00% One major main breaks in 2019 ytd, budgeted for 1 major main break in 2020
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 9,760 5,039 4,752 3,789 6,500 3,244 3,500 -46.15% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG. 1,990 1,295 1,002 1,113 650 550 650 0.00% based on run rates
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 500 371 414 326 255 438 450 76.47% Based on est renewal requirements
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES 399 491 - - 500 500 510 2.00% Based on est renewal requirements
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 4,588 1,681 3,840 2,476 4,335 3,781 4,422 2.00% Timing of postage fills vary
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 89,504 86,619 11,519 15,457 16,153 12,628 12,881 -20.26% MAJORITY MOVED PRODUCTION COSTS IN 2016
<br />TOTAL 618,069$ 600,246$ 536,974$ 559,170$ 593,794$ 572,968$ 599,298$ 0.93%
<br />WATER OPERATIONS
|