Reso25 16349 - Laserfiche WebLink

Browse Search

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 19ATTY/RESO.0092/CC RESO APPROVING TIER 2 DROUGHT RESPONSE IMPLEMENTATION PLAN (WATER SUPPLY AGREEMENT) - EXHIBIT A REV: 08-18-25 MI Page 17 of 21