|
Fiscal Year 2019 14 EXHIBIT A
<br />ACTUAL ACTUAL ACTUAL BUDGET ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />2014 2015 2016 2017 2017 2018 2018 2019 in Budget
<br />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 869,372$ 891,132$ 911,902$ 981,030$ 938,997$ $1,037,742 977,739$ $1,051,769 1.35%Includes the 2019 phase in of flat rate increase
<br />701-3715-0-0-00 WATER ON/OFF FEES 735 450 525 550 915 550 550 550 0.00%No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 5,300 5,650 5,500 5,876 5,876 6,526 7,432 6,609 1.27%
<br />TOTAL 875,407$ 897,232$ 917,927$ 987,456$ 945,788$ $1,044,818 985,721$ $1,058,928 1.35%Blended rate increase
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 284,852$ 286,793$ 298,315$ 315,278$ 317,302$ 328,044$ 319,941$ 335,237$ 2.19%AD/PW wages, 2018 actual reflects staff turnover
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 8,498 17,235 16,381 15,304 21,329 17,140 24,269 25,000 45.86%Dept summ-pw OT includes split of pump duty
<br />701-4115-80-0000 WT POST BENEFIT PAYOUT - - 2,095 - - - - -
<br />701-4121-80-0000 WT PERA 30,195 23,514 23,433 24,794 23,892 25,889 25,816 27,018 4.36%7.50%
<br />701-4122-80-0000 WT FICA/MEDICARE 22,143 22,135 23,637 25,289 24,164 26,407 26,332 27,558 4.36%7.65%
<br />701-4131-80-0000 WT INSURANCE HEALTH 49,415 53,691 58,664 60,008 51,904 55,615 53,401 57,069 2.61%SPLIT PREMUIM INCREASE IN 2019
<br />701-4135-80-0000 WT INSURANCE WC 6,510 9,712 11,559 11,479 9,895 3,000 9,250 9,686 222.87%BASED ON 2018/2019 RENEWAL, 2018 budget assumed different allocation
<br />701-4211-80-0000 WT OFFICE SUPPLIES 1,126 785 721 740 585 750 675 675 -10.00%based on run rates
<br />701-4212-80-0000 WT MOTOR FUELS 8,562 5,834 4,152 5,017 4,557 5,770 5,860 6,930 20.10%2018 contracted cost per gallon $2.37 / 2019 projection $2.96 / 3yr avg usage +1%
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT - - 762 750 118 750 500 500 -33.33%based on run rates
<br />701-4226-80-0000 WT GENERAL SUPPLIES 2,996 3,416 4,253 2,657 3,396 2,142 4,875 5,350 149.77%More meter radios battery @ end of life
<br />701-4300-80-0000 WT AUDITOR 7,750 6,167 7,350 7,650 8,324 7,250 7,250 7,420 2.34%BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 15,148 19,592 21,693 26,725 20,640 36,263 24,200 25,962 -28.41%BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 4,071 2,428 326 400 4,307 400 2,200 2,277 469.25%BASED ON Misc CONTRACTED SERVIES spreadsheet
<br />701-4310-80-0100 WT METER READING FEES 3,206 5,017 7,500 7,500 10,232 7,725 7,970 8,209 6.27%2019-sensus fees/estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 10,273 9,949 10,391 10,641 9,255 9,734 9,400 9,810 0.78%BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 7,127 24,925 1,104 11,500 5,548 11,500 6,500 11,500 0.00%no main breaks in 2018 ytd budgeted for 1 main break in 2019
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 12,428 9,760 5,039 10,465 4,752 6,500 5,900 6,500 0.00%MAJORITY MOVED PRODUCTION COSTS
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE 1,388 6,279 - 1,400 - - - - MOVED PRODUCTION COSTS
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG.2,051 1,990 1,295 2,100 1,002 2,100 600 650 -69.05%based on run rates
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 114 500 371 450 414 450 90 255 -43.33%Based on est renewal requirements
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES 349 399 491 500 - 500 500 500 0.00%Based on est renewal requirements
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 4,764 4,588 1,681 4,394 3,840 4,335 4,000 4,335 0.00%Timing of postage fills vary
<br />701-4365-80-0000 WT INSURANCE PROPERTY / LIABILILITY 25,782 13,855 12,414 - - - - - MOVED TO PRODUCTION
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 92,869 89,504 86,619 16,600 11,519 12,090 11,100 11,600 -4.06%MAJORITY MOVED PRODUCTION COSTS
<br />TOTAL 601,617$ 618,069$ 600,246$ 561,641$ 536,974$ 564,353$ 550,629$ 584,040$
<br />WATER OPERATIONS
|