HomeMy WebLinkAboutII (D) Presentation: Water/ Wastewater Rate Study Report — F0 p, �l
Ll
CITY OF OCOEE
- WATER AND WASTEWATER RATE STUDY REPORT
— December 15, 2000
— Preliminary Draft Report
:12
:
-
Presented By
Burton & Associates, Inc.
Specialists In Water Resources Economics
City of Ocoee RPF�
Water and Wastewater Rate Study 9
Executive Summary
This executive summary presents the results of the water and wastewater rate study conducted
for the City by Burton & Associates. This executive summary is intended to present only the
summary results and we recommend that the report be read in its entirety for a thorough
understanding of the methodology and underlying analyses that support the results presented herein.
A. Objective and Scope
The objective and scope of this Study were to:
1. Conduct an evaluation of the sufficiency of the City's water and wastewater rates to
fully fund all operations, maintenance, renewal and replacement and capital costs of
the utility for a five year projection period,
2. Develop a reclaimed water rate program, and
3. Conduct an analysis of the City's water and wastewater rate structure to identify any
changes to:
a) Ensure fair and equitable recovery of the costs of service and
b) Provide incentives for water conservation in the context of the other water
conservation initiatives being undertaken by the City.
B. Study Procedures
In the conduct of the Study, we employed our automated interactive process to develop an
integrated solution, in concert with City staff, that fully evaluated all possible alternatives available
to the City. Through this interactive process, we were able to develop a recommended water,
wastewater and reclaimed water rate program that fully funds the requirements of the utilities over
the next five years, with minimal impact upon the rate payers.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study -i- Water Resources Economics
G Results OgN
,. The recommendations presented in the following section provide for a financial management
plan for the water, wastewater and reclaimed water utilities of the City that achieves the following:
1. Minimizes the impact of required water and wastewater rate increases by use of an
annual inflationary indexing rate adjustment plan,
2. Provides a rational reclaimed water rate program in recognition of the limitations of
market pricing realities,
3. Provides funding for the reclaimed water program, without the need for an up-front
capacity fee, and
4. Provides for water conservation incentives in the recommended adjustments to the
water rate structure by applying all annual water and wastewater rate adjustments to
only the usage rate portion of the rates.
D. Recommendations
.. In order to achieve the results presented in the prior section, we recommend the following:
1. Implement annual water and wastewater rate indexing adjustments to provide for a
3% annual increase in water and wastewater rate revenues. The first of such rate
indexing adjustments should take effect March 1, 2001 and subsequent indexing
adjustments should take effect on October 1, 2001 through October 1, 2005.
2. Implement the above referenced rate indexing adjustments by adjusting only the water
and wastewater usage rate by 6%per year. This will a)cause the average residential
rate payer's monthly water and wastewater bill to increase by approximately 3% per
month,b)will achieve the required 3%annual increase in water and wastewater rate
revenues and c) will provide a water conservation incentive by implementation of
annual increases in the water and wastewater usage charge, which over the five year
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study -ii- Water Resources Economics
DRAFT
rate plan, will shift a significant percentage of the rate impact from the fixed charge
to the usage charge.
Note: In light of all of the water conservation initiatives being implemented
by the City, namely the water conservation public relations program,
the reclaimed water program and this rate structure recommendation,
we believe that this rate structure recommendation, in combination
with the other two conservation initiatives, will provide incentives to
conserve potable water and would expect to see reductions in potable
water usage per equivalent dwelling unit within the City over the five
year projection period.
3. Connect only New (new construction) and Bulk (greater than 3"meters) reclaimed
water customers through Fiscal Year 2002, at which time Retrofit (existing
construction)reclaimed water customers can be connected. This will allow the above
recommended water and wastewater rate indexing adjustments to provide the level
of revenue generation required to fully fund all of the capital costs of the Retrofit
reclaimed water customers.
a
4. Implement reclaimed water rates with a fixed monthly charge based upon the meter
size with an allowed monthly reclaimed water usage amount and a rate per 1,000
gallons for all reclaimed water usage in excess of the monthly allowance. Specific
recommended reclaimed water rates are presented in Figure 1 of Appendix B to this
Report.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study -iii- Water Resources Economics
n r3
TABLE OF CONTENTS
Section Page
SECTION I. Introduction 1
A. Objective 1
B. Scope
1. Revenue Sufficiency Analysis Scope 1
2. Reclaimed Water Rates Scope 3
y 3. Rate Structure Analysis Scope 3
C. Study Procedures 4
1. Data Gathering and Compilation 4
2. Analysis and Evaluation 4
3. Interactive Work Sessions 5
4. Development of Conclusions/Recommendations 6
SECTION II. Revenue Sufficiency Analysis 7
.. A. Assumptions g
B. Proposed Financial Management Plan Results 10
1. Enterprise Fund 10
2. Capital Improvements Program 10
3. Financial Management Plan 10
4. Summary of Results 11
a. Rate Revenues 11
b. Operations and Maintenance Expenses 12
c. Capital Improvements Program 12
d. Debt Service 12
e. Unrestricted Fund Balances 12
f. Development Fee Fund Balances 12
g. Debt Service Coverage 13
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
ri.�� Lh_ t-11 c-7
a
TABLE OF CONTENTS
Section Page
SECTION III. Reclaimed Water Rates 14
A. Basis of the Analysis 14
B. Results 16
1. Overview 16
2. Summary of Assumptions 17
a. Retail - Retrofit 17
b. Retail - New 17
c. Bulk Users 17
3. Results 18
a. Summary of Results 18
b. Reclaimed Water Rate Structure
Recommendations 19
c. Supporting Schedules 20
4. Impact Upon Water and Wastewater Rates 20
5. Recommendations 21
SECTION IV. Rate Structure Analysis 23
EXHIBITS Exhibits Appendix A - Revenue Sufficiency Analysis
APPENDIX
Exhibits Appendix B - Reclaimed Water Rates Analysis
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-E2-
[RI if L
I. Introduction
_ This report presents the results of the Water and Wastewater Rate Study conducted by Burton
& Associates for The City of Ocoee. This section of the report presents the objective of the Study,
the scope of the work conducted and the Study procedures employed in the conduct of the Study.
A. Objective
The objective of this Study was to develop 1) an evaluation of the ability of the City's water
and wastewater utilities to provide sufficient revenue to cover all revenue requirements over a four
year forecast period, 2) proposed reclaimed water rates and 3) an analysis of the City's water and
wastewater rate structure.
B. Scope
1. Revenue Sufficiency Analysis Scope
The scope of the Revenue Sufficiency Analysis portion of the Study was to
develop a financial management plan for the water and wastewater system during a
four year forecast period. The results of this Study present a plan, or blueprint, that,
with annual updates, verifications and adjustments, will serve to guide the financial
management of the water and wastewater systems over the four years of the forecast
period.
This report presents the results of a four year revenue sufficiency analysis for
the water and wastewater systems which includes a four year financial management
plan. The four year financial management plan identifies the following.
O Revenue Sufficiency Analysis
V Annual revenue projections
✓ Annual operations and maintenance expense projections
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
l'
✓ Annual projections of other revenue requirements such as renewal and
_ replacement requirements, contributions to reserves, etc.
✓ Annual rate plan to provide sufficient revenues
❑ Capital Improvements Program
/ Project listing and prioritization by year
✓ Optimum funding source by project by year
❑ Borrowing Program
✓ Borrowing required (by source) to fund CEP projects not funded by
other sources
✓ Timing of borrowing(s) to provide required borrowed funds
✓ Annual debt service of borrowing(s)
❑ Cash Flow Reconciliation
✓ Total net income produced by year
✓ Total development fees produced by year
✓ Total restricted reserves required by year
✓ Use of funds for debt service, renewal and replacement, capital outlay,
etc. by year
_ ✓ Use of funds for capital projects funding,including revenues,reserves,
development fees and proceeds from borrowing
❑ Funds Analysis
✓ Spend down limits(minimum reserve requirements) by year
✓ Beginning and ending funds balance by fund by year
.. ✓ Use of funds for capital projects by project by year
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
_z_
r.�
U � 1U� Ljj J
2. Reclaimed Water Rates Scope
The scope of this Study included the development of reclaimed water rates,
consistent with the market for reclaimed water, that can be implemented on a City-
wide basis for identified classes of reclaimed water service. The scope also included
a determination of the range of impact,for specific implementation scenarios,in terms
of water and wastewater rate increases that will be required to 1) recover reclaimed
water costs that are not recoverable from the reclaimed water rates and 2)counteract
the potable water offset effect,or conservation effect,of potential revenue losses from
the substitution of reclaimed water usage for potable water usage because of the loss
of water and wastewater billing units.
The scope included the development of reclaimed water rates for the following
classes of reclaimed water customers:
• Retail - Retrofit - These are reclaimed water customers that are
currently City water customers and provision of' reclaimed water
service would require retrofitting reclaimed water transmission and
distribution lines in existing developments and neighborhoods.
• Retail- New - These are reclaimed water customers that connect to
the reclaimed water system as new homes or businesses. For these
customers, it is assumed that the reclaimed water distribution system
will be installed by the developer and contributed to the City.
_ • Bulk Users - These are reclaimed water customers that receive
reclaimed water on a bulk volume basis. These customers do not
require a distribution system to provide them service or they provide
their own distribution system behind the bulk meter through which the
City provides reclaimed water.
3. Rate Structure Analysis Scope
To be included in the Final Water and Wastewater Rate Study Report.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-3-
ti
C. Study Procedures
In order to complete this Study, we completed activities in four areas of work as follows:
I. Data Gathering and Compilation
In this area of work we obtained copies of all relevant data and information
including prior rate studies, historical and current financial statements and budgets,
the current rate ordinance(s), customer and billing information, the current capital
structure,capital improvement programs,existing and planned system configurations
and other information provided to us by City staff
2. Analysts and Evaluation
After obtaining the above referenced data and information, we met with
members of City staff to ensure that we understood all data and information obtained
and to gain a better understanding of management philosophies, goals and objectives
regarding the ongoing management of the water, wastewater and reclaimed water
systems.
We then 1) conducted an analysis of the sufficiency of the water and
wastewater system revenues over a four year projection period from FY 2001 through
FY 2004 and developed a four year financial management plan by using our
proprietary Funding Analysis and Management System(FAMS)model,2)conducted
an analysis of the reclaimed water system service delivery alternatives identified by
City staff and developed an analysis of the reclaimed water rates for each type of
reclaimed water service identified by using our proprietary reclaimed water financial
model, and 3) conducted an evaluation of the City's current water and wastewater
rate structure.
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
_4_
3. Interactive Work Sessions
We then conducted interactive work sessions with City staff. In these
interactive work sessions, we presented the results of our revenue sufficiency and
reclaimed water analyses and discussed in detail the assumptions and reconciliations
to the City's budget for each utility. We identified our initial revenue sufficiency
analysis, which conforms with the City's budget, as the Baseline Alternative. We
displayed the results of our analysis in graphical format with our revenue sufficiency
and reclaimed water rate models up and running.
In the revenue sufficiency analysis,the graphs displayed showed four year bar
charts for each of the following financial indicators simultaneously:
• Percent increase in rate revenue required in each year
• Annual debt service amount and debt service coverage provided in each year
• Balance of unrestricted reserves by year
• Borrowing requirement by year
• Total amount of capital improvement program by year
We demonstrated the impact of various changes in assumptions, capital
improvements program amounts and other parameters of the model in order to
identify, with City staff, the financial management plan included in this report.
In the reclaimed water analysis, we demonstrated the impact of various
changes in assumptions, customer subscription rates and other parameters of the
model in order to identify, with City stab, the most appropriate allocation of costs in
the development of reclaimed water rates for each identified class of reclaimed water
service.
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-5-
- L • j L
4. Development of Conclusions and Recommendations
Based upon the results of the analysis and interactive work sessions discussed
above,we developed the proposed Financial Management Plan, reclaimed water rates
and rate structure changes presented herein.
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-6-
Il
L;L
H. Revenue Sufficiency Analysis
This section presents the results of the revenue sufficiency analysis and financial management
program development portion of the Study.
As was described in Section I.C. - Study Procedures, we identified our initial analysis, which
conforms to the City's budget, as the Baseline Alternative. We presented the results of our revenue
sufficiency analyses in interactive work sessions with City staff and discussed in detail the assumptions
and reconciliations to the City's budget.
We displayed the results of our analysis in graphical format with our FAMS model up and
running. The graphs displayed showed four year bar charts for each of the following financial
indicators simultaneously:
Percent increase in rate revenue required in each year
• Annual debt service amount and debt service coverage provided in each year
• Balance of unrestricted reserves by year
• Borrowing requirement by year
• Total amount of capital improvement program by year
We demonstrated the impact of various changes in assumptions, capital improvements
program amounts and other parameters. After review of the Revenue Sufficiency analysis with City
staff it was determined that, under the assumptions presented in this report, no rate increases would
be necessary in order for the financial requirements of the water and wastewater system to be met in
each year of the forecast period.
The following subsection presents the assumptions used in the development of the financial
management plan and the subsequent subsection presents the results of the proposed financial
management plan.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-7-
A. Assumptions
The assumptions included in the development of the financial management plan are as follows:
• Growth:
• Growth in Rate Revenues - Growth in rate revenues was projected using
growth projections for water and wastewater from the City. These growth
projections ranged from a high in FY 2001 of 3.46%to a low of 3.14%in FY
2004 for water. Growth projections for wastewater ranged from a high of
7.55% in FY 2001 to a low of 6.15% in FY 2004.
• Growth in Development Fee Revenues-Growth in development fee revenues
was projected based upon the City's projected annual growth of400 ERCs for
both water and wastewater.
• Operations and maintenance cost escalation- Operations and maintenance expenses
for FY 2001 reflect the City's budgeted expenses. For the remainder of the forecast
period, operating expenses have been escalated by a 3% cost escalation factor and
25% of growth. This results in a range of cost escalation factors during the forecast
period of 3.87%in FY 2001 to 3.78%in FY 2004 for water, and 4.89% in FY 2001
to 4.54% in FY 2004 for wastewater.
• Minimum working capital balance in unrestricted reserves-An amount equal to three
(3)months of operations and maintenance expenses is reserved as a minimum working
capital balance.
• Investment interest earnings-Investment interest earnings were calculated on average
balances at 5.30% for FY 2001, 4.30% for FY 2002 through FY 2004.
• Capital projects funding- Water and wastewater development fee revenue was not
used in projecting the funding of capital projects. This is because the City currently
uses water and wastewater development fee revenues to pay the portion of the annual
debt service that resulted from the issuance of Revenue Bonds in 1993 and 1997.
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-8-
r ,
Therefore, the only"non-debt" source of funds available to fund capital projects is
unrestricted reserves, which were applied to unfunded project balances. Any project
balances unfunded after application of all available sources of funds would be included
in the borrowing requirements for each year. However, it was projected that no
borrowing would be required during the forecast period.
• Borrowing assumptions - Had any borrowing requirements been identified, the
resultant borrowing and annual debt service would be calculated based upon the
assumption of a 30 year term for revenue bonds at 6.0% interest; one year's debt
service for a debt service reserve fund; costs of issuance to include underwriters
discount at 1%of par amount, bond insurance at .25%of par amount and other costs
of issuance at .75%of par amount. If any borrowing were projected, it was assumed
to occur on October 1 in all years where it is required.
• Debt service coverage - There are four debt service coverage tests in the City's
outstanding bond covenants as follows:
Rate covenant:
• Net income must be equal to 1.00 times annual debt service,
and
• Net income plus development fees must be equal to 1.10 times
annual debt service.
Parity test -
• Net income must be equal to 1.00 times maximum annual debt
service(applies only in years when revenue bonds are issued),
and
• Net income plus development fees must be equal to 1.10 times
maximum annual debt service (applies only in years when
revenue bonds are issued).
The following subsections present the results of the revenue sufficiency analysis and the
proposed financial management plan.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-q-
1 � fi
B. Proposed Financial Management Plan Results
I. Enterprise Fund
The City of Ocoee's water and wastewater systems are considered as one enterprise fund in
the City's budget and accounting system and the combined revenues of both the water and
wastewater systems are pledged revenues for the City's outstanding water and wastewater revenue
bonds.
2. Capital Improvements Program
The four year capital improvements program (CIP) that was used in the development of all
of the financial management plan scenarios is presented in Figure 3 in the Exhibits Appendix of this
Report. Figure 3 presents the water and wastewater utility capital improvements program. The
proposed financial management plan presented herein provides sufficient funds to finance this CIP
in all years of the four year forecast period.
3. Financial Management Plan
The proposed financial management plan will not require any rate increases during the four
year forecast period, (FY 2001 -FY 2004), in order for the water and wastewater utility to meet all
a necessary financial requirements during the forecast period.
The results of the revenue sufficiency analysis and financial management plan development
are presented in the graphs and schedules in the Exhibits Appendix at the end of this Report. The first
exhibit , Figure 1, presents the control panel used in the interactive workshops with City staff. This
figure shows graphical representations of the CIP,the percentage rate revenue increases required(in
this case no rate increases are required), the annual debt service and debt service coverage, annual
borrowing required, and the end-of—year unrestricted fund balances(working capital reserve funds).
Figure 2-A presents the Financial Results of Operations with Computation of Debt Service
Coverage for each year of the forecast period. Figure 2-A demonstrates that the rate plan will
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-10-
L
provide sufficient revenue to pay all operations and maintenance expenses and will provide adequate
debt service coverage in all years of the forecast period. Figure 2-A also demonstrates that the rate
plan will generate sufficient cash to not only pay all operations and maintenance expenses and provide
adequate debt service coverage,but also will pay all minor capital outlay expenses and other"below
the line" expenses.
Figure 2-B presents the Sources and Uses of Funds which demonstrates that the rate plan will
provide sufficient resources to fund the CIP projects in all years of the forecast period.
Figure 2-C presents Changes in Account Balances during the forecast period. This figure
shows the fund activity and beginning and end of year fund balances in all funds for each year of the
forecast period.
Figure 4 presents the Annual Project Funding Summary during the forecast period. This
figure provides a detailed listing of water and wastewater capital projects, as provided in the City's
CIP,and the most effective means by which each project can be funded. The Annual Project Funding
Summary lists sources of funds available to pay for capital projects, i.e. water development fees,
wastewater developments fees, 1997 Revenue Bond proceeds and the Operating Fund revenue. It
then shows the how each project in the CIP was projected to be funded within the financial
' management plan presented in this Report.
4. Summary of Results
a. Rate Revenues
Combined water and wastewater rate revenues for FY 2001 are estimated to
be$4,085,000. These rate revenues are projected to increase by the assumed growth
rate for each year in the forecast period resulting in projected combined water and
wastewater rate revenues of$4,721,000 in FY 2004, the last year of the forecast
period. No rate increases will be required during the period.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-11-
- I -'� r Fri LJ
2 _
b. Operations and Maintenance Expenses
Combined water and wastewater operations and maintenance expenses for FY
2001 are estimated to be$3,302,000.These O&M expenses are projected to increase
by the cost escalation factor of 3%and 25%of the assumed growth rate for each year
in the forecast period. This results in projected O&M expenses of$3,723,000 in FY
2004, the last year of the forecast period.
c. Capital Improvements Program
' The proposed financial management plan will fund approximately $984,000
of water projects and $2,715,000 of wastewater projects for a total of$3,699,000
during the four year forecast period, FY 2001 through FY 2004. All capital projects
funding during the forecast period are funded with reserves and current revenues.
d. Debt Service
The City's current water and wastewater annual debt service ranges from a
low during the forecast period of approximately $1,342,000 in FY 2002 to a high of
approximately $1,347,000 in FY 2004. Debt service remains basically unchanged
during the forecast period because no additional debt is incurred to fund capital
projects during the forecast period.
e. Unrestricted Fund Balances
Need to update per September 30, 2000 CAFR.
f Development Fee Fund Balances
Need to update per September 30,2000 CAFR.
The City of Ocoee Burton B Associates
Water and Wastewater Rate Study Water Resources Economics
_12_
rL r�
g. Debt Service Coverage
Debt service by net income during the four year forecast period ranges from
a high of 1.29 in FY 2004 to a low of 1.13 in FY 2001. Debt service coverage by net
income+ development fees during the forecast period ranges from a high of 2.23 in
FY 2004 to a low of 2.08 in FY 2001. There is no parity test coverage during the
forecast period due to the fact that no additional debt is projected to be issued during
the forecast period.
a
a
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-13-
III. Reclaimed Water Rates
This section presents the results of the revenue sufficiency analysis and financial management
program development portion of the Study.
A. Basis of the Analysis
In order to develop fair and equitable reclaimed water rates it is first necessary to determine
the cost of providing reclaimed water service for each identified class of service. To the extent that
the cost to provide service is greater than the market rate that is feasible relative to alternative sources
of irrigation water available to potential reclaimed water customers,the rate must be set at the market
rate and the excess costs to provide the service must be absorbed in the water and/or wastewater
rates. To the extent that the cost to provide service is less than the market rate, the rate should be
set at the cost to provide the service.
In order to determine the cost of providing reclaimed water service to the classes of service
identified, it was first necessary to establish a baseline class of service to use as the basis for
determining the total cost to provide reclaimed water on an equivalent residential unit (ERU)basis.
_ The Retail-New class of service was identified as the baseline class of service. It was determined
that the cost to provide service to both the Retail-Retrofit and the Retail-New classes differ only
by the cost of the distribution system, which is contributed by the developer for a Retail - New
customer and would be incurred as an additional cost to the Retail- Retrofit customer. Therefore,
to the extent that the market would allow, the monthly rates for the Retail-Retrofit class would be
greater than the monthly rates for the Retail-New class in order to reflect the additional cost of the
distribution system for the Retail-Retrofit class. In the event that the market rate would not recover
any portion of the distribution costs for the Retail - Retrofit class, those costs would need to be
recovered through some other means, most likely an increase in the water and wastewater rates.
a In order to arrive at the rates presented in this report, an analysis of the cost to serve each
identified class of service was performed with City staff and any appropriate adjustments were made
a in order to reflect the appropriate cost to provide service to each class of service.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-14-
L
In order to calculate the cost of providing reclaimed water service on an EAU basis it was
necessary to establish a prototypical service area for which cost estimates could be made for the
various functional components of reclaimed water cost. We worked with City staff to determine the
impact of various levels of buildout of the reclaimed water system in order to arrive at a proposed
implementation program that would provide reclaimed water service to the most customers while
a minimizing the impact to the water and sewer rates.
Due to the nature of the analysis required and the limited data currently available with respect
to estimated operations and maintenance(O&M) and capital costs for the reclaimed water system,
Burton&Associates provided industry standards for O&M and capital costs where that data was not
readily available. These industry standard costs were applied on a cost per ERU basis to the proposed
implementation program to determine the total cost of the proposed implementation program.
The total cost to provide reclaimed water service on an ERU basis was calculated as described
a above for each class of service identified, with the cost of Bulk service being expressed as a rate per
1,000 gallons. These costs per ERU were then compared to the market rate per EAU for reclaimed
water. The market rate was established as being equal to approximately 75% of the cost per ERU,
at current City water rates, of the potable water that the average customer uses now for irrigation.
The average amount of potable water per ERU now used for irrigation was estimated based upon an
analysis of the water usage profiles of the City's current reclaimed water customers (who are
presently using potable water). This was done by identifying all reclaimed water customers and
performing a usage analysis upon their most current 12 month consumption history. It was
determined through our discussions with City staff regarding this analysis that, for the purposes of
this reclaimed water analysis, the average reclaimed water user's consumption was estimated to be
20,000 gallons per month, with consumption beginning at 10,000 gallons per month. This average
usage per customer was considered to be the standard irrigation usage per ERU.This irrigation usage
per ERU was also used to convert the costs calculated on an ERU basis to a rate per 1,000 gallons
of usage for Bulk customers.
a
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-15-
Ll
B. Results
This section presents the results of the Study. The first subsection presents an overview
discussion of a reclaimed water program and the financial dynamics between the reclaimed water
program and the water and wastewater rates. The next subsections present a summary of
assumptions, the results of the study, the recommended reclaimed water rates for each reclaimed
water class of service identified,and a recommended implementation program for the reclaimed water
system.
1. Overview
In the evaluation of a reclaimed water program it is important to understand
' that reclaimed water rates will be dictated by market pricing forces rather than the
cost to provide the service. This is because potential reclaimed water customers have
alternatives for irrigation, the most readily available of which is potable water.
Therefore, the price of reclaimed water must be no more than the cost of potable
water now used for irrigation or the customer will probably choose to continue to
irrigate with potable water. Our experience has been that in order for a reclaimed
water rate to compete with potable water as an alternative for irrigation it must be set
at a rate equivalent to from 50%to 75% of the cost of potable water currently used
for irrigation. If the cost to provide reclaimed water is more than the revenue that will
be derived from setting the rates at the determined percentage of the potable water
cost for irrigation, the unrecovered costs must be allocated to the water and/or sewer
rates and may require an increase in water and/or sewer rates to cover these costs.
Also,when reclaimed water is substituted for potable water for irrigation,the
City will lose billing units for water and, if the water rate is not increased, it will lose
water revenue. To the extent that the existing water rate structure inclines in the
usage range where it is estimated that reclaimed water usage would happen, the
"substitution" effect described above would be exacerbated. This phenomenon is
a typically referred to as the potable water offset effect. Reclaimed water substitution
for potable water usage for irrigation also effects wastewater revenue if there is no
cap, or a high cap, on residential wastewater billings. The City caps residential
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-16-
- • L2
wastewater billings at 12,000 gallons per month, therefore, there will be some loss of
wastewater billing units (from 10,000 to 12,000) in addition to the loss of water
billing units caused by the potable water offset effect, or substitution effect. In order
to maintain the current level of water and wastewater revenues after the
implementation of a reclaimed water program,water and wastewater rates may have
to be increased to counteract this potable water offset effect.
2. Summary of Assumptions
We developed recommended reclaimed water rates for the following classes
of reclaimed water service:
a. Retail-Retrofit-These are reclaimed water customers that are currently City
water customers and provision of reclaimed water service would require
retrofitting reclaimed water transmission and distribution lines in existing
developments and neighborhoods.
_ b. Retail - New - These are reclaimed water customers that connect to the
reclaimed water system as new homes or businesses. For these customers, it
is assumed that the reclaimed water distribution system will be installed by the
developer and contributed to the City.
c. Bulk Users - These are reclaimed water customers that receive reclaimed
water on a bulk volume basis. These customers do not require a distribution
system to provide them service or they provide their own distribution system
behind the bulk meter through which the City provides reclaimed water.
Major assumptions included in the development of the reclaimed water rates
presented herein are as follows:
• Grants-It is assumed that no grants will be received for any portion
of the estimated reclaimed water costs.
• Funding of capital costs - All capital costs will be funded by the
issuance of revenue bonds and the annual debt service of those bonds
is included as an annual reclaimed water cost.
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-17-
• Rates-Reclaimed water rates will be set at a level equal to the lessor
of cost or 75% of the current cost of potable water per ERU in the
range in which irrigation normally occurs.
• Rate structure-The reclaimed water rates are assumed not to include
an availability charge to all customers to whom the service is available
whether they connect or not. Such an availability charge could be
included in the rate structure, however, it was not included in this
analysis in order to present as conservative an analysis of reclaimed
water revenues as possible.
• Reclaimed water costs in excess of reclaimed water revenue-Where
reclaimed water costs exceed reclaimed water revenue, the
unrecovered reclaimed water costs will be allocated to the water and
wastewater rates in proportion to each systems revenue as a percent
of combined water and wastewater rate revenue.
• Potable water offset - It is assumed that the water and wastewater
revenue losses that would occur due to the loss of billing units caused
by the substitution of reclaimed water for potable water for irrigation
will be countered with increases in the water and wastewater rates in
order to remain revenue neutral.
3. Results
This section presents the recommended reclaimed water rates as unit charges
per ERU and per 1,000 gallons. However, in order to implement reclaimed water
rates, a specific rate structure must be adopted. Such rate structures typically include
a fixed charge per month and a usage charge per 1,000 gallons. Therefore, a specific
recommended rate structure with specific rates for each rate component for each class
of service is presented in Section II.C.2 Rate Structure Recommendations.
a. Summary of Results
Figure 2 presents the calculation of the cost of providing reclaimed
water to each identified class of customer. Figure 2 shows that the cost to
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-18-
Li ll•
provide reclaimed water service for the Retail - Retrofit class is $33.43 per
ERU, or $1.67 per 1,000 gallons, and the cost to provide reclaimed water
service for the Retail-New class of service is $11.98 per ERU, or$0.60 per
1,000 gallons. The cost to provide service to both the Retail-Retrofit class
of service and the Retail-New class of service, $33.43 per ERU and $11.98
•- per ERU respectively, are greater than the market rate of$7.65 per ERU,
which represents 75%of the current cost per ERU of potable water used for
irrigation. Therefore, the recommended rate for the Retail class of service is
the market rate of$7.65 per ERU, or$0.38 per 1,000 gallons. Rate structure
recommendations are presented in Figure 1.
Figure 2 shows that the cost to provide Bulk reclaimed water service
is $0.40 per 1,000 gallons, and that the market rate for Bulk reclaimed water
service is $0.38 per 1,000 gallons.
b. Reclaimed Water Rate Structure Recommendations
Recommended reclaimed water rates per ERU and per 1,000 gallons
of usage were presented in the previous section. However, in order to
implement a reclaimed water rate program, a specific rate structure must be
adopted_ The alternatives for reclaimed water rate structures range from a
fixed charge per month per ERU for unlimited reclaimed water usage to a rate
per 1,000 gallons for all reclaimed water usage.
In order to provide fiscal security relative to the City's reclaimed
water rate revenues and a predictable, yet controllable cost for the City's
reclaimed water customers, we recommend a rate structure that combines
elements of both of the above approaches for Retail-Retrofit, Retail-New
and Bulk reclaimed water customers. We recommend adoption of I) a fixed
monthly charge for the Retail - Retrofit, Retail - New and Bulk customer
.. classes equal to the recommended monthly rate per ERU, based upon meter
size equivalencies, with a monthly usage allowance of 12,000 gallons of
reclaimed water for a 5/8"x 3/4" meter, and a proportionately similar type of
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-19-
i '
usage allowance adjusted to reflect the increased flow capability of larger
meter sizes, and 2)a rate per 1,000 gallons of usage above the monthly usage
allowance, based upon meter size equivalencies, equal to the recommended
rate per 1,000 gallons.
Based upon these rate structure recommendations, we recommend
adoption of the reclaimed water rate schedules presented in Figure 1.
c. Supporting Schedules
This subsection presents the schedules which contain the analyses that
support the results presented in the previous subsection. The schedules
included are as follows:
Figure 1 - Proposed Reclaimed Water Presents a schedule of proposed reclaimed water rates and
Rates and Rate Structure rate structure by customer class and by meter size.
Figure 2- Rate Computations Presents a summary of the computation of the cost per
ERU for all classes of service and the recommended rates
for each class of service
Figure 3- Units Analysis Presents the estimated reclaimed water customers and
ERUs for the prototypical service areas used in the
computation of City-wide reclaimed water rates
4. Impact Upon Water and Wastewater Rates
In order for a reclaimed water system to be viable, any costs not recovered through the
reclaimed water revenue must be recovered through some other means,usually the water and
wastewater system. Therefore,a logical issue that arises in consideration ofa reclaimed water
system is the impact upon the water and wastewater rates. As discussed in prior sections of
this report, there are two components to the impact upon the water and wastewater rates.
The first component is net income(loss) generated by the reclaimed water system. To the
extent that it costs more to provide reclaimed water than can be generated through the
market-based rates necessary for reclaimed water,a net loss will occur in the reclaimed water
The City of Ocoee Burton &Associates
Water and Wastewater Rate Study Water Resources Economics
-20-
DRAFT
system. This net loss must be allocated to the water and wastewater revenue and to the
extent that there is not enough water and wastewater revenue available to make up this net
loss, it must be recovered through an increase to the water and wastewater rates.
The second component to the impact upon the water and wastewater rates is the potable
offset effect, or"substitution" effect, of current water and wastewater customers switching
from potable water to reclaimed water. As outlined in prior sections,the reclaimed water rate
must be less than the potable water rate in order for customers to have an incentive to use
reclaimed water. If the same usage occurs, but at a lower rate, revenue that is lost from the
water system will not be recovered completely from the reclaimed water system. Therefore,
this potable offset effect must be recovered through the water and wastewater revenues and
an increase to the water and wastewater rates will likely be necessary.
a
In order to minimize increases while maximizing the number of customers for which
reclaimed water can be made available, a rational implementation plan must be developed.
The section below outlines a plan that should accomplish both of these goals. Under the
assumptions developed in our worksessions with City staff, the plan presented should allow
the City to provide reclaimed water to as many customers as is economically feasible and at
the same time minimize the impact to the water and wastewater rates.
5. Recommendations
In order to maximize the number of customers that will receive reclaimed water service
_ while minimizing the impact to the current water and wastewater rates, a rational
implementation plan must be developed for the reclaimed water system. The following are
recommendations with respect to the implementation of the reclaimed water system.
1. Begin annual indexing, or rate increases, to apply to the City's water and
_ wastewater rates and charges,including impact fees,beginning March 1,2001
and on October 1, 2002 through 2005. A common annual indexing factor,
which we recommend,is 3%,which provides the water and wastewater utility
some protection against inflationary pressures.It is also recommended that the
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
_21_
DRAFT
City apply the same annual indexing to the reclaimed water rates and charges
so as to maintain a steady relationship between potable water and reclaimed
water rates.
2. Connect only Retail -New and Bulk customers during the first 2 years of the
reclaimed water program. In order for the reclaimed water system to become
a viable utility, customer classes that require much more expense than the
revenue they generate,as does the Retail-Retrofit class, must be limited until
the water and wastewater utility has more ability,through the annual indexing
recommended in item 1, to absorb unrecovered costs associated with the
connection of Retail - Retrofit customers, which is projected to occur after
approximately 2 years.
3. Implement reclaimed water rates in accordance with the rate structure
recommendations presented in Figure 1 of the Exhibits Appendix B -
Reclaimed Water Rates Analysis.
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-22-
I
IV. Rate Structure Analysis
The City of Ocoee Burton 8 Associates
Water and Wastewater Rate Study Water Resources Economics
-23-
LJ LLA L' Li
Exhibits Appendix A - Revenue Sufficiency Analysis
This page will be replaced by Figure 1, a printout of the Control Panel
of the Revenue Sufficiency Rate Model, in the next Draft of this Report.
FIGURE 2-A
City of Ocoee, Florida
WAI ER&SLH LKSYSI CM
Financial Results of Operations I
with Computation of Debt Service Coverage
IN ACCORDArya Mfli BOND COVENANTS
2001 2002 2003 2004
a UP DT 01-BASELINE PROJECTED PROJECTED PROJECTED PROJECTED
1 A,OSMFUN0
2 RATE REVENUES BEFORE RATE INCREASE 54085,000 $4297000 $4509.000 $4,121,000
3 RATE INCREASE -
_ - -
4 ANNUALIZED REVENUE R PROVIDEDEINCEASE IN EFFECT
0 0._ -
5 PERCENTAGE OF YEAR ESP PROVIDED
RATE 100.00% f00.00% 100.0 100.00%_
6 CURRENT TALYREN RATE REVENU BY RATE INCREASE - .__ - _
7 TOH OPCUERENT ATING
YEAR EN RATE REVENUES $$345000 $4346,000 $$346,000 $$346000
8 _ OTHER OPERA INGREENUES ,431,000 _ 646000 _ ,8855,000 _ ,067,000
9 TOTALREST ATING REVENUES $4431000 $$351,000 $$374,000 g$36Tp00
'� 11 TOTAL T RE INCOMEES $824 000 p91 000 $229.000 S466 50000
12 PTEG REVENUE ACCOUNT $3,302,000 $3.439,000 $3579.000 83,723,000
12 OPERATING $3,3021.$$ 000 $3555,000 $$35T9000 5374J000
14 NEAR S g1,B 17dp $153S,OIp $1�30,b00 g15d0,000
14 15,SEWER DEVELOPMENT FEES
a
15 BOND SERVICE COMPONENT $867,000 $867,000 8868.000 8870,000
16 C WATEREEVICE COMPONENT
NT FEES
17 BOND SERVICE $407,000 $400,000 $396,000 $393,000
18 0 9 CNVE/R$R
19 NO COVERAGE TRANSACTIONS .... ...- _
20 PLEDGED REVENUES FOR COVERAGE CALCULATION 52,797,00000 52.522.000 52,914,000 S3,003,000
21
22 CALCULATION OF DEBT SERVICE COVERAGE:
23 RATE_EOVENANT WITH DEVELOPMENTCHARGES The rate covenantdebt service coverage fest must be met In every veer
+ 24 PLEDGED REVENUES FOR COVERAGE,RESTATED 52797,000 52822,000 $2914,000 $3003,000
25 DIVIDED BY:CURRENT ANNUAL DEBT SERVICE REQUIREMENT 81 343 000 51 342 000 $1,345 000 $1347000
26 COVERAGE RATIO 2.08 2.10 2.17 2.23
27 COVERAGE REQUIRED 1.10 1.10 1.10 1.10
28
4 29 RATE COVENANT_WITHOUT DEVELOPMENT CHARGES II1olateCovenant debtserlte 909E9Ege_(es(must be met in every veal
30 PLEDGED REVENUES FOR COVERAGE,RESTATED $2,797,000 $28220f10 $2914,000 $3,003,003
31 LESS:BOND SERVICE COMPONENT.DEVELOPMENT CHARGES ($1,2I4000) . __($1,267,000) (81,264000) ($1,263,000)
32 PLEDGED REVENUES FOR COVERAGE(NET OF 0EV CHARGES) $1,523,000 51555.000 $1550.000 81.740,000
33 DIVIDED BY.CURRENT ANNUAL DEBT SERVICE REQUIREMENT $1 343,000 $1 342 000 $1,345000 $1,347 000
34 COVERAGE RATIO 1.13 1.16 1.23 1.29
35 COVERAGE REQUIRED 1.00 1.00 1.00 1.00
36
37
a 38 OTHER SOURCES AND USES OF FUNDS NOT INCLUDED IN COVERAGE TEST CALCULATIONS:
39 REVENUE FUND
40 OPERATING TRANSFERS AND OTHER INTERFUND TRANSACTIONS: ($66300)) ($693,000) ($723,000) ($755,000)
41 DEBT SERVICE AND RELATED -- __ __
42 DEBT SERVICE RESERVE FUND PROCEEDS --- ---- --
a - 43 CAPITAL OUTLAY ($100,000) (5149,000) ($110,000) (5134000)
44 CIP FUNDED WITH CASH _ _ _. •... ($465,000) ($200,000)
45 TOTALTH REVENUE NAN NT (ST6],OW) ($842,Ob) (g1,298,000) ($1089,000)
46 OTHER CAPITALPORTFINANCINGION
TRANSADEVELOPMENT
FE
47 UNPLECGED PORTION OF DEVELOPMENT FEES $417,000 $409,000 $426 D•J3 5443,003
4.
48 UNPLEDGED PORTION OF WATER DEVELOPMENT FEES ... _... - _
INTEREST NTEREST ON EXISTING BOND FUNDS $242,000 5191000 $165,000 $150.000
50 CAPITAL PROJECTS FUNDED FROM RBR FUND (51,349,000) (5650,000) ($885,000) ($150,000)
51 CAPITAL PROJECTS FUNDED WITH WATER DEVELOPMENT FEES ---- -_. __ _
a52 WATER DEVELOPMENT FEES USED TO PAY DEBT SERVICE 18476000) ($475000) (5977.000) ($427,000)
53 CAPITAL PROJECTS FUNDED WITH SEWER DEVELOPMENT FEES -00 --. __
-
54 SEWER DEVELOPMENT FEES USED TO PAY DEBT SERVICE ($867,000) (5867,000) ($868,000) ($870,000)
55 BOND PROCEEDS DEPOSITED TO CONSTRUCTION FUND ---• .... .... ___
56 INTEREST ON CONSTRUCTION FUNDS _ ____
a 57 PROCEEDS OF INTERIM FINANCING __ ._ _
58 CAPITAL PROJECTS FUNDED WITH BOND PROCEEDS AND INTEREST .... .... __ _-
59 TOTAL OTHER CAPITAL FINANCING TRANSACTIONS (82 033 000) S1.392,0001 ($1,639,000) 3904,00)
60 NET OTHER SOURCES AND USES OF FUNDS 152,796,000) (5000) ($ 000) (51,993,000)
61 _ NET REVENUES AND PLEDGED DEV.FEES,RESTATED $2,T ,000 $2,822,000 $2,914,000($20 $3,003,9W
62 TOTAL SOURCES VER( NDER)USES OF FUNDS,CURRENT YEAR $1,000 $688,000 ($23,000) $1,010,000
63 TOTAL BEGINNING BALANCES $12,167,000 812.166,000 $12,756,000 512,733,000
64 TOTAL ENDING BGLANCE9 --- 512068,000 512,756,000 512,733,000 513,743,000
SOURCE:BURTON 5 ASSOCIATES 12/14/2000
FIGURE 2-
Cily ofOcoee, Florida
WATER 3 388.343 MISrFNI
Sources and Uses of Funds
2001 2002 2003 2004
UPDT 01 -BASELINE PROJECTED PROJECTED PROJECTED PROJECTED
a 1 SOURCES OF FUNDS:
2 A.O&M FUND
3 RATE REVENUES BEFORE RATE INCREASE $4,085,000 $4297,0 0 $4,509,000 $4,721,000
4 CURRENT YEAR REVENUES PROVIDED BY RATE INCREASE ---
5 TOTAL CURRENT YEAR RATE REVENUES $4,085,000 - 54297.000 $4,509,000 $4721000
6 OTHER OPERATING REVENUES $346000 S346.000 $346.000 $346,000
7 TOTALROPERATINGINOME:REVENUES $$394,000 $351,000 f$374.000 - g 5396,000
9 INTEREST
LFRO REVS j825,000 5994,000 $229.000 5463,000
9 TOTAL ACCOUNT g4825,W0 P994,000 $5,229,000 $5,46J,000
10 B.SEWER DEVELOPMENT FEES
• 12 INTERESTSEWRE DEVELOPMENTARINGSFEES $1,146,000 $S130,003 $1,146,000 $1167,000
12 EARNINGS $ll8000 - f276,000 $294,000 $313.000
14 RTOTALEFROMPMEIT PLANT CAPACITY FEES ACCOUNT f1,284000 $t 2T6,000 $1294,000 f1813,LW
14 C.WATER DEVELOPMENT FEES
15 ._. -_ .... -
' 16 TRANSFER FROM REVENUE ACCOUNT $386,000 5386.000 $386,000 $386,000
17 INTEREST EARNINGS _ $21,000 $14,000 $10,000 $7,000
18 TOTAL FROM WATER PLANT CAPACITY FEES ACCOUNT $407,000 S400000 $396,000 $393,003
19 D.97 BONDS/R&R
,a 20 TRANSFER IN FROM OPERATING FUND $$92000 $1`50,000 4150,000 $150.000
$9200 21 INTEREST INCOME 0 $41000 815,000 _ -
22 TOTAL FROM 97 SALES TAX ACCOUNT $242,000 $191,000 $165,000 $150.000
23 BOND FUNDS
24 DEBT SERVICE RESERVE FUND PROCEEDS ---- --- .... ___
a 25 BOND PROCEEDS DEPOSITED TO CONSTRUCTION FUND ---- - _.. .._
26 INTEREST ON CONSTRUCTION FUNDS --- ---- __ _
27 TOTAL BONG PROCEEDS AND INTEREST TOTAL BON ---- --- - -
28 TOTAL SOURCES OF FUNDS $6,758,000 $8,881,000 $7,080,000 $7,319,000
29
' 30 USESQEF_UNDS:
31 A.4&MfU D
32 OPERATING EXPENSES $3,302,000 $3,439,000 $3.579,000 $3.723.000
33 OPERATING TRANSFERS AND OTHER INTERFUNO TRANSACTION $663,000 5693000 $723000 $755,000
34 DEBT SERVICE AND RELATED ---- -- ._. _
35 CAPITAL OUTLAY $100,000 5149,000 $110,000 $134,000
36 CIP FUNDED WITH CASH ---- _ --- $465,000 $200,000
37 TOTAL FRO $4,065,000 $4281.000 $4877.000 34812,00
38 B.SEWER DEVELOPMENT FEES
a. 39 CAPITAL EXPENDITURES --- ----
40 DEBT SERVICE $867000 $867,000 $868,000 $870,000
41 C.WATER DEVELOPMENT FEES
42 CAPITAL EXPENDITURES - .... --
43 DEBT SERVICE $476.000 5475,000 $477,000 $477000
' 44 D.97 BONOWR&R
45 CAPITAL EXPENDITURES $1,349,000 $ 50,000 $885.000 $150,000
46 CAPITAL PROJECTS FUNDED WITH BOND PROCEEDS AND INTEREST ---- ---. - -
47 TOTAL USES OF FUNDS $6,757,000 $8,273,000 $7,107,000 $6,309,000
48
' 49 TOTAL SOURCES OVER(UNDER) USES OF FUNDS,CURRENT YEAR
50 A.O&M FUND $760,000 $713,000 $352,000 $651,000
51 B.SEWER DEVELOPMENT FEES $417,000 $409,000 $426000 $443,000
52 C.WATER DEVELOPMENT FEES ($69,000) ($75,000) ($81,000) ($84,000)
53 D.97 BONDSIR&R ($1,107.000) ($459,000) ($720,000) -
54 BOND FUNDS --- --.- -_ -
55 NET CHANGE IN FUND BALANCE,ALL ACCOUNTS $1,000 4588,000 ($23,000) 41,010,000
56 TOTAL BEGINNING BALANCES $12,167,000 $12,168,000 $12,756.000 $12733000
57 TOTAL ENDING BALANCES 413,168,000 $13,756,000 $13,733,000 $13,743,000
a 58 RESTRICTED FOR CAPITAL(DEV.FEES B BOND PROCEEDS) - $4,352,000 $4227,000 $3,852,000 $4,211,000
59 RESTRICTED RESERVES(BOND COVENANTS) $1,812,000 $1,812,000 $1,812,000 $1,812,000
60 DESIGNATED FOR WORKING CAPITAL $826000 $850,000 $895000 $931.000
61 UNRESERVED,UNRESTRICTED,AND VNDESILNATEO 55.178.000 55,957,000 50,174.000 $8,7R9,000
' SOURCE:BURTON&ASSOCIATES 12114/2000
FIOUfl x
a Crty of Ocoee, Florida
WATER&SEWER SYSTEM
Changes in Account Balances-
UPDT 01-BASELINE
A.O&M FUND
BEGINNING SALAAM:
' DEBT SERVICE RESERVE-NEW ISSUES .... — -_ _
DEBT SERVICE RESERVE-EXISTING ISSUES(93 BONDS) $1,119,000 $1,119.000 $1,119003 $1119,000
SINKING FUND $693,000 $693.000 $693,000 $693.000
RENEWAL AND REPLACEMENT RESERVE
aBEGINNING BALANCES.RESTRICTED $1,812.000 $1812,000 $1,812,000 $1,013,000
BEGINNING BALANCES,UNRESTRICTED 85,244,000 56,004,000 86.717,000 $7,069,000
1 REVENUE ACCOUNT TOTAL BEGINNING BALANCES $2,056,000 0,816,000 $8,529,,529,000 $8,8111,000
1 TOTAL SOURCES OVER(UNDER)USES OF FUNDS,CURRENT YEA $760.000 $713,000 $352,000 $651.000
1 ENDING_DALANREB.
a 1 DEBT SERVICE RESERVE-NEW ISSUES --- — _
1 DEBT SERVICE RESERVE-EXISTING ISSUES 693 BONDS) $1.119,000 $1,119.000 $1119,900 $1119.000
1 RENEWAL AND REPLACEMENT RESERVE _
1 ENDING BALANCES,RESTRICTED $1,119,000 $1119,000 $1,119,003 $1,119,000
1 ENDING BALANCES,UNRESTRICTED $6,004,000 $6.717,,000 8069,000 $7,720.000
a 1 REVENUE ACCOUNT TOTAL-ENDING BALANCES $7,816,000 S4,529,000 $8,281,000 $9,532,000
1 B.SEWER DEVELOPMENT FEES
2 BEGINNING BALANCES $2,401,000 $2818,000 $3,227.000 $3.653,000
2 TOTAL SOURCES OVER(UNDER)USES OF FUNDS,CURRENT YEA $417,060 $409,000 $426,000 $443,000
2 ENDING BALANCES $2,818,000 $3,227,000 $3653,000 $4,096,000
' 2 C.WATER DEVELOPMENT FEES
2 BEGINNING BALANCES $424,000 $955.000 $280,000 $199,000
2 TOTAL SOURCES OVER(UNDER)USES OF FUNDS,CURRENT YEA ($69,000).__ ($75,000) (881 000) ($84000)
2 ENDING BALANCES $355,000 $280,000 $199,000 5115,000
2 D.97 BONDSIRSR
a
2 BEGINNING BALANCES $2.286,000 $1,179,000 $720,090 —
29 TOTAL SOURCES OVER(UNDER)USES OF FUNDS,CURRENT YEA ($1107,000) ($459,000�__ ($720,000) ---
30 ENDING BALANCES $1179,000 $720,000 ._. _
31 BOND FUNDS
a 32 BEGINNING BALANCES -_ — _- —
33 TOTAL SOURCES OVER(UNDER)USES OF FUNDS,CURRENT YEA --- — —
-
35 ENDING BALANCES _0 — — _
36 TOTAL O BEGINNING OV BALANCES $t2,t8$1060 $12,168,000 $12,756,000 $t$1,010000
36 TOTAL SOURCESOVER(UNDER)USES OF FUNDS,CURRENT YEAR 8,000 $56,000 (33,00 $743,S00
a 37 TOTA(-ENDINOBALANCEB $12,168,000 $t2,]58,000 $u,ne,od9' v,]u,Do9
SOURCE:BURTON &ASSOCIATES 12/14/2000
I 1 1 I I I I 1 i I I I I I i 1 1 1
I
FIGURE S
City or Ocoee, 1 1 . I�
WATER&SSW EERR SYSTEM I -- L�L3 L
CAPITAL IMPROVEMENTS PROGRAM
AD ROC SCFNARIQ
SOURCE.BURTON I ASSOCIATES 1241412000
PROJECT PROJECT FISCAL YEAR ENOINGSEPTEMBER 30. EXPANSION
TOTAL CODE NUMBER PROJECT NAME 2001 2002 2003 2004 PERCENT
WATER SYSTEM:
5134000 P1 139 DESIGN CAPITAL CONSTRUCTION PROJECTS $134,000
150,000 P5 141 CONSTRUCT BOOSTER PUMP STATION ON A . MIMS RD 150,000
BOg0o0 P11 ua WATER TREATMENT PLANT IMPROVEMENTS 500,000
50,000 P13 145 REPLACE SODIUM HYPOCHLORITE GEN ANODES AT SWTP 50,000
50,000 P15 146 REPLACE SODIUM HYPOCHLORITE GEN ANODES AT FOWTP 50,000
100,000 P17 147 DECOMMISSION WELL AND PUMPTING SYSTEM AT JWTP 100,000 -
_ _.. ..
26.6% $984,000 $739000 $150,000 $50,000 $50,000
SfWfR3%STEjN1
95000 Pa 150 REHAB LIFT STATION 90,000 ---- -- - -- --
500,000 P10 155 REUSE RETROFIT PROJECTS SOO 2 5P5000 -0-
1,100,000 pu 155 REUSE RETROFIT PROJECTS SOUTHTH OF HWY 50 500 000 300 000 300 000
11000,000 PIC 157 CONSTRUCTADMIN BLDG AT A.O.MIMS WWTP 1 000 000 _
73.4% $2,715,000 TOTAL EEWER SYSTEM $515,000 $500.000 $1,300,000 $300,000
100.0% $3,699,000 TOTAL WATER AND SEWER $1,349,000 $650,000 $1,350,000 $350,000
SOURCE:BURTON 6 ASSOCIATES 12f U2Ooo
Pape 1014
a i I i i i i I i i 1 i 1 I I 1 1 1 1
City or Ocoee Florida r .1 I I
WATER&SEWER SYSTEM I i1
ANNUAL PROJECT FUNDING SUMMARY
AD HOC SCENARIO FIGURE 4
APPLICATION-OF-RINDS
2001 PROJECT SEWER WATER 97 BONDSIR&R O&M FUND
COST DEVELOPMENT FEE DEVELOPMENT FEE FUNDED BY
THIS FUND FUNDS FUND FUNDS FUND FUNDS FUND I FUNDS DEBT
YEAR BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED FINANCING
BEGINMRGBALANCE(SCHEDULE A) WADf060- 9424,000 f3,206,000 $7,056,000
ADDITIONAL FUNDS(SCHEDULE B) 417,000 (69.000) 242,000 6760,000
SUBTOTAL —f2,818.000 i 1355.000 62,520,000 f7,016,000-
LESS.DEDICATED BALANCE(SCHEDULE A) N/A N/A N/A $2,638,000
TOTAL AVAILABLE FOR CAPITAL PROJECTS —62sT87000 $355,000 S2,528,000 $5,178,000
PROJECTS(SCHEDULE C)
1 DESIGN CAPITAL CONSTRUCTION PROJECTS 5134,000 .... __ 6134000. _ _
4 REHAB LIFT STATION#1 93,ECO _.. __ yD�' -
10 REUSE RETROFIT PROJECTS-GROUP 1 82 525.000 --
1I 7DECOMMREAONWELANDPUMPTINGSYST SSI,IXp __ �O� __
9 DECOMMISSION WELL AND PUMPTING SYSTEM AT JWT 100,030 .... .._ 100,000 __
TOTAL I 61.349,000 _
f055.0001 61,PH,000 6 349 LES
f2,818,000 $355,000 $1,179,000 I LESS:INTEREST ON BOND FUNDS: -.-
lAVAIL BLE BALANCE AFTER APPLICATION OF FUNDS 62,818,000 65,178,000[NET DEBT FIN
..-
LENDING TOTAL BALANCE $7,816,000
SOURCE: BURTON A ASSOCIATES FILE-C\DATA\123\OCOEEWEVSUF-l\OCFAM19 WKd 1211412000
Page 1 of 4
I I i i I I I i i I I I i I I I I I i
•
cry or Ocoee,Florid - ' I-
\VATER&SEWER SYSTEM
ANNUAL PROJECT FUNDING SUMMARY L LI
AB XGC BCERABLQ FIGURE
- - APPETCATONOFFUND4
2002 PROJECT SEWER WATER 97 BONDSIRBR O&M FUND
COST DEVELOPMENT FEE DEVELOPMENT FEE FUNDED BY
THIS FUND FUNDA -I" FUND FUNDS FUND FUNDS FUND FUNDS DEBT
YEAR BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED FINANCING
SLUINNIN(a EALANCE t H $2,818,000 $355,000 $1,129,000 $/,816,000
ADDITIONAL FUNDS(SCHEDULE B) 409,000 (75,000) 191,000 1713,000
'.UBTOTAL >3,22T000 --{2807000- S1,5]Q,00O —503297P0ti
LESS.DEDICATED BALANCE(SCHEDULE A) N/A WA N/A S2.672,000
TOTAL AVAILABLE FOR CAPITAL PROJECTS -"—13,227,00 $280300- $1,370,000 15,B57-,00O
-ROJECTS(SCHEDULE C).
5 CONSTRUCT BOOSTER PUMP STATION ON A O.MIMS R' 150,000 .... __ 155000 I --
14REUSERETROFITPROJECTS-SOUTH OF HWY 50 500,000: .... 500000 I - -
TOTAL S650,0O0 .... $650,000 -__ - ----
LESS:INTEREST ON BOND FUNDSR
AVAILABLE BALANCE AFTER APPLICATION OF FUNDS $3,227,000 1250,0001 $720,000 I S5,857,000 NE1 DEBT FIN
ENDING TOTAL BALANCE $3,227.000 $280,000 $720,000 I 18,529,000
SOURCE: BURTON&ASSOCIATES FILE.C 1DATA1123\O ' 12/14/2000
Page 2 of 4
I I I I I I I I I I I i I I I I I i i
i'
City or Oa«q Florid. -
WATER&SEWER SYSTEM 51 IL11
ANNUAL PROJECT FUNDING SUMMARY
AD HOC SCENARIO FIGURE 4
—APPLICATION U$FUNDS
2003 PROJECT SEWER WATER 1
1 SJ BONDS/0.6R O&M FUND
COST DEVELOPMENT FEE DEVELOPMENT FEE FUNDED BY
THIS FUND FUNDS FUND FUNDS 1 FUND FUNDS FUND FUNDS DEBT
YEAR BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED FINANCING
1.NG BALANCE(SLHEUULE A) $3,227,000 5260.000 , 5720,000 S8,529.000
ADDITIONAL FUNDS(SCHEDULE B) 426.000 (81.000 i 165,000 1812,000I
'-UBTOTAL $3;053A09- - s1997000- ii $895�09- 49.440.000i
LESS'.DEDICATED BALANCE(SCHEDULE A) NIA N/A NIA 52,707,000
TOTAL AVAILABLE FOR CAPITAL PROJECTS 1T.653000" --9i99T0U' 85700C 153397000
--OJECTS(SCHEDULE C) 1,
14 REUSE RETROFIT PROJECTS-SOUTH OF HWY.50 300.000 __ 300,,000
15 REPLACE SODIUM HYPOCHLORITE GEN ANODES AT FC 50.000 - - - 50,000 --- __
10 CONSTRUCT ADMIN BLDG ATAD.MIMS WWTP t,MOUxI -_. .._ 535000 4651809 --..
OTAL 51,350.00 — S8S5,030 $465,003 -
LESS:INTEREST ON BOND FUNDS -...
AVAILABLE BALANCE AFTER APPLICATION OF FUNDS S3,553,0001 $199,000 — 15,174,000 INET Dt 1 FiN ....
ENDING TOTAL BALANCE 43,553.0001 1199,000 — W,881,000
SOURCE: BURTON 6 ASSOCIATES FILE.C\DATA\123\OCOEEREVSUF-i\OCFAM19.WK4 12/14/2000
Page 3 al 4
I 1 1 1 1 1 1 1 1 1 1 l 1 1 1 i 1 �17I l
r.\
City of m ee,Fm.m. r1 'I(�
WATER&SEWER SYSTEM
ANNUAL PROJECT FUNDING SUMMARY
AD MOO SCENARIO FIGURE 4
/�/
APPLICATION-OF-FUNDS
2004 PROJECT SEWER WATER 97 BONDSIRSR O&M FUND
I COST DEVELOPMENT FEE DEVELOPMENT FEE FUNDED BY
THIS FUND RINDS FUND FUNDS FUND FUNDS FUND FUNDS DEBT
' YEAR BALANCE APPLIED BALANCE APPLIED BALANCE APPLIED BALANCE ' APPLIED FINANCING
be INNING BALANCE(SCHEWLE A) $3,65300 $199,000 — 14851,000
ADDITIONAL FUNDS(SCHEDULE B) 443,000 (84,000 1511,000 $851,000
SUBTOTAL —T4098,000 $115,000 1150,600 —$9734,000
LESS DEDICATED BALANCE(SCHEDULE A) WA N/A N/A $2,143,000
TOTAL AVAILABLE FOR CAPITAL PROJECTS $4,0067000 —S115,000 f150,000 $6,988,000
PROJECTS(SCHEDULE C)
13 REPLACE SODIUM HYPOCHLORITE GEN ANODES AT S 50,000 .... _ 50000
14 REUSE RETROFIT PROJECTS-SOUTH OF HWY 50 300,000
TOTAL S350,000, - $150.000 S200,000
LESS:INTEREST ON BOND FUNDS: ---
AVAILABLE BALANCE AFTER APPLICATION OF FUNDS 84.096,000 1115,000 — 16,789.000INE1 DEBI FIN
59
(ENDING TOTAL BALANCE $4.096.000 S115,000 I — ,532,000 I
SOURCE: BURTON&ASSOCIATES FILE:C:\DATA\123\OCOE-IREVSUF-1\OCFAM19 WK4 12/14/2000
Page 4 of 4
a
Exhibits Appendix B - Reclaimed Water Rates Analysis
- Figure 1
City of Ocoee
Reclaimed Water System DRAFT
- Preliminary Progosed Rates
A B C D E
- 1 Retail Rates:
Usage Charge
er ,000 Gallons
for all Usage
above the
Ratio to 5/8 x 3/4 Fixed _ onthly Allowed Monthly Allowed Monthly
- 2 Meter Size inch meter Charae Usage in Gallons Usage_
3 5/8 x 3/4 1.00 $7.65 12,000 $0.38
4 3/4 1.00 $7.65 12,000 $0.38
5 1 2.50 $19.13 30,000 $0.38
6 1.5 5.00 $38.25 60,000 $0.38
7 2 8.00 $61.20 96,000 $0.38
- a 3 15.00 $114.75 180,000 $0.38
9
10 Bulk Rates:
- 11
Usage Charge per
I.000 Gallons for
aI11.1 a aboy_e
the Allowed
12 Month) Usage
- Ratio to 5/8 x 3/4 Fixed Monthly Allowed Monthly Wholesale
13 Meter Size inch meter Charge Usage in Gallons Customer
14
15 4 58.25 $295.69 699,000 $0.25
16 6 133.25 $676.40 1,599,000 $0.25
17 8 208.25 $1,057.12 2,499,000 $0.25
- 18 10 316.75 $1,607.88 3,801,000 $0.25
19 12 483.25 $2,453.07 5,799,000 $0.25
20 16 958.25 $4,864.25 11,499,000 $0.25
a
a
Source: Burton&Associates 01/04/2001
C:\DATA\123\CCOEE\CONSRP11I215WKSNWATES5.WK4
Figure 2
City of Ocoee
Reclaimed Water Rate Study
Rate Computations DRAFT
A B C D E F
Annual Annual New
Retrofit Cost Cost Der Bulk Cost Der
per ERU FRU ItlaiGallons
Annual O&M
Water
a 1 Meter Reading Costs $509,298
2 Number of Water Customers 73,175
3 Base Meter Reading Costs per Gust 1 _ $6.96]
4
a 5 Pumping 8 Storage 08M-Reclaimed Water $188,000
6 Number of Reclaimed Water ERUs 11,843
7 Pumping
p g 8 Storage g Cost per ERU 1 _ E15.871
8
9 Transmission Maint Costs 90.00% $2,082,493
10 Number of Water ERUs 84,899
11 Base Dist Maint Cost per ERU $24.53
12
13 Distribution Maint Costs 10.00% $231,388 :.
- 14 Number of Water ERUs 84,899
15 Base Dist Maint Cost per ERU L_ $2.73
16 Cross Connection 08M per Customer $55.20
17 Cross Connection 08M per ERU $50.97
a 18 Dist Maint 8 Cross Connection 08M $53.70
19 %of Cost
Cost
20 Retrofit Source °,4 _
e• 21 Meter Reading Costs per Cust Base 30% $2.09 231 Retrofit Gust $193
22 Pumping 8 Storage Cost per ERU 100% $1587 $15.87
23 Transmission Cost per ERU 100% $24.53 : $24.53'.
a Dist Maint Cost per ERU(Includes
24 Cross Connection 08M) Base 100% $53.70 250 Retrofit ERUs $53.70
25 100%
26 New
• 27 Meter Reading Costs per Cust Retrofit 100% $2.09 185 New Cust :. $1.93.
28 Pumping B Storage Cost per ERU 100% $15.87 $15.87
29 Transmission Cost per ERU 100% $24.53 $24.53.
t e Dist Maint Cost per ERU(Includes
30 Cross Connection 08M) Base 100% $53.70 200 New ERUs $53.70
31 100%
32 Bulk
▪ 33 Meter Reading Costs per Cust 100% $6.96 123 Bulk Cust $0.03
34 Pumping B Storage Cost per ERU 100% $1587 $0.07
35 Transmission Cost per ERU 100% $24.53 _
$0.10
Dist Maint Cost per ERU
AP (Includes Cross
36 Connection 08M) 0% $0.00 133 Bulk ERUs $0.00
37 0%
38 Total Annual 08M
_.-_ . . - $96.03 $9603'. $0.20
... 39 %of Total Cost 13 94% 6681% 50.00%
40
Figure 2
City of Ocoee
"' Reclaimed Water Rate Study
Rate Computations DRAFT
A B C D E F
Annual Annual New.
a Retrofit Cost Cstpe[ Bulk Cost per
per_ERU ERU 1004 GalWus
41 Capital Costs
42 Treatment Costs
a 43 No Treatment Costs NA
44 NA
45 NA
46 Total Treatment Costs $0.00 $000 $0.00
s 47 %d Total Cost 000% 000% 000%
48
49 Transmission Pumping&Storage Costs Grants
a50 Total Transmission Costs for New ERUs 0% $4,800,000
51 New ERUs(Phase I Buildoul of Horizon's West) __ 12,161
52 New Cost per ERU-Trans Costs $394.71
53 RIB Transmission Cost for New ERUs 0% $0
54 New ERUs(2050 Buildout ERUs) 23,304
- 55 New Cost per ERU-RIB Costs -- $0.00
56 Pumping&Storage Cost for New ERUs 0% $3,101,000
57 ERUs-from South Service Area 11,843
58 New Cost per ERU-Pumping&Storage Costs - $261.84
a. 59 Total New Cost per ERU $656.55 $47.70
60 Multiplier for Retrofit Cost _ 1.0
61 Retrofit Cost per ERU 0% $656.55 $47.70
62 Bulk Cost per 1000 Gallons _ _ r_100Tof Retrofit _ $020
63 Total Transmission Costs - $47.70. $47.70 $0.20
64 %d Total Cost 11.89%: 39.19% 5000%
65
Re ro
or 66 Distribution Costs Cost per
EB5! Retold EROS
67 Retrofitw Distribution Include in Cost ERU? Y $3,543 250 $257.40
68 New Distribution Costs $00p
69 Bulk Distribution Costs 0.00% $0 _ _ _ $0.00
70 Total Distribution Costs $257.40 $0.00 $0.00
71 %of TotalCos( 64.17%. 0.00% 0.00%
72
73 Cost Summary
74 Total Annual Cost per ERU' 5401.13 $143.73 NA
75 Monthly Cost per ERU _ _ $33.43 $11.98 NA
76 Bulk Rate Cost Multipliers - NA NA 1.00
77 Cost per 1000 Gallons _. $1.67. $0.60 $0.40
sr
79
80
81 Rate Summary
82 Calculated Rates:
83 Market Rate per ERU $7.65. $7.65 NA
84 Market Rate per 1000 Gal $0.38 $0.38 $0.25I
85 Percent of Current Base Potable Water Rate per 1000 Gallons 74.51% 74.51%
86 Cost Above Market Rate:
87 Monthly Cost Above Market Rate for New Customers $25.78
88 Annual Cost Above Market Rate for New Customers $309.33 NA NA
89 Lump Sum Payment for Cost Above Market Rate for New Customers $4,258 NA NA
a 90 —.. .
SOURCE: BURTON&ASSOCIATES
C:10ATAN231000EE\CONSRPnll15WKSMRATES4 WK4
Figure 3
City of Ocoee
Reclaimed Water Rate Study
Recommended Annual Number of Units to be Connected to the Reclaimed Water
System Durin tg he Next Four Years
'v ais L-
Connected ERU's _
Customer Class Year 1 Year 2 Year 3 Year 4
Retail-Retrofit 0 0 250 250
Retail-New 200 200 200 200
Bulk 133 133 _ 133 133
Total ERUs 333 333 583 583
Notes:(1)Year 1 represents the first year the City begins connection of Reclaimed Water
customers. It is assumed that the City will begin indexing water and wastewater rates
and charges beginning in year 1. Indexing of the water and wastewater rates will help
the water and wastewater system absorb the deficit that will arise from the connection of
Retail-Retrofit customers to the reclaimed water system.
SOURCE: BURTON&ASSOCIATES 12/14/2000
C'.\DATA\123CCOEE\CONSRPT1215W KSN\OCOEERI3.W K4