|
Fiscal Year 2018 EXHIBIT A
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET
<br />2013 2014 2015 2016 2017 2017 2018
<br />OPERATING INCOME
<br />701-3710-0-0-00 WATER BILLINGS 875,788$ 869,372$ 891,132$ 911,902$ 981,030$ 982,649$ $1,037,742 5.5% blended rate increase
<br />701-3715-0-0-00 WATER ON/OFF FEES 510 735 450 525 550 550 550 No change in rate
<br />701-3717-0-0-00 PENALTIES WATER 4,553 5,300 5,650 5,500 5,876 6,592 6,526
<br />TOTAL 880,851$ 875,407$ 897,232$ 917,927$ 987,456$ 989,791$ $1,044,818
<br />DISTRIBUTION OPERATING EXPENDITURES
<br />701-4110-80-0000 WT REGULAR EMPLOYEE 282,686$ 284,852$ 286,793$ 298,315$ 315,278$ 308,500$ 326,847$ AD/PW PR
<br />701-4111-80-0000 WT OVERTIME EMPLOYEE 5,800 8,498 17,235 16,381 15,304 19,500 17,140 Dept summ-pw OT
<br />701-4115-80-0000 WT POST BENEFIT PAYOUT - - - 2,095 - - -
<br />701-4121-80-0000 WT PERA 20,915 30,195 23,514 23,433 24,794 24,794 25,799 7.50%
<br />701-4122-80-0000 WT FICA/MEDICARE 22,270 22,143 22,135 23,637 25,289 25,289 26,315 7.65%
<br />701-4131-80-0000 WT INSURANCE HEALTH 45,270 49,415 53,691 58,664 60,008 51,113 55,615 AD/PW see dept summ-HI lower due to Eastwood
<br />701-4135-80-0000 WT INSURANCE WC 2,504 6,510 9,712 11,559 11,479 9,895 3,000 Budgeted to match billing allocation
<br />701-4211-80-0000 WT OFFICE SUPPLIES 594 1,126 785 721 740 740 750 2016 actual plus 2%
<br />701-4212-80-0000 WT MOTOR FUELS (6,689) 8,562 5,834 4,152 5,017 4,767 5,770 based on average mileage and 15% increase in cost per gallon
<br />701-4221-80-0000 WT SUPPLIES-EQUIPMENT - - - 762 750 750 750
<br />701-4226-80-0000 WT GENERAL SUPPLIES 3,759 2,996 3,416 4,253 2,657 2,100 2,142 2016 actual plus 2%
<br />701-4300-80-0000 WT AUDITOR 7,676 7,750 6,167 7,350 7,650 7,691 7,250 BASED ON AUDITOR CONTRACT
<br />701-4309-80-0000 WT IT & SFTW SUPPORT 21,675 15,148 19,592 21,693 26,725 32,500 36,263 BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-80-0000 WT MISC CONTRACTED SERVICES 8,180 4,071 2,428 326 400 360 400 BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />701-4310-80-0100 WT METER READING FEES 1,438 3,206 5,017 7,500 7,500 7,500 7,725 2017-sensus fees/estimated annual billing
<br />701-4325-80-0000 WT COMMUNICATIONS 10,921 10,273 9,949 10,391 10,641 9,543 9,734 BASED ON COMMUNICATION SPREADSHEET
<br />701-4337-80-0000 WT MAIN REPAIRS & MAINTENANCE 19,068 7,127 24,925 1,104 11,500 4,500 11,500 no main breaks in 2017 ytd budgeted for 1 main break in 2018
<br />701-4339-80-0000 WT EQUIP REPAIRS & MAINTENANCE 25,993 12,428 9,760 5,039 10,465 6,250 6,500 MAJORITY MOVED PRODUCTION COSTS
<br />701-4340-80-0000 WT BLDG REPAIRS & MAINTENANCE 5,729 1,388 6,279 - 1,400 - - MOVED PRODUCTION COSTS
<br />701-4341-80-0000 WT TRAINING, CONF. & MTG.2,810 2,051 1,990 1,295 2,100 1,450 2,100 2017 average run rate
<br />701-4341-80-0100 WT TUITION- CERTIFICATIONS 653 114 500 371 450 450 450 Based on est renewal requirements
<br />701-4342-80-0000 WT MEMBERSHIPS & DUES 530 349 399 491 500 500 500 Based on est renewal requirements
<br />701-4350-80-0000 WT PRINTING AND POSTAGE 1,245 4,764 4,588 1,681 4,394 4,250 4,335 2016 actual plus 2%
<br />701-4365-80-0000 WT INSURANCE PROPERTY / LIABILILITY 43,631 25,782 13,855 12,414 - - - MOVED TO PRODUCTION
<br />701-4381-80-0000 WT ELECTRIC AND GAS UTILITIES 92,818 92,869 89,504 86,619 16,600 10,160 12,090 MAJORITY MOVED PRODUCTION COSTS
<br />TOTAL 619,477$ 601,617$ 618,069$ 600,246$ 561,641$ 532,602$ 562,975$
<br />WATER OPERATIONS
|