Loading...
HomeMy WebLinkAboutReso - CC - 110-2025RESOLUTION NO. 110-2025 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF BURLINGAME APPROVING TIER 2 DROUGHT RESPONSE IMPLEMENTATION PLAN PURSUANT TO SECTION 3.11.C OF THE AMENDED AND RESTATED WATER SUPPLY AGREEMENT THIS RESOLUTION IS ADOPTED based upon the following facts and circumstances: WHEREAS, The City of Burlingame 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 WHEREAS, 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 WHEREAS, 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 WHEREAS, 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 WHEREAS, 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 adopted by the governing body of their respective agencies; and WHEREAS, The Tier 2 Plan allocates the collective Wholesale Customer share of Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A 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. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Burlingame as follows: 1. The Tier 2 Drought Response Implementation Plan, as attached as Exhibit A (Tier 2 Plan), is approved. 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. 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. Peter Stevenson, Mayor I, MEAGHAN HASSEL-SHEARER, City Clerk of the City of Burlingame, certify that the foregoing Resolution was introduced at a regular meeting of the City Council held on the 6th day of October, 2025, and was adopted thereafter by the following vote: AYES: NOES: ABSENT: COUNCILMEMBERS: Brownrigg, Colson, Pappajohn, Stevenson, Thayer COUNCILMEMBERS: None COUNCILMEMBERS: None Meaghan Hassel-Shearer, City Clerk Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A Tier 2 Drought Response Implementation Plan Drought Shortage Allocation Plan for the Regional Water System Wholesale Customers Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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 meters 2. 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A Tier 2 Drought Implementation Plan July 2024 Model Concept - Efficient Res Allocation + Non-Res Base Allocation + Seasonal Allocation + Base SFPUC Purchases/ISG-Based Allocation - Variable Base Year Model Set-up/Assumptions Base Years Allocation Year/Projection Year FY24-25 Non-Drought Year 1 FY18-19 Tier 1 Shortage Allocation (mgd)114.20 Non-Drought Year 2 FY19-20 Base Period SFPUC Purchases (mgd)134.34 Non-Drought Year 3 FY20-21 Overall Reduction from Base Period Required -15.0% SFPUC Maximum Cutback Factor -22.5%Error Message(s) (if applicable) SFPUC Minimum Cutback Factor -5.0% Non-Residential Base Allocation %92.5% Step 5 Reserved % of Remaining Tier 1 Allocation (less Step 3 Reserved) after Step 2 50% Unreserved % of Remaining Tier 1 Allocation (less Step 3 Reserved and Step 5 Reserved) After Step 2 50% Seasonal Allocation %7.9% Step 5 ISG Weighting 33% Step 5 Base SFPUC Purchases Weighting 67% Residential Efficient Allocation (R- GPCD)47.0 Adjustment % for SFPUC Minimum Cutback, if efficient residential allocation is greater than minimum cutback 95% Effective Date for Model Run (update for testing only)12/16/2024 Instructions: 1. Adjust aqua cells in OVERVIEW tab to adjust model parameters. If there are errors in the inputs, an error message will appear in Columns E-F. 2. View allocation calculations and results in "Tier 2 Allocation" and "Agency Charts" tabs. Calculation Steps for July 2024 Model Concept: 0. SFPUC Minimum Cutback a. Calculate Minimum Cutback from Lesser of Base Period SFPUC Purchases and ISG (Lesser ofBase Period SFPUC Purchases and ISG × [1+SFPUC Minimum Cutback Factor]) b. Calculate Efficient Residential Allocation (population × per capita allocation × % SFPUC reliance)c. Determine if Minimum Cutback is greater than the Efficient Residential Allocation d. If Efficient Residential Allocation is greater than the Minimum Cutback, an agency's cutbackmay be no less than 5% 1. Efficient Residential Allocationa. Calculate Efficient Residential Allocation (population × per capita allocation) b. Account for % SFPUC Reliancec. Provide Efficient Residential Allocation 2. Non-Residential Base Allocationa. Incorporate Estimated % Indoor Use (see glossary for definition and calculation of % Indoor Use) b. Incorporate % Non-Residential Usec. Calculate Non-Residential Base Allocation (% Indoor Use × % Non-Residential Use × Base Period SFPUC Purchases × Non-Residential Indoor Allocation %)d. Add Non-Residential Base Allocation to the Step 1 Allocation 3. Calculate Potential SFPUC Maximum Cutback Needa.Calculate SFPUC Maximum Cutback (Base Period SFPUC Purchases × [1+ SFPUC Maximum Cutback Factor])b. Reserve the sum of the potential SFPUC Maximum Cutback need for Step 5 (Maximum Cutback Reserve)4. Seasonal Allocation a. Determine % Seasonal Use (1 -% Indoor Use)b. Calculate seasonal SFPUC Purchases (Base Period SFPUC Purchases × % Seasonal Use) c. Calculate Seasonal Allocation (seasonal SFPUC Purchases × Seasonal Allocation %)d. Add the Seasonal Allocation to the Step 2 Allocation 5. Base Period/ISG-Based Allocationa. Calculate weighted average of Base Period SFPUC Purchases and ISG, up to Minimum Cutback b. Calculate Weighted Share of total Tier 1 Allocation to Wholesale Customers (agency weightedaverage Base Period SFPUC Purchases/ISG ÷ total Wholesale Customer weighted average × Tier 1 Allocation)c. Calculate the gap between Step 4 allocation and the lesser of 1) weighted share, or 2) Minimum Cutbackd. Allocate remaining supplies, except Maximum Cutback Reserve, among agencies with a gap, proportionately to gap, up to the Minimum Cutbacke. Confirm allocation meets Maximum Cutback; allocate water from Maximum Cutback Reserve up to Maximum Cutbackf. Allocate remaining supplies among agencies with a gap, proportionately to gap, up to the Minimum Cutback Attachment C: Example of Tier 2 Plan Excel-Based Model Calculations Page 15 of 19 Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A                          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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A Tier 2 Drought Response Implementation Plan Drought Shortage Allocation Plan for the Regional Water System Wholesale Customers Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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 meters 2. 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A Tier 2 Drought Implementation Plan July 2024 Model Concept - Efficient Res Allocation + Non-Res Base Allocation + Seasonal Allocation + Base SFPUC Purchases/ISG-Based Allocation - Variable Base Year Model Set-up/Assumptions Base Years Allocation Year/Projection Year FY24-25 Non-Drought Year 1 FY18-19 Tier 1 Shortage Allocation (mgd)114.20 Non-Drought Year 2 FY19-20 Base Period SFPUC Purchases (mgd)134.34 Non-Drought Year 3 FY20-21 Overall Reduction from Base Period Required -15.0% SFPUC Maximum Cutback Factor -22.5%Error Message(s) (if applicable) SFPUC Minimum Cutback Factor -5.0% Non-Residential Base Allocation %92.5% Step 5 Reserved % of Remaining Tier 1 Allocation (less Step 3 Reserved) after Step 2 50% Unreserved % of Remaining Tier 1 Allocation (less Step 3 Reserved and Step 5 Reserved) After Step 2 50% Seasonal Allocation %7.9% Step 5 ISG Weighting 33% Step 5 Base SFPUC Purchases Weighting 67% Residential Efficient Allocation (R- GPCD)47.0 Adjustment % for SFPUC Minimum Cutback, if efficient residential allocation is greater than minimum cutback 95% Effective Date for Model Run (update for testing only)12/16/2024 Instructions: 1. Adjust aqua cells in OVERVIEW tab to adjust model parameters. If there are errors in the inputs, an error message will appear in Columns E-F. 2. View allocation calculations and results in "Tier 2 Allocation" and "Agency Charts" tabs. Calculation Steps for July 2024 Model Concept: 0. SFPUC Minimum Cutback a. Calculate Minimum Cutback from Lesser of Base Period SFPUC Purchases and ISG (Lesser ofBase Period SFPUC Purchases and ISG × [1+SFPUC Minimum Cutback Factor]) b. Calculate Efficient Residential Allocation (population × per capita allocation × % SFPUC reliance)c. Determine if Minimum Cutback is greater than the Efficient Residential Allocation d. If Efficient Residential Allocation is greater than the Minimum Cutback, an agency's cutbackmay be no less than 5% 1. Efficient Residential Allocationa. Calculate Efficient Residential Allocation (population × per capita allocation) b. Account for % SFPUC Reliancec. Provide Efficient Residential Allocation 2. Non-Residential Base Allocationa. Incorporate Estimated % Indoor Use (see glossary for definition and calculation of % Indoor Use) b. Incorporate % Non-Residential Usec. Calculate Non-Residential Base Allocation (% Indoor Use × % Non-Residential Use × Base Period SFPUC Purchases × Non-Residential Indoor Allocation %)d. Add Non-Residential Base Allocation to the Step 1 Allocation 3. Calculate Potential SFPUC Maximum Cutback Needa.Calculate SFPUC Maximum Cutback (Base Period SFPUC Purchases × [1+ SFPUC Maximum Cutback Factor])b. Reserve the sum of the potential SFPUC Maximum Cutback need for Step 5 (Maximum Cutback Reserve)4. Seasonal Allocation a. Determine % Seasonal Use (1 -% Indoor Use)b. Calculate seasonal SFPUC Purchases (Base Period SFPUC Purchases × % Seasonal Use) c. Calculate Seasonal Allocation (seasonal SFPUC Purchases × Seasonal Allocation %)d. Add the Seasonal Allocation to the Step 2 Allocation 5. Base Period/ISG-Based Allocationa. Calculate weighted average of Base Period SFPUC Purchases and ISG, up to Minimum Cutback b. Calculate Weighted Share of total Tier 1 Allocation to Wholesale Customers (agency weightedaverage Base Period SFPUC Purchases/ISG ÷ total Wholesale Customer weighted average × Tier 1 Allocation)c. Calculate the gap between Step 4 allocation and the lesser of 1) weighted share, or 2) Minimum Cutbackd. Allocate remaining supplies, except Maximum Cutback Reserve, among agencies with a gap, proportionately to gap, up to the Minimum Cutbacke. Confirm allocation meets Maximum Cutback; allocate water from Maximum Cutback Reserve up to Maximum Cutbackf. Allocate remaining supplies among agencies with a gap, proportionately to gap, up to the Minimum Cutback Attachment C: Example of Tier 2 Plan Excel-Based Model Calculations Page 15 of 19 Docusign Envelope ID: 9EC87010-609C-4D21-8464-2F4DD085380A                          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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A 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: 9EC87010-609C-4D21-8464-2F4DD085380A