91 2021 Amended and Restated WSA 17162043.1
4. T he Wholesale Customers’ claim that the SFPUC is not entitled to impose a surcharge for lost power generation revenues attributable to furnishing water in excess of the Supply Assurance. This claim may not be asserted unless and until SFPUC furnishes water in excess of the Supply Assurance during the Term and also includes such a surcharge in the price of such water.
5. Claims by Wholesale Customers (other than San Jose and Santa Clara, whose service areas are fixed) that SFPUC is obligated under the Act or state law to furnish water, within their Individual Supply Guarantee, for delivery to customers outside their existing service area and that Wholesale Customers are entitled to enlarge their service areas to supply those customers. Such claims may be asserted only after compliance with the procedure set forth in Section 3.03, followed by SFPUC’s denial of, or failure for six months to act on, a written request by a Wholesale Customer to expand its service area.
C. Waived Activities. The Wholesale Customers (and the SFPUC, where specified) will refrain from the following activities during the Term (or portions thereof, as specified):
1. The Wholesale Customers and the SFPUC will not contend before any court, administrative agency or legislative body or committee that the methodology for determining the Wholesale Revenue Requirement (or the requirements for (a) amortization of the ending balance under the 1984 Agreement, or (b) contribution to the Wholesale Revenue Coverage) determined in accordance with this Agreement violates the Act or any other provision of federal law, state law, or San Francisco’s City Charter, or is unfair, unreasonable or unlawful.
2. The Wholesale Customers will not challenge the transfer of funds by the SFPUC to any other San Francisco City department or fund, provided such transfer complies with the San Francisco City Charter. The transfer of its funds, whether or not permitted by the City Charter, will not excuse the SFPUC from its failure to perform any obligation imposed by this Agreement.
3. The Wholesale Customers and the SFPUC will not assert monetary claims against one another based on the 1984 Agreement other than otherwise arbitrable claims arising from the three fiscal years immediately preceding the start of the Term (i.e., FYs 2006-07, 2007-08 and 2008-09). Such claims, if any, shall be governed by the dispute resolution provisions of this Agreement, except that the time within which arbitration must be commenced shall be 18 months from delivery of the Compliance Auditor’s report.
92 2021 Amended and Restated WSA 17162043.1
D. Other
1. This Agreement shall determine the respective monetary rights and obligations of the parties with respect to water sold by the SFPUC to the Wholesale Customers during the Term. Such rights and obligations shall not be affected by any judgments or orders issued by any court in litigation, whether or not between parties hereto, and whether or not related to the controversy over co-grantee status, except for arbitration and/or litigation expressly permitted in this Agreement. No judicial or other resolution of issues reserved by this section will affect the Wholesale Revenue Requirement which, during the Term, will be determined exclusively as provided in Articles 5, 6 and 7 of this Agreement.
2. Because delays in the budget process or other events may cause the SFPUC to defer the effective date of changes in wholesale rates until after the beginning of the fiscal year, this Agreement does not require the SFPUC to make changes in wholesale rates effective at the start of the fiscal year or at any other specific date.
3. T he Wholesale Customers do not, by executing this Agreement, concede the legality of the SFPUC’s establishing Interim Supply Allocations, as provided in Article 4 or imposing Environmental Enhancement Surcharges on water use in excess of such allocations.
Any Wholesale Customer may challenge such allocation when imposed and/or such surcharges if and when levied, in any court of competent jurisdiction.
4. The furnishing of water in excess of the Supply Assurance by San Francisco to the Wholesale Customers shall not be deemed or construed to be a waiver by San Francisco of its claim that it has no obligation under any provision of law to supply such water to the Wholesale Customers, nor shall it constitute a dedication by San Francisco to the Wholesale Customers of such water.
8.08. Prohibition of Assignment
A. This Agreement shall be binding on, and shall inure to the benefit of, the parties and their respective successors and permitted assigns. Each Wholesale Customer agrees that it will not transfer or assign any rights or privileges under this Agreement, either in whole or in part, or make any transfer of all or any part of its water system or allow the use thereof in any manner whereby any provision of this Agreement will not continue to be binding on it, its assignee or transferee, or such user of the system. Any assignment or transfer in violation of this covenant, and any assignment or transfer that would result in the supply of water in violation of the Act, shall be void.
93 2021 Amended and Restated WSA 17162043.1
B. N othing in this section shall prevent any Wholesale Customer (except the California Water Service Company and Stanford) from entering into a joint powers agreement or a municipal or multi-party water district with any other Wholesale Customer (except the two listed above) to exercise the rights and obligations granted to and imposed upon the Wholesale Customers hereunder, nor shall this section prevent any Wholesale Customer (except the two listed above) from succeeding to the rights and obligations of another Wholesale Customer hereunder as long as the Wholesale Service Area served by the Wholesale Customers involved in the succession is not thereby enlarged.
8.09. Notices
A. All notices and other documents that San Francisco is required or permitted to send to the Wholesale Customers under this Agreement shall be sent to each and all of the Wholesale Customers by United States mail, first class postage prepaid, addressed to each Wholesale Customer at the address to which monthly water bills are mailed by the Water Enterprise.
B. All notices or other documents which the Wholesale Customers are required or permitted to send to San Francisco under this Agreement shall be sent by United States mail, first class postage prepaid, addressed as follows:
General Manager
San Francisco Public Utilities Commission
525 Golden Gate Avenue, 13th Floor
San Francisco, CA 94102
C. Each Wholesale Customer is a member of BAWSCA. San Francisco shall send a copy of each notice or other document which it is required to send to all Wholesale Customers to BAWSCA addressed as follows:
General Manager/CEO
Bay Area Water Supply and Conservation Agency
155 Bovet Road, Suite 650
San Mateo, CA 94402
The failure of San Francisco to send a copy of such notices or documents to BAWSCA shall not invalidate any rate set or other action taken by San Francisco.
94 2021 Amended and Restated WSA 17162043.1
D. Any party (or BAWSCA) may change the address to which notice is to be sent to it under this Agreement by notice to San Francisco (in the case of a change desired by a Wholesale Customer or BAWSCA ) and to the Wholesale Customer and BAWSCA (in the case of a change desired by San Francisco).
The requirements for notice set forth in Section 8.01 concerning arbitration shall prevail over this section, when they are applicable.
8.10. Incorporation of Attachments
Attachments A through R, referred to herein, are incorporated in and made a part of this Agreement.
8.11. Interpretation
In interpreting this Agreement, or any provision thereof, it shall be deemed to have been drafted by all signatories, and no presumption pursuant to Civil Code Section 1654 may be invoked to determine the Agreement’s meaning. The marginal headings and titles to the sections and paragraphs of this Agreement are not a part of this Agreement and shall have no effect upon the construction or interpretation of any part hereof.
8.12. Actions and Approvals by San Francisco
Whenever action or approval by San Francisco is required or contemplated by this Agreement, authority to act or approve shall be exercised by the Commission, except if such action is required by law to be taken, or approval required to be given, by the San Francisco Board of Supervisors. The Commission may delegate authority to the General Manager in accordance with the San Francisco City Charter and Administrative Code, except for actions that this Agreement requires to be taken by the Commission.
8.13. Counterparts
Execution of this Agreement may be accomplished by execution of separate counterparts by each signatory. San Francisco shall deliver its executed counterpart to BAWSCA and the counterpart which each Wholesale Customer executes shall be delivered to San Francisco. The separate executed counterparts, taken together, shall constitute a single agreement.
95 2021 Amended and Restated WSA 17162043.1
8.14. Limitations on Damages
A. Unless otherwise prohibited by this Agreement, general or direct damages may be recovered for a breach of a party’s obligations under this Agreement. No party is liable for, or may recover from any other party, special, indirect or consequential damages or incidental damages, including, but not limited to, lost profits or revenue. No damages may be awarded for a breach of Section 8.17.
B. The limitations in subsection A apply only to claims for damages for an alleged breach of this Agreement. These limitations do not apply to claims for damages for an alleged breach of a legal duty that arises independently of this Agreement, established by constitution or statute.
C. If damages would be an inadequate remedy for a breach of this Agreement, equitable relief may be awarded by a court in a case in which it is otherwise proper.
D. This section does not apply to any claim of breach for which arbitration is the exclusive remedy pursuant to Section 8.01.A.
8.15. Force Majeure
A. Excuse from Performance. No party shall be liable in damages to any other party for delay in performance of, or failure to perform, its obligations under this Agreement, including the obligations set forth in Sections 3.09 and 4.06, if such delay or failure is caused by a “Force Majeure Event.”
B. Notice. The party claiming excuse shall deliver to the other parties a written notice of intent to claim excuse from performance under this Agreement by reason of a Force Majeure Event. Notice required by this section shall be given promptly in light of the circumstances, and, in the case of events described in (c), (d) or (e) of the definition of Force Majeure Event only, not later than ten (10) days after the occurrence of the Force Majeure Event. Such notice shall describe the Force Majeure Event, the services impacted by the claimed event, the length of time that the party expects to be prevented from performing, and the steps which the party intends to take to restore its ability to perform.
C. Obligation to Restore Ability to Perform. Any suspension of performance by a party pursuant to this section shall be only to the extent, and for a period of no longer duration
96 2021 Amended and Restated WSA 17162043.1
than, required by the nature of the Force Majeure Event, and the party claiming excuse shall use its best efforts to remedy its inability to perform as quickly as possible.
8.16. No Third-Party Beneficiaries
This Agreement is exclusively for the benefit of the parties and not for the benefit of any other Person. There are no third-party beneficiaries of this Agreement and no person not a party shall have any rights under or interests in this Agreement.
No party may assert a claim for damages on behalf of a person other than itself, including a person that is not a party.
8.17. Good Faith and Fair Dealing
San Francisco and the Wholesale Customers each acknowledge their obligation under California law to act in good faith toward, and deal fairly with, each other with respect to this Agreement.
97 2021 Amended and Restated WSA 17162043.1
Article 9. Implementation and Special Provisions Affecting Certain Wholesale Customers
9.01. General; Individual Water Sales Contracts
A. As described in Section 1.03, San Francisco previously entered into Individual Water Sales Contracts with each of the Wholesale Customers. The term of the majority of Individual Water Sales Contracts will expire on June 30, 2009, concurrently with the expiration of the 1984 Agreement. Except as provided below in this Article, each of the Wholesale Customers will execute a new Individual Water Sales Contract with San Francisco concurrently with its approval of the Agreement.
B. The Individual Water Sales Contracts will describe the service area of each Wholesale Customer, identify the location and size of connections between the Regional Water System and the Wholesale Customer’s distribution system, provide for periodic rendering and payment of bills for water usage, and in some instances contain additional specialized provisions unique to the particular Wholesale Customer and not of general concern or applicability. A sample Individual Water Sales Contract is provided at Attachment F. The Individual Water Sales Contracts between San Francisco and the Wholesale Customers will not contain any provision inconsistent with Articles 1 through 8 of this Agreement except (1) as provided below in this Article or (2) to the extent that such provisions are not in derogation of the Fundamental Rights of other Wholesale Customers under this Agreement. Any provisions in an Individual Water Sales Contract which are in violation of this section shall be void.
9.02. California Water Service Company
A. The parties recognize that the California Water Service Company is an investor- owned utility company and, as such, has no claim to co-grantee status under the Act, which specifically bars private parties from receiving for resale any water produced by the Hetch Hetchy portion of the Regional Water System. Accordingly, the following provisions shall apply to the California Water Service Company, notwithstanding anything to the contrary elsewhere in this Agreement.
B. The total quantity of water delivered by San Francisco to the California Water Service Company shall not in any calendar year exceed 47,400 acre feet, which is the estimated average annual production of Local System Water. If San Francisco develops additional Local System Water after the Effective Date, it may (1) increase the maximum
98 2021 Amended and Restated WSA 17162043.1
delivery amount stated herein; and (2) increase the Supply Assurance, but not necessarily both.
San Francisco has no obligation to deliver water to California Water Service Company in excess of the maximum stated herein, except as such maximum may be increased by San Francisco pursuant to this subsection. The maximum annual quantity of Local System Water set forth in this subsection is intended to be a limitation on the total quantity of water that may be allocated to California Water Service Company, and is not an Individual Supply Guarantee for purposes of Section 3.02. The maximum quantity of Local System Water set forth in this subsection is subject to reduction in response to (1) changes in long-term hydrology or (2) environmental water requirements that may be imposed by or negotiated with state and federal resource agencies in order to comply with state or federal law or to secure applicable permits for construction of Regional Water System facilities. San Francisco shall notify California Water Service Company of any anticipated reduction of the quantity of Local System Water set forth in this subsection, along with an explanation of the basis for the reduction.
C. Notwithstanding anything in Section 8.08 to the contrary, California Water Service Company shall have the right to assign to a public agency having the power of eminent domain all or a portion of the rights of California Water Service Company under any contract between it and San Francisco applicable to any individual district of California Water Service Company in connection with the acquisition by such public agency of all or a portion of the water system of California Water Service Company in such district. In the event of any such assignment of all the rights, privileges and obligations of California Water Service Company under such contract, California Water Service Company shall be relieved of all further obligations under such contract provided that the assignee public agency expressly assumes the obligations of California Water Service Company thereunder. In the event of such an assignment of a portion of the rights, privileges and obligations of California Water Service Company under such contract, California Water Service Company shall be relieved of such portion of such obligations so assigned thereunder provided that the assignee public agency shall expressly assume such obligations so assigned to it.
D. Should California Water Service Company seek to take over or otherwise acquire, in whole or in part, the service obligations of another Wholesale Customer under Section 3.03.E, it will so inform San Francisco at least six months prior to the effective date of the sale and provide information concerning the total additional demand proposed to be served, in order that San Francisco may compare the proposed additional demand to the then-current estimate of Local System Water. In this regard, California Water Service Company has notified
99 2021 Amended and Restated WSA 17162043.1
the SFPUC that it has reached an agreement to acquire the assets of Skyline County Water District (“Skyline”) and assume the responsibility for providing water service to customers in the Skyline service area. California Water Service Company has advised the SFPUC that, on September 18, 2008, the California Public Utilities Commission approved California Water Service Company’s acquisition of Skyline. The SFPUC anticipates approving the transfer of Skyline’s Supply Guarantee as shown on Attachment C to California Water Service Company and the expansion of California Water Service Company’s service area to include the current Skyline service area before the Effective Date of this Agreement. All parties to this Agreement authorize corresponding modifications of Attachment C, as well as any of the Agreement’s other provisions, to reflect the foregoing transaction without the necessity of amending this Agreement.
E. Nothing in this Agreement shall preclude San Francisco from selling water to any county, city, town, district, political subdivision, or other public agency for resale to customers within the service area of the California Water Service Company. Nothing in this Agreement shall require or contemplate any delivery of water to California Water Service Company in violation of the Act.
F. Nothing in this Agreement shall alter, amend or modify the Findings of Fact and Conclusions of Law and the Judgment dated May 25, 1961, in that certain action entitled City and County of San Francisco v. California Water Service Company in the Superior Court of the State of California in and for the County of Marin, No. 23286, as modified by the Quitclaim Deed from California Water Service Company to San Francisco dated August 22, 1961. The rights and obligations of San Francisco and California Water Service Company under these documents shall continue as therein set forth.
9.03. City of Hayward
A. San Francisco and the City of Hayward (“Hayward”) entered into a water supply contract on February 9, 1962 (“the 1962 contract”) which provides, inter alia, that San Francisco will supply Hayward with all water supplemental to sources and supplies of water owned or controlled by Hayward as of that date, in sufficient quantity to supply the total water needs of the service area described on an exhibit to the 1962 contract “on a permanent basis.” The service area map attached as Exhibit C to the 1962 contract was amended in 1974 to remove an area of land in the Hayward hills and in 2008 to make minor boundary adjustments identified in SFPUC Resolution No. 08-0035.
100
2021 Amended and Restated WSA 17162043.1
B. The intention of the parties is to continue the 1962 contract, as amended, in effect as the Individual Water Sales Contract between San Francisco and Hayward.
Accordingly, it shall not be necessary for San Francisco and Hayward to enter into a new Individual Water Sales Contract pursuant to this Article and approval of this Agreement by Hayward shall constitute approval of both this Agreement and an Individual Water Sales Contract for purposes of Section 1.03. The 1962 contract, as amended, will continue to describe the service area of Hayward, while rates for water delivered to Hayward during the Term shall be governed by Article 5 hereof. The 1962 contract, as amended, will continue in force after the expiration of the Term.
9.04. Estero Municipal Improvement District
A. San Francisco and the Estero Municipal Improvement District (“Estero”) entered into a water supply contract on August 24, 1961, the term of which continues until August 24, 2011 (“the 1961 Contract”). The 1961 Contract provides, inter alia, that San Francisco will supply Estero with all water supplemental to sources and supplies of water owned or controlled by Estero as of that date, in sufficient quantity to supply the total water needs of the service area described on an exhibit to the 1961 Contract.
B. The intention of the parties is to terminate the 1961 Contract and replace it with a new Individual Water Sales Contract which will become effective on July 1, 2009. The new Individual Water Sales Contract will describe the current service area of Estero. The Individual Supply Guarantee applicable to Estero shall be 5.9 MGD, rather than being determined as provided in the 1961 Contract.
9.05. Stanford University
A. The parties recognize that The Board of Trustees of The Leland Stanford Junior University (“Stanford”) operates a non-profit university, and purchases water from San Francisco for redistribution to the academic and related facilities and activities of the university and to residents of Stanford, the majority of whom are either employed by or students of Stanford. Stanford agrees that all water furnished by San Francisco shall be used by Stanford only for domestic purposes and those directly connected with the academic and related facilities and activities of Stanford, and no water furnished by San Francisco shall be used in any area now or hereafter leased or otherwise used for industrial purposes or for commercial purposes
101
2021 Amended and Restated WSA 17162043.1
other than those campus support facilities that provide direct services to Stanford faculty, students or staff such as the U.S. Post Office, the bookstore and Student Union.
Nothing in this Agreement shall preclude San Francisco from selling water to any county, city, town, political subdivision or other public agency for resale to Stanford or to customers within the service area of Stanford.
B. Notwithstanding anything in Section 8.08 to the contrary, Stanford shall have the right to assign to a public agency having the power of eminent domain all or a portion of the rights of Stanford under this Agreement or the Individual Water Sales Contract between it and San Francisco in connection with the acquisition by such public agency of all or a portion of Stanford’s water system. In the event of any such assignment of all the rights, privileges, and obligations of Stanford under such contract, Stanford shall be relieved of all further obligations under such contract, provided that the assignee public agency expressly assumes Stanford’s obligations thereunder. In the event of such an assignment of a portion of the rights, privileges, and obligations of Stanford under such contract, Stanford shall be relieved of such obligations so assigned thereunder, provided that the assignee public agency shall expressly assume such obligations so assigned to it.
Nothing in this Agreement shall require or contemplate any delivery of water to Stanford in violation of the Act.
9.06. City of San Jose and City of Santa Clara
A. Continued Supply on Temporary, Interruptible Basis. During the term of the 1984 Agreement, San Francisco provided water to the City of San Jose (“San Jose”) and the City of Santa Clara (“Santa Clara”) on a temporary, interruptible basis pursuant to SFPUC Resolution No. 85-0256. Subject to termination or reduction of supply as provided in Section
4.05 of this Agreement, San Francisco will continue to supply water to San Jose and Santa Clara on a temporary, interruptible basis pending a decision by the Commission, pursuant to Section 4.05.H, as to whether to make San Jose and Santa Clara permanent customers of the Regional Water System. San Francisco will furnish water to San Jose and Santa Clara at the same rates as those applicable to other Wholesale Customers pursuant to this Agreement.
Water delivered to San Jose and Santa Clara after July 1, 2009 may be limited by the SFPUC’s ability to meet the full needs of all its other Retail and Wholesale Customers. The service areas of San Jose and Santa Clara set forth in their Individual Water Sales Contracts may not be
102
2021 Amended and Restated WSA 17162043.1
expanded using the procedure set forth in Section 3.03. The combined annual average water usage of San Jose and Santa Clara shall not exceed 9 MGD. The allocation of that total amount between San Jose and Santa Clara shall be as set forth in their Individual Water Sales Contracts.
B. Reservation of Rights. In signing this Agreement, neither San Jose nor Santa Clara waives any of its rights to contend, in the event that San Francisco (1) elects to terminate or interrupt water deliveries to either or both of the two cities prior to 2028 using the process set forth in Section 4.05, or (2) does not elect to take either city on as a permanent customer in 2028, that it is entitled to permanent customer status, pursuant to the Act or any other federal or state law. Santa Clara's reservation of rights is limited to its existing Service Area A, as shown on Attachment Q-2. Service Area B, south of Highway 101, was added in 2018 solely for the operational convenience of Santa Clara. Santa Clara waives its right to make claims described in this Section 9.06.B and Section 8.07.B.3 with respect to Service Area B. In signing this Agreement, San Francisco does not waive its right to deny any or all such contentions.
9.07. City of Brisbane, Guadalupe Valley Municipal Improvement District, Town of Hillsborough
A. The parties acknowledge that San Francisco has heretofore provided certain quantities of water to the City of Brisbane (“Brisbane”), Guadalupe Valley Municipal Improvement District (“Guadalupe”) and the Town of Hillsborough (“Hillsborough”) at specified rates or without charge pursuant to obligations arising out of agreements between the predecessors of San Francisco and these parties, which agreements are referred to in judicial orders, resolutions of the SFPUC and/or the 1960 contracts between San Francisco and Brisbane, Guadalupe and Hillsborough. The parties intend to continue those arrangements and accordingly agree as follows:
1. Nothing in this Agreement is intended to alter, amend or modify the terms of SFPUC Resolution No. 74-0653 or the indenture of July 18, 1908 between the Guadalupe Development Company and the Spring Valley Water Company.
2. Nothing in this Agreement is intended to alter, amend or modify the Findings of Fact and Conclusions of Law and Judgment dated May 25, 1961 in that certain action entitled City and County of San Francisco v. Town of Hillsborough in the Superior Court of the State of California in and for the County of Marin, No. 23282, as modified by the Satisfaction of Judgment filed October 23, 1961 and the Compromise and Release between
103
2021 Amended and Restated WSA 17162043.1
Hillsborough and San Francisco dated August 22, 1961. The rights and obligations of Hillsborough under these documents shall continue as therein set forth.
3. Nothing in this Agreement is intended to affect or prejudice any claims, rights or remedies of Guadalupe or of Crocker Estate Company, a corporation, or of Crocker Land Company, a corporation, or of San Francisco, or of their successors and assigns, respectively, with respect to or arising out of that certain deed dated May 22, 1884, from Charles Crocker to Spring Valley Water Works, a corporation, recorded on May 24, 1884, in Book 37 of Deeds at page 356, Records of San Mateo County, California, as amended by that certain Deed of Exchange of Easements in Real Property and Agreement for Trade in Connection Therewith, dated July 29, 1954, recorded on August 4, 1954, in Book 2628, at page 298, Official Records of said San Mateo County, or with respect to or arising out of that certain action involving the validity or enforceability of certain provisions of said deed entitled City and County of San Francisco v. Crocker Estate Company, in the Superior Court of the State of California in and for the County of Marin, No. 23281.
///
///
///
///
///
///
///
///
///
///
///
ATTACHMENT A
17162158.1
Attachment A - Definitions
“1984 Agreement” refers to the 1984 Settlement Agreement and Master Water Sales Contract between the City and County of San Francisco and certain Suburban Purchasers in San Mateo County, Santa Clara County and Alameda County, which expires on June 30, 2009. “Act” refers to the Raker Act, 38 Stat. 242, the Act of Congress, enacted in 1913, that authorized the construction of the Hetch Hetchy system on federal lands. “Adjusted Proportional Annual Use” means the respective percentages of annual water use, as adjusted to reflect deliveries of water by the Hetch Hetchy Enterprise to outside City Retail Customers. The adjustment is calculated each year as described in Section B of Attachment J and is shown on lines 18 and 19 of Table 1 of that Attachment. “Agreement” refers to this Water Supply Agreement, by and among San Francisco and the Wholesale Customers who approve this Agreement in accordance with Section 1.03. “BAWSCA” refers to the Bay Area Water Supply and Conservation Agency established pursuant to Division 31 of the California Water Code (Water Code §§81300-81461) or its successor and permitted assigns.
“CEQA” refers to the California Environmental Quality Act found at §§21000 et seq. of the Public Resources Code and the Guidelines for the California Environmental Quality Act found at §§15000 et seq. of Title 14 of the California Code of Regulations, as amended from time to time. “Commission” means the governing board of the SFPUC, whose members, as of the date of this Agreement, are appointed by the Mayor of San Francisco and confirmed by the San Francisco Board of Supervisors.
“Compliance Audit” refers to the annual audit of the Wholesale Revenue Requirement by the Compliance Auditor required by Sections 7.03 through 7.05. “Compliance Auditor” refers to the independent certified public accountant chosen by the San Francisco Controller to conduct each fiscal year’s audit of the SFPUC’s calculation of the Wholesale Revenue Requirement as provided in Section 7.03.B.
17162158.1
“Countywide Cost Allocation Plan” refers to the full costs of the Water and Hetch Hetchy Enterprises’ prorated share of San Francisco city government expenses that are not directly billed to city departments, as determined by the Controller of the City and County of San Francisco.
“Debt Service” means principal and interest paid during a fiscal year on Indebtedness incurred by the SFPUC for the 2006 Revenue Bonds, Series A, and subsequently issued Indebtedness (exclusive of 2006 Revenue Bonds Series B and C), the proceeds of which are used or are scheduled to be used for the acquisition or construction of New Regional Assets or to refund such Indebtedness.
“Direct Retail” refers to Regional Water System capital or operating expenditures that are incurred to provide water service solely to Retail Customers. “Direct Wholesale” refers to Regional Water System capital or operating expenditures that are incurred to provide water service solely to one or more Wholesale Customers. “Drought” means 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.
“Effective Date” refers to the date this Agreement will become effective in accordance with the terms of Section 1.03.
“Emergency” means a sudden, non-drought event, such as an earthquake, failure of Regional Water System infrastructure or other catastrophic event or natural disaster that results in an insufficient supply of water available to the Retail or Wholesale Service Areas for basic human consumption, firefighting, sanitation, and fire protection. “Encumbrance” or “Encumber” refers to the process by which the City Controller certifies the availability of amounts previously appropriated by the Commission for specifically identified SFPUC capital projects performed either by third parties or through work orders to other City departments.
17162158.1
“Environmental Enhancement Surcharge” means the surcharge to be imposed by the SFPUC on individual parties to this Agreement whose use exceeds their Interim Supply Allocation when the collective use of water by all parties to this Agreement is in excess of the Interim Supply Limitation.
“ERRP” refers to a SFPUC document entitled Emergency Response and Recovery Plan:
Regional Water System (“ERRP”) dated August 23, 2003, and updated November 2006. “Excess Use Charges” are monthly charges set by the SFPUC, in the form of multipliers, that are applied to the Wholesale Customer water rates during times of mandatory rationing if a Wholesale Customer's water usage is greater than its shortage allocation. Excess Use Charges are further described in Section 4 of the Tier 1 Shortage Plan (Attachment H). “Existing Assets” refers to Regional and Hetch Hetchy Water-Only and Water-Related capital assets plant in service as of June 30, 2009.
“Existing System Assets” refers to all Water Enterprise and Hetch Hetchy Enterprise assets and assets that are components of, or appurtenances thereto. Existing Assets are a subset of the Existing System Assets for repayment of capital costs under Section 5.03. “Existing Facilities” means those wells and associated infrastructure owned by the Participating Pumpers and in existence as of the effective date of the Project Operating Agreement, and any replacements of Existing Facilities irrespective of location. “Force Majeure Event” means an event not the fault of, and beyond the reasonable control of, the party claiming excuse which makes it impossible or extremely impracticable for such party to perform obligations imposed on it by this Agreement, by virtue of its effect on physical facilities and their operation or employees essential to such performance. Force Majeure Events include (a) an “act of God” such as an earthquake, flood, earth movement, or similar catastrophic event, (b) an act of the public enemy, terrorism, sabotage, civil disturbance or similar event, (c) a strike, work stoppage, picketing or similar concerted labor action, (d) delays in construction caused by unanticipated negligence or breach of contract by a third party or inability to obtain essential materials after diligent and timely efforts; or (e) an order or regulation issued by a federal or state regulatory agency after the Effective Date or a judgment or order entered by a federal or state court after the Effective Date.
17162158.1
“Fundamental Rights” of Wholesale Customers are their status as parties to this Agreement, their allocation of water recognized in Section 3.02, their protection against arbitrary, unreasonable, or unjustly discriminatory rates provided in Section 6.04, and any specific rights described in Article 9.
“Groundwater Storage and Recovery Project” refers to a WSIP project for groundwater storage and recovery in the Southern portion of the Westside Basin approved in SFPUC Resolution No. 14-0127 dated August 12, 2014.
“Hetch Hetchy Enterprise” refers to Hetch Hetchy Water and Power Enterprise, a SFPUC operating department.
“Imputed Sales” apply when a Wholesale Customer does not meet the minimum annual purchase requirements of Section 3.07.C, except in fiscal years in which a waiver of these requirements is in effect. Imputed Sales are calculated as the difference between (1) a Wholesale Customer’s metered water purchases during a fiscal year, from July 1 to June 30, and (2) the larger of (a) or (b) as follows: (a) the Wholesale Customer’s Minimum Annual Purchase Quantity, as specified in Attachment E, or (b) the Wholesale Customer’s Temporary Modified Minimum Annual Purchase Quantity, as specified in Attachment E-1. If a Wholesale Customer has more than one Temporary Modified Minimum Annual Purchase Quantity, the largest quantity is used for calculating Imputed Sales. Imputed Sales are considered wholesale water usage for the purposes of calculating the Proportional Annual Use, and any fees charged for Imputed Sales are considered wholesale revenues.
“In Lieu Water” refers to Regional Water System water, subject to the limitations set forth in Section 9.02 of this Agreement for water delivered to California Water Service Company, that the SFPUC delivers at no charge on an interruptible basis to the Participating Pumpers, to replace groundwater that the Participating Pumpers refrain from pumping using their Existing Facilities during storage periods under the Project Operating Agreement. “Include” and its variants mean “including but not limited to” whenever used in this Agreement, regardless of whether or not it is capitalized.
“Indebtedness” includes revenue bonds, bond anticipation notes, certificates of participation (excluding certificates of participation towards which SFPUC contributes debt service as an operating expense), and commercial paper.
17162158.1
“Individual Water Sales Contract” refers to the contracts between each Wholesale Customer and San Francisco contemplated in Section 9.01 that details customer-specific matters such as location of service connections, service area maps and other matters specific to that customer. “Individual Supply Guarantee” refers to each Wholesale Customer’s share of the Supply Assurance, as shown in Attachment C.
“Interim Supply Allocation” refers to each Wholesale Customer’s share, to be established by the SFPUC pursuant to Section 4.02, of the Interim Supply Limitation. “Interim Supply Limitation” refers to the 265 MGD annual average limitation on water deliveries until December 31, 2018 from Regional Water System watersheds imposed by the SFPUC in its approval of the WSIP in Resolution Number 08-0200 dated October 30, 2008. “Irrigation Well Owners” refers to the Hills of Eternity, Home of Peace, and Salem Cemetery; Eternal Home Cemetery; Woodlawn Cemetery; Holy Cross Cemetery; Italian Cemetery; Olivet Cemetery; Cypress Lawn Cemetery; and the California Golf Club, located within the Southern portion of the Westside Basin.
“Irrigation Well Owner Replacement Water” refers to water supplied by the Regional Water System delivered on a standby basis by the SFPUC, or wheeled through California Water Service Company's South San Francisco District System, for delivery to Irrigation Well Owners as may be necessary under the MMRP.
“Joint,” when used in connection with Hetch Hetchy Enterprise assets or expenses, refers to assets used or expenses incurred in providing both water supply (“Water-Related”) and in the generation and transmission of electrical energy (“Power-Related”). “Level of Service Goals and Objectives” refers to the “Phased WSIP Goals and Objectives” adopted by the Commission in Resolution No. 08-0200 dated October 30, 2008 as part of the approval of the WSIP and any amendments that may be adopted by the Commission. “Local System Water” refers to Regional Water System water supplies developed in San Mateo, Alameda and Santa Clara Counties or otherwise not produced by the Hetch Hetchy Enterprise under rights of way granted by the Raker Act.
17162158.1
“MGD” refers to an average flow rate of one million gallons per day over a specific time period, often a year. For example, one MGD is equal to 365 million gallons per year or 1,120 acre feet per year.
“Minimum Annual Purchase Quantity” means the minimum amount of water that a Wholesale Customer that has an Individual Supply Guarantee agrees to purchase from San Francisco annually, as specified in Attachment E, as may be amended from time to time pursuant to Section 2.03.C.
“Mitigation, Monitoring and Reporting Program or “MMRP” refers to the CEQA required program of mitigation and monitoring adopted by the SFPUC as part of Groundwater Storage and Recovery Project approval in Resolution No. 14-0127. “Net Annual Debt Service” refers to debt service less payments made from proceeds of Indebtedness (e.g., capitalized interest), earnings on bond proceeds (e.g., reserve fund earnings) used to pay Debt Service, and interest paid from renewed commercial paper, or from reserve fund liquidation.
“New Assets” refers to Regional and Hetch Hetchy Water-Only and Water-Related capital assets added to Regional Water System plant in service after June 30, 2009. “New Regional Assets” refers to New Assets placed in service on or after July 1, 2009 that are used and useful in delivering water to Wholesale Customers. The following four categories comprise New Regional Assets:
1. Water Enterprise Regional Assets
2. Water Enterprise Direct Wholesale Assets
3. Hetch Hetchy Water Only Assets
4. Water-Related portion (45 percent) of Hetch Hetchy Joint Assets “Participating Pumpers” refers to the Wholesale Customers pumping groundwater who are parties to the Project Operating Agreement; specifically, the cities of Daly City and San Bruno and the California Water Service Company, South San Francisco Service Area. “Participating Pumper Replacement Water” refers to the quantity of Regional Water System water that may be made available by the SFPUC to some or all of the Participating Pumpers in accordance with Section 4.7 of the Project Operating Agreement.
17162158.1
“Power-Only,” when used with reference to Hetch Hetchy Enterprise capital costs and operating and maintenance expenses, means capital costs and expenses that are incurred solely for the construction and operation of assets used to generate and transmit electrical energy.
“Power-Related” refers to the power related portion (55%) of Joint Hetch Hetchy Enterprise assets or expenses.
“Prepayment” refers to payments of principal and interest amounts not due in the year the prepayment is made, as described in Section 5.03.
“Project Facility or Facilities” refers to all Groundwater Storage and Recovery Project assets, such as Project wells and all related fixed assets (e.g., real property, water treatment, connecting pipelines) that are acquired or constructed by the SFPUC pursuant to the Project Operating Agreement and operated as Regional Water System assets for the allocation of capital costs and operation and maintenance expenses under this Agreement. “Project Operating Agreement” refers to the “Agreement for Groundwater Storage and Recovery from the Southern Portion of the Westside Groundwater Basin by and among the San Francisco Public Utilities Commission, the City of Daly City, the City of San Bruno, and California Water Service Company,” dated as of December 16, 2014. “Proportional Annual Use” means the shares of deliveries from the Regional Water System used by City Retail Customers and by the Wholesale Customers in a fiscal year, expressed as a percentage. The percentages of annual use are calculated each year as described in Section B of Attachment J and are shown on lines 10 and 11 of Table 1 of that Attachment. “Proportional Water Use” refers the general principle of allocating Regional Water System costs based on the relative purchases of water by Retail and Wholesale Customers. “Regional,” when used with reference to Water Enterprise capital assets and operating expenses, refers to assets and expenses that benefit Wholesale and Regional Customers. “Regional Water System” means 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.
17162158.1
“Retail Customers” means any customer that purchases water from San Francisco that is not a Wholesale Customer, whether located inside or outside of San Francisco. “Retail Service Area” means the areas where SFPUC sells water to Retail Customers. “Retail Water” means water sold by the SFPUC to its Retail Customers within and outside San Francisco.
“San Francisco” refers to the City and County of San Francisco. “SFPUC” refers to the San Francisco Public Utilities Commission as an operating department of San Francisco, the General Manager of which reports to the Commission. “SFPUC Bureaus” refers to the portions of the SFPUC that provide support services to the SFPUC Operating Departments. These presently consist of the General Manager’s Office, Business Services, and External Affairs.
“SFPUC Operating Departments” refers to the Water, Hetch Hetchy and Wastewater Program Enterprises under the control and management of the SFPUC pursuant to the San Francisco Charter.
“SFPUC Storage Account” refers to the book account maintained by the SFPUC showing the amount of water stored in the Southern Westside Basin pursuant to the Project Operating Agreement.
“Shared Facilities” refers to an Existing Facility that is owned by a Participating Pumper, as upgraded through the expenditure of Regional capital costs under Section 5.04 of this Agreement and operated in part as a Project Facility.
“Substantially Expended”: A bond issue series is substantially expended when 98% of the proceeds and investment earnings contributed to the project fund have been expended. “Supply Assurance” means 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. “Target Balance,” for purposes of determining the Wholesale Capital Fund unencumbered balance under Section 6.08.E and amended Attachment M-3 beginning in FY 2018-19, means
17162158.1
the sum of (i) the current year (FY 2018-19) wholesale share of the revenue funded capital appropriation for New Regional Assets pursuant to Section 5.04.B times the quotient of 4 divided by 5; plus (ii) the wholesale appropriation for the prior year (FY 2017-18) times the quotient of 3 divided by 5; plus (iii) the wholesale appropriation for the 2nd year prior (FY 2016- 17) times the quotient of 2 divided by 5; plus (iv) the wholesale appropriation for the third year prior (FY 2015-16) times the quotient of 1 divided by 5. Such appropriations shall take into account any de-appropriations and/or reimbursements from bond proceeds or other sources.
The fiscal years in parentheses used in this definition are for illustration purposes only. “Temporary Modified Minimum Annual Purchase Quantity” means the minimum amount of water that a Wholesale Customer that has an Individual Supply Guarantee, which has received a permanent transfer of a portion of Individual Supply Guarantee and a portion of Minimum Annual Purchase Quantity pursuant to Section 3.04.C, agrees to purchase from San Francisco on a temporary annual basis, as described in Section 3.04.C and as specified in Attachment E- 1, as may be amended from time to time pursuant to Section 2.03.C. “Term” means the 25-year term commencing July 1, 2009, including one or both 5-year extensions authorized by Section 2.02.A and B.
“Tier 1 Shortage Plan” refers to the Water Shortage Allocation Plan (Attachment H) adopted by the SFPUC and the Wholesale Customers in conjunction with this Agreement 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.
“Water Enterprise” refers to the San Francisco Water Department (SFWD), an SFPUC Operating Department.
“Water Management Charge” refers to the charge collected by San Francisco on behalf of BAWSCA for local water resource development in the Wholesale Service Area pursuant to Section 3.06 of this Agreement.
“Water-Only,” when used with reference to Hetch Hetchy Enterprise capital costs and operating and maintenance expenses, means capital costs and expenses that are incurred solely for the construction and operation of assets used to protect water quality or to provide for the delivery of water for consumptive purposes.
17162158.1
“Water-Related” refers to the water related portion (45%) of Joint Hetch Hetchy Enterprise assets or expenses.
“Water Supply Development Report” refers to the annual report prepared pursuant to Section
4.05, and submitted to the Commission for purposes of estimating whether Regional Water System demand will be within the Interim Supply Limitation by June 30, 2018. “Wheeling Statute” refers to Article 4 of Chapter 11 of the California Water Code, as amended from time to time.
“Wholesale Capital Fund” is the account established by the SFPUC for deposit of Wholesale Customer revenue that is used to fund the wholesale share of revenue-funded New Regional Assets, as described in Section 6.08.
“Wholesale Customer” or “Customers” means one or more of the 26 water customers identified in Section 1.02 that are contracting for purchase of water from San Francisco pursuant to this Agreement.
“Wholesale Revenue Coverage” refers to the additional dollar amount included in wholesale rates each fiscal year that is charged to Wholesale Customers by the SFPUC for their proportionate share of Debt Service coverage under Section 6.06.A. “Wholesale Revenue Coverage Reserve” refers to the account established by the SFPUC for deposit of Wholesale Revenue Coverage under Section 6.06.B. “Wholesale Revenue Requirement” means the calculated Wholesale Customer portion of SFPUC Regional Water System capital and operating costs as determined in accordance with the provisions of Article 5 of this Agreement, formerly called the “Suburban Revenue Requirement” in the 1984 Agreement.
“Wholesale Service Area” means the combined service areas of the Wholesale Customers, as delineated on the service area maps attached to each Individual Water Sales Contract. “WSIP” refers to the Water System Improvement Program approved by the Commission in Resolution No. 08-0200 on October 30, 2008, as amended from time to time.
ATTACHMENT B
ATTACHMENT B
WHOLESALE CUSTOMER REGIONAL WATER SYSTEM PURCHASES FY 2007-2008* (To determine 75% approval process for Section 1.02)
;,:;";":"""1"""""""";"''';''':':',;;/',,',/,''x"';"":::"';;""""J""'::c,,",_ . ..,,:..':"......., HWHOLESA'/E:G.I!STJ1MERo.:ja:ö ,i""""","",,
'"',..y,',:;,""'Y"'/;):I.';;:)'S:".'''::',:,,,,!,:;;'t";"'/"§,'i;t.'::-:.%Ù"",;"""',,,, .....,.:..'., :;,
Alameda County Water District 12.90
California Water Service Company 37.72
City of Brisbane 0.23
City of Burlingame 4.50
City of Daly City 4.49
City of East Palo Alto 2.16
City of Hayward 19.33
City of Menlo Park 3.69
City of Milbrae 2.46
City öf Milpitas 6.95
City of Mountain View 10.51
City of Palo Alto 12.72
City of Redwood City 11.01
City of San Bruno 1.86
City of San Jose 4.80
City of Santa Clara 3.49
City of Sunnyvale 10.52
Coastside County Water District 2.08
Estero Municipal Improvement District 5.51
Guadalupe Valley Municipal Improvement District 0.40
Mid-Peninsula Water District 3.25
North Coast County Water District 3.25
Purissima Hills Water District 2.31
Skyline County Water District 0.16
Stanford University 2.31
Town of Hillsborough 3.83
Westborough Water District 0.95
Total 173.39
*Source: SFPUC Commercial Division Records
Note: FY 2007-2008 was a Leap Year with 366 days.
1847951.
ATTACHMENT C
ATTACHMENT C
15074851.1
INDIVIDUAL SUPPLY GUARANTEES
(1) (2)
WHOLESALE CUSTOMER
100 Cubic
Feet (per
year)1
Million Gallons
Per Day (MGD)1
Alameda County Water District 6,714,439 13.760
California Water Service Company2 17,320,807 35.499
City of Brisbane 224,435 0.460
City of Burlingame 2,553,753 5.234
City of Daly City 2,094,386 4.292
City of East Palo Alto 1,689,713 3.463
City of Menlo Park 2,174,231 4.456
City of Millbrae 1,538,120 3.152
City of Milpitas 4,504,533 9.232
City of Mountain View 6,079,715 12.460
City of Palo Alto 8,087,730 16.575
City of Redwood City 5,333,115 10.930
City of San Bruno 1,583,899 3.246
City of Sunnyvale 6,138,122 12.580
Coastside County Water District 1,061,453 2.175
Estero Municipal Improvement District 2,878,807 5.900
Guadalupe Valley Municipal Improvement District 254,436 0.521 Mid-Peninsula Water District 1,898,707 3.891
North Coast County Water District 1,872,928 3.838
Purissima Hills Water District 792,832 1.625
Skyline County Water District 88,537 0.181
Stanford University 1,479,764 3.033
Town of Hillsborough 1,995,644 4.090
Westborough Water District 644,172 1.320
Total:3 79,004,278 161.913
Footnotes:
1. 100 Cubic feet per year = Million Gallons per Day / 0.00000204946. Figures in column (1) are calculated using unrounded MGD values and are more precise than the figures listed in column (2)
2. Includes quantities from Los Trancos County Water District and Palomar Park Water District.
3. Total does not equal sum of MGD figures due to rounding. Total is not 184 MGD because the table does not include the City of Hayward. Cordilleras Mutual Water Association is not a party to this Agreement, but it has its own Supply assurance of 3,007 hundred cubic feet (CCF).
ATTACHMENT D
ATTACHMENT D
PROCEDURE FOR PRO-RATA REDUCTION OF WHOLESALE CUSTOMERS' INDIVIDUAL
SUPPLY GUARANTEES
(SECTION 3.02).
The 23 wholesale customers listed on Attachment C have individual Supply Guarantees that total approximately 161.9 MGD.
If the amount of water purchased from SFPUC by Hayward exceeds 22.1 MGD for three consecutive fiscal years, the individual Supply Guarantees of each of those 23 wholesale customers will be reduced as described below.
STEP ONE:
Obtain the average annual excess purchases during the three fiscal year period. For example, assume Hayward uses 25.0 MGD, 24.2 MGD and 26.0 MGD in three consecutive years. The average annual excess use for that period is 2.9 MGD; calculated as follows:
(25.0 MGD + 24.2 MGD + 26.0 MGD) + 161.9 MGD = 186.9 MGD 3 186.9 MGD -184.0 MGD = 2.9 MGD
STEP TWO:
Allocate the excess purchases among the 23 Wholesale Customers in proportion to each customer's Supply Guarantee as a percentage of the total Supply Guarantees (161.9 MGD as of FY 2009-10).
For example, assume that Wholesale Customer A's Supply Guarantee is 12.0 MGD.
Wholesale Customer A's percentage share of the total individual supply guarantees is 0.074, calculated as follows:
'12.0 MGD
161.9 MGD = 0.074
and its share of the excess use is 0.22 MGD, calculated as follows:
2.9 MGD x 0.074 = 0.22 MGD
i 866408.4
STEP THREE:
Determine Wholesale Customer's adjusted Supply Guarantee by subtracting the result of Step Two from the Wholesale Customer's Supply Guarantee:
12 MGD - 0.22 MGD = 11.78 MGD
**********
Adjustments will be made at intervals comprised of distinct three-year periods of use by Hayward in excess of 22.1 MGD rather than overlapping periods. For example, assuming that the first adjustment were to occur in FY 2014-15 (based on use during FY 2011-12, FY 2012-13 and FY 2013-14), a second adjustment will not occur earlier than three full fiscal years thereafter (Le., FY 2017-18, based on use by Hayward in FY 2014-15, FY 2015-16 and FY 2016-17). The figures used in the second and subsequent adjustments will reflect previous adjustments. For example, a second adjustment will use 158.9 MGD as the total of individual Supply Guarantees (161.6 MGD -
2.7 MGD = 158.9 MGD).
For purposes of simplicity, the volumetric units used in the foregoing example are MGD. For actual adjustment calculations, the unit employed will be hundreds of cubic feet ("ccf'), the unit by which the SFPUC measures water deliveries for billing purposes.
The procedure described and illustrated above is
independent of and unrelated to the establishment
by the SFPUC of Interim Supply Limitations
described in Article 4.
ATTACHMENT D Page 2
1866408.4
ATTACHMENT E
ATTACHMENT E
MINIMUM ANNUAL PURCHASE QUANTITIES
(Section 3.07.C)
Alameda County Water District
City of Milpitas
City of Mountain View
City of Sunnyvale
ATTACHMENT E-1
TEMPORARY MODIFIED MINIMUM ANNUAL PURCHASE QUANTITIES
(Sections 3.04 and 3.07.C)
AGENCY
TEMPORARY MODIFIED
MINIMUM ANNUAL
PURCHASE QUANTITY
(IN MGD)
EFFECTIVE FISCAL
YEAR OF TEMPORARY
MODIFIED MINIMUM
ANNUAL PURCHASE
QUANTITY
Attachment E‐2
Illustrations of a Transfer of a Portion of a Minimum Annual Purchase Quantity Pursuant to Sections 3.04 and 3.07.C Scenario 1: Transferee Not Already Subject to Temporary or Permanent Minimum Annual Purchase Requirements of Section 3.07.C A B C D = B + C E = A + C
Line # Wholesale Customer
Pre‐Transfer
Permanent Minimum
Purchase1
5 Previous Non‐
Drought‐Year
Average Usage
Minimum Purchase
Transfer
Temporary Modified
Minimum Purchase
Post‐Transfer
Permanent
Minimum Purchase
1 Transferor X 5.0 4.5 (1.0) N/A 4.0
2 Transferee Z N/A 6.0 1.0 7.0 1.0
Year 0
Pre‐Transfer
Year 1
Transfer Effective Year 2 Year 3
Year 4
1st Year Meeting
Temp Min
Year 5
Year 6
3rd Year Meeting
Temp Min
Year 7 Year 8
Transferor X
3 Applicable Minimum Purchase 2
5.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0
4 Annual Purchase 4.5 4.5 4.0 3.5 4.0 4.0 4.5 4.0 3.5 5 = 3 ‐ 4 Imputed Sales 0.5 ‐ ‐ 0 .5 ‐ ‐ ‐ ‐ 0 .5
6 = 4 + 5 Total Purchases 5.0 4.5 4.0 4.0 4.0 4.0 4.5 4.0 4.0 Transferee Z
7 Applicable Minimum Purchase N/A 7.0 7.0 7.0 7.0 7.0 7.0 1.0 1.0 8 Annual Purchase 6.0 6.0 6.5 6.5 7.0 7.0 7.5 7.0 7.5 9 = 7 ‐ 8 Imputed Sales ‐ 1 .0 0 .5 0 .5 ‐ ‐ ‐ ‐ ‐
10 = 8 + 9 Total Purchases 6.0 7.0 7.0 7.0 7.0 7.0 7.5 7.0 7.5 1 “Minimum Purchase” and "Permanent Minimum Purchase" are used in the tables in this Attachment E‐2 as shorthand references to the term Minimum Annual Purchase Quantity. 2 “Applicable Minimum Purchase” is used in the tables in this Attachment E‐2 to mean the larger of (a) or (b), as applicable: (a) the Wholesale Customer’s Minimum Annual Purchase Quantity, as specified in Attachment E, or (b) the Wholesale Customer’s Temporary Modified Minimum Annual Purchase Quantity, as specified in Attachment E-1. 1 of 3
Attachment E-2
Illustrations of a Transfer of a Portion of a Minimum Annual Purchase Quantity Pursuant to Sections 3.04 and 3.07.C A B C D = B + C E = A + C
Line # Wholesale Customer
Pre‐Transfer
Permanent Minimum
Purchase1
5 Previous Non‐
Drought‐Year
Average Usage
Minimum Purchase
Transfer
Temporary Modified
Minimum Purchase
Post‐Transfer
Permanent
Minimum Purchase
1 Transferor X 5.0 4.5 (1.0) N/A 4.0
2 Transferee Z 1.0 6.0 1.0 7.0 2.0
Year 0
Pre‐Transfer
Year 1
Transfer Effective Year 2
Year 3
Meets Temp Min but
Not Consecutive
Year 4
Year 5
1st Year Meeting
Temp Min
Year 6
Year 7
3rd Consecutive
Year Meeting
Temp Min
Year 8
Transferor X
3 Applicable Minimum Purchase 2
5.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0
4 Annual Purchase 4.5 4.5 4.0 3.5 4.0 4.0 4.5 4.0 3.5 5 = 3 ‐ 4 Imputed Sales 0.5 ‐ ‐ 0 .5 ‐ ‐ ‐ ‐ 0 .5
6 = 4 + 5 Total Purchases 5.0 4.5 4.0 4.0 4.0 4.0 4.5 4.0 4.0 Transferee Z
7 Permanent Minimum Purchase 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 8 Applicable Minimum Purchase 1.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 2.0 9 Annual Purchase 6.0 6.5 6.5 7.0 6.5 7.0 7.5 8.0 7.5 10 = 8 ‐ 9 Imputed Sales ‐ 0 .5 0 .5 ‐ 0 .5 ‐ ‐ ‐ ‐
11 = 9 + 10 Total Purchases 6.0 7.0 7.0 7.0 7.0 7.0 7.5 8.0 7.5 1 “Minimum Purchase” and "Permanent Minimum Purchase" are used in the tables in this Attachment E‐2 as shorthand references to the term Minimum Annual Purchase Quantity. 2 “Applicable Minimum Purchase” is used in the tables in this Attachment E‐2 to mean the larger of (a) or (b), as applicable: (a) the Wholesale Customer’s Minimum Annual Purchase Quantity, as specified in Attachment E, or (b) the Wholesale Customer’s Temporary Modified Minimum Annual Purchase Quantity, as specified in Attachment E-1. 2 of 3
Scenario 2: Transferee Already Subject to Permanent Minimum Annual Purchase Requirement
Attachment E-2
Illustrations of a Transfer of a Portion of a Minimum Annual Purchase Quantity Pursuant to Sections 3.04 and 3.07.C A B C D E3 F = A + D
Line # Wholesale Customer
Pre‐Transfer
Permanent Minimum
Purchase1
5 Previous Non‐
Drought‐Year
Average Usage
Existing Temporary
Modified Minimum
Minimum Purchase
Transfer
Temporary Modified
Minimum Purchase4
Post‐Transfer
Permanent
Minimum5
1 Transferor X 5.0 4.5 N/A (1.0) N/A 4.0
2 Transferor Y 3.0 3.0 N/A (1.0) N/A 2.0
3 Transferee Z
4 Transfer 1: X ‐> Z N/A 4.0 N/A 1.0 5.0 1.0
5 Transfer 2: Y ‐> Z N/A N/A3 5.0 1.0 6.0 2.0
Year 0
Pre‐Transfer
Year 1
Transfer 1 Effective
Year 2
1st Year Meeting
Temp Min 1
Year 3
Transfer 2 Effective
Year 4
3rd Year Meeting
Temp Min 1
Year 5
1st Year Meeting
Temp Min 2
Year 6
Year 7
3rd Year Meeting
Temp Min 2
Year 8
Transferor X
6 Applicable Minimum Purchase2
5.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0
7 Annual Purchase 4.5 4.5 4.0 3.5 4.0 4.0 4.5 4.0 3.5 8 = 6 ‐ 7 Imputed Sales 0.5 ‐ ‐ 0 .5 ‐ ‐ ‐ ‐ 0 .5
9 = 7 + 8 Total Purchases 5.0 4.5 4.0 4.0 4.0 4.0 4.5 4.0 4.0 Transferor Y
10 Applicable Minimum Purchase 3.0 3.0 3.0 2.0 2.0 2.0 2.0 2.0 2.0 11 Annual Purchase 3.0 2.5 3.5 2.5 2.5 2.0 1.5 2.5 2.0 12 = 10 ‐ 11 Imputed Sales ‐ 0 .5 ‐ ‐ ‐ ‐ 0.5 ‐ ‐
13 = 11 + 12 Total Purchases 3.0 3.0 3.5 2.5 2.5 2.0 2.0 2.5 2.0 Transferee Z
14 Permanent Minimum Purchase N/A N/A N/A N/A N/A 1.0 1.0 1.0 2.0 15 Applicable Minimum Purchase N/A 5.0 5.0 6.0 6.0 6.0 6.0 6.0 2.0 16 Annual Purchase 4.0 4.5 5.0 5.0 5.5 6.0 6.0 6.5 6.0 17 = 15 ‐ 16 Imputed Sales ‐ 0 .5 ‐ 1 .0 0.5 ‐ ‐ ‐ ‐
18 = 16 + 17 Total Purchases 4.0 5.0 5.0 6.0 6.0 6.0 6.0 6.5 6.0 1 “Minimum Purchase” and "Permanent Minimum Purchase" are used in the tables in this Attachment E‐2 as shorthand references to the term Minimum Annual Purchase Quantity. 2 “Applicable Minimum Purchase” is used in the tables in this Attachment E‐2 to mean the larger of (a) or (b), as applicable: (a) the Wholesale Customer’s Minimum Annual Purchase Quantity, as specified in Attachment E, or (b) the Wholesale Customer’s Temporary Modified Minimum Annual Purchase Quantity, as specified in Attachment E-1. 3 The Temporary Modified Minimum Purchase for Transfer 1 is E = B + D; the Temporary Modified Minimum Purchase for Transfer 2 is E = C + D. 4 If a transferee already has a Temporary Modified Minimum Annual Purchase Quantity, the additional Minimum Annual Purchase Quantity from transfer 2 is added to the transferee's existing Temporary Modified Minimum Annual Purchase Quantity, not to the transferee's 5 non‐drought‐year average usage. 5 Cumulative total, including transfers 1 and 2.
3 of 3
Scenario 3: Transferee Already Subject to Temporary Minimum Annual Purchase Requirement
ATTACHMENT F
ATTACHMENT F
WATER SALES CONTRACT
This Contract, dated as of , 2009, is entered into by and between the City and County of San Francisco ("San Francisco") and
("Customer").
RECITALS
San Francisco and the Customer have entered into a Water Supply Agreement (UWSA"), which sets forth the terms and conditions under which San Francisco will continue to furnish water for domestic and other municipal purposes to Customer and to other Wholesale Customers. The WSA contemplates that San Francisco and each individual Wholesale Customer will enter into an individual contract describing the location or locations at which water will be delivered to each customer by the San Francisco Public Utilities Commission ("SFPUC"), the customer's service area within which water so delivered is to be sold, and other provisions unique to the individual purchaser. This Water Sales Contract is the individual contract contemplated by the WSA.
AGREEMENTS OF THE PARTIES
1. Incorporation of the WSA
The terms and conditions of the WSA are incorporated into this Contract as if set forth in full herein.
2. Term
Unless explicitly provided to the contrary in Article 9 of the WSA, the term of this Contract shall be identical to that provided in Section _ of the WSA. 1669591.1
3. Sèrvice Area
Water delivered by San Francisco to the Customer may be used or sold within the service area shown on the map designated Exhibit A attached .hereto. Except as provided in Section _ of the WSA, Customer shall not deliver or sell any water provided by San Francisco outside of this area without the prior written consent of the General Manager of the SFPUC.
4. Location and Description of Service Connections
Sale and delivery of water to Customer will be made through a connection or connections to the SFPUC Regional Water System at the location or locations shown on Exhibit A attached hereto and with the applicable present accoimtnumber, description, connection size, and meter size shown on Exhibit B attached hereto.
5. Interties With Other Systems.
Customer maintains interties with neighboring water systems at the location or locations. shown on Exhibit A attached hereto and with the connection size(s) as shown on Exhibit C attached hereto.
6. Billing and Payment
San Francisco shall compute the amounts of water delivered and bill Customer therefor on a monthly basis. The bill shall show the separate components of the charge (e.g., service, consumption, demand). Customer shall pay the amount due within thirty (30) days after receipt of the bilL.
If Customer disputes the accuracy of any portion of the water bill it shall (a) notify the General Manager of the SFPUC in writing of the specific nature of the dispute and (b) pay the undisputed portion of the bill within thirty (30) days after receipt. Customer shall meet with the General Manager of the SFPUC or a delegate to discuss the disputed portion of the bilL.
ATTACHMENT F, Page 2 1669591.2
7.,8.,9,.. Other Specialized Provisions
(Certain Wholesale Customers will require additional provisions in their individual contracts addressed to issues such as minimum and/or maximum water delivery quantities, prior authorized wheeling arrangements, maximum expansion of the service area, etc. These and other provisions addressing issues unique to the particular Wholesale Customer may be added here, subject to the. provisions of Section 9.01 of the WSA.) IN WITNESS WHEREOF, the parties hereto have executed this Contract, to become effective upon the effectiveness of the WSA, by their duly authorized representatives.
CITY AND COUNTY OF SAN FRANCISCO
Acting by and through its Public Utilities
Commission
Date: _,2009
BY
Edward Harrington
General Manager
NAME OF WHOLESALE CUSTOMER
BY Date: _,2009
Name:
Title:
Note: This attachment is provided for the convenience of the prospective parties to the Water Supply Agreement and associated individual contracts. The format may be modified as desired by San Francisco and Wholesale Customer, subject to Section 9.01 of the WSA.
ATTACHMENT F, Page 3 1669591.2
ATTACHMENT G
http://sfwater.org/cfapps/wholesale/detailPage.cfm?c_id=3739
Water Quality Notifications and
Communications Plan
MARCH 2017 • REVISION 6
SFPUC WATER QUALITY DIVISION
UPDATED BY: AND
ATTACHMENT H
1 15017932.1
ATTACHMENT H
WATER SHORTAGE ALLOCATION PLAN
This Interim Water Shortage Allocation Plan (“Plan”) describes the method for allocating water between the San Francisco Public Utilities Commission (“SFPUC”) and the Wholesale Customers collectively during shortages caused by drought. The Plan implements a method for allocating water among the individual Wholesale Customers which has been adopted by the Wholesale Customers. The Plan includes provisions for transfers, banking, and excess use charges. The Plan applies only when the SFPUC determines that a system-wide water shortage due to drought exists, and all references to “shortages” and “water shortages” are to be so understood. This Plan was adopted pursuant to Section 7.03(a) of the 1984 Settlement Agreement and Master Water Sales Contract and has been updated to correspond to the terminology used in the June 2009 Water Supply Agreement between the City and County of San Francisco and Wholesale Customers in Alameda County, San Mateo County and Santa Clara County ("Agreement").
SECTION 1. SHORTAGE CONDITIONS
1.1. Projected Available SFPUC Water Supply. The SFPUC shall make an annual determination as to whether or not a shortage condition exists. The determination of projected available water supply shall consider, among other things, stored water, projected runoff, water acquired by the SFPUC from non-SFPUC sources, inactive storage, reservoir losses, allowance for carryover storage, and water bank balances, if any, described in Section 3.
1.2 Projected SFPUC Purchases. The SFPUC will utilize purchase data, including volumes of water purchased by the Wholesale Customers and by Retail Customers (as those terms are used in the Agreement) in the year immediately prior to the drought, along with other available relevant information, as a basis for determining projected system-wide water purchases from the SFPUC for the upcoming year.
1.3. Shortage Conditions. The SFPUC will compare the available water supply (Section 1.1) with projected system-wide water purchases (Section 1.2). A shortage condition exists if the SFPUC determines that the projected available water supply is less than projected system-wide water purchases in the upcoming Supply Year (defined as the period from July 1 through June 30). When a shortage condition exists, SFPUC will determine whether voluntary or mandatory actions will be required to reduce purchases of SFPUC water to required levels.
1.3.1 Voluntary Response. If the SFPUC determines that voluntary actions will be sufficient to accomplish the necessary reduction in water use throughout its service area, the SFPUC and the Wholesale Customers will make good faith efforts to reduce their water purchases to stay within their annual shortage allocations and associated monthly water use budgets. The SFPUC will not impose excess use charges during periods of voluntary rationing, but may suspend the prospective accumulation of water bank credits, or impose a ceiling on further accumulation of bank credits, consistent with Section 3.2.1 of this Plan.
2 15017932.1
1.3.2 Mandatory Response. If the SFPUC determines that mandatory actions will be required to accomplish the necessary reduction in water use in the SFPUC service area, the SFPUC may implement excess use charges as set forth in Section 4 of this Plan.
1.4. Period of Shortage. A shortage period commences when the SFPUC determines that a water shortage exists, as set forth in a declaration of water shortage emergency issued by the SFPUC pursuant to California Water Code Sections 350 et seq. Termination of the water shortage emergency will be declared by resolution of the SFPUC.
SECTION 2. SHORTAGE ALLOCATIONS
2.1. Annual Allocations between the SFPUC and the Wholesale Customers. The annual water supply available during shortages will be allocated between the SFPUC and the collective Wholesale Customers as follows:
Level of System Wide
Reduction in Water Use
Required
Share of Available Water
SFPUC Share Wholesale Customers
Share
5% or less
6% through 10%
11% through 15%
16% through 20%
35.5%
36.0%
37.0%
37.5%
64.5%
64.0%
63.0%
62.5%
The water allocated to the SFPUC shall correspond to the total allocation for all Retail Customers. In the event that the SFPUC share of the available water supply in the above table results in Retail Customers having a positive allocation (i.e., a supply of additional water rather than a required percentage reduction in water use), the SFPUC’s percentage share of the available water supply in the table shall be reduced to eliminate any positive allocation to Retail Customers, with a corresponding increase in the percentage share of the available water supply allocated to the Wholesale Customers. For any level of required reduction in system-wide water use during shortages, the SFPUC shall require Retail Customers to conserve a minimum of 5%, with any resulting reallocated supply credited to storage for inclusion in calculation of projected available water SFPUC water supply in a subsequent year (Section 1.1).
The parties agree to reevaluate the percentages of the available water supply allocated to Retail and Wholesale Customers by May 1, 2028.
2.2 Annual Allocations among the Wholesale Customers. The annual water supply allocated to the Wholesale Customers collectively during system wide shortages of 20 percent or less will be apportioned among them based on a methodology adopted by all of the Wholesale Customers, as described in Section 3.11(C) of the Agreement. In any year for which the methodology must be applied, the Bay Area Water Supply and Conservation Agency (“BAWSCA”) will calculate each Wholesale Customer’s individual percentage share of the amount of water allocated to the Wholesale Customers collectively pursuant to Section 2.1. Following the declaration or reconfirmation of a water shortage emergency by the SFPUC, BAWSCA will deliver to the SFPUC General Manager a list, signed by the President of BAWSCA’s Board of Directors and
3 15017932.1
its General Manager, showing each Wholesale Customer together with its percentage share and stating that the list has been prepared in accordance with the methodology adopted by the Wholesale Customers. The SFPUC shall allocate water to each Wholesale Customer, as specified in the list. The shortage allocations so established may be transferred as provided in Section 2.5 of this Plan. If BAWSCA or all Wholesale Customers do not provide the SFPUC with individual allocations, the SFPUC may make a final allocation decision after first meeting and discussing allocations with BAWSCA and the Wholesale Customers.
The methodology adopted by the Wholesale Customers utilizes the rolling average of each individual Wholesale Customer’s purchases from the SFPUC during the three immediately preceding Supply Years. The SFPUC agrees to provide BAWSCA by November 1 of each year a list showing the amount of water purchased by each Wholesale Customer during the immediately preceding Supply Year. The list will be prepared using Customer Service Bureau report MGT440 (or comparable official record in use at the time), adjusted as required for any reporting errors or omissions, and will be transmitted by the SFPUC General Manager or his designee.
2.3. Limited Applicability of Plan to System Wide Shortages Greater Than Twenty Percent. The allocations of water between the SFPUC and the Wholesale Customers collectively, provided for in Section 2.1, apply only to shortages of 20 percent or less. The SFPUC and Wholesale Customers recognize the possibility of a drought occurring which could create system-wide shortages greater than 20 percent despite actions taken by the SFPUC aimed at reducing the probability and severity of water shortages in the SFPUC service area. If the SFPUC determines that a system wide water shortage greater than 20 percent exists, the SFPUC and the Wholesale Customers agree to meet within 10 days and discuss whether a change is required to the allocation set forth in Section 2.1 in order to mitigate undue hardships that might otherwise be experienced by individual Wholesale Customers or Retail Customers. Following these discussions, the Tier 1 water allocations set forth in Section 2.1 of this Plan, or a modified version thereof, may be adopted by mutual written consent of the SFPUC and the Wholesale Customers. If the SFPUC and Wholesale Customers meet and cannot agree on an appropriate Tier 1 allocation within 30 days of the SFPUC’s determination of water shortage greater than 20 percent, then (1) the provisions of Section 3.11(C) of the Agreement will apply, unless (2) all of the Wholesale Customers direct in writing that a Tier 2 allocation methodology agreed to by them be used to apportion the water to be made available to the Wholesale Customers collectively, in lieu of the provisions of Section 3.11(C).
The provisions of this Plan relating to transfers (in Section 2.5), banking (in Section 3), and excess use charges (in Section 4) shall continue to apply during system-wide shortages greater than 20 percent.
2.4. Monthly Water Budgets. Within 10 days after adopting a declaration of water shortage emergency, the SFPUC will determine the amount of Tier 1 water allocated to the Wholesale Customers collectively pursuant to Section 2.1. The SFPUC General Manager, using the Tier 2 allocation percentages shown on the list delivered by BAWSCA pursuant to Section 2.2, will calculate each Wholesale Customer’s individual annual allocation. The SFPUC General Manager, or his designee, will then provide each Wholesale Customer with a proposed schedule of monthly water budgets based on the pattern of monthly water purchases during the Supply Year immediately preceding the declaration of shortage (the “Default Schedule”). Each
4 15017932.1
Wholesale Customer may, within two weeks of receiving its Default Schedule, provide the SFPUC with an alternative monthly water budget that reschedules its annual Tier 2 shortage allocation over the course of the succeeding Supply Year. If a Wholesale Customer does not deliver an alternative monthly water budget to the SFPUC within two weeks of its receipt of the Default Schedule, then its monthly budget for the ensuing Supply Year shall be the Default Schedule proposed by the SFPUC.
Monthly Wholesale Customer water budgets will be derived from annual Tier 2 allocations for purposes of accounting for excess use. Monthly Wholesale Customer water budgets shall be adjusted during the year to account for transfers of shortage allocation under Section 2.5 and transfers of banked water under Section 3.4.
2.5. Transfers of Shortage Allocations. Voluntary transfers of shortage allocations between the SFPUC and any Wholesale Customers, and between any Wholesale Customers, will be permitted using the same procedure as that for transfers of banked water set forth in Section 3.4. The SFPUC and BAWSCA shall be notified of each transfer. Transfers of shortage allocations shall be deemed to be an emergency transfer and shall become effective on the third business day after notice of the transfer has been delivered to the SFPUC. Transfers of shortage allocations shall be in compliance with Section 3.05 of the Agreement. The transferring parties will meet with the SFPUC, if requested, to discuss any effect the transfer may have on its operations.
SECTION 3. SHORTAGE WATER BANKING
3.1. Water Bank Accounts. The SFPUC shall create a water bank account for itself and each Wholesale Customer during shortages in conjunction with its resale customer billing process.
Bank accounts will account for amounts of water that are either saved or used in excess of the shortage allocation for each agency; the accounts are not used for tracking billings and payments. When a shortage period is in effect (as defined in Section 1.4), the following provisions for bank credits, debits, and transfers shall be in force. A statement of bank balance for each Wholesale Customer will be included with the SFPUC’s monthly water bills.
3.2. Bank Account Credits. Each month, monthly purchases will be compared to the monthly budget for that month. Any unused shortage allocation by an agency will be credited to that agency’s water bank account. Credits will accumulate during the entire shortage period, subject to potential restrictions imposed pursuant to Section 3.2.1. Credits remaining at the end of the shortage period will be zeroed out; no financial or other credit shall be granted for banked water.
3.2.1. Maximum Balances. The SFPUC may suspend the prospective accumulation of credits in all accounts. Alternatively, the SFPUC may impose a ceiling on further accumulation of credits in water bank balances based on a uniform ratio of the bank balance to the annual water allocation. In making a decision to suspend the prospective accumulation of water bank credits, the SFPUC shall consider the available water supply as set forth in Section 1.1 of this Plan and other reasonable, relevant factors.
3.3. Account Debits. Each month, monthly purchases will be compared to the budget for that month. Purchases in excess of monthly budgets will be debited against an agency’s water bank account. Bank debits remaining at the end of the fiscal year will be subject to excess use charges (see Section 4).
5 15017932.1
3.4. Transfers of Banked Water. In addition to the transfers of shortage allocations provided for in Section 2.5, voluntary transfers of banked water will also be permitted between the SFPUC and any Wholesale Customer, and among the Wholesale Customers. The volume of transferred water will be credited to the transferee’s water bank account and debited against the transferor’s water bank account. The transferring parties must notify the SFPUC and BAWSCA of each transfer in writing (so that adjustments can be made to bank accounts), and will meet with the SFPUC, if requested, to discuss any affect the transfer may have on SFPUC operations.
Transfers of banked water shall be deemed to be an emergency transfer and shall become effective on the third business day after notice of the transfer has been delivered to the SFPUC.
If the SFPUC incurs extraordinary costs in implementing transfers, it will give written notice to the transferring parties within ten (10) business days after receipt of notice of the transfer.
Extraordinary costs means additional costs directly attributable to accommodating transfers and which are not incurred in non-drought years nor simply as a result of the shortage condition itself. Extraordinary costs shall be calculated in accordance with the procedures in the Agreement and shall be subject to the disclosure and auditing requirements in the Agreement. In the case of transfers between Wholesale Customers, such extraordinary costs shall be considered to be expenses chargeable solely to individual Wholesale Customers and shall be borne equally by the parties to the transfer. In the case of transfers between the SFPUC and a Wholesale Customer, the SFPUC’s share of any extraordinary transfer costs shall not be added to the Wholesale Revenue Requirement.
3.4.1. Transfer Limitations. The agency transferring banked water will be allowed to transfer no more than the accumulated balance in its bank. Transfers of estimated prospective banked credits and the “overdrafting” of accounts shall not be permitted. The price of transfer water originally derived from the SFPUC system is to be determined by the transferring parties and is not specified herein. Transfers of banked water shall be in compliance with Section 3.05 of the Agreement.
SECTION 4. WHOLESALE EXCESS USE CHARGES
4.1. Amount of Excess Use Charges. Monthly excess use charges shall be determined by the SFPUC at the time of the declared water shortage consistent with the calendar in Section 6 and in accordance with Section 6.03 of the Agreement. The excess use charges will be in the form of multipliers applied to the rate in effect at the time the excess use occurs. The same excess use charge multipliers shall apply to the Wholesale Customers and all Retail Customers. The excess use charge multipliers apply only to the charges for water delivered at the rate in effect at the time the excess use occurred.
4.2 Monitoring Suburban Water Use. During periods of voluntary rationing, water usage greater than a customer’s allocation (as determined in Section 2) will be indicated on each SFPUC monthly water bill. During periods of mandatory rationing, monthly and cumulative water usage greater than a Wholesale Customer’s shortage allocation and the associated excess use charges will be indicated on each SFPUC monthly water bill.
4.3. Suburban Excess Use Charge Payments. An annual reconciliation will be made of monthly excess use charges according to the calendar in Section 6. Annual excess use charges will be calculated by comparing total annual purchases for each Wholesale Customer with its
6 15017932.1
annual shortage allocation (as adjusted for transfers of shortage allocations and banked water, if any). Excess use charge payments by those Wholesale Customers with net excess use will be paid according to the calendar in Section 6. The SFPUC may dedicate excess use charges paid by Wholesale Customers toward the purchase of water from the State Drought Water Bank or other willing sellers in order to provide additional water to the Wholesale Customers. Excess use charges paid by the Wholesale Customers constitute Wholesale Customer revenue and shall be included within the SFPUC's annual Wholesale Revenue Requirement calculation.
SECTION 5. GENERAL PROVISIONS GOVERNING WATER SHORTAGE
ALLOCATION PLAN
5.1. Construction of Terms. This Plan is for the sole benefit of the parties and shall not be construed as granting rights to any person other than the parties or imposing obligations on a party to any person other than another party.
5.2. Governing Law. This Plan is made under and shall be governed by the laws of the State of California.
5.3. Effect on Agreement. This Plan describes the method for allocating water between the SFPUC and the collective Wholesale Customers during system-wide water shortages of 20 percent or less. This Plan also provides for the SFPUC to allocate water among the Wholesale Customers in accordance with directions provided by the Wholesale Customers through BAWSCA under Section 2.2, and to implement a program by which such allocations may be voluntarily transferred among the Wholesale Customers. The provisions of this Plan are intended to implement Section 3.11(C) of the Agreement and do not affect, change or modify any other section, term or condition of the Agreement.
5.4. Inapplicability of Plan to Allocation of SFPUC System Water During Non-Shortage Periods. The SFPUC’s agreement in this Plan to a respective share of SFPUC system water during years of shortage shall not be construed to provide a basis for the allocation of water between the SFPUC and the Wholesale Customers when no water shortage emergency exists.
5.5. Termination. This Plan shall expire at the end of the Term of the Agreement.. The SFPUC and the Wholesale Customers can mutually agree to revise or terminate this Plan prior to that date due to changes in the water delivery capability of the SFPUC system, the acquisition of new water supplies, and other factors affecting the availability of water from the SFPUC system during times of shortage.
SECTION 6. ALLOCATION CALENDAR
6.1. Annual Schedule. The annual schedule for the shortage allocation process is shown below.
This schedule may be changed by the SFPUC to facilitate implementation.
7 15017932.1
6.1.1 In All Years Target Dates
1. SFPUC delivers list of annual purchases by each Wholesale Customer during the immediately preceding Supply Year
November 1
2. SFPUC meets with the Wholesale Customers and presents water supply forecast for the following Supply Year
February
3. SFPUC issues initial estimate of available water supply February 1
4. SFPUC announces potential first year of drought (if applicable) February 1
5. SFPUC and Wholesale Customers meet upon request to exchange information concerning water availability and projected system- wide purchases
February 1-May 31
6. SFPUC issues revised estimate of available water supply, and confirms continued potential shortage conditions, if applicable March 1
7. SFPUC issues final estimate of available water supply April 15 th or sooner if
adequate snow course
measurement data is available
to form a robust estimate on
available water supply for the
coming year.
8. SFPUC determines amount of water available to Wholesale Customers collectively
April 15
th or sooner if
adequate snow course
measurement data is available
to form a robust estimate on
available water supply for the
coming year.
In Drought Years Target Dates
9. SFPUC formally declares the existence of water shortage emergency (or end of water shortage emergency, if applicable) under Water Code Sections 350 et. seq.
April 15-30
10. SFPUC declares the need for a voluntary or mandatory response April 15-30
11. BAWSCA submits calculation to SFPUC of individual Wholesale Customers’ percentage shares of water allocated to Wholesale Customers collectively
April 15- 30
12. SFPUC determines individual shortage allocations, based on BAWSCA’s submittal of individual agency percentage shares to SFPUC, and monthly water budgets (Default Schedule)
April 25—May 10
13. Wholesale Customers submit alternative monthly water budgets (optional)
May 8-May 24
14. Final drought shortage allocations are issued for the Supply Year beginning July 1 through June 30
June 1
15. Monthly water budgets become effective July 1
16. Excess use charges indicated on monthly Suburban bills August 1 (of the beginning year) through June 30 (of the
succeeding year)
17. Excess use charges paid by Wholesale Customers for prior year August of the succeeding year
ATTACHMENT I
[NOT USED]
ATTACHMENT J
ATTACHMENT J
DEFINITIONS AND FORMULAS FOR
CALCULATING PROPORTIONAL ANNUAL WATER USE
TABLE OF CONTENTS
"-
This Attachment contains four sections, three figures, and five tables.
Section A:
Section B:
Section C:
Section D:
Figure 1:
Figure 2:
Fi'gure 3:
Table 1:
Table 2:
Table 3:
Table 4:
Table 5:
Water Meters
Calculation of Proportional Annual Water Use
Data Requirements and Schedule
County Line and In-City Terminal Reservoir Meter
Calibration and Maintenance
Locations of SFPUC County- Line Meters and In-City
Terminal Reservoirs
Generalized Schematic of Lake Merced Pump Station
Locations of System Input and In-Line Meters
Base Usage and Allocation Rates
Locations of SFPUC County-line Meters and In-City
T eriinal Reservoirs
Locations of SFPNC System Input and In-line Meters
County-line Meters, In-City Terminal Reservoirs and
Associated Metering Equipment
Meter Calibration and Maintenance Frequency
Table 1 presents the format for the water usage and allocation rate calculations for reference and to ilustrate the definitions and formulas described in Sections A through C.
Tables 2 and 3 list the meters whose locations are shown on Figures 1 and 3, respectively. Table March i i, 2009
1
4 identifies the type of meter and associated metering equipment for the County-line Meters and Terminal Reservoirs. Table 5 identifies the meter calibration and maintenance frequency for the meters and equipment listed in Table 4.
SECTION A. WATERMETERS
1. General
The Agreement provides that certain operating and maintenance expenses and the capital cost òf certain categories of utility plant in service are to be allocated between San Francisco and . i
the Wholesale Customer~ on the basis of proportionate ännual usage of the Regional Water' System. The purpose of this Attachment is to describe the meters) and ilustrate the method by which proportionate anual usage wil be calculated.
2. Units of Measurement, Rounding, Conversion
The SFPUC wil compile the usage data required to complete Table 1 anually.. The . units of measurement and'conventions for converting and rounding wil be as follows.
The data in the Table 1 will be presented, and the calculationS contemplated by this Attachment shown, in imits of milions of gallons per day (mgd), rounded tothe nearest tenth of an mgd~Percentages (e.g., the City and Wholesale usa~e rates) shall be carried to two digits to the right ofthedecimal point and reduction factors shall be carried to four digits to the right of the decimal point. Data compiled by the SFPUC in units of hundreds of cubic feet per year (cd) shall be converted to mgd by multiplying hundreds of cubic feet per year by 0.0000020493 (or
2.0493 x 10'6) for non-leap years and 0.0000020437 (or 2.0437 x 10'6) for leap years, In founding, if the rightmost digit dropped is 0 through 4, the preceding digit shall be left u!lchanged; if the rightmost digit dropped is 5 through 9, the preceding digit shall be increased by l.
2 March ii, 2009
3. Location of Meters/Gauges
The SFPUC presently maintains meters and gauges that have been used to determine the proportionate usage of the Regional Water System, in accordance with the methods and calculations described in Exhibit J to the 1984 contract between San Francisco and the Wholesale Customers. These meters consist of "County-Line Meters," "In-City Terminal Reservoir Meters" and "System Input and In-line Meters" as described in the following subsections. As new capital improvement projects are designed and constructed by the SFPUC, it may be necessary for new meters to be installed to ensure continued accurate determinations of the proportionate usage of the Regional Water System. "Planned meters" are included in the following subsections where planed capital improvement projects are likely to require the installation of additional meters.
a. County-line Meters
The SFPUC presently maintains meters at or near the San Mateo-San Francisco County line to measure flow through all transmission pipelines entering the City ("County-line Meters").
The existing and planned County-line Meters are listed in Table 2 and shown on Figures 1 and 2.
Additional details pertaining to the County-line meters located at the Lake Merced Pump Station, and specifically to water deliveries from the pump station to Sunset Reservoir, Sutro Reservoir, and Lake Merced are provided below.
(1) County-Line deliveries to Sunsetand Sutro Reservoirs Water delivered to the City through the Sunset Supply Pipeline may be pumped from the Lake Merced Pump Station to either Sunset Reservoir or Sutro Reservoir located within the City. When water is pumped from the Lake Merced Pump Station to both Sunset and Sutro reservoirs simultaneously, the recording instrumentation on the Sunset and Sutro venturi meters are designed to record flows through both meters.
When water is pumped to Sutro Reservoir only (typically utilizing Pump NO.4 at the 3 March 11, 2009
Lake Merced Pump Station), the source water is from the Sunset Reservoir (not the County-line), and the direction of flow through the Sunset venturi meter is reversed.
Under this pumping scenario, the recording instrumentation on the Sunset and Sutro venturi meters are designed to not record flow on their respective recorders such that the in-City transfer of water between Sunset and Sutro Reservoirs is not included as a County-line delivery to the City. Figure 2 provides a generalized schematic of the Lake Merced Pump Station and the typical direction of flow from the County-line, through the pump station.
(2) County-line deliveries to Lake Merced
In order to raise and maintain water levels in Lake Merced, the SFPUC occasionally delivers water directly from the Regional Water System to Lake Merced. Deliveries from the Regional Water System to Lake Merced are accomplished at the Lake Merced Pump Station. The procedure involves operating valves on the suction side of Sunset Pump NO.2 such that water may flow by gravity in the Sunset Supply Pipeline, from San Mateo County, across the County-line and into San Francisco, through Lake Merced Pump Station and into the Lake Merced wet welL. A 16-inch pipeline connection on the suction side of Sunset Pump NO.2 allows for deliveries of water to the wet well (see Figure 2). Water deliveries from the Regional Water System to Lake Merced are considered County-line deliveries and an in-City usage in the calculation of water allocation rates.
b. In-City Terminal Reservoirs
Water usage by the City includes water deliveries from the SFPUC's "terminal reservoirs." The terminal reservoirs are: 1) Sunset Reservoir, 2) University Mound Reservoir, and 3) Merced Manor Reservoir. The terminal reservoirs are shown on Figure 1. c. System Input and In-Line Meters
4 March 11, 2009
The SFPUC presently measures water flow into and through the Regional System utilizing "System Input and In-Line Meters." The existing and planned System Input and In- Line Meters are listed in Table 3 and shown on Figure 3. d. Wholesale Customer Meters and City Retail Customer Meters Located Outside the Boundaries of the City
The SFPUC presently measures water deliv~ries from the Regional Water System to its Wholesale Customers at various locations where the water delivery systems of the individual Wholesale Customers tie into the Regional Water System. The meters at these locations are referred to as the Wholesale Customers' "master meters." The SFPUCalso measures water deliveries from the Regional Water System to other customers located outside of the boundaries of the City that are not Wholesale Customers. Water deliveries to the Wholesale Customers and Retail Customers outside the City's boundaries that receive water from the Regional Water System are accounted for by the SFPUC's Customer Service Division as described in Section B.
4. Replacement and Relocation of Meters, Gauges, and Recording Devices.
The SFPUC presently equips all of its large venturi meters with differential pressure transmitters. The smaller meters utilize other methods and equipment to register and record flows. The SFPUC will maintain the meters, gauges, and recording devices described above in subsections (a), (b), (c), and (d) unless and until such meters, gauges, and recording devices are replaced.
The SFPUC may replace the meters, gauges, and recording devices described above in subsections (a), (b), (c), and (d) or install new meters, gauges, and recording devices at new locations, provided that such changes do not diminish the accuracy of the water flow measurements or impair the ability of the SFPUC to separate direct City water use from water use by the wholesale customers. Maintenance and calibration procedures for new or replaced equipment may change. Modified maintenance and calibration procedures for new or replaced equipment will conform to industry standards set forth in A WWA Manual M33, the applicable 5 March 11, 2009
standards in the International Society of Automation, and will implement the manufacturer's instructions for maintenance and calibration. The SFPUC will provide BA WSCA with advance written notice of any such changes, together with a brief explanation of the reasons therefor and a description of the type and location of the replacement. Such notice shall automatically amend the list of meters, gauges, and recording devices set forth above in subsections (a), (b), (c), and (d).
5. Recording of Water Flow Data
a. Flow Data
The City shall record and maintain data measuring base water flow throughout the SFPUC Regional Water System as necessary to determine proportional annual water usage. b. Reservoir Data
The SFPUC shall record and maintain data measuring the levels of the terminal reservoirs described above in subsection A.3.b and shown on Figure 1 on an hourly basis. Flow values derived from reservoir level readings for all reservoirs in the SFPUC wholesale system shall be calculated using the tables contained in the SFPUC publication "Reservoir Data" (aka "The Weir Book"), which set forth the relationship between reservoir levels and water volumes, as such tables may be amended from time to time to reflect changes in the volumes of the various reservoirs. The tables to be used initially shall be those from the current edition of The Weir Book.
SECTION B. CALCULA TION OF PROPORTIONAL ANNUAL
USAGE
"Base rates" means the percentages of annual SFPUC deliveries attributed to the Wholesale Customers and to City Retail Customers.
6 March 11,2009
(1) "Gross San Francisco County line base deliveries" shall equal the total amount of water flowing into the City's distribution system through transmission pipelines entering the City, as measured by the County-Line Meters described in Section A.3.a. and shown on Figures 1 and 2.
(2) "Daly City base deliveries" shall equal the water flowing to Daly City through meter accounts provided downstream of the County-Line meters or through SFPUC's City Distribution Division. At present these accounts are:
(a) CSPLl/Macdonald Avenue Service (Account number 010084-01- 0)
(b) Guttenberg Street Service (Account number 010013-01-3) (c) Carter Street Service (Account numb.ers 284070-01-8 and 284071- 01-6)
These accounts represent a portion of the total deliveries to Daly City. The quantities of water delivered to these four Daly City accounts are reported monthly in Form MGT44 i by the SFPUC's Customer Service Division. These connections to meters are presently located within the City, and thus record water which has already been recorded by the SFPUC's master meters at the County line. So long as this condition continues, Daly City base deliveries shall be subtracted from "Gross San Francisco County line base deliveries." (3) "Net San Francisco base deliveries" shall equal the result of subtracting "Daly City base deliveries" from "Gross San Francisco County line base deliveries." 7 March i i, 2009
(4) "Other suburban raw water base deliveries" shall equal the sum of all deliveries of raw (untreated) water to customers of the SFPUC located outside the City other than deliveries to the Wholesale Customers. "Other suburban raw water base deliveries" include deliveries of raw water in Alameda and San Mateo Counties to SFPUC Retail Customers, City departments and commissions, and other users affiiated with San Francisco.
(5) "Other suburban treated water base deliveries" shall equal the sum of all deliveries of treated water to customers of the SFPUC located outside the City . other than deliveries to the Wholesale Customers. Other suburban treated water base deliveries include deliveries of treated water t6 the SFPUC's Retail Customers in San Mateo, Santa' Clara and Alameda Counties (such as NASA Ames Research Center and LLNL), to City departments and commissions and other users affiliated with San Francisco (such as the San Francisco International Airport, the San Francisco County Jail, and tenants ofland owned by the City Recreation and Park Deparment).
(6) "Other suburban base deliveries" shall equal the sum of "Other suburban raw water deliveries" and "Other suburban treated water deliveries." The combined amount of raw and treated water delivered to suburban entities other than the Wholesale Customers is reported monthly in Form MGT440 by the SFPUC's Customer Service Division,
(7) "Total City base usage" shall equal "Net San Francisco base deliveries" plus "Other suburban base deliveries."
(8) "Total wholesale base usage" shall equal the sum of all metered deliveries to the Wholesale Customers measured at their SFPUC master meters (including all deliveries to Daly City which are comprised of deliveries through meters located outside San Francisco and meters located inside San Francisco, deliveries through the latter of which are designated above in paragraph B.1.2 as "Daly City base 8 March I I, 2009
deliveries"). The quantity of water delivered to the individual Wholesale Customers, and the combined amount of water delivered to all Wholesale Customers is reported monthly in Foml MGT440 by the SFPUC's Customer Service Division.
(9) "Total system base usage" shall equal "City base usage" plus "Wholesale base usage."
(10) "Wholesale base rate" shall equal the percentage obtained by dividing "Wholesale base usage" by "Total system base usage."
(11) "City base rate" shall equal the percentage obtained by subtracting "Wholesale base rate" from 100 percent.
(12). "Base system input" shall equal all amounts of water supplied to the SFPUC Regional Water System, which presently comes from the following sources:
(a) Hetch Hetchy water as measured at the venturi meters on the 58-inch, 61- inch, and 78.5-inch San Joaquin Pipeline Nos. 1,2, and 3 near Oakdale. (b) Water supplied by HHWPD to LLNL as measured at the customer meter.
Water delivered from the system to LLNL shall be deemed negative in sign for the purpose of determining "Base system input." (c) Hetch Hetchy water pumped from the Alameda siphons to San Antonio Reservoir as measured at the venturi meter on the 60-inch San Antonio pipeline. Water delivered from the system to San Antonio Reservoir shall be deemed negative in sign for the purpose of determining "Base system input."
9 March I 1, 2009
March i i, 2009
(d) Sunol Valley Water Treatment Plant as measured at the meter on the 78- inch effluent pipeline.
(e) Harry Tracy Water Treatment Plant as measured at the venturi meters on the 60-inch and 78-inch effluent pipelines.
(f) Raw water deliveries to all SFPUCRetail Customers outside the City boundaries as measured at the customer meter. These deliveries are considered positive for the puroses of Table 1. Currently, raw water deliveries to the system are represented by the following account numbers contained in Form MGT440 prepared by the SFPUC's Customer Service Division:
266081-01-7 (Calaveras Nursery)
266081-02-5 (Calaveras Nursery)
264355-01-7 (Caltrans)
266084-02-9 (Color Spot Nursery)
272701-02-0 (Color Spot Nursery)
266069-02-0 (Crystal Springs Golf Course)
266078-02-1 (Dell Franklin)
266078-01-3 (Dells Nursery)
266084-01-1 (Hi-C Nursery)
272701-01-2 (Hi-C Nursery)
284112-01-8 (Hansen Aggregates)
266084-03-7 (Jeff Anhorn Nursery)
272701-03-8 (Jeff Anhorn Nursery)
266079-02-9 (Mission Valley Rock)
281043-01-8 (Mission Valley Rock)
267618~02-3 (Nagata Farms)
267618-01-5 (Nagata Farms)
266090-01-8 (Naka Nursery)
10
March 11, 2009
266091-01-6 (Naka Nursery)
266090-02-6 (Naka Nursery)
266091-02-4 (Naka Nursery)
264315-02-9 (Pacific Nurseries)
266076-01-7 (Sunol Christmas Tree Farm)
266076-02-5 (Sunol Tree Farm)
276095-01-5 (Sunol Valley Golf & Recreation)
266077-02-3 (Ura Farm)
264352-01-4 (Ura, John)
266075-01-9 (Valley Crest)
268276-01-1 (Valley Crest Nursery)
266093-01-2 (Valley Crest Tree Company).
268426-02-0 (Valley Crest Tree Company)
266075-02-7 (Valley Crest Tree Company)
266093-02-0 (Valley Crest Tree Company)
268276-02:-9 (Valley Crest Tree Company)
266082-01-5 (Western Star Nursery)
266089-01-0 (Western Star Nursery)
267254-02-7 (Western Star Nursery)
266082-02-3 (Western Star)
266089-02-8 (Western Star)
267254-03-5 (Western Star)
(g) Raw water deliveries from Pilarcitos Reservoir and Crystal Springs Reservoir to Coastsid~ County Water District as measured at the customer meters. These deliveries are considered positive for the purposes of Table
1. Currently, raw water deliveries to Coastside County Water District from both reservoirs are represented under account number 010027-01-9 contained in Form MGT441 prepared by the SFPUC's Customer Service Division:
11
March I I, 2009
(h) Crystal Springs Balancing Reservoir. The flow into or out of the Crystal Springs Balancing Reservoir shall be calculated based on the changes in the amounts of water stored in the reservoir. The amounts of water stored shall be determined by the use of water level sensors, and the application of water level readings to a water level-storage capacity table. Decreases in storage, which indicate a flow from the Balancing Reservoir into the system, shall be deemed positive in sign. Increases in storage, which indicate a flow into the Balancing Reservoir from the system, shall be deemed negative in sign. Over the period of a year, the total flows into and out of Crystal Springs Balancing Reservoir are nearly equivalent. As such, total sys.tem input from Crystal Springs Reservoir shall be deemed zero for calculating current base rates.
(i) Deliveries to Crystal Springs Reservoir as measured by the overflow weir at the Pulgas Pump Station. Deliveries from the system to Crystal Springs Reservoir ("spills") shall be deemed negative in sign for the purpose of determining "Base system input."
G) Terminal Reservoirs. The "terminal reservoirs" consist of Sunset Reservoir, University Mound Reservoir, and Merced Manor Reservoir, each located within the City of San Francisco. The flow into or out of the terminal reservoirs shall be calculated based on the changes in the amounts of water stored in them. The amounts of water stored shall be determined by the use of water level sensors, and the application of water levels to water level-storage capacíty tables. Over the period of a year, the total flows into and out of terminal reservoirs are nearly equivalent. As such, total system input from the terminal reservoirs shall be deemed zero for calculating base rates.
(k) Other Sources. Other sources of flow into, or from, the Regional Water System, shall be accounted for as "other sources." Examples of other 12
sources of system input would include intertie water deliveries between the Regional System and the Santa Clara Valley Water District, and between the Regional System and the East Bay Municipal Utilities District, and deliveries of raw water from Crystal Springs Reservoir in the event of an emergency. Flows from the system shall be. deemed negative in sign for the purpose of determining "Base system input." (13) "Total base system input" shall equal the sum of the system inputs from the sources described in paragraph B. i .12. .
(14) "Joint system loss reduction factor" shall equal "Total system base usage" divided by "Total base system input." "Joint system loss reduction factor" shall not exceed 1.0.
(15) "Daly City reduction factor" shall equal "Net San Francisco base deliveries" divided by "Gross San Francisco County line base deliveries." "Daly City reduction factor" shall not exceed 1.0.
(16) "Total suburban base deliveries" shall equal "Other suburban base deliveries" plus "Total wholesale base usage."
(17) "Suburban reduction factor" shall equal "Wholesale base usage" divided by "Total suburban base deliveries." "Suburban reduction factor" shall not exceed
1.0. (18) "HHWPD Deliveries above Oakdale" shall equal the total amount of water delivered by the HHWPD to users located above the system input meters in Oakdale. Water users located above the system input meters in Oakdale are currently represented by Groveland Community Services District and the HHWPD facility at Moccasin.
13 March 11, 2009
(19) "HH Reduction Factor" is calculated for the purpose of determining the Wholesale Customers' share of the Hetch Hetchy Assessment. The factor shall equal a fraction, the numerator of which is the total system input measured at the Oakdale meters (Table 1, line 12.a) and the denominator of which is the sum of the total system input measured at the Oakdale meters (Table 1, line 12.a) plus the total "HHWPD deliveries above Oakdale" (Table 1, line 18).
SECTION C. DATA REQUIREMENTS AND SCHEDULE
1. Collection and Dissemination of Data
The SFPUC presently compiles daily flow data for the County-line meters, System Input and In-Line Meters, and daily reservoir water level data, and provides copies of that data to the Wholesale Customers (through BA WSCA) on a monthly basis. Thè SFPUC also provides copies of wholesale "Suburban Resale" and City Retail water usage data to BA WSCA on a monthly basis. Additionally, the SFPUC provides BA WSCA aCcess to flow data for the meters as reported and recorded by the SFPUC's SCADAsystem.
The SFPUC shall continue to provide the flow and water usage data described above to BA WSCA on a monthly basis, and shall continue to allow BA WSCA access to the SCADA system data, so that a coordinated effort between the SFPUC and BA WSCA will allow for updating Table 1 of this Attachment annually on a timely basis.
It shall continue to be the SFPUC's responsibility to compile the data necessary to update Table 1 of this Attachment annually and the City shall deliver to BAWSCA, for review and approval, copies ofthe updated Table 1 by September 15 for the fiscal year ending the preceding June 30, as shown by the schedule contained in Section C.3. 14 March i i, 2009
Upon reasonable notice to the General Manager of the SFPUC, BAWSCA shall be given access to all water flow ànd usage records compiled by the SFPUC, including raw data, at reasonable times during business hours and shall have the right to copy such records and data at its expense.
2. Lack of Data
The paries recognize that, because of human error, mechanical failure, or other unplanned events, portions ofthe data required for the calculation of the usage rates and ratios described in Sections B and C of this Attachment occasionally may be unavailable or incorrect.
In the event that such data are unavailable or inaccurate, the SFPUC shall make a reasonable estimate of the unavailable or incorrect data or use the most accurate alternative data that are available, and substitute the estimate therefor.
If the SFPUC uses an estimate of the unavailable or inaccurate data or alternative data, it shall provide BA WSCA with the following:
(1) a description of the unavailable or inaccurate data and the estimation or substitution of data used therefor;
(2) an explanation of the cause of the missing or inaccurate data and the reasons underlying the SFPUC's estimation or substitution of alternate data; and (3) a statement of how the error or malfunction that caused the unavailability or inaccuracy of the data will be avoided in the future.
The SFPUC shall provide this information to BA WSCA upon calculation by the SFPUC of the usage rates and ratios described in this Attachment for the fiscal year in question. 15 March i i, 2009
3. Schedule for Completing the Annual Calculations of Water Usage Rates The paries recognize the importance of updating Table 1 of this Attachment anually in a timely maner, and that historically, doing so has required a coordinated effort between the SFPUC and BAWSCA. To assure timely completion of the anual calculations of water usage rates 'and ratios, the paries agree to adhere to the following schedule. (1) By August 15: The SFPUC shall forward to BA WSCA all data for the fiscal year ending the preceding June 30, necessary to make a determination ofthë base water usage and base allocation rates for the Wholesale Customers and the City. (2) By September 15. The City shall deliver to BAWSCA, for review and approval, draft copies of the updated Table 1 for the fiscal year ending the preceding June 30. (3) Between September 15 and October 15. The SFPUC and BAWSCA shall reconcile any discrepancies or inaccuracies in the draft calculations of water usage rates and shall reach agreement on a final updated Table 1 for the fiscal year ending the preceding June 30. (4) By November 1. The SFPUC shall deliver to BA WSCA a finalized updated Table 1, signed by the SFPUC General Manager, or appropriate designee, representing the water usage rates agreed upon by the SFPUC and BAWSCA, for the fiscal year ended June 30. (5) By November 15. BA WSCA shall return the finalized Table 1 to the SFPUC, counter-signed by the BA WSCA General Manager/CEO. If the SFPUC does not receive the countersigned Table 1 from BA WSCA by November 15, it may use the water use data as contained in the Table 1 delivered pursuant to paragraph (4) above, subject to arbitration as provided in section 8.01 of the Agreement.
16 . March 11, 2009
SECTION D. COUNTY LINE AND IN-CITY TERMINAL RESERVOIR METER CALIBRA nON AND MAINTENANCE
i. General
This section refers only to the County-Line and In-City Terminal Reservoir Meters. The term "meter(s)" includes the primary meter.itself (most of the primary meters in the SFPUC's water system are Venturi-type flow meters) as well as any and all of the associated equipment used to measure, record, and transmit flow and water level data. The metering equipment associated with the primary metering device (also referred to as the secondary metering equipment) includes differential pressure transmitters, recorders, telecommunications equipment and the portion of the SFPUC's Supervisory Control and Data Acquisition (SCADA) System that is used to transmit flow and water level measurements from the water meter to the computer terminal that records the measured data.
The County-Line and In-City Terminal Reservoir meters, their general locations, and their associated metering equipment are listed in Table 4.
2. Frequency and Type of Work to be Performed
The meters, water level sensors, and associated metering equipment are to be inspected, tested, calibrated, and maintained according to the applicable meter calibration and maintenance frequency specified in Table 5.
3. Components of the Calibration and Maintenance Work
17 March i i, 2009
The SFPUC will contract with an independent metering consultant to perform periodic inspections, testing, servicing and calibrations of the meters and metering equipment for the County-line meters and In-City Terminal Reservoirs. The metering consultant's calibration and maintenance work wil include the following components: . · Annual Pitot Tube Tests: Pitot tube flow tests shall be performed once a year on all . Venturi-type flow meters. See Sections 4.b and 4.c for further detaiL. · Quarterly Secondary Meter Equipment Testing and Calibration: The secondary metering equipment shall be tested for accuracy and calibrated quarterly at five input levels (0%, 25%, 50%,75% and 100% of the full range of flow). See Section 4.a for further detaiL. · Cleaning: Clean and remove dust, oils, dirt, etc. from all instruments. · Flushing: Flush and clean Venturi tube differential pressure (D/P) sensing lines. · Inspecting: Inspections for mechanical fatigue, leaky pipes and fittings, worn parts, and improper operation of electrical/electronic equipment.
· Lubrication: Mechanical parts shall be lubricated as needed.
4. Calibration Procedures
The metering consultant shall continue to calibrate and maintain the County-line meters and metering equipment listed in Table 4 in accordance with the frequency of work specified in Table 5. The work includes documenting meter readings and accuracy before and after calibration. Specific tasks to be completed by the metering consultant are as follows:
a) Quarterly testing and calibration. The secondary metering equipment shall be tested and calibrated quarerly using NIST Traceable test equipment, and a "dead weight tester." 18 March i i, 2009
The system loop error for the secondary metering equipment is determined by connecting its output to the differential pressure transmitter and adjusting the dead weight tester to 5 places over the full range of flow: 0%, 25%, 50%, 75% and 100%, while all instruments in the loop are connected. For water level transmitters, provide simulated test head equal to full range of the transmitter being calibrated, comparing the simulated test head to its 4-20 miliamp output signal to determine transmitter error and calibration requirements.
The system loop error for the secondary metering equipment may not exceed +/-2%. The individual components of the secondary metering equipment shall also be tested at the same 5 input levels and calibrated as necessary to ensure the error of the system and individual components does not exceed +/- 2%.
b) Anual Pitot Tube Testing and Calibration. Annual Pitot tube testing shall be conducted for a comparison of flow totalized by the Pitot tube test equipment and the totalizer used by the SFPUC for water measurement and biling purposes. Annual Pitot tube flow testing shall be performed on all flow meters for assessment of Venturi error using the Annubar continuous flow method at 22%ofthe pipe radius. Pitot tube flow testing must be conducted continuously for a minimum of 30 minutes per test.
The Pitot tube flow tests are first performed before any of the secondary metering instruments are calibrated to determine the total system error (system consisting of the primary metering device and secondary metering equipment). Once the total system loop. error has been established, perform secondary loop instrument testing and calibration as per the quarterly testing and calibration procedures described in 4.a above. If the total system error exceeds +/- 2% after calibration of the secondary metering equipment, minor adjustments to the differential pressure transmitter shall be made to correct (calibrate) the error in the Venturi meter. Repeat Pitot tube testing must be performed after the individual instrument calibration and differential pressure transmitter adjustments have been performed to establish that total system loop error is within +/- 2%.
19 March 11, 2009
c) Pitot tube testing shall be conducted at a flow rate representing the typical flow for the meter (and, if operationally possible, at three different flows ranging from a minimum to near maximum capacity flow).
d) The metering consultant shall perform the meter testing and calibration procedures utilizing the meter characteristic curves (for example, the pressure drop vs. flow for a Venturi meter) that have been obtained during previous meter calibration and maintenance work.
e) During each quarerly site visit, the metering consultant shall tnspect, assess and document the condition of all metering equipment, including meter, gauges, indicators, recorders, transmitters and other instrumentation, used in the measurement and recording offlow rates and cumulative flow totals and shall document all operational problems with. the calibration instruments and meters during the calibration process. Problems may include air entrainment, leakage, flow disturbance and unstable meter readings. f) Prior to each quarterly site visit, the metering consultant shall review prior calibration records and reports for each meter to determine if previously-identified errors or equipment deficiencies were corrected as previously recommended. g) Each quarter, the metering consultant shall submit a final report (See Section 6) containing all of the calibration results for each meter tested and calibrated during the quarter. The metering consultant's report shall include a narrative description of the work conducted on each meter and meter calibration reports for the individual metering equipment. The quarterly report shall also address deficiencies that were not previously corrected according to the recommendations made in the prior report.
5. Calibration Instruments
The instrument used for flow testing of the primary meter (Venturi) must meet the accuracy standards required by the American Water Works Association (AWWA), and be 20 March i i, 2009
capable of measuring actual flows with an error of less than +/- 2%. If a particular calibration instrument is not rated for accuracy by the A WWA, its accuracy wil be determined by reference to its manufacturer's representations as to accuracy.
6. Calibration Reports
Within foureen (14) working days after the beginning of each quarter, the metering consultant shall submit a written progress report of the work performed during the previous quarter. Each quarterly report wil describe the results of the meter calibrations and any other tasks performed. The report wil also include comments regarding any observations of abnormal conditions and any recommendations regarding these meters and their related equipment.
The reports must include complete descriptions and status of meters and related equipment, dates and times of service, all calibration specifics, pipeline dimensions, range of flow rates and totalized volumes, before and after error analysis and accuracy levels achieved, testing equipmentused, and the name(s) of the person(s) that performed the work.
When appropriate and necessary, the metering consultant shall provide recommendations for improving the accuracy and reliability of the equipment and/or the methods of data collection. If, in the opinion of the metering consultant, the condition of a meter or its associated metering equipment is found to be defective, damaged, or otherwise in need of immediate repair or replacement, the metering consultant shall: 1) promptly notify the appropriate SFPUC personnel of the problem and recommend a solution to the problem so that the SFPUC can determine how to address it and, 2) include the problem description in its quarterly report. -
21 March 11,2009
FIGURE 1
Golden Gate Bridge
Pacific Ocean
Bay Bridge
San Francisco
San Francisco
Bay
Lake
Merced
CITY AND COUNTY
4 OF SAN FRANCISCO 6
SAN MATEO COUNTY
Lake Merced
Pump Station
G),CI,~ .
(See detail )on Figure 2
San Pedro
Valve Lot
N
w.'
0 1.6
i
MILES
METER
1 2
3 4
5 6
A
PIPELINE
Sunset
Sutro
Lake Merced Outfall
San Andreas No. 2
Crystal Springs No. 1
Crystal Springs No. 2
San Andreas No. 3 (Planned)
LOCATION
Lake Merced Pump Station
Lake Merced Pump Station
Lake Merced Pump Station
Junipero Serra (Hwy. 280) South of Belle Ave.
PG&E Martin Service Center Yard
Tamasco Ct. South of Sunnydale Ave.
To be determined
METER
7 8
9 RESERVOIR
Sunset Reservoir
University Mound Reservoir
Merced Manor Reservoir
LOCATION
26th Avenue and Ortega
University Avenue and Bacon
23rd Avenue and Ocean
JobFoldorJ2175JFlauni 2(122:i08Jdraftal
..'
S 0:
ëi;,
.0 ~
i- Vl
:; W
00:-- i-"- w
Vl
z::
Vl
CD
Sunset Venturi Meter_):
w
Z
:¡
".--"-
"-::
48" DISCHARGE TO SUNSET SUPPLY LINE ~
~~~ ~Sljç'r"" 3/0tV-~.. GATE VALVE Vl
~!l6A;', (TYPICALLY CLOSED)- 15
Súiy'"
SI:i-~
SÚf;'P'"~~,_~~~_
~/J11:
w
Z
:¡
".i-z:: ::
t.,I¡~8. "- 0:; uo !!-- u
"- z.i
0:"-
Z.i
Vl
Outfall Meter
NOTE:
Water enters Lake Merced Pump 5 tation from the 5 unset supply line (pipeline highlighted in yellow) and is discharged from the 5 unset Pumps (numbered 1,2, and 3) to 5 unset Reservoir located in 5 an Francisco, or to the suction side of the 5 utro Pumps (numbered 4,5, and 6).5 utro Pump Nos. 5 and 6 are typically on standby. 5 utro Pump NO.4 delivers water from the pump station to 5 utro Reservoir located in 5 an Francisco. Delivedes from the 5 F P UC water system to La ke Merced are accomplished by gravity through the 16-inch
pipeline that connects to the suction side of 5 unset
Pump NO.2.
õ1
e)
C::
Generalized Schematic of Lake Merced Pump Station 1mN
WeMe,
METER
10 11
12 13
14 15
16 17
18 19
20 21
22 23
24 25
26 27
28 29
30 31
B
C
D & E
w+
STANFORD
TUNNEL
o 2.5 5
MILES
PIPELINE
San Joaquin Pipeline No.
San Joaquin Pipeline No.
San Joaquin Pipeline No.
San Antonio Pipeline
Sunol Valley WT Effuent
Calaveras Pipeline
Irvington . Bay Division Pipeline No. 1
Irvington . Bay Division Pipeline No. 2
Irvington . Bay Division Pipeline No. 3
Irvington . Bay Division Pipeline No. 4
Pulgas - Bay Division Pipeline No. 1
Pulgas . Bay Division Pipeline No. 2
Pulgas . Bay Division Pipeline No. 3
Pulgas . Bay Division Pipeline No. 4
Crystal Springs Reservoir Outfall
Harry Tracy WTP Effuent . Sunset Supply
Harry Tracy WTP Effuent . San Andreas Supply
Crystal Springs . san Andreas Pipeline
Crystal Springs Pump Station . Sunset Supply
Crystal Springs Pump Station . Crystal Springs No.
Crystal Springs Balancing Reservoir
Santa Clara Valley WD Intertie
San Joaquin Pipeline No. 4 (Planned)
East Bay MUD Intertie (Planned)
Bay Division Pipeline No. 5 (Planned)
(not shown on this map)
(not sho\M on this map)
(not shown on this map)
2 Supply
FIGURE 3
LOCATION
Albers Road, South of Oakdale in Slanislaus County
Sae as San Joaquin Pipeline No. 1
sae 8S San Joaquin Pipeline No. 1
Sa Antonio Pump Slatlon
Sa Antonio Pump Slation
Sunol Valley Water Treatment Plant
Driscoll Road in Fremont
sae as Irvington Bay Division Pipeline No.
Mission Boulevad in Fremont
sae as Irvington Bay Division Pipeline No.
Hassler Road at Pulgas Valve Lot
sae as Pulgas Bay Division Pipeline No.
sae as Pulgas Bay Division Pipeline No.
sae as Pulgas Bay Division Pipeline No.
canada Road near Pulgas Temple
Harr Tracy Water Treatment Plant
Harr Tracy Water Treatment Plant
Crstal Springs Pump Slation
Crstal Springs Pump Slation
Crstal Springs Pump Slation
canada Road near Pulgas Temple
Milpitas Boulevard in Milpitas
To be determined
To be determined
To be determined
. Lawrence L1vennore
National Laboratory
Connection to
San Joaquin Pipelines
~\"'~an Joaquin Pipeline Meters
- "";; 0;9":""' (i9),~ ,G3, fB
Located near Oa~
Calaveras
Reseroir
Locations of System Input and In-Line Meters
Table 1
Base Usage (mgd) and Allocation Rates
(1 ) (2) (3) (4) (5) (6) (7) (8)
Usage Definition 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10
1. Gross S.F. Co. line 8.1 79.5 78.3 75.7
2. Daly City portion 8.2 0.2 0.2 0.2
3. Net S.F. (1-2) 79.3 78.1 75.5
4. Other suburban raw water 8.4 0.4 0.5 0.7
5. Other suburban treated water 8.5 4.1 3.4 3.9
6. Total other suburban (4+5) 4.5 3.9 4.6
7. Total City usage (3+6) 83.8 82.0 80.1
8. Total wholesale usage 8.8 167.4 164.4 175.8
9. Total system usage (7+8) 251.2 246.4 255.9
10. Wholesale alloc. rate (819) 66.63% 66.72% 68.70%
11. City alloc. rate (100%-10) 33.37% 33.28% 31.30%
12a. HHWPD input (Oakdale) 8.12 194.7 202.6 227.3
12b. Deliveries to LLNL 8.12 -0.4 -0.9 -0.9
12c. HH to San Ant. Res. 8.12 -3.8 -1.8 -11.6
12d. Sunol ValleyWTP 8.12 28.5 29.4 17.6
12e. Harr Tracy WTP 8.12 45.2 40.4 41.2
12f. Raw water deliveries 8.12 0.4 0.4 0.7
12g. Deliveries to Coastside Co. WD 8.12 1.8 1.6 2.1
12h. Crys. Sprs. 8al. Res. 8.12 0.0 0.0 0.0
12i. Spil to CS Res. 8.12 -19.9 -42.6 -37.1
12j. Terminal Reservoirs 8.12 0.0 0.0 0.0
12k. Other sources 8.12 0.0 1.9 3.8
13. Total system input 8.13 246.5 231.0 243.1
14. Jt. sys. loss red. fact. (9113) 1.0000 1.0000 1.0000
15. Daly City red. factor (311 ) 0.9975 0.9974 0.9974
16. Total suburban (6+8) 171.9 168.3 180.4
17. Suburban red. factor (8116) 0.9736 0.9768 0.9745
18. HHWPD Deliveries above Oakdale 8.18
19. HH Reduction Factor 8.19 99.56%
Meter
1 2
3 4
5 6
A
Meter
7 8
9 Table 2
Locations of SFPUC County-Line Meters and In-City Terminal Reservoirs County-Line Meters
Pipeline
Sunset
Sutro
Lake Merced Outfall
Location
Lake Merced Pump Station
Lake Merced Pump Station
Lake Merced Pump Station
San Andreas NO.2
Crystal Springs No. 1
Crystal Springs NO.2
JuniperD Serra (Hwy. 280) South of Belle Ave.
PG&E Martin Service Center Yard
Tamasco Ct. South of Sunny dale Ave.
San Andreas NO.3 (Planned) To be determined
In-City Terminal Reservoirs
Reservoir
Sunset Reservoir
University Mound Reservoir
Merced Manor Reservoir
Location
26th Avenue and Ortega
University Avenue and Bacon
23rd Avenue and Ocean
Meter
10 11
12 13
14 15
16 17
18 19
20 21
22 23
24 25
26 27
28 29
30 31
B
C
D&E
Table 3
Locations of SFPUC System Input and In-Line Meters
Pipeline
San Joaquin Pipeline NO.1
San Joaquin Pipeline NO.2
San Joaquin Pipeline NO.3
San Antonio Pipeline
Sunol Valley WTP Effluent
Calaveras Pipeline
Irvington - Bay Division Pipeline NO.1
Irvington - Bay Division Pipeline NO.2
Irvington - Bay Division Pipeline NO.3
Irvington - Bay Division Pipeline NO.4
Pulgas - Bay Division Pipeline No. 1
Pulgas .. Bay Division Pipeline NO.2
Pulgas - Bay Division Pipeline NO.3
Pulgas - Bay Division Pipeline NO.4
Crystal Springs Reservoir Outfall
Harry Tracy WTP Effluent - Sunset Supply
Harry Tracy WTP Effluent - San Andreas Supply
Crystal Springs - San Andreas Pipeline
Crystal Springs Pump Station - Sunset Supply
Crystal Springs Pump Station - Crystal Springs NO.2 Supply Crystal Springs Balancing Reservoir
Santa Clara Valley WD Intertie
San Joaquin Pipeline NO.4 (Planned)
East Bay MUD Intertie (Planned)
Bay Division Pipeline NO.5 (Planned)
Location
Albers Road, South of Oakdale in Stanislaus County
Same as San Joaquin Pipeline No. 1
Same as San Joaquin Pipeline NO.1
San Antonio Pump Station
San Antonio Pump Station
Sunol Valley Water Treatment Plant
Driscoll Road in Fremont
Same as Irvington Bay Division Pipeline NO.1
Mission Boulevard in Fremont
Same as Irvington Bay Division Pipeline No,3
Hassler Road at Pulgas Valve Lot
Same as Pulgas Bay Division Pipeline No. 1
Same as Pulgas Bay Division Pipeline NO.1
Same as Pulgas Bay Division Pipeline NO.1
Canada Road nearPulgas Temple
Harry Tracy Water Treatment Plant
Harry Tracy Water Treatment Plant
Crystal Springs Pump Station
Crystal Springs Pump Station
Crystal Springs Pump Station
Canada Road near Pulgas Temple
Milpitas Boulevard in Milpitas
To be determined
To be determined
To be determined
TABLE 4
SFPUC COUNTY~LINE METERS, IN-CiTY TERMINAL RESERVOIRS,
AND ASSOCIATED METERING EQUIPMENT
County-Line Meter Meter Type Location
1. Sunset 60" Venturi Lake Merced Pump Station
Associated Metering . Rosemount DIP transmitter
Equipment: . Honeywell recorder
. SCADA
2. Sutro 36" Venturi Lake Merced Pump Station
Associated Metering . Rosemount DIP transmitter
Equipment: . Honeywell recorder
. SCADA
3. Lake Merced Outfall 16" Mao. Meter Lake Merced Pump Station Associated Metering . Honeywell recorder
Equipment: . SCADA
4. San Andreas NO.2 36" Venturi Junipero Serra (Hwy. 280) south of Belle Avenue
Associated Metering . Yokogawa DIP transmitter
Equipment: . NLS display
. AGM electronics
. Honeywell recorder
. SCADA
5. Crystal Springs NO.1 44" Venturi PG&E Martin Service Center Yard
Associated Metering . Yokogawa DIP transmitter
Equipment: . NLS display
. AGM electronics
. Honeywell recorder
. SCADA
6. Crystal Springs NO.2 60" Venturi Tamasco ct. south of Sunnvdale Avenue
Associated Metering . Yokogawa DIP transmitter
Equipment: . NLS display
. AGM electronics
. SCADA
In-Citv Terminal Reservoirs
1. Sunset Pressure 26m Avenue and Ortega
Transducer
Associated Metering . Honeywell recorder
Equipment: . SCADA
2. Merced-Manor Pressure 23ra Avenue and Ocean
Transducer
Associated Metering . Honeywell recorder
Equipment: . SCADA
3. University Mound Pressure University Avenue and Bacon Transducer
Associated Metering . Honeywell recorder
.Equipment: . SCADA
TABLES
METER CALIBRATION AND MAINTENANCE FREQUENCY
METERI FREQUENCY WORK TO BE PERFORMED
EQUIPMENT (See Work Codes Listed Below)
Quarterly Semi- Annual CA CL FL IN LU PT
Annual
Venturi Meters X X X X X
(1 ) (1 )
Magnetic Meters X X X X
(2) (2) (2)
Yokagowa DIP X X X X X
Transmitters
Rosemount DIP X X X X X
Transmitters
Honeywell X X X X
Recorders
Water Level Sensors X X X X
(Pressure Transducers)
SCADA Electronics X X
AGM Electronics X X
NLS Digital Displays X X
Electrostatic 24V DC X X
Power Supplies (3)
ASCO Solenoids X X X X
(4)
WORK CODES:
CA = CALIBRATE; CL = CLEAN; FL = FLUSH; IN = INSPECT; LU = LUBRICATE; PT = PITOT TUBE TEST.
NOTES:
(1) Inspection and flushing requirements for Venturi meters refer to the pressure tubing from the meter to the differential pressure transmitter.
(2) May calibrate using clamp-on meter where conditions allow. Inspection and cleaning requirements for magnetic meters refer to the sensors or probes that are inserted through the pipe walL. (3) Adjust voltage if necessary.
(4) Replace rubber ware as needed.
ATTACHMENT K
III-wIIIIci
~z
~xw
u.
ow
:J..
~
.- ~ I~ 0 l-
I- ~ ~
as t fa
~ Z l-
I u. :JU 0 I-
g ~ ~.. ci :J
~ II
in ~ff 0~ I-
o )-
I- ixII ci
:J Z.~ ~
~ ¡jw ix.. c.
o *
i *
~
**IIw:J..
~
en
~om..~..ciZ
u.
moi.
i:o
:e
QI
~
~I
Cl
H~~~ u lD
'0 ~ U)
a: :i .v
.. Mo --
O' .-
~I Gf ~-;; lJ"l N-
~ ~
O'
00.-
00 O'
ir~
ui MM N
ui 0
..' ..-
M 0
ui 00
N- ir
lD
00 ..
O'
..-.ui.-
.--uiui
.v
00ui
ui
",:t--M
00lD
.v
'*.N
.¿lD
-- O' --N 00 .-q O' --
q- --' cñM O' N.. ui M.
lD' ir N-lD .- 00
M M
.v.v .v
00 O'O' 0o .-
cñ 00-- N.- ..0' m--
.v .v
lD
oN
..'..
00 m--
.v
. M O'
.- ui.- M
--- cñlD lDN .-N' ..'N
.v .v
'* ui lD mM N M M.- 00 0ui cñ 00-ui .-N .-m
.v .v
M.. M 0'*...- ..'*LJui.-O N'-NOO OMN.- O' ui -- c: MOON .- .-- --' 00 m .. ir I. N- ui.. 00 N.- OOlD ui..000'00 uiOO--N' ui- lD- N' lD'.-- 00' lD lD .-OON .- M-- -- M M
.v.v .v .v
.v .v .v .v .v .v
Vl
Cl+-oZ
M N M
O'
.!oM..lD O'
'õ ~~ ~
lD
O' ~ 'õ
~ ~ ~
~ Q1 ::lD .. ;;'+ ti Uo e "0Vl c. i:ro ro+- i: +-
i: -' Cro .. ro
el 0 el
'¿ 3;
z
E
Cl+-Vl
;:Vl
ro Vl
:: '¿
1: Vl V)
~ ~ §ro ~§ 'e._ "0
ti ci
Cl
ix ro+-'+ C 'ë.o 0 roVl C Uro 0 O'
~ .~ 0
rc 'ü 00
el Cl 0+- .. 0Cl a. NZ Cl ~ roo LL CE"O-o 0Cl Cl Cl oM
t; tJ tJ OJ
J' Cl Cl ix"Q "Q -0rc i. li Q)c: a. a. tJo Cl
:r~£l£
00 ~M..lD
--
î
Co''¡
u::..+-Vl
CoU
"0
Cl+-U(J
(J..a.
ro 3;
C U
.2 -0
ti Cl
Cl ..ix ~
~ 'ètí a.
.~ 'õ
e (Ja. ~
ro 'õ ¡¡
25 ~ ~ Q)OM tJ ~ ~
~ ~ Vl (J
-0 c~:g
~ 2 ~ 3;~ rn ~
'0 ~ ~. ~
0: ;; ~ a:
+-
Cl
z
E
Cl+-Vl
;:Vl
ui
.v.v .v
lD
O'
.!oM..lD
'+o
Vl
ro
+-c
ro
el
+-
Cl
z
E
Cl+-Vl
;:vi
~O' ~
~ ~M ro.. a.lD
'+o
Vl
ro
a.
3;U
-0C
ro
..c
ro
el..
Cl
Z
"0
Cl+-U
Cl
'0..a.'+o
Cl..
ro
.. Clvi +-
Cl ~ Vl
ro ..
~ ~ ~... ~ i.3; C ~
.. lD.
.. NN M
--'o .-'o uio 0N- --'N
.v .v
::0-
Cl
+- ixVl (JCl ::
.. c~ (Jc ;:
Cl
ix
ro ~a. ~
'u Clc 0..
3;
o(
o¡:
a.
~
.. ro+- ::c co c
~ ci
..c::o
Eci
+-C
Cl
E
~
00 ~~lD
'õ
Vl
ro
toa.
Cl
ix
c:oNM
Vl
Uc:c:
jl :
Vl
3.2 :ê
Vl
ro
Vl+-C::o
E
ro
"0c
ro
Vl+-U
Cl
'0..
a.co
"0
Cl
Vl
ro
.0
Cl Cl+- ..ro ro
E E
:¡ ¡:Vl VlL. L.
U U
:J :Ja. a.LL LLVl Vl
N M
Vl+-
Cl
VlVl
c:..
Cl+-ro
3;
-- ui -- M-- .- O' ui.. -- O' .-
N- cñ 00 rl00 .. 0 ..M lD .. ..
..- M' .-' N'ui lD
.v .v.v .v
c"iii cro Vl 0m O',¡
.. i. "Vi
t 1: ::o 0 0-Z U uc c:.. 0 "0'õ ". c
2: ~ ~Cl c "0Vl c Cl
~ 0 c.+- U ~
Cl Vl Cl
Vl Vl ..C 0 ro~ Ò 3;
00 ui --ui lD O'
M M M
3; 3; 3;
:J :J :J
U U U
Vl
::
c.
00 .!oM..lD
Vl
ro
Cl
ucro
ro
Vl .0c co 0
".¡ 'U
'e Cl
-0 Vl
c: ~
ro a.
Õ 3;i- u
--
Vl
Cl..::.t-0c
Cl
a.x
Cl
o
~
~.0
~'+o
Clo
tiro..
Cl
;:ro
..
ro
Cl
;:
Ji
"0(J+-..
.9P
(J
3 Vl
Cl..::.t-0c
Cl
a.
x
Cl
oi-~
Vl
::
c.
00 ~M~..00 lDo Vl
r: ro.. 0 Cl
~ ~ ~
c. ~
ti ro:: .0
o c
.c 0.. -0-- Cl
9 :G~ m -0
o g a.tí ~~+- ~ ~Ceo ClOJ 0 t) ~
.§ .~~~ro 0 ro
:t rc ¡: lIc: -0 ro Cl
Cl (J U 0
Cl X 0 c.
~ u: ro 3;
o-0
c.
o
"0
Cl
Vl
ro
.0
N
:.
ui lD
O'
o
oN.....-
~
.-'+o.-
Cl
ti
roa.
N:.
+-C
Cl
E..Uro+-
~
Cl
(J
~
ATIACHMENT K-2
WHOLESALE CUSTOMERS' SHARE OF THE BOOK VALUE OF REVENUE FUNDED CAPITAL EXPENDITURES "PRELIMINARY - TO BE SUBSTTUTED WITH FINAL 6/30/09 VALUES" ¡Seetlon 5.03)
(11 (2) 13) (4) (51 (6) (7J (B) (9)
Project CWIPasof FY 2008.09 Reduction for CWIPas Water Related Wholesale No. Project Description Rate Class 6/30/08 Expenditures 02A Funding 6/30/09 CWIP Share A. Water Enterprise
1 Regional Projects
CUW352 Alameda Creek Fishery Joint S 2,007,607 S 224,582 S 2,232,189 S S CUW353 Seismic Upgrade (§ Hayward Fault Joint S 3,129,234 S 1,967,625 S 5,096,859 S S CUW354 LOWER CRYSTAL SPRINGS DAM-REV-5FWD Joint S 7,046,944 S 1,086,262 S 8,133,206 S S CUW355 STANDBY POWER FACILITES Joint S 3,715,276 S 6,596,849 S 10,312,125 S S CUW357 Adit leak Repairs Joint S 783. S 1,129 S 1,912 S S CUW359 Irvington Tunnel Joint S 21,391,129 S 5,176,713 S 26,567,842 S S CUW359 Joint S 7,837,176 S S 7,837,176 S S
CUW361 Joint S 368,057 S 1,383,959 S 1,752,016 S S
CUW361 Joint S 1,255,545 S S 1,255,545 S S
CUW361 Pulgas Balancing Reservoir Joint S 1,248,002 S S 1,248,002 S S CUW361 Joint S 570,179 S S 570,179 S S
CUW361 Joint S 712.921 S .. S 712,921 S S
CUW363 SCADA Phase II Joint S 1,335,371 S 1,738,045 S 3,073,416 S S CUW363 Joint S 1,062,050 S S 1,062,050 S S
CUW365 Cross Connection Control Joint S 3.635,172 S 547,801 S 4,182,973 S S Capitalized in FY 200~-o9 CUW367 HTWP LT lmpr Joint S 8,011,348 S 2,479,731 S 10,491,079 S S CUW368;. , Joint S 23,640,601 S S 23,640,601 S S
CUW368 BDPL Hydraulic Capacity Joint S 17,556,905 S 4,200,442 S 21,757,347 S S CUW368 Joint S 2,579,847 S S 2,579,847 S S
CUW370 Pipeline Readiness Joint S 5,320,934 S 328,070 S 5,649,004 S S CUW371 CSPS and Pipeline Joint S 11,420,770 S 3,872,779 S 15,293,549 S S CUW372 University Mound (N) Joint S 4,624,981 S 1,068,147 S 5,693,128 S S CUW373 ~5JPL Joint S 19,479,341 S 6,023,849 S 25,503;190 S S CUW373 Joint S 7,199,051 S S 7,199,051 S S
CUW374 Calaveras Dam Joint S 31,171,669 S 4,314,430 S 35,486,099 S S CUW374 Joint S 2,366,343 S S 2,366,343 S S
CUW378 C5PL #2 Joint S 7,453,098 S 913,369 $ 8,366,467 S S CUW379 5APL #3 Joint S 5,728,934 S .588,346 S 6,317,280 S S CUW380 BDPK "3&4 Crossovers Joint S 3,855,357 S 1,083,888 S 4,939,245 S. S CUW381; . Joint S 5,450,995 S S 5,450,995 S S
CUW381 SVWTP Expansion Joint S 53,222 S 3,090,520 S 3,143,742 S S CUW381. . Joint S 97,373 S S 97,373 S S
CUW382 SVWTP Treated Water Reservoir Joint S 5,799,505 S 575 S 5,800,080 S S 'CUW384 Tesla Joint S 6,102,621 S 7,444,942 S 13,547,563 S S CUW386 SAPS X-CONNECT & PUMP IMP 96A UEa Joint S 1,374,491 S 971,625 S 2,346,116 S S CUW388fPEIR Joint S 896,476 S 1,641,717 S 2,538,193 S S CUW388 Joint S 1,331,676 S S 1,331,676 S S
CUW390 Desalination Pilot Joint S 175,165 S S 175,i65 S S CUW391 Baden/San Pedro Valve Lots Joint S 3,964,642 S 948,589 S 4,913,231 S S CUW392 Program Management Joint S 2,452,297 S 5,081,444 S 7,533,741 S S CUW393 BDPL 114 Condition Assessment Joint S 25.071 S 294,634 S 319,705 S S CUW394 Watershed Envirof!ent Improvement Joint S 142,924 S 96,027 S 238,951 S S Capitalized in FY 2008-09 CUW101 SAN ANDREAS PLANT EXPANSION #1 Joint S 182 S 96,027 S 96,209 S 67,443 CUW111 LOWER CRYSTAL SPRINGS DAM-REV-5FWD Joint S 40,436 S S 40,436 S 28,346 CUW151 Baden PS Joint S 921 S 26,760 S 27,681 S 19,404
CUW161 Water Treatment Facilities Joint S 75,801 S 605 S 76,406 S 53,561 CUW178 SAPS X-CONNECT & PUMP IMP 96A UEB Joint S 104,902 S S 104,902 S 73,536 CUW202 J Joint S 50,808 S S 50,808 S 35,616
CUW202 Replace pecp Joint S 285,003 S 64,256 S 349,259 S 244,831 CUW202 Joint S 2,365 S S 2,365 S 1,658
CUWl27 SCADA Joint S 50,029 S 2,481.274 S 2,531,303 S 1,774,443 CUW356 New Crystal Springs Bypass Tunnel Joint $ 13,992,264 S 5,560,862 16,028,397 S 3,524,729 S 2,470,835 CUW358 Sunset (N) Joint S 52,494,764 S 4,887,980 55,806,081 S 1,576,663 S 1,105,241 Capitalized in FV 2008-09 CUW387 Tesla Portal Disinfection Joint S 2,377,262 S (1,996) 1,223,945 S 1,151,321 S 807,076 'OW"') Joint S 45,413 S S 4.5,413 S 31,835
. CUW135 New Lines and Bypass Valves Joint S 153,983 S 620,156 S 774,139 S 542.671 CUW135 Joint S 8,860 S S 8,860 S 6,211
CUW143 Joint S 5,656 S S 5,656 S 3,965
CUW143 HH Water Treatment Plan Joint S 709,972 S 8,817 S 718,789 S 503,871 CUW143 Joint S 96,292 S S 96,292 S 67,501
CUW186 5VWTP IMPROVEMENT PROJECT -eP~-5FWD Joint S 3,604 S S 3,604 S 2,526 CUW206; Joint S 4,365 S S 4,365 S 3,060
CUW206 Tesla PortallThomas Shaft Emergency Disinfection Joint S 283,620 S 5,665 S 289,285 S 202,789 CUW206 Joint S 227,004 S S 227,004 S 159,130
CUW231 Millbrae labs Joint S 81,856 $ 34.685 S 116,541 S 81,695 CUW236 TEL5A/5JVH WQ MONITORING IMPR Joint S 152,963 S S 152,963 S 107,227 CUW366; . Joint S 16,523 S S 16,523 S 11,583
CUW366 HTWP ST Improvements Joint S 1,398,798 S 5,732,626 7,131,424 S S CUW366 . Joint S 1,452,901 S 1,452,901 S SCUW120 WATER QUALITY PLANNING STUDY Joint S 577 $ S 577 S 404 CUW164 WATER VULNERABILITY STUDY-UEB Joint S 479 S S 479 S 336 CUW181 5TAND8Y POWER FACILITIES Joint S 5,905 S S 5,905 S 4,139CUW210 Milbrae Administrative Bldg Remodel Joint S 7,803 S 321,553 S 329,356 S 230.879 CUW220 Calaveras Dam Evaluation Joint S 308,971 S S 308,971 S 216,589 . CUW227 Watershed Facilties and Fencing Joint S 190.552 S 206,448 S 397,000 S 278,297 CUW228 Watershed Roads Joint S 358,434 S 85,337 S 443,771 S 311,083 CUW232 Crystal Springs Dam Discharge Joint S 363,823 S S 363,823 S 255,040 CUW242J- .. Joint S 311,548 S 22,741 S 334,289 S 234,337Demolition of Unsafe StructuresCUW242 Joint S 315 S S 315 S 221 CUW261 Regional R&R - Storage Joint S 275,694 S 277,958 S 553,652 S 388,110 CUW262J- . Joint S 1,236,895 S 409,282 S 1,646,177 S 1,153,970Regional R&R - Treatement CUW262 Joint S 277,383 S S .27,383 S 194,445
'page 2 of 2 4/17/2009
ATTACHMENT K-3
25 YEAR PAYOFF SCHEÖULE FOR EXISITING RATE BASE
WATER ENTERPRISE REGIONAL ASSETS AND ONE DIRECT WHOLESALE ASSET **PRELIMINARY - TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES** (Section5.03)
Water Assets
6/30/09 Wholesale Share of Net Plant & CWIP (Attachment K-1) 358,452,207 Interest Rate: 5.13%
Term: 25
Monthly Principal & Interest Calculation: 2,004,277
Annual Wholesale Revenue Requirement: 24,051,326
Fiscal Yr Annual Year End
Ending Principal Interest Payment (Wtr) Balance
Jun-lO 6,848,259 17,203,067 24,051,326 331,603,948
Jun-11 7,207,954 16,843,372 24,051,326 .324,395,994
Jun-12 7,586,541 16,464,785 24,051,326 316,809,453
Jun-13 7,985,013 16,066,313 24,051,326 308,824,439
Jun-14 8,404,415 15,646,911 24,051,326 300,420,024
Jun-15 8,845,844 15,205,482 24,051,326 291,574,180
Jun-16 9,310,459 14,740,867 24,051,326 282,263,721
Jun-17 9,799,478 14,251,848 24,051,326 272,464,243
Jun-18 10,314,181 13,737,145 24,051,326 262,150,062
Jun-19 10,855,919 13,195,407 24,051,326 251,294,143
Jun-20 11,426,110 12,625,216 24,051,326 239,868,033
Jun-21 12,026,250 12,025,076 24,051,326 227,841,784
Jun-22 12,657,911 11,393,415 24,051,326 215,183,873
Jun-23 13,322,749 10,728,577 24,051,326 201,861,123
Jun-24 . 14,022,507 10,028,819 24,051,326 187,838,616
Jun-25 14,759,019 9,292,307 24,051,326 173,079,597
Jun-26 15,534,215 8,517,111 24,051,326 157,545,382
Jun-27 16,350;127 7,701,199 24,051,326 141,195,254
Jun-28 17,208,894 6,842,432 24,051,326 123,986,361
Jun-29 18;112,766 5,938,560 24,051,326 105,873,594
Jun-30 19,064,113 4,987,213 24,051,326 86,809,482
Jun-31 20,065,428 3,985,898 24,051,326 66,744,054
Jun-32 21,119,335 2,931,991 24,051,326 45,624,719
Jun-33 22,228,597 1,822,729 24,051,326 23,396,122
Jun-34 23,396,122 655,204 24,051,326 0
Totals: 338,452,207 262,830,943 601,283,150
Water . Page 4 of 1 4/17/2009
ATTACHMENT K-4
25 YEAR PAYOFF SCHEDULE FOR EXISTING RATE BASE
HETCH HETCHY WATER ASSETS AND WATER-RELATED PORTION OF JOINT ASSETS **PRElIMINARY -TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES** (Section 5.03)
Hetch Hetchy
6/30/09 Wholesale Share of Net Plant & CWIP (Attachment K-1) 43,877,206 Interest Hate: 5.13%
Term: 25
Monthly Pr'incipal & Interest Calculation: 259,836
Annual Wholesale Revenue Requirement: 3,118,033
Fiscal Yr Annual Year End
Ending Principal. Interest Payment (HH) Balance
Jun-10 887,814 2,230,219 3,118,033 42,989,393
. Jun-11 934,445 2,183,588 3,118,033 42,054,948
Jun-12 983,525 2,134,507 3,118,033 41,071,423
Jun-13 1,035,183 2,082,849 3,118,033 ,40,036,239
Jun-14 1,089,555 2,028,478 3,118,033 38,946,685
Jun-15 1,146,782 1,971,250 3,118,033 37,799,903
Jun-16 1,207,015 1,911,017 3,118,033 36,592,887
Jun-17 1,270,412 1,847,621 3,118,033 35,322,475
Jun-18 . 1,337,138 1,780,,894 3,118,033 33,985,337
Jun-19 1,407,370 1,710,663 3,118,033 32577,967
Jun-20 1,481,290 1,636,743 3,118,033 31,096,678
Jun-21 1,559,092 1,558,940 3,118,033 29,537,585
Jun-22 1,640,981 1,477,051 3,118,033 27,896,604
Jun-23 1,727,172 1,390,861 .3,118,033 26,169,432
Jun-24 l,8i7,889 1,300,144 3,118,033 24,351,544
Jun-25 1,913,371 1,204,662 3,118,033 22,438,173
Jun-26 2,013,868 1,104,165 3,118,033 20,424,305
Jun-27 2,119,643 998,389 3,118,033 18,304,662
Jun-28 2,230,974 887,058 3,118,033 16,073,688
Jun-29 2,348,153 769,880 3,118~033 13,725,535
Jun-30 2,471,486 . 646,546 3,118,033 11,254,048
Jun-31 2,601,298 516,735 3,118,033 8,652,751
Jun-32 2,737,927 380,106 3,118,033 5,914,824
Jun-33 2,881,733 236,300 3,118,033 3,033,091
Jun-34 3,033,091 84,941 3,118,033 0
43,877,206 34,073,607 77,950,813
Hetch Hetchy Page 5 of 1 4/17/2009
'" VI
:¡ '"02! c'r; .!,. ..c( ai
VI'"0c
'~
E::0C
W
VI
2!
::
in c ;!l- I- "C
W 0. cin '"Coin )(c( w
~g VI
2!z N ::o - o ;t_ 0
(! M I- "C
W:i )- C
a: U '"
o a:. )(
w c( w
0:; .S!z u. ..:J 0
u, in
.¡:
'" w c( e t:~~CI_ Co
!ž ~ i: C!
Co VI
c( 1i
WWa:", VIVI
:; a: (! c c c(
:i a: ~,g ~ ~U 0 0. 0ci U. z ci .. 30~ in -- ""
ci~æ . "iñVI
~~
..
Õ
a: z0. 00- "Ca: I-0. U C
0. :J .2c( a: .c
o lñ ::inw z00
.æ u '"
0. Co
X I-w "CZ c:J ::
U.
VI
~
z a: a: a: a:o/ o/ o/o/a: a: a: a:
ii (i ëü ro:: :: :: ::C C C CC C C C
c( c( c( c(
ro ~ 00 ID w.m a N ~ 00 ~ ~ a MOM m W 00 00 a N ID
~~~~ ~~~~~æ~~~~~ w ~ ~ ~~~~RM~WOÓW~M~~mNrom~o~d~MM ~æ æ ~ ~ ~ ~ ~ ~ ~ ~ 8 ~ ~ ID · ~ ~ re ~ ~ ~ ~'. -v-.. 'r- - .. oq ai M ~ ~ v a ~ ID ~ a ID v a 00 ~. a ~ a a M a a M
~~ff~~~o~ ~~~m~~ ~ ~ ro..wm..~ÑmÑ ""ri ~""i ~ ~ ID~ NN~~~~ ~~ ~ID~ V ~ Ñ
m m v a M a v m ~ ID V V ~ a ~ ~ M M N m ~ m ~
~ m ~ ~ ~ g ~; ~ t ~ ~ ~ ~ ~ 8 ~ ~ ~ ~ ~ ~'gM Ñ ID ~ ro"" ~ å Ñ MID~ M m ~ mN ~ ro"" MID""~ ~ N a ~ mo. M N . M ~ ID ~ 00 ~ . 00 ~ ~ m m "V _~. M M ~ a ~ N _ m. N aID. ~ m ~ ID. NM..~.. Ñ~..~..ri~ro~~ WÑN~ ~ "" M - a ~ M. M. m NOON N NOM o. a mv m ~
~M~.O~~N_N.om_ a Mm_~oIDmvmmIDOOID_Nommo MM~N~ID
"m m a Ñ ri ~ ~ ID m w ri ~ Ñ ID Ñ ro ro ..'~-oN ~Nw~m.-o~oooo mOOMON ~ M N N -v N mÑ .- a m a a a a a 00 a a a a a a mom m a a _ _ W
N M a a a a a m,o a a a a a ~ 00 N _ a a 00 00 N~ moo a a a M a a a ~ a a N W ~ M a a W 00 00'w ~ ò ó ~ å"" ~ a 00 ~ a a ~ m ~ ro o~w~ m~ ro ~ 0 N 0 0 M ~ 0 0 0 ~ 0 ~ N N NOM ~ m 0~ M ~ 0 ro a ro ~ ~ 0 M ~ ~ V N ro ro 0 a ro ~ ~ N- ~'~~~~~ ~¿~¿~~~~¿~~ri~~.. ~ .. 0 ;; ;t ;;ZZZ000
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~~ ~ ~ ~ ~ ~ ilc( c( c( c( c( c( c( c( c( c( c( c( c( c( c( c( c( c( c( a: a: a:ZZZZZZZ ZZZ zz ZZZZZZZ::::::
Q Q Q Q Q Q Q Q Q 22 Q Q Q Q Q Q Q Q c( c( c(
~ ~ ~ ~ (!~ ~ ~ ~ ~ ~ (! ~ ~ ~ (! ~ ~ ~ U U U
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~~ ~ ~ ~ ~ ~ ~ 9 9 9
~~ ~ ~ ~ ~~ ~~~ ~~ ~~~ ~ ~~ ~ ~ ~~
~ ~ ~ ~ ~ I ~ ~ ~ ~ ~ ~ ~ ~ ~ l~ ~ ~ ~ l~
Æ!
¡=
o'"
.e0.
~333 ~~~ ~~ ~~~ ~~ 3 ~~~~ 33 ~~~~~ ~~~ ~~ ~~~~~~ ~ ~ ~~ ~~~ó~ ~ ~ Z ~~a:(! I- ~ in ~zwa 5m~~~§ w ~!ž oQa:â o.~:J~ z~m8 § w ~0~8 !žw0moa:w:J ~ â a::JZ)- w~:J~._za:ai wwwm a:Wa: â;:a:-~a::J 'l-;:(1)wl-~l-(!o 1-01-;:W w 0 Ô ~ 0 L5 a: ~ ~ ff ~ ff I- in L5 a: m ff z a: ~ :J - 0 a: ~ ~ - ~ I- 0 â 5 w a: 0. I- m
o~~~~:J~w~~~~uw:J~I-~~1- ~~a:oin~~a~~~o.~~~~~ffæ&m ~
~ ~ lñ ~ ~ 8 ~ ~ ~ æ ~ 9 8 ~ ~ m ~ E ~ ~ ~ ~ ~-a:c(c( m~o.Üa:ro w~m~~ ~ 0o c( w m ~ c(o Ü ~ c( Z :J Z C(O ~ ~ c( ~u- I- - ~ U ~ a:~ zt: wUw - ~c(o.)- z-"'~1-~:JwOC~wroU.~âa: ~)-:i~~~~I-~o 0 ~ Z Ü 0 ~ a: 5 0 m 9 0 Q m ro Ü I- â â c( ~ 0.ww QZWzO w~~wz~~~z~ o~~:i i ~ ~ c( I W c( W :i w w :i 0 z w w w w â c( 0 ~~ ~ Z ~ ~ ~ â 0 ~ ~ ~ ~ ~ ~ 0 ~ :i â ~ ~ ü a: c(w w Q 0 ~ w ~ ~ ro w ~ ro w c( a: ~ 5 ~ ~ (! m ~ ~ ~ ~ ~:; ô~ w 5 j ~ ü j ~ Z 5 ~ I- W Ü 0 ~ ~ I-~ ~ ~ ~ ü ~ ~ c( ~ ~ ~ ~ ~ ~ m ~ ~ ~ ~ æ ~ g ~ õ
.'"
e0.
~ g w ~ ~ ~ ~ ff M ~ ~ ~ ~ g ~ ~ ~ ID ~ ~ ~ ~NNNNNNN.. NN NN NN ..~~~ N M~ ~~ ~ ~ ~ ~ ~ ~ ~~ ~ ~ ~ 3 3 3 ~ ~ ~ ~ ~ ~ ~:J :J :J :J :J :J :J :J :J :J :J ~ ~ :J :J ~ ~ ~ ~ :J :J :JU U Ü Ü Ü U üü üU üü ü ü U U uu ü ü U ü OO(OID'" ..0'" M..r-~~~ '" onon M ""
¿t~
a MOM
:; ;¡ 0;
ti~g0' 0~~
am ro ~on.. 0NOMÑcn..-0"" 0'0' '" N~oÑ~.. ""
a N m~CD 0' CD.. ~ CD
ro-Ño-~ "" 0CD N 0'
ÑN-V-
a N ~ IDCD CD N'" N ""
~ ro-m-0' ~ 0.... N
~w~... ro ~
;:Zoa~w c(a:z
~:: 0c( c( -U Ü ~oow~~~
~
W
~oa:
0. ~c(Zo
am inw I- I-a: ü Uin 0 w wi-z.,~ü c( 0 0w ~ 0: 0:
o 5 ~ ~
æ 9:: ~
~ i-.Q ~
U ~ ~ ~00 wo~ ~ 0: i-
~vm""''NMa~ooCDoro~mCD~ro ~ CD ~ ~ m CD m m CD M M N CD V (Q N ..M N ~, M M ~ .. N maN ro N a a m CD ..ro~~~Nro~~¿~~M~ro~~ IDN~O~ ..~..NM..~ro(Q~ ro CDMMa ..NmN..~ ~N ~ ~ a
M a ro a a NO.. N ro ~ a a ~ .. d CD NN M ~ M~m..~ mID coma CD NN..M~ N~ ..N¿ m ~ M~m~N cñ~ NCD a M ON~""CD ro ~ N .. roNN.. M~ - ¿
~ ~ ~ ~.m ~ ~ ~ ID ~ ~ ~ g i ~ ~ ~ g~~Mm~~~v~m~M~CDO~NCD gigg~~æ~~g~g~~~~t~ro~ro""''N ~MCD~m~""~NrooÑ Ñ~ ; MM~M~~~r-Ñ ~ ~~m~~~~~~~~o~g~~a~~~m..coo..roNmNCDco~CD~ ~-tLno~-M¿~-mcöcö~~~M05'" ¿M~""~""~ ~~'V'VCD""M"' CD"~.. N O..NMN ..- - -t '"
1iVI
~
g88~ß~gggg~~g~~~g~
a a a M ro N CD a a .. a CD a a ø 'V a a
a a a a cñ m 00 ~ 05¿ cö om M ~ ¿ IDa a a .. ~ CD ro 0 CD CD ~ ro ~ ~ .. ro .. ..a ro 'V N .. 'V N M ~ a ~ 0 CD .. CD N ro N cñ M~ ~ cñ~N~N~~r-N ~
.c
t:i
.c
t:i a: a: a: a: a: a:w w w w w W I- I- I- I- I- I- I- I- I- I- l-
I- I- I- I- I- I- Z Z Z Z Z Z Z Z Z Z Z
~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~
~ ~ ~ ~l ~ ~ ~ ~ ~ ~ 111111
I- I- I- I- I- I- I- I- I- I- I- I- ~ I- I- I- I-~ ~ ~ ~ ,~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~I- W;: uJ ~ a:ma:~~ lñ:; ~~wirc(!ž I- L5~~ g~~~5win ~ ..8~ ~O:ic(Zâa: Ol-O~- in~~~Oüw~ :JZ~5)- m I-w~I-- - row~ai~ a: a:ü':Ja:m5~ 'âzw~â~ OZ~~~ffo.~ ~~8a::J~fu 0.::~~c(~~W Z5o/8~ma: ~wüw~Ow~ c(0.)-c(m)-0 m~~~ i o:~~ zwi-ÖCf~- i ~ a: ~ ~ Õ c( w w ~ a: ~ a: ~ w 0 ro ~ c( ~I- a: Z ;: :i ~ ~ Z W :J )- I- Ô ~ 0 Z â ~om~c(a:ü (!~;:U:i~ m~c()- ~ 0 m w ~ ~ Z â c( ~ ü Ü ~ w 9 m c( æu. w ~ æ 0. :J W m ~ c( ~ c( Z mOi- ~ ~ ~i~a:w~g~~o:i~~~m~~~a:a:~I-ZOOI-Uc(i:iC(:J:Jc( ~
~~~~~~~~~g~~~~~~~;:
~ ~ ~ æ ~~ ~ ~ ~ ~ ~ ~ i ~ ~ ~ ~ ~
~~~8æ~~~M~~~~~~~~~~~~~~~~~~~~~~~~~~ :J :J :J :J :J ~ :J :J :J ~ :J :J :J :J :J :JüUUüUüüüUUüüüuuuu N
l
OM ~ ~~ 0 ~CD '" ~
MÑc6
:i ~ ~-.cög
ON ON~ "" 0'"" ..NrÓMÑ0.. ""0'.. M
MNCO-
o ~ f' N"" ~ 00' CD CD
c6å~-
¡g ~ ;:
"'M~CD '" 0
a N ~ 0..0'..
0'" ..~rÓ~M N CDo ~ ~ÑN-~
a a a 6~ 0 ~.. CD 0
cñ cö CD-"'.. ~o ~ N¿ÑrÓ~ ~ ~
a: a:w w I-
3~z
ir 3 ~
mI-mm ü00~~w w U 0~ ~ w 0:o 0 ~ 0.a: a: 0 ~~ a. c:-.a: a: a. c( ~ ~ ~ ~
Oc(ë5b0.~~1-
• REVISED ATTACHMENT K-1
WHOLESALE CUSTOMERS SHARE OF NET BOOK VALUE OF EXISTING ASSETS AS OF JUNE 30, 2009
• (Section 5.03)
Notes Water Hetch Hetchy Total
Regional System Net Plant as of 6/30/09 1, 5 $485,580,249 1 $63,528,861 2 $549,109,110 Regional Construction VVork in Progress as 6/30/09 2 $35,072,164 3 $7,507,984 3 $42,580,148 Total Net Plant and Construction Work in Progress $520,652,413 $71,036,845 $591,689,258 Regional System Allocation Factor 3 70.1% 64.2%
Wholesale Share of Regional System Net Plant $340,391,755 $40,785,529 $381,177,284 Wholesale Share of Construction Work inProgress 4 $11,025,550 $4,820,126 $15,845,676 Total Wholesale Share of Net Plant and CWIP $351,417,305 $45,605,655 $397,022,960 Interest Rate 5.13% 5.13%
Term (Yrs) 25 25
Monthly Principal & Interest $2,081,055 ' $270,072 $2,351,127 Annual Wholesale Revenue Requirement Amount $24,972,661 $3,240,861 $28,213,522 Notes
1. FAACS 120D Report as of 6/30/09
2. CWIP based on balance as 6/30/09, with adjustments from the Agreed-Upon Procedures Report. See K-2 for details.
3. Fixed allocation factors based on dollar weighted 5-year average of J-Table allocation factors (2003-04 through 2007-08) 4, Projects CUW127 SCADA, CUW687/934 525 Golden Gate, and CUW690 Customer Care and Billing are specially allocated, see K-2 for details
5. A rounding difference of $3,846 was identified by the SFPUC relating to various cumulative prior year differences in net utility plant.
Under Section 5.03D, the Parties agreed that the Wholesale Customers' share of net book values of existing regional assets as of 06/30/2008 are accurate. However, to match Attachment K to the FY08-09 Audited SRRC, the SFPUC will credit the 1984 Balancing Account for $79.
Original Rate Base, FY08-09 SRRC $19,367,641
Adjusted Rate Base $19,367,562
1984 Balancing Account Credit $79
APPROVED IN ACCORDANCE WITH ARTICLE V, SECTION 6.03D OF THE WATER SUPPLY AGREEMENT BETWEEN THE CITY & COUNTY OF SAN FRANCISCO & WHOLESALE CUSTOMERS:
CITY AND COUNTY OF SAN FRANCISCO
Acting by and through its Public Utilities Co mission
By:
Edward Harrington
General Manager
Date:
3 (4 ‚2011
BAY AREA WATER SUPPLY AND CONSERVATION AGENCY
Acting on behalf of the Wholesale Customers
By:
Date:
Arthur R. Jensen
General Manager
2011
•
Page lof 4
Revised Attachment K-1
REVISED ATTACHMENT K-2
WHOLESALE CUSTOMERS SHARE OF REVENUE FUNDED CAPITAL EXPENDITURES CONSTRUCTION WORK IN PROGRESSAS OF JUNE 30, 2009
(Sectloh 6.03)
(1) (2) (3)
Rate
Project No. Project Description Class
(4)
CWIP as of
6130/09 .
(4a)
Adjustments
(4b) (5)
Adjusted
CWIP as of WatecrwR jeplated
06/30/09
(6)
Wholesafe
• Share Funding Source / Notes
A. Water Enterprise
1. Regional Projects .
CUW111/112 Lower Crystal Springs Dam Joint
CUW127 SCADA Joint
52, 615
30,952
o
0 52,615
30,952
36,883 ACP196A
13,951 ACP/98A Split 64.3%/35.9%. Joint/City
CUW135 New Lines and Bypass Valves Joint 69,818 (6,018) • 63,800 44.724 98A .
CUW143 HH Water Treatment J'oint - 1167 (1,167) 0 0 ACP CUW168 Alameda liCP -EISIEIR
Standbi Power Facilifies CUW181 Joint
26,428
5,905
o
0 26,428
5,905
18,526 ACP
4,139 ACP
CUVV202 Replace PCCP .
Thomas Shaft Roadway CUW205 Joint
414,754
530,329
0,
a
414,754
530,329
290,743 ACP/96A/98A
371,761 96A1988
CUW208 Lawrence -Livermore . City o ' o 0 0 ACP
CUW220 Calaveras Dam Evaluation Joint 308,971 0 308,971 216,588 ACP CUW227 Watershed Facilitiesind Fencing Joint
CUW228 Watershed Roads Joint
CUW231 Millbrae Labs Improvement Joint
235,658
443,771
58,081
0 0
0 235 ,658
443,771
58,081
165,19à ACP
311,083 ACP
40,715 ACP198B
CUW236 Tesla/SJVH WO Monitoring Joint 5,596 (6,596) 0 0 98B CUW242 Demolltion of Unsafe Structures *Joint 2534 a 2534 P CUW248 SunoUNiles Dam Removal Joint 81 ,111 0 81111 , 561,879 ACP CUW253 WQ Projects Joint 72,144 0 72,144 50,573 ACP
' CUW261 Regional R&R - Storage Joint 706,584 0 706 684 , 495,386 ACP CUW262 Reglonal R&R - Treatment
CUW263 Reglonal R&R - Transmission
Joint
Joint
CUW264 Watershed Roads • Joint
575 ,064
1,433,996 •
198,163
0 0
0 575 , oe4
1,433,993
298 163 ,
403,120 ACP
1,005,231 ACP,
138,912 ACP
CUW354 Lower Clystai Springs Dam
• CUW355 Standby Power Facilities
Joint
Joint •
857,235
37, 875
0 a
857,235
37, 875
600,922 ACP
26,550 ACP
CUW356 New Crystal Springs Bypass Tunnel Joint 3,671,856 0 3,671,856 2573,971 96A/98A 0UW359/0UW12- lrvington Tunnel Joint 2,095,122 0 2,095,122 1,468,681 ACP CUW388 BDPL Hydrautic Capacity Joint 1,612,592 0 1,812,592 1,130,427 ACP CUW371 CSPS and Pipeline Joint
CUW374 Calaveras Dam Joint
CUW382 SVWTP Treated Water Resevoir Joint .
2 52441 : 661980
3Z153
0 0
0 221,690
644,618
32,153
155,404 ACP
381,777 ACP
22,539 ACP
C11W384/C0W23i Tesla Disinfection ' Joint • 230,019 0 230,019 T 161,244 ACP CUW387 CSPL #2 . Joint 1,195,062 0 1,195,062 837,739 96A/28B • CUW392 Program Management
. Special 979,694 (979,694) 0 0 Special
CUW685 Emergency Operations Center Joint . 185 . 0 185 129 ACP CUW687I934 625 Golden Gate Joint . 15,797,879 0 1e97,679 0 will be paid for as iease in lieu of rent ,CUW690 Customer Care & Billing • Special 3,536,118 0 3,535,118 0 Note A W710 OCIP CU Special 2496,959 (2,496,959) 0
.
0 SpeCial
TOTAL REGIONAL PROJECTS 38,561,597 (3,489,434) ..... 35,072,164 eleeee 11,025,560
2. Wholesale Direct
None
B. Hetch Hetchy Water & Power
CUH703, . Priest Reservoir Bypass Joint 574 0 574 268 166 ACP CUI-1762 SJPL Repaira . Water 66,609 a 66,609 66,609 42,763 ACP CUH766 HH Security Improvements Joint 284,456 0 284,456 128,005 82,179 ACP CUI-1804 HH Roads Joint 567,503 0 .567,503 255,376 163,952 ACP CUH846 New Moccasin Penstock Power 543,074 0 543,074 0 0 ACP CUH931 Microwave Replacement Joint 4,156,642 D 4,156,642 1,870,489 1,200,854 ACP CUH941 HH SCADA Security & Control Joint 702,709 0 702,709 316,219 203,013 ACP CUH950 Penstock Renovation Power 561,636 0 561,536 0 0 ACP C1JI-1957 Moccasin Corrision Control Water 314,805 0 314,805 314,805 202,105 ACP CUH959 Moccasin Reservoir Water Quality Water 109,379 0 109,379 109,379 70,221 ACP CUI-1964 Watershed Land Purchase
Water 47,768 0 47,768 47,768 30,667 ACP
CUH976 HH Water R&R - Joint Facilities Joint 2,495,322 0 2,495,322 1,122,895 720,898 ACP CUH975 Fili Water R&R - Kirkwood Penstock Assessment Power 460,170 0 460,170 b 0 ACP OUH975 HH Water R&R - SJPL Rehabilitation/RR Lime Slaker Water 2,330,076 0 2,330,076 2,330,076 1,495,909 ACP CUH977 Facilities Maintenance - Water Joint 2,076,186 0 2,076,186 934,284 599,810 ACP CUI1998 Camp Mather Leach Field Joint 26,270 0 26,270 11,822 7,569 ACP TOTAL HETCH HETCHY WATER & POWER 14,743,078 0 14,743,078 7,507,984 4,820,126 TOTAL COMBINED WATER AND HHWP 53,304,675 (3,489,434) 49,815,242 7,507,984 15,845,676 !Vote A: CUW690 Qustomer Care & Billinq
This project will be specially allocated. SFPUC will refiect $70,702,36 ($3,535,117.97 x 2%) as an adjustment ta the Balancing Account in favor of the Retail customers.
Revised Attachment K-2
REVISED ATTACHMENT K-3
(Section 5.03)
ANNUAL PAYMENTS FOR WHOLESALE SHARE OF 6/30/09 NET PLANT & CWIP (WATER ASSETS)
Revised for February 2013 Prepayment
6/30/09 Wholesale Share of Net Plant & CW1P: 351,417,305 Interest Rate: 5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13: 2,081,055 Annual Wholesale Revenue Requirement through 6/30/13: 24,972,661 Fiscal Yr
Ending Principal Interest Total
Prepay-
ment End Bal (6/30)
Jun-10 7,110,596 17,862,065 24,972,661 344,306,709
Jun-11 7,484,069 17,488,591 24,972,661 336,822,640
Jun-12 7,877,159 17,095,502 24,972,661 328,945,481
Jun-13 13,715,985 11,256,676 24,972,661 315,229,496 0
Jun-14
Jun-15
Jun-16
Jun-17
Jun-18
Jun-19
Jun-20
Jun-21
Jun-22
Jun-23
Jun-24
Jun-25
Jun-26
Jun-27
Jun-28
Jun-29
Jun-30
Jun-31
Jun-32
Jun-33
Jun-34
36,187,809 63,702,834 99,890,643 315,229,496
Note: The monthly supporting calculation for fiscal year 2012-13 is attached.
Revised Attachment K-3
Monthly Calculations for Updated 1(-3 Schedule for FY 2012-13 Based on February 2013 Prepayment
(Water)
6/30/12 Unpaid Balance
Interest Rate:
Origina!Term:
Monthly Principal & Interest Calculation through 6/30/13 Anl')ual Wholesale Revenue Requirement through 6/30/13:
Prepayment Date
Month Beginning
Ending Mo. Pmt Balance Principal (ll
6/30/12 n/a n/a
7/30/12 2,081,055 328,945,481 674,813
8/30/12 2,081,055 328,270,667 677,698
9/30/12 2,081,055 327,592,970 680,595
10/30/12 2,081,055 326,912,374 683,505
11/30/12 2,081,055 326,228,870 686,427
12/30/12 2,081,055 325,542,443 689,361
1/30/13 2,081,055 324,853,082 692,308
2/28/13 2,081,055 324,160,774 695,268
3/30/13 2,081,055 8,236,010 2,045,846
4/30/13 2,081,055 6,190,164 2,054,592
5/30/13 2,081,055 4,135,572 2,063,375
6/30/13 2,081,055 2,072,19� 2,072,196
Total (Rev K-3): 13,715,985
Current K-3 1�1: 8,290,896
Additlonal Principal Amortized: 5,425,089
Interest (ll
n/a
1,406,242
1,403,357
1,400,460
1,397,550
1,394,628
1,391,694
1,388,747
1,385,787
35,209
26,463
17,680
8,859
11,256,676
16,681,765
Total
n/a
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
24,972,661 I
24,972,661
{1) Starting in March, the Prepayment is applied to the monthly Interest calculations and monthly p_ri.ncipal is calculated to maintain monthly principal and Interest $2,081,055 and the annual WRR amount at $24,972,661 resulting in no impact to the 6/30/13 balancing account compared to no prepayment being made. {2) K-3 principal and Interest for FY 12-13 on K-3 before prepayment.
Provided for reference only.
Revised Attachment K-3
328,945,481
5.13%
25 2,081,055
24,972,66_1
2/27/13
Ending Prepay-
Balance ment
328,945,481
328,270,667
327,592,970
326,912,374
326,228,870
325,542,443
324,853,082
324,160,774
323,465,506 315,229,496 Ill
6,190,164
4,135,572
2,072,196
0 315,229,496
ATTACHMENT l(-4
(Section 5.03)
ANNUAL PAYMENTS FOR WHOLESALE SHARE OF 6/30/09 NET PLANT & CWIP (HETCH HETCHY ASSETS)
Revised for February 2013 Prepayment
6/30/09 Wholesale Share of Net Plant & CWIP: 45,605,655 Interest Rate: 5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13: 270,072 Annual Wholesale Revenue Requirement through 6/30/13: 3,240,861.
Fiscal Yr
Ending Principal Interest Total
Prepay-
ment End Bal (6/30)
Jun-10 922,787 2,318,074 3,240,861 44,682,868
Jun-11 971,255 2,269,606 3,240,861 43,711,612
Jun-12 1,022,269 2,218,592 3,240,861 42,689,343
Jun-13 1,780,010 1,460,850 3,240,861 40,909,333
Jun-14
Jun-15
Jun-16
Jun-17
Jun-18
Jun-19
'Jun-20
Jun-21
Jun-22
Jun-23
Jun-24.
Jun-25
Jun-26
Jun-27
Jun-28
Jun-29
Jun-30
Jun-31
Jun-32
Jun-33
Jun-34
4,696,322 8,267,121 12,963,443 40,909,333
Note: The monthly supporting calculation for fiscal year 2012-13 is attached.
Revised Attachment K-4
REVISED
Monthly Calculations for Updated K Schedules for FY 2012-13 Based on February 2013 Prepayment
(Hetch Hetchy)
6/30/12 Unpaid Balance
Interest Rate:
42,689,343
5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13 270,072 Annual Wholesale Revenue Requirement through 6/30/13: 3,240,861 Est. Prepayment Date 2/27/13
Month Beginning Ending Prepay-
Ending Mo. Pmt Balance Principal (1) Interest (1) Total Balance ment 6/30/12 n/a n/a n/a n/a 42,689,343
7/30/12 270,072 42,689,343 87,575 182,497 270,072 42,601,769 8/30/12 270,072 42,601,769 87,949 182,123 270,072 42,513,820 9/30/12 270,072 42,513,820 88,325 181,747 270,072 42,425,494 10/30/12 270,072 42,425,494 88,703 181,369 270,072 42,336,792 11/30/12 270,072 42,336,792 89,082 180,990 270,072 42,247,710 12/30/12 270,072 42,247,710 89,463 180,609 270,072 42,158,247 1/30/13 270,072 42,158,247 89,845 180,227 270,072 42,068,402 2/28/13 270,072 42,068,402 90,229 179,842 270,072 41,978,172 40,909,333 3/30/13 270,072 1,068,839 265,502 4,569 270,072 803,337 4/30/13 270,072 803,337 266,637 3,434 270,072 536,699
5/30/13 270,072 536,699 267,777 2,294 270,072 268,922
6/30/13 270,072 268,922 268,922 1,150 270,072 0
Total (Rev K-4): 1,780,010 1,460,850 3,240,861 40,909,333 Current K-4(2): 1,075,962 2,164,899 3,240,861
Additional Principal Amortized (K-4): 704,048 Combined
Plus Additional K-3 Principal: 5,425,089 Prepayment
Combined Additional Principal: 6,129,137 356,138,829
(1) Starting In March, the Prepayment is applied to the monthly interest calculations and monthly principal is calculated to maintain monthly principal and interest $270,072 and
the annual WRR amount at $3,240,861, resulting in no impact to the 6/30/13 balancing account compared to np prepayment being made. (2) K-4 principal and interest for FY 12-13 on K-4 before prepayment.
Revised Attachment K-4
(
ATTACHMENT K-5
10 YEAR PAYOFF SCHEDULES FOR EXISTING RATE BASE
WATER ENTERPRISE UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS
CONSTRUCTION WORK IN PROGRESS (CWIP)
AS OF JUNE 30, 2009
(Section 5.03C)
Difference Difference
(Increase) from (Increase) from
Revised Audited Audited Original Original
6/30/09 Wholesale Share of Unexpended Appropriations of CWIP $ 6,618,478 $ 6,618,021 $ 457 $ 6,613,084 $ 5,394 Interest Rate: 4.00%
Term: 10
Monthly Principal & Interest Calculation: $67,009
Annual Wholesale Revenue Requirement: $804,106 $804,051 $ 55 $803,451 $655 Fiscal Yr Ending Principal Interest Annual Payment Year End Balance Jun-15 $549,366 $254,740 $804,106 $6,069,112
Jun-16 $571,748 $232,358 $804,106 $5,497,363
Jun-17 $595,042 $209,064 $804,106 $4,902,321
Jun-18 $619,285 $184,821 $804,106 $4,283,035
Jul-19 $644,516 $159,590 $804,106 $3,638,519
Jun-20 $670,775 $133,332 $804,106 $2,967,745
Jun-21 $698,103 $106,004 $804,106 $2,269,642
Jun-22 $726,545 $77,562 $804,106 $1,543,097
Jul-23 $756,145 $47,961 $804,106 $786,952
Jun-24 $786,952 $17,155 $804,106 $0
Totals: $6,618,478 $1,422,587 $8,041,065
K-5 (WTR) as of 6-30-15
REVISED
Revised Attachment K-5
ATTACHMENT K-5
10 YEAR PAYOFF SCHEDULES FOR EXISTING RATE BASE
HETCH HETCHY ENTERPRISE UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS
CONSTRUCTION WORK IN PROGRESS (CWIP)
AS OF JUNE 30, 2009
(Section 5.03C)
Revised Audited
Difference
Original
Difference
(Increase) from Increase
Audited from Original
6/30/09 Wholesale Share of Unexpended Appropriations of CWIP 2,923,204 $ 2,914,484 $ 8,720 $ 2,912,877 $ 10,326 Interest Rate: 4.00%
Term: 10
Monthly Principal & Interest Calculation: $29,596
Annual Wholesale Revenue Requirement: $355,152 $354,093 $ 1,059 $353,898 $1,254 Fiscal Yr Ending Principal Interest Total End. Balance Principal Interest Annual Payment Year End Balance Jun-15 $20,592 $9,004 $29,596 $2,680,563 $242,640 $112,512 $355,152 $2,680,563 Jun-16 $21,431 $8,165 $29,596 $2,428,037 $252,526 $102,626 $355,152 $2,428,037 Jun-17 $22,304 $7,292 $29,596 $2,165,223 $262,814 $92,338 $355,152 $2,165,223 Jun-18 $23,213 $6,383 $29,596 $1,891,701 $273,522 $81,631 $355,152 $1,891,701 Jul-19 $24,159 $5,437 $29,596 $1,607,036 $284,665 $70,487 $355,152 $1,607,036 Jun-20 $25,143 $4,453 $29,596 $1,310,773 $296,263 $58,889 $355,152 $1,310,773 Jun-21 $26,167 $3,429 $29,596 $1,002,440 $308,333 $46,819 $355,152 $1,002,440 Jun-22 $27,233 $2,363 $29,596 $681,544 $320,895 $34,257 $355,152 $681,544 Jul-23 $28,343 $1,253 $29,596 $347,575 $333,969 $21,183 $355,152 $347,575 Jun-24 $29,498 $98 $29,596 ($0) $347,575 $7,577 $355,152 ($0) Totals: $2,923,204 $628,318 $3,551,522 $2,923,204 $628,318 $3,551,522 K-5 (HHP) as of 6-30-15
REVISED
Revised Attachment K-5
Review of Unexpended Balances of Appropriated Funds (Not Included in CWI P as of 6/30/2009) Construction Work in Progress As of June 30, 2009
(Section 5.03.CI
(A) (8) (C) (D) = (A) -(8)-(C)
Appropriiltion YTD Expenditures PTD Expenditures Encumbrilnces Avililiible Billilnce (E) =(El) + (E2) +
r--�(E�1)�---�(E_2)�---�(E_3�)
---�(E_4�)
---
�(E_5�) ____ (�E6�)
---, (E3)+(E4)+(E5) + (E6)
Expenditures in
Project
Wiiter Assets:
CliissifiCiltion As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 L.....FY.2_009 __ -_10 ...... _ ... FY_2_0_1_0-_1 ... 1 _ ...... FY ... 2_0_1_1-_1_2_..._ I .. FY ..... 20_1_2-.. 1 .. 3_..._ 1..,FY...,.20.1 .. 3-.. 1 .. 4 _ _._.. IYT.,D...,rv.,2.0 .. 1,..4-.1__,5 T otil Expenditures Addition to K-5 CUWlll
Addition to K-5 CUW112
Addition to K-5 CUW118
K-5 CUW135
K-S CUW143
K-5 CUW148
K-5
K-5
K-5
K-5
K-5
K-S
K-5
K-5
K-5
K-5
K-5
K-5
K-5
K-S
K-5
K-5
K-5
K-5
K-5
CUW161
CUW168
CUW202
CUW210
CUW227
CUW228
CUW231
CUW241
CUW242
CUW2SO
CUW253
CUW2S7
CUW261
CUW262
CUW263
CUW264
CUW127
CUW392
CUW710
CRYSTAL SP RES OP PLAN'
CRYSTAL SPRINGS P/L NO 1-PHASE 21
MILLBRAE SHOP-PHASE 2-B'
NEW LINE & BYPASS VALVES'
HETCH HETCHY WATER TREATMENT PLAN'·
10 ENVIRONMENTAL & REGULATORY COMP1
TREATMENT FACILITIES IMPROVEMENTS'
ALAMEDA CREEK FISH RELEASE
SAN ANTONIO PIPELINE EMERGENCY REPAIR
MILLBRAE ADMIN BLDG INTERIM REMODEL'
WATERSHED FENCES/FACILITIES '
WATERSHED ROADS RECONSTRUCTION'
MILLBRAE LAB CAPITAL IMPROVEMENTS'
FACILITIES MAINT SUPPORT STRUCTURES'
DEMOLITION UNSAFE STRUCTURES'
WATERSHED TRAILS & RECREATION IMPROv'
FACILITIES SECURITY PROJECT'''
WATER PROTECTION'·'
REGIONAL WATER STORAGE RNR - BUDGET1''
TREATMENT FACS/WQ IMPROVE - BUDGET'
CONVEYANCE/TRANSMISSION - BUDGET'
WATERSHED ROADS - BUDGET'
INST SCADA SYSTEM
7 ' 1
PROGRAM MANAGEMENT SERVICES - WSIF�'·'·"
OCIP PROJECT CONTROL
2 '1
CUH977-03 HH MATHER FACILITIES
TOTAL ALL PROJECTS PER K-5
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
ST
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
AAAACP REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP Local $
l,OSS,054 $
2,422,523 $
11,263,269 $
4,829,680 $
18,821,529 $
3,241,279 $
15,028,319 $
1,S37,398 $
1,400,000 $
2,407,700 $
3,000,000 $
5,170,000 $
770,000 $
S,000,000 $
1,000,000 $
387,639 $
S,300,000 $
1,448,720 $
1,7SO,OOO $
4,801,000 $
7,82S,OOO $
3,000,000 $
13,1S6,681 $
1,000,000 $
2,497,881 $
73,000 $
118,18 9,672 $
$
207 $
3,998 $
2,103 $
164,267 $
990 $
334 $
100,642 $
(339,46S) $
284,902 $
S30,822 $
85,843 $
40,678 $
8,390 $
24,867 $
9,431 $
234,328 $
113,871 $
430,990 $
896,697 $
1,404,SOl $
202,638 $
6,221,108 $
(92,112) $
235,706 $
13,327 $
1 0,57 9,063 $
1,023,222 $
1,37S,634 $
11,014,662 $
4,689,067 $
18,616,320 $
3,0lS,985 $
14,747,873 $
1,094,937 $
923,712 $
l,93S,204 $
2,548,376 $
4,415,913 $
S53,694 $
4,988,882 $
410,040 $
112,689 $
4,308,224 $
497,747 $
706,684 $
3,201,827 $
4,019,441 $
1,517,064 $
12,393,475 $
7S8,065 $
2,496,959 $
SS,989 $
1 01,421,685 $
$
$
$
$
47,947 $
$
$
125,057 $
16,032 $
160 $
494,574 $
2,742 $
$
$
21,524 $
11,233 $
142,789 $
481,704 $
283,219 $
293,371 $
381,217 $
14S,665 $
$
33,289 $
$
$
2,48 0,523 $
34,832 $
1,046,889 $
248,607 $
140,613 $
157,262 $
225,294 $
280,446 $
317,404 $
460,2S6 $
472,336 $
(42,9SO) $
751,34S $
216,306 $
11,118 $
568,436 $
263,717 $
848,987 $
$
1,327 $
$
23,027 $
36,572 $
$
580 $
11,523 $
5,936 $
$
221,71S $
$
42,703 $
1,74S $
$
4,558 $
142,346 $
469,269
760,097
1,305,802
3,424,342
1,337,271
$ 3S7,690 $
763,206
208,646
922
17,011
14,287,464
$ 1,043,316 $
$ 622,441 $
$ 2,062,S74 $
$ 687,176 $
$ $
$ $
$ $
$ 17,011 $
$ 5,282,24 0 $
$
99 $
$
1,4S3 $
7,125 $
$
45,176 $
67,487 $
5,366 $
$
38,212 $
$
54,851 $
$
$
$
100,S91 $
S93,283 $
$
473,078 $
749,747 $
473,915 $
$
2 $
$
$
2,610,385 $
$
$
$
$
$
$
$
31,045 $
748,839
$
$
$
$
$
$
$
$
$
$
33,103 $
217,706 $
69,916 $
$
$
$
$
1,100,609 $
2,233
24,981
1,642
17,763
46,61 9 $
(6,684)
$
$
$
446,362 $
118,158 $
$
$
$
$
557,836 $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,753 $
$
$
$
$
1,753 $
$
1,426 $
$
24,480 $
43,697 $
$
45,756 $
105,604 $
11,302 $
$
259,927 $
$
97,554 $
1,745 $
$
4,558 $
991,776 $
950,973 $
1,043,316 $
1,153,603 $
3,478,031 $
1,368,681 $
$
$
$
17,011 $
9,599,442 $
(F) = (C) + (D) -(E) (GI (H)
Appropriiltion
Transfer Out
through Ooseout
(I)
DEOBLIGATE /
Encumbrances Process OBLIGATION
Unused Balance As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 34,832 $
1,045,463 $
248,607 $
116,133 $
161,512 $
225,294 $
234,690 $
336,857 $
464,986 $
472,496 $
191,697 $
754,087 $
118,752 $
9,373 $
589,960 $
270,392 $
$
$
$
445,570 $
327,528 $
114,255 $
763,206 $
241,933 $
922 $
$
7,168,545 $
$
$
$
$
$
$
$
7,068 $
$
$
$
$
$
$
$
$
$
$
$
$
327,528 $
$
$
$
$
$
334,596 $
34,832 $
1,045,463 $
248,607 $
116,133 $
161,512 $
225,294 $
234,690 $
329,789 $
464,986 $
472,496 $
191,697 $
754,087 $
118,752 $
9,373 $
589,960 $
270,392 $
$
$
$
$
$
$
763,206 $
241,933 $
922 $
6,274,124 $
VI= {A) -(8) -(E) -(G)
(H)-(11
Unexpended
Balilnces of
Appropriation after
Closeout and
Deobligate
As of June 3 0, 2015
445,570
114,255
559,825
LOCAL PROJECTS LOCAL $ 73,000 $ 13,327 $ 55,989 $ $ 17,011 $ 17,011 $ $ $ $ $ $ 17,011 $ $ $ $ $ Addition to K-5 CUW690
JOINT LOCAL AND REGIONAL PROJECTS
REGIONAL PROJECTS
TOTAL ALL PROJECTS PER K-5
Proportionill Water Use per J-Tiible
Wholesille Share before Customer lnformiltion System
CUSTOMER INFORMATION SYSTEM' SW
(AA)
(BB )
LOCAL/REGIONAL $ 16,654,562 $ 6,364,702 $ 15,648,499 $ 33,289 $ 972,774 $ $ 2 $ $ $ $ $ $ 1,006,061 $ $ 1,006,061 $ $ REGIONAL $ 101,462,110 $ 4,201,034 $ 85,717,197 $ 2,447,234 $ 13,297,679 $ 5,265,229 $ 2,610,383 $ 1,100,609 $ 46,619 $ 557,836 $ 1,753 $ 9,582,429 $ 6,162,484 $ 334,596 $ 5,268,063 $ $ 559,825 -$,--711"'8"',1"'89"',--=6"'72,-T$--""10"',5"'79"""',06"'3,-T$--,1-,-01"",4"'2"'1"",6"'85=-""'s---2=-,""43"'0"',s"'2"'3-,$,----=1 74,"'2s"'7"",464=--,s,---= 5--=,27s2=-,724,-,oc-$,---= 2--=,6"'1"'0,"'3ss=--s,---=1"',1"'00"' ,--=609=----,,-s----, 46"',--=6"'19,-T$--,5"'5,:7--:,8-=-36=-Ts----,-1,-=75:,3,-$,----,9,-,5:,99,.,-,,44,-,2=-""'s---=7,""1"'68,.,,54=5---,$,-----=3734,-,5:,9"'6-,-,$,-- -,6--=,z-=747,"'12,.,4C-$,-------$,-----:5-:,59,-,s:,2"'5 ,-
66.67% 65.86% 65.83% 66.56% 67.63% 65.67%
(Cll = (AA) x (BB) $ 3,510,328 $ 1,719,198 $ 724,531 $ 31,030 $ 377,264 $ 1,151 $ 6,363,503 AAAACP LOCAL/REGIONAL $ 8,856,574 $ 3,786,403 $ 5,757,389 $ 1,384,017 $ 62,794 $ 51,242 $ 11,552 $ - $ Water Regional share (49.7% of Customer Information System up to FY 2013 and 51.2% for FY 2014) 1,715,168 $ 2,400,419 $
$ 1,193,008 $
47,133 $
23,425 $
523,304 $
260,082 $
40,839 $
20,297 $
24,696 $
12,644 $
3,036,391 $
1,509,457
Wholesille share {2% from Water Regional share} (C2)
Wholesale Share after Customer Information System
Pooled Interest Rate in FY 2010-11
Pooled Interest Rate in FY 2011-12
Pooled Interest Rate in FY 2012-13
Pooled Interest Rate in FY 2013-14
Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015} Interest Amount in FY 2010-11
Interest Amount in FY 2011-12
Interest Amount in FY 2012-13
Interest Amount in FY 2013-14
Estimated lntere5t Amount in FY 2014-15 (as of March 31., 2015} Balance due from Wholesale Customers
CC=(Cl+C2)
(DDl)
(DD2)
(DD3)
(DD4)
(DDS)
(EEl) = (CC) x (DDl}
(EE2) = (CC) x (DD2)
(EE3) = (CC) x (DD3)
(EE4) = (CC) x (DD4}
(EES) = (CC) x (DDS)
(FF)= (CC)+ (EEl) + (EE2) + (EE3} + (EE4) + (EE5)
$ 23,860 $ 469 $
$ 3,534,188 $ 1,719,667 $
1.24%
1.11% 1.11%
0.85% 0.85%
0.663% 0.663%
0.499% 0.499%
5,202 $
729,733
0.85%
0.663%
0.499%
406 $ 253 $ $
31,436 $ 377,517 $ 1,151 $
0.663%
0.499% 0.499% 0.499%
_$-_43_,,'-82_4---,-$ ____ $ ____ -,$ ____ .;-$ ___ ---'$�---$ _$'--_3�9
.:..;;
,22.;;.9;..._$'--_1;;.;;9.:.;;, 0.;;.88;..._$'------$'------$'------$'------ $ $ 3 0,041 $ 14,617 $ 6,2 03 $ $ $ $
-$',---2�3,�43 -2 -�$--1-1,�4 -01- .,..$---4�,838-�$---2 -08- -,-$-------,$-----$ $ 17,636 $ 8,581 $ 3,641 $ 157 $ 1,884 $ 6 $
$ 3,688,350 $ 1,773,355 $ 744,415 $ 31,801 $ 379,401 $ 1,157 $ 3 0,189
6,393,692
43,824
58,318
50,860
39,880
31,905
6,618,478
REVISED ATTACHMENT K-5
K-5
K-5
K-5
Ad dition to K-5
K-5
Addition to K-5
K-5
K-5
Addition to K-5
Project Project Title
Hetch Hetchy Assets:
CUH703 PRIEST RESERVOIR DIVERSION CHANNEL
CUH762
CUH926
CUH945
CUH957
CUH959
CUH964
SAN JOAQUIN PIPELINE REPAIRS
PIPELINE PURCHASE REPLACEMENT PIPE'
SJ PIPELINE #4 ADDITION; CROSSOVER;TSTAJ'
FAC MAINTENANCE -WATER TRANSPORTATION
MOCCASIN RESV WATER QUALllY
WATERSHED PROPERlY PURCHASES
CUH975-02 REDUNDANT POWER SUPPLIES
CUH975-03 RESERVIOR-DAM ASSESSMENT/IMPROVEMENTS
CUH975-04 FOOTHILL TUNNELIMPROVEMENTS
CUH97S-05 MOCCASIN SEWAGE DISPOSAL IMPROVEMENTS
CUH97S-06 DAM DEFLECTION REHABILITATION
CUH97S-07 MOUNTAIN TUNNEL ADIT DOOR UPGRADE
CUH975-08 OS DRUM GATE ASSESSMENT
CUH975-09 RESERVIOR
VALVES REHABILITATION
CUH975-10 MOUNTAIN TUNNEL REHAB
CUH975-11 TRASH RACKS MOCCASSIN GATE
CUH975-13 0 SHAUGHNESSY NEEDLE VALVES
CUH975-14 PENSTOCK ASSESSMENT/IMPROVEMENTS
CUH975-15 SJPL REHABILITATION
CUH975-16 TUNNEL CONDITION ASSESSMENT/IMPROVEMENT
CUH975-17 ROCK RIVER SLAKER
CUH975-18 MOCCASIN AFTERBAY REHAB
CUH975-19 LEITHOLD SERVICE LINE
CUH975
CUH383
K-5 CUH766
Ad dition to K-5 CUH774
WATER INFRASTRUCTURE - BUDGET'· 10· 11
O'SHAUGENESSY WATER SYSTEM RENOVATION'
HETCHY FACILITIES SECURllY IMPROV.'
OLD MOCCASIN POWERHOUSE REHAB.'
HETCH-HETCHY ROADS REBUILDING' K-5 CUHB04
K-5 CUH810 VARIOUS OLD JOB
1 '�
5' 14
Addition to K-5 CUH846 MOCCASIN PENSTOCK REPLACEMENT'
MOCCASIN PHONE SYSTEM
O'SHAUGENESSY DIS. REPAIRS
K-5 CUH876
K-5 CUH878
Ad dition to K-5
Ad dition to K-5
K-5
K-5
K-5
K-5
Ad dition to K-5
CUH899
CUH923
CUH931
CUH941
CUH946
CUH949
CUH950
STUDY/DESIGN REPL CANYON TUNNEL/PENSTOCJ<'
HH DOMESTIC WATER SYSTEM'
HH MICROWAVE REPLACEMENT
HH SCAD SECURllY & CONTROL, EAST
FAC MAINTENANCE - SUPPORT STRUCTURE'
RIGHT OF WAY MAINTENANCE'
PEN STOCK RENOVATIONS
CUH977-01 FACILITIES - SUPPORT STRUCTURES
CUH977-02 ROOR REPLACEMENT ENGINEERING BLDG
CUH977-04 FIBER/COMMUNICATION SYSTEM UPGRADES
CUH977-0S HETCHY HETCHY ROADS & RIGHT OF WAY
CUH977-07 REPAVE HETCHY ROADS-TESLA TO OSH
CUH977-08 HETCHY HVAC UNITS
CUH977-09 SCADNHMI SYSTEM REPLACEMENT
CUH977-10 FIRE SUPPRESSION SYSTEM - OPS BUILDING
CUH977-11 HETCHY ELECTRICAL UPGRADES
CUH977-12 WARNERVILLE BIO-DIESEL TANK
CUH977-13 REPLACEMENT SCADA MASTER
CUH977-15 O'SH COT 1 ROOF/ADA IMPROVEMENTS
CUH977-17 BIO DIESEL TANK/FACILITIES REPAIRS
CUH977-18 REPLACE WOOD WATER TANKS
CUH977-19 EMERGENCY BACK UP POWER MOCCASIN
CUH977-20 ENGINEERING OFFICE HVAC
CUH977-21 HHP SECURllY UPGRADES
CUH977-22 REPAIR MOCCASIN COTTAGES
CUH977-23 Oil CONTAINMENT PROJECT
CUH977-24 HHWP SMALL WATER SYSTEM IMPROVEMENTS
CUH977-25 WEST PORTAL TANK PIPING IMPROVEMENTS
CUH977-26 PERMIT HHWP ROW MAINTENANCE
K-5 CUH977
Ad dition to K-5 CUW269
FACILITIES MAINTENANCE - BUDGET' 10'"
FIBER STUDv'
TOTAL ALL PROJECTS PER K-5
POWER PROJECTS
WATER PROJECTS
JOINT PROJECTS
TOTAL ALL PROJECTS PER K-5
Proportional Water Use per J-Table
Wholesale Share (100% of WATER and 45%of JOINT)
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
ClassifiCiltion
Power
WATER
WATER
WATER
WATER
WATER
WATER
JOINT
JOINT
WATER
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
WATER
JOINT
Power
WATER
JOINT
WATER
Power
JOINT
PROJECT TOTAL
JOINT
JOINT
JOINT
JOINT
Power
Power
JOINT
JOINT
Power
JOINT
JOINT
JOINT
JOINT
JOINT
Power
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
POWER
JOINT
JOINT
JOINT
(E) = (El) + (£2) +
(A)
(B) (C) (D) = (A) -(8)-(C) --�(E�1)�---�(E_2)�---�(E_3�) ---�(E_4�) ---�(E_5�) ____ (�E6-J_� (E3)+(E4)+(ES) + (E6) Appropriation YTD Expenditures PTO Expenditures Encumbrances Available Balance Expenditures in (FJ = (C) + (D) -(E) (G)
Encumbrances
(H)
Appropriation
Transfer Out
through Closeout
Process
(I)
DEOBLIGATf/
OBLIGATION
(J) =(A)· (B)-(E)-(G)
(H)-(1)
Unexpended
Balances of
Appropriation after
Closeout and
Deobligate
As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 L=FY=2=009-=,:;10:r,_ _,:,.FY;,;2:,;0=1;;;0-;:,1:,,1 _ _..,:,,FY,:,.2;;;0=1,:,1-;:,1,;;,2 _.1._l 1,,FY,:,,:,:20�1;:,2-;,:13;;;,_.1_l 1,,FY,:,,:,:20�1�3-;,:1;;;4 _-1...: IYT=D==FY=2=0=J.4..===1:..15 Tot.I Expenditures Unused Balonce As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
21,210,344 $ 58,645 $ 20,178,474 $ 12,715 $ 1,019,155 $ 11,677 $ 668,169 $ 345,705 $ $ $ 1,025,551 $ 6,319 $ $ 6,320 $ $ 41,469,206 $ 376,954 $ 41,337,704 $ 22,570 $ 108,932 $ 95,946 $ 5,657 $ (4,335) $ 26,504 $ $ 123,772 $ 7,730 $ $ 159,860 $ 13,667 $ 157,489 $ $ 2,371 $ $ $ $ $ $ $ 2,371 $ 2,371 $ 500,000 $ $ 440,711 $ $ 59,289 $ $ $ $ $ $ $ 59,289 $ 59,289 $ 3,400,000 $ 122,418 $ 2,896,826 $ 209,138 $ 294,036 $ 201,606 $ 154,592 $ 107,781 $ (28,813) $ $ 435,166 $ 68,008 $ $ 68,008 $ 150,000 $ $ 109,379 $ $ 40,621 $ 11,955 $ $ $ $ $ 11,955 $ 28,666 $ $ 28,666 $ 800,000 $ 130,035 $ 509,035 $ 1,388 $ 289,577 $ 35,024 $ $ $ $ $ 35,024 $ 255,941 $ 255,941 $ $ 100,000 $ 8,549 $ 8,549 $ 2,120 $ 89,331 $ 323 $ 35,375 $ 50,539 $ $ $ 86,237 $ 5,214 $ $ 5,214 $ 300,000 $ 179,633 $ 179,633 $ $ 120,367 $ 36,725 $ 83,642 $ $ $ $ 120,367 $ $ $ 315,500 $ 418 $ 190,257 $ $ 125,243 $ $ $ $ $ $ $ 125,243 $ $ 125,243 $ 691,500 $ 197,110 $ 388,174 $ 9,159 $ 294,167 $ 23,389 $ 274,666 $ (15,812) $ 416 $ 282,659 $ 20,667 $ $ 20,667 $ 110,000 $ 54,847 $ 137,259 $ $ (27,259) $ (27,259) $ $ $ $ $ (27,259) $ $ $ 643,000 $ 447,483 $ 450,726 $ 1,323 $ 190,951 $ 155,893 $ 31,392 $ $ $ 187,285 $ 4,989 $ $ 4,989 $ 115,000 $ 3,094 $ 96,931 $ 20,048 $ (1,979) $ 13,854 $ 4,215 $ $ $ $ 18,069 $ $ $ 500,000 $ $ 239,922 $ $ 260,078 $ $ 445 $ $ $ $ 445 $ 259,633 $ $ 259,633 $ 972,000 $ 704,286 $ 945,567 $ 32,997 $ (6,564) $ 26,433 $ $ $ $ $ 26,433 $ $ $ 415,000 $ 2,339 $ 2,339 $ $ 412,661 $ 43,275 $ 219,026 $ $ $ $ 262,301 $ 150,360 $ $ 150,360 $ 190,000 $ 141,801 $ 168,113 $ 14,462 $ 7,425 $ 5,525 $ $ $ 5,525 $ 16,362 $ $ 16,362 $ 1,000,000 $ 255,974 $ 460,170 $ 99,191 $ 440,639 $ 237,131 $ 302,699 $ $ $ $ 539,830 $ $ $ 2,925,000 $ 2,327,311 $ 2,327,311 $ 792,130 $ (194,441) $ 428,865 $ 104,300 $ 14,872 $ 36,377 4,869 $ 8,406 $ 597,689 $ $ $ $ 528,000 $ 247,576 $ 247,576 $ 6,239 $ 274,185 $ 6,245 $ 290 $ $ $ $ 6,535 $ 273,889 $ $ 273,535 $ 160,000 $ 2,765 $ 2,765 $ 141,818 $ 15,417 $ 129,230 $ 14,182 $ $ $ $ 143,412 $ 13,823 $ $ 13,823 $ 20,000 $ $ $ $ 20,000 $ 12,457 $ $ $ $ $ 12,457 $ 7,543 $ $ 7,543 $ 15,000 $ $ $ $ 15,000 $ 15,000 $ $ $ $ $ 15,000 $ $ $ $ 9,000,000 $ 4,573,186 $ 5,845,292 $ 1,119,487 $ 2,035,221 $ 1,107,086 $ 1,070,232 $ 49,599 $ 36,377 5,285 $ 8,406 $ 2,276,985 $ 877,723 $ $ $ 877,369 $ 765,578 $ $ 765,453 $ $ 125 $ $ $ $ $ $ $ 124 $ $ 124 $ 2,086,692 $ 340,148 $ 2,038,933 $ 23,484 $ 24,275 $ 40,374 $ 3,174 $ $ $ $ 43,548 $ 4,211 $ $ 4,211 $ 1,808,487 $ $ 1,808,481 $ $ 6 $ $ $ $ $ $ $ 6 $ $ 6 $
4,175,027 $ 574,433 $ 3,777,676 $ 398,725 $ (1,374) $ 353,081 $ 30,350 $ $ $ $ 383,431 $ 13,920 $ $ 13,920 $ 7,641,687 $ 47,557 $ 7,566,901 $ 559 $ 74,227 $ 74,786 $ $ $ $ $ 74,786 $ $ $ $ 716,623 $ $ 713,578 $ $ 3,045 $ $ $ $ $ $ $ 3,045 $ $ 3,045 $ 1,610,000 $ 16,912 $ 1,530,015 $ 457 $ 79,528 $ 9,802 $ $ $ $ $ 9,802 $ 70,183 $ $ 70,183 $ 7,179,009 $ 42,279 $ 7,110,173 $ $ 68,836 $ 24,863 $ $ 9,316 $ (9,316) $ $ 24,863 $ 43,973 $ $ 43,973 $ 30,000 $ 21,804 $ 28,087 $ $ 1,913 $ $ $ 1,913 $ $ 1,913 $ 1,393,211 $ $ 1,393,062 $ $ 149 $ $ $ $ $ $ $ 149 $ $ 149 $ 4,767,000 $ 999,151 $ 4,156,642 $ 442,163 $ 168,195 $ 440,316 $ 21,851 $ 57,854 $ 24,872 11,287 $ $ 556,180 $ 54,178 $ $ $ 2,068,180 $ 489,156 $ 1,923,129 $ 104,912 $ 40,139 $ 72,077 $ 37,002 $ $ 3,836 $ $ 112,915 $ 32,136 $ $ $ 32,136 $ 2,281,454 $ 239 $ 2,273,485 $ $ 7,969 $ $ $ $ $ $ $ 7,969 $ $ 7,969 $ 815,000 $ $ 814,208 $ $ 792 $ $ $ $ $ $ $ 792 $ $ 792 $ 9,444,452 $ 3,264,219 $ 6,109,676 $ 2,758,048 $ 576,728 $ 2,493,142 $ 191,537 $ 59,334 $ 300,067 89,053 $ (2,944) $ 3,130,189 $ 204,587 $ 1,861 $ $ $ 361,556 $ 43 $ 361,591 $ $ (35) $ $ $ (35) $ $ $ (35) $ $ $ $ 216,670 $ 55,370 $ 227,450 $ $ (10,780) $ (10,780) $ $ $ $ $ (10,780) $ $ $ $ 3,354,480 $ 113,923 $ 460,652 $ 2,542,583 $ 351,245 $ 2,673,530 $ 60,374 $ 8,905 $ $ $ 2,742,809 $ 151,019 $ $ $ 151,019 $ 1,036,000 $ 277,627 $ 940,924 $ 42,323 $ 52,753 $ 78,945 $ 16,131 $ $ $ $ 95,076 $ $ $ $ 125,000 $ 6,390 $ 24,132 $ $ 100,868 $ 4,600 $ 8,216 $ $ $ $ 12,816 $ 88,052 $ $ $ 88,052 $ 100,000 $ 24,513 $ 115,350 $ $ (15,350) $ (15,350) $ $ $ $ $ (15,350) $ $ $ $ 475,000 $ 253,777 $ 321,571 $ 9,236 $ 144,193 $ 85,621 $ 45,066 $ 22,742 $ $ $ 153,429 $ $ $ $ 95,000 $ $ 76,902 $ $ 18,098 $ 18,098 $ $ $ $ $ 18,098 $ $ $ $ 305,000 $ 89,098 $ 214,397 $ 8,703 $ 81,900 $ 90,603 $ $ $ $ $ 90,603 $ $ $ $ 37,828 $ $ 37,828 $ $ $ $ $ $ $ $ $ $ $ $
310,000 $ $ 302,831 $ $ 7,169 $ $ $ $ $ $ $ 7,169 $ $ $ 7,169 $ 560,000 $ 380,477 $ 549,131 $ 14,256 $ (3,387) $ (7,197) $ 2,341 $ $ $ $ (4,856) $ 15,725 $ $ $ 15,725 $ 457,000 $ 397,964 $ 447,177 $ 17,626 $ (7,803) $ (5,427) $ 2,156 $ $ $ $ (3,271) $ 13,094 $ $ $ 13,094 $ 350,000 $ 307,505 $ 311,932 $ 7,535 $ 30,533 $ 38,068 $ $ $ $ $ 38,068 $ $ $ $ 203,749 $ 184 $ 943 $ $ 202,806 $ 335 $ 492 $ 2,825 $ 34,153 $ $ 37,805 $ 165,001 $ $ $ 162,892 $ 70,000 $ 66,489 $ 66,489 $ $ 3,511 $ 234 $ $ $ $ $ 234 $ 3,277 $ $ $ 3,277 $ 25,000 $ 14,797 $ 14,797 $ $ 10,203 $ $ $ $ $ $ $ 10,203 $ $ $ $ 253,000 $ 39,635 $ 39,635 $ 1,804 $ 211,561 $ 93,684 $ 47,607 $ 1,072 $ 10,550 47,512 $ $ 200,425 $ 12,940 $ $ $ 12,940 $ 225,000 $ 70,038 $ 70,038 $ 135,864 $ 19,098 $ 139,594 $ (6,170) $ 7,784 $ $ $ 141,208 $ 13,754 $ $ $ $ 350,000 $ 20,236 $ 20,236 $ 311,608 $ 18,156 $ 315,980 $ 9,066 $ $ $ $ 325,046 $ 4,718 $ $ $ $ 24,000 $ 4,929 $ 4,929 $ $ 19,071 $ 19,071 $ $ $ $ $ 19,071 $ $ $ $ 292,717 $ 18,024 $ 18,024 $ 274,693 $ $ 273,149 $ 1,519 $ $ $ $ 274,668 $ 25 $ $ $ 25 $ 7,730
354
354
54,178
202,726
2,109
10,203
13,754
4,718
PROJECT TOTAL _s� --9�,2_2_7,�000-�$ ___ 2�,1_ 4_1 �,0_19_�$ ___ 4�, _62_ 6�,9_5 _9�$ __ �3,_366�,2_3 _1�$ __ �1,_2 _33�,8_ 1_0 _s� -3�.7_9_2.�7 _58_�s __ 1_86_ ,�7 _98_�s __ 4_3�,2_93_�s __ 4_4�,7_0 _3 ___ 4_ 7 �,5_1 _2�$ _____ �s __ �4,_ll_ S�,064-�$ ____ 4_84� , _97_ 7_$�------ s� ______ s ___ 4_5_4 �,1 _93_�s ____ 3 _0,_784_ ST AAAACP JOINT $ 26,250 $ $ $ $ 26,250 $ 26,250 $ $ $ $ $ $ 26,250 $ $ $ $ $ (AAAl)
(AAA 2)
(BBB)
POWER
WATER
JOINT
-$.---13
""
2-,7
--
2-5,-060
----,.$ ---13-,2-l-l-,8-22-.,.$--l-18-,-11-1-,3-68--,$---8-, -45 --
9-,8
--
7 --
7 --,
$---6,-15
--
3-,8
--
1-5--$,--8-,7-90-, --744--$,--2-,36
--
9,-36 __ 2_$.--6
--
68-.-54- 7-.,.$ --3
--
9-8,-23- 0-.,.$--1
--
5 ... 3-,1-37
---.,.$---5 ,-46_2_$,,_ __ 12-,3- 8 ... 5-,48-2--,$---2 ,-2 -28-,2-1-0 """"$,----1-, 8-6
--
1-$,----4
--
70-, -206
---$,---1-,460
-- ,-37
--
2-.,.$ ----2-95-,77
=
2-
$
$
$
40,288,106 $
50,294,566 $
42,142,388 $
132,725,060 $
3,718,237 $
2,975,907 $
6,517,678 $
13,211,822 $
35,126,924 $
47,973,816 $
35,010,628 $
118,111,368 $
3,006,377 $
1,167,044 $
4,286,456 $
8,459,877 $
2,154,805
1,153,706
2,845,304
6,153,815
$
$
2,968,787 $
945,901
$ 4,876,056
$ 8,790,744
66.48%
$
$
$
1,156,235 $
497,757 $
715,370 $
2,369,362 $
65.70%
412,823 $
118,318 $
137,406 $
668,547 $
65.72%
300,067 $
34,068 $
64,095 $
398,230 $
66.43%
89,053 $
4,869 $
59,215 $
153,137 $
67.52%
(2,944) $
8,406 $
$
5,462 $
65.56%
4,924,021 $
1,609,319 $
5,852,142 $
12,385,482 $
237,161 $
711,431 $
1,279,618 $
2,228,210 $
1,861 $
$
$
1,861 $
11,278 $
317,601 $
141,327 $
470,206 $
7,543 $
386,100 $
1,066,729 $
1,460,372 $
216,479
7,730
71,562
295,771
(CCC) = (AAAl x 100% + AAA2 x 45%) x (BBB) $ 2,087,451 $ 538,525 $ 118,395 41,794 $ 21,278 $ 5,511 $ 2,812,954 REVISED ATTACHMENT K-5
(A) (B) ICJ (D) = (A) -(8)-(C)
Appropriation YTD Expenditures PTO Expenditures Encumbrances Available Balance Pooled Interest Rate in FY 2010-11
Pooled Interest Rate in FY 2011-12
Pool&d Interest Rate in FY 2012-13
Pooled Interest Rate in FY 2013-14
Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015} Interest Amount in FY 2010-11
Interest Amount in FY 2011-12
Interest Amount in FY 2012-13
Interest Amount in FY 2013-14
Estimated Interest Amount in FY 2014-15 (as of March 31, 2015} (DDD1)
(DDD2)
(DDD3)
(DDD4)
(DDD5)
ClassifiCiltion
(EEEl) = (CCC} x (DDD1)
(EEE2) = (CCC} x (DDD2)
(EEE3) = (CCC} x (DDD3)
(EEE4) = (CCC) x (DDD4)
(EEE5) = (CCC) x (DDD5)
As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 Balance due from Wholesale Customers (FFF) =(CCC}+ (EEEl) + (EEE2) + (EEE3) + (EEE4) + (EEE5) 1 Total expenditure only included amount up to the Unused Balance. 2 Expenditures under projects CUW392 and CUW710 were re-allocated to various projects. As a resutt, there are zero balance in expenditures for these projects. 3 Project CUW690 - Customer Care & Billing System will be specially allocated due to limit to Customer Services % (2%} in WSA contract section S.OSE. 4 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009. 5 Actual expenditures exceed available fund balance, assume the exc..d expenditures are from encumbrances. 6 This project has been closed out as of June 6, 2013.
7 This project is split 64.3%/35. 7%, Joint/City} per Revised Attachment K-2. 8 This project has been closed out as of June 30, 2012. 9 Project is included as part of the revenue funded capital project. 10 Project is included as part of the Water Enterprise revenue bond funded capital project. (E) = (El) + (E2) +
�-�(E_1�) ----�(E_2)�---�(�E3�)----�(E_ 4�) ----�(E_5�) ----�(E_6�) -� (E3)+(E4)+(ES) + (E6) Expenditures in
FY 2009-10 ��-_;FY�2�0�1;;0-;,:1,:.l _ _;F,;,Y,,:2;;0=11�-=12:,_L_l _,:,FY,:,,:,20;;;1�2;;;-13:;;,__JIL;,.FY;,.2;;;0;,:1;;;3-;;;1;;:4'"""11_,YT=D=FY=2=014-==1=5:..I Tot.I Expenditures
1.24%
1.11% 1.11%
0.85% 0.85% 0.85%
0.663% 0.663% 0.663% 0.663%
0.499% 0.499% 0.499% 0.499% 0.499% 0.499%
$ 25,884 $ $ $ $ $ $ 25,884
$ 23,171 $ 5,978 $ $ $ $ $ 29,148
$ 17,743 $ 4,577 $ 1,006 $ $ $ $ 23,327
$ 13,840 $ 3,570 $ 785 $ 277 $ $ $ 18,195
$ 10,416 $ 2,687 $ 591 $ 209 $ 106 $ 27 $ 13,694
$ 2,178,506 $ 555,338 $ 120,777 42,279 $ 21,384 $ 5,538 $ 2,923,204 (F) = (C) + (D) - (E)
Unused Balance
11 Projects CUH975 and CUH977 were funded by revenue in FY 2009-10 and FY 2010-11. However, starting: in FY 2011-12, these two projects were funded by Water Revenue Bond Series 20118. As a result, Wholesale Customers were refunded $10,838,326 ($10,519,682 collected in FY 2009-10 and FY 2010-11 plus interest of $318,644) in FY 2011-12. 12 Intentionally left blank.
13 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009. 14 Per discussion with Carlos Jacobo, project CUH810 is a custom work project and should be "POWER" not "JOINT'. These custom works are mainfy for street light maintenance. (G)
Encumbrances
(H)
Appropriation
Transfer Out
through Closeout
Process
(I)
DEOBLIGATE/
OBLIGATION
As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 (J) = (A) - (B)-(E)-(G)
(H)-(1)
Unexpended
Balances of
Appropriation after
Closeout and
Deobligate
As of June 30, 2015
REVISED ATTACHMENT K-5
ATTACHMENT L
Project
Number
REGIONAL
CUW373 Regional
CUW384 Regional
CUW387 Regional
CUW352 Regional
CUW355 Regional
CUW359 Regional
CUW370 Regional
CUW374 Regional
CUW381 Regional
CUW382 Regional
CUW386 Regional
CUW353 Regional
CUW363 Regional
CUW368 Regional
CUW380 Regional
CUW389 Regional
CUW393 Regional
CUW354 Regional
CUW356 Regional
CUW357 Regional
CUW361 Regional
CUW365 Regional
CUW366 Regional
CUW367 Regional
CUW369 Regional
CUW371 Regional
CUW378 Regional
CUW379 Regional
CUW390 Regional
CUW391 Regional
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project Description
San Joaquin Region
San Joaquin Pipeline System Rehabilitation
Tesla Advance Disinfection
Tesla Portal Disinfection
Sunol Valley Region
Alameda Creek Fishery Enhancement
Stand-by Power - Various Locations
New Irvington Tunnel/Alameda Siphon NO.4
Pipeline Readiness Improvements
Calaveras Dam Replacement
SVWTP 40 mgd Addition
SVWTP Finished Water Reservoir
San Antonio Pump Station Upgrade
Bay Division Region
Seismic Upgrade BDPL 3 & 4
SCADA Phase II/Security Upgrades
BDPL Reliability Upgrades
BDPL 3 & 4 Crossover
EBMUD Intertie
BDPL 4 Slipline
Peninsula Region
Lower Crystal Springs Dam Improvement
Crystal Springs Bypass Tunnel
Adit Leak Repairs
Pulgas Balancing Reservoir Rehabilitation and Improvements Cross Connection Control
HTWTP Short Term Improvemetns
HTWTP Long Term Improvements
Capuchino Valve Lot Improvements
Crystal Springs/San Andreas Transmission
Crystal Springs Pipleine 2 Replacement
San Andreas Pipeline 3 Installation
Desalination
Baden & San Pedro Valve Lots Improvements
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project
Number Project Description
San Francisco Region
CUW358 Regional Sunset Reservoir Upgrades - North Basin CUW372 Regional University Mound Reservoir Upgrades - North Basin System-Wide
CUW388 Regional PEIR
CUW392 Regional Program Management Services
CUW394 Regional Watershed Land Acquisition
RETAIL
Reservoirs
CUVV307 Local Summit Reservoir Rehabilitation
CUW310 Local New Northwest Reservoir
CUW319 Local Hunters Point Reservoir Rehabilitation
CUW334 Local Stanford Heights Reservoir Rehabilitation
CUW335 Local Potrero Heights Reservoir Rehabiliation
CUW337 Local Sutro Reservoir Rehabilitation
Pump Stations/Tanks
CUW306 Local Croçker Amazon Pump Station Upgrade
CUW309 Local Lake Merced Pump Station Upgrade
CUW314 Local La Grande Tank Upgrade
CUW318 Local Forest Hill Tank Rehabilitation
CUW320 Local Forest Hilll Pump Station Upgrade
CUW321 Local Forest Knoll Pump Station Upgrade
CUW322 Local Lincoln Park Pump Station Upgrade
CUW323 Local Alemany Pump Station Upgrade
CUW324 Local Mount Davidson Pump Station Upgrade
CUW326 Local Palo Alto Pump Station Upgrade
CUW326 Local Sktview-AquaVista Pump Station Upgrade
CUW327 Local Summit Pump Station Upgrade
CUW328 Local McLaren #1 Tank Rehabilitation
CUW329 Local Potrero Heights Tank Seismic Upgrade
CUW330 Local Forest Knoll Tank Seismic Upgrade
CUW331 Local Lincoln Park Tank Seismic Upgrade
CUW332 Local McLaren #2 Tank Rehabilitation
CUW333 Local Mount Davidson Tank Seismic Upgrade
CUW338 Local La Grande Pump Station Upgrade
CUW339 Local Potrero Heights Pump Station Upgrade
CUW340 Local Vista Francisco Pump Station Upgrade
Page2 of 3
Project
Number
CUW304 Local
CUW308 Local
CUW311 Local
CUW312 Local
CUW313 Local
CUW315 Local
CUW316 Local
CUW301 Local
CUW302 Local
CUW364 Local
CUW303 Local
CUW305 Local
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project Description
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
Eastlest Transmission Main
Fulton (§ Sixthe Ave Main Replacement
Water SupplylWater Quality
Groundwater
Recycled Water
Lawrence-Livermore National Laboratory Water Quality Improvements Miscellaneous
Vehicle Service Facility Upgrade
Fire Protection at CCD
A TT ACHMENT L-2
03/13/06
$507,815,000
PUBLIC UTILITIES COMMISSION
OF THE CITY AND COUNTY OFSAN FRANCISCO
SAN FRANCiSCO WATER REVENUE BONDS, 2006 SERIES A
$110,065,000
PUBLIC UTILITIES COMMISSION
OF THE CITYAND COUNTY OF SAN FRANCISCO
SAN FRANCISCO WATER REVENUE BONDS, 2006 REFUNDING SERIESB
CERTIFICATE REGARDING USE OF PROCEEDS
The undersigned hereby states and certifesas follows:
(i) The undersigned is the General Manager of the Public Utiities Commission of the City and County of San Francisco (the "Commission"), and is authorized to execute this certificate on behalf of the Commission and is knowledgeable with respect to the matters set forth herein.
(ii) On the date hereof, the Commission is issuing the two series of bonds captioned above (the "2006 Series A Bonds," the "2006 Refunding Series B Bonds" and, together, the "Bonds") pursuant to an Amended and Restated Indenture dated as of August 1, 2002 and the First Supplemental Indenture dated as of March 1, 2006 (collectively, the "Indenture"), both by and between the Commission and U.S. Bank National Association, as trustee (the "Trustee"). (iii) The Trustee wil transfer and deposit the proceeds of the 2006 Series A Bonds received by the Trustee on the date hereof as follows:
(1) $48,212,528.32 will be deposited in the 2006 Series A Gapitalized Interest Account established within the Interest Fund;
(2) $15,958,031.25 will be deposited in the 2006 Series A Reserve Account of the Bond Reserve Fund;
(3) $623,906.09 will be deposited in the 2006 Series A Costs of Issuance Fund; (4) $120,622,352.19 will be deposited in the 2006 Series A Refunding Fund and transferred pursuant to Irrevocable Refunding Instructions of the Commíssion dated the date hereof; and
(5) the remaining $338,600,816.86 wil be transferred to the Treasurer for deposit to the 2006 Senes A Project Fund.
(iv) The proceeds of the 2006 Series A Bonds transferred pursuant to the Irrevocable Refunding Instructions of the Commission wil be used to defease and refund the Commission's Commercial Paper Notes (Water Series) on a current basis. The Notes were issued to finance a portion of the facilities described in Exhibit A hereto. (v) The proceeds of the Bonds deposited in the 2006 Series A Project Fund will be used to finance a portion of the facilties described in Exhibit A hereto.
A TT ACHMENT L-2
CONTINUED
(vi) The Trustee wil transfer and deposit the proceeds of the 2006 Refunding Series B Bonds received by the Trustee on the date hereof as follows:
(1) $192,498.04 wil be deposited in the 2006 Refunding Series B Costs of Issuance Fund; and
(2) $111,178,241.95 wil be deposited in the 2006 Refunding Series B Refunding Fund.
(vii) The proceeds of the Bonds deposited in the 2006 Refunding Series B Refunding Fund, together with amounts on deposit in the funds and accounts established under the Indenture for the Commission's San Francisco Water Revenue Bonds, 1996 Series A (the "1996 Series A Bonds") and its San Francisco Water Revenue Bonds, 2001 Series A (the "2001 Series A Bonds"), wil be used to refund on an advance basis a portion of the outstanding 1996 Series A Bonds and a portion of the outstanding 2001 Series A Bonds. The portion of the 1996 Series A Bonds being refunded were issued to finance the facilties (the "1996 Project") described in Exhibit B hereto, and the portion of the 2001 Series A Bonds being refunded were used to finance the facilties (the "2001 Project") described in Exhibit B hereto. (viii) Exhibit C hereto attached describes (A) each use to be made by any person of the Project', the 1996 Project and the 2001 Project other than use by the Commission and other non-federal governmental units and other than use by members of the public generally, and (B) payments (if any) directly or indirectly in respect of such use which are to be made after the date hereof;
(ix) Other than as set forth in Exhibit A and Exhibit B, no portion of the proceeds of the Bonds wil be used, directly or indirectly, to make or finance a loan to any person (other than a State or local government unit) or to acquire property which wil be sold or leased to any person (other than a State or local government unit) on an installment a sale basis except as referenced in Exhibit C.
(x) The Commission expects to use the Project for the purposes referenced and discussed in Exhibit Ai Exhibit B, Exhibit C and Exhibit D or for other governmental purposes of the Commission during the entire term ofthe Bonds. ,
(xi) Set forth on Exhibit 0 is the Commission's methodology for determining governmental use and private use with respect to the water enterprise:
(xii) To the best knowledge of the undersigned, the above statements are reasonable and there are no other facts, estimates or circumstances, other than those set forth herein, that would matenally affect the statements made herein.i
Capitalized terms used but not defined herein have the meanings set forth in the Indenture.
IN WITNESS WHEREOF, I have hereunto set my name this 15th day of March, 2006.
By:
2//
ATTACHMENT L-2 (CONTINUED)
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
SUMMARY OF SOURCES AND USES OF FUNDS
(Section 5.04)
Source: Closing Documents (Certificate Regarding Use of Proceeds) Proceeds
Principal
Plus Premium
Minus Underwriter's Discount
Minus Insurance
Net Proceeds
i;07,815,000.00
19,109,138.35
(932,940.06)
(1,973,563.58)
524,017,634.71
Use of Proceeds
Capitalized Interest Fund
Bond Reserve Fund
Insurance Fund
Series A Refunding Fund
Series A Project Fund
Total Uses
48,212,528.32
15,958,031.25
623,906.09
120,622,352.191.
338,600,816.86 f 459,223,169.05
524,017,634.71
Commercial Paper Project Fund Total
Hetch Hetchy
Tesia Portal Disinfection 251,262.58 1,147,302.42 1,398,565.00 Advance Disinfection 429,714.76 5,611,554.24 6,041,269.00 SJPL 4,737,937.28 17,784,667.72 22,522,605.00
Total Hetch Hetchy 5,418,914.62 24,543,524.38 29,962,439.00 SF Regional
University Mouhd - North 55,728.10 5,964,279.90 6,020,008.00 Sunset - North 7,525,896.84 28,782,094.16 36,307,991.00 Groundwater 3,400,973.67 2,963,110.33 6,364,084.00
Recycled Water 1,548,036.76 11,316,958.24 12,864,995.00 Total SF Regiona1 12,530,635.37 49,026,442.63 61,557,078.00 SF Local 45,405,787.71 106,407,313.30 151,813,101.01
Sunol Valley Subregional
Calaveras Dam 9,065,945.51 15,993,818.49 25,059,764.00
Stand-by Power 556,398.67 1,207,319.33 1,763,718.00
Pipeline Readiness 649,566.31 4,942,205.69 5,591,772.00 SAPS Upgrade 213,423.44 1,748,134.56 1,961,558.00
SVWTP Finished Water Res 3,317,203.82 7,838,383.18 11,155,587.00 Irvington Tunnel 4,084,139.65 18,247,176.35 22,331,316.00 Alameda Creek Fishery 656,765.00 1,327,119.00 1,983,884.00 SVWTP 40 mgd Addition 25,378.75 3,474,585.25 3,499,964.00 Total Sunol Valley Subregional 18,568,821.15 54,778,741.85 73,347,563.00
This certificate is for illustration only. It was prepared in 2006 and shown groundwater and recycled water projects as regional instead of locaL. In addition, it does not reflect expenditures for the portions of regional assets which in rate base as of June 30, 2008 nor what is expected to be added to rate base through June 30, 2009. For these reasons, the percentages shown for regional and local projects are not accurate.
ATTACHMENT L-3
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
(Section 5.04 A)
Project
Number
REGIONAL PROGRAM
San Joaquin Region
San Joaquin Pipeline System Rehabilitation
Tesla Advance Disinfection
Tesla Portal Disinfection
Total San Joaquin Region
CUW373 Regional
CUW384 Regional
CUW387 Regional
CUW352 Regional
CUW355 Regional
CUW359 Regional
CUW370 Regional
CUW374 Regional
CUW381 Regional
CUW382 Regional
CUW386 Regional
CUW353 Regional
CUW363 Regional
CUW368 Regional
CUW380 Regional
CUW389 Regional
CUW393 Regional
CUW354 Regional
CUW356 Regional
CUW357 Regional
CUW361 Regional
CUW365 Regional
CUW366 Regional
CUW367 Regionai
CUW369 Regional
CUW371 Regional
CUW378 Regional
CUW379 Regional
CUW390 Regional
CUW391 Regional
CUW358 Regional
CUW372 Regional
CUW388 Regional
CUW392 Regional
CUW394 Regional
LOCAL PROGRAM
CUW307 Local
CUW310 Local
CUW319 Local
CUW334 Local
CUW335 Local
CUW337 Local
CUW306 Local
CUW309 Local
CUW314 Locai
CUW318 Local
CUW320 Local
CUW321 Local
CUW322 Local
CUW323 Local
CUW324 Local
Project Description
Sunol Valley Region
Alameda Creek Fishery Enhancement
Stand-by Power - Various Locations
New Irvington Tunnel/Alameda Siphon NO.4
Pipeline Readiness Improvements
Calaveras Dam Replacement
svwp 40 mgd Addition
svwP Finished Water Reservoir
San Antonio Pump Station Upgrade
Total Sunol Valley Region
Bay Division Region
Seismic Upgrade BDPL 3 & 4
SCADA Phase II/Security Upgrades
BDPL Reliability Upgrades
BDPL 3 & 4 Crossover
E8MUD Intertie
BDPL 4 Slipline
Total Bay Division Region
Peninsula Region
Lower Crystal Springs Dam Improvement
Crystal Springs 8ypass Tunnel
Adit Leak Repairs
~~fE~~E~~~';~;OO '"' ,m~:.""..m",..'.'.~,:,'\'.:,e,JJt,'.-.:.~.;\~,~~\\ Crytal Springs/San Andreas Transmission _~, " , _) _
Crystal Springs Pipleine 2 Replacement i'"' \ \'.,; '\
San Andreas Pipeline 3 Installation 'f; è\ \ " ,\'(0,'1 Desalination /_ 'r~ \. '\ /~\_\~~)! ,.:Y
Baden & San Pedro Valve L9íel¡prcìÌ!èn~-!tS
Total Peninsula Region '\ \\, .~;~¿\;;,..
\2;'.\;/
San Francisco Region
Sunset Reservoir Upgrades - North 8asin-
University Mound Reservoir Upgrades - North Basin
Total San Francisco Region
System-Wide
PEIR
Program Management Services
Watershed Land Acquisition
Total System-Wide
Total Regional Program
Reservoirs
Summit Reservoir Rehabilitation
New Northwest Reservoir
Hunters Point Reservoir Rehabilitation
Stanford Heights Reservoir Rehabilitation
Potrero Heights Reservoir Rehabilitation
Sutro Reservoir Rehabilitation
Total Reservoirs
Pump Stations/Tanks
Crocker Amazon Pump Station Upgrade
Lake Merced Pump Station Upgrade
La Grande Tank Upgrade
Forest Hill Tank Rehabilitation
Forest Hilll Pump Station Upgrade
Forest Knoll Pump Station Upgrade
Lincoln Park Pump Station Upgrade
Alemany Pump Station Upgrade
Mount Davidson Pump Station Upgrade
Net Financing
Proceeds'
1,398,565
6,041,269
22,522,605
29,962,439
1,983,884
1,763,718
22,331,316
5,591,772
25,059,764
3,499,964
11,155,587
1,961,558
73,347,563
21,234,846
1,313,461
45,235,465
21,239,846
10,743,922
1,219,251
100,986,791
4,2J.°Ata
18¡4Q6,O~~
. ir1',.9tsN'03\
..\\3_92,i.~213
\. \\:C,¡75, 1 09
v' 6,457,624
3,656,979
916,364
5,737,829
6,288,936
3,435,064
652,092
3,023,744
60,090,650
6,020,008
36,307,991
42,327,999
8,308,050
13,323,598
502,660
22,134,308
-328,849,750
Appropriated
Interest
Earnings'
Adjusted
Project
Funding
Expenditures
Thru 6/30/093
Remaining
Balance
Project
Number
CUW326 Local
CUW326 Local
CUW327 Local
CUW328 Local
CUW329 Local
CUW330 Local
CUW331 Local
CUW332 Local
CUW333' Local
CUW338 Local
CUW339 Local
CUW340 Local
CUW304 Local
CUW308 Local
CUW311 Local
CUW312 Local
CUW313 Local
CUW315 Local
CUW316 Local
CUW301 Local
CUW302 Local
CUW364 Local
CUW303 Local
CUW305 Local
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
(Section 5.04 A)
Project Description
Palo Alto Pump Station Upgrade
Sktview-AquaVista Pump Station Upgrade
Summit Pump Station Upgrade
McLaren #1 Tank Rehabilitation
Potrero Heights Tank Seismic Upgrade
Forest Knoll Tank Seismic Upgrade
Lincoln Park Tank Seismic Upgrade
McLaren #2 Tank Rehabilitation
Mount Davidson Tank Seismic Upgrade
La Grande Pump Station Upgrade
Potrero Heights Pump Station Upgrade
Vista Francisco Pump Station Upgrade
Total Pump StationslTanks
Net Financing
Proceeds1
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
EasUWest Transmission Main
Fulton ~ Sixth Ave Main Replacement ','"
TloalPipelinesNalves "'1/;;2:'\,\ \:,' .).
Water SupplylWater Quality .. (!. \ ¡':::) j \.i
Groundwater ~(~, \\ ~ :\ ,! (. ,:.j'
Recycled Water. it, \ \Y";¿. .,'
Lawrence-Livermore Natioita.1 täi,oj~t~iY.Wáter Quality Improvements Total Water SupplylWater Q"Ii~Ir,:~j'/
\J':;'
/)\)f§j\~\
f,:\'\\'
Miscellaneous
Vehicle SerVice Facility Upgrade
Fire Protection at CCD
Total Miscellaneous
Total Local Program
Grand Total Regional and Local Programs
Unappropriated. Interest Earnings
Percent of Net Proceeds.
Percent of Net Proceeds and Earnings4
'Net financing proceeds available on date of issue (i.e. deposit to project fund) 'Cumulative net of arbitrage rebate liability
3Cumulative
'If financing sources Substantially Expended, proceed allocations are then fixed
Appropriated
Interest
Eamings2
Adjusted
Project
Funding
Expenditures
Thru 6/30/09'
Remaining
Balance
ATTACHMENT M
REVENUE-FUNut:D CAPITAL ADDITIONS (Section 5.04.8)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) ATIACHMENI M-1
Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year)
A B C D E F
Wholesale Customer Capital Fund (5W CPF WCF)
G=C.D-F H I=G.H
Based on Proportionate Annual Water Deliveries of ... 68.7% Project Title
CUW262 Regional Water RnR - Treatment Facilities
CUW263 Regional Water RnR - ConveyancefTransmission Systems CUW264 Regional Water - Watersheds I ROW Management
FUW100 Regional Water - Facilties Maintenance
CUW261 Regional Water - Storage
FY 2009.10
Approved
Budget -
Total Regional
$ 1,000,000
$ 7.000,000
$ 500,000
$ 3,700,000
FY 2009-10
Approved
Budget -
WHOLESALE
SHARE
$ 687,000
$ 4,809,000
$ 343,500
$ 2,541,900
Projected
Expended &
Total Fiscal Year Encumbered Appropriated, Encumbered Projected Appropriation - All Years Actual 2009-10 Actual But Not Unencumbered through Surplus 1 All YearsA ExpendituresA ExpendituresA ExpendedA BalanceA 6/30/2010 (Shortall) $ 687,000 $ $ '$ $ 687,000 . $ 229,000 $ 458.000
$ 4,809,000 $ $ $ $ 4,809,000 $ 1,603,000 $ 3,206,000
$ 343.500 $ $ $ $ 343,500 $ 114,000 $ 229.500
$ 2,541,900 $ - $ $ - $ 2,541,900 $ 847,000 $ 1,694.900 Regional Total ~ _.~ $
Source: . SFPUC Commission Approved Budget, February 2009, Same Format . FAMIS - City's Official Financial System of Record
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.8)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) ..
Projected FAMIS.as of June 30, 2010 (Last Day ofBuClget Year) Based on Proportionate Annual Water Deliveries of 00'
Wholesale Customer Capital Fund (5W CPF WCF)
68.7%
FY 2009-10 Projected
FY 2009-10 Approved Expended &
Approved Budget - Total Fiscal Year Encumbered Appropriated, Encumbered Projected Budget - WHOLESALE Appropriation - All Years Actual 2009-10 Actual But Not Unencumbered through Surplus 1 Project Title Total Regional SHARE All YearsA ExpendituresA ExpendituresA ExpendedA BalanceA 6/30/2011 (Shortall) CUW262 Regional Water RnR - Treatment Facilities $ 1,000,000 $ 687,000 $ 687,000 $ 235.000 $ 235,000 $ $ 452,000 $ 409.000 $ 43.000 CUW263 Regional Water RnR - ConveyancefTransmission Systems $ 7,000,000 $ 4,809.000 $ 4,809,000 $ 1,395,000 $ 1,395,000 $ 25,000 $ 3,389,000 $ 1,589.000 $ 1.800,000 CUW264 Regional Water - Watersheds I ROW Management $ 500,000 $ 343.500 $ 343,500 $ 115,000 $ 115.000 $ 50,000 $ 178,500 $ 35.500 $ 143,000 FUW100 Regional Water - Facilities Maintenance $ 3,700,000 $ 2,541,900 $ 2,541,900 $ 850,000 $ 850,000 $ 123,000 $ 1,568,900 $ 768,900 $ 800,000 CUW261 Regional Water - Storage $ - $
Regional Total $ 12,200,000 $ 8,381,400 $ 2,595,000\ $ 2,595,000.J $ 198,000 $ 5,588,400 $ 2,802,400 $ 2,786,000 Source: . SF PUC Commission Approved Budget, February 2009, Same Format · FAMIS - City's Official Financial System of Record .
'\
Shown On Attchment N.2, Schedule 3
Revenue Capital - Actual Expenditures
"Shown on Attchement N-2, Schedule 3
Continuing Appropriation
Needed for Mulit-Year
Revenue Funded Capital
N
:E 'õ
.. NZ "
W '"
~ ~
~
os.s
~-:J
.s
~::~'tII §
;g lL
in .l
5 is.
~~Cl ..
~Ë
I/ 0
z ..
o g¡¡:u
ë ,gC Clc: II
;¡ ~
ii ~
c: lL
Uuc~wlLCo.~U
lL i-
i. II
:: 'tZ i:
~ :5W::
ii I/
'C
~
lí'"
-gai
~
Õ
~..o
o
N
.:
.2':i..Õ....
CI
¡¡
11 '"
t"
"ê'a-
:i
C)
.!
i:
~U"
C)
¡¡
~
u.u. a-u
~
'"c::iu.
;gw c-..U
~
~:iU
.!0"
ii
õ
;:
U
ai
Ol'"
i i: f! .c ~
~-8.8 gi~
'è~~~~Q. ~ C (,W W
"#
;;'"
~ i ~ ~ w
ge~f3~N c. "C .. :i
~.îól~CI::
-0
-I
~ i: . g
en ~ to.-
~ ~i~~ c- :i ..c( m ~
Õ
~"-c:
.~
¿¡
~..:ic:
c:
-0
~c:
o
:eoc-
ea-
c:o
"'.
~..ai
"'- -IV Ul ñi
-i .2 'I
'~ e- 0~ :i .ca-CICi
o CDo CD
In ..
CD~ or
00 r:
lßllWU)
0000
00 ~- ri., CO
if ff (ß U) U) (ß fß (ß (ß U) U) El tß
.'"
-g f! 0(
~ ~ BCo :J ;
~ ~ ~
~5
o CDo CDIn ..
~ ",.N. 0.
'" .
~ õ -g.D Z '"
§ "5 ~
u ai "
iJ w
ff(ßU)(ß
If (ß ff ff
c:o .
i; ~ ~
ë g- ~
&: ~
-0
g ~In .."" ~N to
N.O.
o CD
o CD
In ..
.. T""N ..N.O.
'" '"
lßffl0U)WU)WWfftßffWEi
.. i Q. Do D. Do Do Q. D. C. a. 3: ;:
a a 0 a 0a a 0 a 000000cicic:cic:a a 0 a 0o IS 0 0 f'
.. cr-"¡ - c¡
g ¡i:g :i
~ ~ ~ ~"(U t:"C II
~~tl~.ê
~~'~Õ.5
~ "g .Ef~ j~ u. ~
~ ~ ~ ~ ~(I a: S '; 0:
_u~2&~Q)-" .. jj
" ~ ~Ld~~ IIU)otI
ü ~~~~~~~~'~ 55555555a. üuul)uu0u
g"
t ;g
O~ en Wi2 ~Q. ~. Q)
l:š iT c'õ~ã.~
~~:i " ".. 0 iñ
c en "' (9
;l ~ ~ ~
E ~ ~ ~
~ '~ ~ ~:i (, (9 a:
§8ig§~§§ciit~c5lt-å6mCOOONOOo (f i. r- C" 0 0- r- e- Ñ cõ Ñ g c
.~ ~ ~ '~
et ~ ~ ~_O)Ula.æ Ìi .ê i:
~ ~ i ~2ã.1illê"~5:~;;-grt~~ æ ~ æ" ~ "l! .ê 2 c
~ ~ ~ ~
~ jj ~ ~
~:i::U
0000
00 ~~
CDCD'"
'"
g¡
Ñ
..
§ §
C"- .,
gi :S
"" -
'"CD
'"
~..
0000
00ri ~
:g ~"" -
..'"
Ñ
:!Ñ'"
..
~..c:o'¡;
&!
;;
E
il"
E
~
CDo
oN",
~ Š
~ &!
" -u. 0.; E~2
~~
-g ~,. c:
e ..0..5
c- u.
~~'~-~
.!!OE '"E :¡
8C3
g~a- ::u. -0CI u.. .
~:i
oCI
~
..'c:
~:;
'"c:-c:
~i:
lí'"'":iai
ß.."
i=
'C..
~
lí'"'":iai
Õ,.
~
!
~o
N
ÒCO
~"..Õ
'"..
!!:;
11 ~"
'ea-
os.s
~:J.s
~::~'t
II §
~ ~II .l
.2 'g.
õ uCl ..
~ ËI/ 0z ..
o g¡¡: u
ë ,gC Clc: II
;¡ ~
ii ~
c: lL
U U
C ~w lLCo.
~ ulL i-
i. II
::'tz i:
~ :5w ::
ii I/
"'- -II II r;-i .2 'I
'~ e- 0e :J.ra- CI CI
Ol'"
"i-g ¡ã~Õ i:.Q :J 0'~-~ ~ ~ ~
Q.)(c CDw w
.'"
i ! c
~ ~ fJQ. :i ;
~ ~ ~
: :5
¡¡
~
u.a-U
~
'"c:
iÌ
..'"c-..U
~
~:iU
.!..
...!o
;:
"'. .
~ õ "i.Dz'"
~ "S ¡u ai "
iJ w
~.,'"
~ i.. ~ w
g e ~æ ~N Q."C..:i
~.îól~CI::
-I
S! i: i 5
g ~ 1; ';
~ a..g~~ Q,:i..ci m ~
õ
.ê
.~
¿¡
I..:ic:
c:
-0
~c:
o
:eoc-
ea-
c:o
'"":ai
w (, Ul W Ul Ei lß fß U) W U) W U7
tlff6"WElWtllßfßl:Wtflß
o CDa CDIn ..
.e ~.:N ..N~ 0_
fFtßUllßtßlRtlliEltßEltßtl
o CDo CDIn .... ~
gj. ~-
ll Ul (ß lß (ß U) lß lß Eß (ß (ß U) lß
c:o.
ei ~ ~
~ e~
.îct
o CDo CDIn ..
~ ;N.O.
lß Ei El U' U' Ul tl (ß En (ß fß lß W
~ ~"'" ~N ..
NO'" -
ff (ß ff tß tß ti lß tf tß lß Eß tß tl
g g g g g
o a 000ci ci ci ci ci
a a 0 0'0
a i. a a ""-a- ri-oe" - ~
a- a- a- a- a- a- a- a- a- :: ::
g~i:g~g8a MO",OOci 1.- 'r" ci iri ci 0cnIDOO'NOO
o C' i. r- (" a a- 1"" ('j N- (0" Ñ
(ß lß lß ll lß lß lß tß lß ff ff lß W
"'"..
ilc:
..
c:
~
E ~
~ :ß
~ ~g- u.
'" '"
! d1
:l:ii:
l~
il b5
" c:
~ .Qc: ..
~ -~
~ ~(f
~ t6 ~
~ itdi (f;;
~ g~ i: u.9: l! :8ß w '~~to
~ ~~ o:~s~
,êlo:i ëei~D..£ z;ei ~~e-g..~=êi:~w::"§~_§~woeõ-~Q)
a.'§:§~~Ë~~~
n::Æ ~~(~~-gn:_~ci ë (I i: ~.! :: cd -n:~"Ëæ~~~i:n:
l~~e~~'ê~1:i~:~~~~i~3i:iUC)O:l-WI~
õ ~~~Š;~~~~
'ê' 55555555a. OOOOOüoo
'"
.!"'"
l!uCI
~~ ~
ê: '~ ¡ g-II Q.~ 0
~ K:!iU Q. :i i:nic(:EC
ä gi 0 æ
c.- - Cb
..¡ill len 0 Z IX
00 0000ct'r-
~ gs
.,- -
'" ~
.! l!" ""'''"'".c c:u"CI c-."
~~- "
¡ ~
~~~~-0 :ic:UAÎQ"~c:"~ Iio ,..c "CID:
'"
":;
~ 'i...c'c: u"CI
~~-",z
.2 i.. E
~ ti- ..
i~" c:ai 0
o c:- ~
'" 0
~æ
000000MT"-CD CDo CO
"" -
'"'"
~,.
..
00 g gri ~CD CD
o CO
"" -
CD
::
~,.
§ §crr
gi :S
"" -
~..c:o
i
;;
E
il
~
~
CDo
oN",
~ Š
H,,-u. 0.; E" "
.g¡¡
di Ji","i
~ .~
RJ:
~~
'~ E.~ 0
E ~
E :¡
86 g~a- ::u. -0(f u.
'"..In:i::U
åi
l!:i
oCI
ATTACHMENT M-2
REVENUE FUNDED CAPITAL
ANNUAL REPORTING REQUIREMENTS
(Section 5.048)
Part A. Updated Actual Information Through Most Recent Fiscal Year (Due in November) Each year, the SFPUC will provide a report on the status of the regional revenue funded projects with the following information:
Project-level information (through close-out)
1 Scope of project
2 Current cost estimate/budget.
3 . Expected milestone dates (ie, design, environmental, construction period, close-out, etc.) 4 Contract status
5 Reasons for status changes from prior report.
6 Other information relevant to whether project is on time/on budget. 7 For most recently completed fiscal year and estimated for current year:
8 Total expenditures (capital and operating); amounts paid from other sources. 9 Amount of encumbered and unencumbered appropriations
10 Application of any unused appropriations
Wholesale Capital Fund
11 Beginning balance, deposits, capital expenditures (by project), earnings, ending balance. 12 Components of ending balance; wholesale portion of:
13 Appropriated and encumbered
14 Appropriated but unencumbered
Part 8. Proposed Appropriations for Upcoming Year (Due in March) 15 Project information, to the extent not provided in Part A 16 Expected funding needs for regional projects
17 Unused or excess appropropriations carried over.
18 Proposed appropriation for upcoming fiscal year.
Amended Attachment M-3
Wholesale Capital Fund and Balancing Account Adjustment Reference Amended Section 6.08E
A. Cash Flow in Wholesale Capital Fund
FYE 2010 FYE 2011 FYE 2012 FYE 2013 FYE 2014 FYE 2015 FYE 2016 FYE 2017 FYE 2018 FYE 2019 FYE 2020 FYE 2021 FYE 2022 FYE 2023 1 Beginning Total Balance (1) - 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 2 Annual Appropriation (2) 10,476,724 8,636,920 21,737,468 11,285,643 18,668,585 15,432,451 21,138,051 11,184,265 17,847,379 26,424,000 26,420,000 13,210,000 13,210,000 13,210,000 3 Annual Expenditures (3) (1,778,695) (5,202,897) (18,553,119) (10,916,349) (5,758,565) (7,331,312) (6,245,954) (13,892,649) (14,361,409) (18,089,498) (16,723,232) (28,485,215) (33,563,793) (22,018,000) 4 Interest Earnings (4) 120,294 151,929 173,034 137,113 180,672 58,140 115,532 299,936 370,050 475,153 664,783 757,859 711,183 409,280 June 30 Balances Before Balancing Account Transfers
5 Total Balance (5) 8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785 42,508,440 51,910,495 32,848,850 17,206,239 12,807,520 6 Amount Encumbered as of June 30 (6) (1,927,466) (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 7 Unencumbered Balance (7) n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a 41,508,440 50,910,495 31,848,850 15,206,239 10,807,520 8 Transfer From/(To) Balancing Account (8) n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a (959,496) (4,544,290) 4,000,000 4,000,000 4,000,000 Ending Balances After Balancing Account Transfers
9 Ending Total Balance (9) 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 16,807,520 10 Unencumbered Ending Balance (10) n/a n/a n/a n/a 7,156,838 n/a n/a n/a n/a 40,548,944 46,366,205 35,848,850 19,206,239 14,807,520 B. Calculation of Target Balance
11 Target WCF Balance (11) 7,156,838 40,548,944 46,366,205 40,559,076 34,346,800 29,062,000 C. Calculation of Remaining Cumulative Appropriation
12 Cumulative Appropriation Since FYE 2010 (12) 10,476,724 19,113,644 40,851,112 52,136,755 70,805,340 86,237,791 107,375,842 118,560,107 136,407,486 162,831,486 189,251,486 202,461,486 215,671,486 228,881,486 13 Cumulative Expenditures Since FYE 2010 (13) (1,778,695) (6,981,592) (25,534,711) (36,451,060) (42,209,626) (49,540,938) (55,786,891) (69,679,540) (84,040,949) (102,130,447) (118,853,679) (147,338,893) (180,902,686) (202,920,686) 14 Total Remaining Cumulative Appropriation (14) 28,595,715 36,696,854 51,588,951 48,880,567 52,366,537 60,701,040 70,397,808 55,122,593 34,768,800 25,960,800 15 Amount Encumbered as of June 30 (15) (1,927,466) - (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 16 Unencumbered Remaining Cumulative Appropriation (16) n/a n/a n/a 26,668,249 n/a n/a n/a n/a 59,701,040 69,397,808 54,122,593 32,768,800 23,960,800 17 D. Lesser of Target Balance and Unencumbered Remaining Cumulative Appropriation Lesser of Target Balance (line 11) and Unencumbered Remaining Appropriation (line 16) (17) 40,548,944 46,366,205 40,559,076 32,768,800 23,960,800 E. Calculation of Excess Fund Balance and Refund to Wholesale Customers Through Balancing Account 18 Is Unencumbered Balance (line 7) more than line 17? (18) Yes Yes No No No 19 Excess WCF Balance (applied as a negative entry on line 8) (19) 959,496 4,544,290 - - - F. Calculation of Deficiency Fund Balance and Charge to Wholesale Customers Through Balancing Account (This Section is Only Applicable in Any Year When Line 18 is No) 20 Is Unencumbered Balance (line 7) less than line 17? (20) Yes Yes Yes 21 Tentative Amount Before Application of $4 million cap (21) 8,710 ,226 17,562,561 13,153,280 22 Is line 21 more than $4,000,000 maximum? (22) Yes Yes Yes 23 Balancing Account Charge (applied as a positive entry on line 8): 4,000 ,000 4,000,000 4,000,000 Original 5 Year True-up Method FYEs 2010-2018 Amended Annual True-Up (FYE 2019 and Beyond) See Notes on Page 2 Page 1 of 2
Notes:
(1) Beginning Total Balance (encumbered and unencumbered). Equal to the prior year ending total balance after balancing account transfers (line 9). (2) Wholesale Share of Revenue Funded Appropriations for Regional capital projects, adjusted for de-appropriations which have been factored into a wholesale revenue requirement, if applicable. FYE 2015 and forward are subject to compliance audit and 7.06 review.
Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided. (3) Wholesale Share of actual Regional capital expenditures funded from Revenue Funded Capital, determined based on proportionate water use in the year of expenditure. Figures from FYE 15 and forward are subject to 7.06 and compliance audit review.
Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided.
The figures in line 3 for FYE 18 and on are for illustrative purposes only. (4) Line 1 times the assumptions below for the SFPUC pool rate. FYE 2010 - 2014 figures are actual and tie to the first 5 year review.
Pool rate assumptions: 0.640% 0.670% 0.930% 1.240% 1.410% 1.600% 1.600% 1.930% 1.930% (5) Total encumbered and unencumbered balance of the Wholesale Capital Fund before Balancing Account adjustments: Line 1 + line 2 + line 3 + line 4. (6) Wholesale Share of the encumbrances for purchase orders or contracts in connection with revenue-funded Regional capital projects; calculated using the proportional annual use of the true-up year. Entered as a negative number.
Not applicable in years with no true-up (FYEs 2010-13 and 2015-18). FYE 2014 figure is actual. FYE 2019 and forward are plug numbers included for illustration. (7) Unencumbered Balance Before Balancing Account transfers: Line 5 + line 6. FYE 2014 figure is actual. Not applicable (n/a) in years with no true-up (FYEs 2010-13 and 2015-18). (8) Negative entries represent refunds to the Wholesale Customers through the Balancing Account and are calculated per Section E below, except for 2014 which is actual pursuant to the original 6.08E.
Positive entries represent charges to the Wholesale Customers through the Balancing Account and are calculated per Section F below. (9) Total Ending Balance After Balancing Account Transfers = Line 5 + line 8. (10) Unencumbered Ending Balance After Balancing Account Transfers = Line 7 + line 8. Must not exceed the amount on line 17, which is the lesser of the Target Balance (line 11) and the Unencumbered Remaining Cumulative Appropriation (line 16). (11) Starting in FYE 2019, the Target Balance is calculated by the formula below, where CY represent the Current Year (for which the transfer is being calculated), CY-1 is the prior year, CY-2 is 2 years prior, etc.:
[line 2: CY]*(4/5) + [line 2: CY-1]*(3/5) + [line 2: CY-2]*(2/5) +[line 2: CY-3]*(1/5); rounded to the nearest dollar. The FYE 2014 figure is the actual target balance under the original section 6.08E. (12) Cumulative Appropriations Since FYE 2010 = prior year line 12 + current year line 2. (13) Cumulative Expenditures Since FYE 2010 = prior year line 13 + current year line 3. Does not include encumbrances. (14) Total Remaining Cumulative Appropriation (encumbered and unencumbered) = line 12 + line 13. (15) Amount encumbered as of June 30 = line 6. Encumbrances are not cumulative. (16) Unencumbered Remaining Cumulative Appropriation = line 14 + line 15. (17) Lesser of Target Balance (line 11) and Unencumbered Remaining Cumulative Appropriation (line 16). Used in formulas in line 19 (Section E) and line 21 (Section F), as applicable. (18) If Yes, go to line 19 for calculation of the excess unencumbered balance. If No, go to line 20. (19) Calculation of Excess Balance: If line 18 = Yes, then line 7 minus line 17. The result appears as a negative amount on line 8. (20) If yes, then go to lines 21-23 for calculation of charge to Wholesale Customers. (21) Initial step in calculating charge: If line 20 = Yes, then line 17 minus line 7; go to line 22. (22) If the result on line 21 is greater than $4,000,000, then the charge to the Wholesale Customers is capped at $4,000,000. (23) Equal to the lesser of line 21 or $4,000,000. The result appears as a positive number on line 8.
See Notes on Page 2 Page 2 of 2
ATTACHMENT N
BALANCING ACCOUNT I RATE SETTING CALCULATION
REFERENCE SECTION 6.03.A.3.a
Step 1:
A. Balancing Account as of June 30, 2007
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year C. Wholesale Revenues for Fiscal Year
D. Wholesale Revenue Requirement for Fiscal Year
E. Settlement Credits or Other Adjustments
F. 1984 Agreement Balancing Account Credits
G. Balancing Account as of June 30, 2008
Step 2:
A. Balancing Account as of June 30, 2008
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year C. Wholesale Revenues for Fiscal Year "À 'n
D. Wholesale Revenue Requirement for Fiscal Year /?- \\ '\\ \// .. ,\ .¡ \ E. Settlement Credits or Other Adjustments ,;:t ;/:",, ~~ t' \ F. 1984 Agreement Balancing Account Credits /~~~ l\\ U )\: v G. Balancing Account as of June 30, 2009 .::\ c.~.\ \ '\'~ ',_¿:/' . L,\'\~ ~;)-;...:) ¡ ,!\ '\ \\ \\ 'vStep 3: .,.,(-'i\') i 4:, " V.l///. \-~ \....l;j ;1 ~\ /;' A. Balancing Account as of June 30, 2009 / ;,.Y-,l (\?\, ~~j3 'Ç B. Interest on Balancing Account at Pooled Investment Ra1aAór,;lIs~t ye~\r\; C. Wholesale Revenues for ~iscal Year . f\n\;~-=)\J .1,;-- D. Wholesale Reve.nue Requirem~nt for Fiscal y,\~;~r \\ '\ ;1\,(2/;/ E. Settlement Credits or Other AdJustmentsç", ~ ,\ '\ k'c1 F. 1984 Agreement Balancing Account üt~1t~\ '\ \;;j-./
G. Balancing Account as of June 30, 201 ai \\ i\~)\::/
H. Net Change in Wholesale Revenue Co\\~~âgÉ!
i. Total Revenue Deficiency or Surplus '~'.
J. Projected Water Sales in Ccf
K. Deficiency or (Surplus) $/Ccf
L. Deficiency or (Surplus) Ccf as a Percentage of Revenues FY 2007-08
$12,882,000
$554,000
($113,932,000)
$119,224,000
$2,448,614
$0
$21,176,614
84,621,240
ATTACHMENT N-1
FY 2008-09 FY 2009-10
//\
.,.... (,J"
_ :)\/\ \\ í ." ,\.\
(~S?),il:\\l ìJ/;;.1 ~ 'Pi ~ '\ '\ -',.,,;v1 J ò' '\ ~. Jl A c\ 0"I,f '\ '!/iJ¡\.;''~ ','t.f \\ ~/:J
'1 " \/.,/1 \" ''',i ',/
\\l\\/\\;\ .II,.. \. "'b\i '176614
\ -\ \,' ~~1 I\ \\~/ $529 000, ;) ,
\) -: -$123,604,000
$120,562,000
$21,000
$0
$18,684,614
$0
$0
-$127,485,900
$140',994,733
$21,000
$1,997,220
$15,527,053
$4,488,233
$20,015,286
83,205,600 85,920,000
$0.23
15.7%
Note: Dollar amounts are for illustrative purposes only. The Parties have not agreed on the amount of the balancing account as of June 30, 2007, revenue requirement for FY 2007-08, settlement credits for FY 2007-08, and the amount of the balancing account as of June 30,2009.
BALANCING ACCOUNT I RATE SETTING CALCULATION
METHOD OF CALCULATION
REFERENCE SECTION 6.03.A.3.a
ATTACHMENT N-1
N = The year for which rates are being set
N-1 = The current year
N-2 = The most recently completed year for which actual results are available Calculation Method:
Step 1 Determine the actual revenue differential for year N-2 A. Enter the beginning amount of the Balancing Account
B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amount of the Balancing Account Step 2
Step 3
Determine the projected revenue differential for year N-1 A. Enter the beginning amount of the Balancing Account; this is the same amount as G in Step 1 B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amòunt of the Balancing Account Determine the projected revenue differential for year N A. Enter the beginning amount of the Balancing Account; this is the same amount as G in Step 2 B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amount of the Balancing Account H. Enter the net change in the Wholesale Revenue Coverage, if applicable i. Calculate the total revenue deficiency or surplus (G) + (H) J. Enter the projected water sales to Wholesale Customers in Ccf K. Calculate the required increase in the commodity portion of the rate by dividing (I) by (J) L. Calculate the required increase in revenues by dividing (I) by (C)
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
REFERENCE ARTICLE 5
ATIACHMENT N-2
SCHEDULE 1
EXPENSE CATEGORY CONTRACT SCHEDULE
REFERENCE REFERENCE TOTAL DIRECTDIRECT RETAIL WHOLESALE REGIONAL
JOINT EXPENSE
ALLOCATION
FACTOR
WHOLESALE
SHARE
OPERATING AND MAINTENANCE EXPENSE:
SOURCE OF SUPPLY
PUMPING
TREATMENT
TRANSMISSION & DISTRIBUTION
CUSTOMER ACCOUNTS2
5.05 (A)
5.05 (B)
505 (C)
5.05 (D)
5.05 (E)
SCH8.1
SCH8.1
SCH8.1
SCH8.1
SCH8.1
953 $
i82 $
053 $
232 $
!13 $
/' \/:/"\~. , \'
$ p,!,g~:~t:d\ "ANNUAL USE'
- /:~ '\ ,4'8';8t, \Af'NUAL USE',- cr,. ,.$, \, *~5,Ò:5a 'ANNUAL USE' ,,,:'r"~,\\ 'i¡'1 !!23,is2.!l46\ ANNUAL USE'
i\;fÌl4\$,\i) :(/\;.)V 2%
\ ' \ \, \\v"\O\
15\1M)) k) si~79,572
._~~:.:
$
$
$
$
$
9,364,568
334,210
20,821.372
15,902,690
151,044
TOTALO&M
COMPOSITE % (WHOLESALE SHARE I TOTAL O&M) 5.06 (C)
46,573,883
42.07%
ADMINISTRATIVE AND GENERAL EXPENSES:
COWCAP
SERVICES OF SFPUC BUREAUS
OTHERA&G
COMPLIANCE AUDIT
5.06 (A)
5.06 (B)
5.06 (C)
5.06 (D)
$ 1,238,009 COMPOSITE O&M $ 520,857
$ 14,286.867 ANNUAL USE' $ 9.770,788
$ 8,962,586 COMPOSITE O&M $ 3.770,749
$ 200,000 50% $ 100,000
$ 24.687,462 $ 14.162,394TOTALA&G
PROPERTY TAXES 5.07 $ $ 1,417,293 ANNUAL USE' $ 969.287 CAPITAL. COST RECOVERY
PRE-2009 ASSETS
DEBT SERVICE ON NEW ASSETS .,.-,
REVENUE FUNDED ASSETS - APPROPRIATED TO WHOLESALE CAPITk.bfuAi,ci\ \~. " ì?~ '- -\ '--\~A\\ \ \"\ \ \.
'\ \\'~ '\ '\ ,/-'
\\\:\V~~\\:/.)
\;\"\;/
TOTAL CAPITAL COST RECOVERY
\ .-
.'b.OS ,
.S:04(Äl"'
. 8,04,(B1
WHOLESALE SHARE HETCH HETCHY WATER & POWER 5.04 SCH4
$ 24,051.326
$ 17,952.931
$ 8,381,400
$ 50,385.657
$ 28,903.512
$ 140,994,733
$ 4,488,233
WHOLESALE REVENUE REQUIREMENT
. WHOLESALE REVENUE COVERAGE'
'Proportional Annual Use (68.39%)
2Water Enterprise Share of Customer Accunts Expenses (62% of Total Customer Accunts Expenses) '25% of Wholesale Share of Debt Service
''1
WHOLESALE REVENUE REQUIREMENT SCHEDULES
WATER ENTERPRISE CAPITAL COST RECOVERY - ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.04.A
ATIACHMENT N-2
SCHEDULE 2
5,561,386 $ 56,181,932
1,276,338 $ 10,919,$';
4,285,048 $ 4§,21,1;1~;~
( " '\\ ~~'\ '\
- /\\$, 156,18'hS'S2 '\/ I"" \ \.~" '\,;;, \ -c' ~ \1019V~i3,t\:? 'A ~ \'.:,\ \ $\ '46.211j4 ir;". \ ',"\ ~ '.' '. \ \. ,ii//\(. ~ 1 ,~ \\ \, \. \, \ \ .._.:/INTEREST PAYMENT (NET) $ 23,3/5~3\,388J~ '()~\51?1.;ee \, \, \) RETAIL PROJECTS $ ,Jf~4P96~ $~ ,1~716!,93,8;d-'REGIONAL PROJECTS A \;~'s¡~~8~, ~~ \ ~~~t.Jl48 ':)~ '\ \ '\ \" __\\ \ '\ \/3.1
TOTAL PRINCIPAL AND INTEREST PAYM,StJT \ \ "\\3~\\1Â~~~ \¿i '5,561,386 RETAIL PROJECTS ~ \ " \ \ \ l \0~1WÍ? ~?~ 1,276,338
REGIONAL PROJECTS \ \ \ \ \, \:/~?l;~95'J6 4,285,048
\ \ \ \~;;~~ /~\ ~" \, \, v \\;//" 68.39% 68.39%
\' \ .'?
\:\1/" $ 15,022,387 $ 2,930,544
USE OF BOND PROCEEDS
RETAIL PROJECTS
REGIONAL PROJECTS
PRINCIPAL PAYMENT
RETAIL PROJECTS
REGIONAL PROJECTS
INTEREST PAYMENT (GROSS)
RETAIL PROJECTS.
REGIONAL PROJECTS
INTEREST PAYMENT (CAPITALIZED)
RETAIL PROJECTS
REGIONAL PROJECTS
PROPORTIONAL ANNUAL USE
WHOLESALE SHARE
2006 BOND
ISSUE SERIES
A
2009 BOND
ISSUE ALL
SERIES
XX BOND
ISSUE ALL
SERIES
xx.xX%
YV.YY%
(';,~)\ "\.\
7" (~Ç\ ",~l \/'_~ \\ " \ '- ,\ '? . \
(í~ '\ '\ \\ \ \ \,il. '?"- \c' , '\ \ \, , /"'.' ' ,
~ \\ \ \\'\- \~. ~~ \ \)-1 \\ 'i ~\' '\" ,,\../ ./
\\)\~ '\'" \.,), '1;:/
\ /)', 'J, ''i
"-¿/
zz.ZZ%
Note: Allocation of bond proceeds shown are for illustrative purposes only. Regional projects wil not include bond proceeds used to construct or acquire assets capitalized prior to 7/1109. Regional projects also wil not include in-city groundwater or in-city recycled water projects.
2-008 BOND
ISSUE ALL
SERIES
31.61%
68.39%
19.42%
80.58%
22.95%
77.05%
$
$
$
8,765,000
2,770,617
5,994,384
$ 23,353,388 $
$ 7,382,006 $
$ 15,971,382 $
68.39%
XX B-OND
ISSUE ALL
SERIES
XXBOND
ISSUE ALL
SERIES
"';.-:
. '" .
XX.XX%r\XV'
YY.YY~// \ '\ \\ 'i\ _ '-'\ ;1\
(~~\\ \)) \\~A
\ \- \ \\ \\ ~~ (r-'~.
'\,\\ )\S\;5? -
v'~'/
zz.ZZ% zz.ZZ%
XXBOND
ISSUE ALL
~ SERIES
TOTAL ALL
OUTSTANDING
BONDS
xx.xx%_
YY,YY%
$ 8,765,000
$ 2,770,617
$ 5,994,384
$ 85,096,706
$ 19,568,875
$ 65,527,831
$ 37,679.774
$ 11,428,961
$ 26,250.813
zz.ZZ%
$ 17,952,931
(TO SCHEDULE 1)
WHOLESALE REVENUE REQUIREMENT SCHEDULES
WATER ENTERPRISE CAPITAL COST RECOVERY. REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009.10
REFERENCE SECTION 5.04.B
ATIACHMENT N-2
SCHEDULE 3
ALLOCATION
FACTOR
TOTAL ALL YEAS
APPROPRIATION ACTUAL
ALL YEARS EXPENDITURES
PROJECT
APPROPRIATION CLASSIFICATION
WHOLESALE
SHARE
FY 2009-10 ACTUAL ENCUMBERED, NOT APPROPRIATED,
EXPENDITURES EXPENDED UNENCUMBEREDBALACE/,~
CUH980 Treasure Island Improvement Project
CUW253 Facilities Security
CUW260 Local Water R&R
CUW686 Automated Meter Reading System
Total Local
CUW202 Replace Prestressed Concrete Cylr Pipe
CUW261 Regional Water R&R - Storage
CUW262 Regional Water R&R -Treatment Facilities
CUW263 Regional Water R&R ConveyancefTransmission
CUW264 Regional Watersheds/ROW Management
FUW100 Regional Facilities Maintenance
Total Regional
TOTAL ALL PROJECTS
/Ý~r' ,/j0.0% $ $ - $ _ ç :./):~\ \0.0% $ $ - $ _ '(\ '\ -Ç,~ \ \0.0% $ $ - $,;:';"-'. \1\\ '. .~$ \, \$ $ , '\ /' , , ,.",\, \~ \ \0.0% N''", \"" " '.\ 0\. _.\ ',, ,j$ $ '( $1\',~;J!\''\ \"~.;:1 ~.-.;~., \\ "" 'l. :. -..~.1: ~~"'\ \ \',\ \'\ "~ Ç..r\-)
68.7% $ $ ...\ '/\\.\ \'.'l~ '\')\\~¡.t - $
687% $ . $' \ '. ",¡ - \ $" ) .;' . $
68:7% $ 68,7;106' $'\ \, 6£,'7:'000 ''$;'/ 235,000 $
68.7% $ .., 4,89g,Dûa\ ~\ \\ '4SQ9,r).O $ 1 ,395,000 $
68.7% $,,\. \\ 343'\5~0\\ $:,. \', ,9A3,500 $ 115,000 $
68. 7~;"~\ '\'. ~,541..OÐ " .~ ""... 2,541,900 $ 850,000 $ . v-\ ;í (",$\.i. ..'\8\381\00. i So 8,381,400 $ 2,595,000 $ ~..7~)h \\ '\ ~\ \\ '-~~ \. ,.~..,'
;.\ \/( \ \ \ \$,1 '-\ \, \8.;i)1,400 $
~;;'.--\ '\ :,\'''\''_ \ '\ \\ V.J J \)/\\~\ \ '.\ ~\.. \ \ \ ,," i.'~;'::\S,\~;i~;~,jr.~\J v.
\ "\ \. ". \.\.~t;
\ \\ \;.'
3,800,000
500,000
22,347,520
36,001,000
62,648,520
1,000,000
7,000.000
500,000
3,700.000
12,200.000
74,848,520
RETAIL
RETAIL
RETAIL
RETAIL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
$ $
$ $
$ $
$ $
$ - $
$ $
$ $
235,000 $ $ 452,000
1,395,000 $ 25,000 $ 3,389,000
115,000 $ 50,000 $ 178,500
850,000 $ 123,000 $ 1,568,900
2.595,000 $ 198,000 $ 5,588,400
8,381,400 $ 2,595,000 $ 2,595,000 $ 198,000 $ 5,588,400 (TO SCHEDULE 1) (TO SCHEDULE 1) (TO SCHEDULE 1)
ATTACHMENT N.2
SCHEDULE 4
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF WHOLESALE SHARE OF HETCH HETCHY WATER & POWER FISCAL YEAR 2009-10
REFERENCE ARTICLE 5
JOINT
ALLOCATION
PERCENTAGE
WATER-
RELATED
TOTAL
WHOLESALE WHOLESALE
ALLOCATiON FACTOR SHARE
POWER
SPECIFIC
WATER
SPECIFIC
CONTRACT SCHEDULE
REFERENCE REFERENCE JOINTTOTALEXPENSE CATEGORY
,..-:..:":\
../,,:-;:, ::../
45% .. ,_ $.:Ji\0~~~,038
\~)~~:t:
" '45~,\) $
\4500 $
45% $45% $
OPERATION AND MAINTENANCE
OPERATION
MAINTENANCE
TOTAL OPERATION AND MAINTENANCE
ADUSTO PR~:TIONAL ANNUAL $
ADUSTED PROPORTIONAL ANNUAL $
uSE _
$
7,484,165
4,831,890
12,316,055
31,853,965 $
5,048,039 ~
36,902,004 $
9,557,861 $
3,238,622 ~
12,796,483 $
3,200,394
8,581,951
11,782,345
44,612,220 $
16,868,612 ~
61,480,832 $
5.0881
5.0881
SCH 8.2
SCH 8.2
$
ADUSTD PR~~TIONA ANNUAL $
ADSTED PR~~TIONAL ANNUAL $
ADSTD PR~~TIONAL A.NNUAL $
ADSTD PROPORTIONAl ANNUAl $
USE _
$
ADMINISTRATIVE AND GENERAL
COWCAP
SERVICES OF SFPUC 8UREAUS
OTHER A&G
CUSTOMER ACCOUNTS
TOTAL ADMINISTRATIVE AND GENERAL
348,968
1.959,603
3,280,434
$ - $ :".1,139,579
5,375,656 $ 2,879,65.1" '$"..\ \'" ',\ ',\ '." .14,913,071 $ c(?6,~(~\~\ ,)a'6,,34Q' 347,403 L6\""'. ":I",. ':$\\"'. ',"..'.
20,636, 9P:(¡'~2~~~,72\~~ ,\ \t,T71 ,919'
. ~:/~~~\\\'\ \-.~\t,\ \ ",-_."
452.000~ f,\.?\\ \\;;s\j i\\) v - $ 456,305
\~~~~~\S,j
512,811
2,879,651
4,820,623
5.0882
5.0882
5.0882
5.0882
SCH 8.2
SCH7
SCH 8.2
SCH 8.2
1,139,579
8,255,307
25,581,481
347,403
5,589,004$ 8,213,08535,323.770
ADSTD PROPORTIONAL ANNUA!
U" 139,73245% $ 205,3375.0883 SCH 8.2PROPERTY TAXES
CAPITAlCOST RECOVERY
PRE-2009 ASSETS
DE8T SERVICE ON NEW ASSETS
REVENUE FUNDED ASSETS-APPROPRIATIONS TO WHOLESALE CAPITAL FUND
TOTAL CAPITAL COST RECOVERY
3,118,033ATT K-4
SCH 5
..§,CH~'\
\~~~~~\.\.;~,)
\-:.Y'~-;/
5.0981
5.0982
5.0983 7,740,688
10,858,721
$ 28,903,512
(TO SCHEDULE 1)
WHOLESALE SHARE OF HETCH HETCHY WATER & POWER
WHOLESALE REVENUE COVERAGE'
'Adjusted Proportonal Annual Use (68.39% X 99:50% = 68.05%) 225% of Wholesale Share of Debt Service
WHOLESALE REVENUE REQUIREMENT SCHEDULES
HETCH HETCHY CAPITAL COST RECOVERY - ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.09.B.1
ATTACHMENT N-2
SCHEDULE 5
XX BOND XX BoND XX BOND XX BOND XX BOND )(OND-XX BOND TOTAL ALL
ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL OUTSTANDIN
SERIES SERIES SERIES SERIES SERIES SERIES SERIES G BONDS ,,/\
USE OF BOND PROCEEDS
POWER PROJECTS
WATER PROJECTS
JOINT PROJECTS
PRINCIPAL PAYMENT
POWER SHARE
WATER SHARE
JOINT SHARE
(-s~~;:~\i. ' \ ,\ ',\ ~ .~-, 't/\-'?'
\\\ \\\" \\v');.0'\'~)I\"~ -
\. ,i .;,)...:.;/
xx.XX% XX.X?%~./j,/ .)Ó( XX%_YV.YV% yv.'f.% \ f / Y'( YV% ZZ.ZZ% d'~z:d.z~, \ . .' Z; ZZ%
r \0.\\1\\\' .\'."'/"
" '% ~ I " '\, \ \ \ ~.r ~.,\"V.._\ 'i," -" r'.. \'~.;.' "\\./A \';/ \\ \t\ ~\ .1\ \/~
. n \\./y"Y) Il' .) ~ ." ') ';. -'\~.l
XX.XX%
YV.YV%
ZZ.ZZ%
XX.XX%
YV.YV%
ZZ.ZZ%
XX.XX%
YV.YV%
ZZ.ZZ%
XX.xx%
YV.YV%
ll.ll%
ADJUSTED PROPORTIONAL ANNUAL USE
WHOLESALE SHARE
(~~~\
/'. \ '-\\
/" (:-:-j\\\f:~~~:;~\\,/\ ~" \\\\\1\ \.,\ \ v/Ä-~.\-\~' t.-;.\ ','l\:...¡-:r '\ \1 ~\ \ ~ \ -\'~ '\ //1 /" '0.-\ \\ ,\\ \\ '. ," ..""".:..:' \\:; i' ~\ l\ :\.\ "\ \'Í ,;.'\ i¿) Ji \\. '.' \" 1,, '-, .\. l '" \\ ~ ;; :r\ : (\ Y/\"\ \ -f" '\ \\ 'f~'-¿.~
. . \ -" -\ '--':, \ \~ '\ \ V;:J
/",\ \. \ '\ \, '-". \, \ \ \y~
f ~~ \,., \ ~-r '--.'') ,\ \ Ç¡\ -v 0.", '" \)8\05" /\\,\ ,,68.05 Yo \\\~~~:_;~~) \;;J .
'Water Related = 100% of Water Share + 45% of Joint Share\ \ \ ./ )./ \:~\/'''-
INTEREST PAYMENT (NET)
POWER SHARE
WATER SHARE
JOINT SHARE
TOTAL PRINCIPAL AND INTEREST PAYMENT
POWER SHARE
WATER SHARE
JOINT SHARE
WATER RELATED PRINCIPAL AND INTEREST PAYMENY'
68.05% 68.05% 68.05% 68.05% 68.05%
(TO SCHEDULE 4)
WHOLESALE REVENUE REQUIREMENT SCHEDULES
HETCH HETCHY CAPITAL COST RECOVERY - REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009.10
REFERENCE SECTION 5.04,8
ATTACHMENT N.2
SCHEDULE 6
APP~~~~~;;ION CLASSIFICATION W~~~~E'¡~~D WAT~~rTED
ALLOCATION
FACTOR
WHOLESALE
SHARE
TOTAL ALL YEARS
APPROPRIATION ACTUAL
ALL YEAS EXPENDITURES
FY2009.10ACTUAL ENCUMBERED NOT APPROPRIATED.
EXPENDITURES EXPENDED UNENCUMBEREDBALNCE
CUH931
CUH977
HH Microwave Replacement
HH Water R&R - Facilities Maintenance
Total Joint
CUH947
CUH971
CUH976
CUH979
CUH983
CUH986
SEA. Go Solar Incentive Project
Alternative Transmission Studies
HH Water R&R - Power Infrastructure
Hunters Point Municipal Power
Civic Center Sustainability District
General Fund Dept - Energy Effciency
Renewable/Generation
Treasure Island Improvement Project
Enterprise Fund Dept - Energy Effciency
Total Power
CUH975 HH Water R&R - Water Infrastructure
Toulumne River Watershed Protection
Total Water
TOTAL ALL WATER RELATED PROJECTS
4.000.000 JOINT
3,500,000 JOINT
7,500,000
4,000,000
1,000,000
16,700,000
1,090,000
7,365,158
3,501,307
2,700,000
325,722
36,682,187
6,000,000 WATER
2,000,000 WATER
8,000,000
96,364,374
AOJUSTEDPROPQRTlON ./.:~~(~' -..,-1,800,000 ~'u"- u" $ 1,224,900 $ r Å,~4,w(r\ $ 1,575,000 AOUS~DN~~l~TlON $ 1,071.788 $,"" '~.1.)i7,.)7-éa 'li 3,375,000 $ 2,296,6ßS \;'$:",\i2~Se:eaá $. \
AlU~lI:.UI'UIl.IlUNA ,f''' '\\ \,) .!\ ,\, -"''. \,'0% $ ANl1AlliSE AUU~'I:U..OIUtI'UNANNUA USE
AUU~II:Ut-U+OHlrlJ
0% $ ANUAl liSE ,:..
0% .. AUu,¡i,~.~~~W./'~
0%
0%
0%
0%
O%'
c.', :ri:~t\v,.~,,\ '\~~\\
.(\ \ \\ i....:C~on~ ~ \ ...;~/6,000.000
..r,., \ \ \ \. ."'.-.... 1-Do.o/¿~ $_, 2,000.000
\, '\ \. \\ '\('G1)) \;. $ 8,000.000
. \ \., ,.\. \-) .~J '..-.:/
\.;,~\:;\'";:. $ 11,375.000
)'\~'
POWER
POWER
POWER
POWER
POWER
POWER
POWER
POWER
POWER
45%
45%
0%
\')
PU:iltil"UlIIUN
ANUAl use
AOSTEOPRoPTION
ANNUA USE
4,083,000
',361,000
5,444,000
7,740,688
4,083,000
, ,361.000
5,444,000
7,740,688
1.224,900
1,071,788
2,296.688
4,083,000
1,361,000
5,44,000
1,224,900
1,071,788
2,296,688
4,083,000
1,361,000
5,44,000
7,740,688 $ 7,740,688 $
(TO SCHEDULE 4) (TO SCHEDULE 4)
$
(TO SCHEDULE 4)
WHOLESALE REVENUE REQUIREMENT SCHEDULES
SERVICES OF SFPUC BUREAUS - ALLOCATION TO ENTERPRISES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B
ATIACHMENT N-2
SCHEDULE 7
ADJUSTED HETCH HETCHYEXPENDITURE ADJUSTMENTS EXPENDITURE POWER S S
HETCH HETCHY
WATER WATER RETAIL WATER REGIONAL WASTEWATER
/;;..'"\
TOTAL
ALLOCATION FACTORS (SCHEDULE N-7.1)
PUC01 General Manager $
PUC1101 BizServ-Administration $
PUC1102 Finance $
PUC1103 ITS1 $
PUC1106 Human Resources $
PUC1108 Customer Services $
PUC12 External Affairs $
TOTAL $
//0\/~" r~..16.94r. r(~~"" 29.59%
\(~\ '\ "~~\ \ \
$ 453.820 $1;2à)88~'\$.. '\ ë' ~~!51,548, . ,. ,\",' \ '.~ .,,' $ 243,456 $-.\\6:Yti31 \)1\\" 1,207.864
$ 525,902.~ (\ 1,;19S,f;0~ :$/v\\P 2,609,166
$ 966,959 . 5 \ \2\t4~~~ ;$ 4,797,391
$ 4~7,9$8 $ ", \, '~,3Qoìt'34't'$ 2,272,074$ r/" (\ -', $, \ .~...) \...- $ 432,263 $.. t',. " \?'Q1\556 ,$'. \/657,637 $
.!/':":~'\ \ '\.~\ \" \ .-\. \ \34,752.000 $ (12,731,000) $ 48.282,521 $ 5,375,6.56 ¡'$ c,;'" . \ '.\ ~87,g,65i ":V 8,178,424 $ 14,286,867 (TO SCHE9_ULt't)'\ttO¥~l:~U.U¡\È.M/ (TO SCHEDULE 1) (TO SCHEDULE 1) :r"'\~\\ \J'\ '\.\ ...'
\ il .r \,\ \. .. \.//\ ( ). j !,( '!\ "\"\ ''\.."\ ~
\\ \'\ '\ \ -,\1 \"- \1
,\ ,-.~; '\ \'~ "~ ;\ ::\ \ ~ 'Y;'1
".\ ' " \ \, \ \:J !j ",)-
, ,slf~~~\(~0~~~\~\ \~~j .c\ \\.'.".M~'I ,-;)"\ '\ \ \\ ?,\( '0., ./' \' \\ J\ "j '\ ;/ (-\ \ \ '-"\ '~"l 0 J '",::.:/
\ \ \ \ \ \;:;\\..-~;..)
\ \ \ \..;:./\\./ ~)
\ \."\ ))~;.r
\, \\.;;//
\;-;..
7,609,114 $
4,081,981 $
8,817,687 $
18,048,158 $
7,678,483 $
12,262,428 $
3,882,455 $
$
$
$
(1,835,357) $
$
$
$
(12,262,428)
'Adjustment for Transfer of SCADA Expenditures to T&D Joint ($1,730,000)
11.13%
7,609,114 $
4,081,981 $
8,817,687 $
16,212,801 $
7,678,483 $
$
$
847,180
454,478
981,739
1,805,093
854,903
3,882,455
5.96%
1,148,824
36.37%
$ 2,767,682 $ 7,609,114
$ 1,484,749 $ 4,081,981
$ 3,207,280 $ 8,817,687
$ 5,897,123 $ 16,212,801
$ 2,792,914 $ 7,678,483
$ $
$ 1,412,175 $ 3,882,455
$ 17,561,923 $ 48,282,521
WHOLESALE REVENUE REQUIREMENT SCHEDULES
SERVICES OF SFPUC BUREAUS - ANNUAL SALARIES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B
ATIACHMENT N-2
SCHEDULE 7.1
DEPARTMENT/DIVISION ALLOCATION GROUP
FACTOR CODE SALARIES PERCENTAGE
HETCH HETCHY
POWER
WATER
JOINT
WATER SHARE
POWER SHARE
1 $ 6,677,939
2 $ 1,775,910
$ 9,428,450
45% 2 $ 4.242,803
55% 1 $ 5.185,648
WATER
ADMINISTRATION (WTR01)
RETAIL SHARE
REGIONAL SHARE
HETCH HETCHY WATER SHARE
33.4%
33.3%
33.3%
$
3 $
4 $
2 $
1,009.246
336,415 .,'
336,41h\\
33"'116, \'\!
\¿\\'\ \... ~,\
3 1"~:7;3~é,~~ \ \
./c. :\,~~\4 '~\\1~~~~~i;)\)
,'\ if ,~.:\" ,,\ ~ $\ ':18J184.689
.' ;;:;~.~\\\ \:\ '\ \\ ~ \ ..~~~'NATURAL RESOURCES (WTR06) , ...... \('\(';/\ \ \\\'J :\ \~ '4:",$ 4,682.073 WATE~ RESOURCE PLANNING,;;;,'r~), n. \ \ \ \\ '.j' $
WATER CONSERVATION ..,(')\ \;: :i '\ Ù \, \ \ \;/ 3 $
RETAIL WATER RESOURf;i: F-'nNNIl\'G¡. '\\..."\.;.'(/ 3 $ REGIONAL SHARE (Ni.r\S\;1-Ã~I~~l,'\ \'i\ .:~;I ~ 4 $
'- ' . " ,,\" -'" " ~,'
CDD(WTR03)
WATER QUALITY (WTR04)
WATER SUPPLY & TREATMENT (WTR05)
1,419,760
355,703
1,064,057
WASTEWATER \ ) 5 $ 38,757,578
SALARIES BY GROUP COOE ,
HETCH HE'Tel\jy. ,.f'oÌNE'" . 1 $ 11,863.587
HETCH HEl-y),i'Y'-IkÀTÈR 2 $ 6,355,129
\\\/v
$WATER - RETAIL 3 18,049,040
WATER- REGIONAL 4 $ 31,529,823
WASTEWATER 5 $ 38,757,578
TOTAL SALARIES $ 106,555,156
6.27%
1.67%
3.98%.;,,~")
4.87% V ,.;10', ,
(~~~\:~',ìO'3';'t\ v:;v
\, \:) .,t ,~,) -'"
)-&~1'9%
6.83%
17.05%
4.39%
0.33%
1.00%
36.37%
11.13% (TO SCHEDULE 7)
5.96% (TO SCHEDULE 7)
16.94% (TO SCHEDULE 7)
29.59% (TO SCHEDULE 7)
36.37% (TO SCHEDULE 7)
100.00%
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
WATER ENTERPRISE SUMMARY OF OPERATING EXPENSES
ATIACHMENT N-2
SCHEDULE 8.1
- $ 23,252,946 $ .J)~\A1'6';;32
- $ - L2:~"- -
- $ . 23,252,9~6l$\'\L\~11h\~
- $ 13:.Rer."8.~~\ \.~ \~t¡~43,g,~~
1~,i,t-\t~ \~'~~'~~~~g43,9~~
/\ .,\ i: ' 'Ii \ '\ \;)l:)
3,854,000 $ ,'; (', \',,- ,,' ~ ag-S f\~Y. $" 4342682\ ~ '\ ;/. i i$1/-" '\ ,$ "\ \. '.;:: - $ 3,854,099 $( fi~\\~\ '; "~$\ \) 488,682 $'r \. \'\ l~ ,.\ .'"\" ,\ \ \\ \\Ì\ \\ \ ,j-$ (', , \ $'\ , \, \ \ \\ )\.\'/$ 30445053("-", \ \ \~ \ '\ \ ) \ \', - $ ,-' '. "","' \$ , / $--\-\..\L.'-tr\_\~--i -"/'$ \\ \\ \ \, \\ \~. $ ,-,j - $ ..\; ",)~. \ \.' ,,\ \ \ '\ ~\
,~- .\ \~/~ ~l. \ '\ \. \ ,:) ':\ \.\ '0)Customer Accounts ,//",: \ ",~ \'S \, \ ~;'4Ó'1/j 69' $ Adjustments to Customer AgÇ0U~~tSt)¡ \ ': \~ \l~ \) ,_:/ - $ Adjusted Customer ACGéÙ!:i\s" ~) \ ,"", ¡~ ~, "\;r-7,401, 169 $ I \v , \ \ ' '\ /\ "d~4 r\\ Q::/ 1" '" \'\ \\ \1 '"
Total Adjusted opar~tli;91\EXPè.rse,\ ,\" ,,,:i;; $
'f\ ~" \"\" - " "" 'V\' 1I'~,'\j ~"\\\\\
GeneraJ\\~~drr!~istrat'ive ~\pén);e \?
COt(It'AI"? \ '\ \'\D' ,-.:/" ~ \ \ \ \ ")" ,
Servi.h~\ò~ S~'ltJC\l3ureaus
\ \'\ \~../\\//~J)
Other èlJ~'erai-'&Administrative
Adjustm'aMs to General & Administrative
Adjusted General & Administrative
Operating Expenses
Transmission & Distributions
Adjustments to Transmission & Distribution
Adjusted Transmission & Distribution
Source of Supply
Adjustments to Source of Supply
Adjusted Source of Supply
Pumping
Adjustments to Pumping
Adjusted Pumping
Treatment
Adjustments to Treatment
Adjusted Treatment
Compliance Audit
Total General & Administrative
Propert Taxes
Total
Source: FAMIS/EIS
Note: All adjustments to be separately identified above Retail Regional TotalWholesale
$
$
$
30,163,286 $
- $
30,163,286 $
$
$
$
1,251,062 $
- $
1,251,062 $
$
$
$ 4,342,682
$
- $
30,445,053 $
30,445,053
30,445,053
151,044 $
- $
151,044 $
- $
- $
- $
7,552,213
7,552,213
42,669,517 $ 151,044 $ 67,879,572 $ 110,700,133
$
$
$
8,178,424 $
$
- $
1,238,009 $
14,286,867 $
1,238,009
22,465,291
$
$
$
4,009,891 $
- $
4,009,891 $
- $
- $
- $
8,962,586 $
- $
8,962,586 $
12,972,477
12,972,477
$
$
$
$
100,000 $ 100,000 $ - $ 200,000
12,288,315 $ 100,000 $ 24,487,462 $ 36,875,777
- $ - $ 1,417,293 $ 1,417,293
54,957,832 $ 251,044$ 93,784,327 $ 148,993,203
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
HETCHY HETCHY WATER & POWER SUMMARY OF OPERATING EXPENSES Operating Expenses
Purchased Power & Wheeling
Adjustments to Purchased Power & Wheeling
Adjusted Purchased Power & Wheeling
Operations
Hydraulic Generation
Transmission & Distribution
Water Quality Expense
Adjustments to Operations
Adjusted Operations
Maintenance
Hydraulic Generation
Transmission & Distribution
Water Quality Expense
Adjustments to Maintenance
Adjusted Maintenance
Totat General & Administrative
Propert Taxes
Total
Source: FAMIS/EIS
Note: All adjustments to be separately identified above Power Water . Joint
$
$
$ 28,953.676
28,953,676
$
$
$
$
$
2.900,291 $
$
- $
- $
2,900,291 $
28,95i6î6
\~;;J;"'\e
A ,,¡/'\ \ \;.~ \ \- $ 3,200,.~~-'\ ~\ ',~ \ ~.1('Öu,t'S5, ~ $ .., \ /\ \$,\ .\;, \ '\ \ \;~')9,557,862 $ (' \ \ ';),$.)/' '9JS57,862 - \t;~~~~\~t~rr\y/ -9,557,.e6,f ,$\( ,\ 3.~O\')í3~, \~ 15.658,547 . (-ù '" \., \. \ v if "i', ((\" ~\\ "~\ \';:Y
$ 1,840.096 $ r"" 3a\~\r\ \-')8,581.952 $
$ 3,359) 8t\ $ \\ \( \\.,l::. - $
$ -;' \ \$ \ \ ,; /$ - $$ ,. :ßt" , \\ \~. \ ',¿; ) - $ - $~, ,7' . \ -'ç.,..:S/~:\. \.~,o ' $\ 3;,,38,622 $ 8,581,952 $~;" 't/. ,/' \. \'~\ \;) Total Adjusted Operating Expe~:~I\~~:,;'\\ \~:~\\\~~:'?:~2P¡( $ 12,796,484 $ General & Administrative ExnehS~;'\ \) ) \ "" \ ~\'
COWCAP " '. . . " /11 'i. ,.
Services of SFPUC,Bùr~\ä.ui;~ \\) $
".\ \ \\\ "t,'" \ v'Customer_~cc~l!rts \ \ \ \ 'í 'J,¡
Adjuslrt 0'f~stoiiap ;~c'chts
Adjuste o,,~r:~ibo.uHts
:..~~"
Other ~.&;:Administrative
Adjustme to General & Administrative
Adjusted General & Administrative
$
5.375.656 $
$
$
$
347,403 $
- $
347,403 $
$
$
$
14.913,071 $
- $
14,913.071 $
$ 20,636,130 $
$
$ 57,538,136 $
$
2,879.651 $
- $
- $
- $
36.070 $
- $
36.070 $
2,915,721 $
- $ - $
15,712,205 $
11,782,346 $
1,139,579 $
- $
10.632.340 $
- $
10,632,340 $
11,771,919 $
452,000 $
24,006,265 $
Total
$
$
$
28,953,676
13.660,670
3,359,385
(151,42)
16.868,613
61,480.836
1.139.579
8,255,307
- $
- $
- $
347,403
347,403
25,581,481
25,581,481
35,323,770
452,000
97.256,606
ATTACHMENT N-2
SCHEDULE 8.2
'?z
I-Z
W
:¡:i
~
mw
~
w..c(m
w..o:i
3:
ozc(
~zw
:¡
W
0:
5aw0:
w::zw
¡¡
0:
w..c(m
w..o:i
3:. ..m .w c(.. .c( am ui
O:ww..
I- U
c( -
3: li
o c(
~ iiu uw z
""w00:O:w
Q. U.
U. w00:wI-.. U
:: c(
00:wI-:i zu 0m u
':",' I~/~ '
\~,~\'~'~
'0~\\\~..,...,,,~_:;. '
'l', ,/-~,X\.
~ IÐ IÐ W IÐ~~='~ ,.,..Aß0~,.,lß Ei fØ~.~r. ",-:..._;-' ,.....\" i I I I i 1\~;;:-~:-;1;~ Ii'
.~.'~..~.'.Ç.~~.f~\
\\"",,'
iÐ El iÐ iÐ iÐ iÐ El ih li fÐ ~r. tl
i ~;;~'~:'~'~'~".'?,;? i,.....~¿' I~ .~:~\
\ .,.:)
)\fr;:~
~~~~i'~?~3"r~~ ~
rõ ~ ~ g ~ \~~;~;:~~"./ ~ M 8¡ i;co_ 1"_ "'_ 0_ M_ N. ¿t..:~ v_ co_o 0 0 a C\ (J ,.._~.~.. ~ ~ r" Ll ~ t:_ r:_ ~ ~_ æç;~,~,;~¿'it.~~~_~_
en (t ~ 'S~"-;;~;~~I~)ß
fØ iÐ ll fß ff IÐ r~,.;kT~;æ: .~~~ ó9
~~:~~\~ \~::~~,~,r;-,\
\\;~/~, (,'
\~~~
1\ \\~, \\ .,_..c:':":::~
\'''';;'è.oil .1"'\ ';1
l d:.' \),()'!\;f~~~~~t~
,..."' '). ,\
0~~~~_::~;~f\~\_.,'- ':) \\
~:-:':~;::$.
..+Z
ElElIÐElfß fh
'"+Z
0:
Li
)- N
-' +
c( Zu
m
u:
'+
z
iÐ tl Eß Eß tl ~
COONe.. ..CD T" f' en v !X
l( N (' CD a !X
oq- -q- ~ c,r r-- C'(0 C" N a U' ..Z C" (l 00 m ,. '"
m- 0- i. inN ~ ..
IÐWtflÐER~
mwmzw0-
XW
m ww um zz c(w Z0. Z W(i 0 I-W ¡: ~~ ¡¡::c( iimClz I-I-Z ~~ ¡S~ ~~~ ~§ 0
ClUl Oo: ~
.~ ~ ~ ~ ff ~z~~::~~ 0
Qo: o.!;z I- -'1-::::uJo:Ul ~
~ O:: 0: ii:: 0
wmo.i-i-U I-0.o
El iÐ Eß Eß fl
mwm
z
w
0.XW
Ul -'~ ~Z WW Z Z0. 0 WX ëi Clw m 0;J ~ zii:: o:wowz u ;:w m I-Cl w I-o:o ¡: 0 ii~ :J ~ ~ .. ¡: Z~ ::Cl~ ~
¡:O-~~~ Cl
~ê3ã:o::J :3~s:~~~ ~ZOlLl-O 1-0~UUlOu
Cl
o:
~ ElliW fl
~ Ei Eß Ul El
lßEßll (f
mw
g
~
W
0. o0:0.
m ~
ti w
m -' 6
~~ u
s: ii ~~ wo: t:
w z U w;:mZO 00i-OW uUWw§1-'wmu:: ~
~~5lL iim CJ 0: W ~00 W:: ~u¡;~~ o:i--'
-'wee;:~ 0: W W 0
ii 0. Cl 0: I-
ê3
~
~
~
~
N
u;
C'o
CJ
in
N
0. ~:i:i
w0:o::i
Ul
w-'
~w-'o:i
s:
J
J
J
J
~
El ll tl El ER El Eß fl
tltlEßtltiEßEß Eß
ti fl tl El El lß Eß fF
El W ll ll Eß El ó9 lß
S i 0000o a C\ (I0) aNN
It- or- r- a:ai C\mco.. CJ..r-- T'-"'N~
fh fl tl Eß ER Eß Eß lß
I-ZW
::
W
Q:
::aw0:
w::Zw
ru0:
W-'
~
W-'o:i
s:
Ul Ul w
!z c ~w Cl W:: w m
w ~5~
!; :: I- W
o ii a~~",i-Clmo:oiiwZ~wo:uwz::cClwU;::: 0 m o::i o: 0
~8(i~bClUOo:i-Uo~~mClo:wZ~5o: ~ m ~ o: o:.O:I-Uw m..wZZ::mco:m::~~¡ßfieeco o:;:Uo:l-ee8ee~(iu~~o:zwwl-::wCl°-,-,zw-,zi-o:o:wwo:i3¡ß¡ß¡ß~ff¡ßZo:-,-,-'o:-,~w00I=..O ;¡~~~~~~
r- 'r!X ..
N~ i.
'" ~
oc:N
UlW
Cl
0:o::iu
w
Ul
::
mmwu
(i
oz
o:
mw::
zw;:w0:
u.o
I-
ow0:
U
0:
I- 0o~WzO:wU_ti~o u.)- w
u Cl
ZWW -'-o:u mu: ~Woo :i
~ s:
o: ~-
m zw w
-' U00::i w
s: 0.
000
000
000
000
0'" '"ON'"o . ..0 ~o
NCJ
It
!X
LL
u
~~
U. I-
U Ul
S2 0~u
I- COZ~w::u. 0: ~UuWSo:!;
Ul 0 iiw)- w
-' U -'o: zo:Ul w Ul
0:- WW U-'
I- u: 0
o:w:i
s: Cl s:
Cl w Cl
w -' WI- o: I-U Ul UWW w
e3 Ô e3
o::i ii
0. s: 0.
000000'" N '"O-f'-..-N N..'" '" N.. Ñ i-.. ..~ ~
~~~
m mWw,:: ::Zz
Ww;: ;:w w
0: 0:
w w mCl Cl w
0: o:::
o: o:Z:i:iw
u u ru
w wO:
~::w;: :: -'
0: -' o:
W 0 Ul
m ;: ~000w W:i
t; t; s:
w w-'
.... o:001-0:0:00. 0. I-
ATTACHMENT O
ATTACHMENT 0
STATEMENT OF WHOLESALE REVENUE REQUIREMENTI CHANGES IN BALANCING ACCOUNT YEAR ENDED JUNE 30
(Section 7.02.B)
FY 2008-09
Allocation to
Wholesale
Customers
FY 2009-10
Allocation to
Wholesale
Customers Difference
Wholesale Revenue Requirement Calculation:
Operating and maintenance (O&M) expense:
San Francisco Water Enterprise:
Source of supply
Pumping
Purification
Transmission and distribution
Customer Accounts
Total SFWE operating and maintenance
$ 9,133,025 $ 9,364,568 $ 231,543
$ 325,946 $ 334,210 $ 8,264
$ 20,437,460 $ 20,821,372 $ 383,912
$ 9,350,279 $ 15,902,690 $ 6,552,411
$ 224,255 $ 151,044 $ (73,211)
$ 39,470,965 $ 46,573,884 $ 7,102,919
Hetch Hetchy Water and Power (HHWP):
Operating expenses
Maintenance expenses
Total HHWP operating and maintenance
\ ....
7,484,165 $;(-2;$75,621)
4,831 ,890/'d.;t\,~05,650
12,316,0?'t\ \(:~ (~\,~69,971)
/;::',, '¡\ 1, \ \\ ,":":) \. "I,/;/ "\l ~!:- \ \\ '~ \,. ;:;/~~\\ \(J )' \\ \\) ,,\~\) '~~
/l\ \\ ((~ "~ ': l. i\. I(\¿
$ 512,438;~ fi $ \ \\i 'g?,q;iiÆ(0 . $ 8,419
$ 1e2~e4'(" \! :i $ \ \\J ~4ß),68 $ 186,604\(\~.. '\ li (, /J :"""' "., . '\ \k/
S:~O'\., \t,4~~ ,., ,y~ .9,770,788
($(', ~\~'!i . .\ '\$ 1 959 603
.- \\ '$\1\ \\ä~S':i~7,t,g;:/' $ Ú70:749\ " " ~." ') ,;" r v /'~', \ '\ \ '. $\ "':¡\:;) $ 3,280,434;':'\ \\ i.' \ $ '.".j 95338 $ 100000I !, \. \ \ \\, \. i , \ \ ) \ \ \ \,.$ 18,824,396 $ 19,751,399
\
$ 10,359,786
$ 4,526,240
$ 14,886,026
$
$
$
Administrative and general (A&G) expenses:
COWCAP
SFWE
HHWP
SF Public Utilities Commission:
SFWE
HHWP
Other A&G - SFWE
Other A&G - HHWP
Compliance audit
Total administrative and general expenses
$ 2,308,953
$ (398,019)
$ (4,464,050)
$ 3,280,434
$ 4,662
$ 927,003
p~o:~r; taxes (outside city Oniy)~,. :~:\ \) )', i\'\
HHWP ,/',\/\ \ 'I,,' \\(\;)...:.,:f ;r;'';) '\ '\ \ \\ _;,\~'', Total propert taxes ,,;:~ \\ \\ \\ """, "\\ \\ v,.
,.~ \\ \~ \\ \'".::: '\ \ % \;'"", 1\ \ \ ~ ,?\!\ ,,;)Capital Cost Re'" ~verv~, \1" 1\ \1\\ ,I¡i .' '\',.., \''0 '-'''Pre-2009 A' \ \ \/-,,~ )!
SFWE ~ ..\ V)C:/,,1,/..:\ ."/
HHWP '. \ Ý.\y',;~
Debt Service o\~JiJ~'Assets
SFWE
HHWP
Revenue Funded Assets
SFWE
HHWP
Total Capital Cost Recovery
',.~J
$ 964,040
$ 120,923
$ 1,084,963
$
$
$
969,287
139,732
1,109,019
$
$
$
5,247
18,809
24,056
Balancing Account June 30
$ 24,051,326
$ 3,118,033
$ 17,952,931
$
$ 8,381,400
$ 7,740,688
$ 46,378,941 $ 61,244,378 $14,865,437
$ 120,645,291 $ 140,994,735 $20,349,444
$ 21,176,614 $
$ 529,415 $
$ (123,604,000) $ (147,247,500)
$ $
$ $ 4,488,233
$ $
$ 21,006 $ 21,006
$ $ 1,997,220
$ 18,768,326 $ 253,694
Total Wholesale Revenue Requirement
Balancing Account July 1
Interest on adjusted beginning balance
Wholesale revenues biled
Excess use charges biled
Wholesale Revenue Coverage Reserve
Other adjustments
Settlement adjustments
1984 Agreement Balancing Account Credits
ATTACHMENT P
Attachment P
REPRESENTATION LETTER
Certification Pursuant to Water Sales Agreement (the Agreement) between the City and County of San Francisco (San Francisco) and certain wholesale customers in the counties of San Mateo, Santa Clara, and Alameda (the Wholesale Customers) effective July 1,2009.
Each of the undersigned certifies that:
1. I have reviewed San Francisco Water Department and Retch Retchy Water & Power Deparment Report on the Calculation of the Wholesale Revenue Requirement and Statement of Changes in the Balancing Account (the Statement) for the year ended June 30, 200X;
Based on my knowledge, this report and Statement do not contain any untrue statements of a material fact or omit to state a material fact necessary to make the statements made, in light of the circumstances under which such statements were made, not misleading with respect to the period covered by the report;
Based on my knowledge, the Statement and other financial information included in the report, fairly presents in all material respects the proper costs incurred and allocated to the Wholesale Customers in accordance with the provisions of the Agreement.
The below certifying officers and I are responsible for establishing and maintaining internal control over financial reporting and have:
Designed such internal control over financial reporting, or caused such internal control over financial reporting to be designed under our supervision, to provide reasonable assurance regarding the reliability of financial reporting for purposes ofthe preparation of the Statement.
Evaluated the effectiveness of the allocation procedures to ensure compliance with the terms of the Agreement.
Attachment P, Page 1
1870057.1
The Statement fully complies with the contractual requirements of the Agreement and fairly presents, in all material respects, the allocation of costs to the Wholesale Customers in accordance with the Agreement.
General Manager, SFPUC Date
Assistant General Manager & Chief Financial Offcer, SFPUC Date Finance Director, SFPUC Date
Accounting Manager, SFPUC Date
Financial Planning Manager, SFPUC Date
Senior Rates Administrator, SFPUC Date
Attachment P, Page 2
1870057.1
ATTACHMENT Q
Legend
f: 21] Service Area
- Streams/Rivers
Attachment Q-1
i l:
;=--,,----------+---�c;s ......... ;.... ______ ,.,-
Maximum Service Area - North San Jose Municipal Water
\\oakland-01\data \GISIBAWSCA\Project\2018_07 _ServiceAreas\Attach_ Q-1_SantaClara-ServiceArea.mxd 9/14/2018 11 :45:29 AM
Legend
L rn M Service Area A: Existing service area
Attachment Q-2
(Z2I Service Area B: Expanded service area, for operational purposes only . , . - Streams/Rivers
" .. '!
·1 " .:;
>lh•h
It.th
•.11•1
11 :,
GI
.,
,, ,,
(I
,•
� ..
•,t ··�
Ji ,1 l1,;.q11(r. 1,\1,,1;
,\
Cup 0 •1li110
l\lVt!:,0
\',' 'dll I
J
··'·t
.... "'------!.' \ ,.,
t �!,....i;'��--..... �::-:T���::1--"'"'."'."""',.,:r,�ol/,j,,iliol,..Q.; ..... �-.:_:.,-,� ... T ... , .. ,. ,, . ,, I· I
(
\
,,,,,., 'h
.,'"'' '; li•I
r..:..-,yr,'4111
llttlt
f I ®
Maximum Service Area - City of Santa Clara
\\oakland-01\data\GISIBAWS CA\Project\2018 _07 _ ServlceAreas\Attach_ Q-2_ SantaClara-ServlceAreaExisting.mxd 9/27/2018 3:49:40 PM I
I
i ·','
ATTACHMENT R
ATTACHMENT R – CLASSIFICATION OF EXISTING SYSTEM ASSETS 1 15049417.1
ATTACHMENT R-1
INTRODUCTION TO ATTACHMENT R
Attachment R is composed of three documents (1) this R-1 Introduction to Attachment R, (2) R-2 Special Classification of Discrete Projects for 2018 WSA Amendment Purposes, and (3) R-3 Major Hetch Hetchy Enterprise Existing System Assets. These R series attachments provide a record for purposes of maintaining the historical basis for the allocation of capital costs and operating expenses associated with Existing System Assets generally, with greater detail provided for major Hetch Hetchy Enterprise Existing System Assets due to the complexity of tracking the Water-Only, Power-Only, and Joint classifications as inputs to the Wholesale Revenue Requirement under Sections 5.08 and 5.09 of the Agreement.
Attachment R-2, Special Classification of Discrete Projects for 2018 WSA Amendment Purposes defines a limited number of capital projects involving five Hetch Hetchy Enterprise Existing System Assets where the parties have agreed to classify defined capital project costs separately from the assets’ underlying classification listed on Attachment R-3. The classification listed in Attachment R-3 will continue to control the allocation of capital costs and operating expenses once the defined capital projects described in Attachment R-2 are complete.
Attachment R-3, Major Hetch Hetchy Enterprise Existing System Assets is a record of major assets at the "facility group" level (see below) as of January 1, 2019. The table contains six columns and 578 rows. The facility groups are broken down into individual facilities or assets. The facility group name and classification are provided for each asset. Assets listed on Attachment R-3 are classified as Joint, Water-Only, or Power-Only. Each asset is also assigned a unique identification ("ID") number for ease of reference. Attachment R-3 is not a complete record of all Hetch Hetchy Enterprise Existing System Assets.
General Explanation of Classification.
A “facility group” is a location where a group of facilities is located. A single facility may constitute a facility group. A “facility” is a primary asset in a facility group whose function determines its classification and the classification of appurtenances or sub-assets. An appurtenance is an asset or sub-asset that supports the function of the facility to which it is appurtenant. In most cases the classification of the appurtenance is determined by the classification of the facility to which the appurtenance belongs. The function of the appurtenance may not necessarily control its classification.
The classification of appurtenant assets generally follows the classification of the facility group served. These appurtenant assets include security, offices/housing, and utilities serving the facility group such as domestic water, wastewater, communications and solid waste disposal.
Power distribution assets that provide power to a facility group (e.g. lower voltage power distribution lines) generally carry the classification of the facility group served, but do not include power generation or higher voltage transmission lines for export of power elsewhere, which remain classified as Power-Only. With limited exceptions for roads exclusively accessing Power-Only facilities, roads and bridges are classified as Joint because most roads serve multiple facilities or Joint facilities. Equipment and rolling stock are generally classified as Joint unless the asset has a specialized purpose serving the Power function. Capital costs and operating expenses related to Camp Mather are charged to Power in order to segregate these costs from the Wholesale Revenue Requirement.