Laserfiche WebLink
21464584.11 <br />ATTACHMENT E-3 <br />Illustrations of Imputed Sales Considering Collective Regional Water System Use <br />by Original Minimum Purchase Customers Compared to Sum of Minimum Annual <br />Purchase Quantities Pursuant to Section 3.07.E <br />Scenario 1: Collective Purchases Equal to or Greater Than Sum of MAPQs1 (No Imputed Sales)2 <br />Line <br />#Wholesale Customer <br />A B C D <br />E = (D[LINE #] <br />/ D5) × (B5 - <br />A5) <br />MAPQ <br />RWS3 <br />Use <br />(mgd) <br />RWS <br />Over <br />MAPQ <br />(mgd) <br />RWS <br />Under <br />MAPQ <br />(mgd) <br />Proportion of <br />Use Under <br />Total MAPQ <br />(mgd) <br />1 Alameda County Water District 6.682 7.682 1.00 N/A <br />2 City of Milpitas 4.371 3.871 -0.50 N/A <br />3 City of Mountain View 6.047 5.047 -1.00 N/A <br />4 City of Sunnyvale 7.412 7.912 0.50 N/A <br />5 Total 24.512 24.512 1.50 -1.50 N/A <br />Scenario 2: Collective Purchases Less Than Sum of MAPQs (by 1.0 mgd) (Imputed Sales)4 <br />Line <br />#Wholesale Customer <br />A B C D <br />E = (D[LINE #] <br />/ D5) × (B5 - <br />A5) <br />MAPQ <br />RWS <br />Use <br />(mgd) <br />RWS <br />Over <br />MAPQ <br />(mgd) <br />RWS <br />Under <br />MAPQ <br />(mgd) <br />Proportion of <br />Use Under <br />Total MAPQ <br />(mgd) <br />1 Alameda County Water District 6.682 7.182 0.50 N/A <br />2 City of Milpitas 4.371 3.871 -0.50 -0.25 <br />3 City of Mountain View 6.047 4.547 -1.50 -0.75 <br />4 City of Sunnyvale 7.412 7.912 0.50 N/A <br />5 Total 24.512 23.512 1.00 -2.00 -1.0 <br />1 Minimum Annual Purchase Quantity (MAPQ) <br />2 In Scenario 1, the Original Minimum Purchase Customers’ collective purchases from San Francisco in a particular <br />fiscal year (Line 5B) are equal to the sum of their Minimum Annual Purchase Quantities (Line 5A). Therefore, no <br />Imputed Sales are applied to individual Original Minimum Purchase Customers that purchased less than their <br />individual Minimum Annual Purchase Quantities (in this scenario, Milpitas and Mountain View). <br />3 Regional Water System (RWS) <br />4 In Scenario 2, the Original Minimum Purchase Customers’ collective purchases from San Francisco in a particular <br />fiscal year (Line 5B) are 1.0 mgd less than the sum of their Minimum Annual Purchase Quantities (Line 5A). <br />Therefore, Imputed Sales are applied proportionally to any individual Original Minimum Purchase Customer that <br />purchased less than its individual Minimum Annual Purchase Quantity (in this scenario, Milpitas and Mountain View), <br />so that customer is responsible for its share of the difference between the sum of all Minimum Annual Purchase <br />Quantities (Line 5A) and the collective amount of RWS use (Line 5B). In this scenario, Mountain View is responsible <br />for 75% and Milpitas is responsible for 25% of the 1.0 mgd difference between Line 5A and Line 5B. <br />ATTY/RESO.0091/CC RESO AMENDING 2021 AMENDED AND RESTATED WATER SUPPLY AGREEMENT - EXHIBIT A <br />REV: 08-18-25 MI <br /> <br />Page 26 of 34