HomeMy WebLinkAboutRESO 10245Resolution Approving Tier 2 Drought Response Implementation Plan 1
6056956 21488606.4
RESOLUTION NO. 10245
Resolution of the Council of the City of Palo Alto Approving Tier 2 Drought Response
Implementation Plan Pursuant to Section 3.11.C of the Amended and Restated Water Supply
Agreement
R E C I T A L S
A. The City of Palo Alto is one of twenty-six (26) agencies in San Mateo, Santa Clara
and Alameda Counties (Wholesale Customers) which purchase water from the City and County
of San Francisco (San Francisco) pursuant to a Water Supply Agreement entered into in 2009,
and recently amended in 2018, 2021 and 2025 (the Agreement or WSA). Collectively these 26
agencies are referred to in the Agreement as Wholesale Customers; and
B. Section 3.11 of the Agreement addresses situations when insufficient water is
available in the San Francisco Regional Water System (RWS) to meet the full demands of all
users. Section 3.11.C provides that during periods of water shortage caused by drought, the
San Francisco Public Utilities Commission (SFPUC) will allocate available water between its retail
customers and the Wholesale Customers collectively, in accordance with a schedule contained
in the Water Shortage Allocation Plan set forth in Attachment H to the Agreement (Tier 1 Plan);
and
C. Section 3.11.C authorizes the Wholesale Customers to adopt a Drought
Allocation Plan, including a methodology for allocating the available water among the individual
Wholesale Customers (Tier 2 Plan). The WSA also commits the SFPUC to honor allocations of
water unanimously agreed to by all Wholesale Customers or, if unanimous agreement cannot
be achieved, water allocations that have been adopted by the Board of Directors of the Bay
Area Water Supply and Conservation Agency (BAWSCA). The Agreement also provides that the
SFPUC can allocate water supplies as necessary during a water shortage emergency if no agreed
upon plan for water allocation has been adopted by the 26 Wholesale Customers or the
BAWSCA Board of Directors; and
D. Commencing in January 2022, representatives appointed by the managers of
each of the Wholesale Customers began meeting monthly to develop a set of principles to serve
as guidelines for an equitable allocation methodology, and to develop formulas and
procedures, in order to implement those principles. These discussions, and supporting
technical analyses, have been conducted with the assistance of BAWSCA; and
E. The Tier 2 Plan, attached to this resolution as Exhibit A, has been endorsed by all
of the Wholesale Customer representatives who participated in the formulation process and
they have each recommended that it be formally a dopted by the governing body of their
respective agencies; and
F. The Tier 2 Plan allocates the collective Wholesale Customer share of RWS supply
made available by the SFPUC among each of the 26 Wholesale Customers through December
31, 2034 and is coordinated with the term of the Agreement, and extension and renewal terms.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Resolution Approving Tier 2 Drought Response Implementation Plan 2
6056956 21488606.4
The Council of the City of Palo Alto does hereby RESOLVE as follows:
Section 1. The Tier 2 Drought Response Implementation Plan, as attached as Exhibit A
(Tier 2 Plan), is approved.
Section 2. This approval is conditioned upon all of the other twenty-five Wholesale
Customers approving the Tier 2 Plan, such approvals being evidenced through adoption of
similar resolutions or, in the case of private-sector organizations, by other equivalently binding
written commitments signed by an executive officer acting within the scope of delegated
authority, and all such approvals occurring on or before December 31, 2025.
Section 3. If such resolutions or binding commitments are not adopted by that date, this
resolution will automatically expire and be of no further effect after December 31, 2025, unless
it has been extended prior thereto by further action of this [Council, Board, etc.].
Section 4. The Council finds that adoption of this resolution is categorically exempt from
the California Environmental Quality Act as an action taken by a regulatory agency for the
protection of natural resources (CEQA Guidelines Section 15307), and an as action taken by a
regulatory agency for protection of the environment (CEQA Guidelines S ection 15308).
INTRODUCED AND PASSED: AUGUST 11, 2025
AYES: BURT, LAUING, LU, RECKDAHL, STONE, VEENKER
NOES:
ABSTENTIONS:
ABSENT: LYTHCOTT-HAIMS
ATTEST:
City Clerk Mayor
APPROVED AS TO FORM: APPROVED:
Assistant City Attorney City Manager
Director of Utilities
Director of Administrative Services
Attachment: Exhibit A. Tier 2 Drought Response Plan and Example Tier 2 Plan Excel-Based Model
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Tier 2 Drought
Response
Implementation
Plan
Drought Shortage
Allocation Plan for the
Regional Water System
Wholesale Customers
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
i
21418818.2
Table of Contents
1. Introduction ........................................................................................................................ 1
2. Relationship to Water Supply Agreement ........................................................................... 1
3. Development Process ........................................................................................................ 1
4. Plan Policy Principles ......................................................................................................... 2
5. Allocation Formula .............................................................................................................. 2
Base Period Calculations................................................................................................ 2
Tier 2 Plan Allocation Formula Inputs ............................................................................. 2
Step 0: Establish SFPUC Minimum and Maximum Cutback ........................................... 3
Step 1: Efficient Residential Allocation............................................................................ 4
Step 2: Non-Residential Base Allocation ........................................................................ 4
Step 3: SFPUC Maximum Cutback Reserve................................................................... 5
Step 4: Seasonal Allocation ............................................................................................ 5
Step 5: SFPUC Purchases and ISG-Based Allocation .................................................... 5
6. Plan Implementation ........................................................................................................... 5
7. Plan Term .......................................................................................................................... 6
Attachments
Attachment A: List of Abbreviations and Definitions ................................................................... 8
Attachment B: Tier 2 Plan Data Sources and Calculations ........................................................10
Attachment C: Example of Tier 2 Plan Excel-Based Model Calculations ...................................15
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 1 of 19
21418818.2
1. Introduction
The Tier 2 Drought Response Implementation Plan (the “Plan” or “Tier 2 Plan”) describes the
method for allocating the water made available by the San Francisco Regional Water System
(“RWS”) among the Wholesale Customers during shortages caused by Drought. This Plan is
adopted pursuant to Section 3.11(C) of the Amended and Restated Water Supply Agreement
between the City and County of San Francisco and the Wholesale Customers in Alameda, San
Mateo, and Santa Clara Counties (the “WSA”).
2.Relationship to Water Supply Agreement
The WSA includes a Water Shortage Allocation Plan which, among other things, (a) provides for
the allocation of available water between Retail Customers (e.g., retail water customers within
the City and County of San Francisco) and the Wholesale Customers collectively during system-
wide water shortages of 20 percent or less, (b) contemplates the adoption by the Wholesale
Customers of this Plan for allocation of the Wholesale Customers share of available water, (c)
commits the SFPUC to implement this Plan, (d) provides for banking of unused allocation, and
(e)provides for the transfer of both banked water and shortage allocations between and among
the Wholesale Customers and commits the SFPUC to implement such transfers. That plan is
referred to as the Tier 1 Plan and is included as Attachment H to the WSA.
The Tier 1 Plan also provides the methodology for determining the Overall Average Wholesale
Customer Reduction, expressed as a percentage cutback from prior year’s normal SFPUC
purchases, and Overall Wholesale Customer Allocation, in million gallons per day (MGD), both
of which are used in determining the final Allocation Factor for each Wholesale Customer. The
Overall Average Wholesale Customer Reduction is determined by dividing the volume of water
available to the Wholesale Customers (the “Overall Wholesale Customer Allocation” or “Tier 1
Allocation”), shown as a share of available water in Section 2 of the Tier 1 Plan, by the prior
year’s normal total Wholesale Customers’ RWS purchases and subtracting that value from one.
3.Development Process
Between January 2022 and June 2024, Bay Area Water Supply and Conservation Agency
(BAWSCA), supported by Woodard & Curran technical consultants, facilitated negotiations
between the Wholesale Customers through a series of meetings, workshops, and workgroups to
develop a formula and implementation plan to allocate RWS supplies in the event of shortage
caused by a SFPUC declared Drought, as defined in the WSA. These meetings, workshops,
and workgroups provided a forum for in-depth discussion of the objectives, mechanics, and
policy aspects of the elements of an updated Plan.
The Wholesale Customers began negotiations by reviewing the prior Plan, then discussed and
agreed upon four policy principles to lay the foundation for a revised Plan. BAWSCA, with
support from Woodard & Curran as the technical consultant team, introduced potential elements
of a formula to align with the agreed upon policy principles. In monthly workshops, the
Wholesale Customers discussed these options and provided feedback on which elements
should be included in the Plan, along with suggested refinements. These workshops, and the
discussions, suggestions, and comments expressed by the Wholesale Customers during this
process, were the primary forum through which this Plan was developed.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 2 of 19
21418818.2
4. Plan Policy Principles
The Wholesale Customers collectively developed four policy principles (the “Policy Principles”)
to guide the development and performance of the Tier 2 Plan. The Tier 2 Plan and associated
Tier 2 Plan Allocation Model were developed in consideration of these policy principles, with the
intent to abide by each policy principle while minimizing conflicts between policy principles. The
policy principles are summarized below and implemented in Attachment B, Tier 2 Plan Data
Sources and Calculations.
1.Policy Principle #1 - Provide sufficient water for the basic health and safety needs of
customers.
2.Policy Principle #2 - Minimize economic and other adverse impacts of water shortages
on customers and the BAWSCA region.
3.Policy Principle #3 - Provide predictability of drought allocations through consistent and
predetermined rules for calculation, while allowing for flexibility to respond to unforeseen
circumstances.
4.Policy Principle #4 - Recognize benefits of, and avoid disincentives for, water use
efficiency and development of alternative water supply projects.
5.Allocation Formula
Guided by the Policy Principles, the Wholesale Customers developed a specific formula for
apportioning the Overall Wholesale Customer Allocation among the individual Wholesale
Customers. The Tier 2 Allocation Model requires several inputs to calculate each Wholesale
Customer’s allocation. First, Base Period data are collected to be used as inputs in the Tier 2
formula. Next each Wholesale Customer’s allocation is calculated in five steps.
Base Period Calculations
The Base Period in the Tier 2 Plan is defined as the average of each Wholesale Customer’s two
years with the highest volumes of SFPUC purchases from the previous three non-Drought
years. A non-Drought year is defined as a full fiscal year (July 1 through June 30) in which the
SFPUC has not declared a water shortage emergency, as defined in the WSA. BAWSCA’s
Annual Survey, which compiles and publishes data self-reported by the Wholesale Customers,
is the primary source for model inputs.
Tier 2 Plan Allocation Formula Inputs
•Population: Each Wholesale Customer’s population as reported in the most recently
published Annual Survey and is not tied to Drought or non-Drought year status.
•Base Period SFPUC Purchases: The average of each Wholesale Customer’s two
years with the highest volumes of SFPUC purchases from the previous three non-
Drought years.
•Base Period Total Potable Water Production: Total potable production as reported in
the Annual Survey.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 3 of 19
21418818.2
•Base Period SFPUC Reliance: Each Wholesale Customer’s Base Period SFPUC
Purchases divided by Base Period Total Potable Water Production, expressed as a
percentage.
•Base Period Percent Indoor Demand: The single lowest month’s total potable demand
(a proxy for indoor use) divided by the average monthly total potable demand, expressed
as a percentage. The resulting percentages are averaged for the two selected Base
Period years.
•Base Period Percent Non-Residential Demand: Each Wholesale Customer’s potable
water consumption from the Base Period from all customer categories except residential,
divided by the Wholesale Customer’s Base Period Total Potable Water Production,
expressed as a percentage. The resulting percentages are averaged for the two
selected Base Period years.
•Individual Supply Guarantee (ISG): Each Wholesale Customer’s share of the Supply
Assurance, as shown on Attachment C to the WSA, with proxies for Hayward, San Jose,
and Santa Clara in order to provide inputs for the Tier 2 Allocation Formula
There are three exceptions to the Base Period Calculations: (1) Coastside County Water District
(“Coastside CWD”) Base Period SFPUC Purchases and Base Period SFPUC Reliance, (2)
Stanford Base Period Percent Indoor Demand, and (3) Stanford Population Calculation.
(1)Coastside CWD Base Period SFPUC Purchases will be calculated as 94% of its Base
Period Total Potable Water Production. Base Period SFPUC Reliance will be fixed at
94%. More information is provided in Attachment B.
(2)Stanford’s Base Period Percent Indoor Demand calculation will exclude demand from
the month of December and/or January when the campus is closed and demand is
abnormally low.
(3)Stanford’s population is calculated as described in Attachment B.
Furthermore, three Wholesale Customers do not have an ISG and a proxy is used in the Tier 2
Plan: (1) Hayward, (2) San Jose, and (3) Santa Clara. Background on ISG and each ISG proxy
is described in Attachment B.
Data sources, methodologies, and equations used to calculate each input are described further
in Attachment B.
Step 0: Establish SFPUC Minimum and Maximum Cutback
The Minimum and Maximum Cutback establish the upper and lower bounds for each Wholesale
Customer’s final allocation.
No water is allocated in this step. Instead, allocations in subsequent steps are limited such that
no Wholesale Customer’s final allocation is outside the upper and lower bounds (i.e., above the
Minimum Cutback or below the Maximum Cutback) established in this step.
Minimum Cutback: Each Wholesale Customer will contribute to meeting the Overall Average
Wholesale Customer Reduction by taking a Minimum Cutback from its Base Period SFPUC
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 4 of 19
21418818.2
Purchases (up to its ISG or proxy). This establishes the upper limit of each Wholesale
Customer’s potential final allocation. The Minimum Cutback, expressed as a percentage, is
equal to 1/3 times the Overall Average Wholesale Customer Reduction, but no less than 5%.
Maximum Cutback: The Maximum Cutback establishes the lower limit of each Wholesale
Customer’s potential final allocation. The Maximum Cutback, expressed as a percentage, is
equal to 1.5 times the Overall Average Wholesale Customer Reduction. The Maximum Cutback
is calculated from each Wholesale Customer’s Base Period SFPUC Purchases (up to its ISG, or
proxy).
Step 1 Override Exception: If a Wholesale Customer’s allocation in Step 1 exceeds the upper
limit established by the Minimum Cutback at 1/3 times the Overall Average Wholesale Customer
Reduction, the Wholesale Customer’s Minimum Cutback will be reduced, but the Minimum
Cutback will be no less than 5%.
Calculations and an example of the Step 1 Override Exception are provided in Attachment B.
Step 1: Efficient Residential Allocation
Step 1 allocates water on a residential per capita basis, based on the State Indoor Water Use
Efficiency Standard1 and the portion of each Wholesale Customer’s water demand met by the
RWS.
The per capita efficient residential volume, in gallons, will align with the State Residential Indoor
Water Use Efficiency Standard, established as 47 gallons per capita per day (GPCD) through
2029 and 42 GPCD beginning in 2030. This step multiplies the per-capita volume by each
Wholesale Customer’s Population and Base Period SFPUC Reliance to determine the total
amount of supply allocated to each Wholesale Customer in this step.
Step 2: Non-Residential Base Allocation
Step 2 allocates water based on each Wholesale Customer’s estimated non-residential
indoor/base demand.
To calculate non-residential indoor/base demand, each Wholesale Customer’s Base Period
SFPUC Purchases are multiplied by:
•Base Period Percent Indoor Demand
•Base Period Percent Non-Residential Demand
•Non-Residential Base Allocation Factor – this is equal to one minus 50% of the Overall
Average Wholesale Customer Reduction.
o For example, in a 20% Overall Average Wholesale Customer Reduction, the
Non-Residential Base Allocation Factor will be 90% (1 – (20% ÷ 2)) of each
Wholesale Customer’s non-residential indoor/base demand.
1 SB 1157, signed into law in September 2022, established the standard for efficient indoor residential
water use be 47 gallons per capita per day (“GPCD”), lowering to 42 GPCD in 2030.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 5 of 19
21418818.2
Step 3: SFPUC Maximum Cutback Reserve
The Maximum Cutback establishes the lower limit for each Wholesale Customer’s final
allocation. See Step 0 for more information.
No water is allocated in this step. Instead, this step calculates the gap between each Wholesale
Customer’s allocation after Step 2 and the lower limit of its potential final allocation. This step
then reserves the sum of the gap for all Wholesale Customers from the Overall Wholesale
Customer Allocation for Step 5. This Maximum Cutback Reserve ensures, after other steps are
applied, that sufficient water is available in the final step to provide that each Wholesale
Customer’s final allocation is equal to, or greater than, the lower limit of its potential allocation
established by the Maximum Cutback.
Step 4: Seasonal Allocation
Step 4 allocates water based on estimated seasonal purchases from the RWS.
The inverse of each Wholesale Customer’s Base Period Percent Indoor Demand (1 - % Indoor
Demand) is used to estimate percent seasonal demand, which is then multiplied by Base Period
SFPUC Purchases to estimate each Wholesale Customers’ SFPUC seasonal purchases. Each
Wholesale Customer’s estimated SFPUC seasonal purchases are multiplied by the Seasonal
Cutback Factor to establish each Wholesale Customer’s Seasonal Allocation.
The Seasonal Cutback Factor is calculated based upon the Overall Wholesale Customer
Allocation remaining to be allocated after Step 2. Of the remaining Overall Wholesale Customer
Allocation after Step 2 (less the Maximum Cutback Reserve), 50% is allocated through the
Seasonal Minimum Allocation Step. The detailed methodology for calculating the Seasonal
Cutback Factor is described in Attachment B.
Step 5: SFPUC Purchases and ISG-Based Allocation
Step 5 allocates the water remaining after Step 4 to get agencies as close to the “Target
Allocation” as possible. Each Wholesale Customer’s Target Allocation is based on a weighted
share of two-thirds Base Period SFPUC Purchases and one-third ISG (or proxy) while ensuring
each agency’s final allocation is between the Minimum and Maximum Cutback limits.
The detailed methodology for calculating the Base Period SFPUC Purchases and ISG weighted
allocation is described in Attachment B.
6.Plan Implementation
The Tier 2 Plan applies when, and only when, the SFPUC declares a Drought that has is a
system-wide water shortage of 20 percent or less. The Tier 2 Plan applies only to water
acquired and distributed by the SFPUC to the Wholesale Customers through the WSA and has
no effect on water obtained by a Wholesale Customer from any source other than the SFPUC.
Shortages Greater than 20 Percent
In no way should it be construed that the Wholesale Customers relieve the SFPUC of its
obligations established in the Level of Service goals adopted in the Water System Improvement
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 6 of 19
21418818.2
Program (“WSIP”), including the level of service goal to “meet dry-year delivery needs while
limiting drought rationing to a maximum 20 percent system-wide reduction water service during
extended droughts” (2023 Amended and Updated LOS Goals and Objectives, SFPUC
Resolution No. 23-0210, adopted November 28, 2023, updating the Resolution No. 08-0200,
adopted October 30, 2008). Should conditions occur that result in system-wide shortages
greater than 20%, the provisions in WSA Section 3.11(C) apply. The Tier 2 Plan calculations
may be used during discussions with the SFPUC on how to implement reductions above 20%
with the Wholesale Customers and for planning purposes only to estimate potential Wholesale
Customer allocations for system-wide shortages greater than 20% (e.g., to inform efforts such
as Urban Water Management Plans).
BAWSCA Role in Plan Implementation
In accordance with the WSA, upon the SFPUC’s declaration or reconfirmation of a water
shortage emergency, BAWSCA will calculate and provide the SFPUC with each Wholesale
Customer’s individual percentage share of the amount of water allocated to the Wholesale
Customers collectively.
In the event that shortage conditions change and the SFPUC takes action to declare an
increase or decrease to the system-wide shortage level, BAWSCA will recalculate the Tier 2
Plan and submit new Allocation Factors to the SFPUC. When rerunning the Tier 2 calculations,
the Base Period will not change to provide predictability (Policy Principle #3). The only inputs
that will change are the Overall Wholesale Customer Allocation and population, if a more recent
Annual Survey has been published.
If the appropriate base period data, as specified in this Plan, are not available when BAWSCA
initially calculates the Tier 2 Allocation Factors, the Base Period may be updated. However,
BAWSCA may only provide the SFPUC with updated Allocation Factors if the Commission
takes action to declare or reconfirm a shortage condition.
Each year, BAWSCA will provide the Wholesale Customers with a review of the Tier 2 Plan.
The annual review will include:
•Calculation of each Wholesale Customer’s Allocation Factor for regional shortages of
10% and 20% for the current Base Period, based upon the most recent published
BAWSCA Annual Survey;
•Review of Base Period data used to develop the calculations.
7.Plan Term
The term of the Tier 2 Plan will be the same as the WSA term and may be extended by the
written agreement of all the Wholesale Customers. The Tier 2 Plan negotiators chose to
coordinate the Plan term with WSA term in order to avoid simultaneous renegotiation of these
related agreements. Pursuant to WSA Section 2, the WSA expires on June 30, 2034. In
December 2031, the SFPUC may provide written notice to the Wholesale Customers that it is
willing to extend the WSA for five years, through June 30, 2039. Between January 1, 2032 and
June 30, 2032, any Wholesale Customer may accept the SFPUC's offer to extend the Term by
providing a written notice of extension to the SFPUC. If the WSA is extended, the Tier 2 Plan
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 7 of 19
21418818.2
shall expire on December 31, 2034, unless extended by the written agreement of all Wholesale
Customers. The Wholesale Customers will meet to review and potentially negotiate
amendments to the Tier 2 Plan between July 2032 and June 2034.
If the SFPUC is not willing to extend the term of the WSA, or the Wholesale Customers decline
the offer to extend the term of the WSA, the term of the Tier 2 Plan shall be automatically
extended for two additional years through December 31, 2036 to allow for more time for the
Wholesale Customers to meet to review and potentially negotiate amendments to the Tier 2
Plan between July 2034 and June 2036.
Sample schedules described above are provided in the table below.
Date
Extension of WSA with Limited
Negotiated Changes
Parties must renegotiate WSA
Terms
Dec 2031 SFPUC indicates willingness to extend
term of WSA for 5 years
SFPUC indicates willingness to extend
term of WSA for 5 years
Jan - Jun
2032
Wholesale Customers accept offer to
extend term of WSA
Wholesale Customers decline offer to
extend term of WSA
Jul 2032 -
Jun 2034
Wholesale Customers meet to review,
extend and potentially negotiate
amendments to the Tier 2 Plan
SFPUC and Wholesale Customers
negotiate amendments to WSA
Jul 2034 –
Jun 2036
Wholesale Customers meet to review
and potentially negotiate amendments
to the Tier 2 Plan
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 8 of 19
21418818.2
Attachment A: List of Abbreviations and Definitions
Abbreviations
BAWSCA – Bay Area Water Supply and Conservation Agency
GPCD – gallons per capita per day
ISG – Individual Supply Guarantee
MGD – million gallons per day
RWS – San Francisco Regional Water System
SFPUC – San Francisco Public Utilities Commission
WSA – Amended and Restated Water Supply Agreement between the City and County of San
Francisco and the Wholesale Customers in Alameda, San Mateo and Santa Clara Counties
WSIP – Water System Improvement Program
Definitions
Allocation Factor – Each Wholesale Customer's portion of the Overall Wholesale Customer
Allocation, expressed as a percent.
Base Period – The average of each Wholesale Customer’s two years with the highest volumes
of SFPUC purchases from the previous three non-Drought years.
BAWSCA Annual Survey – An annual survey of the Wholesale Customers, conducted by
BAWSCA, to update key service area information including actual and projections of Wholesale
Customer water demand and population.
Drought – “[a] water shortage caused by lack of precipitation, as reflected in resolutions of the
Commission calling for voluntary or mandatory water rationing based on evaluation of water
stored or otherwise available to the Regional Water System, whether or not the Commission
declares a water shortage emergency pursuant to Water Code §§ 350 et seq., as amended
from time to time." (WSA, Attachment A)
Individual Supply Guarantee – “[each] Wholesale Customer’s share of the Supply Assurance,
as shown in Attachment C [to the WSA]." (WSA, Attachment A)
Overall Average Wholesale Customer Reduction – The percent cutback from Base Period
SFPUC Purchases, calculated by dividing the Overall Wholesale Customer Allocation by the
sum of the Wholesale Customer's Base Period SFPUC Purchases.
Overall Wholesale Customer Allocation or Tier 1 Allocation – The volume of water available
to the Wholesale Customers from the RWS.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 9 of 19
21418818.2
Regional Water System – “[the] water storage, transmission and treatment system operated by
the SFPUC in Tuolumne, Stanislaus, San Joaquin, Alameda, Santa Clara, San Mateo and San
Francisco counties, including projects constructed under the WSIP, but excluding Direct Retail
and Direct Wholesale assets." (WSA, Attachment A)
SFPUC Purchases – For the purposes of the Tier 2 Plan, SFPUC Purchases are defined as the
volume of water purchased by and delivered to a Wholesale Customer for use within its service
area. SFPUC Purchases specifically exclude (1) In-Lieu Water, which is Regional Water
System water pursuant to the WSA and the Regional Groundwater Storage and Recovery
Project Operating Agreement and (2) Imputed Sales, both defined in the WSA, Attachment A.
Supply Assurance – “[the] 184 MGD maximum annual average metered supply of water
dedicated by San Francisco to public use in the Wholesale Service Area (not including San
Jose and Santa Clara) in the 1984 Agreement and Section 3.01 of this Agreement." (WSA,
Attachment A)
Tier 1 Plan or Tier 1 Shortage Plan – “[the] Water Shortage Allocation Plan (Attachment H)
adopted by the SFPUC and the Wholesale Customers in conjunction with this Agreement [the
WSA] describing the method for allocating water between the SFPUC and the Wholesale
Customers collectively for shortages of up to 20% of deliveries from the Regional Water
System, as amended from time-to-time." (WSA, Attachment A)
Tier 2 Plan or Tier 2 Drought Response Implementation Plan – The method of apportioning
the Tier 1 Allocation among the 26 Wholesale Customers.
Tier 2 Plan Allocation Model – The Excel-based tool used for applying the Tier 2 Plan
allocation methodology and determining each Wholesale Customer's Allocation Factor.
Wholesale Customers – “[the] 26 water customers identified in Section 1.02 [of the WSA] that
are contracting for purchase of water from San Francisco pursuant to [the WSA].” (WSA,
Attachment A)
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 10 of 19
21418818.2
Attachment B: Tier 2 Plan Data Sources and Calculations
BAWSCA Annual Survey
Each year, BAWSCA conducts an annual survey of its members in order to update key
BAWSCA service area information including population, current and projected water use, and
climatology. BAWSCA begins collecting data in October of each year. The Wholesale
Customers submit data through BAWSCA’s Water Conservation Database. Between
approximately January and March, BAWSCA reviews the Wholesale Customers’ submissions
for potential errors and works with Wholesale Customers to confirm and finalize the data. The
final report is published around March of each year for the fiscal year ending the previous June
30th.
Base Period inputs will use data published in the Annual Surveys from the previous three non-
Drought years. Depending on when the SFPUC declares a shortage emergency, the most
recent non-Drought year’s Annual Survey may not be finalized and published. If the most
recent non-Drought year’s Annual Survey is not available, the Base Period inputs will use data
from the three most recent non-Drought year’s published in Annual Surveys.
Base Period
The Tier 2 Plan uses historical SFPUC purchases, total potable water production, monthly
potable production, potable consumption by customer category, and population for Steps 0
through 5. These values are established using a historical base period with established water
supply and delivery data.
The Base Period for all inputs except population is defined as the average from the highest two
years of SFPUC Purchases over the most recent three non-Drought years. The selection of
Base Period is unique to each Wholesale Customer. Two example agencies are provided in the
table below, where the data associated with the highest two years are highlighted.
Previous Non-
Drought Year
Agency A Agency B
SFPUC
Purchases
Percent Non-
Residential
SFPUC
Purchases
Percent Non-
Residential
Year 1 2.50 70% 5.90 58%
Year 2 2.75 69% 6.20 56%
Year 3 2.40 67% 6.10 55%
Calculation (2.50 + 2.75)2 (0.70 + 0.69)2 (6.20 + 6.10)2 (0.56 + 0.55)2
Average of Highest
Two Years 2.63 70% 6.15 55.5%
Coastside CWD Special Provisions for Base Period Calculations
Coastside CWD Base Period SFPUC Purchases will be calculated as 94% of its Base Period
Total Potable Water Production. Base Period SFPUC Reliance will be fixed at 94%.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 11 of 19
21418818.2
Coastside CWD’s high variability in SFPUC purchases from year to year, the California Coastal
Commission limitations on growth in its service area, and geographical and hydrological
isolation set it apart from other Wholesale Customers. Uniquely among the Wholesale
Customers, Coastside CWD does not have interties with other Wholesale Customers or
agencies. Additionally, it has junior rights on local surface water supplies. To ensure resiliency,
Coastside CWD must maximize its use of Denniston Creek in normal years to provide evidence
to the State in its ongoing case to perfect its water rights. This results in low RWS purchases in
non-drought years, which are the source of each Wholesale Customer’s Base Period. The
Coastside CWD special provisions for Base Period SFPUC Purchases ensure its dry year
reliance on the RWS is reflected in the Tier 2 Plan.
Minimum Cutback Factor
The minimum cutback factor is used to establish the upper limit at or below which each
Wholesale Customer’s final allocation will be. The minimum cutback factor is equal to 1/3 times
the Overall Average Wholesale Customer Reduction, expressed as a percentage. Base Period
SFPUC Purchases (up to ISG or proxy) are multiplied by 1 minus the minimum cutback factor.
An example equation is provided below. 𝑊𝑊ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝐶𝐶𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶 𝑓𝑓𝑓𝑓𝑓𝑓𝑜𝑜𝑜𝑜 𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑎𝑎𝑜𝑜𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓 𝐶𝐶𝑢𝑢𝑢𝑢𝑜𝑜𝐶𝐶 𝑜𝑜𝑓𝑓𝐶𝐶𝑓𝑓𝐶𝐶 = 𝐵𝐵𝑜𝑜𝑜𝑜𝑜𝑜 𝑃𝑃𝑜𝑜𝐶𝐶𝑓𝑓𝑜𝑜𝑃𝑃 𝑆𝑆𝑆𝑆𝑃𝑃𝑆𝑆𝐶𝐶 𝑃𝑃𝐶𝐶𝐶𝐶𝑎𝑎ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 × �1 −(1 3⁄× 𝑂𝑂𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝑜𝑜𝑜𝑜 𝐴𝐴𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝐴𝐴𝑜𝑜 𝑊𝑊ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝐶𝐶𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶 𝑅𝑅𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓)�
Step 1 Override Exception
If a Wholesale Customer’s allocation in Step 1 (Efficient Residential Allocation) is greater than
the upper limit of its potential allocation established by the Minimum Cutback, the Step 1
allocation will override. However, no Wholesale Customer’s final cutback will be less than 5%.
For example, in a 20% Overall Average Wholesale Customer Reduction, the Minimum Cutback
will be 6.67% (20% × 1/3). An example Wholesale Customer’s calculation is provided below.
Base Period SFPUC Purchases 5.0 MGD
Minimum Cutback Factor -6.67%
Upper Limit of Potential Final Allocation 4.67 MGD
Population 101,000
Base Period SFPUC Reliance 100%
Residential Efficient Allocation 47 GPCD
Step 1 Allocation 4.75 MGD
The example agency’s final cutback will be 5.1% as calculated below: 4.75 𝐶𝐶𝐴𝐴𝑃𝑃5.0 𝐶𝐶𝐴𝐴𝑃𝑃−1 =−5.1%⁄
Maximum Cutback Factor
The maximum cutback factor is used to establish the lower limit at or above each Wholesale
Customer’s final allocation. The maximum cutback factor is equal to 1.5 times the Overall
Average Wholesale Customer Reduction, expressed as a percentage. Base Period SFPUC
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 12 of 19
21418818.2
Purchases (up to ISG or proxy) are multiplied by 1 minus the minimum cutback factor. An
example equation is provided below. 𝑊𝑊ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝐶𝐶𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶 𝑓𝑓𝑓𝑓𝑓𝑓𝑜𝑜𝑜𝑜 𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑎𝑎𝑜𝑜𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓 𝑜𝑜𝑜𝑜𝑙𝑙𝑜𝑜𝐶𝐶 𝑜𝑜𝑓𝑓𝐶𝐶𝑓𝑓𝐶𝐶 = 𝐵𝐵𝑜𝑜𝑜𝑜𝑜𝑜 𝑃𝑃𝑜𝑜𝐶𝐶𝑓𝑓𝑜𝑜𝑃𝑃 𝑆𝑆𝑆𝑆𝑃𝑃𝑆𝑆𝐶𝐶 𝑃𝑃𝐶𝐶𝐶𝐶𝑎𝑎ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 × �1 −(1.5 × 𝑂𝑂𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝑜𝑜𝑜𝑜 𝐴𝐴𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝐴𝐴𝑜𝑜 𝑊𝑊ℎ𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝐶𝐶𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶𝑜𝑜𝐶𝐶 𝑅𝑅𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓)�
Efficient Residential Volume
The Tier 2 Plan uses a per-capita volume, in gallons, to calculate each Wholesale Customer’s
Efficient Residential Allocation (Step 1 of the Allocation Model). The per-capita volume is 47
gallons per capita per day through 2029 and 42 GPCD beginning in 2030, consistent with the
State of California Indoor Residential Water Use Standard for 2025 established by SB 1157.
SFPUC Reliance
For agencies with multiple potable water sources, the Tier 2 Plan calculates SFPUC Reliance
by dividing each agency’s Base Period SFPUC Purchases by Base Period Total Potable Water
Production, expressed as a percentage. SFPUC Reliance is used in Step 1 to calculate multi-
source agency’s Residential Efficient Allocation met by the RWS.
Population
The Tier 2 Plan uses population reported in the most recently published Annual Survey to
calculate each Wholesale Customer’s Efficient Residential Allocation in Step 1.
BAWSCA reviews data submitted for the Annual Survey and works with agencies to ensure the
information is correct before making it public. As part of this annual review, BAWSCA will flag
any agencies that have reported population increases greater than 5%. BAWSCA will first
confirm with the agency that there are no reporting errors. If the reported data are correct,
BAWSCA will include a note to all agencies during the annual review of the Tier 2 Plan.
Stanford University Population Calculation
Stanford has historically reported its population in the BAWSCA Annual Survey using data from
the Stanford Office of Institutional Research & Decision Support, which annually documents
population based on student enrollment and data from human resources. This number captures
all students (undergraduate and graduate), post-docs, faculty, and staff that are employed and
work on campus. The population report does not directly capture residential population that is
not enrolled or employed (significant others or dependents). However, it would include a
daytime population component. Stanford reviewed several population sources and calculation
methods including census data. Based on review of the available sources for population
information, Stanford proposed, and the BAWSCA agencies agreed, to utilize a formula that
captures student and faculty/staff residential population. This new approach would eliminate the
inclusion of daytime staff and faculty who do not live on campus.
The formula takes the Office of Institutional Research & Decision Support data and uses only
the "Total Students" and adds a multiplier of 2.57 people per residence (single and multi-family)
for the faculty/staff housing area.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 13 of 19
21418818.2
Stanford Population = (Faculty/Staff Housing Residences x 2.57) + ("Total Students" from
Population Report)
Percent Indoor Demand
For each Base Period year, percent indoor demand is calculated by dividing each Wholesale
Customer’s lowest month of potable production by the Wholesale Customer’s average monthly
potable production. The two resulting percentages are averaged together. An example equation
is provided below, where Y1 and Y2 represent the two Base Period years.
% 𝐼𝐼𝑓𝑓𝑃𝑃𝑜𝑜𝑜𝑜𝐶𝐶 𝑆𝑆𝑜𝑜𝑜𝑜= 𝐿𝐿𝑜𝑜𝑙𝑙𝑜𝑜𝑜𝑜𝐶𝐶 𝑀𝑀𝑜𝑜𝑓𝑓𝐶𝐶ℎ 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌1𝐴𝐴𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝐴𝐴𝑜𝑜 𝑀𝑀𝑜𝑜𝑓𝑓𝐶𝐶ℎ𝑜𝑜𝑙𝑙 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌1 +𝐿𝐿𝑜𝑜𝑙𝑙𝑜𝑜𝑜𝑜𝐶𝐶 𝑀𝑀𝑜𝑜𝑓𝑓𝐶𝐶ℎ 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌2𝐴𝐴𝑂𝑂𝑜𝑜𝐶𝐶𝑜𝑜𝐴𝐴𝑜𝑜 𝑀𝑀𝑜𝑜𝑓𝑓𝐶𝐶ℎ𝑜𝑜𝑙𝑙 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌22
Percent Seasonal Demand
Percent seasonal demand is calculated as the inverse of percent indoor demand. 𝑃𝑃𝑜𝑜𝐶𝐶𝑎𝑎𝑜𝑜𝑓𝑓𝐶𝐶 𝑆𝑆𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑓𝑓𝑜𝑜𝑜𝑜 𝐷𝐷𝑜𝑜𝐶𝐶𝑜𝑜𝑓𝑓𝑃𝑃= 1 −% 𝐼𝐼𝑓𝑓𝑃𝑃𝑜𝑜𝑜𝑜𝐶𝐶 𝐷𝐷𝑜𝑜𝐶𝐶𝑜𝑜𝑓𝑓𝑃𝑃
Percent Non-Residential Demand
For each Base Period year, percent non-residential demand is calculated by first dividing each
Wholesale Customer’s potable water consumption from all residential customer categories by
the Wholesale Customer’s total annual potable production. The resulting percentage is
subtracted from one to calculate the inverse and thus captures all non-residential demands
including non-revenue water and dedicated irrigation meters2. The two resulting percentages
from the two Base Period years are averaged together. An example equation is provided below,
where Y1 and Y2 represent the two Base Period years.
% 𝑁𝑁𝑅𝑅 𝑆𝑆𝑜𝑜𝑜𝑜= (1 −𝑅𝑅𝑜𝑜𝑜𝑜𝑓𝑓𝑃𝑃𝑜𝑜𝑓𝑓𝐶𝐶𝑓𝑓𝑜𝑜𝑜𝑜 𝑆𝑆𝑜𝑜𝑜𝑜,𝑌𝑌1𝑃𝑃𝑜𝑜𝐶𝐶𝑜𝑜𝑃𝑃𝑜𝑜𝑜𝑜 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌1 ) + (1 −𝑅𝑅𝑜𝑜𝑜𝑜𝑓𝑓𝑃𝑃𝑜𝑜𝑓𝑓𝐶𝐶𝑓𝑓𝑜𝑜𝑜𝑜 𝑆𝑆𝑜𝑜𝑜𝑜,𝑌𝑌2𝑃𝑃𝑜𝑜𝐶𝐶𝑜𝑜𝑃𝑃𝑜𝑜𝑜𝑜 𝑃𝑃𝐶𝐶𝑜𝑜𝑃𝑃𝐶𝐶𝑎𝑎𝐶𝐶𝑓𝑓𝑜𝑜𝑓𝑓,𝑌𝑌2 )2
Individual Supply Guarantee (ISG)
Use of ISG in the Tier 2 Plan
Each Wholesale Customer’s ISG is used in the Tier 2 Plan calculations with proxies for
Hayward, San Jose and Santa Clara, in order to provide inputs for the Tier 2 Allocation Formula.
See WSA, Attachment C for a current list of ISG values.
Hayward’s de facto ISG (22.1 MGD) is used in place of permanent ISG for the purposes of the
Tier 2 Plan calculations. This figure is used in WSA, Attachment D, to determine whether
Hayward’s increased use requires pro-rata reduction of remaining Wholesale Customers’ ISG.
2 Prior to FY 22-23, all consumption recorded under the dedicated irrigation sector in the Water
Conservation Database is assumed to be non-residential. Starting in FY 22-23, Wholesale Customers
were given the option to separate out residential vs. non-residential dedicated irrigation consumption.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Page 14 of 19
21418818.2
San Jose and Santa Clara’s temporary and interruptible contract amounts (4.5 MGD each) are
used in place of ISG for the purposes of the Tier 2 Plan calculations.
Background on ISG
San Francisco has a perpetual legal obligation and commitment (Supply Assurance) to deliver
184 MGD to the 24 permanent Wholesale Customers collectively. The Supply Assurance is
subsequently allocated among the 24 permanent Wholesale Customers through Individual
Supply Guarantees (ISG), which represent each Wholesale Customer’s share of the 184 MGD
Supply Assurance. San Jose and Santa Clara are not included in San Francisco’s Supply
Assurance obligation; rather each has a temporary and interruptible water supply contract with
San Francisco. Through the WSA and its individual contracts with San Jose and Santa Clara,
San Francisco has many requirements to plan for water supply development and analyze the
sufficiency of water supply to San Jose and Santa Clara. For example, San Francisco must
complete a CEQA review and provide at least a 10-year notice of interruption.
Hayward does not have an Individual Supply Guarantee
San Francisco and Hayward entered into a water supply contract on February 9,1962 (the
"1962 contract") which provided that San Francisco would supply Hayward with all water
supplemental to water controlled by Hayward, in sufficient quantity to supply the total water
needs of Hayward’s service area "on a permanent basis." This 1962 contract remains the
Individual Water Sales Contract between San Francisco and Hayward. Due to the terms of this
ongoing contract, Hayward does not have an ISG. If Hayward’s purchases exceed 22.1 MGD
for three consecutive years, the remaining 23 Wholesale Customer's ISG will be reduced on a
pro rata (WSA, Attachment D).
Currently, the sum of the 23 Wholesale Customers fixed ISG is 161.9 MGD.
184 MGD Supply Assurance - 161.9 MGD = 22.1 MGD water available for Hayward purchases
(i.e., Hayward’s “de facto” ISG)
Hayward’s proxy ISG for the purpose of the Tier 2 Plan is 22.1 MGD.
San Jose and Santa Clara do not have an Individual Supply Guarantee
During the term of the 1984 Settlement Agreement, San Francisco provided water to San Jose
and Santa Clara on a temporary and interruptible basis, pursuant to SFPUC Resolution No. 85-
0256. The SFPUC has contracted to supply a combined annual average of 9 MGD to San Jose
and Santa Clara (4.5 MGD each) through 2028. The 9 MGD allocated to San Jose and Santa
Clara is not included in the Supply Assurance. San Francisco will decide whether to make San
Jose and Santa Clara permanent customers by December 31, 2028. (WSA, Sec. 4.05)
San Jose and Santa Clara’s proxy ISG for the purpose of the Tier 2 Plan is 4.5 MGD each.
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Tie
r
2
D
r
o
u
g
h
t
I
m
p
l
e
m
e
n
t
a
t
i
o
n
P
l
a
n
Ju
l
y
2
0
2
4
M
o
d
e
l
C
o
n
c
e
p
t
-
E
f
f
i
c
i
e
n
t
R
e
s
A
l
l
o
c
a
t
i
o
n
+
N
o
n
-
R
e
s
B
a
s
e
A
l
l
o
c
a
t
i
o
n
+
S
e
a
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
+
B
a
s
e
S
F
P
U
C
P
u
r
c
h
a
s
e
s
/
I
S
G
-
B
a
s
e
d
A
l
l
o
c
a
t
i
o
n
-
V
a
r
i
a
b
l
e
B
a
s
e
Y
e
a
r
Mo
d
e
l
S
e
t
-
u
p
/
A
s
s
u
m
p
t
i
o
n
s
Ba
s
e
Y
e
a
r
s
Al
l
o
c
a
t
i
o
n
Y
e
a
r
/
P
r
o
j
e
c
t
i
o
n
Y
e
a
r
FY
2
4
-
2
5
No
n
-
D
r
o
u
g
h
t
Y
e
a
r
1
FY
1
8
-
1
9
Tie
r
1
S
h
o
r
t
a
g
e
A
l
l
o
c
a
t
i
o
n
(
m
g
d
)
11
4
.
2
0
No
n
-
D
r
o
u
g
h
t
Y
e
a
r
2
FY
1
9
-
2
0
Ba
s
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
(
m
g
d
)
13
4
.
3
4
No
n
-
D
r
o
u
g
h
t
Y
e
a
r
3
FY
2
0
-
2
1
Ov
e
r
a
l
l
R
e
d
u
c
t
i
o
n
f
r
o
m
B
a
s
e
P
e
r
i
o
d
Re
q
u
i
r
e
d
-15
.
0
%
SF
P
U
C
M
a
x
i
m
u
m
C
u
t
b
a
c
k
F
a
c
t
o
r
-22
.
5
%
Er
r
o
r
M
e
s
s
a
g
e
(
s
)
(
i
f
a
p
p
l
i
c
a
b
l
e
)
SF
P
U
C
M
i
n
i
m
u
m
C
u
t
b
a
c
k
F
a
c
t
o
r
-5.
0
%
No
n
-
R
e
s
i
d
e
n
t
i
a
l
B
a
s
e
A
l
l
o
c
a
t
i
o
n
%
92
.
5
%
St
e
p
5
R
e
s
e
r
v
e
d
%
o
f
R
e
m
a
i
n
i
n
g
T
i
e
r
1 A
l
l
o
c
a
t
i
o
n
(
l
e
s
s
S
t
e
p
3
R
e
s
e
r
v
e
d
)
aft
e
r
S
t
e
p
2
50
%
Un
r
e
s
e
r
v
e
d
%
o
f
R
e
m
a
i
n
i
n
g
T
i
e
r
1
Al
l
o
c
a
t
i
o
n
(
l
e
s
s
S
t
e
p
3
R
e
s
e
r
v
e
d
a
n
d
St
e
p
5
R
e
s
e
r
v
e
d
)
A
f
t
e
r
S
t
e
p
2
50
%
Se
a
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
%
7.9
%
St
e
p
5
I
S
G
W
e
i
g
h
t
i
n
g
33
%
St
e
p
5
B
a
s
e
S
F
P
U
C
P
u
r
c
h
a
s
e
s
We
i
g
h
t
i
n
g
67
%
Re
s
i
d
e
n
t
i
a
l
E
f
f
i
c
i
e
n
t
A
l
l
o
c
a
t
i
o
n
(
R
-
GP
C
D
)
47
.
0
Ad
j
u
s
t
m
e
n
t
%
f
o
r
S
F
P
U
C
M
i
n
i
m
u
m
Cu
t
b
a
c
k
,
i
f
e
f
f
i
c
i
e
n
t
r
e
s
i
d
e
n
t
i
a
l
all
o
c
a
t
i
o
n
i
s
g
r
e
a
t
e
r
t
h
a
n
m
i
n
i
m
u
m
cu
t
b
a
c
k
95
%
Eff
e
c
t
i
v
e
D
a
t
e
f
o
r
M
o
d
e
l
R
u
n
(
u
p
d
a
t
e
f
o
r
tes
t
i
n
g
o
n
l
y
)
12
/
1
6
/
2
0
2
4
Ins
t
r
u
c
t
i
o
n
s
:
1.
A
d
j
u
s
t
aq
u
a
ce
l
l
s
i
n
O
V
E
R
V
I
E
W
t
a
b
t
o
a
d
j
u
s
t
m
o
d
e
l
pa
r
a
m
e
t
e
r
s
.
I
f
t
h
e
r
e
a
r
e
e
r
r
o
r
s
i
n
t
h
e
i
n
p
u
t
s
,
a
n
e
r
r
o
r
me
s
s
a
g
e
w
i
l
l
a
p
p
e
a
r
i
n
C
o
l
u
m
n
s
E
-
F
.
2.
V
i
e
w
a
l
l
o
c
a
t
i
o
n
c
a
l
c
u
l
a
t
i
o
n
s
a
n
d
r
e
s
u
l
t
s
i
n
"
T
i
e
r
2
All
o
c
a
t
i
o
n
"
a
n
d
"
A
g
e
n
c
y
C
h
a
r
t
s
"
t
a
b
s
.
Cal
c
u
l
a
t
i
o
n
S
t
e
p
s
f
o
r
J
u
l
y
202
4
M
o
d
e
l
C
o
n
c
e
p
t
:
0. S
F
P
U
C
M
i
n
i
m
u
m
C
u
t
b
a
c
k
a. C
a
l
c
u
l
a
t
e
M
i
n
i
m
u
m
C
u
t
b
a
c
k
f
r
o
m
L
e
s
s
e
r
o
f
B
a
s
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
a
n
d
I
S
G
(
L
e
s
s
e
r
o
f
Bas
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
a
n
d
I
S
G
×[1+
S
F
P
U
C
M
i
n
i
m
u
m
C
u
t
b
a
c
k
F
a
c
t
o
r
]
)
b. C
a
l
c
u
l
a
t
e
Effi
c
i
e
n
t
R
e
s
i
d
e
n
t
i
a
l
Allo
c
a
t
i
o
n
(
p
o
p
u
l
a
t
i
o
n
×per
c
a
p
i
t
a
a
l
l
o
c
a
t
i
o
n
×% S
F
P
U
C
reli
a
n
c
e
)
c. D
e
t
e
r
m
i
n
e
i
f
M
i
n
i
m
u
m
C
u
t
b
a
c
k
i
s
g
r
e
a
t
e
r
t
h
a
n
t
h
e
E
f
f
i
c
i
e
n
t
Res
i
d
e
n
t
i
a
l
A
l
l
o
c
a
t
i
o
n
d. I
f
E
f
f
i
c
i
e
n
t
R
e
s
i
d
e
n
t
i
a
l
A
l
l
o
c
a
t
i
o
n
i
s
g
r
e
a
t
e
r
t
h
a
n
t
h
e
M
i
n
i
m
u
m
C
u
t
b
a
c
k
,
a
n
a
g
e
n
c
y
'
s
c
u
t
b
a
c
k
ma
y
b
e
n
o
l
e
s
s
t
h
a
n
5
%
1. E
f
f
i
c
i
e
n
t
Res
i
d
e
n
t
i
a
l
A
l
l
o
c
a
t
i
o
n
a. C
a
l
c
u
l
a
t
e
E
f
f
i
c
i
e
n
t
Res
i
d
e
n
t
i
a
l
A
l
l
o
c
a
t
i
o
n
(po
p
u
l
a
t
i
o
n
×per
c
a
p
i
t
a
a
l
l
o
c
a
t
i
o
n
)
b. A
c
c
o
u
n
t
f
o
r
%
S
F
P
U
C
R
e
l
i
a
n
c
e
c. P
r
o
v
i
d
e
E
f
f
i
c
i
e
n
t
Res
i
d
e
n
t
i
a
l
Allo
c
a
t
i
o
n
2. N
o
n
-Res
i
d
e
n
t
i
a
l
B
a
s
e
A
l
l
o
c
a
t
i
o
n
a. In
c
o
r
p
o
r
a
t
e
E
s
t
i
m
a
t
e
d
%
I
n
d
o
o
r
U
s
e
(
see
g
l
o
s
s
a
r
y
f
o
r
d
e
f
i
n
i
t
i
o
n
a
n
d
c
a
l
c
u
l
a
t
i
o
n
o
f
%
I
n
d
o
o
r
U
s
e
)
b. I
n
c
o
r
p
o
r
a
t
e
%
N
o
n
-Res
i
d
e
n
t
i
a
l
U
s
e
c. C
a
l
c
u
l
a
t
e
N
o
n
-Res
i
d
e
n
t
i
a
l
B
a
s
e
A
l
l
o
c
a
t
i
o
n
(
%
I
n
d
o
o
r
U
s
e
×% N
o
n
-Res
i
d
e
n
t
i
a
l
U
s
e
×Bas
e
Per
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
×Non
-Res
i
d
e
n
t
i
a
l
I
n
d
o
o
r
A
l
l
o
c
a
t
i
o
n
%
)
d. A
d
d
Non
-Res
i
d
e
n
t
i
a
l
B
a
s
e
A
l
l
o
c
a
t
i
o
n
to the
S
t
e
p
1
A
l
l
o
c
a
t
i
o
n
3. C
a
l
c
u
l
a
t
e
P
o
t
e
n
t
i
a
l
S
F
P
U
C
M
a
x
i
m
u
m
C
u
t
b
a
c
k
N
e
e
d
a.Cal
c
u
l
a
t
e
S
F
P
U
C
M
a
x
i
m
u
m
Cut
b
a
c
k
(
B
a
s
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
×[1+
S
F
P
U
C
M
a
x
i
m
u
m
Cut
b
a
c
k
F
a
c
t
o
r
]
)
b. R
e
s
e
r
v
e
t
h
e
s
u
m
o
f
t
h
e
p
o
t
e
n
t
i
a
l
S
F
P
U
C
M
a
x
i
m
u
m
C
u
t
b
a
c
k
n
e
e
d
f
o
r
S
t
e
p
5
(
M
a
x
i
m
u
m
C
u
t
b
a
c
k
Res
e
r
v
e
)
4. S
e
a
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
a. D
e
t
e
r
m
i
n
e
%
S
e
a
s
o
n
a
l
U
s
e
(
1
-% I
n
d
o
o
r
U
s
e
)
b. C
a
l
c
u
l
a
t
e
s
e
a
s
o
n
a
l
S
F
P
U
C
P
u
r
c
h
a
s
e
s
(
B
a
s
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
×% S
e
a
s
o
n
a
l
U
s
e
)
c. C
a
l
c
u
l
a
t
e
S
e
a
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
(
sea
s
o
n
a
l
S
F
P
U
C
P
u
r
c
h
a
s
e
s
×Sea
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
%
)
d. A
d
d
t
h
e
S
e
a
s
o
n
a
l
A
l
l
o
c
a
t
i
o
n
t
o
t
h
e
S
t
e
p
2
A
l
l
o
c
a
t
i
o
n
5. B
a
s
e
P
e
r
i
o
d
/
I
S
G
-Bas
e
d
A
l
l
o
c
a
t
i
o
n
a. C
a
l
c
u
l
a
t
e
w
e
i
g
h
t
e
d
a
v
e
r
a
g
e
o
f
Bas
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
and
I
S
G
,
u
p
t
o
M
i
n
i
m
u
m
C
u
t
b
a
c
k
b. C
a
l
c
u
l
a
t
e
W
e
i
g
h
t
e
d
S
h
a
r
e
o
f
t
o
t
a
l
T
i
e
r
1
A
l
l
o
c
a
t
i
o
n
t
o
W
h
o
l
e
s
a
l
e
C
u
s
t
o
m
e
r
s
(
a
g
e
n
c
y
w
e
i
g
h
t
e
d
ave
r
a
g
e
Bas
e
P
e
r
i
o
d
S
F
P
U
C
P
u
r
c
h
a
s
e
s
/ISG
÷tota
l
W
h
o
l
e
s
a
l
e
C
u
s
t
o
m
e
r
w
e
i
g
h
t
e
d
a
v
e
r
a
g
e
×Tier
1
Allo
c
a
t
i
o
n
)
c. C
a
l
c
u
l
a
t
e
t
h
e
g
a
p
b
e
t
w
e
e
n
S
t
e
p
4
a
l
l
o
c
a
t
i
o
n
a
n
d
t
h
e
l
e
s
s
e
r
o
f
1
)
w
e
i
g
h
t
e
d
s
h
a
r
e
,
o
r
2
)
M
i
n
i
m
u
m
Cut
b
a
c
k
d. A
l
l
o
c
a
t
e
r
e
m
a
i
n
i
n
g
s
u
p
p
l
i
e
s
,
e
x
c
e
p
t
M
a
x
i
m
u
m
C
u
t
b
a
c
k
R
e
s
e
r
v
e
,
a
m
o
n
g
a
g
e
n
c
i
e
s
w
i
t
h
a
g
a
p
,
pro
p
o
r
t
i
o
n
a
t
e
l
y
t
o
g
a
p
,
u
p
t
o
t
h
e
M
i
n
i
m
u
m
C
u
t
b
a
c
k
e. C
o
n
f
i
r
m
a
l
l
o
c
a
t
i
o
n
m
e
e
t
s
M
a
x
i
m
u
m
C
u
t
b
a
c
k
;
a
l
l
o
c
a
t
e
w
a
t
e
r
f
r
o
m
M
a
x
i
m
u
m
C
u
t
b
a
c
k
R
e
s
e
r
v
e
up
t
o
M
a
x
i
m
u
m
C
u
t
b
a
c
k
f. A
l
l
o
c
a
t
e
r
e
m
a
i
n
i
n
g
s
u
p
p
l
i
e
s
a
m
o
n
g
a
g
e
n
c
i
e
s
w
i
t
h
a
g
a
p
,
p
r
o
p
o
r
t
i
o
n
a
t
e
l
y
t
o
g
a
p
,
u
p
t
o
t
h
e
Min
i
m
u
m
C
u
t
b
a
c
k
Att
a
c
h
m
e
n
t
C
:
E
x
a
m
p
l
e
o
f
T
i
e
r
2
P
l
a
n
E
x
c
e
l
-
B
a
s
e
d
M
o
d
e
l
C
a
l
c
u
l
a
t
i
o
n
s
Pa
g
e
15 of
19
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
FY24-25
Tier 2 Allocation Model FY22-23
Relevant Base Period Data 1.Efficient Residential Allocation
Agency Selected
Base Year 1
Selected
Base Year 2
Base
Period
SFPUC
Purchases
(mgd)
Base Period
Reliance on
SFPUC
ISG
(mgd)
Total
Potable
Production
(mgd)
Lesser of Base
Period SFPUC
Purchases and
ISG (mgd)
SFPUC
Minimum
Cutback
(mgd)
SFPUC
Maximum
Cutback
(mgd)
Is efficient
residential
allocation
greater than
minimum
cutback?
Adjusted SFPUC
Minimum
Cutback, if
efficient
residential
allocation is
greater than
0.Effective
SFPUC
Minimum
Cutback
(mgd)
Population
% Potable
Demand
Reliance on
SFPUC
Allocation
based on
efficient
residential
indoor use
(mgd)
Efficient
Residential
Allocation
1.Efficient
Residential
(mgd)
Alameda CWD 2021 2020 8.63 22%13.76 39.32 8.63 8.20 6.69 8.20 344,000 22%16.17 3.55 3.55
Brisbane 2019 2020 0.65 100%0.98 0.65 0.65 0.62 0.50 0.62 4,851 100%0.23 0.23 0.23
Burlingame 2020 2019 3.45 100%5.23 3.45 3.45 3.28 2.67 3.28 31,080 100%1.46 1.46 1.46
Coastside 2021 2019 1.69 94%2.18 1.80 1.69 1.61 1.31 1.61 18,890 94%0.89 0.83 0.83
CWS - Total 2021 2020 29.23 95%35.68 30.62 29.23 27.77 22.66 27.77 262,704 95%12.35 11.78 11.78
Daly City 2020 2019 3.84 64%4.29 6.00 3.84 3.64 2.97 3.64 107,000 64%5.03 3.22 3.22
East Palo Alto 2020 2019 1.57 100%3.46 1.57 1.57 1.49 1.21 1.49 29,519 100%1.39 1.39 1.39
Estero 2020 2021 4.32 100%5.90 4.32 4.32 4.10 3.35 4.10 37,443 100%1.76 1.76 1.76
Hayward 2021 2019 14.26 100%22.10 14.26 14.26 13.55 11.06 13.55 159,800 100%7.51 7.51 7.51
Hillsborough 2021 2020 2.66 100%4.09 2.66 2.66 2.53 2.06 2.53 11,592 100%0.54 0.54 0.54
Menlo Park 2019 2020 3.09 100%4.46 3.09 3.09 2.94 2.40 2.94 20,319 100%0.95 0.95 0.95
Mid-Peninsula 2020 2021 2.63 100%3.89 2.63 2.63 2.50 2.04 2.50 30,159 100%1.42 1.42 1.42
Millbrae 2019 2020 1.92 100%3.15 1.92 1.92 1.83 1.49 1.83 20,666 100%0.97 0.97 0.97
Milpitas 2020 2021 5.67 67%9.23 8.49 5.67 5.39 4.40 5.39 81,067 67%3.81 2.54 2.54
Mountain View 2021 2020 7.78 87%12.46 8.90 7.78 7.40 6.03 7.40 81,501 87%3.83 3.35 3.35
North Coast 2021 2020 2.39 100%3.84 2.39 2.39 2.27 1.85 2.27 37,082 100%1.74 1.74 1.74
Palo Alto 2021 2020 9.95 100%16.58 9.95 9.95 9.45 7.71 9.45 68,624 100%3.23 3.23 3.23
Purissima Hills 2021 2020 1.82 100%1.62 1.82 1.62 1.54 1.26 1.54 7,350 100%0.35 0.35 0.35
Redwood City 2020 2021 8.62 100%10.93 8.62 8.62 8.19 6.68 8.19 90,928 100%4.27 4.27 4.27
San Bruno 2020 2021 0.93 30%3.25 3.09 0.93 0.89 0.72 0.89 43,910 30%2.06 0.62 0.62
San Jose 2019 2020 4.27 99%4.50 4.29 4.27 4.05 3.31 4.05 43,036 99%2.02 2.01 2.01
Santa Clara 2020 2021 3.25 20%4.50 16.27 3.25 3.09 2.52 3.09 132,476 20%6.23 1.24 1.24
Stanford 2020 2019 1.43 100%3.03 1.43 1.43 1.36 1.11 1.36 20,000 100%0.94 0.94 0.94
Sunnyvale 2021 2020 9.47 54%12.58 17.68 9.47 8.99 7.34 8.99 156,317 54%7.35 3.93 3.93
Westborough 2020 2019 0.80 100%1.32 0.80 0.80 0.76 0.62 0.76 13,486 100%0.63 0.63 0.63
Total 134.34 193.02 196.04 134.14 1,853,800 87.13 60.49
Allocated 60.49
Unallocated 53.71
Reserved 0
Allocation Year/Projection Year
0.Establish SFPUC Minimum Cutback
No water is allocatied in this step
Establishes the upper limit of each agency's final allocation
Most Recent Annual Survey Data Year
Page 16 of 19
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Tier 2 Allocation Model
Agency
Alameda CWD
Brisbane
Burlingame
Coastside
CWS - Total
Daly City
East Palo Alto
Estero
Hayward
Hillsborough
Menlo Park
Mid-Peninsula
Millbrae
Milpitas
Mountain View
North Coast
Palo Alto
Purissima Hills
Redwood City
San Bruno
San Jose
Santa Clara
Stanford
Sunnyvale
Westborough
Total
Allocated
Unallocated
Reserved
2.Non-Residential Base Allocation 3.SFPUC Maximum Cutback "Reserve"4.Seasonal Allocation 5.Base SFPUC Purchases/ISG-Based Allocation with Minimum Cutback
Estimated %
Indoor Use
% Non-
Residential
Use
Non-
Residential
Base
Allocation
(mgd)
2.Non-
Residential
Base
Allocation
(mgd)
SFPUC Maximum
Cutback (mgd)2
Does Step 2
Allocation Meet
SFPUC Maximum
Cutback?
SFPUC
Maximum
Cutback
Shortfall
(mgd)
% Seasonal
Use
Seasonal
SFPUC
Purchases
(mgd)
Seasonal
Allocation
(mgd)
4.Seasonal
Allocation
(mgd)
Weighted
Average of Base
Period SFPUC
Purchases (up to
ISG) and ISG
(mgd)
Weighted Share
of Tier 1
Allocation (mgd)
Lesser of
Weighted Share
and Minimum
Cutback
Allocation
(i.e., Target
Allocation)
Target
Allocation
Based Gap
(mgd)
Target
Based
Allocation 1
(mgd)
69%41%2.22 5.77 6.69 0.92 31%2.71 0.22 5.99 10.33 7.68 7.68 1.69 0.31
66%68%0.27 0.50 0.50 0.01 34%0.22 0.02 0.51 0.76 0.56 0.56 0.05 0.01
73%40%0.93 2.39 2.67 0.28 27%0.93 0.07 2.46 4.04 3.00 3.00 0.54 0.10
64%46%0.47 1.30 1.31 0.01 36%0.60 0.05 1.35 1.85 1.38 1.38 0.03 0.01
61%30%5.02 16.80 22.66 5.85 39%11.26 0.89 17.69 31.36 23.32 23.32 5.62 1.05
88%23%0.73 3.64 2.97 0.00 12%0.46 0.04 3.64 3.99 2.96 2.96 0.00 0.00
79%18%0.21 1.49 1.21 0.00 21%0.33 0.03 1.49 2.19 1.63 1.49 0.00 0.00
63%45%1.13 2.89 3.35 0.46 37%1.58 0.13 3.01 4.84 3.60 3.60 0.59 0.11
72%45%4.33 11.85 11.06 0.00 28%3.95 0.31 12.16 16.85 12.53 12.53 0.37 0.07
36%9%0.08 0.62 2.06 1.44 64%1.70 0.14 0.76 3.13 2.33 2.33 1.57 0.29
53%63%0.94 1.90 2.40 0.50 47%1.47 0.12 2.01 3.54 2.63 2.63 0.62 0.12
68%27%0.45 1.87 2.04 0.18 32%0.86 0.07 1.93 3.05 2.27 2.27 0.33 0.06
76%36%0.49 1.46 1.49 0.03 24%0.46 0.04 1.49 2.33 1.73 1.73 0.24 0.04
78%51%2.08 4.62 4.40 0.00 22%1.23 0.10 4.72 6.85 5.09 5.09 0.37 0.07
66%43%2.04 5.39 6.03 0.65 34%2.64 0.21 5.60 9.33 6.94 6.94 1.34 0.25
80%24%0.42 2.16 1.85 0.00 20%0.48 0.04 2.20 2.87 2.13 2.13 0.00 0.00
61%38%2.11 5.34 7.71 2.37 39%3.90 0.31 5.65 12.14 9.03 9.03 3.38 0.63
38%12%0.07 0.42 1.26 0.84 62%1.13 0.09 0.51 1.62 1.21 1.21 0.70 0.13
68%34%1.81 6.08 6.68 0.60 32%2.80 0.22 6.31 9.38 6.98 6.98 0.67 0.13
78%29%0.20 0.82 0.72 0.00 22%0.21 0.02 0.84 1.70 1.26 0.89 0.05 0.01
69%62%1.68 3.69 3.31 0.00 31%1.33 0.11 3.79 4.34 3.23 3.23 0.00 0.00
73%50%1.10 2.35 2.52 0.17 27%0.88 0.07 2.42 3.66 2.72 2.72 0.31 0.06
63%45%0.38 1.32 1.11 0.00 37%0.53 0.04 1.36 1.96 1.46 1.36 0.00 0.00
69%42%2.54 6.48 7.34 0.86 31%2.98 0.24 6.71 10.49 7.80 7.80 1.09 0.20
73%26%0.14 0.76 0.62 0.00 27%0.22 0.02 0.76 0.97 0.72 0.72 0.00 0.00
31.83 91.90 103.98 15.18 44.87 3.56 95.38 153.57 114.20 113.58 19.56 3.64
91.90 91.90 95.38
22.30 22.30 18.82
0 15.18 15.18
No water is allocatied in this step
Establishes the lower limit of an agency's final
allocation and potential need is reserved for Step 5
Basis for Target Allocation (SFPUC
Purchases / ISG weighting from
OVERVIEW tab)
Target Allocation First Iteration of Base Per
Allocation
Page 17 of 19
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Tier 2 Allocation Model
Agency
Alameda CWD
Brisbane
Burlingame
Coastside
CWS - Total
Daly City
East Palo Alto
Estero
Hayward
Hillsborough
Menlo Park
Mid-Peninsula
Millbrae
Milpitas
Mountain View
North Coast
Palo Alto
Purissima Hills
Redwood City
San Bruno
San Jose
Santa Clara
Stanford
Sunnyvale
Westborough
Total
Allocated
Unallocated
Reserved
First Iteration
of Target
Based
Allocation
(mgd)
Does Step 5
Initial Allocation
Meet SFPUC
Maximum
Cutback?
Maximum
Cutback
(mgd)
Initial Step 5
Allocation with
Maximum
Cutback (mgd)
Target
Allocation
Based Gap
(mgd)3
Target
Based
Allocation 2
(mgd)
Second
Iteration of
Target Based
Allocation
(mgd)
Equal or Greater
than Weighted
Share/Minimum
Cutback
Target
Allocation
Based Gap 3
(mgd)
Third
Iteration of
Target Based
Allocation
(mgd)
5.Weighted
Share/
Maximum
Cutback Based
Allocation
(mgd)
Final Allocation
(mgd)
Cutback
Percentage
Allocation
Factor
6.30 0.39 6.69 0.99 0.88 7.57 0.11 0.00 7.57 7.57 12.3%6.6%
0.52 0.00 0.52 0.04 0.04 0.56 0.00 0.00 0.56 0.56 13.8%0.5%
2.56 0.11 2.67 0.33 0.29 2.97 0.04 0.00 2.97 2.97 14.0%2.6%
1.35 0.00 1.35 0.02 0.02 1.38 0.00 0.00 1.38 1.38 18.8%1.2%
18.74 3.91 22.66 0.66 0.59 23.24 0.07 0.00 23.24 23.24 20.5%20.4%
3.64 0.00 3.64 0.00 0.00 3.64 0.00 0.00 3.64 3.64 5.0%3.2%
1.49 0.00 1.49 0.00 0.00 1.49 0.00 0.00 1.49 1.49 5.0%1.3%
3.12 0.23 3.35 0.25 0.22 3.57 0.03 0.00 3.57 3.57 17.3%3.1%
12.23 0.00 12.23 0.30 0.27 12.50 0.03 0.00 12.50 12.50 12.4%10.9%
1.05 1.01 2.06 0.27 0.24 2.30 0.03 0.00 2.30 2.30 13.6%2.0%
2.13 0.27 2.40 0.24 0.21 2.61 0.03 0.00 2.61 2.61 15.7%2.3%
2.00 0.05 2.04 0.23 0.20 2.24 0.03 0.00 2.24 2.24 14.9%2.0%
1.54 0.00 1.54 0.19 0.17 1.71 0.02 0.00 1.71 1.71 11.1%1.5%
4.79 0.00 4.79 0.30 0.27 5.06 0.03 0.00 5.06 5.06 10.8%4.4%
5.85 0.19 6.03 0.90 0.80 6.84 0.10 0.00 6.84 6.84 12.2%6.0%
2.20 0.00 2.20 0.00 0.00 2.20 0.00 0.00 2.20 2.20 7.7%1.9%
6.28 1.44 7.71 1.31 1.17 8.88 0.15 0.00 8.88 8.88 10.8%7.8%
0.64 0.62 1.26 0.00 0.00 1.26 0.00 0.00 1.26 1.26 30.9%1.1%
6.43 0.25 6.68 0.29 0.26 6.95 0.03 0.00 6.95 6.95 19.5%6.1%
0.85 0.00 0.85 0.04 0.04 0.88 0.00 0.00 0.88 0.88 5.5%0.8%
3.79 0.00 3.79 0.00 0.00 3.79 0.00 0.00 3.79 3.79 11.1%3.3%
2.47 0.05 2.52 0.20 0.18 2.70 0.02 0.00 2.70 2.70 16.9%2.4%
1.36 0.00 1.36 0.00 0.00 1.36 0.00 0.00 1.36 1.36 5.0%1.2%
6.92 0.42 7.34 0.47 0.41 7.75 0.05 0.00 7.75 7.75 18.1%6.8%
0.76 0.00 0.76 0.00 0.00 0.76 0.00 0.00 0.76 0.76 5.0%0.7%
99.02 8.92 107.95 7.04 6.25 114.20 0.79 0.00 114.20 114.20
99.02 107.95 114.20 114.20
0.00 6.25 0.00 0.00
15.18 0.00 0.00 0.00
Third Iteration of Base Period/ISG-Based Allocation
If all agencies meet their Target Allocation, remaining water is
allocated up to Minimum Cutback
iod/ISG-Based Maximum Cutback Second Iteration of Base Period/ISG-Based
Allocation
Page 18 of 19
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Tier 2 Allocation Model
Agency
Alameda CWD
Brisbane
Burlingame
Coastside
CWS - Total
Daly City
East Palo Alto
Estero
Hayward
Hillsborough
Menlo Park
Mid-Peninsula
Millbrae
Milpitas
Mountain View
North Coast
Palo Alto
Purissima Hills
Redwood City
San Bruno
San Jose
Santa Clara
Stanford
Sunnyvale
Westborough
Total
Allocated
Unallocated
Reserved
Instructions: Copy/paste the table below into the "Historical Saves" tab, columns A through F.Instructions: Copy/paste the table below into the "Historical Saves" tab, columns A through F.
Agency
Allocatio
n Year
(FY)
Allocatio
n Year
(integer)
Final
Allocation
(mgd)
Cutback
Percentag
e
Allocation
Factor Input Category Value
Allocati
on Year
(FY)
Allocatio
n Year
(integer)
Alameda CWD FY24-25 2025 7.57 12%7%Allocation Year/Projection Year FY24-25 FY24-25 2025
Brisbane FY24-25 2025 0.56 14%0%Tier 1 Shortage Allocation (mgd)114.20 FY24-25 2025
Burlingame FY24-25 2025 2.97 14%3%Overall Reduction from Base Period Required -15%FY24-25 2025
Coastside FY24-25 2025 1.38 19%1%SFPUC Maximum Cutback Factor -22%FY24-25 2025
CWS - Total FY24-25 2025 23.24 20%20%SFPUC Minimum Cutback Factor -5%FY24-25 2025
Daly City FY24-25 2025 3.64 5%3%Non-Residential Base Allocation %93%FY24-25 2025
East Palo Alto FY24-25 2025 1.49 5%1%Step 5 Reserved % of Remaining Tier 1 Allocation (less Step 50%FY24-25 2025
Estero FY24-25 2025 3.57 17%3%Unreserved % of Remaining Tier 1 Allocation (less Step 3 50%FY24-25 2025
Hayward FY24-25 2025 12.50 12%11%Seasonal Allocation %8%FY24-25 2025
Hillsborough FY24-25 2025 2.30 14%2%Step 5 ISG Weighting 33%FY24-25 2025
Menlo Park FY24-25 2025 2.61 16%2%Step 5 Base SFPUC Purchases Weighting 67%FY24-25 2025
Mid-Peninsula FY24-25 2025 2.24 15%2%Residential Efficient Allocation (R-GPCD)47.0 FY24-25 2025
Millbrae FY24-25 2025 1.71 11%1%Adjustment % for SFPUC Minimum Cutback, if efficient 95%FY24-25 2025
Milpitas FY24-25 2025 5.06 11%4%
Mountain View FY24-25 2025 6.84 12%6%
North Coast FY24-25 2025 2.20 8%2%
Palo Alto FY24-25 2025 8.88 11%8%
Purissima Hills FY24-25 2025 1.26 31%1%
Redwood City FY24-25 2025 6.95 19%6%
San Bruno FY24-25 2025 0.88 5%1%
San Jose FY24-25 2025 3.79 11%3%
Santa Clara FY24-25 2025 2.70 17%2%
Stanford FY24-25 2025 1.36 5%1%
Sunnyvale FY24-25 2025 7.75 18%7%
Westborough FY24-25 2025 0.76 5%1%
Page 19 of 19
Docusign Envelope ID: 2591B07A-5EB9-425B-AFC4-237059FF071A
Certificate Of Completion
Envelope Id: 2591B07A-5EB9-425B-AFC4-237059FF071A Status: Completed
Subject: Complete with Docusign: RESO 10245_.pdf
Source Envelope:
Document Pages: 23 Signatures: 6 Envelope Originator:
Certificate Pages: 5 Initials: 0 Francesca Reyes
AutoNav: Enabled
EnvelopeId Stamping: Enabled
Time Zone: (UTC-08:00) Pacific Time (US & Canada)
250 Hamilton Ave
Palo Alto , CA 94301
Francesca.Reyes@CityofPaloAlto.org
IP Address: 2601:647:4800:2
Record Tracking
Status: Original
9/8/2025 4:16:39 PM
Holder: Francesca Reyes
Francesca.Reyes@CityofPaloAlto.org
Location: DocuSign
Security Appliance Status: Connected Pool: StateLocal
Storage Appliance Status: Connected Pool: City of Palo Alto Location: Docusign
Signer Events Signature Timestamp
Amy Bartell
Amy.Bartell@paloalto.gov
Assistant City Attorney
City of Palo Alto
Security Level: Email, Account Authentication
(None)
Signature Adoption: Pre-selected Style
Using IP Address: 199.33.32.254
Sent: 9/8/2025 4:19:28 PM
Viewed: 9/9/2025 8:32:27 AM
Signed: 9/9/2025 8:33:08 AM
Electronic Record and Signature Disclosure:
Accepted: 7/16/2015 5:52:40 AM
ID: d8ecb53d-ef81-4016-8886-1560c48de42a
Lauren Lai
Lauren.Lai@paloalto.gov
Director Administrative Services/CFO
COPA
Security Level: Email, Account Authentication
(None)
Signature Adoption: Drawn on Device
Using IP Address: 199.33.32.254
Sent: 9/9/2025 8:33:10 AM
Viewed: 9/9/2025 2:46:53 PM
Signed: 9/9/2025 2:47:03 PM
Electronic Record and Signature Disclosure:
Not Offered via Docusign
Alan Kurotori
Alan.Kurotori@paloalto.gov
Director of Utilities
City of Palo Alto
Security Level: Email, Account Authentication
(None)
Signature Adoption: Pre-selected Style
Using IP Address: 199.33.32.254
Sent: 9/9/2025 2:47:04 PM
Viewed: 9/10/2025 4:24:47 PM
Signed: 9/10/2025 4:25:06 PM
Electronic Record and Signature Disclosure:
Not Offered via Docusign
Ed Shikada
Ed.Shikada@paloalto.gov
Ed Shikada
City of Palo Alto
Security Level: Email, Account Authentication
(None)
Signature Adoption: Pre-selected Style
Using IP Address: 199.33.32.254
Sent: 9/10/2025 4:25:07 PM
Viewed: 9/11/2025 3:28:34 PM
Signed: 9/11/2025 3:28:43 PM
Electronic Record and Signature Disclosure:
Not Offered via Docusign
Signer Events Signature Timestamp
Ed Lauing
Ed.Lauing@paloalto.gov
Security Level: Email, Account Authentication
(None)
Signature Adoption: Pre-selected Style
Using IP Address:
2601:647:6880:a6f0:5187:c4e0:1d48:e221
Sent: 9/11/2025 3:28:45 PM
Viewed: 9/11/2025 3:31:03 PM
Signed: 9/11/2025 3:31:27 PM
Electronic Record and Signature Disclosure:
Not Offered via Docusign
Mahealani Ah Yun
Mahealani.AhYun@paloalto.gov
Security Level: Email, Account Authentication
(None)
Signature Adoption: Pre-selected Style
Using IP Address:
2601:640:8e80:6e70:2d90:98ef:969d:4a8d
Sent: 9/11/2025 3:31:29 PM
Resent: 9/17/2025 7:46:39 AM
Viewed: 9/17/2025 9:15:50 AM
Signed: 9/17/2025 9:16:12 AM
Electronic Record and Signature Disclosure:
Not Offered via Docusign
In Person Signer Events Signature Timestamp
Editor Delivery Events Status Timestamp
Agent Delivery Events Status Timestamp
Intermediary Delivery Events Status Timestamp
Certified Delivery Events Status Timestamp
Carbon Copy Events Status Timestamp
Witness Events Signature Timestamp
Notary Events Signature Timestamp
Envelope Summary Events Status Timestamps
Envelope Sent Hashed/Encrypted 9/8/2025 4:19:28 PM
Certified Delivered Security Checked 9/17/2025 9:15:50 AM
Signing Complete Security Checked 9/17/2025 9:16:12 AM
Completed Security Checked 9/17/2025 9:16:12 AM
Payment Events Status Timestamps
Electronic Record and Signature Disclosure
CONSUMER DISCLOSURE
From time to time, City of Palo Alto (we, us or Company) may be required by law to provide to
you certain written notices or disclosures. Described below are the terms and conditions for
providing to you such notices and disclosures electronically through your DocuSign, Inc.
(DocuSign) Express user account. Please read the information below carefully and thoroughly,
and if you can access this information electronically to your satisfaction and agree to these terms
and conditions, please confirm your agreement by clicking the 'I agree' button at the bottom of
this document.
Getting paper copies
At any time, you may request from us a paper copy of any record provided or made available
electronically to you by us. For such copies, as long as you are an authorized user of the
DocuSign system you will have the ability to download and print any documents we send to you
through your DocuSign user account for a limited period of time (usually 30 days) after such
documents are first sent to you. After such time, if you wish for us to send you paper copies of
any such documents from our office to you, you will be charged a $0.00 per-page fee. You may
request delivery of such paper copies from us by following the procedure described below.
Withdrawing your consent
If you decide to receive notices and disclosures from us electronically, you may at any time
change your mind and tell us that thereafter you want to receive required notices and disclosures
only in paper format. How you must inform us of your decision to receive future notices and
disclosure in paper format and withdraw your consent to receive notices and disclosures
electronically is described below.
Consequences of changing your mind
If you elect to receive required notices and disclosures only in paper format, it will slow the
speed at which we can complete certain steps in transactions with you and delivering services to
you because we will need first to send the required notices or disclosures to you in paper format,
and then wait until we receive back from you your acknowledgment of your receipt of such
paper notices or disclosures. To indicate to us that you are changing your mind, you must
withdraw your consent using the DocuSign 'Withdraw Consent' form on the signing page of your
DocuSign account. This will indicate to us that you have withdrawn your consent to receive
required notices and disclosures electronically from us and you will no longer be able to use your
DocuSign Express user account to receive required notices and consents electronically from us
or to sign electronically documents from us.
All notices and disclosures will be sent to you electronically
Unless you tell us otherwise in accordance with the procedures described herein, we will provide
electronically to you through your DocuSign user account all required notices, disclosures,
authorizations, acknowledgements, and other documents that are required to be provided or
made available to you during the course of our relationship with you. To reduce the chance of
you inadvertently not receiving any notice or disclosure, we prefer to provide all of the required
notices and disclosures to you by the same method and to the same address that you have given
us. Thus, you can receive all the disclosures and notices electronically or in paper format through
the paper mail delivery system. If you do not agree with this process, please let us know as
described below. Please also see the paragraph immediately above that describes the
consequences of your electing not to receive delivery of the notices and disclosures
electronically from us.
Electronic Record and Signature Disclosure created on: 10/1/2013 8:33:53 AM
Parties agreed to: Amy Bartell
How to contact City of Palo Alto:
You may contact us to let us know of your changes as to how we may contact you electronically,
to request paper copies of certain information from us, and to withdraw your prior consent to
receive notices and disclosures electronically as follows:
To contact us by email send messages to: david.ramberg@cityofpaloalto.org
To advise City of Palo Alto of your new e-mail address
To let us know of a change in your e-mail address where we should send notices and disclosures
electronically to you, you must send an email message to us at
david.ramberg@cityofpaloalto.org and in the body of such request you must state: your previous
e-mail address, your new e-mail address. We do not require any other information from you to
change your email address..
In addition, you must notify DocuSign, Inc to arrange for your new email address to be reflected
in your DocuSign account by following the process for changing e-mail in DocuSign.
To request paper copies from City of Palo Alto
To request delivery from us of paper copies of the notices and disclosures previously provided
by us to you electronically, you must send us an e-mail to david.ramberg@cityofpaloalto.org and
in the body of such request you must state your e-mail address, full name, US Postal address, and
telephone number. We will bill you for any fees at that time, if any.
To withdraw your consent with City of Palo Alto
To inform us that you no longer want to receive future notices and disclosures in electronic
format you may:
i. decline to sign a document from within your DocuSign account, and on the subsequent
page, select the check-box indicating you wish to withdraw your consent, or you may;
ii. send us an e-mail to david.ramberg@cityofpaloalto.org and in the body of such request
you must state your e-mail, full name, IS Postal Address, telephone number, and account
number. We do not need any other information from you to withdraw consent.. The
consequences of your withdrawing consent for online documents will be that transactions
may take a longer time to process..
Required hardware and software
Operating Systems: Windows2000? or WindowsXP?
Browsers (for SENDERS): Internet Explorer 6.0? or above
Browsers (for SIGNERS): Internet Explorer 6.0?, Mozilla FireFox 1.0,
NetScape 7.2 (or above)
Email: Access to a valid email account
Screen Resolution: 800 x 600 minimum
Enabled Security Settings:
•Allow per session cookies
•Users accessing the internet behind a Proxy
Server must enable HTTP 1.1 settings via
proxy connection
** These minimum requirements are subject to change. If these requirements change, we will
provide you with an email message at the email address we have on file for you at that time
providing you with the revised hardware and software requirements, at which time you will
have the right to withdraw your consent.
Acknowledging your access and consent to receive materials electronically
To confirm to us that you can access this information electronically, which will be similar to
other electronic notices and disclosures that we will provide to you, please verify that you
were able to read this electronic disclosure and that you also were able to print on paper or
electronically save this page for your future reference and access or that you were able to
e-mail this disclosure and consent to an address where you will be able to print on paper or
save it for your future reference and access. Further, if you consent to receiving notices and
disclosures exclusively in electronic format on the terms and conditions described above,
please let us know by clicking the 'I agree' button below.
By checking the 'I Agree' box, I confirm that:
• I can access and read this Electronic CONSENT TO ELECTRONIC RECEIPT OF
ELECTRONIC CONSUMER DISCLOSURES document; and
• I can print on paper the disclosure or save or send the disclosure to a place where I can
print it, for future reference and access; and
• Until or unless I notify City of Palo Alto as described above, I consent to receive from
exclusively through electronic means all notices, disclosures, authorizations,
acknowledgements, and other documents that are required to be provided or made
available to me by City of Palo Alto during the course of my relationship with you.