in
Alameda County, San Mateo County and
Santa Clara County
Page | ||||
Introduction | 1 | |||
Article 1. Parties, Effective Date, and Defined Terms | 1 | |||
1.01 Definitions | 1 | |||
1.02 Parties | 1 | |||
1.03 Effective Date | 2 | |||
Article 2. Term; Amendments During Term | 4 | |||
2.01 Term | 4 | |||
2.02 Extension and Renewal of Term | 4 | |||
2.03 Amendments | 5 | |||
Article 3. Water Supply | 8 | |||
3.01 Supply Assurance | 8 | |||
3.02 Allocation of Supply Assurance | 9 | |||
3.03 Wholesale Customer Service Areas | 10 | |||
3.04 Permanent Transfers of Individual Supply Guarantees | 12 | |||
3.05 Restrictions on Resale | 12 | |||
3.06 Conservation; Use of Local Sources; Water Management Charge | 13 | |||
3.07 Restrictions on Purchases of Water from Others; Minimum Annual Purchases | 14 | |||
3.08 Water Quality | 14 | |||
3.09 Completion of WSIP | 15 | |||
3.10 Regional Water System Repair, Maintenance and Operation | 15 | |||
3.11 Shortages | 16 | |||
3.12 Wheeling of Water from Outside SFPUC System | 18 | |||
3.13 Limits on New Customers | 19 | |||
3.14 Measurement of Water | 21 | |||
3.15 New Sources of Water Supply to Maintain Supply Assurance | 22 | |||
3.16 New Sources of Water Supply to Increase Supply Assurance | 23 | |||
3.17 Westside Basin Conjunctive Use Program | 24 | |||
Article 4. Implementation of Interim Supply Limitation | 27 | |||
4.01 Interim Supply Limitation Imposed by SFPUC | 27 | |||
4.02 Retail and Wholesale Customer Allocations Under Interim Supply Limitation | 27 | |||
4.03 Transfers of Interim Supply Allocations | 27 | |||
4.04 Environmental Enhancement Surcharge | 28 |
-i-
(continued)
Page | ||||
4.05 San Jose/ Santa Clara Interim Supply Allocation and Process for Reduction/ Termination | 30 | |||
4.06 San Francisco Decisions in 2018 Regarding Future Water Supply | 31 | |||
4.07 Retained Discretion of SFPUC and Wholesale Customers | 32 | |||
Article 5. Wholesale Revenue Requirement | 34 | |||
5.01 Scope of Agreement | 34 | |||
5.02 General Principles | 34 | |||
5.03 Capital Cost Recovery — Existing Regional Assets | 36 | |||
5.04 Capital Cost Contribution — New Regional Assets | 38 | |||
5.05 Water Enterprise Operation and Maintenance Expenses | 40 | |||
5.06 Water Enterprise Administrative and General Expenses | 42 | |||
5.07 Water Enterprise Property Taxes | 45 | |||
5.08 Hetch Hetchy Enterprise Expenses | 45 | |||
5.09 Hetch Hetchy Enterprise Capital Costs | 47 | |||
5.10 Additional Agreements Related to Financial Issues | 48 | |||
Article 6. Integration of Wholesale Revenue Requirement with SFPUC Budget Development and Rate Adjustments | 51 | |||
6.01 General | 51 | |||
6.02 Budget Development | 51 | |||
6.03 Rate Adjustments | 51 | |||
6.04 Rate Structure | 53 | |||
6.05 Balancing Account | 54 | |||
6.06 Wholesale Revenue Coverage Reserve | 56 | |||
6.07 Working Capital Requirement | 58 | |||
6.08 Wholesale Capital Fund | 59 | |||
Article 7. Accounting Procedures; Compliance Audit | 61 | |||
7.01 SFPUC Accounting Principles, Practices | 61 | |||
7.02 Calculation of and Report on Wholesale Revenue Requirement | 62 | |||
7.03 Appointment of Compliance Auditor | 64 | |||
7.04 Conduct of Compliance Audit | 64 | |||
7.05 Issuance of Compliance Auditor’s Report | 67 | |||
7.06 Wholesale Customer Review | 67 | |||
Article 8. Other Agreements of the Parties | 69 | |||
8.01 Arbitration and Judicial Review | 69 |
-ii-
(continued)
Page | ||||
8.02 Attorneys’ Fees | 73 | |||
8.03 Annual Meeting and Report | 74 | |||
8.04 Administrative Matters Delegated to BAWSCA | 75 | |||
8.05 Preservation of Water Rights; Notice of Water Rights Proceedings | 76 | |||
8.06 SFPUC Rules and Regulations | 77 | |||
8.07 Reservations of, and Limitations on, Claims | 77 | |||
8.08 Prohibition of Assignment | 80 | |||
8.09 Notices | 80 | |||
8.10 Incorporation of Attachments | 81 | |||
8.11 Interpretation | 81 | |||
8.12 Actions and Approvals by San Francisco | 81 | |||
8.13 Counterparts | 82 | |||
8.14 Limitations on Damages | 82 | |||
8.15 Force Majeure | 82 | |||
8.16 No Third-Party Beneficiaries | 83 | |||
8.17 Good Faith and Fair Dealing | 83 | |||
Article 9. Implementation and Special Provisions Affecting Certain Wholesale Customers | 84 | |||
9.01 General; Individual Water Sales Contracts | 84 | |||
9.02 California Water Service Company | 84 | |||
9.03 City of Hayward | 86 | |||
9.04 Estero Municipal Improvement District | 87 | |||
9.05 Stanford University | 87 | |||
9.06 City of San Jose and City of Santa Clara | 88 | |||
9.07 City of Brisbane, Guadalupe Valley Municipal Improvement District, Town of Hillsborough | 89 |
-iii-
A | Definitions | |
B | Wholesale Customer Regional Water System Purchases 2007-2008 (Section 1.03) | |
C | List of Agencies and Individual Supply Guarantees (Section 3.02) | |
D | Procedure for Pro Rata Reduction of Individual Supply Guarantees if Total Use Exceeds 184 MGD (Section 3.02) | |
E | Minimum Quantities for Dual Source Agencies (Section 3.07.C) | |
F | Sample Individual Water Sales Contract (Section 9.01) | |
G | Water Quality Notification and Communications Plan (Section 3.08.B) | |
H | Tier 1 Shortage Plan (Section 3.11.C) | |
I | NOT USED | |
J | Water Use Measurement and Tabulation (Section 3.14) | |
K-1 | Wholesale Customers’ Share of Net Book Value of Existing Assets (Section 5.03) | |
K-2 | Wholesale Customers’ Share of the Book Value of Revenue-Funded Capital Expenditures (Section 5.03) | |
K-3 | 25 Year Payoff Schedule for Existing Rate Base — Water Enterprise Regional Assets and One Direct Wholesale Asset (Section 5.03) | |
K-4 | 25 Year Payoff Schedule for Existing Rate Base — Hetch Hetchy Water Assets and Water-Related Portion of Joint Assets (Section 5.03) | |
K-5 | Unexpended Appropriations for Revenue-Funded Regional Assets (Section 5.03) | |
L-1 | Identification of WSIP Projects as Regional/Retail (Section 5.04) | |
L-2 | Certificate of Use of Proceeds (Section 5.04.A) | |
L-3 | Annual Report on Expenditures of and Earnings on Proceeds (Section 5.04.A) | |
M-1 | Revenue-Funded Capital Additions (Section 5.04.B) | |
M-2 | Revenue-Funded Capital Annual Reporting Requirements (Section 5.04.B) | |
M-3 | Wholesale Revenue-Funded Capital Fund (Section 6.08) | |
N-1 | Balancing Account/Rate Setting Calculation Table (Section 6.03.A.3.a) |
-iv-
N-2 | Wholesale Revenue Requirement Schedules (Section 6.03.A.3.b) | |
N-3 | Schedule of Projected Water Sales, Wholesale Revenue Requirement and Wholesale Rates (Section 6.03.A.3.c) | |
O | Statement of Wholesale Revenue Requirement/Changes in Balancing Account (Section 7.02.B.1) | |
P | Management Representation Letter (Section 7.02.B.5) | |
Q | San Jose and Santa Clara Service Areas (Section 9.06) |
-v-
California Water Service Company
City of Brisbane
City of Burlingame
City of Daly City
City of East Palo Alto
City of Hayward
City of Menlo Park
City of Millbrae
City of Milpitas
City of Mountain View
City of Palo Alto
City of Redwood City
-1-
City of San José
City of Santa Clara
City of Sunnyvale
Coastside County Water District
Estero Municipal Improvement District
Guadalupe Valley Municipal Improvement District
Mid-Peninsula Water District
North Coast County Water District
Purissima Hills Water District
Skyline County Water District
Stanford University
Town of Hillsborough
Westborough Water District
-2-
-3-
-4-
-5-
Attachment | Name | |
G | January 2006 Water Quality Notification and Communications Plan | |
J | Water Use Measurement and Tabulation | |
L-1 | Identification of WSIP Projects as Regional/Retail | |
N-1 | Balancing Account/Rate Setting Calculation Table | |
N-2 | Wholesale Revenue Requirement Schedules | |
N-3 | Schedule of Projected Water Sales, Wholesale Revenue Requirement and Wholesale Rates | |
P | Management Representation Letter |
-6-
-7-
-8-
-9-
-10-
• | the Wholesale Customer may expand its service area without subsequent San Francisco approval to a definitive size but no larger, or | ||
• | the Wholesale Customer will not expand its service area beyond its present limits without San Francisco approval |
-11-
-12-
-13-
-14-
-15-
-16-
-17-
-18-
-19-
-20-
-21-
-22-
-23-
-24-
-25-
-26-
Retail Customers’ allocation: | 81 MGD | |
Wholesale Customers’ allocation: | 184 MGD |
-27-
-28-
-29-
-30-
-31-
-32-
-33-
-34-
-35-
-36-
-37-
-38-
-39-
-40-
-41-
-42-
-43-
-44-
-45-
-46-
-47-
-48-
-49-
-50-
-51-
-52-
-53-
-54-
-55-
-56-
-57-
-58-
-59-
-60-
-61-
-62-
-63-
-64-
-65-
-66-
-67-
-68-
-69-
-70-
-71-
-72-
-73-
-74-
-75-
-76-
-77-
-78-
-79-
San Francisco Public Utilities Commission
1155 Market Street, 11th Floor
San Francisco, CA 94103
-80-
Bay Area Water Supply and Conservation Agency
155 Bovet Road, Suite 302
San Mateo, CA 94402
-81-
-82-
-83-
-84-
-85-
-86-
-87-
-88-
-89-
-90-
Acting by and through its Public Utilities Commission
By: | ||||
Edward Harrington | ||||
General Manager | ||||
Date: , 2009 | ||||
Approved by Commission Resolution No. 09-0069, | ||||
adopted April 28, 2009 | ||||
Michael Housh | ||||
Secretary to Commission | ||||
Approved as to form: | ||||
DENNIS J. HERRERA | ||||
City Attorney | ||||
By: | ||||
Joshua D. Milstein | ||||
Deputy City Attorney |
-91-
Attachment A, Page 1
Attachment A, Page 2
Attachment A, Page 3
Attachment A, Page 4
Attachment A, Page 5
Attachment A, Page 6
Attachment A, Page 7
Attachment A, Page 8
WHOLESALE CUSTOMER REGIONAL WATER SYSTEM PURCHASES FY 2007-2008*
(To determine 75% approval process for Section 1.02)
WHOLESALE CUSTOMER | MGD | |||
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 Millbrae | 2.46 | |||
City of 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. |
INDIVIDUAL SUPPLY GUARANTEES
(1) | (2) | |||||||
WHOLESALE CUSTOMER | 100 Cubic Feet * | MGD | ||||||
Alameda County Water District | 6,714,439 | 13.760 | ||||||
California Water Service Company** | 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 | 957,813 | 1.963 | ||||||
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,567,648 | 13.460 | ||||||
City of Palo Alto | 8,331,697 | 17.075 | ||||||
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:*** | 79,004,278 | 161.913 |
* | 100 Cubic feet equals MGD divided by 0.00000204946. Figures in this column are calculated using unrounded MGD values and are more precise than the figures listed in column (2). | |
** | Includes quantities from Los Trancos County Water District and Palomar Park Water District. | |
*** | Total does not equal sum of MGD figures due to rounding. Total is not 184 MGD because 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). |
SUPPLY GUARANTEES
(SECTION 3.02).
ATTACHMENT D Page 2
(Section 3.07.C)
MINIMUM ANNUAL PURCHASE | ||||
QUANTITY | ||||
AGENCY | (IN MGD) | |||
Alameda County Water District | 7.648 | |||
City of Milpitas | 5.341 | |||
City of Mountain View | 8.930 | |||
City of Sunnyvale | 8.930 |
ATTACHMENT F, Page 2
CITY AND COUNTY OF SAN FRANCISCO | ||||
Acting by and through its Public Utilities Commission | ||||
BY | Date: , 2009 | |||
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 toSection 9.01 of the WSA. |
ATTACHMENT F, Page 3
ATTACHMENT G |
Notification and Communications Plan
Revision 4
January 2006
Water Quality Engineering
Olivia Chen Consultants, Inc.
1
Level of System Wide | Share of Available Water | |||||||
Reduction in Water Use | Wholesale Customers | |||||||
Required | SFPUC Share | Share | ||||||
5% or less | 35.5 | % | 64.5 | % | ||||
6% through 10% | 36.0 | % | 64.0 | % | ||||
11% through 15% | 37.0 | % | 63.0 | % | ||||
16% through 20% | 37.5 | % | 62.5 | % |
2
3
4
5
ALLOCATION PLAN
6
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 15th 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 15th 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-31 | ||
10. | SFPUC declares the need for a voluntary or mandatory response | April 15-31 | ||
11. | BAWSCA submits calculation to SFPUC of individual Wholesale Customers’ percentage shares of water allocated to Wholesale Customers collectively | April 15-31 | ||
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 |
7
CALCULATING PROPORTIONAL ANNUAL WATER USE
Section A: | Water Meters | |||
Section B: | Calculation of Proportional Annual Water Use | |||
Section C: | Data Requirements and Schedule | |||
Section D: | County Line and In-City Terminal Reservoir Meter Calibration and Maintenance | |||
Figure 1: | Locations of SFPUC County-Line Meters and In-City Terminal Reservoirs | |||
Figure 2: | Generalized Schematic of Lake Merced Pump Station | |||
Figure 3: | Locations of System Input and In-Line Meters | |||
Table 1: | Base Usage and Allocation Rates | |||
Table 2: | Locations of SFPUC County-line Meters and In-City Terminal Reservoirs | |||
Table 3: | Locations of SFPUC System Input and In-line Meters | |||
Table 4: | County-line Meters, In-City Terminal Reservoirs and Associated Metering Equipment | |||
Table 5: | Meter Calibration and Maintenance Frequency |
1
2
a. | County-line Meters |
3
b. | In-City Terminal Reservoirs |
c. | System Input and In-Line Meters |
4
d. | Wholesale Customer Meters and City Retail Customer Meters Located Outside the Boundaries of the City |
5
a. | Flow Data |
b. | Reservoir Data |
6
Table 1.
(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) | CSPL1/Macdonald Avenue Service (Account number 010084-01-0) | ||
(b) | Guttenberg Street Service (Account number 010013-01-3) | ||
(c) | Carter Street Service (Account numbers 284070-01-8 and 284071-01-6) |
(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
(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 affiliated 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 to 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 of land owned by the City Recreation and Park Department). | ||
(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
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 Form 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
(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 SFPUC Retail Customers outside the City boundaries as measured at the customer meter. These deliveries are considered positive for the purposes 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-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
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 Coastside 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
(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 system 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.” | ||
(j) | 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 capacity 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.1.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
(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). |
14
15
16
Table 4.
17
a) | Quarterly testing and calibration. The secondary metering equipment shall be tested and calibrated quarterly using NIST Traceable test equipment, and a “dead weight tester.” |
18
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 milliamp 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) | Annual 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 billing 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% of the 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
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 quarterly site visit, the metering consultant shall inspect, assess and document the condition of all metering equipment, including meter, gauges, indicators, recorders, transmitters and other instrumentation, used in the measurement and recording of flow 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. |
20
21
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 | B.1 | 79.5 | 78.3 | 75.7 | |||||||||||||||||||||||||
2. Daly City portion | B.2 | 0.2 | 0.2 | 0.2 | |||||||||||||||||||||||||
3. Net S.F. | (1-2 | ) | 79.3 | 78.1 | 75.5 | ||||||||||||||||||||||||
4. Other suburban raw water | B.4 | 0.4 | 0.5 | 0.7 | |||||||||||||||||||||||||
5. Other suburban treated water | B.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 | B.8 | 167.4 | 164.4 | 175.8 | |||||||||||||||||||||||||
9. Total system usage | (7+8 | ) | 251.2 | 246.4 | 255.9 | ||||||||||||||||||||||||
10. Wholesale alloc. rate | (8/9 | ) | 66.63 | % | 66.72 | % | 68.70 | % | |||||||||||||||||||||
11. City alloc. rate | (100%-10 | ) | 33.37 | % | 33.28 | % | 31.30 | % | |||||||||||||||||||||
12a. HHWPD input (Oakdale) | B.12 | 194.7 | 202.6 | 227.3 | |||||||||||||||||||||||||
12b. Deliveries to LLNL | B.12 | -0.4 | -0.9 | -0.9 | |||||||||||||||||||||||||
12c. HH to San Ant. Res. | B.12 | -3.8 | -1.8 | -11.6 | |||||||||||||||||||||||||
12d. Sunol Valley WTP | B.12 | 28.5 | 29.4 | 17.6 | |||||||||||||||||||||||||
12e. Harry Tracy WTP | B.12 | 45.2 | 40.4 | 41.2 | |||||||||||||||||||||||||
12f. Raw water deliveries | B.12 | 0.4 | 0.4 | 0.7 | |||||||||||||||||||||||||
12g. Deliveries to Coastside Co. WD | B.12 | 1.8 | 1.6 | 2.1 | |||||||||||||||||||||||||
12h. Crys. Sprs. Bal. Res. | B.12 | 0.0 | 0.0 | 0.0 | |||||||||||||||||||||||||
12i. Spill to CS Res. | B.12 | -19.9 | -42.6 | -37.1 | |||||||||||||||||||||||||
12j. Terminal Reservoirs | B.12 | 0.0 | 0.0 | 0.0 | |||||||||||||||||||||||||
12k. Other sources | B.12 | 0.0 | 1.9 | 3.8 | |||||||||||||||||||||||||
13. Total system input | B.13 | 246.5 | 231.0 | 243.1 | |||||||||||||||||||||||||
14. Jt. sys. loss red. fact. | (9/13 | ) | 1.0000 | 1.0000 | 1.0000 | ||||||||||||||||||||||||
15. Daly City red. factor | (3/1 | ) | 0.9975 | 0.9974 | 0.9974 | ||||||||||||||||||||||||
16. Total suburban | (6+8 | ) | 171.9 | 168.3 | 180.4 | ||||||||||||||||||||||||
17. Suburban red. factor | (8/16 | ) | 0.9736 | 0.9768 | 0.9745 | ||||||||||||||||||||||||
18. HHWPD Deliveries above Oakdale | B.18 | ||||||||||||||||||||||||||||
19. HH Reduction Factor | B.19 | 99.56 | % |
Locations of SFPUC County-Line Meters and In-City Terminal Reservoirs
Meter | Pipeline | Location | ||
1 | Sunset | Lake Merced Pump Station | ||
2 | Sutro | Lake Merced Pump Station | ||
3 | Lake Merced Outfall | Lake Merced Pump Station | ||
4 | San Andreas No. 2 | Junipero Serra (Hwy. 280) South of Belle Ave. | ||
5 | Crystal Springs No. 1 | PG&E Martin Service Center Yard | ||
6 | Crystal Springs No. 2 | Tamasco Ct. South of Sunnydale Ave. | ||
A | San Andreas No. 3 (Planned) | To be determined |
Meter | Reservoir | Location | ||
7 | Sunset Reservoir | 26th Avenue and Ortega | ||
8 | University Mound Reservoir | University Avenue and Bacon | ||
9 | Merced Manor Reservoir | 23rd Avenue and Ocean |
Locations of SFPUC System Input and In-Line Meters
Meter | Pipeline | Location | ||
10 | San Joaquin Pipeline No. 1 | Albers Road, South of Oakdale in Stanislaus County | ||
11 | San Joaquin Pipeline No. 2 | Same as San Joaquin Pipeline No. 1 | ||
12 | San Joaquin Pipeline No. 3 | Same as San Joaquin Pipeline No. 1 | ||
13 | San Antonio Pipeline | San Antonio Pump Station | ||
14 | Sunol Valley WTP Effluent | San Antonio Pump Station | ||
15 | Calaveras Pipeline | Sunol Valley Water Treatment Plant | ||
16 | Irvington — Bay Division Pipeline No. 1 | Driscoll Road in Fremont | ||
17 | Irvington — Bay Division Pipeline No. 2 | Same as Irvington Bay Division Pipeline No. 1 | ||
18 | Irvington — Bay Division Pipeline No. 3 | Mission Boulevard in Fremont | ||
19 | Irvington — Bay Division Pipeline No. 4 | Same as Irvington Bay Division Pipeline No. 3 | ||
20 | Pulgas — Bay Division Pipeline No. 1 | Hassler Road at Pulgas Valve Lot | ||
21 | Pulgas — Bay Division Pipeline No. 2 | Same as Pulgas Bay Division Pipeline No. 1 | ||
22 | Pulgas — Bay Division Pipeline No. 3 | Same as Pulgas Bay Division Pipeline No. 1 | ||
23 | Pulgas — Bay Division Pipeline No. 4 | Same as Pulgas Bay Division Pipeline No. 1 | ||
24 | Crystal Springs Reservoir Outfall | Canada Road near Pulgas Temple | ||
25 | Harry Tracy WTP Effluent — Sunset Supply | Harry Tracy Water Treatment Plant | ||
26 | Harry Tracy WTP Effluent — San Andreas Supply | Harry Tracy Water Treatment Plant | ||
27 | Crystal Springs — San Andreas Pipeline | Crystal Springs Pump Station | ||
28 | Crystal Springs Pump Station — Sunset Supply | Crystal Springs Pump Station | ||
29 | Crystal Springs Pump Station — Crystal Springs No. 2 Supply | Crystal Springs Pump Station | ||
30 | Crystal Springs Balancing Reservoir | Canada Road near Pulgas Temple | ||
31 | Santa Clara Valley WD Intertie | Milpitas Boulevard in Milpitas | ||
B | San Joaquin Pipeline No. 4 (Planned) | To be determined | ||
C | East Bay MUD Intertie (Planned) | To be determined | ||
D&E | Bay Division Pipeline No. 5 (Planned) | To be determined |
SFPUCcounty-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 D/P transmitter | |||||
Equipment: | • Honeywell recorder | |||||
• SCADA | ||||||
2. | Sutro | 36” Venturi | Lake Merced Pump Station | |||
Associated Metering | • Rosemount D/P transmitter | |||||
Equipment: | • Honeywell recorder | |||||
• SCADA | ||||||
3. | Lake Merced Outfall | 16” Mag. 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 D/P 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 D/P transmitter | |||||
Equipment: | • NLS display | |||||
• AGM electronics | ||||||
• Honeywell recorder | ||||||
• SCADA | ||||||
6. | Crystal Springs No. 2 | 60” Venturi | Tamasco Ct. south of Sunnydale Avenue | |||
Associated Metering | • Yokogawa D/P transmitter | |||||
Equipment: | • NLS display | |||||
• AGM electronics | ||||||
�� | • SCADA |
In-City Terminal Reservoirs | ||||||
1. | Sunset | Pressure Transducer | 26th Avenue and Ortega | |||
Associated Metering | • Honeywell recorder | |||||
Equipment: | • SCADA | |||||
2. | Merced-Manor | Pressure Transducer | 23rd Avenue and Ocean | |||
Associated Metering | • Honeywell recorder | |||||
Equipment: | • SCADA | |||||
3. | University Mound | Pressure Transducer | University Avenue and Bacon | |||
Associated Metering | • Honeywell recorder | |||||
Equipment: | • SCADA |
Meter Calibration and Maintenance Frequency
METER/ | WORK TO BE PERFORMED | |||||||||||||||||
EQUIPMENT | FREQUENCY | (See Work Codes Listed Below) | ||||||||||||||||
Semi- | ||||||||||||||||||
Quarterly | Annual | Annual | CA | CL | FL | IN | LU | PT | ||||||||||
Venturi Meters | X | X | X | X | X | |||||||||||||
(1) | (1) | |||||||||||||||||
Magnetic Meters | X | X | X | X | ||||||||||||||
(2) | (2) | (2) | ||||||||||||||||
Yokagowa D/P Transmitters | X | X | X | X | X | |||||||||||||
Rosemount D/P Transmitters | X | X | X | X | X | |||||||||||||
Honeywell Recorders | X | X | X | X | ||||||||||||||
Water Level Sensors (Pressure Transducers) | X | X | X | X | ||||||||||||||
SCADA Electronics | X | X | ||||||||||||||||
AGM Electronics | X | X | ||||||||||||||||
NLS Digital Displays | X | X | ||||||||||||||||
Electrostatic 24V DC Power Supplies | X | X | ||||||||||||||||
(3) | ||||||||||||||||||
ASCO Solenoids | X | X | X | X | ||||||||||||||
(4) |
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. |
WHOLESALE CUSTOMERS’ SHARE OF NET BOOK VALUE OF EXISTING ASSETS
**PRELIMINARY — TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES**
(Section 5.03)
Notes | Projected Value | |||||||||||||||
Water | Hetch Hetchy | Total | ||||||||||||||
Regional System Net Plant as of 6/30/08 (Actual) | 1 | $ | 435,639,907 | $ | 66,135,724 | |||||||||||
Less: Projected Depreciation on Regional Assets | 2 | $ | (32,526,143 | ) | $ | (3,598,189 | ) | |||||||||
Plus: Projected FY 2008-09 Capital Additions | 3 | $ | 62,771,153 | $ | — | |||||||||||
Projected Regional System Net Plant as of 6/30/09 | $ | 465,884,917 | $ | 62,537,535 | ||||||||||||
Plus: Projected Construction Work In Progress (CWIP) as of 6/30/09 | 4 | $ | 16,928,503 | $ | 5,807,023 | |||||||||||
Projected Regional System Net Plant and CWIP as of 6/30/09 | $ | 482,813,420 | $ | 68,344,558 | $ | 551,157,978 | ||||||||||
Allocation Factor: | 5 | 70.1 | % | 64.2 | % | |||||||||||
Wholesale Share of Projected Regional System Net Plant as of 6/30/09 | $ | 326,585,327 | $ | 40,149,098 | $ | 366,734,424 | ||||||||||
Plus: Wholesale Share of Projected CWIP as of 6/30/09 | 6 | $ | 11,866,881 | $ | 3,728,109 | $ | 15,594,989 | |||||||||
Wholesale Share of Projected Net Plant and CWIP as 6/30/09 | $ | 338,452,207 | $ | 43,877,206 | $ | 382,329,414 | ||||||||||
Interest Rate: | 5.13 | % | 5.13 | % | ||||||||||||
Term (Yrs): | 25 | 25 | ||||||||||||||
Monthly Principal & Interest | $ | 2,004,277 | $ | 259,836 | $ | 2,264,113 | ||||||||||
Annual Wholesale Revenue Requirement Amount | $ | 24,051,326 | $ | 3,118,033 | $ | 27,169,359 |
Notes | ||
1 | FAACS 120A Report as of 6/30/08 | |
2 | SFPUC Estimate | |
3 | SFPUC Estimate based on projects and amounts as follows: |
Water Assets | ||||
CUW358 Sunset Reservoir (North Basin) | $ | 57,382,744 | ||
CUW 365 Cross Connection Controls | $ | 3,679,415 | ||
CUW 394 Watershed Land Acqusition | $ | 1,708,994 | ||
Total Additions | $ | 62,771,153 |
4 | CWIP based on balance as 6/30/08 plus YTD expenditures (see Attachment K-2) | |
5 | Fixed allocation factors based on dollar weighted 5-year average of J-Table allocation factors (2003-04 through 2007-08) | |
6 | Wholesale share CWIP based on balance as 6/30/08 plus YTD expenditures (see Attachment K-2) |
Page 1 of 1
WHOLESALE CUSTOMERS’ SHARE OF THE BOOK VALUE OF REVENUE FUNDED CAPITAL EXPENDITURES
**PRELIMINARY — TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES**
(Section 5.03)
[1] | [2] | [3] | [4] | [5] | [6] | [7] | [8] | [9] | ||||||||||||||||||||||||
Project | CWIP as of | FY 2008-09 | Reduction for | CWIP as | 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 | $ | 2,007,607 | $ | 224,582 | $ | 2,232,189 | $ | — | $ | — | ||||||||||||||||||||
CUW353 | Seismic Upgrade@Hayward Fault | Joint | $ | 3,129,234 | $ | 1,967,625 | $ | 5,096,859 | $ | — | $ | — | ||||||||||||||||||||
CUW354 | LOWER CRYSTAL SPRINGS DAM-REV-SFWD | Joint | $ | 7,046,944 | $ | 1,086,262 | $ | 8,133,206 | $ | — | $ | — | ||||||||||||||||||||
CUW355 | STANDBY POWER FACILITIES | Joint | $ | 3,715,276 | $ | 6,596,849 | $ | 10,312,125 | $ | — | $ | — | ||||||||||||||||||||
CUW357 | Adit Leak Repairs | Joint | $ | 783 | $ | 1,129 | $ | 1,912 | $ | — | $ | — | ||||||||||||||||||||
CUW359 | } | Joint | $ | 21,391,129 | $ | 5,176,713 | $ | 26,567,842 | $ | — | $ | — | ||||||||||||||||||||
CUW359 | Irvington Tunnel | Joint | $ | 7,837,176 | $ | — | $ | 7,837,176 | $ | — | $ | — | ||||||||||||||||||||
CUW361 | } | Joint | $ | 368,057 | $ | 1,383,959 | $ | 1,752,016 | $ | — | $ | — | ||||||||||||||||||||
CUW361 | Joint | $ | 1,255,545 | $ | — | $ | 1,255,545 | $ | — | $ | — | |||||||||||||||||||||
CUW361 | Pulgas Balancing Reservoir | Joint | $ | 1,248,002 | $ | — | $ | 1,248,002 | $ | — | $ | — | ||||||||||||||||||||
CUW361 | Joint | $ | 570,179 | $ | — | $ | 570,179 | $ | — | $ | — | |||||||||||||||||||||
CUW361 | Joint | $ | 712,921 | $ | — | $ | 712,921 | $ | — | $ | — | |||||||||||||||||||||
CUW363 | } | Joint | $ | 1,335,371 | $ | 1,738,045 | $ | 3,073,416 | $ | — | $ | — | ||||||||||||||||||||
CUW363 | SCADA Phase II | Joint | $ | 1,062,050 | $ | — | $ | 1,062,050 | $ | — | $ | — | ||||||||||||||||||||
CUW365 | Cross Connection Control | Joint | $ | 3,635,172 | $ | 547,801 | $ | 4,182,973 | $ | — | $ | — | Capitalized in FY 2008-09 | |||||||||||||||||||
CUW367 | HTWTP LT Impr | Joint | $ | 8,011,348 | $ | 2,479,731 | $ | 10,491,079 | $ | — | $ | — | ||||||||||||||||||||
CUW368 | } | Joint | $ | 23,640,601 | $ | — | $ | 23,640,601 | $ | — | $ | — | ||||||||||||||||||||
CUW368 | BDPL Hydraulic Capacity | Joint | $ | 17,556,905 | $ | 4,200,442 | $ | 21,757,347 | $ | — | $ | — | ||||||||||||||||||||
CUW368 | Joint | $ | 2,579,847 | $ | — | $ | 2,579,847 | $ | — | $ | — | |||||||||||||||||||||
CUW370 | Pipeline Readiness | Joint | $ | 5,320,934 | $ | 328,070 | $ | 5,649,004 | $ | — | $ | — | ||||||||||||||||||||
CUW371 | CSPS and Pipeline | Joint | $ | 11,420,770 | $ | 3,872,779 | $ | 15,293,549 | $ | — | $ | — | ||||||||||||||||||||
CUW372 | University Mound (N) | Joint | $ | 4,624,981 | $ | 1,068,147 | $ | 5,693,128 | $ | — | $ | — | ||||||||||||||||||||
CUW373 | } | Joint | $ | 19,479,341 | $ | 6,023,849 | $ | 25,503,190 | $ | — | $ | — | ||||||||||||||||||||
CUW373 | SJPL | Joint | $ | 7,199,051 | $ | — | $ | 7,199,051 | $ | — | $ | — | ||||||||||||||||||||
CUW374 | } | Joint | $ | 31,171,669 | $ | 4,314,430 | $ | 35,486,099 | $ | — | $ | — | ||||||||||||||||||||
CUW374 | Calaveras Dam | Joint | $ | 2,366,343 | $ | — | $ | 2,366,343 | $ | — | $ | — | ||||||||||||||||||||
CUW378 | CSPL #2 | Joint | $ | 7,453,098 | $ | 913,369 | $ | 8,366,467 | $ | — | $ | — | ||||||||||||||||||||
CUW379 | SAPL #3 | Joint | $ | 5,728,934 | $ | 588,346 | $ | 6,317,280 | $ | — | $ | — | ||||||||||||||||||||
CUW380 | BDPK #3&4 Crossovers | Joint | $ | 3,855,357 | $ | 1,083,888 | $ | 4,939,245 | $ | — | $ | — | ||||||||||||||||||||
CUW381 | } | Joint | $ | 5,450,995 | $ | — | $ | 5,450,995 | $ | — | $ | — | ||||||||||||||||||||
CUW381 | SVWTP Expansion | Joint | $ | 53,222 | $ | 3,090,520 | $ | 3,143,742 | $ | — | $ | — | ||||||||||||||||||||
CUW381 | Joint | $ | 97,373 | $ | — | $ | 97,373 | $ | — | $ | — | |||||||||||||||||||||
CUW382 | SVWTP Treated Water Reservoir | Joint | $ | 5,799,505 | $ | 575 | $ | 5,800,080 | $ | — | $ | — | ||||||||||||||||||||
CUW384 | Tesla | Joint | $ | 6,102,621 | $ | 7,444,942 | $ | 13,547,563 | $ | — | $ | — | ||||||||||||||||||||
CUW386 | SAPS X-CONNECT & PUMP IMP 96A UEB | Joint | $ | 1,374,491 | $ | 971,625 | $ | 2,346,116 | $ | — | $ | — | ||||||||||||||||||||
CUW388 | } | Joint | $ | 896,476 | $ | 1,641,717 | $ | 2,538,193 | $ | — | $ | — | ||||||||||||||||||||
CUW388 | PEIR | Joint | $ | 1,331,676 | $ | — | $ | 1,331,676 | $ | — | $ | — | ||||||||||||||||||||
CUW390 | Desalination Pilot | Joint | $ | 175,165 | $ | — | $ | 175,165 | $ | — | $ | — | ||||||||||||||||||||
CUW391 | Baden/San Pedro Valve Lots | Joint | $ | 3,964,642 | $ | 948,589 | $ | 4,913,231 | $ | — | $ | — | ||||||||||||||||||||
CUW392 | Program Management | Joint | $ | 2,452,297 | $ | 5,081,444 | $ | 7,533,741 | $ | — | $ | — | ||||||||||||||||||||
CUW393 | BDPL #4 Condition Assessment | Joint | $ | 25,071 | $ | 294,634 | $ | 319,705 | $ | — | $ | — | ||||||||||||||||||||
CUW394 | Watershed Enviroment Improvement | Joint | $ | 142,924 | $ | 96,027 | $ | 238,951 | $ | — | $ | — | Capitalized in FY 2008-09 | |||||||||||||||||||
CUW101 | SAN ANDREAS PLANT EXPANSION #1 | Joint | $ | 182 | $ | 96,027 | $ | 96,209 | $ | 67,443 | ||||||||||||||||||||||
CUW111 | LOWER CRYSTAL SPRINGS DAM-REV-SFWD | Joint | $ | 40,436 | $ | — | $ | 40,436 | $ | 28,346 | ||||||||||||||||||||||
CUW151 | Baden PS | Joint | $ | 921 | $ | 26,760 | $ | 27,681 | $ | 19,404 | ||||||||||||||||||||||
CUW161 | Water Treatment Facilities | Joint | $ | 75,801 | $ | 605 | $ | 76,406 | $ | 53,561 | ||||||||||||||||||||||
CUW178 | SAPS X-CONNECT & PUMP IMP96A UEB | Joint | $ | 104,902 | $ | — | $ | 104,902 | $ | 73,536 | ||||||||||||||||||||||
CUW202 | } | Joint | $ | 50,808 | $ | — | $ | 50,808 | $ | 35,616 | ||||||||||||||||||||||
CUW202 | Replace PCCP | Joint | $ | 285,003 | $ | 64,256 | $ | 349,259 | $ | 244,831 | ||||||||||||||||||||||
CUW202 | Joint | $ | 2,365 | $ | — | $ | 2,365 | $ | 1,658 | |||||||||||||||||||||||
CUW127 | SCADA | Joint | $ | 50,029 | $ | 2,481,274 | $ | 2,531,303 | $ | 1,774,443 | ||||||||||||||||||||||
CUW356 | New Crystal Springs Bypass Tunnel | Joint | $ | 13,992,264 | $ | 5,560,862 | $ | 16,028,397 | $ | 3,524,729 | $ | 2,470,835 | ||||||||||||||||||||
CUW358 | Sunset (N) | Joint | $ | 52,494,764 | $ | 4,887,980 | $ | 55,806,081 | $ | 1,576,663 | $ | 1,105,241 | Capitalized in FY 2008-09 | |||||||||||||||||||
CUW387 | Tesla Portal Disinfection | Joint | $ | 2,377,262 | $ | (1,996 | ) | $ | 1,223,945 | $ | 1,151,321 | $ | 807,076 | |||||||||||||||||||
CUW135 | } | Joint | $ | 45,413 | $ | — | $ | 45,413 | $ | 31,835 | ||||||||||||||||||||||
CUW135 | New Lines and Bypass Valves | Joint | $ | 153,983 | $ | 620,156 | $ | 774,139 | $ | 542,671 | ||||||||||||||||||||||
CUW135 | Joint | $ | 8,860 | $ | — | $ | 8,860 | $ | 6,211 | |||||||||||||||||||||||
CUW143 | } | Joint | $ | 5,656 | $ | — | $ | 5,656 | $ | 3,965 | ||||||||||||||||||||||
CUW143 | HH Water Treatment Plan | Joint | $ | 709,972 | $ | 8,817 | $ | 718,789 | $ | 503,871 | ||||||||||||||||||||||
CUW143 | Joint | $ | 96,292 | $ | — | $ | 96,292 | $ | 67,501 | |||||||||||||||||||||||
CUW186 | SVWTP IMPROVEMENT PROJECT-CPB-SFWD | Joint | $ | 3,604 | $ | — | $ | 3,604 | $ | 2,526 | ||||||||||||||||||||||
CUW206 | } | Joint | $ | 4,365 | $ | — | $ | 4,365 | $ | 3,060 | ||||||||||||||||||||||
CUW206 | Tesla Portal/Thomas Shaft Emergency Disinfection | Joint | $ | 283,620 | $ | 5,665 | $ | 289,285 | $ | 202,789 | ||||||||||||||||||||||
CUW206 | Joint | $ | 227,004 | $ | — | $ | 227,004 | $ | 159,130 | |||||||||||||||||||||||
CUW231 | Millbrae Labs | Joint | $ | 81,856 | $ | 34,685 | $ | 116,541 | $ | 81,695 | ||||||||||||||||||||||
CUW236 | TELSA/SJVH WQ MONITORING IMPR | Joint | $ | 152,963 | $ | — | $ | 152,963 | $ | 107,227 | ||||||||||||||||||||||
CUW366 | } | Joint | $ | 16,523 | $ | — | $ | 16,523 | $ | 11,583 | ||||||||||||||||||||||
CUW366 | HTWTP ST Improvements | Joint | $ | 1,398,798 | $ | 5,732,626 | $ | 7,131,424 | $ | — | $ | — | ||||||||||||||||||||
CUW366 | Joint | $ | 1,452,901 | $ | — | $ | 1,452,901 | $ | — | $ | — | |||||||||||||||||||||
CUW120 | WATER QUALITY PLANNING STUDY | Joint | $ | 577 | $ | — | $ | 577 | $ | 404 | ||||||||||||||||||||||
CUW164 | WATER VULNERABILITY STUDY-UEB | Joint | $ | 479 | $ | — | $ | 479 | $ | 336 | ||||||||||||||||||||||
CUW181 | STANDBY POWER FACILITIES | Joint | $ | 5,905 | $ | — | $ | 5,905 | $ | 4,139 | ||||||||||||||||||||||
CUW210 | Millbrae Administrative Bldg Remodel | Joint | $ | 7,803 | $ | 321,553 | $ | 329,356 | $ | 230,879 | ||||||||||||||||||||||
CUW220 | Calaveras Dam Evaluation | Joint | $ | 308,971 | $ | — | $ | 308,971 | $ | 216,589 | ||||||||||||||||||||||
CUW227 | Watershed Facilities and Fencing | Joint | $ | 190,552 | $ | 206,448 | $ | 397,000 | $ | 278,297 | ||||||||||||||||||||||
CUW228 | Watershed Roads | Joint | $ | 358,434 | $ | 85,337 | $ | 443,771 | $ | 311,083 | ||||||||||||||||||||||
CUW232 | Crystal Springs Dam Discharge | Joint | $ | 363,823 | $ | — | $ | 363,823 | $ | 255,040 | ||||||||||||||||||||||
CUW242 | } | Joint | $ | 311,548 | $ | 22,741 | $ | 334,289 | $ | 234,337 | ||||||||||||||||||||||
CUW242 | Demolition of Unsafe Structures | Joint | $ | 315 | $ | — | $ | 315 | $ | 221 | ||||||||||||||||||||||
CUW261 | Regional R&R — Storage | Joint | $ | 275,694 | $ | 277,958 | $ | 553,652 | $ | 388,110 | ||||||||||||||||||||||
CUW262 | } | Joint | $ | 1,236,895 | $ | 409,282 | $ | 1,646,177 | $ | 1,153,970 | ||||||||||||||||||||||
CUW262 | Regional R&R — Treatement | Joint | $ | 277,383 | $ | — | $ | 277,383 | $ | 194,445 |
Page 1 of 2
WHOLESALE CUSTOMERS’ SHARE OF THE BOOK VALUE OF REVENUE FUNDED CAPITAL EXPENDITURES
**PRELIMINARY — TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES**
(Section 5.03)
[1] | [2] | [3] | [4] | [5] | [6] | [7] | [8] | [9] | ||||||||||||||||||||||
Project | CWIP as of | FY 2008-09 | Reduction for | CWIP as | Water Related | Wholesale | ||||||||||||||||||||||||
No. | Project Description | Rate Class | 6/30/08 | Expenditures | 02A Funding | 6/30/09 | CWIP | Share | ||||||||||||||||||||||
CUW263 | } | Regional R&R — Transmission | Joint | $ | 768,422 | $ | 797,659 | $ | 1,566,081 | $ | 1,097,823 | |||||||||||||||||||
CUW263 | Joint | $ | 1,224,094 | $ | — | $ | 1,224,094 | $ | 858,090 | |||||||||||||||||||||
CUW360 | PLANNING — WSTD Sunol Quarry Reservoirs | Joint | $ | 2,513 | $ | — | $ | 2,513 | $ | 1,762 | ||||||||||||||||||||
CUW934 | BOA/BAW/13/F2/SFWD-CONT PROJ-OPER FD | Joint | $ | 59,479 | $ | (2,210 | ) | $ | 998,005 | $ | (940,736 | ) | $ | (659,456 | ) | |||||||||||||||
TOTAL REGIONAL WATER PROJECTS | $ | 313,100,517 | $ | 84,802,574 | $ | 379,397,925 | $ | 18,505,166 | $ | 12,972,121 | ||||||||||||||||||||
Less Projects to be Capitalized in FY 2008-09 | $ | 1,576,663 | $ | 1,105,241 | ||||||||||||||||||||||||||
ADJUSTED TOTAL REGIONAL WATER PROJECTS | $ | 16,928,503 | $ | 11,866,881 | ||||||||||||||||||||||||||
2 Wholesale Direct | ||||||||||||||||||||||||||||||
None | ||||||||||||||||||||||||||||||
B. | Hetch Hetchy Water & Power | |||||||||||||||||||||||||||||
CUH703 | Priest Reservoir By-pass | Joint | — | 47,164 | $ | 47,164 | $ | 21,224 | $ | 13,626 | ||||||||||||||||||||
CUH762 | SJPL Reparis | Water | 53,616 | 255,011 | $ | 308,627 | $ | 308,627 | $ | 198,139 | ||||||||||||||||||||
CUH766 | HH Security Improvements | Joint | 164,478 | 261,601 | $ | 426,079 | $ | 191,736 | $ | 123,094 | ||||||||||||||||||||
CUH767 | Power Transformers | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH803 | Street Lights | Power | — | 40,506 | $ | 40,506 | $ | — | $ | — | ||||||||||||||||||||
CUH804 | HH Roads | Joint | — | 341,240 | $ | 341,240 | $ | 153,558 | $ | 98,584 | ||||||||||||||||||||
CUH829 | HH SCADA | Joint | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH842 | Moccasin Cottages Renovations | Joint | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH846 | New Moccasin Penstock | Power | 543,073 | — | $ | 543,073 | $ | — | $ | — | ||||||||||||||||||||
CUH851 | Turbine Generator Renovations | Power | 111,755 | 926,254 | $ | 1,038,009 | $ | — | $ | — | ||||||||||||||||||||
CUH868 | Moccasin Energy Absorber | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH876 | Moccasin Phone System | Joint | — | 15,677 | $ | 15,677 | $ | 7,055 | $ | 4,529 | ||||||||||||||||||||
CUH878 | O’Shaugnessy Discharge/Toulumne River Channel Impr. | Joint | 31,953 | 168,076 | $ | 200,029 | $ | 90,013 | $ | 57,788 | ||||||||||||||||||||
CUH891 | Metering Muni Load | Power | 18 | 4,361 | $ | 4,379 | $ | — | $ | — | ||||||||||||||||||||
CUH893 | Cherry/Eleanor Pump Upgrade | Power | — | 17,012 | $ | 17,012 | $ | — | $ | — | ||||||||||||||||||||
CUH896 | Street Lights | Power | 9,294 | 568,794 | $ | 578,088 | $ | — | $ | — | ||||||||||||||||||||
CUH899 | Canyon Tunnel Penstock | Power | 6,210 | 21,804 | $ | 28,014 | $ | — | $ | — | ||||||||||||||||||||
CUH915 | UG Assessment/Hunters Point | Power | 961,755 | 1,668,663 | $ | 2,630,418 | $ | — | $ | — | ||||||||||||||||||||
CUH926 | Pipe Purchase | Water | — | 13,667 | $ | 13,667 | $ | 13,667 | $ | 8,774 | ||||||||||||||||||||
CUH931 | Microwave Replacement | Joint | 3,157,491 | 156,270 | $ | 3,313,761 | $ | 1,491,192 | $ | 957,346 | ||||||||||||||||||||
CUH932 | HH SCADA | Joint | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH825 | Distribution System | Power | 446,419 | 109,797 | $ | 556,216 | $ | — | $ | — | ||||||||||||||||||||
CUH941 | HHP SCADA Security & Control, East/O’Shaugnessy | Joint | 1,433,974 | 246,948 | $ | 1,680,922 | $ | 756,415 | $ | 485,618 | ||||||||||||||||||||
CUH942 | O’Shaugnessy Dam Discharge Needle Valves | Joint | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH943 | Renewable Energy | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH945 | SJPL Crossovers | Water | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH946 | Facility Maintenance | Joint | — | 239 | $ | 239 | $ | 108 | $ | 69 | ||||||||||||||||||||
CUH947 | Sustainable Energy Account | Power | 441,226 | 1,838,396 | $ | 2,279,622 | $ | — | $ | — | ||||||||||||||||||||
CUH948 | Facility Maintenance — Transmission Lines | Power | 70,631 | 101,295 | $ | 171,926 | $ | — | $ | — | ||||||||||||||||||||
CUH949 | POW Maintenance | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH950 | HPH/KPH/MPH | Power | 1,236,853 | 1,167,621 | $ | 2,404,474 | $ | — | $ | — | ||||||||||||||||||||
CUH955 | Solar Monitoring | Power | 222 | — | $ | 222 | $ | — | $ | — | ||||||||||||||||||||
CUH956 | Facility Maintenance — Gate Valves | Water | 275,213 | — | $ | 275,213 | $ | 275,213 | $ | 176,687 | ||||||||||||||||||||
CUH957 | Moccasin Corrison Control | Joint | 48,023 | 110,986 | $ | 159,009 | $ | 71,554 | $ | 45,938 | ||||||||||||||||||||
CUH958 | Generation Metering | Power | — | 18,811 | $ | 18,811 | $ | — | $ | — | ||||||||||||||||||||
CUH959 | Moccasin Reservoir Water Quality | Water | 109,379 | — | $ | 109,379 | $ | 109,379 | $ | 70,221 | ||||||||||||||||||||
CUH960 | Solar Power Project | Power | 6,480 | (5,333 | ) | $ | 1,147 | $ | — | $ | — | |||||||||||||||||||
CUH861 | MECA Solar | Power | — | 26,369 | $ | 26,369 | $ | — | $ | — | ||||||||||||||||||||
CUH962 | SF Electrical Reliability | Power | 9,672,565 | 2,653 | $ | 9,675,218 | $ | — | $ | — | ||||||||||||||||||||
CUH964 | Watershed Lan Purchase | Water | — | 75,756 | $ | 75,756 | $ | 75,756 | $ | 48,635 | ||||||||||||||||||||
CUH966 | MECA — Demand Reduction | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH969 | SFIA SCADA | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH971 | Neward — CCSF Tranmission Project | Power | 235,120 | 54,602 | $ | 289,722 | $ | — | $ | — | ||||||||||||||||||||
CUH972 | Load Metering | Power | 145,039 | 1,274 | $ | 146,313 | $ | — | $ | — | ||||||||||||||||||||
CUH973 | Distribution Assessment | Power | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
CUH975 | Hetch Hetchy Water R&R | Power | — | 130,100 | $ | 130,100 | $ | — | $ | — | ||||||||||||||||||||
CUH975 | Hetch Hetchy Water R&R | Water | 52,613 | 516,524 | $ | 569,137 | $ | 569,137 | $ | 365,386 | ||||||||||||||||||||
CUH975 | Hetch Hetchy Water R&R | Joint | 999,854 | 887,864 | $ | 1,887,718 | $ | 849,473 | $ | 545,362 | ||||||||||||||||||||
CUH976 | KPH Rewind | Power | 1,053,295 | 1,417,914 | $ | 2,471,209 | $ | — | $ | — | ||||||||||||||||||||
CUH977 | Facilities Maintenance — Water | Joint | 770,839 | 1,049,878 | $ | 1,820,717 | $ | 819,323 | $ | 526,005 | ||||||||||||||||||||
CUH978 | Community Choice Aggregation | Power | 5,571 | 101,075 | $ | 106,646 | $ | — | $ | — | ||||||||||||||||||||
CUH979 | Hunters Point Distribution | Power | 1,926,977 | 532,011 | $ | 2,458,988 | $ | — | $ | — | ||||||||||||||||||||
CUH981 | Shore Power for Cruise Ships | Power | 2,690 | — | $ | 2,690 | $ | — | $ | — | ||||||||||||||||||||
CUH986 | SEA — Energy Efficiency | Power | 15,262 | — | $ | 15,262 | $ | — | $ | — | ||||||||||||||||||||
CUW687 | 525 Golden Gate | Joint | — | 4,105 | $ | 4,105 | $ | 1,847 | $ | 1,186 | ||||||||||||||||||||
IUH004 | Auto Maintenance | Joint | — | 3,882 | $ | 3,882 | $ | 1,747 | $ | 1,122 | ||||||||||||||||||||
PUH501 | SF Environment Energy/Green Power | Power | — | 66,107 | $ | 66,107 | $ | — | $ | — | ||||||||||||||||||||
PYEAES | Youth Employment | Joint | — | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
TOTAL HHWP PROJECTS | 23,987,888 | 12,964,974 | — | 36,952,862 | 5,807,023 | $ | 3,728,109 | |||||||||||||||||||||||
C | TOTAL COMBINED WATER AND HHWP | $ | 337,088,405 | $ | 97,767,548 | $ | 379,397,925 | $ | 55,458,028 | $ | 15,594,990 |
1. | 6/30/08 CWIP per FAMIS | |
2. | FY 2008-09 Expenditures posted through 3/20/09 per FAMIS | |
3. | Wholesale share of CWIP 70.1% (see Note 5 Attachment K-1) | |
4. | Water Related HHWP CWIP includes 100% of Water and 45% of Joint | |
5. | Wholesale share of CWIP 64.2% (see Note 5 Attachment K-1) | |
6. | Fund 2A expenditures are funded by Series 2006A bond proceeds, proceeds of commercial paper redeemed from 2006A proceeds and earnings on such proceeds, as applicable. |
Page 2 of 2
25 YEAR PAYOFF SCHEDULE FOR EXISITING RATE BASE
WATER ENTERPRISE REGIONAL ASSETS AND ONE DIRECT WHOLESALE ASSET
**PRELIMINARY — TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES**
(Section 5.03)
Water Assets | ||||
6/30/09 Wholesale Share of Net Plant & CWIP (Attachment K-l) | 338,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-10 | 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 1 of 1
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 Rate: | 5.13 | % | ||
Term: | 25 | |||
Monthly Principal & 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 | 32,577,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 | 1,817,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 1 of 1
UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS
CONSTRUCTION WORK IN PROGRESS AS OF MARCH 30, 2009
(Section 5.04)
YTD | PTD | Available | ||||||||||||||||||||||||||||
Project | Project Title | Fund Type | Subfund | Classification | Appropriation | Expenditures | Expenditures | Encumbrances | Balances | Notes | ||||||||||||||||||||
Water Assets | ||||||||||||||||||||||||||||||
CUW257 | WATERSHED PROTECTION | 5W | AAAACP | REGIONAL | 1,448,720 | 29,653 | 413,529 | 141,643 | 893,548 | |||||||||||||||||||||
CUW250 | WATERSHED TRAILS&RECREATION IMPROV | 5W | AAAACP | REGIONAL | 387,639 | 9,431 | 112,689 | 6,675 | 268.275 | |||||||||||||||||||||
CUW261 | REGIONAL WATER STORAGE RNR -BUDGET | 5W | AAAACP | REGIONAL | 1,750,000 | 250,970 | 526,664 | 26,687 | 1,196,648 | Annual R&R | ||||||||||||||||||||
CUW242 | DEMOLITION UNSAFE STRUCTURES | 5W | AAAACP | REGIONAL | 1,000,000 | 22,647 | 407,820 | 21,524 | 570,656 | |||||||||||||||||||||
CUW263. | CONVEYANCE/TRANSMISSION - BUDGET | 5W | AAAACP | REGIONAL | 7,825,000 | 763,603 | 3,378,543 | 125,990 | 4,320,466 | Annual R&R | ||||||||||||||||||||
CUW264 | WATERSHED ROADS - BUDGET | 5W | AAAACP | REGIONAL | 3,000,000 | 77,074 | 1,391,500 | 162,401 | 1,446,099 | Annual R&R | ||||||||||||||||||||
CUW262 | TREATMENT FACS/WQ IMPROVE-BUDGET | 5W | AAAACP | REGIONAL | 4,801,000 | 399,073 | 2,704,204 | 349,016 | 1,747,780 | Annual R&R | ||||||||||||||||||||
CUW168 | ALAMEDA CREEK FISH RELEASE | 5W | AAAACP | REGIONAL | 1,537,398 | 46,624 | 1,040,919 | 152,647 | 343,832 | |||||||||||||||||||||
CUW231 | MILLBRAE LAB CAPITAL IMPROVEMENTS | 5W | AAAACP | REGIONAL | 770,000 | 19,119 | 532,135 | 0 | 237,865 | |||||||||||||||||||||
CUW227 | WATERSHED FENCES/FACILITES | 5W | AAAACP | REGIONAL | 3,000,000 | 206,222 | 2,223,776 | 581,926 | 194,298 | |||||||||||||||||||||
CUW253 | FACILITIES SECURITY PROJECT | 5W | AAAACP | REGIONAL | 5,300,000 | 73,048 | 4,146,944 | 113,124 | 1,039,931 | |||||||||||||||||||||
CUW210 | MILLBRAE ADMIN BLDG INTERIM REMODEL | 5W | AAAACP | REGIONAL | 2,407,700 | 284,902 | 1,935,204 | 160 | 472,337 | |||||||||||||||||||||
CUW228 | WATERSHED ROADS RECONSTRUCTION | 5W | AAAACP | REGIONAL | 5,170,000 | 82,992 | 4,413,061 | 18,598 | 738,340 | |||||||||||||||||||||
CUW202 | SAN ANTONIO PIPELINE EMERGENCY REPA | 5W | AAAACP | REGIONAL | 1,400,000 | 6,012 | 1,269,190 | 61,727 | 69,083 | |||||||||||||||||||||
CUW148 | ENVIRONMENTAL & REGULATORY COMP | 5W | AAAACP | REGIONAL | 3,241,279 | 0 | 3,014,995 | 184,774 | 41,510 | |||||||||||||||||||||
CUW135 | NEW LINE & BYPASS VALVES | 5W | AAAACP | REGIONAL | 4,829,680 | 2,103 | 4,689,067 | 0 | 140,613 | |||||||||||||||||||||
CUW143 | HETCH HETCHY WATER TREATMENT PLAN | 5W | AAAACP | REGIONAL | 18,821,529 | 0 | 18,452,053 | 47,947 | 321,529 | |||||||||||||||||||||
CUW161 | TREATMENT FACILITIES IMPROVEMENTS | 5W | AAAACP | REGIONAL | 15,028,319 | 334 | 14,747,873 | 0 | 280,446 | |||||||||||||||||||||
CUW241 | FACILITIES MAINT SUPPORT STRUCTURES | 5W | AAAACP | REGIONAL | 5,000,000 | 8,390 | 4,988,882 | 0 | 11,118 | |||||||||||||||||||||
CUW392 | PROGRAM MANAGEMENT SERVICES - WSIF | 5W | AAAACP | LOCAL/REGIONAL | 1,837,000 | (98,519 | ) | 751,659 | 71,973 | 1,013,368 | ||||||||||||||||||||
CUW127 | INST SCADA SYSTEM | 5W | AAAACP | LOCAL/REGIONAL | 13,156,681 | 2,481,274 | 8,653,641 | 0 | 4,503,040 | |||||||||||||||||||||
CUW710 | OCIP PROJECT CONTROL | 5W | AAAACP | LOCAL/REGIONAL | 2,497,881 | 235,706 | 2,496,959 | 0 | 922 | |||||||||||||||||||||
TOTAL ALL PROJECTS | 104,209,826 | 4,900,661 | 82,291,307 | 2,066,813 | 19,851,706 | |||||||||||||||||||||||||
LOCAL PROJECTS | LOCAL | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
JOINT LOCAL AND REGIONAL PROJECTS | LOCAL/REGIONAL | 17,491,562 | 2,618,462 | 11,902,259 | 71,973 | 5,517,330 | ||||||||||||||||||||||||
REGIONAL PROJECTS | REGIONAL | 86,718,264 | 2,282,199 | 70,389,048 | 1,994,840 | 14,334,376 | ||||||||||||||||||||||||
TOTAL ALL PROJECTS | 104,209,826 | 4,900,661 | 82,291,307 | 2,066,813 | 19,851,706 | |||||||||||||||||||||||||
Hetchy Hetchv Assets | ||||||||||||||||||||||||||||||
CUH975 | WATER INFRASTRUCTURE - BUDGET | 5T | AAAACP | WATER | 9,000,000 | 1,534,488 | 2,806,592 | 3,565,023 | 2,628,385 | |||||||||||||||||||||
CUH964 | WATERSHED PROPERTY PURCHASES | 5T | AAAACP | WATER | 800,000 | 75,756 | 454,756 | 0 | 345,244 | |||||||||||||||||||||
CUH957 | FAC MAINTENANCE-WATER TRANSPORTAT | 5T | AAAACP | WATER | 3,400,000 | 110,986 | 2,885,394 | 209,138 | 305,469 | |||||||||||||||||||||
CUH703 | PRIEST RESERVOIR DIVERSION CHANNEL | 5T | AAAACP | WATER | 21,210,344 | 47,164 | 20,166,993 | 0 | 1,043,351 | |||||||||||||||||||||
CUH926 | PIPELINE PURCHASE REPLACEMENT PIPE | 5T | AAAACP | WATER | 159,860 | 13,667 | 157,489 | 0 | 2,371 | |||||||||||||||||||||
CUH762 | SAN JOAQUIN PIPELINE REPAIRS | 5T | AAAACP | WATER | 41,469,206 | 255,011 | 41,215,761 | 134,652 | 118,792 | |||||||||||||||||||||
CUW687 | 525 GOLDEN GATE | 5T | AAAACP | JOINT | 280,600 | 4,105 | 26,437 | 0 | 254,163 | |||||||||||||||||||||
CUH977 | FACILITIES MAINTENANCE - BUDGET | 5T | AAAACP | JOINT | 9,300,000 | 1,049,878 | 3,578,478 | 803,231 | 4,918,290 | |||||||||||||||||||||
CUH931 | HH MICROWAVE REPLACEMENT | 5T | AAAACP | JOINT | 4,767,000 | 156,270 | 3,313,761 | 1,227,242 | 225,997 | |||||||||||||||||||||
CUH941 | HH SCADA SECURITY & CONTROL, EAST | 5T | AAAACP | JOINT | 2,068,180 | 246,948 | 1,680,922 | 256,198 | 131,060 | |||||||||||||||||||||
CUH804 | HETCH-HETCHY ROADS REBUILDING | 5T | AAAACP | JOINT | 4,175,027 | 341,240 | 3,544,483 | 113,314 | 517,230 | |||||||||||||||||||||
CUH766 | HETCHY FACILITIES SECURITY IMPROV. | 5T | AAAACP | JOINT | 2;086,692 | 261,601 | 1,960,386 | 62,470 | 63,836 | |||||||||||||||||||||
CUH876 | MOCCASIN PHONE SYSTEM | 5T | AAAACP | JOINT | 1,610,000 | 15,677 | 1,528,780 | 0 | 81,220 | |||||||||||||||||||||
CUH878 | O’SHAUGENESSY DISREPAIRS | 5T | AAAACP | JOINT | 7,179,009 | 33,750 | 7,101,644 | 9,297 | 68,068 | |||||||||||||||||||||
CUH810 | VARIOUS OLD JOB | 5T | AAAACP | JOINT | 7,613,638 | 18,690 | 7,538,034 | 1,561 | 74,044 | |||||||||||||||||||||
CUH946 | FAC MAINTENANCE-SUPPORT STRUCTURE | 5T | AAAACP | JOINT | 2,281,454 | 239 | 2,273,485 | 0 | 7,969 | |||||||||||||||||||||
CUH949 | RIGHT OF WAY MAINTENANCE | 5T | AAAACP | JOINT | 815,000 | 0 | 814,208 | 166 | 626 | |||||||||||||||||||||
TOTAL ALL PROJECTS | 118,216,010 | 4,165,470 | 101,047,602 | 6,382,292 | 10,786,117 | |||||||||||||||||||||||||
POWER PROJECTS | POWER | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
WATER PROJECTS | WATER | 76,039,410 | 2,037,072 | 67,686,985 | 3,908,812 | 4,443,613 | ||||||||||||||||||||||||
JOINT PROJECTS | JOINT | 42,176,600 | 2,128,397 | 33,360,617 | 2,473,480 | 6,342,504 | ||||||||||||||||||||||||
TOTAL ALL PROJECTS | 118,216,010 | 4,165,470 | 101,047,602 | 6,382,292 | 10,786,117 |
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project | ||||
Number | ||||
REGIONAL | Project Description | |||
San Joaquin Region | ||||
CUW373 | Regional | San Joaquin Pipeline System Rehabilitation | ||
CUW384 | Regional | Tesla Advance Disinfection | ||
CUW387 | Regional | Tesla Portal Disinfection | ||
Sunol Valley Region | ||||
CUW352 | Regional | Alameda Creek Fishery Enhancement | ||
CUW355 | Regional | Stand-by Power — Various Locations | ||
CUW359 | Regional | New Irvington Tunnel/Alameda Siphon No. 4 | ||
CUW370 | Regional | Pipeline Readiness Improvements | ||
CUW374 | Regional | Calaveras Dam Replacement | ||
CUW381 | Regional | SVWTP 40 mgd Addition | ||
CUW382 | Regional | SVWTP Finished Water Reservoir | ||
CUW386 | Regional | San Antonio Pump Station Upgrade | ||
Bay Division Region | ||||
CUW353 | Regional | Seismic Upgrade BDPL 3 & 4 | ||
CUW363 | Regional | SCADA Phase II/Security Upgrades | ||
CUW368 | Regional | BDPL Reliability Upgrades | ||
CUW380 | Regional | BDPL 3 & 4 Crossover | ||
CUW389 | Regional | EBMUD Intertie | ||
CUW393 | Regional | BDPL 4 Slipline | ||
Peninsula Region | ||||
CUW354 | Regional | Lower Crystal Springs Dam Improvement | ||
CUW356 | Regional | Crystal Springs Bypass Tunnel | ||
CUW357 | Regional | Adit Leak Repairs | ||
CUW361 | Regional | Pulgas Balancing Reservoir Rehabilitation and Improvements | ||
CUW365 | Regional | Cross Connection Control | ||
CUW366 | Regional | HTWTP Short Term Improvements | ||
CUW367 | Regional | HTWTP Long Term Improvements | ||
CUW369 | Regional | Capuchino Valve Lot Improvements | ||
CUW371 | Regional | Crystal Springs/San Andreas Transmission | ||
CUW378 | Regional | Crystal Springs Pipleine 2 Replacement | ||
CUW379 | Regional | San Andreas Pipeline 3 Installation | ||
CUW390 | Regional | Desalination | ||
CUW391 | Regional | Baden & San Pedro Valve Lots Improvements |
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 | ||||
CUW307 | 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 | Crocker 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 Hill 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 |
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project | ||||
Number | Project Description | |||
Pipelines/Valves | ||||
CUW304 | Local | North University Mound System Upgrade | ||
CUW308 | Local | Motorize Key Valves | ||
CUW311 | Local | Sunset Circulation Improvements | ||
CUW312 | Local | Lincoln Way Transmission Line | ||
CUW313 | Local | Noe Valley Transmission Main, Phase 2 | ||
CUW315 | Local | East/West Transmission Main | ||
CUW316 | Local | Fulton @ Six the Ave Main Replacement | ||
Water Supply/Water Quality | ||||
CUW301 | Local | Groundwater | ||
CUW302 | Local | Recycled Water | ||
CUW364 | Local | Lawrence-Livermore National Laboratory Water Quality Improvements | ||
Miscellaneous | ||||
CUW303 | Local | Vehicle Service Facility Upgrade | ||
CUW305 | Local | Fire Protection at CCD |
PUBLIC UTILITIES COMMISSION
OF THE CITY AND COUNTY OF SAN FRANCISCO
SAN FRANCISCO WATER REVENUE BONDS, 2006 SERIES A
PUBLIC UTILITIES COMMISSION
OF THE CITY AND COUNTY OF SAN FRANCISCO
SAN FRANCISCO WATER REVENUE BONDS, 2006 REFUNDING SERIES B
CONTINUED
PUBLIC UTILITIES COMMISSION OF THE | ||||
CITY AND COUNTY OF SAN FRANCISCO | ||||
By: | /s/ Edward Harrington | |||
General Manager |
2
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
SUMMARY OF SOURCES AND USES OF FUNDS
(Section 5.04)
Proceeds | ||||||||||||
Principal | 507,815,000.00 | |||||||||||
Plus Premium | 19,109,138.35 | |||||||||||
Minus Underwriter’s Discount | (932,940.06 | ) | ||||||||||
Minus Insurance | (1,973,563.58 | ) | ||||||||||
Net Proceeds | 524,017,634.71 | |||||||||||
Use of Proceeds | ||||||||||||
Capitalized Interest Fund | 48,212,528.32 | |||||||||||
Bond Reserve Fund | 15,958,031.25 | |||||||||||
Insurance Fund | 623,906.09 | |||||||||||
Series A Refunding Fund | 120,622,352.19 | } | 459,223,169.05 | |||||||||
Series A Project Fund | 338,600,816.86 | |||||||||||
Total Uses | 524,017,634.71 |
Commercial Paper | Project Fund | Total | ||||||||||
Hetch Hetchy | ||||||||||||
Tesla 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 Mound — 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 Regional | 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 | |||||||||
SVWTP40 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 |
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
SUMMARY OF SOURCES AND USES OF FUNDS
(Section 5.04)
Miscellaneous | ||||||||||||||||
PEIR | 3,204,177.44 | 5,103,872.56 | 8,308,050.00 | |||||||||||||
PPPCMS Services | 2,964,786.31 | 10,358,811.69 | 13,323,598.00 | |||||||||||||
Watershed Land Acquisition | — | 502,660.00 | 502,660.00 | |||||||||||||
Total Miscellaneous | 6,168,963.75 | 15,965,344.25 | 22,134,308.00 | |||||||||||||
LLNL | 133,156.60 | 282,702.40 | 415,859.00 | |||||||||||||
Bay Division Subregional | ||||||||||||||||
Seismic Upgrade BDPL 3 & 4 | 4,758,306.54 | 16,481,539.46 | 21,239,846.00 | |||||||||||||
BDPL Reliability | 4,360,664.44 | 40,874,800.56 | 45,235,465.00 | |||||||||||||
BDPL 3 & 4 Crossover | 802,494.94 | 493,817.06 | 1,296,312.00 | |||||||||||||
SCADA Phase II | 65,497.37 | 1,247,963.63 | 1,313,461.00 | |||||||||||||
EBMUD Intertie | 6,668,906.37 | 4,075,015.63 | 10,743,922.00 | |||||||||||||
BDPL 4 Slipline | — | 1,219,251.00 | 1,219,251.00 | |||||||||||||
Total Bay Division Subregional | 16,655,869.66 | 64,392,387.34 | 81,048,257.00 | |||||||||||||
Peninsula Subregional | ||||||||||||||||
Capuchino Valve Lot | 162,584.69 | 753,779.31 | 916,364.00 | |||||||||||||
CS/SA Transmission | 2,288,853.10 | 3,448,975.90 | 5,737,829.00 | |||||||||||||
Adit Leak Repair | 255,334.99 | 1,650,368.01 | 1,905,703.00 | |||||||||||||
HTWTP Short Term | 2,874,763.69 | 3,582,860.31 | 6,457,624.00. | |||||||||||||
Cross Connection Control | 1,150,559.48 | 324,549.52 | 1,475,109.00 | |||||||||||||
CS Bypass Tunnel | 2,873,475.22 | 15,532,584.78 | 18,406,060.00 | |||||||||||||
LCS Dam Improvement | 931,587.07 | 3,278,932.93 | 4,210,520.00 | |||||||||||||
Pulgas Balancing Reservoir | 1,218,341.39 | 2,706,284.61 | 3,924,626.00 | |||||||||||||
HTWTP Long Term | 1,107,185.77 | 2,549,793.23 | 3,656,979.00 | |||||||||||||
Baden & San Pedro Valve Lots | 60,203.48 | 2,963,540.52 | 3,023,744.00 | |||||||||||||
Total Peninsula Subregional | 12,922,888.88 | 36,791,669.12 | 49,714,558.00 | |||||||||||||
San Francisco Subregional | ||||||||||||||||
CSPL 2 Replacement | 1,269,111.95 | 5,019,824.05 | 6,288,936.00 | |||||||||||||
SAPL 3 | 1,492,584.40 | 1,942,479.60 | 3,435,064.00 | |||||||||||||
Desalination | 55,618.10 | 596,473.90 | 652,092.00 | |||||||||||||
Total San Francisco Subregional | 2,817,314.45 | 7,558,777.55 | 10,376,092.00 | |||||||||||||
Grand Total | 120,622,352.19 | 359,746,902.82 | 480,369,255.01 | |||||||||||||
Regional | 328,140,295.00 | 68.31 | % | |||||||||||||
Local | 152,228,960.01 | 31.69 | % | |||||||||||||
480,369,255.01 |
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)
Appropriated | Adjusted | |||||||||||||||||||||||
Project | Net Financing | Interest | Project | Expenditures | Remaining | |||||||||||||||||||
Number | Project Description | Proceeds1 | Earnings2 | Funding | Thru 6/30/093 | Balance | ||||||||||||||||||
REGIONAL PROGRAM | ||||||||||||||||||||||||
San Joaquin Region | ||||||||||||||||||||||||
CUW373 | Regional | San Joaquin Pipeline System Rehabilitation | 1,398,565 | |||||||||||||||||||||
CUW384 | Regional | Tesla Advance Disinfection | 6,041,269 | |||||||||||||||||||||
CUW387 | Regional | Tesla Portal Disinfection | 22,522,605 | |||||||||||||||||||||
Total San Joaquin Region | 29,962,439 | |||||||||||||||||||||||
Sunol Valley Region | ||||||||||||||||||||||||
CUW352 | Regional | Alameda Creek Fishery Enhancement | 1.983,884 | |||||||||||||||||||||
CUW355 | Regional | Stand-by Power — Various Locations | 1,763,718 | |||||||||||||||||||||
CUW359 | Regional | New Irvington Tunnel/Alameda Siphon No. 4 | 22.331,316 | |||||||||||||||||||||
CUW370 | Regional | Pipeline Readiness Improvements | 5,591,772 | |||||||||||||||||||||
CUW374 | Regional | Calaveras Dam Replacement | 25,059,764 | |||||||||||||||||||||
CUW381 | Regional | SVWTP40 mgd Addition | 3,499,964 | |||||||||||||||||||||
CUW382 | Regional | SVWTP Finished Water Reservoir | 11,155,587 | |||||||||||||||||||||
CUW386 | Regional | San Antonio Pump Station Upgrade | 1,961,558 | |||||||||||||||||||||
Total Sunol Valley Region | 73,347,563 | |||||||||||||||||||||||
Bay Division Region | ||||||||||||||||||||||||
CUW353 | Regional | Seismic Upgrade BDPL 3 & 4 | 21,234,846 | |||||||||||||||||||||
CUW363 | Regional | SCADA Phase II/Security Upgrades | 1,313,461 | |||||||||||||||||||||
CUW368 | Regional | BDPL Reliability Upgrades | 45,235,465 | |||||||||||||||||||||
CUW380 | Regional | BDPL 3 & 4 Crossover | 21,239,846 | |||||||||||||||||||||
CUW389 | Regional | EBMUD Intertie | 10,743,922 | |||||||||||||||||||||
CUW393 | Regional | BDPL 4 Slipline | 1,219,251 | |||||||||||||||||||||
Total Bay Division Region | 100,986,791 | |||||||||||||||||||||||
Peninsula Region | ||||||||||||||||||||||||
CUW354 | Regional | Lower Crystal Springs Dam Improvement | 4,210,520 | |||||||||||||||||||||
CUW356 | Regional | Crystal Springs Bypass Tunnel | 18,406,050 | |||||||||||||||||||||
CUW357 | Regional | Adit Leak Repairs | 1,905,703 | |||||||||||||||||||||
CUW361 | Regional | Pulgas Balancing Reservoir Rehabilitation and Improvements | 3,924,626 | |||||||||||||||||||||
CUW365 | Regional | Cross Connection Control | 1,475,109 | |||||||||||||||||||||
CUW366 | Regional | HTWTP Short Term Improvements | 6,457,624 | |||||||||||||||||||||
CUW367 | Regional | HTWTP Long Term Improvements | 3,656,979 | |||||||||||||||||||||
CUW369 | Regional | Capuchino Valve Lot Improvements | 916,364 | |||||||||||||||||||||
CUW371 | Regional | Crystal Springs/San Andreas Transmission | 5,737,829 | |||||||||||||||||||||
CUW378 | Regional | Crystal Springs Pipleine 2 Replacement | 6,288,936 | |||||||||||||||||||||
CUW379 | Regional | San Andreas Pipeline 3 Installation | 3,435,064 | |||||||||||||||||||||
CUW390 | Regional | Desalination | 652,092 | |||||||||||||||||||||
CUW391 | Regional | Baden & San Pedro Valve Lots Improvements | 3,023,744 | |||||||||||||||||||||
Total Peninsula Region | 60,090,650 | |||||||||||||||||||||||
San Francisco Region | ||||||||||||||||||||||||
CUW358 | Regional | Sunset Reservoir Upgrades — North Basin | 6,020,008 | |||||||||||||||||||||
CUW372 | Regional | University Mound Reservoir Upgrades — North Basin | 36,307,991 | |||||||||||||||||||||
Total San Francisco Region | 42,327,999 | |||||||||||||||||||||||
System-Wide | ||||||||||||||||||||||||
CUW388 | Regional | PEIR | 8,308,050 | |||||||||||||||||||||
CUW392 | Regional | Program Management Services | 13,323,598 | |||||||||||||||||||||
CUW394 | Regional | Watershed Land Acquisition | 502,660 | |||||||||||||||||||||
Total System-Wide | 22,134,308 | |||||||||||||||||||||||
Total Regional Program | 328,849,750 | |||||||||||||||||||||||
LOCAL PROGRAM | ||||||||||||||||||||||||
Reservoirs | ||||||||||||||||||||||||
CUW307 | 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 Rehabilitation | ||||||||||||||||||||||
CUW337 | Local | Sutro Reservoir Rehabilitation | ||||||||||||||||||||||
Total Reservoirs | ||||||||||||||||||||||||
Pump Stations/Tanks | ||||||||||||||||||||||||
CUW306 | Local | Crocker 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 Hill 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 |
ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS
AS OF JUNE 30, 2009
(Section 5.04 A)
Appropriated | Adjusted | |||||||||||||||||||||||
Project | Net Financing | Interest | Project | Expenditures | Remaining | |||||||||||||||||||
Number | Project Description | Proceeds1 | Earnings2 | Funding | Thru 6/30/093 | Balance | ||||||||||||||||||
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 | ||||||||||||||||||||||
Total Pump Stations/Tanks | ||||||||||||||||||||||||
Pipelines/Valves | ||||||||||||||||||||||||
CUW304 | Local | North University Mound System Upgrade | ||||||||||||||||||||||
CUW308 | Local | Motorize Key Valves | ||||||||||||||||||||||
CUW311 | Local | Sunset Circulation Improvements | ||||||||||||||||||||||
CUW312 | Local | Lincoln Way Transmission Line | ||||||||||||||||||||||
CUW313 | Local | Noe Valley Transmission Main, Phase 2 | ||||||||||||||||||||||
CUW315 | Local | East/West Transmission Main | ||||||||||||||||||||||
CUW316 | Local | Fulton @ Sixth Ave Main Replacement | ||||||||||||||||||||||
Total Pipelines Valves | ||||||||||||||||||||||||
Water Supply/Water Quality | ||||||||||||||||||||||||
CUW301 | Local | Groundwater | ||||||||||||||||||||||
CUW302 | Local | Recycled Water | ||||||||||||||||||||||
CUW364 | Local | Lawrence-Livermore National Laboratory Water Quality Improvements | ||||||||||||||||||||||
Total Water Supply/Water Quality | ||||||||||||||||||||||||
Miscellaneous | ||||||||||||||||||||||||
CUW303 | Local | Vehicle Service Facility Upgrade | ||||||||||||||||||||||
CUW305 | Local | Fire Protection at CCD | ||||||||||||||||||||||
Total Miscellaneous | ||||||||||||||||||||||||
Total Local Program | ||||||||||||||||||||||||
Grand Total Regional and Local Programs | ||||||||||||||||||||||||
Unappropriated Interest Earnings | ||||||||||||||||||||||||
Percent of Net Proceeds4 | ||||||||||||||||||||||||
Percent of Net Proceeds and Earnings4 |
1 | Net financing proceeds available on date of issue (i.e. deposit to project fund) | |
2 | Cumulative net of arbitrage rebate liability | |
3 | Cumulative | |
4 | if financing sources Substantially Expended, proceed allocations are then fixed |
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.B) | ATTACHMENT M-1 | |
Subfund: 5W CPF WCF — Wholesale Customer Capital Fund (Water) | Page 1 of 2 | |
Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year) | ||||||||||||||||||||||||||||||||||||||
A | B | C | D | E | F | G=C-D-F | H | I=G-H | ||||||||||||||||||||||||||||||
Wholesale Customer Capital Fund (5W CPF WCF) | ||||||||||||||||||||||||||||||||||||||
Based on Proportionate Annual Water Deliveries of ... | 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 / | ||||||||||||||||||||||||||||||
Project | Title | Total Regional | SHARE | All Years^ | Expenditures^ | Expenditures^ | Expended^ | Balance^ | 6/30/2010 | (Shortfall) | ||||||||||||||||||||||||||||
CUW262 | Regional Water RnR — Treatment Facilities | $ | 1,000,000 | $ | 687,000 | $ | 687,000 | $ | — | $ | — | $ | — | $ | 687,000 | $ | 229,000 | $ | 458,000 | |||||||||||||||||||
CUW263 | Regional Water RnR — Conveyance/Transmission Systems | $ | 7,000,000 | $ | 4,809,000 | $ | 4,809,000 | $ | — | $ | — | $ | — | $ | 4,809,000 | $ | 1,603,000 | $ | 3,206,000 | |||||||||||||||||||
CUW264 | Regional Water — Watersheds / ROW Management | $ | 500,000 | $ | 343,500 | $ | 343,500 | $ | — | $ | — | $ | — | $ | 343,500 | $ | 114,000 | $ | 229,500 | |||||||||||||||||||
FUW100 | Regional Water — Facilities Maintenance | $ | 3,700,000 | $ | 2,541,900 | $ | 2,541,900 | $ | — | $ | — | $ | — | $ | 2,541,900 | $ | 847,000 | $ | 1,694,900 | |||||||||||||||||||
CUW261 | Regional Water — Storage | |||||||||||||||||||||||||||||||||||||
Regional Total | $ | 12,200,000 | $ | 8,381,400 | $ | 8,381,400 | $ | — | $ | — | $ | — | $ | 8,381,400 | $ | 2,793,000 | $ | 5,588,400 | ||||||||||||||||||||
Source: | * SFPUC Commission Approved Budget, February 2009, Same Format |
^ FAMIS — City’s Official Financial System of Record |
Subfund: 5W CPF WCF — Wholesale Customer Capital Fund (Water) | Projected FAMIS as of June 30, 2010 (Last Day of Budget Year) | |
Wholesale Customer Capital Fund (5W CPF WCF) | ||||||||||||||||||||||||||||||||||||||
Based on Proportionate Annual Water Deliveries of ... | 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 / | ||||||||||||||||||||||||||||||
Project | Title | Total Regional | SHARE | All Years^ | Expenditures^ | Expenditures^ | Expended^ | Balance^ | 6/30/2011 | (Shortfall) | ||||||||||||||||||||||||||||
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 — Conveyance/Transmission 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 / 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 | $ | 8,381,400 | $ | 2,595,000 | $ | 2,595,000 | $ | 198,000 | $ | 5,588,400 | $ | 2,802,400 | $ | 2,786,000 | ||||||||||||||||||||
Source: | * SFPUC Commission Approved Budget, February 2009, Same Format |
^ FAMIS — City’s Official Financial System of Record |
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.B) | ATTACHMENT M-1 | |
Subfund: 5T CPF WCF — Wholesale Customer Capital Fund (Hetch Hetchy) | Page 2 of 2 | |
Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year) | ||||||||||||||||||||||||||||||||||||||
A | B | C | D | E | F | G=C-D-F | H | I=G-H | ||||||||||||||||||||||||||||||
Wholesale Customer Capital Fund (5w CPF WCF) | ||||||||||||||||||||||||||||||||||||||
Based on Proportionate Annual Water Deliveries of ... | 68.1% | |||||||||||||||||||||||||||||||||||||
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 / | ||||||||||||||||||||||||||||||
Project | Title | Total Regional | SHARE | All Years^ | Expenditures^ | Expenditures^ | Expended^ | Balance^ | 6/30/2010 | (Shortfall) | ||||||||||||||||||||||||||||
CUH931 | HH Microwave Replacement | $ | 4,000,000 | J | $ | 1,224,900 | $ | 1,224,900 | $ | — | $ | — | $ | — | $ | 1,224,900 | $ | 408,000 | $ | 816,900 | ||||||||||||||||||
CUH977 | HH Water R&R — Facilities Maintenance | $ | 3,500,000 | J | $ | 1,071,788 | $ | 1,071,788 | $ | — | $ | — | $ | — | $ | 1,071,788 | $ | 357,000 | $ | 714,788 | ||||||||||||||||||
CUH947 | SEA — Go Solar Incentive Project | $ | 4,000,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH971 | Alternative Transmission Studies | $ | 1,000,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH976 | HH Water R&R — Power Infrastructure | $ | 16,700,000 | P | $ | — | $ | — | $ | — | ||||||||||||||||||||||||||||
CUH979 | Hunters Point Municipal Power | $ | — | P | $ | — | $ | — | $ | — | ||||||||||||||||||||||||||||
CUH983 | Civic Center Sustainability District | $ | 1,090,000 | P | $ | — | $ | — | $ | — | ||||||||||||||||||||||||||||
CUH986 | General Fund Dept — Energy Efficiency | $ | 7,365,158 | P | $ | — | $ | — | $ | — | ||||||||||||||||||||||||||||
Renewable/Generation | $ | 3,501,307 | P | $ | — | $ | — | $ | — | |||||||||||||||||||||||||||||
Treasure Island Improvement Project | $ | 2,700,000 | P | $ | — | $ | — | $ | — | |||||||||||||||||||||||||||||
Enterprise Fund Dept — Energy Efficiency | $ | 325,722 | P | $ | — | $ | — | $ | — | |||||||||||||||||||||||||||||
CUH975 | HH Water R&R — Water Infrastructure | $ | 6,000,000 | W | $ | 4,083,000 | $ | 4,083,000 | $ | 1,361,000 | ||||||||||||||||||||||||||||
Toulumne River Watershed Protection | $ | 2,000,000 | W | $ | 1,361,000 | $ | 1,361,000 | $ | 454,000 | |||||||||||||||||||||||||||||
Regional Total | $ | 52,182,187 | $ | 7,740,688 | $ | 7,740,688 | $ | — | $ | — | $ | — | $ | 2,296,688 | $ | 2,580,000 | $ | 1,531,6881 | ||||||||||||||||||||
Source: | * SFPUC Commission Approved Budget. February 2009, Same Format | |
^ FAMIS — City’s Official Financial System of Record |
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.B) | Projected FAMIS as of June 30, 2010 (Last Day of Budget Year) | |
Subfund: 5T CPF WCF — Wholesale Customer Capital Fund (Hetch Hetchy) | ||
�� | ||||||||||||||||||||||||||||||||||||||
Wholesale Customer Capital Fund (5W CPF WCF) | ||||||||||||||||||||||||||||||||||||||
Based on Proportionate Annual Water Deliveries of ... | 68.1% | |||||||||||||||||||||||||||||||||||||
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 / | ||||||||||||||||||||||||||||||
Project | Title | Total Regional | SHARE | All Years^ | Expenditures^ | Expenditures^ | Expended^ | Balance^ | 6/30/2011 | (Shortfall) | ||||||||||||||||||||||||||||
CUH931 | HH Microwave Replacement | $ | 4,000,000 | J | $ | 1,224,900 | $ | 1,224,900 | $ | 1,224,900 | $ | 1,224,900 | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH977 | HH Water R&R — Facilities Maintenance | $ | 3,500,000 | J | $ | 1,071,788 | $ | 1,071,788 | $ | 1,071,788 | $ | 1,071,788 | $ | — | $ | (1 | ) | $ | (1 | ) | $ | — | ||||||||||||||||
CUH947 | SEA — Go Solar Incentive Project | $ | 4,000,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH971 | Alternative Transmission Studies | $ | 1,000,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH976 | HH Water R&R — Power Infrastructure | $ | 16,700,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH979 | Hunters Point Municipal Power | $ | — | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH983 | Civic Center Sustainability District | $ | 1,090,000 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
CUH986 | General Fund Dept — Energy Efficiency | $ | 7,365,158 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
Renewable/Generation | $ | 3,501,307 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||
Treasure Island Improvement Project | $ | 2,700,000 | P | $ | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||||
Enterprise Fund Dept — Energy Efficiency | $ | 325,722 | P | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||
CUH975 | HH Water R&R — Water Infrastructure | $ | 6,000,000 | W | $ | 4,083,000 | $ | 4,083,000 | $ | 4,083,000 | $ | 4,083,000 | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
Toulumne River Watershed Protection | $ | 2,000,000 | W | $ | 1,361,000 | $ | 1,361,000 | $ | 1,361,000 | $ | 1,361,000 | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||
Regional Total | $ | 52,182,187 | $ | 7,740,688 | $ | 7,740,688 | 7,740,688 | $ | 7,740,688 | $ | — | $ | (1 | ) | $ | (1 | ) | $ | — | |||||||||||||||||||
Source: | * SFPUC Commission Approved Budget, February 2009, Same Format | |
^ FAMIS — City’s Official Financial System of Record |
ANNUAL REPORTING REQUIREMENTS
(Section 5.04B)
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 |
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 |
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. |
WHOLESALE REVENUE-FUNDED CAPITAL FUND — BALANCING ACCOUNT ADJUSTMENT
** EXAMPLE REPORTING FORMAT **
(Section 6.08)
(1) | (2) | (3) | (4) | (5) | (1) | (2) | (3) | (4) | (5) | (1) | ||||||||||||||||||||||||||||||||||||||
FY 2009-10 | FY 2010-11 | FY 2011-12 | FY 2012-13 | FY 2013-14 | FY 2014-15 | FY 2015-16 | FY 2016-17 | FY 2017-18 | FY 2018-19 | FY 2019-20 | ||||||||||||||||||||||||||||||||||||||
a. | Beginning balance | $ | 0 | $ | 5,671,414 | $ | 8,960,834 | $ | 9,669,194 | $ | 10,420,781 | $ | 11,217,991 | $ | 5,498,801 | $ | 6,198,022 | $ | 6,944,933 | $ | 7,742,299 | $ | 8,593,037 | |||||||||||||||||||||||||
b. | Transfer to Balancing Account | $ | 0 | $ | (6,467,533 | ) | $ | (2,574,995 | ) | |||||||||||||||||||||||||||||||||||||||
Year 1 | ||||||||||||||||||||||||||||||||||||||||||||||||
c. | Budgeted appropriation | $ | 8,381,400 | $ | 10,697,026 | $ | 13,652,417 | |||||||||||||||||||||||||||||||||||||||||
d. | Encumbrance/Expenditure | $ | (2,793,800 | ) | $ | (2,793,800 | ) | $ | (2,793,800 | ) | $ | (3,565,675 | ) | $ | (3,565,675 | ) | $ | (3,565,675 | ) | $ | (4,550,806 | ) | ||||||||||||||||||||||||||
Year 2 | ||||||||||||||||||||||||||||||||||||||||||||||||
e. | Budgeted appropriation | $ | 8,800,470 | $ | 11,231,878 | |||||||||||||||||||||||||||||||||||||||||||
f. | Encumbrance/Expenditure | $ | (2,933,490 | ) | $ | (2,933,490 | ) | $ | (2,933,490 | ) | $ | (3,743,959 | ) | $ | (3,743,959 | ) | $ | (3,743,959 | ) | |||||||||||||||||||||||||||||
Year 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
g. | Budgeted appropriation | $ | 9,240,494 | $ | 11,793,471 | |||||||||||||||||||||||||||||||||||||||||||
h. | Encumbrance/Expenditure | $ | (3,080,165 | ) | $ | (3,080,165 | ) | $ | (3,080,165 | ) | $ | (3,931,157 | ) | $ | (3,931,157 | ) | $ | (3,931,157 | ) | |||||||||||||||||||||||||||||
Year 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
i. | Budgeted appropriation | $ | 9,702,518 | $ | 12,383,145 | |||||||||||||||||||||||||||||||||||||||||||
j. | Encumbrance/Expenditure | $ | (3,234,173 | ) | $ | (3,234,173 | ) | $ | (3,234,173 | ) | $ | (4,127,715 | ) | $ | (4,127,715 | ) | $ | (4,127,715 | ) | |||||||||||||||||||||||||||||
Year 5 | ||||||||||||||||||||||||||||||||||||||||||||||||
k. | Budgeted appropriation | $ | 10,187,644 | $ | 13,002,302 | |||||||||||||||||||||||||||||||||||||||||||
l. | Encumbrance/Expenditure | $ | (3,395,881 | ) | $ | (3,395,881 | ) | $ | (3,395,881 | ) | $ | (4,334,101 | ) | $ | (4,334,101 | ) | ||||||||||||||||||||||||||||||||
m. | Subtotal | $ | 5,587,600 | $ | 8,744,594 | $ | 9,393,873 | $ | 10,123,885 | $ | 10,898,206 | $ | 5,251,755 | $ | 6,025,163 | $ | 6,750,702 | $ | 7,525,246 | $ | 8,351,628 | $ | 6,657,838 | |||||||||||||||||||||||||
n. | Interest earnings (e.g., 3%) | $ | 83,814 | $ | 216,240 | $ | 275,321 | $ | 296,896 | $ | 319,785 | $ | 247,046 | $ | 172,859 | $ | 194,231 | $ | 217,053 | $ | 241,409 | $ | 228,763 | |||||||||||||||||||||||||
o. | Ending fund balance (unencumbered, unexpended) | $ | 5,671,414 | $ | 8,960,834 | $ | 9,669,194 | $ | 10,420,781 | $ | 11,217,991 | $ | 5,498,801 | $ | 6,198,022 | $ | 6,944,933 | $ | 7,742,299 | $ | 8,593,037 | $ | 6,886,601 | |||||||||||||||||||||||||
p. | Five Year Cumulative Appropriations w/ interest | $ | 47,504,581 | $ | 60,180,421 | |||||||||||||||||||||||||||||||||||||||||||
q. | 10% of Cumulative Appropriations w/ interest | $ | 4,750,458 | $ | 6,018,042 | |||||||||||||||||||||||||||||||||||||||||||
r. | Ending fund balance | $ | 11,217,991 | $ | 8,593,037 | |||||||||||||||||||||||||||||||||||||||||||
s. | Excess balance transferred to Balancing Account* | $ | (6,467,533 | ) | $ | (2,574,995 | ) |
* | Test: Any balance in excess of 10% of the cumulative five-year appropriation total is credited to the balancing account. |
BALANCING ACCOUNT/RATE SETTING CALCULATION | ATTACHMENT N-1 | |
REFERENCE SECTION 6.03.A.3.a | Page 1 |
FY 2007-08 | FY 2008-09 | FY 2009-10 | ||||||||||
Step 1: | ||||||||||||
A. Balancing Account as of June 30, 2007 | $ | 12,882,000 | ||||||||||
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year | $ | 554,000 | ||||||||||
C. Wholesale Revenues for Fiscal Year | ($ | 113,932,000 | ) | |||||||||
D. Wholesale Revenue Requirement for Fiscal Year | $ | 119,224,000 | ||||||||||
E. Settlement Credits or Other Adjustments | $ | 2,448,614 | ||||||||||
F. 1984 Agreement Balancing Account Credits | $ | 0 | ||||||||||
G. Balancing Account as of June 30, 2008 | $ | 21,176,614 | ||||||||||
Step 2: | ||||||||||||
A. Balancing Account as of June 30, 2008 | $ | 21,176,614 | ||||||||||
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year | $ | 529,000 | ||||||||||
C. Wholesale Revenues for Fiscal Year | -$ | 123,604,000 | ||||||||||
D. Wholesale Revenue Requirement for Fiscal Year | $ | 120,562,000 | ||||||||||
E. Settlement Credits or Other Adjustments | $ | 21,000 | ||||||||||
F. 1984 Agreement Balancing Account Credits | $ | 0 | ||||||||||
G. Balancing Account as of June 30, 2009 | $ | 18,684,614 | ||||||||||
Step 3: | ||||||||||||
A. Balancing Account as of June 30, 2009 | $ | 0 | ||||||||||
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year | $ | 0 | ||||||||||
C. Wholesale Revenues for Fiscal Year | -$ | 127,485,900 | ||||||||||
D. Wholesale Revenue Requirement for Fiscal Year | $ | 140,994,733 | ||||||||||
E. Settlement Credits or Other Adjustments | $ | 21,000 | ||||||||||
F. 1984 Agreement Balancing Account Credits | $ | 1,997,220 | ||||||||||
G. Balancing Account as of June 30, 2010 | $ | 15,527,053 | ||||||||||
H. Net Change in Wholesale Revenue Coverage | $ | 4,488,233 | ||||||||||
I. Total Revenue Deficiency or Surplus | $ | 20,015,286 | ||||||||||
J. Project Water Sales in Ccf | 84,621,240 | 83,205,600 | 85,920,000 | |||||||||
K. Deficiency or (Surplus) $/Ccf | $ | 0.23 | ||||||||||
L. Deficiency or (Surplus) Ccf as a Percentage of Revenues | 15.7 | % |
Page 2
METHOD OF CALCULATION
REFERENCE SECTION 6.03.A.3.a
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 | 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 amount of the Balancing Account | ||
Step 3 | 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 | ATTACHMENT N-2 SCHEDULE 1 |
JOINT EXPENSE | ||||||||||||||||||||||||||||||||
CONTRACT | SCHEDULE | DIRECT | ALLOCATION | WHOLESALE | ||||||||||||||||||||||||||||
EXPENSE CATEGORY | REFERENCE | REFERENCE | TOTAL | DIRECT RETAIL | WHOLESALE | REGIONAL | FACTOR | SHARE | ||||||||||||||||||||||||
OPERATING AND MAINTENANCE EXPENSE: | ||||||||||||||||||||||||||||||||
SOURCE OF SUPPLY | 5.05 | (A) | SCH 8.1 | $ | 14,943,953 | $ | 1,251,062 | $ | — | $ | 13,692,891 | ANNUAL USE1 | $ | 9,364,568 | ||||||||||||||||||
PUMPING | 5.05 | (B) | SCH 8.1 | $ | 4,342,682 | $ | 3,854,000 | $ | — | $ | 468,682 | ANNUAL USE1 | $ | 334,210 | ||||||||||||||||||
TREATMENT | 5.05 | (C) | SCH 8.1 | $ | 30,445,053 | $ | — | $ | — | $ | 30,445,053 | ANNUAL USE1 | $ | 20,821,372 | ||||||||||||||||||
TRANSMISSION & DISTRIBUTION | 5.05 | (D) | SCH 8.1 | $ | 53,416,232 | $ | 30,163,286 | $ | — | $ | 23,252,946 | ANNUAL USE1 | $ | 15,902,690 | ||||||||||||||||||
CUSTOMER ACCOUNTS2 | 5.05 | (E) | SCH 8.1 | $ | 7,552,213 | $ | 7,401,169 | $ | 151,044 | $ | — | 2% | $ | 151,044 | ||||||||||||||||||
TOTAL O&M | $ | 110,700,133 | $ | 42,669,517 | $ | 151,044 | $ | 67,879,572 | 46,573,883 | |||||||||||||||||||||||
COMPOSITE % (WHOLESALE SHARE/ TOTAL O&M) | 5.06 | (C) | 42.07 | % | ||||||||||||||||||||||||||||
ADMINISTRATIVE AND GENERAL EXPENSES: | ||||||||||||||||||||||||||||||||
COWCAP | 5.06 | (A) | SCH 8.1 | $ | 1,238,009 | $ | — | $ | — | $ | 1,238,009 | COMPOSITE O&M | $ | 520,857 | ||||||||||||||||||
SERVICES OF SFPUC BUREAUS | 5.06 | (B) | SCH 7 | $ | 22,465,291 | $ | 8,178,424 | $ | — | $ | 14,286,867 | ANNUAL USE1 | $ | 9,770,788 | ||||||||||||||||||
OTHER A&G | 5.06 | (C) | SCH 8.1 | $ | 12,972,477 | $ | 4,009,891 | $ | — | $ | 8,962,586 | COMPOSITE O&M | $ | 3,770,749 | ||||||||||||||||||
COMPLIANCE AUDIT | 5.06 | (D) | SCH 8.1 | $ | 200,000 | $ | — | $ | — | $ | 200,000 | 50% | $ | 100,000 | ||||||||||||||||||
TOTAL A&G | $ | 36,875,777 | $ | 12,188,315 | $ | — | $ | 24,687,462 | $ | 14,162,394 | ||||||||||||||||||||||
PROPERTY TAXES | 5.07 | SCH 8.1 | $ | 1,417,293 | $ | — | $ | — | $ | 1,417,293 | ANNUAL USE1 | $ | 969,287 | |||||||||||||||||||
CAPITAL COST RECOVERY | ||||||||||||||||||||||||||||||||
PRE-2009 ASSETS | 5.03 | ATT K | $ | 24,051,326 | ||||||||||||||||||||||||||||
DEBT SERVICE ON NEW ASSETS | 5.04 | (A) | SCH 2 | $ | 17,952,931 | |||||||||||||||||||||||||||
REVENUE FUNDED ASSETS — APPROPRIATED TO WHOLESALE CAPITAL FUND | 5.04 | (B) | SCH 3 | $ | 8,381,400 | |||||||||||||||||||||||||||
TOTAL CAPITAL COST RECOVERY | $ | 50,385,657 | ||||||||||||||||||||||||||||||
WHOLESALE SHARE HETCHY WATER & POWER | 5.04 | SCH 4 | $ | 28,903,512 | ||||||||||||||||||||||||||||
WHOLESALE REVENUE REQUIREMENT | $ | 140,994,733 | ||||||||||||||||||||||||||||||
WHOLESALE REVENUE COVERAGE3 | $ | 4,488,233 |
1 | Proportional Annual Use (68.39%) | |
2 | Water Enterprise Share of Customer Accounts Expenses (62% of Total Customer Accounts Expenses) | |
3 | 25% of Wholesale Share of Debt Service |
WHOLESALE REVENUE REQUIREMENT SCHEDULES WATER ENTERPRISE CAPITAL COST RECOVERY — ANNUAL DEBT SERVICE FISCAL YEAR 2009-10 REFERENCE SECTION 5.04.A | ATTACHMENT N-2 SCHEDULE 2 |
2006 BOND | 2008 BOND | 2009 BOND | XXXX BOND | XXXX BOND | XXXX BOND | XXXX BOND | TOTAL ALL | |||||||||||||||||||||||||
ISSUE SERIES | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | OUTSTANDING | |||||||||||||||||||||||||
A | SERIES | SERIES | SERIES | SERIES | SERIES | SERIES | BONDS | |||||||||||||||||||||||||
USE OF BOND PROCEEDS | ||||||||||||||||||||||||||||||||
RETAIL PROJECTS | 31.61 | % | 22.95 | % | 19.42 | % | XX.XX | % | XX.XX | % | XX.XX | % | XX.XX | % | ||||||||||||||||||
REGIONAL PROJECTS | 68.39 | % | 77.05 | % | 80.58 | % | YY.YY | % | YY.YY | % | YY.YY | % | YY.YY | % | ||||||||||||||||||
PRINCIPAL PAYMENT | $ | 8,765,000 | — | — | — | — | — | — | $ | 8,765,000 | ||||||||||||||||||||||
RETAIL PROJECTS | $ | 2,770,617 | — | — | — | — | — | — | $ | 2,770,617 | ||||||||||||||||||||||
REGIONAL PROJECTS | $ | 5,994,384 | — | — | — | — | — | — | $ | 5,994,384 | ||||||||||||||||||||||
INTEREST PAYMENT (GROSS) | $ | 23,353,388 | $ | 5,561,386 | $ | 56,181,932 | — | — | — | — | $ | 85,096,706 | ||||||||||||||||||||
RETAIL PROJECTS | $ | 7,382,006 | $ | 1,276,338 | $ | 10,910,531 | — | — | — | — | $ | 19,568,875 | ||||||||||||||||||||
REGIONAL PROJECTS | $ | 15,971,382 | $ | 4,285,048 | $ | 45,271,401 | — | — | — | — | $ | 65,527,831 | ||||||||||||||||||||
INTEREST PAYMENT (CAPITALIZED) | — | — | $ | 56,181,932 | ||||||||||||||||||||||||||||
RETAIL PROJECTS | — | — | $ | 10,910,531 | ||||||||||||||||||||||||||||
REGIONAL PROJECTS | — | — | $ | 45,271,403 | ||||||||||||||||||||||||||||
INTEREST PAYMENT (NET) | $ | 23,353,388 | $ | 5,561,386 | — | |||||||||||||||||||||||||||
RETAIL PROJECTS | $ | 7,382,006 | $ | 1,276,338 | — | |||||||||||||||||||||||||||
REGIONAL PROJECTS | $ | 15,971,382 | $ | 4,285,048 | — | |||||||||||||||||||||||||||
TOTAL PRINCIPAL AND INTEREST PAYMENT | 32,118,388 | 5,561,386 | — | — | — | — | — | $ | 37,679,774 | |||||||||||||||||||||||
RETAIL PROJECTS | 10,152,622 | 1,276,338 | — | — | — | — | — | $ | 11,428,961 | |||||||||||||||||||||||
REGIONAL PROJECTS | 21,965,766 | 4,285,048 | — | — | — | — | — | $ | 26,250,813 | |||||||||||||||||||||||
PROPORTIONAL ANNUAL USE | 68.39 | % | 68.39 | % | 68.39 | % | ZZ.ZZ | % | ZZ.ZZ | % | ZZ.ZZ | % | ZZ.ZZ | % | ||||||||||||||||||
WHOLESALE SHARE | $ | 15,022,387 | $ | 2,930,544 | — | — | — | — | — | $ | 17,952,931 |
WHOLESALE REVENUE REQUIREMENT SCHEDULES | ATTACHMENT N-2 | |
WATER ENTERPRISE CAPITAL COST RECOVERY — REVENUE FUNDED CAPITAL PROJECTS | SCHEDULE 3 | |
FISCAL YEAR 2009-10 | ||
REFERENCE SECTION 5.04.B |
TOTAL | ALL YEARS | APPROPRIATED | ||||||||||||||||||||||||||||||||||||
PROJECT | ALLOCATION | WHOLESALE | APPROPRIATION | ACTUAL | FY 2009-10 ACTUAL | ENCUMBEERED NOT | UNENCUMBERED | |||||||||||||||||||||||||||||||
APPROPRIATION | CLASSIFICATION | FACTOR | SHARE | ALL YEARS | EXPENDITURES | EXPENDITURES | EXPENDED | BALANCE | ||||||||||||||||||||||||||||||
CUH980 | Treasure Island Improvement Project | 3,800,000 | RETAIL | 0.0 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
CUW253 | Facilities Security | 500,000 | RETAIL | 0.0 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
CUW260 | Local Water R$R | 22,347,520 | RETAIL | 0.0 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
CUW686 | Automated Meter Reading System | 36,001,000 | RETAIL | 0.0 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
Total Local | 62,648,520 | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||||||
CUW202 | Replace Prestressed Concrete Cylr Pipe | — | REGIONAL | 68.7 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
CUW261 | Regional Water R&R — Storage | — | REGIONAL | 68.7 | % | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | |||||||||||||||||||||
CUW262 | Regional Water R&R — Treatment Facilities | 1,000,000 | REGIONAL | 68.7 | % | $ | 687,000 | $ | 687,000 | $ | 235,000 | $ | 235,000 | $ | — | $ | 452,000 | |||||||||||||||||||||
CUW263 | Regional Water R&R Conveyance/Transmission | 7,000,000 | REGIONAL | 68.7 | % | $ | 4,809,000 | $ | 4,809,000 | $ | 1,395,000 | $ | 1,395,000 | $ | 25,000 | $ | 3,389,000 | |||||||||||||||||||||
CUW264 | Regional Watersheds/ROW Management | 500,000 | REGIONAL | 68.7 | % | $ | 343,500 | $ | 343,500 | $ | 115,000 | $ | 115,000 | $ | 50,000 | $ | 178,500 | |||||||||||||||||||||
FUW100 | Regional Facilities Maintenance | 3,700,000 | REGIONAL | 68.7 | % | $ | 2,541,900 | $ | 2,541,900 | $ | 850,000 | $ | 850,000 | $ | 123,000 | $ | 1,568,900 | |||||||||||||||||||||
Total Regional | 12,200,000 | $ | 8,381,400 | $ | 8,381,400 | $ | 2,595,000 | $ | 2,595,000 | $ | 198,000 | $ | 5,588,400 | |||||||||||||||||||||||||
TOTAL ALL PROJECTS | 74,848,520 | $ | 8,381,400 | $ | 8,381,400 | $ | 2,595,000 | $ | 2,595,000 | $ | 198,000 | $ | 5,588,400 | |||||||||||||||||||||||||
(TO SCHEDULE 1) | (TO SCHEDULE 1) | (TO SCHEDULE 1) |
WHOLESALE REVENUE REQUIREMENT SCHEDULES CALCULATION OF WHOLESALE SHARE FO HETCH HETCHY WATER & POWER FISCAL YEAR 2009-10 REFERENCE ARTICLE 5 | ATTACHMENT N-2 SCHEDULE 4 |
JOINT | WATER- | |||||||||||||||||||||||||||||||||||||||
CONTRACT | SCHEDULE | POWER | WATER | ALLOCATION | RELATED | WHOLESALE | WHOLESALE | |||||||||||||||||||||||||||||||||
EXPENSE CATEGORY | REFERENCE | REFERENCE | TOTAL | SPECIFIC | SPECIFIC | JOINT | PERCENTAGE | TOTAL | ALLOCATION FACTOR | SHARE | ||||||||||||||||||||||||||||||
OPERATION AND MAINTENANCE | ||||||||||||||||||||||||||||||||||||||||
OPERATION | 5.08 B 1 | SCH 8.2 | $ | 44,612,220 | $ | 31,853,965 | $ | 9,557,861 | $ | 3,200,394 | 45 | % | $ | 10,998,038 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 7,484,165 | |||||||||||||||||||||||
MAINTENANCE | 5.08 B 1 | SCH 8.2 | $ | 16,868,612 | $ | 5,048,039 | $ | 3,238,622 | $ | 8,581,951 | 45 | % | $ | 7,100,500 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 4,831,890 | |||||||||||||||||||||||
TOTAL OPERATION AND MAINTENANCE | $ | 61,480,832 | $ | 36,902,004 | $ | 12,796,483 | $ | 11,782,345 | $ | 18,098,538 | $ | 12,316,055 | ||||||||||||||||||||||||||||
ADMINISTRATIVE AND GENERAL | $ | — | ||||||||||||||||||||||||||||||||||||||
COWCAP | 5.08 B 2 | SCH 8.2 | $ | 1,139,579 | $ | — | $ | — | $ | 1,139,579 | 45 | % | $ | 512,811 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 348,968 | |||||||||||||||||||||||
SERVICES OF SFPUC BUREAUS | 5.08 B 2 | SCH 7 | $ | 8,255,307 | $ | 5,375,656 | $ | 2,879,651 | $ | — | 45 | % | $ | 2,879,651 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 1,959,603 | |||||||||||||||||||||||
OTHER A&G | 5.08 B 2 | SCH 8.2 | $ | 25,581,481 | $ | 14,913,071 | $ | 36,070 | $ | 10,632,340 | 45 | % | $ | 4,820,623 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 3,280,434 | |||||||||||||||||||||||
CUSTOMER ACCOUNTS | 5.08 B 2 | SCH 8.2 | $ | 347,403 | $ | 347,403 | $ | — | $ | — | 45 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||
TOTAL ADMINISTRATIVE AND GENERAL | $ | 35,323,770 | $ | 20,636,130 | $ | 2,915,721 | $ | 11,771,919 | $ | 8,213,085 | $ | 5,589,004 | ||||||||||||||||||||||||||||
PROPERTY TAXES | 5.08 B 3 | SCH 8.2 | $ | 452,000 | $ | — | $ | — | $ | 456,305 | 45 | % | $ | 205,337 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 139,732 | |||||||||||||||||||||||
CAPITAL COST RECOVERY | ||||||||||||||||||||||||||||||||||||||||
PRE-2009ASSETS | 5.09 B 1 | ATT K-4 | $ | 3,118,033 | ||||||||||||||||||||||||||||||||||||
DEBT SERVICE ON NEW ASSETS | 5.09 B 2 | SCH 5 | $ | — | ||||||||||||||||||||||||||||||||||||
REVENUE FUNDED ASSETS-APPROPRIATIONS TO WHOLESALE CAPITAL FUND | 5.09 B 3 | SCH 6 | $ | 7,740,688 | ||||||||||||||||||||||||||||||||||||
TOTAL CAPITAL COST RECOVERY | $ | 10,858,721 | ||||||||||||||||||||||||||||||||||||||
WHOLESALE SHARE OF HETCH HETCHY WATER & POWER | $ | 28,903,512 | ||||||||||||||||||||||||||||||||||||||
(TO SCHEDULE 1 | ) | |||||||||||||||||||||||||||||||||||||||
WHOLESALE REVENUE COVERAGE1 | $ | — |
1 | Adjusteed Proportional Annual Use (68.39% X 99.50% = 68.05%) | |
2 | 25% 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 |
XXXX BOND | XXXX BOND | XXXX BOND | XXXX BOND | XXXX BOND | XXXX BOND | XXXX BOND | TOTAL ALL | |||||||||||||||||||||||||
ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | ISSUE ALL | OUTSTANDING | |||||||||||||||||||||||||
SERIES | SERIES | SERIES | SERIES | SERIES | SERIES | SERIES | BONDS | |||||||||||||||||||||||||
USE OF BOND PROCEEDS | ||||||||||||||||||||||||||||||||
POWER PROJECTS | XX.XX% | XX.XX% | XX.XX% | XX.XX% | XX.XX% | XX.XX% | XX.XX% | |||||||||||||||||||||||||
WATER PROJECTS | YY.YY% | YY.YY% | YY.YY% | YY.YY% | YY.YY% | YY.YY% | YY.YY% | |||||||||||||||||||||||||
JOINT PROJECTS | ZZ.ZZ% | ZZ.ZZ% | ZZ.ZZ% | ZZ.ZZ% | ZZ.ZZ% | ZZ.ZZ% | ZZ.ZZ% | |||||||||||||||||||||||||
PRINCIPAL PAYMENT | — | — | — | — | — | — | — | — | ||||||||||||||||||||||||
POWER SHARE | — | — | — | — | — | — | — | — | ||||||||||||||||||||||||
WATER SHARE | — | — | — | — | — | — | — | — | ||||||||||||||||||||||||
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 PAYMENT1 | ||||||||||||||||||||||||||||||||
ADJUSTED PROPORTIONAL ANNUAL USE | 68.05 | % | 68.05 | % | 68.05 | % | 68.05 | % | 68.05 | % | 68.05 | % | 68.05 | % | ||||||||||||||||||
WHOLESALE SHARE | — | — | — | — | — | — | — | — |
1 | Water Related = 100% of Water Share + 45% of Joint Share |
WHOLESALE REVENUE REQUIREMENT SCHEDULES | ATTACHMENT N-2 | |
HETCH HETCHY CAPITAL COST RECOVERY — REVENUE FUNDED CAPITAL PROJECTS | SCHEDULE 6 | |
FISCAL YEAR 2009-10 | ||
REFERENCE SECTION 5.04.B |
TOTAL | ALL YEARS | APPROPRIATED | ||||||||||||||||||||||||||||||||||||||||||||
PROJECT | WATER RELATED | WATER RELATED | ALLOCATION | WHOLESALE | APPROPRIATION | ACTUAL | FY 2009-10 ACTUAL | ENCUMBERED, NOT | UNENCUMBERED | |||||||||||||||||||||||||||||||||||||
APPROPRIATION | CLASSIFICATION | PERCENTAGE | SHARE | FACTOR | SHARE | ALL YEARS | EXPENDITURES | EXPENDITURES | EXPENDED | BALANCE | ||||||||||||||||||||||||||||||||||||
CUH931 | HH Microwave Replacement | $ | 4,000,000 | JOINT | 45 | % | $ | 1,800,000 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 1,224,900 | $ | 1,224,900 | $ | 1,224,900 | $ | 1,224,900 | $ | — | $ | ||||||||||||||||||||||||||
CUH977 | HH Water R&R — Facilities Maintenance | $ | 3,500,000 | JOINT | 45 | % | $ | 1,575,000 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 1,071,788 | $ | 1,071,788 | $ | 1,071,788 | $ | 1,071,788 | $ | — | $ | ||||||||||||||||||||||||||
Total Joint | $ | 7,500,000 | $ | 3,375,000 | $ | 2,296,688 | $ | 2,296,688 | $ | 2,296,688 | $ | 2,296,688 | $ | — | $ | |||||||||||||||||||||||||||||||
CUH947 | SEA — Go Solar Incentive Project | $ | 4,000,000 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
CUH971 | Alternative Transmission Studies | $ | 1,000,000 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
CUH976 | HH Water R&R —Power Infrastructure | $ | 16,700,000 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
CUH979 | Hunters Point Municipal Power | $ | — | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
CUH933 | Civic Center Sustainability District | $ | 1,090,000 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
CUH986 | General Fund Dept — Energy Efficiency | $ | 7,365,158 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | |||||||||||||||||||||||||||||||||||
Renewable/Generation | $ | 3,501,307 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | ||||||||||||||||||||||||||||||||||||
Treasure Island Improvement Project | $ | 2,700,000 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | ||||||||||||||||||||||||||||||||||||
Enterprise fund Dept — Energy efficiency | $ | 325,722 | POWER | 0 | % | $ | — | ADJUSTED PROPORTIONAL ANNUAL USE | $ | — | ||||||||||||||||||||||||||||||||||||
Total power | $ | 36,682,187 | $ | — | $ | — | ||||||||||||||||||||||||||||||||||||||||
CUH975 | HH Water R$R — Water Infrastructure | $ | 6,000,000 | WATER | 100 | % | $ | 6,000,000 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 4,083,000 | $ | 4,083,000 | $ | 4,083,000 | $ | 4,083,000 | $ | — | $ | ||||||||||||||||||||||||||
Toulumne River Watershed Protection | $ | 2,000,000 | WATER | 100 | % | $ | 2,000,000 | ADJUSTED PROPORTIONAL ANNUAL USE | $ | 1,361,000 | $ | 1,361,000 | $ | 1,361,000 | $ | 1,361,000 | $ | — | $ | |||||||||||||||||||||||||||
Total Water | $ | 8,000,000 | $ | 8,000,000 | $ | 5,444,000 | $ | 5,444,000 | $ | 5,444,000 | $ | 5,444,000 | $ | — | $ | — | ||||||||||||||||||||||||||||||
TOTAL ALL WATER RELATED PROJECTS | $ | 96,364,374 | $ | 11,375,000 | $ | 7,740,688 | $ | 7,740,688 | $ | 7,740,688 | $ | 7,740,688 | $ | — | $ | — |
(TO SCHEDULE 4) | (TO SCHEDULE 4) | (TO SCHEDULE 4) |
WHOLESALE REVENUE REQUIREMENT SCHEDULES | ATTACHMENT N-2 | |
SERVICES OF SFPUC BUREAUS—ALLOCATION TO ENTERPRISES | SCHEDULE 7 | |
FISCAL YEAR 2009-10 | ||
REFERENCE SECTION 5.05.B |
ADJUSTED | HETCH HETCHY | HETCH HETCHY | ||||||||||||||||||||||||||||||||||||
EXPENDITURES | ADJUSTMENTS | EXPENDITURES | POWER | WATER | WATER RETAIL | WATER REGIONAL | WASTEWATER | TOTAL | ||||||||||||||||||||||||||||||
ALLOCATION FACTORS (SCHEDULE N-7.1) | 11.13 | % | 5.69 | % | 16.94 | % | 29.59 | % | 36.37 | % | ||||||||||||||||||||||||||||
PUC01 | General Manager | $ | 7,609,114 | $ | — | $ | 7,609,114 | $ | 847,180 | $ | 453,820 | $ | 1,288,884 | $ | 2,251,548 | $ | 2,767,682 | $ | 7,609,114 | |||||||||||||||||||
PUC1101 | BizServ-Administration | $ | 4,081,981 | $ | — | $ | 4,081,981 | $ | 454,478 | $ | 243,456 | $ | 691,434 | $ | 1,207,864 | $ | 1,484,749 | $ | 4,081,981 | |||||||||||||||||||
PUC1102 | Finance | $ | 8,817,687 | $ | — | $ | 8,817,687 | $ | 981,739 | $ | 525,902 | $ | 1,493,600 | $ | 2,609,166 | $ | 3,207,280 | $ | 8,817,687 | |||||||||||||||||||
PUC1103 | ITS1 | $ | 18,048,158 | $ | (1,835,357 | ) | $ | 16,212,801 | $ | 1,085,093 | $ | 966,959 | $ | 2,746,235 | $ | 4,797,391 | $ | 5,897,123 | $ | 16,212,801 | ||||||||||||||||||
PUC1106 | Human Resources | $ | 7,678,483 | $ | — | $ | 7,678,483 | $ | 854,903 | $ | 457,958 | $ | 1,300,634 | $ | 2,272,074 | $ | 2,792,914 | $ | 7,678,483 | |||||||||||||||||||
PUC1108 | Customer Services | $ | 12,262,428 | $ | (12,262,428 | ) | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||||||||||
PUC12 | External Affairs | $ | 3,882,455 | $ | — | $ | 3,882,455 | $ | 432,263 | $ | 231,556 | $ | 657,637 | $ | 1,148,824 | $ | 1,412,175 | $ | 3,882,455 | |||||||||||||||||||
TOTAL | $ | 34,752,000 | $ | (12,731,000 | ) | $ | 48,282,521 | $ | 5,375,656 | $ | 2,879,651 | $ | 8,178,424 | $ | 14,286,867 | $ | 17,561,923 | $ | 48,282,521 | |||||||||||||||||||
(TO SCHEDULE 4 | ) | (TO SCHEDULE 4 | ) | (TO SCHEDULE 1 | ) | (TO SCHEDULE 1 | ) |
1 | Adjustment for Transfer of SCADA Expenditures to T&D Joint ($1,730,000) |
WHOLESALE REVENUE REQUIREMENT SCHEDULES | ATTACHMENT N-2 | |
SERVICES OF SFPUC BUREAUS — ANNUAL SALARIES | SCHEDULE 7.1 | |
FISCAL YEAR 2009-10 | ||
REFERENCE SECTION 5.05.B |
ALLOCATION | GROUP | |||||||||||||||||||
DEPARTMENT/DIVISION | FACTOR | CODE | SALARIES | PERCENTAGE | ||||||||||||||||
HETCH HETCHY | ||||||||||||||||||||
POWER | 1 | $ | 6,677,939 | 6.27 | % | |||||||||||||||
WATER | 2 | $ | 1,775,910 | 1.67 | % | |||||||||||||||
JOINT | $ | 9,428,450 | ||||||||||||||||||
WATER SHARE | 45 | % | 2 | $ | 4,242,803 | 3.98 | % | |||||||||||||
POWER SHARE | 55 | % | 1 | $ | 5,185,648 | 4.87 | % | |||||||||||||
WATER | ||||||||||||||||||||
ADMINISTRATION (WTR01) | $ | 1,009,246 | ||||||||||||||||||
RETAIL SHARE | 33.4 | % | 3 | $ | 336,415 | 0.32 | % | |||||||||||||
REGIONAL SHARE | 33.3 | % | 4 | $ | 336,415 | 0.32 | % | |||||||||||||
HETCH HETCHY WATER SHARE | 33.3 | % | 2 | $ | 336,416 | 0.32 | % | |||||||||||||
CDD(WTR03) | 3 | $ | 17,356,922 | 16.29 | % | |||||||||||||||
WATER QUALITY (WTR04) | 4 | $ | 7,282,589 | 6.83 | % | |||||||||||||||
WATER SUPPLY & TREATMENT (WTR05) | 4 | $ | 18,134,689 | 17.05 | % | |||||||||||||||
NATURAL RESOURCES (WTR06) | 4 | $ | 4,682.073 | 4.39 | % | |||||||||||||||
WATER RESOURCE PLANNING | $ | 1,419,760 | ||||||||||||||||||
WATER CONSERVATION | 3 | $ | 355,703 | 0.33 | % | |||||||||||||||
RETAIL WATER RESOURCE PLANNING | 3 | $ | — | |||||||||||||||||
REGIONAL SHARE (NET SALARIES) | 4 | $ | 1,064,057 | 1.00 | % | |||||||||||||||
WASTEWATER | 5 | $ | 38,757,578 | 36.37 | % | |||||||||||||||
SALARIES BY GROUP CODE | ||||||||||||||||||||
HETCH HETCHY — POWER | 1 | $ | 11,863,587 | 11.13 | % | (TO SCHEDULE 7) | ||||||||||||||
HETCH HETCHY — WATER | 2 | $ | 6,355,129 | 5.96 | % | (TO SCHEDULE 7) | ||||||||||||||
WATER — RETAIL | 3 | $ | 18,049,040 | 16.94 | % | (TO SCHEDULE 7) | ||||||||||||||
WATER — REGIONAL | 4 | $ | 31,529,823 | 29.59 | % | (TO SCHEDULE 7) | ||||||||||||||
WASTEWATER | 5 | $ | 38,757,578 | 36.37 | % | (TO SCHEDULE 7) | ||||||||||||||
TOTAL SALARIES | $ | 106,555,156 | 100.00 | % |
WHOLESALE REVENUE REQUIREMENT SCHEDULES | ATTACHMENT N-2 | |
CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT | SCHEDULE 8.1 | |
FISCAL YEAR 2009-10 | ||
WATER ENTERPRISE SUMMARY OF OPERATING EXPENSES |
Retail | Wholesale | Regional | Total | |||||||||||||
Operating Expenses | ||||||||||||||||
Transmission & Distributions | $ | 30,163,286 | $ | — | $ | 23,252,946 | $ | 53,416,232 | ||||||||
Adjustments to Transmission & Distribution | $ | — | $ | — | $ | — | $ | - | ||||||||
Adjusted Transmission & Distribution | $ | 30,163,286 | $ | — | $ | 23,252,946 | $ | 53,416,232 | ||||||||
Source of Supply | $ | 1,251,062 | $ | — | $ | 13,692,891 | $ | 14,943,953 | ||||||||
Adjustments to Source of Supply | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Source of Supply | $ | 1,251,062 | $ | — | $ | 13,692,891 | $ | 14,943,953 | ||||||||
�� | ||||||||||||||||
Pumping | $ | 3,854,000 | $ | — | $ | 488,682 | $ | 4,342,682 | ||||||||
Adjustments to Pumping | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Pumping | $ | 3,854,000 | $ | — | $ | 488,682 | $ | 4,342,682 | ||||||||
Treatment | $ | — | $ | — | $ | 30,445,053 | $ | 30,445,053 | ||||||||
Adjustments to Treatment | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Treatment | $ | — | $ | — | $ | 30,445,053 | $ | 30,445,053 | ||||||||
Customer Accounts | $ | 7,401,169 | $ | 151,044 | $ | — | $ | 7,552,213 | ||||||||
Adjustments to Customer Accounts | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Customer Accounts | $ | 7,401,169 | $ | 151,044 | $ | — | $ | 7,552,213 | ||||||||
Total Adjusted Operating Expense | $ | 42,669,517 | $ | 151,044 | $ | 67,879,572 | $ | 110,700,133 | ||||||||
General & Administrative Expense | ||||||||||||||||
COWCAP | $ | — | $ | — | $ | 1,238,009 | $ | 1,238,009 | ||||||||
Services SFPUC Bureaus | $ | 8,178,424 | $ | — | $ | 14,286,867 | $ | 22,465,291 | ||||||||
Other General & Administrative | $ | 4,009,891 | $ | — | $ | 8,962,586 | $ | 12,972,477 | ||||||||
Adjustments to General & Administrative | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted General & Administrative | $ | 4,009,891 | $ | — | $ | 8,962,586 | $ | 12,972,477 | ||||||||
Compliance Audit | $ | 100,000 | $ | 100,000 | $ | — | $ | 200,000 | ||||||||
Total General & Administrative | $ | 12,288,315 | $ | 100,000 | $ | 24,487,462 | $ | 36,875,777 | ||||||||
Property Taxes | $ | — | $ | — | $ | 1,417,293 | $ | 1,417,293 | ||||||||
Total | $ | 54,957,832 | $ | 251,044 | $ | 93,784,327 | $ | 148,993,203 |
Page 9 of 10
WHOLESALE REVENUE REQUIREMENT SCHEDULES CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT FISCAL YEAR 2009-10 HETCHY HETCHY WATER & POWER SUMMARY OF OPERATING EXPENSES | ATTACHEMENT N-2 SCHEDULE 8.2 |
Power | Water | Joint | Total | |||||||||||||
Operating Expenses | ||||||||||||||||
Purchased Power & Wheeling | $ | 28,953,676 | $ | 28,953,676 | ||||||||||||
Adjustments to Purchased Power & Wheeling | $ | — | $ | — | ||||||||||||
Adjusted Purchased Power & Wheeling | $ | 28,953,676 | $ | 28,953,676 | ||||||||||||
Operations | ||||||||||||||||
Hydraulic Generation | $ | 2,900,291 | $ | — | $ | 3,200,394 | $ | 6,100,685 | ||||||||
Transmission & Distribution | $ | — | $ | — | $ | — | $ | — | ||||||||
Water Quality Expense | $ | — | $ | 9,557,862 | $ | — | $ | 9,557,862 | ||||||||
Adjustments to Operations | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Operations | $ | 2,900,291 | $ | 9,557,862 | $ | 3,200,394 | $ | 15,658,547 | ||||||||
Maintenance | ||||||||||||||||
Hydraulic Generation | $ | 1,840,096 | $ | 3,238,622 | $ | 8,581,952 | $ | 13,660,670 | ||||||||
Transmission & Distribution | $ | 3,359,385 | $ | — | $ | — | $ | 3,359,385 | ||||||||
Water Quality Expense | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjustments to Maintenance | $ | (151,442 | ) | $ | — | $ | — | $ | (151,442 | ) | ||||||
Adjusted Maintenance | $ | 5,048,039 | $ | 3,238,622 | $ | 8,581,952 | $ | 16,868,613 | ||||||||
Total Adjusted Operating Expense | $ | 36,902,000 | $ | 12,796,484 | $ | 11,782,346 | $ | 61,480,836 | ||||||||
General & Administrative Expense | ||||||||||||||||
COWCAP | $ | — | $ | — | $ | 1,139,579 | $ | 1,139,579 | ||||||||
Services of SFPUC Bureaus | $ | 5,375,656 | $ | 2,879,651 | $ | — | $ | 8,255,307 | ||||||||
Customer Accounts | $ | 347,403 | $ | — | $ | — | $ | 347,403 | ||||||||
Adjustments to Customer Accounts | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted Customer Accounts | $ | 347,403 | $ | — | $ | — | $ | 347,403 | ||||||||
Other General & Administrative | $ | 14,913,071 | $ | 36,070 | $ | 10,632,340 | $ | 25,581,481 | ||||||||
Adjustments to General & Administrative | $ | — | $ | — | $ | — | $ | — | ||||||||
Adjusted General & Administrative | $ | 14,913,071 | $ | 36,070 | $ | 10,632,340 | $ | 25,581,481 | ||||||||
Total General & Administrative | $ | 20,636,130 | $ | 2,915,721 | $ | 11,771,919 | $ | 35,323,770 | ||||||||
Property Taxes | $ | — | $ | — | $ | 452,000 | $ | 452,000 | ||||||||
Total | $ | 57,538,136 | $ | 15,712,205 | $ | 24,006,265 | $ | 97,256,606 |
Source: | FAMIS/EIS |
Note: | All adjustments to be separately identified above |
SCHEDULE OF PROJECTED WATER SALES, WHOLESALE REVENUE REQUIREMENTS, AND WHOLESALE RATES CONTRACT REFERENCE: ARTICLE 6.03.A.3 | ATTACHMENT N-3 | |
FISCAL YEAR | ||||||||||||||||||||
N | N+1 | N+2 | N+3 | N+4 | ||||||||||||||||
OPERATION AND MAINTENANCE EXPENSES | ||||||||||||||||||||
SOURCE OF SUPPLY | $ | 9,364,568 | $ | — | $ | — | $ | — | $ | — | ||||||||||
PUMPING | $ | 334,210 | $ | — | $ | — | $ | — | $ | — | ||||||||||
TREATMENT | $ | 20,821,372 | $ | — | $ | — | $ | — | $ | — | ||||||||||
TRANSMISSION & DISTRIBUTION | $ | 15,902,690 | $ | — | $ | — | $ | — | $ | — | ||||||||||
CUSTOMER ACCOUNTS | $ | 151,044 | $ | — | $ | — | $ | — | $ | — | ||||||||||
TOTAL OPERATION AND MAINTENANCE EXPENSES | $ | 46,573,884 | $ | — | $ | — | $ | — | $ | — | ||||||||||
ADMINISTRATIVE AND GENERAL EXPENSES | ||||||||||||||||||||
COWCAP | $ | 520,857 | $ | — | $ | — | $ | — | $ | — | ||||||||||
SF PUBLIC UTILITIES COMMISSION | $ | 9,770,788 | $ | — | $ | — | $ | — | $ | — | ||||||||||
OTHER A&G | $ | 3,770,749 | $ | — | $ | — | $ | — | $ | — | ||||||||||
COMPLIANCE AUDIT | $ | 100,000 | $ | — | $ | — | $ | — | $ | — | ||||||||||
TOTAL ADMINISTRATIVE AND GENERAL EXPENSES | $ | 14,162,394 | $ | — | $ | — | $ | — | $ | — | ||||||||||
PROPERTY TAXES | $ | 969,287 | $ | — | $ | — | $ | — | $ | — | ||||||||||
CAPITAL COST RECOVERY | ||||||||||||||||||||
PRE 2009 ASSETS | $ | 24,051,326 | $ | — | $ | — | $ | — | $ | — | ||||||||||
DEBT SERVICE ON NEW ASSETS | $ | 17,952,931 | $ | — | $ | — | $ | — | $ | — | ||||||||||
REVENUE FUNDED CAPITAL | $ | 8,881,400 | $ | — | $ | — | $ | — | $ | — | ||||||||||
TOTAL CAPITAL COST RECOVERY | $ | 50,385,657 | $ | — | $ | — | $ | — | $ | — | ||||||||||
WHOLESALE SHARE HHW&P | $ | 28,903,512 | $ | — | $ | — | $ | — | $ | — | ||||||||||
WHOLESALE REVENUE REQUIREMENT | $ | 140,994,734 | $ | — | $ | — | $ | — | $ | — | ||||||||||
BALANCING ACCOUNT AS OF JUNE 30 | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||
INTEREST ON BALANCING ACCOUNT | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||
WHOLESALE REVENUES AT EXSITING RATE | $ | (127,485,900 | ) | $ | — | $ | — | $ | — | $ | — | |||||||||
WHOLESALE EXCESS USE CHARGES | $ | — | $ | — | $ | — | $ | — | $ | — | ||||||||||
SETTLEMENT CREDITS AND OTHER ADJUSTMENTS | $ | 21,000 | $ | — | $ | — | $ | — | $ | — | ||||||||||
1984 AGREEMENT BALANCING ACCOUNT CREDITS | $ | 1,997,220 | $ | — | $ | — | $ | — | $ | — | ||||||||||
WHOLESALE DEBIT SERVICE COVERAGE RESERVE | $ | 4,488,233 | $ | — | $ | — | $ | — | $ | — | ||||||||||
WHOLESALE DEFICIENCY OR CREDIT | $ | 20,015,287 | $ | — | $ | — | $ | — | $ | — | ||||||||||
PERCENT WHOLESALE DEFICIENCY OR CREDIT OF REVENUES AND EXCESS USE CHARGES | $ | 15.7 | % | |||||||||||||||||
PROJECTED WATER SALES (CCF) | 85,920,000 | 0 | 0 | 0 | 0 | |||||||||||||||
WHOLESALE DEFICIENCY OR CREDIT ($/CCF) | 0.23 | 0 | 0 | 0 | 0 | |||||||||||||||
PROJECTED WHOLESALE RATE (UNIT COST ($/CCF) | 1.66 | 0 | 0 | 0 | 0 | |||||||||||||||
PROJECTED SERVICE CHARGE REVENUES | $ | 4,620,300 | ||||||||||||||||||
PROJECTED VOLUME CHARGE REVENUES | $ | 142,627,200 | ||||||||||||||||||
TOTAL WHOLESALE REVENUES | $ | 147,247,500 |
STATEMENT OF WHOLESALE REVENUE REQUIREMENT/ CHARGES IN BALANCING ACCOUNT
YEAR ENDED JUNE 30
(Section 7.02.B)
FY 2008-09 | FY 2009-10 | |||||||||||
Allocation to | Allocation to | |||||||||||
Wholesale | Wholesale | |||||||||||
Customers | Customers | Difference | ||||||||||
Wholesale Revenue Requirement Calculation: | ||||||||||||
Operating and maintenance (O&M) expense: | ||||||||||||
San Francisco Water Enterprise: | ||||||||||||
Source of supply | $ | 9,133,025 | $ | 9,364,568 | $ | 231,543 | ||||||
Pumping | $ | 325,946 | $ | 334,210 | $ | 8,264 | ||||||
Purification | $ | 20,437,460 | $ | 20,821,372 | $ | 383,912 | ||||||
Transmission and distribution | $ | 9,350,279 | $ | 15,902,690 | $ | 6,552,411 | ||||||
Customer Accounts | $ | 224,255 | $ | 151,044 | $ | (73,211 | ) | |||||
Total SFWE operating and maintenance | $ | 39,470,965 | $ | 46,573,884 | $ | 7,102,919 | ||||||
Hetch Hetchy Water and Power (HHWP): | ||||||||||||
Operating expenses | $ | 10,359,786 | $ | 7,484,165 | $ | (2,875,621 | ) | |||||
Maintenance expenses | $ | 4,526,240 | $ | 4,831,890 | $ | 305,650 | ||||||
Total HHWP operating and maintenance | $ | 14,886,026 | $ | 12,316,055 | $ | (2,569,971 | ) | |||||
Administrative and general (A&G) expenses: | ||||||||||||
COWCAP | ||||||||||||
SFWE | $ | 512,438 | $ | 520,857 | $ | 8,419 | ||||||
HHWP | $ | 162,364 | $ | 348,968 | $ | 186,604 | ||||||
SF Public Utilities Commission: | ||||||||||||
SFWE | $ | 7,461,835 | $ | 9,770,788 | $ | 2,308,953 | ||||||
HHWP | $ | 2,357,622 | $ | 1,959,603 | $ | (398,019 | ) | |||||
Other A&G — SFWE | $ | 8,234,799 | $ | 3,770,749 | $ | (4,464,050 | ) | |||||
Other A&G — HHWP | $ | — | $ | 3,280,434 | $ | 3,280,434 | ||||||
Compliance audit | $ | 95,338 | $ | 100,000 | $ | 4,662 | ||||||
Total administrative and general expenses | $ | 18,824,396 | $ | 19,751,399 | $ | 927,003 | ||||||
Property taxes (outside city only): | ||||||||||||
SFWE | $ | 964,040 | $ | 969,287 | $ | 5,247 | ||||||
HHWP | $ | 120,923 | $ | 139,732 | $ | 18,809 | ||||||
Total property taxes | $ | 1,084,963 | $ | 1,109,019 | $ | 24,056 | ||||||
Capital Cost Recovery | ||||||||||||
Pre-2009 Assets | ||||||||||||
SFWE | $ | 24,051,326 | ||||||||||
HHWP | $ | 3,118,033 | ||||||||||
Debt Service on New Assets | ||||||||||||
SFWE | $ | 17,952,931 | ||||||||||
HHWP | $ | — | ||||||||||
Revenue Funded Assets | ||||||||||||
SFWE | $ | 8,381,400 | ||||||||||
HHWP | $ | 7,740,688 | ||||||||||
Total Capital Cost Recovery | $ | 46,378,941 | $ | 61,244,378 | $ | 14,865,437 | ||||||
Total Wholesale Revenue Requirement | $ | 120,645,291 | $ | 140,994,735 | $ | 20,349,444 | ||||||
Balancing Account July 1 | $ | 21,176,614 | $ | — | ||||||||
Interest on adjusted beginning balance | $ | 529,415 | $ | — | ||||||||
Wholesale revenues billed | $ | (123,604,400 | ) | $ | (147,247,500 | ) | ||||||
Excess use charges billed | $ | — | $ | — | ||||||||
Wholesale Revenue Coverage Reserve | $ | — | $ | 4488,233 | ||||||||
Other adjustments | $ | — | $ | — | ||||||||
Settlement adjustments | $ | 21,006 | $ | 21,006 | ||||||||
1984 Agreement Balancing Account Credits | $ | — | $ | 1,997,220 | ||||||||
Balancing Account June 30 | $ | 18,768,326 | $ | 235,694 | ||||||||
General Manager, SFPUC | Date | |
Assistant General Manager & Chief Financial Officer, SFPUC | Date | |
Finance Director, SFPUC | Date | |
Accounting Manager, SFPUC | Date | |
Financial Planning Manager, SFPUC | Date | |
Senior Rates Administrator, SFPUC | Date |