HomeMy WebLinkAbout06 Water Fund 2017
FY2017 Annual Budget
WATER FUND
San Jose Splash Pad
105
FY2017 Annual Budget
WATER FUND
Water Services Fund Summary................107
Water Admin &Water Services ...............110
Wastewater Services................................112
Reuse Irrigation ........................................114
Water Fund Five Year Projections ...........116
106
FY2017 Annual Budget
57%23%
12%8%
Operating Revenues
Water UtilityRev.
Wastewater Utility
Rev.
Capital Rec.Fee
Other Rev.
WATER SERVICES FUND SUMMARY
The Water Services Fund is used to account for the revenues generated from operating and maintenance activities
related to the Water,Wastewater,and Irrigation utilities.Each of these utility services is tracked separately within
this fund to ensure the rate and rate design will fully recover the cost of providing each service.The City operates
three water treatment plants and five wastewater treatment plants.The City’s water supply is 35%ground water
and 65%surface water.
Expenses include debt service payments,capital costs,and transfers out to the General Fund per the City’s return
on investment (ROI)policy.
FISCAL YEAR 2016
are projected to be $50,573,839,3.9%higher than the current budget.The higher than expected
revenue is primarily the result of higher than expected water and wastewater sales.
are projected to be $74,752,047,0.26%less than the current budget.Most Departments are
expected to finish the current fiscal year within budget.
is projected to be $24,955,155 as of September 30,2016.Fund balance over the policy required
contingency is available to fund non recurring expenditures
and is expected to be used to cash fund CIP projects in
FY2017.
FISCAL YEAR 2017
total $66,756,338.Overall,revenues are
projected to increase by 32%from FY2016.Base revenue
growth,of approximately 6%,is still expected as new
customers are added.An increase of 4.7%is applied to the
wastewater base rate of each customer class,equating to an
increase of $1.40 per month for residential customers.The
wastewater rate has not changed since 2007.Bond proceeds
for Capital Projects are also increasing.The chart to the right
identifies Water Services Fund revenues by source.
total $83,240,776,which represents an
increase of 11.5%over FY2016 projections.The increase is
primarily due to new CIP projects,as well as recommended
enhancements for FY2017.The $46.7 million in capital
projects includes replacing mains,reconstructing pump
stations,and wastewater treatment plant improvements.
Twenty million of the CIP will be funded through bond
proceeds,and the remainder will be funded with cash.
include $841,400 for a water
purchase contract with Round Rock and $434,000 for a
contract with the Brazos River Authority to provide for
additional connections and water services due to growth.
These purchases allow the City to defer water treatment plant expansion for up to five years.
New meters,additional wastewater collection odor control,and a vehicle for the West Side Service Center are also
included.
9%
52%
24%
15%
Operating Expenses
Transfers
Admin.
Distr.&Ops
Management
107
FY2017 Annual Budget
$44.04
$47.17
$35.60
$51.59
$53.62
$72.55
$50.27
$30.65
$$10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00 $80.00
KILLEEN
ROUND ROCK
TEMPLE
NEW BRAUNFELS
CEDAR PARK
SAN MARCOS
LEANDER
GEORGETOWN
Wastewater Total Customer Cost:
10,000 Gallons Residential
$745.52
$747.79
$904.00
$915.38
$746.43
$1,448.01
$747.52
$516.35
$$200.00 $400.00 $600.00 $800.00 $1,000.00 $1,200.00 $1,400.00 $1,600.00
KILLEEN
ROUND ROCK
TEMPLE
NEW BRAUNFELS
CEDAR PARK
SAN MARCOS
LEANDER
GEORGETOWN
Wastewater Total Customer Cost:
200,000 Gallons Commercial
108
FY2017 Annual Budget
WATER FUND INCOME STATEMENT
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Beginning Fund Balance 37,651,221 49,698,815 49,133,364 24,955,155 24,955,155
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Operating Revenue
Water Utility Revenue 23,223,605 22,500,000 25,100,000 26,700,000 26,700,000
Wastewater Utility Revenue 9,244,064 9,399,394 9,525,000 10,733,475 10,733,475
Capital Recovery Fee 5,924,452 5,945,574 5,081,780 5,367,300 5,367,300
Other Revenue 3,929,232 3,341,051 3,251,103 3,147,088 3,147,088
Irrigation Utility Revenue 249,625 204,428 225,000 225,000 225,000
Interest 145,889 119,232 194,978 199,975 199,975
Raw Water Revenue 175,255 140,000 170,000 178,500 178,500
Other
Transfer In,Debt 99,783 100,000 100,000
Transfer
Transfer In,GCP 3,566,436
Transfer In,Utilities 69,108 293,008 293,008
Total Operating Revenue 46,627,449 42,042,687 43,940,869 46,551,338 46,551,338
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Operating Expenditures
0000 Transfer 66,763 66,763 208,750 82,000 290,750
0000 Transfer Out,General 275,000 425,000 425,000
0000 Transfer Out,ISF 313,141 1,100,947 1,100,947
0000 Transfer Out,ROI 2,487,578 2,420,817 2,451,400 2,648,588 2,648,588
0000 Transfer Out,Utilities 2,279,506
0302 Rural Water Customer Care 4,833
0353 Rural Water Customer Care 301,884 113,850 104,900
0527 Water Administration 10,258,388 11,871,918 11,301,682 15,191,220 1,275,400 16,466,620
0528 Water Distribution 2,271,328 2,267,236 2,764,864 745,846 553,580 1,299,426
0529 Water Plant Management 2,097,431 2,632,741 2,645,508 2,379,631 2,379,631
0530 Wastewater Distribution 1,621,054 1,891,090 1,887,938 689,590 96,475 786,065
0531 Wastewater Plant Managem 2,311,689 2,733,106 2,747,161 2,430,507 2,430,507
0532 Irrigation 162,892 308,386 304,375 233,447 233,447
0549 Rural Water Admin 2,591,318 3,922,196 3,553,879
0550 Rural Water Operations 1,394,717 1,336,848 1,416,690
0551 Rural Water Technical Servic 92,174 158,642 136,125
0552 Rural Water Systems Engin e 452,347 192,700 308,750
0553 Water Operations 4,540,175 256,080 4,796,255
Total Operating Expenditures 28,915,280 31,442,240 31,215,981 29,067,754 2,263,535 31,331,289
FY2015
Actual
FY2016
Budget
FY2016
Projection
FY2017
Base
FY2017
Changes
FY2017
Budget
Available Operating Fund Balance 55,363,390 60,299,262 61,858,251 42,438,739 (2,263,535)40,175,204
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Non Operating Revenue
Bond Proceeds 9,217,156 6,000,000 6,000,000 20,000,000 20,000,000
Special Improvement Fees 705,428 642,373 632,970 205,000 205,000
Grand Total 9,922,584 6,642,373 6,632,970 20,205,000 20,205,000
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Non Operating Expenditures
CIP 90 11,589,210 41,223,500 39,230,500 46,727,000 46,727,000
CIP 91 171,366 71,000 71,000
Debt Service 4,845,575 4,635,034 4,234,566 5,182,487 5,182,487
Operations 34,513
Grand Total 16,640,664 45,929,534 43,536,066 51,909,487 51,909,487
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017
Base
FY2017
Changes
FY2017
Budget
Ending Fund Balance 48,645,311 21,012,101 24,955,155 10,734,252 (2,263,535)8,470,717
CAFR Adjustment 488,053
Contingency 7,325,000 4,565,000 4,565,000 5,000,000 5,000,000
Available Fund Balance 41,808,364 16,447,101 20,390,155 5,734,252 (2,263,535)3,470,717
109
FY2017 Annual Budget
WATER ADMINISTRATION & WATER SERVICES
MAJOR DEPARTMENT GOALS &STRATEGIES FOR FY2017
Meet Environmental Protection Agency (EPA)and Texas Commission on
Environmental Quality (TCEQ)standards for water service (pressure,flow,
and water quality)
Provide reliable and safe drinking water service by operating and
maintaining the water system in a cost efficient and safe manner
Commence operation of the Cedar Breaks and Rabbit Hill storage tanks
Negotiate BRA Alliance Water Contract to acquire water and negotiate
water treatment and transport agreement with Leander for future needs
Continue system leak detection program to further reduce water loss
Develop Water Treatment Plant Operator Training and Progression
Program and performance metrics
Notable Budget Item(s)
Wastewater Plant O&M
(8.5 FTE’s)
WATER FUND
WATER ADMINISTRATION
&WATER SERVICES 50.5 FTES
MAJOR DEPARTMENT ACCOMPLISHMENTS FOR FY2016
Met all regulatory standards for water service (pressure,flow,water
quality)
Provided reliable and safe drinking water service to 35,550 customers
encompassing a total population of 88,875 by operating and maintaining
the water system in a cost efficient and safe manner
Developed and implemented an improved water measurement process
and reporting for the water utility
Commenced operation of a new Daniels Mountain storage tank to
increase storage for system reliability
Completed the planning,preparation,and staffing associated with
bringing Water Operations in house
Relocated appropriate staff to the new Westside Service Center to
improve operational efficiencies
Entered into a service agreement with Round Rock for the treatment and
transport of water
Developed and refined operational performance metrics to improve
Department performance and system reliability
Completed 92 miles of system leak detection to reduce water loss
DEPARTMENT DESCRIPTION
The Water Administration and Water
Services Departments are
responsible for the operation and
maintenance of the infrastructure
that provides potable water for over
33,000 customers in a 450 square
mile area.The water infrastructure
includes 3 treatment plants,10
storage tanks,13 pumping stations,
888 miles water distribution piping,
7,143 valves,4,522 fire hydrants,
and meters.Department activities
are regulated by the Texas
Commission on Environmental
Quality (TCEQ),Public Utility
Commission (PUC),and the
Environmental Protection Agency
(EPA).
Notable Budget Item(s)
Round Rock Wholesale
Water Purchase
$841,000
Wastewater Distribution
Budget Increase
$125,975
110
FY2017 Annual Budget
DEPARTMENTAL BUDGET
DEPARTMENTAL PERFORMANCE MEASURES
Providing safe drinking water service to customers while maintaining the water system in a cost efficient and reliable
manner is a top priority for the Department.Several performance measures are in place to ensure these goals are
met.Water Service Quality (WSQ)is measured across the Average Service Availability Index (ASAI),System Average
Interruption Frequency Index (SAIFI),and the Customer Average Interruption Duration Index (CAIDI).These measures
calculate service/demand ratios,interruption frequency,and outage durations.The chart below is a graphical
representation of the metrics tracked by the Water Administration and Water Services Departments.
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017 Base
Budget
FY2017
Changes
FY2017
Budget
0527Water Administration
Personnel 86,292 109,655 89,806 91,668 91,668
O&M 10,172,095 11,762,263 11,211,876 15,337,039 445,825 15,782,864
Capital 841,400 841,400
0527 Water Administration Sub total 10,258,388 11,871,918 11,301,682 15,428,707 1,287,225 16,715,932
0528Water Distribution
Personnel 1,386,010 1,414,667 1,432,006
O&M 883,400 780,069 867,858 1,360,000 359,230 1,719,230
Capital 1,918 72,500 465,000 60,000 430,000 490,000
0528 Water Distribution Sub total 2,271,328 2,267,236 2,764,864 1,420,000 789,230 2,209,230
0529Water Plant Management
Personnel 402,951 44,460 604,858 604,858
O&M 2,097,431 2,142,290 2,526,048 1,699,773 1,699,773
Capital 87,500 75,000 75,000 75,000
0529 Water Plant Management Sub total 2,097,431 2,632,741 2,645,508 2,379,631 2,379,631
0553Water Operations
Personnel 3,425,206 3,425,206
O&M 274,193 14,080 288,273
Capital
0553 Water Operations Sub total 3,699,399 14,080 3,713,479
Total Departmental Budget 14,627,147 16,771,895 16,712,054 22,927,737 2,090,535 25,018,272
111
FY2017 Annual Budget
WASTEWATER SERVICES
MAJOR DEPARTMENT GOALS &STRATEGIES FOR FY2017
Meet all regulatory standards for wastewater service (discharge limits,
system integrity)
Provide reliable wastewater service to customers by operating and
maintaining the wastewater system in a cost efficient and safe manner.
Participate in industry conferences for technology advances and changes
in operations and maintenance practices
Implement Industrial Pretreatment Program when required by TCEQ.
Continue EARZ testing of the collection system to identify flaws in the
collection system piping
Develop plant operator training and progression program
Develop and implement performance metrics for plant operations to
improve compliance and efficiency
Notable Budget Item(s)
Wastewater Plant O&M
(8.5 FTE’s)
WATER FUND WASTWATER SERVICES 7 FTES
MAJOR DEPARTMENT ACCOMPLISHMENTS FOR FY2016
Met all regulatory standards for wastewater service (discharge limits,
system integrity)
Provided reliable wastewater service to 24,041 customers encompassing
a total population of 60,100 by operating and maintaining the wastewater
system in a cost efficient and safe manner
Completed the planning,preparation,and staffing to affect private to
public operation of wastewater plant operations with associated cost
savings
Participated in industry conferences (AWWA,TMUA)
New positions filled:1 Plant Operations Superintendent,Treatment Plant
Supervisor and 7 Plant Operators
Identified and located the source of mercury excursions creating non
compliance on the Dove Springs WWTP eliminating future violations and
fines
Westside Service Center completed and relocated a portion of
wastewater staff to provide a more efficient level of service to customers
Increased the license level and/or advanced 20 technicians using the
occupational training program and progression program
DEPARTMENT DESCRIPTION
The Wastewater Department is
responsible for the operation and
maintenance of the infrastructure
that provides wastewater for over
24,041 customers.The wastewater
infrastructure includes 5 treatment
plants,24 pumping stations,7,076
manholes,and 337 miles of
wastewater collection mains.This
Department’s activities are
regulated by the Texas Commission
on Environmental Quality (TCEQ)
and the Environmental Protection
Agency (EPA).
Notable Budget Item(s)
Increase in Operations
$91,000
112
FY2017 Annual Budget
DEPARTMENTAL BUDGET
DEPARTMENTAL PERFORMANCE MEASURES
The provision of reliable,safe wastewater service to customers while maintaining the system in a cost efficient and
reliable manner is a top priority for the Wastewater Services Department.Perfomance measures are in place to
monitor Operations and Maintenance (O&M),Systems,Project,Resource,and Financial metrics .Metrics for O&M
include on time service delivery,safety,training,and productivity.Systems metrics focus on reliability,availability,
output,and capacity for service provision.Project metrics are also in place to monitor infrastructure to ensure
continued service provision that is on schedule,within budget,and within allotted resources.Resource and Financial
metrics focus on pricing and risk management to ensure the Department is capable of providing debt coverage in the
form of return on investment.The image below is a graphical representation of monthly performance measures
monitored by the Department.
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017 Base
Budget
FY2017
Changes
FY2017
Budget
0530Wastewater Operations
Personnel 1,102,789 1,213,741 1,195,868
O&M 513,765 627,349 642,070 596,700 91,000 687,700
Capital 4,500 50,000 50,000 50,000 50,000
0530 Wastewater Operations Sub total 1,621,054 1,891,090 1,887,938 646,700 91,000 737,700
0531Wastewater Plant Management
Personnel 505,461 44,729 550,409 550,409
O&M 2,311,689 2,127,645 2,614,932 1,805,098 1,805,098
Capital 100,000 87,500 75,000 75,000
0531 Wastewater Plant Management Sub total 2,311,689 2,733,106 2,747,161 2,430,507 2,430,507
Total Departmental Budget 3,932,743 4,624,196 4,635,099 3,077,207 91,000 3,168,207
113
FY2017 Annual Budget
REUSE IRRIGATION
MAJOR DEPARTMENT GOALS &STRATEGIES FOR FY2017
Meet TCEQ standards for Reuse Irrigation service (water quality)
Provide reliable Reuse Irrigation service to customers by operating and
maintaining the irrigation system in a cost efficient and safe manner
Pecan Branch WWTP Expansion to increase reuse irrigation capability
Notable Budget Item(s)
Wastewater Plant O&M
(8.5 FTE’s)
WATER FUND REUSE IRRIGATION 0 FTE
MAJOR DEPARTMENT ACCOMPLISHMENTS FOR FY2016
Met TCEQ standards for Reuse Irrigation service (water quality)
Provided reliable Reuse Irrigation service to customers by operating and
maintaining the irrigation system in a cost efficient and safe manner
Relocated staff to the Westside Service Center to provide more efficient
service to reuse customers
Provided 85 million gallons to reuse customers which promotes water
conservation
DEPARTMENT DESCRIPTION
The Reuse/Irrigation Department is
responsible for the operation and
maintenance of infrastructure that
distributes reuse irrigation water to
five major irrigation customers.
Reuse Irrigation infrastructure
includes 2 storage tanks,4 pumping
stations,piping,and valves.The
Department activities are regulated
by the Texas Commission on
Environmental Quality (TCEQ)and
the Environmental Protection
Agency (EPA).
114
FY2017 Annual Budget
DEPARTMENTAL BUDGET
DEPARTMENTAL PERFORMANCE MEASURES
The City operates a reuse irrigation system that utilizes wastewater effluent to
provide water for irrigation.One of the goals for the irrigation department is to
maintain Type I effluent water that is safe for public contact 100%of the time.The
system currently provides effluent from four of its five wastewater treatment
plants to five golf courses in the Georgetown area.Effluent irrigation water is also
provided to Southwestern University’s athletic fields and the City’s parks.
FY2015
Actual
FY2016
Budget
FY2016
Projected
FY2017 Base
Budget
FY2017
Changes
FY2017
Budget
0532Irrigation
Personnel 76,079 74,811 75,875
O&M 86,813 233,575 228,500 205,472 205,472
Capital
Total Departmental Budget 162,892 308,386 304,375 205,472 205,472
115
FY2017 Annual Budget
WATER FUND FIVE-YEAR PROJECTIONS
Fiveyear Water Fund Assumptions:
Revenues in Water and Wastewater sales are expected to increase due to growing customer base in the
City and Western District
5year CIP project schedule is weighted toward the initial few years to help meet system capacity needs
Debt service payments are expected to increase over the next five years to pay for capital improvements in
the system
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Beginning Fund Balance 24,911,799 8,162,449 17,085,078 15,819,974 22,900,355
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Operating Revenue
Water Utility Revenue 26,700,000 27,234,000 27,778,680 28,334,254 28,900,939
Wastewater Utility Revenue 10,733,475 10,948,145 11,167,107 11,390,450 11,618,259
Capital Recovery Fee 5,367,300 5,474,646 5,584,139 5,695,822 5,809,738
Other Revenue 3,147,088 3,210,029 3,274,230 3,339,714 3,406,509
Irrigation Utility Revenue 225,000 229,500 234,090 238,772 243,547
Interest 199,975 203,975 208,054 212,215 216,459
Raw Water Revenue 178,500 182,070 185,711 189,426 193,214
Transfer In,Debt 115,839 118,156 120,519 122,929 125,388
Total Operating Revenue 46,667,177 47,600,520 48,552,530 49,523,581 50,514,053
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Operating Expenditures
0000 Transfer 290,750 296,565 302,496 308,546 314,717
0000 Transfer Out,General 425,000 425,000 425,000 425,000 425,000
0000 Transfer Out,ROI 2,604,339 2,656,426 2,709,554 2,763,745 2,819,020
0527 Water Administration 16,715,932 17,050,250 17,391,255 17,739,080 18,093,862
0528 Water Distribution 2,209,230 2,253,415 2,298,483 2,344,453 2,391,342
0529 Water Plant
Management 2,379,631 2,427,223 2,475,768 2,525,283 2,575,789
0530 Wastewater 737,700 752,454 767,503 782,853 798,510
0531 Wastewater Plant
Management 2,430,507 2,479,117 2,528,700 2,579,274 2,630,859
0532 Irrigation 205,472 209,581 213,773 218,049 222,410
0553 Water Operations 3,713,479 3,787,749 3,863,504 3,940,774 4,019,589
Total Operating Expenditures 31,712,040 32,337,781 32,976,036 33,627,057 34,291,098
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Available Operating Fund Balance 39,866,936 23,425,188 32,661,572 31,716,498 39,123,310
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Non Operating Revenue
Bond Proceeds 20,000,000 17,000,000 22,000,000 10,500,000 1,800,000
Special Improvement Fees 205,000 100,000
Total Non Operating Revenue 20,205,000 17,100,000 22,000,000 10,500,000 1,800,000
Row Labels FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Non Operating Expenditures
CIP Expense 46,727,000 17,000,000 31,500,000 10,500,000 1,800,000
Debt Service 5,182,487 6,440,110 7,341,598 8,816,143 9,393,286
Total Non Operating Expenditure 51,909,487 23,440,110 38,841,598 19,316,143 11,193,286
FY2017 Budget FY2018 Projected Budget FY2019 Projected Budget FY2020 Projected Budget FY2021 Projected Budget
Ending Fund Balance 8,162,449 17,085,078 15,819,974 22,900,355 29,730,024
Contingency 5,000,000 5,100,000 5,200,000 5,300,000 5,400,000
Available Fund Balance 3,162,449 11,985,078 10,619,974 17,600,355 24,330,024
116