HomeMy WebLinkAboutSS3 - Wastewater Rate StudyCTY OF
F
NEWPORT BEACH
City Council Staff Report
May 26, 2015
Agenda Item No. SS3
TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL
FROM: George Murdoch, Acting Municipal Operations Department Director - (949) 644-
3011, gmurdoch @newportbeachca.gov
PREPARED BY: George Murdoch
PHONE: (949) 644 -3011
TITLE: Wastewater Rate Study (4:45 p.m.)
ABSTRACT:
The Municipal Operations Department retained the consulting services of H F & H Consultants, LLC
( "HF &H ") to prepare a wastewater and recycled water rate study. The purpose of this presentation is to
review the results of the wastewater rate portion of the study and propose the adoption of an appropriate
wastewater rate.
RECOMMENDATION:
The City has recently hired an outside expert to take a look at the rate structure and capital demands of the
long -term wastewater fund. Staff will go over aspects of the report with the City Council and community. If
the rate structure continues as is without any change, eventually the wastewater reserve fund will be
depleted.
FUNDING REQUIREMENTS:
Should Council move forward with the formal review and approval of the recommendations, a waste water
rate and structure may be established unless written protests against the proposed rate are presented by a
majority of owners of the parcels subject to the rate.
DISCUSSION:
Background:
The Municipal Operations Department operates and maintains approximately 197 miles of wastewater
sewer mains, 4.7 miles of force mains, 4,922 manholes and cleanouts, 25,525 sewer laterals, and 21
sewer lift stations. Operations, maintenance and repair activities include: Sewer line cleaning, root removal,
manhole maintenance and repair, lift station operation and maintenance, sewer line video inspection, as
well as sewer lateral maintenance, repair and replacement.
SS3 -1
Funding for maintenance and replacement activities is collected from rate payers via the Municipal
Services bill. Salaries, maintenance, operations, and internal service charges are estimated to be
approximately $3.5 million for FY 14 -15. Capital Improvement Projects (CIP) is based upon the Wastewater
Master Plan which was last updated in 2009. The Wastewater Master Plan sets $500,000 per year for CIP,
increasing to $1,000,000 per year to replace aging infrastructure over a 30 -year period.
The estimated wastewater revenue for FY 14 -15 is approximately $3.5 million. City Council Policy F -2 sets
the wastewater enterprise reserve level at 50% of the operations budget which is about $1.5 million.
Wastewater rates were last raised in 2006 going from $0.30 /HCF to $0.35 /HCF. Thanks to an increase in
outsourced services, reduced staff, and other factors, rates have not been increased in almost nine years.
Rate Studv:
In 2013, the City entered into an agreement with HF &H to conduct a Wastewater and Recycled Water Rate
Study, the first priority being to identify the recycled water rates. The recycled rates were adopted by City
Council on June 10, 2014 lowering the overall cost to our customers by about 50 %. The next phase of the
study was to address the wastewater rates. Attachment "A" is a draft report that includes details of the
proposed wastewater rates.
Current wastewater revenues provide adequate funding for operations. Ending reserves are approximately
$900,000 - but this is short of the minimum reserve balance. To fund capital improvement, reserve funds
would need to be used. This trend will fully deplete reserves by 2017 as shown in the attached Figure 1
Projected Fund Balance.
Currently the wastewater rates include a fixed fee, sewer use charge and two additional surcharges of
$2.00 /month for each additional dwelling unit and $10.00 /month for customers with two -inch or larger water
meters. The proposed rate structure eliminates these surcharges and moves the costs to the monthly fixed
charge.
The proposed rates include:
• Fixed charge - a monthly sewer service charge based on the size of water connection.
• Sewer use charge - a monthly charge for all customers based on water use.
For a comparison of how the new rate structure will affect sample residents, please see Attachment B.
SS3 -2
Current
Structure
FY 15 -16
FY 16 -17
FY 17 -18
FY 18 -19
FY 19 -20
Monthly Sewer Use Charge
5/8" or 3/4"
$4.50
$7.34
$8.07
$8.47
$8.90
$9.34
1"
$4.50
$7.34
$8.07
$8.47
$8.90
$9.34
1 1/2"
$4.50
$8.07
$8.88
$9.32
$9.79
$10.28
2"
$14.50
$11.01
$12.11
$12.71
$13.35
$14.02
2 1/2"
$14.50
$11.74
$12.91
$13.56
$14.24
$14.95
3"
$14.50
$12.47
$13.72
$14.41
$15.13
$15.88
4"
$14.50
$14.68
$16.14
$16.95
$17.80
$18.69
6"
$14.50
$16.51
$18.16
$19.07
$20.02
$21.02
8"
$14.50
$18.34
$20.18
$21.19
$22.25
$23.36
10"
$14.50
$23.48
$25.83
$27.12
$28.48
$29.90
Monthly Sewer Use Charge
Sewer Only Customers
Rate per Account
$6.25
$12.28
$13.51
$14.19
$14.90
$15.64
Consumption Charge
Rate per HCF
$0.35
$0.43
$0.47
$0.50
$0.52
$0.55
Sewer Surcharges
Multi Unit surcharge (per DU)
$2.00
Note 1
Note 1
Note 1
Note 1
Note 1
Note 1: The surcharge has been incorporated into the Monthly
Sewer Use Charge under the revised structure
For a comparison of how the new rate structure will affect sample residents, please see Attachment B.
SS3 -2
How do we comoare?
The study compared the proposed wastewater rates to those of our neighboring agencies (see attached
Figure 2 Neighboring Agency Comparison).
Next Steps
Following incorporation of the City Council's comments and recommendations, staff will present and
recommend the proposed wastewater rate and structure to the City Council at a regular Council meeting for
final review and approval to move forward with adoption. Staff will be required to issue Proposition 218
notices to the owners of parcels that are subject to the wastewater rate pursuant to California Constitution
Article XIII D, Section 6. There will be a 45 -day public notice period, and all written protests will be received
and tabulated.
Following a public hearing on the proposed wastewater rate and structure, the City Council may thereafter
proceed to adjust the wastewater rates unless written protests against the proposed rate are presented by
a majority of owners of the parcels subject to the rate.
ENVIRONMENTAL REVIEW:
Staff recommends the City Council find this action is not subject to the California Environmental Quality Act
( "CEQA ") pursuant to Sections 15060(c)(2) (the activity will not result in a direct or reasonably foreseeable
indirect physical change in the environment) and 15060(c)(3) (the activity is not a project as defined in
Section 15378) of the CEQA Guidelines, California Code of Regulations, Title 14, Chapter 3, because it
has no potential for resulting in physical change to the environment, directly or indirectly.
NOTICING:
The agenda item has been noticed according to the Brown Act (72 hours in advance of the meeting at
which the City Council considers the item).
ATTACHMENTS:
Description
Figure 1 - Proiected Fund Balance
Figure 2 - Neighboring Agency Comparisons
Attachment A - Draft Sewer and Recycled Water Rate Study
Attachment B - Example of Implemented Rate Structure
SS3 -3
FIGURE 1
SS3 -4
Target Balance
$3.50 -
(Operations + Capital)
$3.00
a
c
O
$2.50
c
c.
m
es with Rate
$2'00
Increase
c
`
$1.50
o
LL
`
��� (Operations)
U
`�`
m
$1.00
■
a
`.
`%% Reserves without
$0.50
�. Rate Increase
$0.00 A.
FY 2014 -15 FY 2015 -16 FY 2016 -17 FY 2017 -18 FY 2018 -19 FY 2019 -20
SS3 -4
Figure 2 - City Comparison
SS3 -5
ATTACHMENT A
May 26, 2015 - REVISED DRAFT
SS3 -7
CITY OF NEWPORT BEACH
592 Superior Avenue
Newport Beach, CA 92663
.W;-� '
c4
'' I
v
C� NEW
�
Llh't >RLO
SEWER AND RECYCLED WATER RATE STUDY
May 26, 2015
HF &H CONSULTANTS,, LLC
201 North Civic Drive, Suite 230
Walnut Creek, CA 94596
C tff CONSULTANTS, LLC All rights reserved.
Td, document is printed on 100% recycled, poet - consumer content paper
SS3 -8
SS3 -9
May 26, 2015
Mr. George Murdoch
Utilities General Manager
City of Newport Beach
592 Superior Avenue
Newport Beach, CA 92663
Subject: Sewer and Recycled Water Rate Study
Dear Mr. Murdoch:
HF &H Consultants, LLC, is pleased to submit this Sewer and Recycled Water Rate
Study to the City of Newport Beach (City). The report summarizes the analysis that
was conducted to develop the recommended rates. A copy of the rate model is
included in the appendix.
The Recycled Water revenue increases and Recycled Water rate design sections
presented in this report summarize the analysis that was previously submitted as a staff
report and presented to City Council on April 29, 2014. The City Council subsequently
adopted, by Resolution 2014 -78 on September 9, 2014, the recommended Recycled
Water rates in compliance with Proposition 218, effective October 9, 2014, and updated
each January 1 thereafter.
The City has demonstrated leadership in improving rate payer equity during a time
when costs are increasing in compliance with regulatory mandates. It has been a
privilege to assist the City with this step forward.
Very truly yours,
HF &H CONSULTANTS, LLC
John W. Farnkopf, P.E.
Senior Vice President
SS3 -10
SS3 -94
TABLE OF CONTENTS
1. EXECUTIVE SUMMARY .................................................. ............................... 1
Findings And Recommmendations ........................................... ..............................1
Sewer.............................................................................. ..............................1
RecycledWater ................................................................. ..............................2
2. INTRODUCTION ............................................................ ............................... 4
StudyPurpose ....................................................................... ..............................4
Rate Making Objectives .......................................................... ..............................4
Background........................................................................... ..............................4
Sewer.............................................................................. ..............................4
RecycledWater ................................................................. ..............................4
3. SEWER PROJECTED REVENUE INCREASES ................... ............................... 6
Revenue Requirements ........................................................... ..............................6
Salaries............................................................................ ..............................6
Benefits........................................................................... ............................... 6
Operations & Maintenance ................................................. ..............................6
Internal Services Allocation ................................................ ..............................7
Operating Reserve Expense ............................................... ..............................7
Capital Reserve Expense .................................................... ..............................7
Miscellaneous Costs .......................................................... ..............................7
Revenue Increases ................................................................. ..............................7
FundBalance ......................................................................... ..............................8
MinimumFund Balance ..................................................... ..............................9
TargetFund Balance ......................................................... ..............................9
4. SEWER RATE DESIGN .................................................. ............................... 10
CurrentRate Structure .......................................................... .............................10
Proposed Rate Structure ........................................................ .............................10
Current and Proposed Customer Bill Comparisons ................... .............................12
Comparison with Neighboring agencies .................................. .............................13
5. RECYCLED WATER PROJECTED REVENUE INCREASES .............................. 15
Revenue Requirements .......................................................... .............................15
Operating Expenses ......................................................... .............................15
Purchased Recycled Water ................................................ .............................15
Pump Station Operating and Maintenance ......................... .............................15
Depreciation.................................................................... .............................16
6. RECYCLED WATER RATE DESIGN ................................ ............................... 17
Current Rate Structure .......................................................... .............................17
Proposed Rate Structure ........................................................ .............................17
SS3 -12
CustomerBill Comparisons .................................................... .............................20
APPENDIX A. SEWER AND RECYCLED WATER RATE MODEL
TABLE OF FIGURES
Figure 1 -1. Current and Proposed Sewer Rates ............................. ..............................2
Figure 1 -2. Average Current and Proposed Monthly Sewer Bills ...... ..............................2
EDU
Figure 1 -3. Current and Proposed Recycled Water Rates ............... ..............................3
Figure 3 -1. Annual Revenue Requirement Components ................ ..............................6
EMU
Figure 3 -2. Capital Projects ......................................................... ..............................7
FY
Figure 3 -3. Projected Revenue Increases ..................................... ..............................8
GPD
Figure 3 -4. Fund Balance With and Without Rate Increases .......... ..............................9
HCF or CCF
Figure 4 -1. Fixed and Variable Revenue ....................................... .............................10
Figure 4 -2. Calculation of Monthly Fixed Charges ......................... .............................11
I &I
Figure 4 -3. Calculation of Sewer Consumption Charge .................. .............................11
Figure 4 -4. Five Year Sewer Rate Projections ............................... .............................12
O &M
Figure 4 -5. Customer Bill Comparison .......................................... .............................13
OCSD
Figure 4 -6. Neighboring Agency Comparison ................................ .............................14
OCWD
Figure 5 -1. Revenue Requirement Projections .............................. .............................15
PAYGo
Figure 6 -1. FY 2014 -15 Revenue Requirement by Cost Category ... .............................18
Figure 6 -2. Calculation of Monthly Fixed Charges ......................... .............................19
SFR
Figure 6 -3. Calculation of Commodity and Pump Station Charges .. .............................19
Figure 6 -4. Five Year Recycled Water Rate Projections ................. .............................20
ACRONYMS
CIP
Capital Improvement Plan
EDU
Equivalent Dwelling Unit, an average single - family residential
customer
EMU
Equivalent meter unit
FY
Fiscal Year
GPD
Gallons Per Day
HCF or CCF
Hundred Cubic Feet of metered water; 748 gallons; a cube of water 4.6
feet on edge
I &I
Inflow and Infiltration; stormwater runoff that enters collection systems
through surface or subsurface connections, cracks, or other openings
O &M
Operations and Maintenance
OCSD
Orange County Sanitation District
OCWD
Orange County Water District
PAYGo
Pay -As- You -Go, in reference to funding capital improvements from
cash rather than from borrowed sources of revenue
SFR
Single Family Residential
SS3 -13
ACKNOWLEDGEMENTS
City Council
Edward Selich, Mayor
Diane Dixon, Mayor Pro Tem
Kevin Muldoon, Council Member
Tony Petros, Council Member
Duffy Duffield, Council Member
Scott Peotter, Council Member
Keith Curry, Council Member
City Finance Commission:
Diane Dixon, Mayor Pro Tem
Keith Curry, Council Member
Tony Petros, Council Member
Larry Tucker, Appointed Finance Commission Member
City Staff
George Murdoch, Utilities General Manager
Dan Matusiewicz, Deputy Finance Director
Rachell Wilfert, Management Assistant
HF &H Consultants, LLC
John Farnkopf, Sr. Vice President
Sima Mostafaei, Senior Associate
SS3 -14
SS3 -95
SEWER AND RECYCLED WATER RATE
STUDY
SS3 -16
This page intentionally left blank
SS3 -97
1. EXECUTIVE SUMMARY
This report summarizes the analysis of the City's sewer and recycled water rates. The
analysis represents a collaborative effort of the City's Staff and consulting team. HF &H
prepared the financial plan model using the City's FY 2015 -16 preliminary operating
budget for sewer, and the FY 2014 -15 preliminary operating budget for recycled water.
FINDINGS AND RECOMMMENDATIONS
Sewer
1. Key Assumptions. Rates were set to generate revenue sufficient to fund the
City's collection system expenses, local capital improvements funded from cash,
and to maintain the City's reserves.
2. Revenue Projections. The revenue increases enable the City to address
collection and pump station improvement projects that were identified in the
City's Sewer Master Plan. These increases enable the City to ramp up PAYGo
funding for capital projects over the next five years; by the fifth year, the rates
will enable the City to fund $1,300,000 per year on a pay -as- you -go cash basis
without issuing debt.
3. Rate Design. The City's current sewer customers pay the sum of the following: a
fixed monthly sewer use charge that is the same for all customers and a
commodity charge based on metered water use during the monthly period. In
addition, for meters 2 -inch or larger, a $10.00 monthly surcharge is assessed, and
for connections servicing two or more dwelling units on the same connection, a
$2.00 per unit per month surcharge is assessed for any additional dwelling units.
We recommend combining the two surcharges into the monthly use charge, and
maintaining the commodity charge. Under the revised rate structure, customers
will pay the sum of only two charges: a monthly sewer use charge, graduated
based on the capacity of the connection, and the commodity charge.
4. Projected Rates. Figure 1 -1 shows the sewer rates that are needed to cover the
projected revenue requirements, and compares the revised structure to the
current structure. In the revised rate structure, the service charges were
graduated using an EMU multiplier that was based on the ratio of $4.50 to $14.50
(the current rate ratio), the effect of which is to increase the service charges for
the larger services. The revised rate structure maintains the consumption charge,
but includes the larger meter and additional dwelling unit surcharges as part of
the monthly sewer use charge.
SS3 -18
Figure
1 -1. Current and Proposed Sewer Rates
Current
Revised
Structure
Structure FY 2015 -16
FY 2016 -17
FY 2017 -18
FY 2018 -19
FY 2019 -20
Monthly Sewer Use Charge
5/8" or 3/4"
$4.50
$5.97
$7.34
$8.22
$8.79
$9.41
$9.88
P
$4.50
$5.97
$7.34
$8.22
$8.79
$9.41
$9.88
1 1/2"
$4.50
$6.56
$8.07
$9.04
$9.67
$10.35
$10.87
2"
$14.50
$8.95
$11.01
$12.33
$13.19
$14.11
$14.82
2 1/2"
$14.50
$9.54
$11.74
$13.15
$14.07
$15.05
$15.81
3"
$14.50
$10.14
$12.47
$13.97
$14.95
$16.00
$16.79
4"
$14.50
$11.93
$14.68
$16.44
$17.59
$18.82
$19.76
6'
$14.50
$13.42
$16.51
$18.49
$19.78
$21.17
$22.23
8"
$14.50
$14.91
$18.34
$20.55
$21.98
$23.52
$24.70
10"
$14.50
$19.09
$23.48
$26.30
$28.14
$30.11
$31.61
Monthly Sewer Use Charge
(Sewer Only Customers)
Rate per Account
$6.25
$9.99
$12.28
$13.76
$14.72
$15.75
$16.54
Consumption Charge
Rate per HCF
$0.35
$0.35
$0.43
$0.48
$0.52
$0.55
$0.58
Sewer Surcharges
Multi Unit surcharge (per DU) $2.00
Note 1
Note I
Note l
Note 1
Note 1
Note 1
Note 1: The surcharge has been incorporated into the Monthly Sewer Use Charge under the revised structure.
5. Customer Bills. Figure 1 -2 shows an average monthly residential and non-
residential bill at the current rates, and the average bills over the five year
projection period. In addition to paying the monthly sewer use charge based on
the size of the connection, each customer's monthly bill includes a consumption
charge that is determined by multiplying the consumption charge times the
average monthly residential flow of 11.49 HCF and non - residential flow of 595
HCF, respectively.
1-Igure 3 -z. Average current ana vroposea nnonmiy sewer Isms
Monthly
Meter Flow Current
Size (HCF) Structure FY 2015 -16 FY 2016 -17 FY 2017 -18 FY 2018 -19 FY 2019 -20
Single Family Residential 518" 11.49 $8.52 $12.28 $13.76 $14.72 $15.75 $16.54
Non Residential 4" 595.00 $224.75 $270.82 $303.32 $324.55 $347.27 $364.64
Recycled Water
1. Key Assumptions. Rates were set to generate revenue sufficient to fund the
City's recycled water system's operations and maintenance expense, the cost of
SS3 -19
purchasing recycled water from OCWD, and capital replacement expense related
to pump stations and meters.
2. Rate Design. The City's current recycled water customers pay the sum of two
charges: a monthly fixed charge that is based on the size of the connection, and a
commodity charge based on metered water use during the monthly period. The
commodity charge is based on 80% of the potable water rate. We recommend
unlinking the recycled water rate from the potable water rate and aligning the
recycled fixed and commodity charges with the fixed costs and the cost of
purchased water from OCWD, respectively. In addition to the fixed and
commodity charges, pump station users will be charged a pump station charge
based on the cost to operate and maintain the stations and convey recycled
water.
3. Projected Rates. The rate projections are shown in Figure 1 -3.
Figure 1 -3.
Current and Proposed Recycled Water Rates
Current
FY 2014 -15
FY 2015 -16
FY 2016 -17 FY 2017 -IS
FY 2018 -19
Monthly Service Charge
5/8" or 3/4"
$13.82
$18.91
$19.29
$19.68
$20.07
$20.47
1"
$23.03
$31.53
$32.16
$32.80
$33.46
$34.13
1 1/2"
$46.06
$63.05
$64.32
$65.60
$66.91
$68.25
2"
$73.70
$100.88
$102.90
$104.95
$107.05
$109.19
3"
$138.18
$189.15
$192.94
$196.80
$200.73
$204.75
4"
$230.30
$315.25
$321.56
$327.99
$334.55
$341.24
6"
$460.61
$630.50
$643.11
$655.98
$669.10
$682.48
8"
$736.98
$1,008.81
$1,028.99
$1,049.57
$1,070.56
$1,091.97
Monthly Commodity Charge
Rate per HCF
$2.46
$0.86
$0.87
$0.89
$0.91
$0.93
Monthly Pump Station Charge
Rate per HCF
none
$0.36
$0.37
$0.38
$0.38
$0.39
SS3 -20
2. INTRODUCTION
STUDY PURPOSE
The purpose of this study is to update the City's rates to ensure that they generate
sufficient revenue and that the rate structures for sewer and recycled water reflect the
City's current rate - making objectives. The study was commissioned by the City to
evaluate the effect of certain rate structure modifications in response to input from its
customers.
RATE MAKING OBJECTIVES
The City's current rate - making objectives include the following:
• Provide revenue sufficiency and financial stability to cover the projected capital
and O &M costs of providing recycled water and funding the City's Sewer fund.
• Meet the City's operations and capital funds reserve targets for the sewer
enterprise fund.
• Rates should reflect equity of costs in proportion to the level of service.
• Provide for efficient administration and execution of utility billing.
• Minimize "rate shock" overall and to any specific customer class.
• Rates should be clear and understandable to the customers.
• The rates must comply with Proposition 218 and applicable State codes.
BACKGROUND
Sewer
The City provides sewer service to approximately 64,465 customers. The City's existing
sewer collection system consists of a network of forcemain and gravity sewers. This system
is composed of approximately 197 miles of mainline gravity pipes, 4.7 miles of forcemains
with 4,922 manholes and cleanouts, and 25,525 sewer laterals with an approximate length of
121 miles in the public- rights -of -way. The City's service area lies within the OCSD who is
responsible for treating the City's sewer. The City also owns and operates 21 pump stations
in various areas which lift sewer from the lower areas and several island communities for
treatment at OCSD's treatment plant.
Recycled Water
The City currently has five recycled water customers totaling 14 water connections. The
customers include Big Canyon and Newport Beach Country Club golf courses; East
Bluff School, Our Lady Queen of Angels School, and the City which uses recycled water
for irrigation of medians and parks.
In 1991, the City entered into an agreement with OCWD for the distribution and sale of
Green Acres Project water. The agreement stipulates the rules and regulations for the
SS3 -21
City to provide recycled water. Included in this agreement is the stipulation that
recycled water rates may not exceed 80% of the potable water rate. The agreement term
is for 25 years with five 5 -year automatic extensions, with an estimated ending term
year of 2041.
The City subsequently entered into "End User Agreements' for the sale of recycled
water to large customers in 1996 for a 10 -year term. These agreements, now expired,
included provisions that OCWD and the City would provide funding to modify golf
courses and construct pump stations to facilitate the use of recycled water. However, in
2011, the City and the Big Canyon Country Club entered into an agreement that
provided for the delivery and sale of recycled water, and a pump station license
agreement.
SS3 -22
3. SEWER PROJECTED REVENUE INCREASES
REVENUE REQUIREMENTS
Rate analysis begins by determining the revenue requirements that must be met by
rates. For purposes of this study, a ten -year rate projection period was developed using
a spreadsheet model (see Appendix A). However, only the first five years are shown in
Figure 3 -1 for rate - setting purposes. Figure 3 -1 summarizes the major categories
comprised in the revenue requirements, indicating the annual change.
Haure 3 -1. Annual Revenue Reauirement Components
Salaries
This cost category includes regular and overtime pay and is projected to increase
gradually at about 3% per year during the projection period. No staff headcount
increases are anticipated; the cost trend is driven primarily by cost of living adjustments
set in labor agreements.
Benefits
This cost category includes health, dental, and vision as well as Other Post - Employment
(OPEB) and Public Employment (PERS) retirement benefits. During the projection
period these costs are projected to increase at about 5% per year. The cost trend is
driven primarily by increases in health care benefit costs set in labor agreements.
Operations & Maintenance
This cost category includes non - personnel related operating and maintenance expenses,
such as electrical utility costs, fuel, and non - capital materials and equipment. During
the projection period, these costs are expected to increase gradually at about 1.73% per
year, based on the five -year historical average of inflation for the Los Angeles area.
SS3 -23
FY 2015 -16 FY 2016 -17 FY 2017 -18 FY 2018 -19 FY 2019 -20
Salaries
$ 947,547
$ 975,973
$1,005,253
$1,035,410
$1,066,472
Benefits
575,693
604,478
622,612
641,290
660,529
Operations & Maintenance
995,721
989,549
1,006,668
1,024,084
1,041,800
Internal Services Allocation
670,581
682,182
693,984
705,990
718,203
Operating Reserve Expense
37,497
242,152
214,690
456,257
224,189
Capital Reserve Expense
500,000
750,000
1,000,000
1,000,000
1,300,000
Miscellaneous Costs
33,000
33,571
34,152
34,743
35,344
Total Revenue Requirement
$ 3,760,039
$4,277,905
$4,577,358
$4,897,773
$5,046,538
Salaries
This cost category includes regular and overtime pay and is projected to increase
gradually at about 3% per year during the projection period. No staff headcount
increases are anticipated; the cost trend is driven primarily by cost of living adjustments
set in labor agreements.
Benefits
This cost category includes health, dental, and vision as well as Other Post - Employment
(OPEB) and Public Employment (PERS) retirement benefits. During the projection
period these costs are projected to increase at about 5% per year. The cost trend is
driven primarily by increases in health care benefit costs set in labor agreements.
Operations & Maintenance
This cost category includes non - personnel related operating and maintenance expenses,
such as electrical utility costs, fuel, and non - capital materials and equipment. During
the projection period, these costs are expected to increase gradually at about 1.73% per
year, based on the five -year historical average of inflation for the Los Angeles area.
SS3 -23
Internal Services Allocation
The City has historically transferred funds from the Sewer Enterprise Fund to the
General Fund as reimbursement for governmental costs incurred by the General Fund
on behalf of the Enterprise. Much of this funding reimburses the General Fund for
salaries, equipment, and program costs associated with general services. During the
projection period, these costs are expected to increase gradually at about 1.73% per year,
based on the five -year historical average of inflation for the Los Angeles area.
Operatino Reserve Expense
The City transfers rate revenue to its Operating Reserve during the projection period to
smooth out the annual revenue requirements and meet the minimum fund balance
requirement. Please refer to the section titled 'minimum fund balance' in this report for
further discussion of the fund policy.
Capital Reserve Expense
The City's 30 -year capital improvement program planned expenditures are
summarized in Figure 3 -2.
Figure 3 -2. Capital Projects
The City plans to fund these capital improvements with cash from rate revenue. To
accomplish this goal, the program is phased based upon the implementation cost of the
facilities, and the quantity of work the City can reasonably administer each year. The
programmed rate increases over the next five years allow the City to ramp up funding
for capital projects and provide the City approximately $1.3 million annually by FY
2019 -20 with the additional revenue generated from the recommended rate increases.
Miscellaneous Costs
This cost category includes non - capital office and shop equipment. During the
projection period, these costs are expected to increase gradually at about 1.73% per year,
based on the five -year historical average of inflation for the Los Angeles area.
REVENUE INCREASES
To determine how much additional rate revenue is required, the projected revenue
requirements are compared to the revenue from current rates. The revenue from
SS3 -24
Project
CIP Project Description
Cost
Collection System Capacity
Improvements
$1281391
Collection System Condition
Improvements
$16,648,060
Pump Station Improvements
$11,088,000
Total $29,017,451
The City plans to fund these capital improvements with cash from rate revenue. To
accomplish this goal, the program is phased based upon the implementation cost of the
facilities, and the quantity of work the City can reasonably administer each year. The
programmed rate increases over the next five years allow the City to ramp up funding
for capital projects and provide the City approximately $1.3 million annually by FY
2019 -20 with the additional revenue generated from the recommended rate increases.
Miscellaneous Costs
This cost category includes non - capital office and shop equipment. During the
projection period, these costs are expected to increase gradually at about 1.73% per year,
based on the five -year historical average of inflation for the Los Angeles area.
REVENUE INCREASES
To determine how much additional rate revenue is required, the projected revenue
requirements are compared to the revenue from current rates. The revenue from
SS3 -24
current rates also reflects the impact of reduced water demand required of the City's
customers to comply with the State Water Resources Control Board's emergency
regulations. For the City's consumption charges, sewer flows from individual City
customers are not metered; therefore water use data is the closest representation of
flows that customers discharge to the City's system for conveyance and treatment.
Estimating current rate revenue took into account 23,104 currently active meters whose
flow equaled 3,932,915 HCF. We also included the annual surcharge revenue for meters
2" or larger, as well as the surcharge for multiple dwelling units serviced by the same
meter. The resulting rate revenue for FY 2014 -15, prior to rate increases, but net of 0.4%
of bad debt, was estimated at $3,105,332. Based on this estimate, annual revenue
increases were projected as shown in Figure 3 -3.
ure a -a. rrolecieu mevenue increases
FY 2015 -16 FY 2016 -17 FY 2017 -18 FY 2018 -19 FY 201
Revenue Requirement
$3,760,039
$4,277,905
$4,577,358
$4,897,773
$5,046,538
Revenue from Current Rates"
3,105,332
3,105,332
3,105,332
3,105,332
3,105,332
Difference
(654,707)
(1,172,574)
(1,472,027)
(1,792,442)
(1,941,206)
Fund Balance (before increase) 1,259,566 320,046 (972,663) (2,363,872) (4,180,01
Revenue from Increases 654,707 1,172,573 1,472,027 1,792,442 1,941,206
Fund Balance (after increase) 1,916,729 2,159,108 2,350,244 2,764,401 2,902,600
revenue
based on conservation efforts
FUND BALANCE
revenue
The FY 2014 -15 estimated year -end fund balance is projected to be $1,865,000, which is
slightly higher than the minimum operations balance of $1,423,000. Figure 3-4 shows
the fund climbing toward the target balance throughout the five year rate projection
period, based on the projected revenue increases. Fluctuations in annual flow will
affect revenue generation and the resulting fund balance. The City is advised to
carefully monitor the fund balance in the event of downward fluctuations in flow.
SS3 -25
Figure 3 -4. Fund Balance With and Without Rate Increases
Minimum Fund Balance
The minimum balance (red line) is the balance tNt is required to meet the City's
operating expenses during the year. If this minimu balance were maintained, the
Sewer Fund should be able to fund its monthly cash f%w over this extended period
without relying on the General Fund for a short -term loan. When the Operations
Reserve balance is below the minimum balance, the likelihood% increases that temporary
funding from the General Fund will be required to meet casl�,flow needs. The City's
reserve policy dictates that the minimum Operations Reserve balance be set equal to
50% of annual O &M expenses.
Target Fund Balance
The proposed revenue increases move the fund balance (solid grek line) upward
toward the target balance (blue line). The target balance is the sum o?,,the minimum
balance for operations (red line) plus an allowance for capital projects. A's allowance
provides liquidity to fund construction for projects on a pay -as- you -go Yap is. With
adequate capital reserves, the City is able to pay construction contractors without
encroaching on the Operations Reserve. The allowance is based on the average annual
budgeted capital improvement projects.
SS3 -26
Target R,I, --e
$3.50
(Operations + Capital)
$3.00
w
c
0
$2.50
c
119s with Rate
"m
Increase
A
$2.00
m
c
$1.50
Balance
o.
Orn-
(Operations)
m
o
$1.00
`�
$0.50
$0.00
FY 2014-15 FY 2015 -16 FY 2016 -17', FY 2017 -18 FY 2018 -19 FY 2019 -20
Minimum Fund Balance
The minimum balance (red line) is the balance tNt is required to meet the City's
operating expenses during the year. If this minimu balance were maintained, the
Sewer Fund should be able to fund its monthly cash f%w over this extended period
without relying on the General Fund for a short -term loan. When the Operations
Reserve balance is below the minimum balance, the likelihood% increases that temporary
funding from the General Fund will be required to meet casl�,flow needs. The City's
reserve policy dictates that the minimum Operations Reserve balance be set equal to
50% of annual O &M expenses.
Target Fund Balance
The proposed revenue increases move the fund balance (solid grek line) upward
toward the target balance (blue line). The target balance is the sum o?,,the minimum
balance for operations (red line) plus an allowance for capital projects. A's allowance
provides liquidity to fund construction for projects on a pay -as- you -go Yap is. With
adequate capital reserves, the City is able to pay construction contractors without
encroaching on the Operations Reserve. The allowance is based on the average annual
budgeted capital improvement projects.
SS3 -26
4. SEWER RATE DESIGN
CURRENT RATE STRUCTURE
The City currently has 23,104 active accounts who pay the sum of two charges every
month for Sewer service: a basic service charge of $4.50 per account plus a sewer
consumption charge of $0.35 per HCF based on metered water use during the billing
period. In addition to the charges specified above, customers with a water service
connection of 2 "or greater pay a $10.00 monthly surcharge. Moreover, customers with
more than one dwelling unit that is serviced by the same connection pay a surcharge of
$2.00 for each additional dwelling unit. Lastly, the City's 485 sewer customers who do
not purchase potable water from the City are charged $6.25 per account per month.
PROPOSED RATE STRUCTURE
The proposed rate structure is based on the revenue generated by the current rate
structure and categorizes the revenue into two categories: fixed revenue and variable
revenue. Fixed revenue is considered fixed because it does not vary based on flow,
while variable costs vary because they are based on the amount of water purchased, or
sewage produced and therefore, are solely comprised of the sewer consumption charge.
For the purpose of rate design, the sewer use charge for customers who do not purchase
water from the City was analyzed separately. Figure 4 -1 presents the breakdown of the
current revenue by revenue category:
Current Revenue
xed Revenue
Sewer Use Charge (per account) $1,247,616
Surcharge (2" meters or greater) $78,720
Surcharge (per additional DU) $378,492
rtal Annual Fixed Revenue $1,704,828
Variable Revenue
Consumption Charge (per HCF)
$1,376,520
Total Annual Variable Revenue
$1,376,520
Subtotal
$3,081,348
Sewer Use Charge (per account)*
$36,375
Grand Total **
$3,117,723
*Sewer Revenue from customers who do not purchase potable
water from the City of Newport Beach
* *Gross revenues; does not account for bad debt
SS3 -27
In order to determine the monthly charge by size of connection, we first converted the
number of active meters to equivalent meter units (EMU) as shown in Figure 4 -2. The
EMU multiplier by meter size is the same multipliers used to determine the fixed
charge by meter size for the current sewer rates; in other words, it is the ratio between
$4.50 to $14.50, or 1 to 3.2. The monthly charge for an EMU of 1.00 is derived by
dividing the total fixed revenue of $1,704,828 by the total number of EMUS, or 23,815.
This quotient was then divided by 12 to convert from an annual charge of $71.59 to a
monthly charge of $5.97. The service charges were then graduated using the EMU
multipliers, the effect of which is to increase the service charges for the larger services.
Note the total annual revenue of $1,704,828 from fixed charges in Figure 4 -2 is equal to
the total annual fixed revenue presented in Figure 4 -1.
Figure 4 -2. Calculation of Monthly Fixed Charges
The sewer consumption charge was derived using the monthly meter readings in HCF
for all customers. Figure 4 -3 presents the derivation of the proposed sewer consumption
charges.
-i ure 4 -s. uaicwauon or newer uonsumpuon i,nar E
Current Usage Charge
Cost Category Revenue (HCF) per HCF
Revenue $1,376,520 3,932,915 $0.35
For sewer customers who do not purchase potable water from the City, and therefore,
do not have a proxy for their sewer flows, an average flow per account was derived by
using average water use per single family residential account. The 11.49 HCF average
SS3 -28
Total
Monthly
Annual
Total Active
EMU
Total
Service
Fixed
Meter Size
Accounts
Multiplier
EMUS
Charge
Revenue
a
b
a *b
c
a *c *12
5/8" or 3/4"
15,357
1.00
15,357
$5.97
$1,099,342
1"
6,276
1.00
6276
$5.97
$449,272
1 1/2"
364
1.10
400
$6.56
$28,663
2"
886
1.50
1,329
$8.95
$95,137
21/2"
1
1.60
2
$9.54
$115
3"
34
1.70
58
$10.14
$4,138
4"
119
2.00
238
$11.93
$17,037
6"
54
2.25
122
$13.42
$8,698
8"
11
2.50
28
$1491
$1,969
10"
2
3.20
6
$19.09
$458
23,104
23,815
$1,704,828
The sewer consumption charge was derived using the monthly meter readings in HCF
for all customers. Figure 4 -3 presents the derivation of the proposed sewer consumption
charges.
-i ure 4 -s. uaicwauon or newer uonsumpuon i,nar E
Current Usage Charge
Cost Category Revenue (HCF) per HCF
Revenue $1,376,520 3,932,915 $0.35
For sewer customers who do not purchase potable water from the City, and therefore,
do not have a proxy for their sewer flows, an average flow per account was derived by
using average water use per single family residential account. The 11.49 HCF average
SS3 -28
use was determined using customer billing data and dividing total single family
consumption by the number of single family accounts. Next, using the revised rate
structure, the $9.99 charge shown in Figure 4-4 represents the average single family bill
per month. It was calculated as the monthly sewer use charge of $5.97 per account plus
the product of the $0.35 consumption charge times 11.49 HCF.
Using the fixed and variable rates as calculated in Figure 4 -2 and Figure 4 -3, a five -year
rate plan was prepared based on the City's Sewer revenue requirements as presented in
Figure 3 -1. The rates included in the 5 -year plan reflect annual rate increases starting in
FY 2015 -16 to keep pace with the increase in the revenue requirements. The proposed 5-
year rate plan is shown in Figure 4-4.
Figure 4 -4. Five Year Sewer Rate Projections
Note I: The surcharge has been incorporated into the Monthly Sewer Use Charge under the revised structure.
CURRENT AND PROPOSED CUSTOMER BILL COMPARISONS
Figure 4 -5 presents a comparison of monthly customer bills using the current rate
structure and the recommended revised rate structure. The rates used to calculate the
revised bills are the FY 2015 -16 charges presented in Figure 4 -4. It is notable that current
customers who are subjected to the multiple dwelling $2.00 monthly surcharge will
experience a decrease in their monthly bill. This occurs based on the revisions to the
SS3 -29
Current
Revised
Structure
Structure
FY 2015 -16
FY 2016 -17
FY 2017 -18
FY 2018 -19
FY 2019 -20
Monthly Sewer Use Charge
5/8" or 3/4"
$4.50
$5.97
$7.34
$8.22
$8.79
$9.41
$9.88
1"
$4.50
$5.97
$7.34
$8.22
$8.79
$9.41
$9.88
11 /2"
$4.50
$6.56
$8.07
$9.04
$9.67
$10.35
$10.87
2"
$14.50
$8.95
$11.01
$12.33
$13.19
$14.11
$14.82
2 1 /2"
$14.50
$9.54
$11.74
$13.15
$14.07
$15.05
$15.81
3"
$14.50
$10.14
$12.47
$1197
$14.95
$16.00
$16.79
4"
$14.50
$11.93
$14.68
$16.44
$17.59
$18.82
$19.76
6"
$14.50
$13.42
$16.51
$18.49
$19.78
$21.17
$22.23
8"
$14.50
$14.91
$18.34
$20.55
$21.98
$23.52
$24.70
10"
$14.50
$19.09
$23.48
$26.30
$28.14
$30.11
$31.61
Monthly Sewer Use Charge (Sewer Only Customers)
Rate per Account
$6.25
$9.99
$12.28
$13.76
$14.72
$15.75
$16.54
Consumption Charge
Rate per HCF
$0.35
$0.35
$0.43
$0.48
$0.52
$0.55
$nSs
Sewer Surcharges
Multi Unit surcharge (per DU)
$2.00
Note 1
Note 1
Note 1
Note 1
Note 1
Notc 1
Note I: The surcharge has been incorporated into the Monthly Sewer Use Charge under the revised structure.
CURRENT AND PROPOSED CUSTOMER BILL COMPARISONS
Figure 4 -5 presents a comparison of monthly customer bills using the current rate
structure and the recommended revised rate structure. The rates used to calculate the
revised bills are the FY 2015 -16 charges presented in Figure 4 -4. It is notable that current
customers who are subjected to the multiple dwelling $2.00 monthly surcharge will
experience a decrease in their monthly bill. This occurs based on the revisions to the
SS3 -29
monthly sewer use charge. The graduated rates, based on meter capacity, better reflect
associated flow assumed per dwelling unit, and its equivalent.
Figure 4 -5. Customer Bill Comparison
COMPARISON WITH NEIGHBORING AGENCIES
Based on available sources, Figure 4 -6 shows the recent charges for sewer service
among similar Orange County agencies, specifically ones that charge a fixed monthly
use charge coupled with a flow -based commodity charge. Larger agencies tend to have
lower rates because they can take advantage of economies of scale and have a larger
base of customers over which to distribute fixed costs. Figure 4-6 indicates that the
City's current and proposed sewer rates track the trend line along with its neighbors
(identified with red diamonds in Figure 4 -6).
SS3 -30
Number of
Average
Current
FY 15 -16
Dwelling
Monthly
Monthly
Monthly
Difference
Customer Name
Meter Size
Units
Flow(11CF)
Bill
Bill
($)
Single Family Residential (low flow)
5/8"-1"
1
2
$
5.20
$
8.20
$3.00
Single Family Residential (avg flow)
5/8"-V
1
11
$
8.35
$
12.07
$3.72
Single Family Residential (high flow;
5/8"-V
1
16
$
10.10
$
14.23
$4.13
Multi Family Residential
3"
55
243
$
209.55
$
117.09
($92.46)
Commercial
4"
1
595
$
224.75
$
270.82
$46.07
Commercial
8"
141
2,074
$
1,022.40
$
911.20
($111.20)
Commercial
6"
1
1,584
$
568.90
$
698.42
$129.52
COMPARISON WITH NEIGHBORING AGENCIES
Based on available sources, Figure 4 -6 shows the recent charges for sewer service
among similar Orange County agencies, specifically ones that charge a fixed monthly
use charge coupled with a flow -based commodity charge. Larger agencies tend to have
lower rates because they can take advantage of economies of scale and have a larger
base of customers over which to distribute fixed costs. Figure 4-6 indicates that the
City's current and proposed sewer rates track the trend line along with its neighbors
(identified with red diamonds in Figure 4 -6).
SS3 -30
Fioure 4 -6. Neiohborino Aoencv Comparison
$35
Irvine Ranch WD
$30
$25
31 $20
i
r
e
Buena Park
Seal Beach ■
$15
ar rove
Newport Beach - Proposed
� �ntinglon Beach
$10
■
$5
La Habra ■ Fullerton
Cosa Mesa SD
$0
0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000
Population of Service Area
SS3 -37
Cosa Mesa SD
SS3 -37
S. RECYCLED WATER PROJECTED REVENUE INCREASES
REVENUE REQUIREMENTS
The City's FY 2013 -14 revenue requirement served as the basis for determining the
revenue requirement projections through FY 2018 -19. Figure 5 -1 summarizes the
sources and assumptions for the data as well as the projected expenditure trends:
Figure 5 -1. Revenue Requirement Projections
Operatina Expenses
This cost category includes administration and overhead expenses that are calculated as
10% of the total recycled water revenue requirement and 1% of the budgeted general
fund overhead charged to the water fund, respectively. During the projection period,
the City's operating expenses are projected to increase gradually at about 1.73% per
year, based on the five -year historical average of general inflation for the Los Angeles
area.
Purchased Recycled Water
This cost category for FY 13 -14 was based on the actual water purchases in FY 12 -13
multiplied by the cost of purchased water from OCWD of $360 per acre foot. During the
projection period, the City's purchased water costs are projected to increase gradually
at about 1.88% per year, based on the five -year historical average of OCWD purchased
water charges per acre foot.
Pump Station Operating and Maintenance
This cost category for FY 13 -14 was based on the actual cost of inspections, scheduled
and corrective maintenance, source changeovers and pump station rehabilitation and
maintenance as provided by the city. During the projection period, the City's pump
station operating and maintenance costs are expected to increase gradually at about
1.73% per year, based on the five -year historical average of general inflation for the Los
Angeles area.
SS3 -32
FY 13 -14
FY 14 -15
FY 15 -16
FY 16 -17
FY 17 -18
FY 18 -19
Operating Costs
$ 40,488
$ 41,188
$ 41,901
$ 42,626
$ 43,363
$ 44,114
Purchased Recycled Water
167,598
173,417
179,438
182,810
186,245
189,745
Pump Station Operating & Maintenance
39,408
47,218
48,104
49,007
49,927
50,864
Depreciation
17,500
17,543
17,587
17,632
17,678
17,724
Total Revenue Requirement
$ 264,994
$ 279,366
$287,030
$ 292,075
$ 297,213
$ 302,446
Annual Change
5%
3%
2%
2%
2%
Operatina Expenses
This cost category includes administration and overhead expenses that are calculated as
10% of the total recycled water revenue requirement and 1% of the budgeted general
fund overhead charged to the water fund, respectively. During the projection period,
the City's operating expenses are projected to increase gradually at about 1.73% per
year, based on the five -year historical average of general inflation for the Los Angeles
area.
Purchased Recycled Water
This cost category for FY 13 -14 was based on the actual water purchases in FY 12 -13
multiplied by the cost of purchased water from OCWD of $360 per acre foot. During the
projection period, the City's purchased water costs are projected to increase gradually
at about 1.88% per year, based on the five -year historical average of OCWD purchased
water charges per acre foot.
Pump Station Operating and Maintenance
This cost category for FY 13 -14 was based on the actual cost of inspections, scheduled
and corrective maintenance, source changeovers and pump station rehabilitation and
maintenance as provided by the city. During the projection period, the City's pump
station operating and maintenance costs are expected to increase gradually at about
1.73% per year, based on the five -year historical average of general inflation for the Los
Angeles area.
SS3 -32
Depreciation
This cost category includes replacement costs for pump station facilities and water
meters. The annual pump station facility replacement cost was based on $600,000 in
construction costs, amortized over 40 years. The annual meter replacement cost was
based on the American Water Works Association's standard cost of $259 per meter per
year, amortized over 15 years. During the projection period, the City's pump station
facility replacement costs are held constant at $15,000 per year, while the meter
replacement costs are projected to increase gradually at about 1.73% per year, based on
the five -year historical average of inflation for the Los Angeles area.
r
SS3 -33
6. RECYCLED WATER RATE DESIGN
The following section was previously submitted as a separate report dated April 24,
2014. The City Council subsequently adopted the recommended rates in compliance
with Proposition 218, effective October 9, 2014. The following text summarizes the rates
documented in the April 2014 report and subsequently adopted by the City Council.
CURRENT RATE STRUCTURE
The City currently has five recycled water customers totaling 14 connections. These
customers pay the sum of two charges every month for water service: a basic service
charge based on the size of the service connection plus a commodity charge based on
metered water use during the billing period. In 1991, the City entered into an agreement
with OCWD for the distribution and sale of recycled water. The agreement stipulated
that the recycled water rate may not exceed 80% of the potable water rate. It is the City's
current practice to charge customers 80% of the potable water rate based on that
agreement.
PROPOSED RATE STRUCTURE
Under the new rate structure, the recycled water rates will no longer be linked to 80% of
the potable water rates. The proposed rate structure is based on the FY 2014 -15 revenue
requirement, and categorizes the expenses into three categories: fixed costs, variable
costs and pump station - related costs. Fixed costs are considered fixed because they do
not vary based on flow, and include the annual cost of meter reading and replacement,
as well as administrative and overhead. Variable costs vary because they are based on
the amount of water purchased, and therefore, are solely comprised of the annual cost
of purchased water from OCWD. Pump station - related costs are comprised of
inspections, maintenance, and rehabilitation & replacement that are directly related to
the pump stations. Figure 6 -1 presents the breakdown of the FY 2014 -15 revenue
requirement by cost category:
SS3 -34
ure 6 -1. FY 2014 -15 Revenue Requirement by Cost i
FY2014 -15
xed Costs
Administration
$25,433
Overhead
$12,208
Meter Reading
$1,514
Meter replacement
$2,543
Other agency fees
$2,035
)tal Fixed Costs
$43,73-
Variable Costs
Purchased Water $173,417
Total Variable Costs $173,417
Station Costs
Inspections $7,021
Maintenance $13,109
Rehab & Replacement $42,087
>talPump Station Costs $62,218
Total Revenue Requirement $279,366
In order to determine the monthly charge by size of connection, we first converted the
number of active meters to equivalent meter units (EMU) as shown in Figure 3 -2. The
EMU multiplier by meter size is the same multipliers used to determine the fixed
charge by meter size for potable water rates. The monthly charge for an EMU of 1.00 is
derived by dividing the total fixed costs of $43,732 by the total number of EMUs or
192.70. This quotient was then divided by 12 to convert from an annual charge of
$226.94 to a monthly charge of $18.91. The service charges were then graduated using
the EMU multipliers, the effect of which is to increase the service charges for the larger
services. Note the total annual revenue of $43.732 from fixed charges in Figure 6 -2 is
equal to the total fixed costs presented in Figure 6 -1.
SS3 -35
Fiaure 6 -2. Calculation of Monthly Fixed Charaes
The commodity and pump station charges were derived using the FY 2012 -13 monthly
meter readings in HCF for all customers, and FY 2012 -13 monthly meter readings for
pump station customers in HCF, respectively. Figure 6 -3 presents the derivation of the
proposed commodity and pump station charges for FY 2014 -15:
Figure
6-3. Calculation of Commoditv and Pump Station C
Total
FY14 -15
FY14 -15
Monthly
FY 14 -15
Cost Category Costs
Active
EMU
Total
Service
Annual
Meter Size
Accounts
Multiplier
EMUs
Charge
Revenue
a
b
a *b
c
a *c *12
5/8" or 3/4"
0
1.00
0
$18.91
$0
1"
0
1.67
0
$31.53
$0
11/2"
0
3.33
0
$63.05
$0
2"
8
5.33
42.67
$100.88
$9,684
3"
3
10.00
30.01
$189.15
$6,810
4"
0
16.67
0
$315.25
$0
6"
2
33.34
66.68
$630.50
$15,132
8"
1
53.34
53.34
$1,008.81
$12,106
14
192.70
$43,732
The commodity and pump station charges were derived using the FY 2012 -13 monthly
meter readings in HCF for all customers, and FY 2012 -13 monthly meter readings for
pump station customers in HCF, respectively. Figure 6 -3 presents the derivation of the
proposed commodity and pump station charges for FY 2014 -15:
Figure
6-3. Calculation of Commoditv and Pump Station C
:harges
Using the FY 2014 -15 rates as calculated in Figure 6 -2 and Figure 6 -3, a five -year rate
plan was prepared based on the City's recycled water revenue requirements as
presented in Figure 5 -1. The rates included in the five -year plan reflect 2% annual rate
increases across the board starting in Year 2 to keep pace with the increase in the
revenue requirements. The proposed five -year rate plan is shown in Figure 6-4.
SS3 -36
FY12 -13
FY14 -15
FY14 -15
Usage
Charge
Cost Category Costs
(HCF)
per HCF
Variable Costs $173,417
202,793
$0.86
Pump Station Costs $62,218
172,426
$0.36
:harges
Using the FY 2014 -15 rates as calculated in Figure 6 -2 and Figure 6 -3, a five -year rate
plan was prepared based on the City's recycled water revenue requirements as
presented in Figure 5 -1. The rates included in the five -year plan reflect 2% annual rate
increases across the board starting in Year 2 to keep pace with the increase in the
revenue requirements. The proposed five -year rate plan is shown in Figure 6-4.
SS3 -36
Fioure 6 -4. Five Year Recvcled Water Rate Proiections
Current FY 14 -15 FY 15 -16 FY 16 -17 FY 17 -18 FY 18 -19
Annual Rate Increases 2% 2% 2% 2%
Monthly Service Charge
5/8" or 3/4" $13.82 $18.91 $19.29 $19.68 $20.07 $20.47
1" $23.03 $31.53 $32.16 $32.80 $33.46 $34.13
1 1/2" $46.06 $63.05 $64.32 $65.60 $66.91 $68.25
2" $73.70 $100.88 $102.90 $104.95 $107.05 $109.19
3" $138.18 $189.15 $192.94 $196.80 $200.73 $204.75
4" $230.30 $315.25 $321.56 $327.99 $334.55 $341.24
6" $460.61 $630.50 $643.11 $655.98 $669.10 $682.48
8" $736.98 $1,008.81 $1,028.99 $1,049.57 $1,070.56 $1,091.97
Monthly Commodity Charge
Rate per HCF $2.46 $0.86 $0.87 $0.89 $0.91 $0.93
Monthly Pump Station Charge
Rate per HCF none $0.36 $0.37 $0.38 $0.38 $0.39
CUSTOMER BILL COMPARISONS
Figure 6 -5 presents a comparison of monthly customer bills using the current rate
structure and the recommended revised rate structure. The rates used to calculate the
revised bills are the Year 1 charges presented in Figure 64. It is notable that all current
recycled water customers will experience no less than a 44% bill decrease with the
recommended structure change.
tourer Name
vport Beach Country Club
Lady Queen of Angels
Canyon Country Club
Canyon Country Club
bluff School
�izure o -5. customer nin kom
Revised
Monthly Difference Difference
Bill
Average
( %)
$8,717
Monthly
Current
$230
Flow
Monthly
Meter Size
(HCF)
Bill
6"
6,650
$16,820
2"
151
$446
8"
5,256
$13,668
6"
2,463
$6,518
3"
321
$928
Revised
Monthly Difference Difference
Bill
($)
( %)
$8,717
($8,103)
-48%
$230
($215)
-48%
$5,504
($8,164)
-60%
$3,625
($2,894)
-440%
$464
($464)
-50%
SS3 -37
APPENDIX A. SEWER AND RECYLED WATER RATE MODEL
SS3 -38
SS3 -39
SS3 -40
Al 8
I C I D
I E I F F G H I I I J
I K L I M
I N 1 O
City of Newport Beach
Sewer Rate Study
Table 1A, Summary
_.L
_.L
3
4
5
Projected
6
Fiscal Year..
FY 2015 -16 FY 2016 -17 FY 2017.18 FY 2018 -19 FY 2019 -20 FY 2020 -21
FY 2021 -22 FY 2022 -23 FY 2023 -24
FY 2024 -25
7
Revenue Increases
Cumulative Increase
- Sewer
23.0% 12.0% 7.0% 7.0% 5.0% 3.0%
23.0% 37.8% 47.4% 57.7% 65.6% 70.6%
3.0% 1.0% 1.0%
75.7% 77.4% 79.2%
1.0%
81.0%
8
10
11
Salaries & Benefits
Operating Costs
Miscellaneous
Internal Service Allocation
i r i FY 2020-21
$ 1,523,240 $ 1580,451 $ 1,627,865 $ 1,676,701 $ 1,727,002 $ 1,778,812
995,721 989,549 1,006,668 1,024,084 1,041,800 1,059,823
33,000 33,571 34,152 34,743 35,344 35,955
670,581 682,182 693,984 705,990 718,203 730,628
r i 2023-24
$ 1,832,176 $ 1887,141 $ 1,943,755
1,078,158 1,096,811 1,115,785
36,577 37,210 37,854
743,268 756,127 769,208
FY 2024-25
$ 2,002,068
1,135,088
38,508
782,515
12
13
14
15
16
Storm Drain Operating
$0 $0 $0 $0 $0 $0
$0 $0 $0
$0
17
Storm Drain Capital
Sewer Operating Reserve Expense
Sewer Capital Reserve Expense
$0 $0 $0 $0 $0 $0
$37,497 $242,152 $214,690 $456,257 $224,189 $292,715
$500,000 $750,000 $1,000,000 $1,000,000 $1,300,000 $1,300,000
$0 $0 $0
$363,692 $330,122 $294,882
$1,300,000 $1,300,000 $1,300,000
$0
$257,919
$1,300,000
18
19
20
$ 3,760,039 $ 4,277,905 $ 4,577,358 $ 4,897,773 $ 5,046,538 $ 5,197,933
$ 5,353,871 $ 5,407,410 $ 5,461,484
$ 5,516,099
21
Annual increase 13.8% 7.0% 7.0% 3.0% 3.0%
3.0% 10% 1.0%
1.0%
22
23
24
zs
Year End Fund Balances -Funds 530 and 540
26
$4.0
�
27
Reserves with Rate
Target Balance Increase
28
79
30
$3.5
(Operations +Cap'
31
32
d
c $3.0
O
U
33
34
`♦
35
36
�
♦♦
a$0.5
37
38
C $2.5
39
♦
40
� $2.0
m
Re
41
42
inimum glance
FV 2019 -20 FY 2020 -21 FV 2021 -22
43
44
00
�`♦
(Operations)
45
v
C
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Ti
62
63
64
65
fib
SS3 -40
♦x
�
LL
d
U
`♦
N
♦♦
a$0.5
`1 Reserves without Rate
♦ Increase
♦
$0.0
FV 2014 -15 FV 2015 -16
FV 2016 -17 FV 2017 -18 FY 2018 -19
FV 2019 -20 FY 2020 -21 FV 2021 -22
FV 2022 -23 FV 2023 -24 FV 2024 -26
SS3 -40
SS3 -41
A I B
C D E F
G
H
I
J
K
L
M
N
1
City of Newport Beach
2
Sewer Rate Study
3
Table 1B. General
5
For acted
fi
FY 2015 -16 FY 2016.17 FY 2017 -18 FY 2018 -19
FY 2019 -20
FY 2020 -21
FY 2021 -22
FY 2022 -23
FY 2023 -24
FY 2024 -25 Source
Notes
7
Factors
8
a. Interest an Reserve Balance
0.75% 0.75% 0.75% 0.75%
0.75%
075%
0.75%
0.75%
0.75%
0.75%
City Estimate
To Table 4
9
b. General inflation
Per Budget 1.73% 1.73% 1.73%
1.73%
1 ]3%
1.73%
1.73%
1.73%
1.73%
US Statistics, LA Area &year average To Table 2
10
c. Personnel Increases
Per Budget 3.0% 3.0% 30%
3.0 %.
3.0%
3.0%
30%
3.0%
30%
Estimate
To Table
11
d. Benefits cost increases
Per Budget 5.0% 5.0% 5.0%
5.0%
5.0%
5.0%
5.0%
5.0%
5.0%
Estimate
To Table
12
e. Percent of Bad Debt
0.4% 0.4% 0.4% 0.4%
0.4%
0.4%
0.4%
0.4%
0.4%
0.4%
Based on City's Fund Worksheet
To Table 3A,3B
13
L Utilities Increases
Per Budget 1.73% 1.73% 1.73%
1.73%
1 ]3%
1.73%
1.73%
1.73%
1.73%
14
g. Pct. increase in Sewer Accounts
0.00% 0.00% 0.00% 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
To Table 3A
15
h. Pct. increase in Water Consumption (for flaw charge)
2.00% 0.00% 0.00% 0.00%
0.00%
040%
0.00%
0.00%
000%
0.00%
To Table 2,8
16
1. Percentage increase in Recycled Water Use
0.00% 0.00% 0.00% 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
To Table 2,3B
17
j. Construction cost inflation
Per Budget 2.00% 200% 2,00%
2.00%
200%
2.00%
2.00%
2.00%
2.00%
City Estimate
To Table 2B, 5
18
k. Percent increase in purchased recycled water rate
1.58% 3.47% 1.88% 1.88%
1.88%
188%
1.88%
1.88%
1.88%
1.88%
OCWD$ /AF 5 -year Average
To Table 28
19
20
21
Reserve Policies
22
Operations Fund
Purpose
Working capital for 08M cash flow during the year.
23
24
Funding priority
Highest. If not maintained, interfund loans are needed.
25
Minimum balance
50% of annual 01 is
26
27
Infrastructure Replacement Funds
Purpose
For wastewater master plan construction projects.
28
29
Funding priority
Second highest.
30
Target balance
No Minimum or Maximum. Should be reviewed periodically
31
32
Model Tables Included
33
Table 1A. Summary
34
Table 1B. General
35
Table 2A. Revenue Requirement Projection - Sewer
36
Table 2B. Revenue Requirement Projection- Recycled
Water
37
Table 3A. Revenue Increases - Sewer
38
Table 3B. Revenue Increases- Recycled Water
39
Table 4. Reserves
40
Table S. CIP
41
Table 7A. Rate Revenue -Sewer
42
Table 7B. Rate Revenue - Recycled Water
SS3 -41
SS3 -42
A B
C
D
E
F
G
H
I
J
K
L
N o
1
City of Newport Beach
2
Sewer Rate Study
3
Table 2A. Revenue Requirement Projection -Sewer
4
5
Table l8
Budgeted
Projected
6
Factors
FY 201546
FY 2016 -17
FY 2017 -18
FY 2018 -19
FY 2019 -20
FY 2020 -21
FY 2021 -22
FY 202243
FY 2023 -24
FY 2024 -25 Notes
7
OPERATING
EXPENSES
8
Salaries
7000
and Benefits
SALARIES - MISC
C.
$ 861,812
$887,666
$914,296
$941,725
$969,977
$999,076
$1,029,049
.$1,059,920
$1,091,718
$1,124,469
9
10
7020
SALARIES - PART TIME
tl.
-
$0
$0
$0
$0
$0
$0
$0
$0
$0
11
7040
OVERTIME, MISC & 1/2 TIME
c.
45,000
$46,350
$47,741
$49,173
$50,648
$52,167
$53,732
$55,344
$57,005
$58,715
12
7062
NIGHT DIFF, MISC
d.
-
$0
$0
$D
$0
$0
$D
$0
$0
$0
13
7063
CERTIFICATION PAY
C.
5,735
$5,907
$6,084
$6,267
$6,455
$6,648
$6,848
$7,053
$7,265
$7,483
14
7080
CALL BACK PAY
c.
35,000
$36,050
$37,132
$38,245
$39,393
$40,575
541,792
$43,046
$44,337
545,667
15
7114
CELL PHONE STIPEND EXP
d.
6,421
$6,742
$6,944
$7,153
$7,367
$7,588
$7,816
$8,050
$8,292
$8,541
16
7210
HEALTH /DENTALIVISION
tl.
240,625
$252,656
$260,236
$268,043
$276,084
$284,367
$292,898
$301,685
$310,735
$320,057
17
7223
ANNUAL OPEB COST
d.
41,826
$43,917
$45,235
$46,592
$47,990
$49,429
$50,912
$52,440
$54,013
$55,633
18
7227
RHS$2.50 CONTRIB
d.
7,350
$7,718
$7,949
$8,187
$8,433
$8,686
$8,947
$9,215
$9,492
$9,776
19
7290
LIFE INSURANCE
d.
1,260
$1,323
$1,363
$1,404
$1,445
$1,489
$1,534
$1,580
$1,627
$1,676
20
7295
EMPASSISTANCE PROGRAM
d.
292
$307
$316
$325
$335
$345
$355
$366
$377
$388
21
7370
WORKERS' COMP, MISC
d.
27,356
$28,724
$29,586
$30,473
$31,387
.$32,329
$33,299
$36,298
$35,327
$36,386
22
7373
COMPENSATED ABSENCES
J.
30,163
$31,671
$32,621
$33,600
$34,608
$35,646
$36.716
$37,817
$38,952
$40,120
23
7425
MEDICARE FRINGES
d.
13,739
$14,426
$14,859
$15,304
$15,764
$16,237
$16,724
$17,225
$17,742
$18,274
24
7439
PIERS MISC EE CNTRBN
d.
69,326
$72,792
$74,976
$77,225
$79,542
$81,928
$84,386
$86,918
$89,525
$92,211
25
7440
PERS MISC ER CNTRBN
d.
70,255
$73,768
$75,981
$78,260
$80,608
$83,026
$85,517
$88,083
$90,725
$93,447
26
7445
EE RET CNTRBN MISC
d.
(107,277)
(5112,641)
($116,020)
($119,501)
($123,088)
($128,778)
($130,582)
($134.499)
($138,534)
($142,690)
7
7446
PIERS UNFND LIAR MISC
d.
174,357
$183,075
$188,567
$194,224
$200,051
$206,052
$212,234
$218,601
$225,159
$231,914
28
Total Salaries and Benefits
1,523,240
1,580,451
1,627,865
1,676,701
1,727,002
1,778,812
1,832,176
1,887,141
1,943,755
2,002,068
29
38%
30%
30%
3D%
3.0%
3.0%
30%
30%
3.0%
30
Ooeratine
8003
Costs
GENRATR MAINT&REPR
b.
$ 17,500
$17,803
$1 8,111
$18,424
$18,743
$19,067
$19,397
$19,732
$20,074
$20,421
31
32
8004
CERT & MEMBERSHIP
b.
5,500
$5,595
$5,692
$5,790
$5,891
$5,992
$6,096
$6,202
$6,309
$6,418
33
8D20
AUTOMOTIVE SERVICE
b.
45,000
$45,779
$46,570
$47,376
$48,196
$49,030
$49,878
$50,741
$51,618
$52,511
34
8030
MAINT & REPAIR - EQUIP
b.
4,000
$4,069
$4,140
$4,211
$4,284
$4,358
$4,434
$4,510
$4,588
$4,668
35
8040
MAINT& REPAIR - BUILDING
b.
4,662
$4,743
$4,825
$4,908
54,993
$5,079
$5,167
$5,257
$5,348
$5,440
36
8060
PUBLICATIONS & DUES NOC
b.
1,000
$1,017
$1,035
$1,053
$1,071
$1,090
$1,108
$1,128
$1,147
$1,167
37
8070
RENTAVPROP & EQUIP NOC
b.
1,000
$1,017
$1,035
$1,053
$1,071
$1,090
$1,108
$1,128
$1,147
$1,167
38
8080
SERVICES -PROF & TECH NOC
b.
31,084
$31,622
$32,169
$32,725
$33,291
$33,867
$34,453
$35,049
$35,656
$36,273
39
8100
TRAVEL & MEETINGS NOC
b.
1,000
$1,017
$1,035
$1,053
$1,071
$1,090
$1,108
$1,128
$1,147
$1,167
40
8105
TRAINING
b.
9,250
$9,420
$9,583
$9,749
$9,91B
$10,089
$10,254
$10,441
$10,622
$10,806
41
8112
UTILITIES - TELEPHONE
f.
8,700
$8,851
$9.004
$9,159
$9,318
$9,479
$9,643
$9,610
$9,980
$10,152
42
8114
UTILITIES - NATURAL GAS
f.
1,000
$1,017
$1,035
$1,053
$1,071
$1,090
$1,108
$1,128
$1,147
$1,167
43
8116
UTILITIES - ELECTRICITY
f.
68,000
$69,176
$70,373
$71,591
$72,829
$74,089
$75,371
$76,675
$7B4O01
$79,351
44
8118
UTILITIES - WATER
f.
20,000
$20,346
$20,698
$21,056
$21,420
$21,791
$22,168
$22,551
$22,942
$23,338
45
8140
SUPPLIES - OFFICE NOC
b.
350
$356
$362
$368
$375
$381
$388
$395
$401
$408
46
8155
WASTEWATER ROOT CUTTING
b.
16,601
$16,888
$17,180
$17,478
$17,780
$18,088
$18,400
$18,719
$19.43
$19,372
47
8158
CCTV MAINTENANCE PROGRAM
b.
67,036
$88,542
$90,073
$91,632
$93,217
$94,830
$96,470
$98,139
$99,837
$101,564
48
8159
GREASE CNTRL DEVIINSPEC
b.
79,544
$80,920
$82,320
$83,744
$85,193
$86,667
$88,166
$89,691
$91,243
$92,822
49
8160
MAINT & REPAIR NOC
b.
211,007
$214,657
$218,371
$222,149
$225,992
$229,902
$233,879
$237,925
$242,041
$246,228
50
8184
MAINT - SCADA
b.
25,252
$25,689
$26,133
$26,585
$27,045
$27,513
$27,989
$28,473
$28,966
$2%467
51
8185
SEWER MANHOLE LINING PRGM
b.
75,000
$76,298
$7/,617
$78,960
$80,326
$81,716
$83,130
$84,568
$86,031
$87,519
52
8186
PUMP STATION MAINTENANCE
b.
13,000
$13,225
$13,454
$13,686
$13,923
$14,164
$14,409
$14,658
$14,912
$15,170
53
8187
ALLEY LATERAL REPL PRGM.
b.
43,500
$44,253
$45,018
$45,797
$46,589
$47,395
$48,215
$49,049
$49,898
$50,761
54
8188
SEWER MANHOLE MINT PRGM
b.
37,601
$38,251
$38,913
$39,586
$40,271
$40,968
$41,677
$42,398
$43,131
$43,877
55
8189
TREE ROOT FOAMING
b.
85,000
$86.471
$87,966
$89,488
$91,036
$92,611
$94,214
$95,843
$97,501
$99,188
56
8197
UTILITIES FAC MAIN PROGM
b.
20,375
$20,727
$21,086
$21,451
$21.822
$22,199
$22,584
$22,974
$23,372
$23,776
57
8200
SPECIAL DEPT SUPPLIES NOC
b.
15,000
$15,260
$15,523
$15,792
$16,065
$16,343
$16,626
$16,914
$17,206
$17,504
58
8204
UNIFORM EXPENSE
b.
5,000
$5,087
$5,174
$5,264
$5,355
$5,448
$5,542
$5,638
$5,735
$5,835
59
8239
CONCRETE MATERIALS
b.
2,000
$2,035
$2,070
$2,106
$2,142
$2,179
$2,217
$2,255
$2,294
$2,334
60
8240
TOOLS, INSTRUMENTS, ETC
b.
2,500
$2,543
$2,587
$2,632
$2,678
$2,724
$2,771
$2,819
$2,868
$2,917
61
8298
OTHER AGENCY FEES
b.
30,000
$30,519
$31,047
$31,584
$32,130
$32,686
$33,252
$33,827
$34,412
$35,008
62
8310
SOFTWARE LICENSE RENEWAL
b.
29,249
$29,755
$30,270
$30,793
$31,326
$31,868
$32,419
$32,980
$33,551
$34,131
63
Total Operating Casts
995,721
989,549
1,006,668
1,024,084
1,041,800
1,059,823
1,078,158
1,096,811
1,115,785
1,135,088
64
-06%
1.I%
1.7%
1.7%
1.7%
1.7T.
1.7%
1.7%
1.7%
65
Internal
8022
Service Allocations
EQUIP MAINT ISF
h.
$ 144,204
$146,699
$149,237
$151,818
$154,445
$157,117
$159,835
$162,600
$165,413
$168,275
66
67
8024
VEHICLE REPLACE ISF
b.
206,622
$210,197
$213,B33
$217,532
$221,296
$225,124
$229,019
$232,981
$237,011
$241,112
68
8318
IT ISF OPERATING CHARGE
b.
68,252
$69,433
$70,634
$71,856
$73,099
$74,364
$75,650
$76,959
$78,290
$79,645
69
83191T
ISF STRATEGIC CHARGE
b.
17,874
$18,183
$18,498
$18,818
$19,143
$19,475
$19,811
$20,154
$20,503
$20,858
70
8330
SVC CHARGE- ADMINISTRATIVE
b.
223,084
$226,943
$230,869
$234,864
$238,927
$243,060
$247,265
$251,543
$255,894
$260,321
71
8340
GENERAL INSURANCE
b.
10,545
$10,727
$10,913
$11,102
$11,294
$11,489
$11,688
$11,890
$12,096
$12,305
72
Total ISF Allocation
670,581
682,182
693,984
705,990
718,203
730,628
743,268
756,127
769,208
782,515
SS3 -42
SS3 -43
Al B I C
D I
E
I F I
G
I H I
I I
J I
K
I L I
M I
N 1
0
1
City of Newport Beach
2
Sewer Rate Study
3
Table 2A Revenue Requirement Projection -Sewer
4
5
Table I
Budgeted
Projected
6
Factors
FY 2015 -16
FY 2016 -17
FY 2017 -18
FY 2018 -19
FY 2019 -20
FY 2020 -21
FY 2021 -22
FY 202243
FY 2023 -24
FY 2024 -25
Notes
73
Miscellaneous
9000 OFFICE EQUIPMENT
b.
2,000
$2,035
$2,070
$2,106
$2,142
$2,179
$2,217
$2,255
$2,294
$2,334
74
75
9010 COMPUTER EQUIPMENT
b.
5,000
$5,087
$5,174
$5264
$5,355
$5,448
$5,542
$5,638
$5,735
.$5,835
76
9200 SHOP EQUIPMENT
b.
1,000
$1,017
$1,035
$1,053
$1,071
$1,090
$1,108
$1,128
$1,147
$1,167
77
9300 EQUIPMENT, N.O.C.
b.
25,000
$25,433
$25,872
$26,320
$26,775
$27,239
$27,710
$28,189
$28,677
$29,173
78
Total Miscellaneous Expenses
33,000
33,571
34,152
34,743
35,344
35,955
36,577
37,210
37,854
38,508
]9
80
Non -0Op.nd'na Revenue
5860 DAMAGE TO CITYPROPERTY
b.
$ -
$0
$0
$0
$0
$0
$0
$0
$0
$0
81
82
5870 REVENUE, NO C.
b.
$0
$0
$0
$0
$0
$0
$0
$0
$0
83
Total Non - Operating Revenue
84
Net Revenue Requirement (before Reserve Expense)
$ 3,222,542
S 3,285,753
$ 3,362,668
$ 3,441,516
$ 3,522,349
$ 3,605,218
$ 3,690,179
$ 3,777,288
S 3,866,602
$ 3,958,180
85
20%
23%
2.3%
2.3%
2.4%
24%
24%
24%
2.4%
66
RESERVE EXPENSE Tol(From)
87
Ops Support- Storm Orain Budget
88
Operations
b.
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 Fmm
Tads 1A
89
Capital Projects
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 From
T.W. to
90
Operating Reserve
37,497
242,152
214,690
456,257
224,189
292,715
363,692
330,122
294,882
257,919 Fmm
T.a.4
91
Infrastructure Replacement
500,000
750,000
1,000,000
1,000,000
1,300,000
1,300,000
1,300,000
1,300,000
1,300,000
1,300,000 Fmm
Taels4
92
Subtotal, Reserve Expense
$ 537,497
$ 992,152
$ 1,214,690
$ 1,456,257
$ 1,524,189
$ 1,592,715
$ 1,663,692
$ 1,630,122
$ 1,594,882
$ 1,557,919
93
94
Net Revenue Requirement
$3,760,039
$4,277,905
$4,577,358
$4,897,773
$5,046,538
$5,197,933
$5,353,871
$5,407,410
$5,461,484
$5,516,099 To T.ele an
95
tae%
70%
7 u
10%
3p%
3.0%
10%
10%
fo%
SS3 -43
Rate Study
2B. Revenue Requirement Projection - Recycled Water
Inpecu es
Table l6
Budget
$3,511
$3,571
$3,633
$3,696
$3,760
Projected
$3,891
$3,959
$4,027
Scheduled Production Maintenance
b.
Factions
FY 2015 -i6
FY 2016.17
FY 2017-18
FY 2019.19
FY 2019.20
FY 2020 -21
FY 2021.22
FY 2022.23
FY 2023 -N
FY 2024.25 F
ared Recycled Water Coats
1,579
$1606
$1.634
$1662
$1691
$1 ]20
$1,750
$1,780
51,611
$18,13
Conective Maintenance
b.
Purchased Water -OCWO
i,k
$ 167,598
$ 173,417
$179,438
$182,810
$4,268
$106,245
$169,745
$193,311
$196,943
$200,644
$204,414
Other agency fees
b.
$ 2000
$2935
$2,070
$$106
$789
$2,142
$2,179
$2,217
$2,255
$2,294
$2,334
Administration
d
25,000
$25,433
$25,872
$26,320
$21348
$26,775
$27,239
$27,710
$28,189
$28,677
$29,173
Overhead
b.
12,000
$12,208
$12419
$12,634
35,145
$12,852
$13,075
$13,301
$13,531
$13,765
$14,003
Meter Reading
b.
1,488
$1514
$1,540
$1.567
$1 594
$1621
$1,649
$1678
$1 707
$1,736 4 hourelmoMh Q$31Ihr
Total - Shared Recycled Water COSts
208,086
214,605
221,339
225.436
229,609
233859
238,187
242,596
247,087
251,661
Inpecu es
b. $
3,451
$3,511
$3,571
$3,633
$3,696
$3,760
$3,825
$3,891
$3,959
$4,027
Scheduled Production Maintenance
b.
1,877
$1,909
$1.943
$1,975
$2,1110
$2,045
$2,080
$2,116
$2.153
$2,190
Scheduled SCACA Maintenance
b.
1,579
$1606
$1.634
$1662
$1691
$1 ]20
$1,750
$1,780
51,611
$18,13
Conective Maintenance
b.
3.851
$3,918
$3,985
$4,054
$4,124
$4,196
$4,268
$4,342
$4,417
$4,494
Source Changeovers
b.
700
$712
$724
$737
$750
$763
$776
$789
$803
$817
Pump Station RehablMaimenance( pumper motors)
j.
11,280
$18,11
$18,956
$19,335
$19,722
$20,116
$20,519
$20,929
$21348
$21775 (pumps,motors)
Teal - Big Canyon Country Club
22,738
30,241
30,814
31,398
31,994
32,600
33,219
33,849
34,491
35,145
93.0%
1.8%
19%
1.9%
1.8%
1H%
1.B%
1.9%
18%
Inpec0on,
b. $
3,451
$3,511
$3,571
$3,633
$3,696
$3,760
$3,825
$3,891
$3,959
$4,027
Scheduled Production Maintenance
b.
1,468
$1,432
$1,457
$1,482
$1,508
$1,534
$1,561
$1,588
$1,615
$1,643
Scheduled SCACA Maintenance
b.
1,184
$1204
$1,225
$1247
$1268
$1,290
$1,312
$1335
$1358
$1382
Cm -narbe Maintenance
b.
2987
$3,039
$3,091
$3,145
$3,199
$3,254
$3,311
$3,368
$3,426
$3,486
Source Changeovers
b.
700
$712
$724
$737
$750
$763
$776
$789
$803
$817
Pump Station RabablMaintemme. (pumps motors)
j.
6,9ag
$7.079
$7,220
$7,365
$7,512
$7,662
$7,816
$7,972
$6,131
$8294 (pumps, motor.)
Total- Newport Beach Country Club
16,670
16,977
17,290
17,609
17,933
18,264
18,600
18,943
19,292
19,648
I..
f.a%
I..
1.a%
f.a%
18%
I..
1.9%
18%
Subtotal: Opera0nR Expenses S 247.494 S 261.80 $ 269.443 $ 274.443 S 279.535 $ 284,723 $ 290.006 S 295.308 $ 300,870 $ 306.454
SB% 26% 19% 1.9% 1.9% iH% I..
Pump Station Facility Replacement
$15,000 $15,000 $15,000 $15,000 $15,000 $15,000
$15,000 (mot, walls, concrete)
$2,917 $259lmeter year -City estimate (15- yr servlce lire)
1.36
SS3 -44
SS3 -45
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
City of Newport Beach
2
Water Rate Study
3
Table 3A. Revenue Increases - Sewer
4
Months
5
in 1st FY of
Est. Actual
Projected
6
rate increase'
FY 2013.14
FY 201546
FY 2016 -17
FY2017d8
FY 2018.19
FY2019 -20
FY 2020.21
FY 2021 -22
FY2022 -23
FY 2023.24
FY 2024 -25
Notes
7
8
Revenue from Rates without Rate Increases
Revenue from Cpthnnt Rates
$3,117.723
$3,117,723
$3,117,723
$3,117,723
$3,117,723
$3,117,723
$3,117.723
$3,117,723
$3,117,723
$3, 117,723
FYlV4 from Table 7A', Table 16, g.
9
10
Bad Debt Expense
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
($12,391)
11
Net Revenue
5 3,105,332
$ 3,105,332
S 3,105,332
5 3,105,332
$ 3,105,332
S 3,105,332
5 3,105,332
$ 3,105,332
S 3,105,332
5 3,105,332
12
Net Revenue Requirements
$3,760,039
$4,277,905
$4,577,358
$4,897,773
$5,046,538
$5,197,933
$5,353,871
$5,407,410
$5,461,484
$5,516,099
From Table
135urplus1(Deficit)
before rate increase
($854,707)
($1,172,574)
($1,472,027)
($1,792,442)
($1,941,208)
($2,092,802)
($2,248,540)
($2,302,079)
($2,356,1521
($2,410,767)
To Table
14
15
Revenue from Rates with Rate Increases
16
Increase In Revenue from Rates
23.0%
12.0%
7.00%
7.0%
5.0%
3.0%
3.0%
1.0%
1.07.
1.0%
From Table 1A
17
Cumulative Increase
206%
372%
468%
571%
61.9%
667%
71.74
734%
75.2%
769i%
To Table 1A
18
Total Revenue from Existing Rates
19
Revenue from Cunent Rates
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
$ 3,105,332
20
Revenue from Rate Increases
21
FYI 5- 16(edective 811115)
11
$654707
$714,226
$714,226
$714,226
$714,226
$714.226
$714,226
$714,226
$714.226
$714,226
22
FY16- 17 (effective 711116)
12
$458,347
$458,347
$458,347
$458,347
$458,347
$458,347
$458,347
$458,347
$458,347
23
FY17- 18 (effective 711117)
12
$29 %453
$299,453
$299,453
$299453
$299,453
$299,453
$299,453
$299,453
24
FY18- 19 (efective 711118)
12
$320,415
$228,868
$228.868
$228,868
$228,868
$228,868
$228.868
25
FY19- 20(e1fective 711119)
12
$240,311
$240,311
$240,311
$240,311
$240,311
$240,311
26
FY20 -21 (effective 711120)
12
$151,396
$151,396
$151,396
$151,396
$151,396
27
FY21- 22 (effective 71121)
12
$155,938
$155,938
$155,938
$155,938
28
FY22- 23 (egective 71122)
12
$53,539
$53,539
$53,539
29
FY23 -24 (e1fective 711123)
12
$54,074
$54,074
30
FY24 -25 (effective 711124)
12
$54,615
31
Subtotal- Revenue from Rate Increases
$654,707
$1,172,573
$1,472,027
$1,792,442
$1,941,206
$2,092,602
$2,248,540
$2,302,079
$2,356,153
$2,410,768
32
Total Rate Revenue
$ 3,117,723
$3,760,039
$4,277,905
$4577,358
$4,897,773
$5,045537
$5,197,933
$5,353,871
$5407,410
$5,461,484
$5,516,099
FY13-14from Table7A
33
Net Revenue Requirements
$ 2,845,911
$3,760,039
$4277,905
$4,577.358
$4,892773
$5046.538
$5,197.933
$5,353.871
$5.407,410
$5,461,484
$5,57099
From Table2
34
Surplual(Deficit) after Rate Increase
$271,012
(so)
($0)
($0)
(so)
($0)
$0
(so)
(so)
$0
$0
To Table4
35
36
- Estimated k ofmon(hs of collections in FYin which ate increase takes place
37
SS3 -45
SS3 -46
A
8 I
C I
D I
E I
F I
G I
H I
I I
J I
K I
L I
M I
N
I G
1
City of Newport Beach
2
Water Rate Study
3
Table 3B. Rise enua Increases - go ... led Water
Month.
5
In 1st FY of
Est Actual
Projected,
6
rat, increase'
FY 2012 -13
FY 2015 -16
FY 2016 -17
FY 209 -18
FY 2018 -19
FY 2019 -20
FY 2020 -21
FY 2021 -22
FY 202233 FY 2023 -24
FY 202485
#REFI
Note.
7
8
Revenue from Rates without Rate Increases
Revenue from Current Rates
$522,123
$522,123
$522,123
$522,123
$522,123
$522,123
$522,123
$522,123
$522,123
$522123
#REFI
Fb,12-13 fm. Table IS; Table 18. 1.
9
10
Bad Debt Expense
$0
$0
$0
$o
$0
$0
$o
$0
$0
$0
#REFI
11
Net Revenue
3 522,123
$ 522,123
11 522,123
$ 522,123
$ 522123
$ 522,123
$ 522123
$ 522.123 $
522,123
$ 522,123
#REFI
12
Net Revenue Requirements
$264,994
$279,366
$287.030
$292075
$297,213
$302,446
8307,777
$313,207
$318,738
$324,371
#REFI
F(13 -14 from City, escalated, by CPI
13
Surplusl(Defcft) before rate increase
$257,129
$242,758
$235,092
$230,048
$224,910
$219,676
$214,346
$208,916
$203,385
$197,752
#REF!
14
15
Revenue from Rates with Rate Increases
16
Increase in Revenue from Rates
0.D%
.50.0%
0.0%
0.0%
0.0%
0.0%
D.0%
0.0%
0.0%
D.0%
0.0%
17
Cumulative lectures
00%
.5001%
-500%
-500%
-5001t
-500%
-500%
500%
-500%
-500%
#REF'
18
Total Revenue from Existing Rates
19
Revenue from Current Rate.
$ 522,123
$ 522,123
$ 52$123
$ 522,123
$ 522,123
$ 522,123
3 522,123
$ 522123 $
522,123
3 522,123
#REF!
20
Revenue from Rate Increases
22
FY14.15(effective 711114)
12
($261.061)
(5261081)
($261.081)
($261 061)
($261061)
(V61,051)
($261 061)
($261.061)
($261 081)
#REF!
23
F(15- 16(effectew 711115)
12
$0
$0
$0
$0
$0
$0
$0
$0
#REFI
24
FY16- 17(effective 711116)
12
$0
$0
$0
$D
$o
$0
$D
#REFI
25
Fill 7- 18(affective Vill 7)
12
$0
$0
$0
$o
$0
$D
PRIDE!
26
FY18- 19(effective 711118)
12
$0
$0
$0
$0
$0
#REF.
27
FY19- 20(effective 711119)
12
$0
$0
$0
$0
#REF!
28
FUC-21 (e6esty. 711120)
12
$0
$0
$0
6RER
29
FY21- 22 (egeviive Ili l2l)
12
$0
$0
#REFI
30
FY22- 23 (effective 711 M)
12
$D
#REF!
31
FY23- 24 (effective 711 23)
12
#REF!
32
Subtotal - Revenue from Rate Increases
$0
($261,061)
($261,061)
($261,061)
($261,061)
($281,081)
($261,061)
($261,061)
($261,061)
($261,081)
#REFI
33
Total Rata Revenue
$ 51
$522,123
$281,061
3261061
$261,061
$261,061
$261,061
$261,061
$261,061
$261,061
$261,061
#REF!
34
Net Revenue Requirements
$264,994
$279366
5287,030
$292075
$297213
$302046
5307,777
$313207
$318,738
$324,371
41REFI
35
Surplu.l(Deficit) after Rata Increase
$522,123
$257,129
($18,305)
($25,969)
($31,013)
($36,152)
($41,385)
($46,718)
($52.140)
($57,678)
($63,310)
#REFI
To Table
36
37
- Estimated #ofmonths of collections In FY in which sale Increase
takes place
38
SS3 -46
SS3 -47
B1 C
D I
E I
F I
G I
IT I
I I
J I
K I
L I
M I
N
1 O
1
City of Newport Beach
Sewer Rate Study
Table 4. Reserves
Budgeted
FY 2014.15
FY 2015 -16
FY 2016 -17
FY 2017.18
FY 2018 -19
Projected
FY 2019 -20 FY 2020.21
FY 2021 -22
FY 2022 -23
FY 2023.24
FY 2024 -25
Notes
2
3
4
5
6
Sewer Operating Reserve Funds With Rate
Revenue Increase
Annual increases
Cumulative increase
Operations Fund
Beginning Balance
Surplusl(Defidt)
Transfers (to) /from
Revenue Requirement
Infrastructure Replacement Fund
Subtotal - Transfers
Subtotal- Fund Balance
Estimated Interest Earnings
Increase (5301
23.0%
23.0%
$1,170,008
($0)
37,497
$37,497
$1,207,505
$8,916
12.0%
37.8%
$1,216,421
($0)
242,152
$242,152
$1,458,572
$10,031
7.0%
47.4%
$1,468,604
(SO)
214,690
$214,690
$1,683,293
$11,820
7.0%
57.7%
$1,695,113
($0)
456,257
($400,000)
$56,257
$1,751,370
$12,924
5.0%
65.6%
$1,764,294
(SO)
224,189
($250,000)
($25,811)
$1,738,482
$13,135
3.0%
70.6%
$1,751,618
$0
292,715
($300,000)
($7,285)
$1,744,333
$13,110
3.0%
75.7%
$1,757,443
($0)
363,692
($300,000)
$63,692
$1,821,135
$13,420
1.0%
77.4%
$1,834,554
($0)
330,122
($300,000)
$30.122
$1,864,676
$13,872
1.0%
79.2%
$1,878,549
$0
294,882
($225,000)
$69,882
$1,948,431
$14,351
1.0%
81.0%
$1,962,782
$0
257,919
($225,000)
$32,919
$1,995,701
$14,844
From Table lA
From Table 3A
To Table 2
(to) /from below
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Ending Balance
Minimum Balance
1,170,008
51422956
$1,216,421
$1,611,271
$1,468,604
$1,642,877
$1,695,113
$1,681,334
$1,764,294
$1,720,758
$1,751,618
$1,761,174
$1,757,443
$1,802,609
$1,834,554
$1,845,090
$1,878,549
$1.888,644
$1,962,782
$1,933,301
$2,010,545
$1.979,090
50 %of annual O&M
22
23
Sewer Infrastructure Replacement Reserve
Beginning Balance
Capital Improvement Projects
Transfers (to)lfrom
Revenue Requirements
Operations Fund
Subtotal - Transfers
Subtotal- Fund Balance
Estimated Interest Earnings
(540)
$695,095
($500,000)
$500,000
$0
$500,000
$695,095
$5,213
$700,308
($765,000)
$750,000
$0
$750,000
$685,308
$5,196
$690,504
($1,040,400)
$1,000,000
$0
$1,000,000
$650,104
$5,027
$655,132
($1,061,208)
$1,000,000
$400000
$1,400,000
$993,924
$6,184
$1,000,108
($1,407,162)
$1,300,000
$250,000
$1,550,000
$1,142,946
$8,036
$1,150,982
($1,435,305)
$1,300,000
$300,000
$1,600,000
$1,315,677
$9,250
$1,324,927
($1,464,011)
$1,300,000
$300,000
$1,600,000
$1,460,916
$10,447
$1,471,363
($1,493,291)
$1,300,000
$300,000
$1,600,000
$1,578,071
$11,435
$1,589,507
($1,523,157)
$1,300,000
$225,000
$1,525,000
$1,591,350
$11,928
$1,603,278
($1,553,620)
$1,300,000
$225,000
$1,525,000
$1,574,658
$11,917
From Table 5
From Table 1A
(to)Rrom above
24
25
26
27
28
29
30
31
32
33
Ending Balance
Target Balance
695,095
51500.000
$700,308
$1,500,000
$690,504
$1,500000
$655,132
$1.500,000
$1,000,108
$1,500,000
$1,150,982
$1,500,000
$1,324,927
$1.500,000
$1,471,363
$1,500,000
$1,589,507
$1500,000
$1,603,278
$1.500,000
$1,586,575
$1,500,000
Average Annual CIP(per 20-Y
341
35
Recycled Water Infrastructure Replacement
Revenue Increase
Annual increases
Cumulative increase
Beginning Balance
Surplus/(Deficit)
Reimbursement to Water Fund
Subtotal - Funtl Expenditures
Subtotal- Fund Balance
Estimated Interest Earnings
Reserve
0.0%
-
$257,129
$0
257,129
$964
-
60.0%
258,094
($18,305)
$0
239,789
$1,867
--
0.0%
241,656
($25,969)
$0
215,687
$1,715
0.0%
217,402
($31,013)
$0
186,388
$1,514
0.0%
187,902
($36,152)
$0
151,751
$1,274
0.0%
153,025
($41,385)
$0
111,640
$992
0.0%
112,632
($46,716)
$0
65,916
$670
0.0%
66,586
($52,146)
$0
14,440
$304
0.0%
14,744
($57,676)
$0
(42,932)
$0
0.0%
(42,932)
($63,310)
$0
(106,242)
$0
From Table 3B
From Table 3B
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Ending Balance
$258,094
$241,656
$217,402
$187,902
$153,025
$112,632
$66,586
$14,744
$42,932
$106,242
SS3 -47
SS3 -48
A I B
C
D
E
F
G
H
I
J
K
L M
1
City of Newport Beach
Water Rate Study
Table 5. CIP
Project # Project Name
FY 2015.16
FY 2016.17 FY 2017.18
FY 2018.19
FY 2019.20 FY 2020 -21
FY 2021 -22 FY 2022.23 FY 2023.24 FY 2024.25 Total Cost
2
3
4
_.L
6
C2002049 Grade Adjustments: Sewer Manhole Covers
C7002005 Saint James Rd. Sewer Relocation
C6002016 SCADA System Upgrade
C7001003 WW Master Plan Improvements
Additional Capital Funding
Total Projects
Total Operating
Total Replacement
Total Unfunded
Total Annual Project Cost
Construction COST Inflation
Inflated Operating Total
Inflated Replacement Total
Inflated Unfunded Total
Source: City of Newport Beach WW CIP 13 -14
$100,000
$225,000
$100,000
$75,000
$0
$500,000
$0
$500,000
$0
$500,000
0.0%
$0
$500,000
$0
$750,000
$750,000
$0
$750,000
$0
$750.000
2.0%
$0
$765,000
$0
$1,000,000
$1,000,000
$0
$1,000,000
$0
$1,000,000
2.0%
$0
$1,040,400
$0
$1,000,000
$1,000,000
$0
$1,000,000
$0
$1,000,000
2.0%
$0
$1,061,208
$0
$1,300,000
$1,300,000
$0
$1,300,000
$0
$1,300.000
2.0%
$0
$1,407,162
$0
$1,300,000
$1,300,000
$0
$1,300,000
$0
$1,300,000
2.0%
$0
$1,435,305
$0
$1,300,000
$1,300,000
$0
$1,300,000
$0
$1,300,000
2.0%
$0
$1,464,011
$0
$1,300,000
$1,300,000
$0
$1,300,000
$0
$1,300,000
2.0%
$0
$1,493,291
$0
$1,300,000
$1,300,000
$0
$1,300,000
$0
$1,300,000
2.0%
$0
$1,523,157
$0
$ 100,000
$ 225,000
$ 100,000
$ 75,000
$1,300,000 $ 10,550,000
$1,300,000 $11,050,000
$0 $ -
$1,300,000 $ 11,050,000
$0 $
$1,300,000 $11,050,000
2.0%
$0 $ -
$1,553,620 $ 12,243,155
$0 $ -
7
6
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
SS3 -48
Rate Study
7A. Rate Revenue - Sewer
Source: SWR_RCY study_meter count - Service 980 Meters Only - Active Accounts
FY11 -12 FY11 -12 FYI 1-12
customer Class No Of Acct. Charge /acct Annual Revenue
SWR 485 $ 6.25 $ 36,375
Source: SWR_RCY study_meter count - SWR Accounts Only
FY11 -12
FY11 -12
FY11 -12
FY11 -12
FYI 1-12
FY11 -12
FY11 -12
Charge /DU
FY11 -12
customer Class
Meter Count
Charge
/meter
Annual
Revenue
Meter Count
WW Surchg
Annual
Revenue
5/8"
15,354
$
4.50
$
829,116
$ 2.00
$
1,008
$ 48,746
3/4"
3
$
4.50
$
162
'LE FAMILY RES
81
$ 2.00
$
1"
6,276
$
4.50
$
338,904
15,648
$ 15,768
-
10960
1.5"
364
$
4.50
$
19,656
0.35
$ -
No Sewer Charge
2"
886
$
4.50
$
47,844
478
$ 10.00
$
57,360
2.5"
1
$
4.50
$
54
0
$ 10.00
$
-
3"
34
$
4.50
$
1,836
35
$ 10.00
$
4,200
4"
119
$
4.50
$
6,426
90
$ 10.00
$
10,800
6"
54
$
4.50
$
2,916
47
$ 10.00
$
5,640
8"
11
$
4.50
$
594
6
$ 10.00
$
720
10"
2
$
4.50
$
108
0
$ 10.00
$
23,104
$
1,247,616
656
$
78,720
Source: SWR_RCY study_meter count - Service 980 Meters Only - Active Accounts
FY11 -12 FY11 -12 FYI 1-12
customer Class No Of Acct. Charge /acct Annual Revenue
SWR 485 $ 6.25 $ 36,375
Source: SWR_RCY study_meter count - SWR Accounts Only
FY 11 -12 Customer Billing Analysis Service 901, 903- Sewer Svc Multi/Bi- monthly, Sewer Svc MulWonthly and 904,910 SWR SRV HOSP- HOT /Bi-MO and Monthly
FY11 -12
FY11 -12
FY11 -12
FY11 -12
FY11 -12
!omer Class
NO of DUs
Charge /DU
Annual
Revenue
Annual Revenue
TI FAMILY RES
8477
$ 2.00
$
203,448
$ 1,327
IMERICAL
759
$ 2.00
$
18,216
$ 48,746
'METER
42
$ 2.00
$
1,008
$ 48,746
ISOLIDATED
949
$ 2.00
$
22,776
$ 816
'LE FAMILY RES
81
$ 2.00
$
1,944
$ 48
IER ONLY
652
$ 2.00
$
15,648
$ 15,768
-
10960
0.35
$
263,040
$ 115,452
FY 11 -12 Customer Billing Analysis Service 901, 903- Sewer Svc Multi/Bi- monthly, Sewer Svc MulWonthly and 904,910 SWR SRV HOSP- HOT /Bi-MO and Monthly
ce: Email from George Murdoch dated 412712015 for FY13 -14 metered water use
Calculated Revenue
from Customer Billing Data
$ 3,576,563 To Table 3A $ 12.90
$ 3,321,344
$ 255,219
SS3 -49
FY 2013 -14
FY11 -12
FY 2013 -14
:omer Class
Consumption
Charge /CCF
Annual Revenue
;LE FAMILY RES
2,982,858
$
0.35
$ 1,044,000
TI FAMILY RES
919,160
$
0.35
$ 321,706
'METER
-
$
0.35
$ -
No Consumption Charge - Only Fixed Fee
1MERICAL
1,312,620
$
0.35
$ 459,417
IL
29,248
$
0.35
$ 10,237
SOLIDATED
-
$
0.35
$ -
T DOCK
-
$
0.35
$ -
No Sewer Charge
INKLER
-
$
0.35
$ -
No Sewer Charge
-
$
0.35
$ -
No Sewer Charge
IP STATION
$
0.35
$
No Sewer Charge
5,243,886
$ 1,835,360
Mandatory Cutbacks @25%
(1,310,972)
$
0.35
$ (458,840)
Consumption Revenue (estm.)
3,932,915
$ 1,376,520
0.35
ce: Email from George Murdoch dated 412712015 for FY13 -14 metered water use
Calculated Revenue
from Customer Billing Data
$ 3,576,563 To Table 3A $ 12.90
$ 3,321,344
$ 255,219
SS3 -49
SS3 -50
A
B
C
D
E
F
G
H I J K
L M
N
O
1
City of Newport Beach
Sewer Rate Study
Table 7B. Rate Revenue - Recycled Water
Breakdown of Recycled Water Costs
Fixed Costs (borne regardless of flow)
Variable Costs (related to flow)
Pump Station Costs
Total - Recycled Water Costs
Total Metered Flow
Total Pump Station Flow
Charge per HCF - All Customers
Charge per HCF - Pump Station
Mo. Service Charge
5/8" or 3/4"
1"
11/2"
2"
3"
4"
6"
8"
Newport Beach Commodity Charge (per HCF)
Pump Station Charge (per HCF)
Total Recycled Water Revenue
IPer GAP Workbooks - Monthly Meter Reads
July
August
September
October
November
December
January
February
March
April
May
June
Total Active
Accounts
(excid City)
0
0
0
1
1
0
2
1
5
202,793
Total
FY12 -13
31,828
31,058
13,620
11,962
6,881
675
4,032
6,369
12,458
26,488
29,488
27,934
202,793
Current
Monthly
Service Annual
Charge Revenue
$ 13.82 $ -
$ 2103 $ -
$ 46.06 $ -
$ 73.70 $ 884
$ 138.18 $ 1,658
$ 230.30 $ -
$ 460.61 $ 11,055
$ 736.98 $ 8,844
$ 22,441
$ 2.46 $499,682
$522,123
CC Usage Total
FY12 -13 FY11 -12
27,605 30,285
26,326 31,311
10,963 11,132
9,778 8,502
5,541 3,082
579
3,188 6,156
5,282 7,140
10,791 9,481
22,844 12,562
25,733 29,175
23,796 28,180
172,426 177,006
85%
FY14 -15
$43,732 From Table 7B
173,417 From TableP
62,218 From Table 2B
$279,366
202,793 From Bro.
172,426 From Below
$0.86
$0.36
Revised
Total Monthly
Active EMU Total Service Annual
Accounts Multiplier EMUS Charge Revenue
0 1.00 0 $18.91 $0
0 1.67 0 $31.53 $0
0 3.33 0 $63.05 $0
8 533 42.673 $100.88 $9,684
3 10.00 30.005 $189.15 $6,810
0 16.67 0 $315.25 $0
2 33.34 66.677 $630.50 $15,132
1 53.34 53 $1,008.81 $12,106
14 193 $43,732
$0.86 $173,417
$0.36 $62,218
$279,366 To Table 3B
To Table 2B
Water
Rates
$ 17.27
$ 28.79
$ 57.58
$ 92.12
$ 172.73
$ 287.88
$ 575.76
$ 921.22
Water
Multiplier
1.00
1.67
3.33
5.33
10.00
16.67
33.34
53.34
_L
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
SS3 -50
IV
HF.H
HF &H Consultants, LLC
201 N. Civic Drive, Suite 230
Walnut Creek, CA 94596
SS3 -51
c1ir_TyOW1614,r9:3
Meter Size r
1
5/8 in
11111111111111W
2 in
6 in
6 in
Usage(HCF)
15
446
Fixed Fee Charge $
1608
Fixed Fee Charge
$
4.50
$
14.50
$
14.50
Variable Fee Charge
$
0.35
$
0.35
$
0.35
Total Monthly Charge
$
9.75
$
170.60
$
577.30
Total Bi- Monthly Charge
$
19.50
$
341.20
Meter Size
1
5/8 in
2 in
2 in
6 in
ii
Usage(HCF)
15
446
Fixed Fee Charge $
1608
Fixed Fee Charge
$
7.34
$
11.01
$
16.51
Variable Fee Charge
$
0.43
$
0.43
$
0.43
Total Monthly Charge
$
13.79
$
202.79
$
707.95
Total Bi- Monthly Charge
$
27.58
$
405.58
Meter Size
Ir
5/8 in
2 in
2 in
6 in
6 in
Usage(HCF)
15
446
Fixed Fee Charge $
1608
Fixed Fee Charge
$
8.47
$
13.19
$
19.78
Variable Fee Charge
$
0.52
$
0.52
$
0.52
Total Monthly Charge
$
16.27
$
245.11
$
855.94
Total Bi- Monthly Charge
$
32.54
$
490.22
Meter Size I=
5/8 in
2 in
6 in
Usage(HCF)
15
446
1608
Fixed Fee Charge $
9.34
$
14.82
$
22.23
Variable Fee Charge $
0.58
$
0.58
$
0.58
Total Monthly Charge $
18.04
$
273.50
$
954.87
Total Bi- Monthly Charge $
36.08
$
547.00
SS3 -52