Revised Attachment K-2
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
REVISED ATTACHMENT K-3
(Section 5.03)
ANNUAL PAYMENTS FOR WHOLESALE SHARE OF 6/30/09 NET PLANT & CWIP (WATER ASSETS)
Revised for February 2013 Prepayment
6/30/09 Wholesale Share of Net Plant & CW1P: 351,417,305 Interest Rate: 5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13: 2,081,055 Annual Wholesale Revenue Requirement through 6/30/13: 24,972,661 Fiscal Yr
Ending Principal Interest Total
Prepay-
ment End Bal (6/30)
Jun-10 7,110,596 17,862,065 24,972,661 344,306,709
Jun-11 7,484,069 17,488,591 24,972,661 336,822,640
Jun-12 7,877,159 17,095,502 24,972,661 328,945,481
Jun-13 13,715,985 11,256,676 24,972,661 315,229,496 0
Jun-14
Jun-15
Jun-16
Jun-17
Jun-18
Jun-19
Jun-20
Jun-21
Jun-22
Jun-23
Jun-24
Jun-25
Jun-26
Jun-27
Jun-28
Jun-29
Jun-30
Jun-31
Jun-32
Jun-33
Jun-34
36,187,809 63,702,834 99,890,643 315,229,496
Note: The monthly supporting calculation for fiscal year 2012-13 is attached.
Revised Attachment K-3
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Monthly Calculations for Updated 1(-3 Schedule for FY 2012-13 Based on February 2013 Prepayment
(Water)
6/30/12 Unpaid Balance
Interest Rate:
Origina!Term:
Monthly Principal & Interest Calculation through 6/30/13 Anl')ual Wholesale Revenue Requirement through 6/30/13:
Prepayment Date
Month Beginning
Ending Mo. Pmt Balance Principal (ll
6/30/12 n/a n/a
7/30/12 2,081,055 328,945,481 674,813
8/30/12 2,081,055 328,270,667 677,698
9/30/12 2,081,055 327,592,970 680,595
10/30/12 2,081,055 326,912,374 683,505
11/30/12 2,081,055 326,228,870 686,427
12/30/12 2,081,055 325,542,443 689,361
1/30/13 2,081,055 324,853,082 692,308
2/28/13 2,081,055 324,160,774 695,268
3/30/13 2,081,055 8,236,010 2,045,846
4/30/13 2,081,055 6,190,164 2,054,592
5/30/13 2,081,055 4,135,572 2,063,375
6/30/13 2,081,055 2,072,19� 2,072,196
Total (Rev K-3): 13,715,985
Current K-3 1�1: 8,290,896
Additlonal Principal Amortized: 5,425,089
Interest (ll
n/a
1,406,242
1,403,357
1,400,460
1,397,550
1,394,628
1,391,694
1,388,747
1,385,787
35,209
26,463
17,680
8,859
11,256,676
16,681,765
Total
n/a
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
24,972,661 I
24,972,661
{1) Starting in March, the Prepayment is applied to the monthly Interest calculations and monthly p_ri.ncipal is calculated to maintain monthly principal and Interest $2,081,055 and the annual WRR amount at $24,972,661 resulting in no impact to the 6/30/13 balancing account compared to no prepayment being made. {2) K-3 principal and Interest for FY 12-13 on K-3 before prepayment.
Provided for reference only.
Revised Attachment K-3
328,945,481
5.13%
25 2,081,055
24,972,66_1
2/27/13
Ending Prepay-
Balance ment
328,945,481
328,270,667
327,592,970
326,912,374
326,228,870
325,542,443
324,853,082
324,160,774
323,465,506 315,229,496 Ill
6,190,164
4,135,572
2,072,196
0 315,229,496
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT l(-4
(Section 5.03)
ANNUAL PAYMENTS FOR WHOLESALE SHARE OF 6/30/09 NET PLANT & CWIP (HETCH HETCHY ASSETS)
Revised for February 2013 Prepayment
6/30/09 Wholesale Share of Net Plant & CWIP: 45,605,655 Interest Rate: 5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13: 270,072 Annual Wholesale Revenue Requirement through 6/30/13: 3,240,861.
Fiscal Yr
Ending Principal Interest Total
Prepay-
ment End Bal (6/30)
Jun-10 922,787 2,318,074 3,240,861 44,682,868
Jun-11 971,255 2,269,606 3,240,861 43,711,612
Jun-12 1,022,269 2,218,592 3,240,861 42,689,343
Jun-13 1,780,010 1,460,850 3,240,861 40,909,333
Jun-14
Jun-15
Jun-16
Jun-17
Jun-18
Jun-19
'Jun-20
Jun-21
Jun-22
Jun-23
Jun-24.
Jun-25
Jun-26
Jun-27
Jun-28
Jun-29
Jun-30
Jun-31
Jun-32
Jun-33
Jun-34
4,696,322 8,267,121 12,963,443 40,909,333
Note: The monthly supporting calculation for fiscal year 2012-13 is attached.
Revised Attachment K-4
REVISED
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Monthly Calculations for Updated K Schedules for FY 2012-13 Based on February 2013 Prepayment
(Hetch Hetchy)
6/30/12 Unpaid Balance
Interest Rate:
42,689,343
5.13%
Original Term: 25
Monthly Principal & Interest Calculation through 6/30/13 270,072 Annual Wholesale Revenue Requirement through 6/30/13: 3,240,861 Est. Prepayment Date 2/27/13
Month Beginning Ending Prepay-
Ending Mo. Pmt Balance Principal (1) Interest (1) Total Balance ment 6/30/12 n/a n/a n/a n/a 42,689,343
7/30/12 270,072 42,689,343 87,575 182,497 270,072 42,601,769 8/30/12 270,072 42,601,769 87,949 182,123 270,072 42,513,820 9/30/12 270,072 42,513,820 88,325 181,747 270,072 42,425,494 10/30/12 270,072 42,425,494 88,703 181,369 270,072 42,336,792 11/30/12 270,072 42,336,792 89,082 180,990 270,072 42,247,710 12/30/12 270,072 42,247,710 89,463 180,609 270,072 42,158,247 1/30/13 270,072 42,158,247 89,845 180,227 270,072 42,068,402 2/28/13 270,072 42,068,402 90,229 179,842 270,072 41,978,172 40,909,333 3/30/13 270,072 1,068,839 265,502 4,569 270,072 803,337 4/30/13 270,072 803,337 266,637 3,434 270,072 536,699
5/30/13 270,072 536,699 267,777 2,294 270,072 268,922
6/30/13 270,072 268,922 268,922 1,150 270,072 0
Total (Rev K-4): 1,780,010 1,460,850 3,240,861 40,909,333 Current K-4(2): 1,075,962 2,164,899 3,240,861
Additional Principal Amortized (K-4): 704,048 Combined
Plus Additional K-3 Principal: 5,425,089 Prepayment
Combined Additional Principal: 6,129,137 356,138,829
(1) Starting In March, the Prepayment is applied to the monthly interest calculations and monthly principal is calculated to maintain monthly principal and interest $270,072 and
the annual WRR amount at $3,240,861, resulting in no impact to the 6/30/13 balancing account compared to np prepayment being made. (2) K-4 principal and interest for FY 12-13 on K-4 before prepayment.
Revised Attachment K-4
(
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT K-5
10 YEAR PAYOFF SCHEDULES FOR EXISTING RATE BASE
WATER ENTERPRISE UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS
CONSTRUCTION WORK IN PROGRESS (CWIP)
AS OF JUNE 30, 2009
(Section 5.03C)
Difference Difference
(Increase) from (Increase) from
Revised Audited Audited Original Original
6/30/09 Wholesale Share of Unexpended Appropriations of CWIP $ 6,618,478 $ 6,618,021 $ 457 $ 6,613,084 $ 5,394 Interest Rate: 4.00%
Term: 10
Monthly Principal & Interest Calculation: $67,009
Annual Wholesale Revenue Requirement: $804,106 $804,051 $ 55 $803,451 $655 Fiscal Yr Ending Principal Interest Annual Payment Year End Balance Jun-15 $549,366 $254,740 $804,106 $6,069,112
Jun-16 $571,748 $232,358 $804,106 $5,497,363
Jun-17 $595,042 $209,064 $804,106 $4,902,321
Jun-18 $619,285 $184,821 $804,106 $4,283,035
Jul-19 $644,516 $159,590 $804,106 $3,638,519
Jun-20 $670,775 $133,332 $804,106 $2,967,745
Jun-21 $698,103 $106,004 $804,106 $2,269,642
Jun-22 $726,545 $77,562 $804,106 $1,543,097
Jul-23 $756,145 $47,961 $804,106 $786,952
Jun-24 $786,952 $17,155 $804,106 $0
Totals: $6,618,478 $1,422,587 $8,041,065
K-5 (WTR) as of 6-30-15
REVISED
Revised Attachment K-5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT K-5
10 YEAR PAYOFF SCHEDULES FOR EXISTING RATE BASE
HETCH HETCHY ENTERPRISE UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS
CONSTRUCTION WORK IN PROGRESS (CWIP)
AS OF JUNE 30, 2009
(Section 5.03C)
Revised Audited
Difference
Original
Difference
(Increase) from Increase
Audited from Original
6/30/09 Wholesale Share of Unexpended Appropriations of CWIP 2,923,204 $ 2,914,484 $ 8,720 $ 2,912,877 $ 10,326 Interest Rate: 4.00%
Term: 10
Monthly Principal & Interest Calculation: $29,596
Annual Wholesale Revenue Requirement: $355,152 $354,093 $ 1,059 $353,898 $1,254 Fiscal Yr Ending Principal Interest Total End. Balance Principal Interest Annual Payment Year End Balance Jun-15 $20,592 $9,004 $29,596 $2,680,563 $242,640 $112,512 $355,152 $2,680,563 Jun-16 $21,431 $8,165 $29,596 $2,428,037 $252,526 $102,626 $355,152 $2,428,037 Jun-17 $22,304 $7,292 $29,596 $2,165,223 $262,814 $92,338 $355,152 $2,165,223 Jun-18 $23,213 $6,383 $29,596 $1,891,701 $273,522 $81,631 $355,152 $1,891,701 Jul-19 $24,159 $5,437 $29,596 $1,607,036 $284,665 $70,487 $355,152 $1,607,036 Jun-20 $25,143 $4,453 $29,596 $1,310,773 $296,263 $58,889 $355,152 $1,310,773 Jun-21 $26,167 $3,429 $29,596 $1,002,440 $308,333 $46,819 $355,152 $1,002,440 Jun-22 $27,233 $2,363 $29,596 $681,544 $320,895 $34,257 $355,152 $681,544 Jul-23 $28,343 $1,253 $29,596 $347,575 $333,969 $21,183 $355,152 $347,575 Jun-24 $29,498 $98 $29,596 ($0) $347,575 $7,577 $355,152 ($0) Totals: $2,923,204 $628,318 $3,551,522 $2,923,204 $628,318 $3,551,522 K-5 (HHP) as of 6-30-15
REVISED
Revised Attachment K-5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Review of Unexpended Balances of Appropriated Funds (Not Included in CWI P as of 6/30/2009) Construction Work in Progress As of June 30, 2009
(Section 5.03.CI
(A) (8) (C) (D) = (A) -(8)-(C)
Appropriiltion YTD Expenditures PTD Expenditures Encumbrilnces Avililiible Billilnce (E) =(El) + (E2) +
r--�(E�1)�---�(E_2)�---�(E_3�)
---�(E_4�)
---
�(E_5�) ____ (�E6�)
---, (E3)+(E4)+(E5) + (E6)
Expenditures in
Project
Wiiter Assets:
CliissifiCiltion As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 L.....FY.2_009 __ -_10 ...... _ ... FY_2_0_1_0-_1 ... 1 _ ...... FY ... 2_0_1_1-_1_2_..._ I .. FY ..... 20_1_2-.. 1 .. 3_..._ 1..,FY...,.20.1 .. 3-.. 1 .. 4 _ _._.. IYT.,D...,rv.,2.0 .. 1,..4-.1__,5 T otil Expenditures Addition to K-5 CUWlll
Addition to K-5 CUW112
Addition to K-5 CUW118
K-5 CUW135
K-S CUW143
K-5 CUW148
K-5
K-5
K-5
K-5
K-5
K-S
K-5
K-5
K-5
K-5
K-5
K-5
K-5
K-S
K-5
K-5
K-5
K-5
K-5
CUW161
CUW168
CUW202
CUW210
CUW227
CUW228
CUW231
CUW241
CUW242
CUW2SO
CUW253
CUW2S7
CUW261
CUW262
CUW263
CUW264
CUW127
CUW392
CUW710
CRYSTAL SP RES OP PLAN'
CRYSTAL SPRINGS P/L NO 1-PHASE 21
MILLBRAE SHOP-PHASE 2-B'
NEW LINE & BYPASS VALVES'
HETCH HETCHY WATER TREATMENT PLAN'·
10 ENVIRONMENTAL & REGULATORY COMP1
TREATMENT FACILITIES IMPROVEMENTS'
ALAMEDA CREEK FISH RELEASE
SAN ANTONIO PIPELINE EMERGENCY REPAIR
MILLBRAE ADMIN BLDG INTERIM REMODEL'
WATERSHED FENCES/FACILITIES '
WATERSHED ROADS RECONSTRUCTION'
MILLBRAE LAB CAPITAL IMPROVEMENTS'
FACILITIES MAINT SUPPORT STRUCTURES'
DEMOLITION UNSAFE STRUCTURES'
WATERSHED TRAILS & RECREATION IMPROv'
FACILITIES SECURITY PROJECT'''
WATER PROTECTION'·'
REGIONAL WATER STORAGE RNR - BUDGET1''
TREATMENT FACS/WQ IMPROVE - BUDGET'
CONVEYANCE/TRANSMISSION - BUDGET'
WATERSHED ROADS - BUDGET'
INST SCADA SYSTEM
7 ' 1
PROGRAM MANAGEMENT SERVICES - WSIF�'·'·"
OCIP PROJECT CONTROL
2 '1
CUH977-03 HH MATHER FACILITIES
TOTAL ALL PROJECTS PER K-5
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
SW
ST
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
AAAACP REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP LOCAL/REGIONAL $
AAAACP Local $
l,OSS,054 $
2,422,523 $
11,263,269 $
4,829,680 $
18,821,529 $
3,241,279 $
15,028,319 $
1,S37,398 $
1,400,000 $
2,407,700 $
3,000,000 $
5,170,000 $
770,000 $
S,000,000 $
1,000,000 $
387,639 $
S,300,000 $
1,448,720 $
1,7SO,OOO $
4,801,000 $
7,82S,OOO $
3,000,000 $
13,1S6,681 $
1,000,000 $
2,497,881 $
73,000 $
118,18 9,672 $
$
207 $
3,998 $
2,103 $
164,267 $
990 $
334 $
100,642 $
(339,46S) $
284,902 $
S30,822 $
85,843 $
40,678 $
8,390 $
24,867 $
9,431 $
234,328 $
113,871 $
430,990 $
896,697 $
1,404,SOl $
202,638 $
6,221,108 $
(92,112) $
235,706 $
13,327 $
1 0,57 9,063 $
1,023,222 $
1,37S,634 $
11,014,662 $
4,689,067 $
18,616,320 $
3,0lS,985 $
14,747,873 $
1,094,937 $
923,712 $
l,93S,204 $
2,548,376 $
4,415,913 $
S53,694 $
4,988,882 $
410,040 $
112,689 $
4,308,224 $
497,747 $
706,684 $
3,201,827 $
4,019,441 $
1,517,064 $
12,393,475 $
7S8,065 $
2,496,959 $
SS,989 $
1 01,421,685 $
$
$
$
$
47,947 $
$
$
125,057 $
16,032 $
160 $
494,574 $
2,742 $
$
$
21,524 $
11,233 $
142,789 $
481,704 $
283,219 $
293,371 $
381,217 $
14S,665 $
$
33,289 $
$
$
2,48 0,523 $
34,832 $
1,046,889 $
248,607 $
140,613 $
157,262 $
225,294 $
280,446 $
317,404 $
460,2S6 $
472,336 $
(42,9SO) $
751,34S $
216,306 $
11,118 $
568,436 $
263,717 $
848,987 $
$
1,327 $
$
23,027 $
36,572 $
$
580 $
11,523 $
5,936 $
$
221,71S $
$
42,703 $
1,74S $
$
4,558 $
142,346 $
469,269
760,097
1,305,802
3,424,342
1,337,271
$ 3S7,690 $
763,206
208,646
922
17,011
14,287,464
$ 1,043,316 $
$ 622,441 $
$ 2,062,S74 $
$ 687,176 $
$ $
$ $
$ $
$ 17,011 $
$ 5,282,24 0 $
$
99 $
$
1,4S3 $
7,125 $
$
45,176 $
67,487 $
5,366 $
$
38,212 $
$
54,851 $
$
$
$
100,S91 $
S93,283 $
$
473,078 $
749,747 $
473,915 $
$
2 $
$
$
2,610,385 $
$
$
$
$
$
$
$
31,045 $
748,839
$
$
$
$
$
$
$
$
$
$
33,103 $
217,706 $
69,916 $
$
$
$
$
1,100,609 $
2,233
24,981
1,642
17,763
46,61 9 $
(6,684)
$
$
$
446,362 $
118,158 $
$
$
$
$
557,836 $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,753 $
$
$
$
$
1,753 $
$
1,426 $
$
24,480 $
43,697 $
$
45,756 $
105,604 $
11,302 $
$
259,927 $
$
97,554 $
1,745 $
$
4,558 $
991,776 $
950,973 $
1,043,316 $
1,153,603 $
3,478,031 $
1,368,681 $
$
$
$
17,011 $
9,599,442 $
(F) = (C) + (D) -(E) (GI (H)
Appropriiltion
Transfer Out
through Ooseout
(I)
DEOBLIGATE /
Encumbrances Process OBLIGATION
Unused Balance As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 34,832 $
1,045,463 $
248,607 $
116,133 $
161,512 $
225,294 $
234,690 $
336,857 $
464,986 $
472,496 $
191,697 $
754,087 $
118,752 $
9,373 $
589,960 $
270,392 $
$
$
$
445,570 $
327,528 $
114,255 $
763,206 $
241,933 $
922 $
$
7,168,545 $
$
$
$
$
$
$
$
7,068 $
$
$
$
$
$
$
$
$
$
$
$
$
327,528 $
$
$
$
$
$
334,596 $
34,832 $
1,045,463 $
248,607 $
116,133 $
161,512 $
225,294 $
234,690 $
329,789 $
464,986 $
472,496 $
191,697 $
754,087 $
118,752 $
9,373 $
589,960 $
270,392 $
$
$
$
$
$
$
763,206 $
241,933 $
922 $
6,274,124 $
VI= {A) -(8) -(E) -(G)
(H)-(11
Unexpended
Balilnces of
Appropriation after
Closeout and
Deobligate
As of June 3 0, 2015
445,570
114,255
559,825
LOCAL PROJECTS LOCAL $ 73,000 $ 13,327 $ 55,989 $ $ 17,011 $ 17,011 $ $ $ $ $ $ 17,011 $ $ $ $ $ Addition to K-5 CUW690
JOINT LOCAL AND REGIONAL PROJECTS
REGIONAL PROJECTS
TOTAL ALL PROJECTS PER K-5
Proportionill Water Use per J-Tiible
Wholesille Share before Customer lnformiltion System
CUSTOMER INFORMATION SYSTEM' SW
(AA)
(BB )
LOCAL/REGIONAL $ 16,654,562 $ 6,364,702 $ 15,648,499 $ 33,289 $ 972,774 $ $ 2 $ $ $ $ $ $ 1,006,061 $ $ 1,006,061 $ $ REGIONAL $ 101,462,110 $ 4,201,034 $ 85,717,197 $ 2,447,234 $ 13,297,679 $ 5,265,229 $ 2,610,383 $ 1,100,609 $ 46,619 $ 557,836 $ 1,753 $ 9,582,429 $ 6,162,484 $ 334,596 $ 5,268,063 $ $ 559,825 -$,--711"'8"',1"'89"',--=6"'72,-T$--""10"',5"'79"""',06"'3,-T$--,1-,-01"",4"'2"'1"",6"'85=-""'s---2=-,""43"'0"',s"'2"'3-,$,----=1 74,"'2s"'7"",464=--,s,---= 5--=,27s2=-,724,-,oc-$,---= 2--=,6"'1"'0,"'3ss=--s,---=1"',1"'00"' ,--=609=----,,-s----, 46"',--=6"'19,-T$--,5"'5,:7--:,8-=-36=-Ts----,-1,-=75:,3,-$,----,9,-,5:,99,.,-,,44,-,2=-""'s---=7,""1"'68,.,,54=5---,$,-----=3734,-,5:,9"'6-,-,$,-- -,6--=,z-=747,"'12,.,4C-$,-------$,-----:5-:,59,-,s:,2"'5 ,-
66.67% 65.86% 65.83% 66.56% 67.63% 65.67%
(Cll = (AA) x (BB) $ 3,510,328 $ 1,719,198 $ 724,531 $ 31,030 $ 377,264 $ 1,151 $ 6,363,503 AAAACP LOCAL/REGIONAL $ 8,856,574 $ 3,786,403 $ 5,757,389 $ 1,384,017 $ 62,794 $ 51,242 $ 11,552 $ - $ Water Regional share (49.7% of Customer Information System up to FY 2013 and 51.2% for FY 2014) 1,715,168 $ 2,400,419 $
$ 1,193,008 $
47,133 $
23,425 $
523,304 $
260,082 $
40,839 $
20,297 $
24,696 $
12,644 $
3,036,391 $
1,509,457
Wholesille share {2% from Water Regional share} (C2)
Wholesale Share after Customer Information System
Pooled Interest Rate in FY 2010-11
Pooled Interest Rate in FY 2011-12
Pooled Interest Rate in FY 2012-13
Pooled Interest Rate in FY 2013-14
Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015} Interest Amount in FY 2010-11
Interest Amount in FY 2011-12
Interest Amount in FY 2012-13
Interest Amount in FY 2013-14
Estimated lntere5t Amount in FY 2014-15 (as of March 31., 2015} Balance due from Wholesale Customers
CC=(Cl+C2)
(DDl)
(DD2)
(DD3)
(DD4)
(DDS)
(EEl) = (CC) x (DDl}
(EE2) = (CC) x (DD2)
(EE3) = (CC) x (DD3)
(EE4) = (CC) x (DD4}
(EES) = (CC) x (DDS)
(FF)= (CC)+ (EEl) + (EE2) + (EE3} + (EE4) + (EE5)
$ 23,860 $ 469 $
$ 3,534,188 $ 1,719,667 $
1.24%
1.11% 1.11%
0.85% 0.85%
0.663% 0.663%
0.499% 0.499%
5,202 $
729,733
0.85%
0.663%
0.499%
406 $ 253 $ $
31,436 $ 377,517 $ 1,151 $
0.663%
0.499% 0.499% 0.499%
_$-_43_,,'-82_4---,-$ ____ $ ____ -,$ ____ .;-$ ___ ---'$�---$ _$'--_3�9
.:..;;
,22.;;.9;..._$'--_1;;.;;9.:.;;, 0.;;.88;..._$'------$'------$'------$'------ $ $ 3 0,041 $ 14,617 $ 6,2 03 $ $ $ $
-$',---2�3,�43 -2 -�$--1-1,�4 -01- .,..$---4�,838-�$---2 -08- -,-$-------,$-----$ $ 17,636 $ 8,581 $ 3,641 $ 157 $ 1,884 $ 6 $
$ 3,688,350 $ 1,773,355 $ 744,415 $ 31,801 $ 379,401 $ 1,157 $ 3 0,189
6,393,692
43,824
58,318
50,860
39,880
31,905
6,618,478
REVISED ATTACHMENT K-5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
K-5
K-5
K-5
Ad dition to K-5
K-5
Addition to K-5
K-5
K-5
Addition to K-5
Project Project Title
Hetch Hetchy Assets:
CUH703 PRIEST RESERVOIR DIVERSION CHANNEL
CUH762
CUH926
CUH945
CUH957
CUH959
CUH964
SAN JOAQUIN PIPELINE REPAIRS
PIPELINE PURCHASE REPLACEMENT PIPE'
SJ PIPELINE #4 ADDITION; CROSSOVER;TSTAJ'
FAC MAINTENANCE -WATER TRANSPORTATION
MOCCASIN RESV WATER QUALllY
WATERSHED PROPERlY PURCHASES
CUH975-02 REDUNDANT POWER SUPPLIES
CUH975-03 RESERVIOR-DAM ASSESSMENT/IMPROVEMENTS
CUH975-04 FOOTHILL TUNNELIMPROVEMENTS
CUH97S-05 MOCCASIN SEWAGE DISPOSAL IMPROVEMENTS
CUH97S-06 DAM DEFLECTION REHABILITATION
CUH97S-07 MOUNTAIN TUNNEL ADIT DOOR UPGRADE
CUH975-08 OS DRUM GATE ASSESSMENT
CUH975-09 RESERVIOR VALVES REHABILITATION
CUH975-10 MOUNTAIN TUNNEL REHAB
CUH975-11 TRASH RACKS MOCCASSIN GATE
CUH975-13 0 SHAUGHNESSY NEEDLE VALVES
CUH975-14 PENSTOCK ASSESSMENT/IMPROVEMENTS
CUH975-15 SJPL REHABILITATION
CUH975-16 TUNNEL CONDITION ASSESSMENT/IMPROVEMENT
CUH975-17 ROCK RIVER SLAKER
CUH975-18 MOCCASIN AFTERBAY REHAB
CUH975-19 LEITHOLD SERVICE LINE
CUH975
CUH383
K-5 CUH766
Ad dition to K-5 CUH774
WATER INFRASTRUCTURE - BUDGET'· 10· 11
O'SHAUGENESSY WATER SYSTEM RENOVATION'
HETCHY FACILITIES SECURllY IMPROV.'
OLD MOCCASIN POWERHOUSE REHAB.'
HETCH-HETCHY ROADS REBUILDING' K-5 CUHB04
K-5 CUH810 VARIOUS OLD JOB
1 '�
5 ' 14
Addition to K-5 CUH846 MOCCASIN PENSTOCK REPLACEMENT'
MOCCASIN PHONE SYSTEM
O'SHAUGENESSY DIS. REPAIRS
K-5 CUH876
K-5 CUH878
Ad dition to K-5
Ad dition to K-5
K-5
K-5
K-5
K-5
Ad dition to K-5
CUH899
CUH923
CUH931
CUH941
CUH946
CUH949
CUH950
STUDY/DESIGN REPL CANYON TUNNEL/PENSTOCJ<'
HH DOMESTIC WATER SYSTEM'
HH MICROWAVE REPLACEMENT
HH SCAD SECURllY & CONTROL, EAST
FAC MAINTENANCE - SUPPORT STRUCTURE'
RIGHT OF WAY MAINTENANCE'
PEN STOCK RENOVATIONS
CUH977-01 FACILITIES - SUPPORT STRUCTURES
CUH977-02 ROOR REPLACEMENT ENGINEERING BLDG
CUH977-04 FIBER/COMMUNICATION SYSTEM UPGRADES
CUH977-0S HETCHY HETCHY ROADS & RIGHT OF WAY
CUH977-07 REPAVE HETCHY ROADS-TESLA TO OSH
CUH977-08 HETCHY HVAC UNITS
CUH977-09 SCADNHMI SYSTEM REPLACEMENT
CUH977-10 FIRE SUPPRESSION SYSTEM - OPS BUILDING
CUH977-11 HETCHY ELECTRICAL UPGRADES
CUH977-12 WARNERVILLE BIO-DIESEL TANK
CUH977-13 REPLACEMENT SCADA MASTER
CUH977-15 O'SH COT 1 ROOF/ADA IMPROVEMENTS
CUH977-17 BIO DIESEL TANK/FACILITIES REPAIRS
CUH977-18 REPLACE WOOD WATER TANKS
CUH977-19 EMERGENCY BACK UP POWER MOCCASIN
CUH977-20 ENGINEERING OFFICE HVAC
CUH977-21 HHP SECURllY UPGRADES
CUH977-22 REPAIR MOCCASIN COTTAGES
CUH977-23 Oil CONTAINMENT PROJECT
CUH977-24 HHWP SMALL WATER SYSTEM IMPROVEMENTS
CUH977-25 WEST PORTAL TANK PIPING IMPROVEMENTS
CUH977-26 PERMIT HHWP ROW MAINTENANCE
K-5 CUH977
Ad dition to K-5 CUW269
FACILITIES MAINTENANCE - BUDGET' 10'"
FIBER STUDv'
TOTAL ALL PROJECTS PER K-5
POWER PROJECTS
WATER PROJECTS
JOINT PROJECTS
TOTAL ALL PROJECTS PER K-5
Proportional Water Use per J-Table
Wholesale Share (100% of WATER and 45%of JOINT)
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST AAAACP
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
ST
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
AAAACP
ClassifiCiltion
Power
WATER
WATER
WATER
WATER
WATER
WATER
JOINT
JOINT
WATER
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
WATER
JOINT
Power
WATER
JOINT
WATER
Power
JOINT
PROJECT TOTAL
JOINT
JOINT
JOINT
JOINT
Power
Power
JOINT
JOINT
Power
JOINT
JOINT
JOINT
JOINT
JOINT
Power
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
JOINT
POWER
JOINT
JOINT
JOINT
(E) = (El) + (£2) +
(A)
(B) (C) (D) = (A) -(8)-(C) --�(E�1)�---�(E_2)�---�(E_3�) ---�(E_4�) ---�(E_5�) ____ (�E6-J_� (E3)+(E4)+(ES) + (E6) Appropriation YTD Expenditures PTO Expenditures Encumbrances Available Balance Expenditures in (FJ = (C) + (D) -(E) (G)
Encumbrances
(H)
Appropriation
Transfer Out
through Closeout
Process
(I)
DEOBLIGATf/
OBLIGATION
(J) =(A)· (B)-(E)-(G)
(H)-(1)
Unexpended
Balances of
Appropriation after
Closeout and
Deobligate
As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 L=FY=2=009-=,:;10:r,_ _,:,.FY;,;2:,;0=1;;;0-;:,1:,,1 _ _..,:,,FY,:,.2;;;0=1,:,1-;:,1,;;,2 _.1._l 1,,FY,:,,:,:20�1;:,2-;,:13;;;,_.1_l 1,,FY,:,,:,:20�1�3-;,:1;;;4 _-1...: IYT=D==FY=2=0=J.4..===1:..15 Tot.I Expenditures Unused Balonce As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
21,210,344 $ 58,645 $ 20,178,474 $ 12,715 $ 1,019,155 $ 11,677 $ 668,169 $ 345,705 $ $ $ 1,025,551 $ 6,319 $ $ 6,320 $ $ 41,469,206 $ 376,954 $ 41,337,704 $ 22,570 $ 108,932 $ 95,946 $ 5,657 $ (4,335) $ 26,504 $ $ 123,772 $ 7,730 $ $ 159,860 $ 13,667 $ 157,489 $ $ 2,371 $ $ $ $ $ $ $ 2,371 $ 2,371 $ 500,000 $ $ 440,711 $ $ 59,289 $ $ $ $ $ $ $ 59,289 $ 59,289 $ 3,400,000 $ 122,418 $ 2,896,826 $ 209,138 $ 294,036 $ 201,606 $ 154,592 $ 107,781 $ (28,813) $ $ 435,166 $ 68,008 $ $ 68,008 $ 150,000 $ $ 109,379 $ $ 40,621 $ 11,955 $ $ $ $ $ 11,955 $ 28,666 $ $ 28,666 $ 800,000 $ 130,035 $ 509,035 $ 1,388 $ 289,577 $ 35,024 $ $ $ $ $ 35,024 $ 255,941 $ 255,941 $ $ 100,000 $ 8,549 $ 8,549 $ 2,120 $ 89,331 $ 323 $ 35,375 $ 50,539 $ $ $ 86,237 $ 5,214 $ $ 5,214 $ 300,000 $ 179,633 $ 179,633 $ $ 120,367 $ 36,725 $ 83,642 $ $ $ $ 120,367 $ $ $ 315,500 $ 418 $ 190,257 $ $ 125,243 $ $ $ $ $ $ $ 125,243 $ $ 125,243 $ 691,500 $ 197,110 $ 388,174 $ 9,159 $ 294,167 $ 23,389 $ 274,666 $ (15,812) $ 416 $ 282,659 $ 20,667 $ $ 20,667 $ 110,000 $ 54,847 $ 137,259 $ $ (27,259) $ (27,259) $ $ $ $ $ (27,259) $ $ $ 643,000 $ 447,483 $ 450,726 $ 1,323 $ 190,951 $ 155,893 $ 31,392 $ $ $ 187,285 $ 4,989 $ $ 4,989 $ 115,000 $ 3,094 $ 96,931 $ 20,048 $ (1,979) $ 13,854 $ 4,215 $ $ $ $ 18,069 $ $ $ 500,000 $ $ 239,922 $ $ 260,078 $ $ 445 $ $ $ $ 445 $ 259,633 $ $ 259,633 $ 972,000 $ 704,286 $ 945,567 $ 32,997 $ (6,564) $ 26,433 $ $ $ $ $ 26,433 $ $ $ 415,000 $ 2,339 $ 2,339 $ $ 412,661 $ 43,275 $ 219,026 $ $ $ $ 262,301 $ 150,360 $ $ 150,360 $ 190,000 $ 141,801 $ 168,113 $ 14,462 $ 7,425 $ 5,525 $ $ $ 5,525 $ 16,362 $ $ 16,362 $ 1,000,000 $ 255,974 $ 460,170 $ 99,191 $ 440,639 $ 237,131 $ 302,699 $ $ $ $ 539,830 $ $ $ 2,925,000 $ 2,327,311 $ 2,327,311 $ 792,130 $ (194,441) $ 428,865 $ 104,300 $ 14,872 $ 36,377 4,869 $ 8,406 $ 597,689 $ $ $ $ 528,000 $ 247,576 $ 247,576 $ 6,239 $ 274,185 $ 6,245 $ 290 $ $ $ $ 6,535 $ 273,889 $ $ 273,535 $ 160,000 $ 2,765 $ 2,765 $ 141,818 $ 15,417 $ 129,230 $ 14,182 $ $ $ $ 143,412 $ 13,823 $ $ 13,823 $ 20,000 $ $ $ $ 20,000 $ 12,457 $ $ $ $ $ 12,457 $ 7,543 $ $ 7,543 $ 15,000 $ $ $ $ 15,000 $ 15,000 $ $ $ $ $ 15,000 $ $ $ $ 9,000,000 $ 4,573,186 $ 5,845,292 $ 1,119,487 $ 2,035,221 $ 1,107,086 $ 1,070,232 $ 49,599 $ 36,377 5,285 $ 8,406 $ 2,276,985 $ 877,723 $ $ $ 877,369 $ 765,578 $ $ 765,453 $ $ 125 $ $ $ $ $ $ $ 124 $ $ 124 $ 2,086,692 $ 340,148 $ 2,038,933 $ 23,484 $ 24,275 $ 40,374 $ 3,174 $ $ $ $ 43,548 $ 4,211 $ $ 4,211 $ 1,808,487 $ $ 1,808,481 $ $ 6 $ $ $ $ $ $ $ 6 $ $ 6 $
4,175,027 $ 574,433 $ 3,777,676 $ 398,725 $ (1,374) $ 353,081 $ 30,350 $ $ $ $ 383,431 $ 13,920 $ $ 13,920 $ 7,641,687 $ 47,557 $ 7,566,901 $ 559 $ 74,227 $ 74,786 $ $ $ $ $ 74,786 $ $ $ $ 716,623 $ $ 713,578 $ $ 3,045 $ $ $ $ $ $ $ 3,045 $ $ 3,045 $ 1,610,000 $ 16,912 $ 1,530,015 $ 457 $ 79,528 $ 9,802 $ $ $ $ $ 9,802 $ 70,183 $ $ 70,183 $ 7,179,009 $ 42,279 $ 7,110,173 $ $ 68,836 $ 24,863 $ $ 9,316 $ (9,316) $ $ 24,863 $ 43,973 $ $ 43,973 $ 30,000 $ 21,804 $ 28,087 $ $ 1,913 $ $ $ 1,913 $ $ 1,913 $ 1,393,211 $ $ 1,393,062 $ $ 149 $ $ $ $ $ $ $ 149 $ $ 149 $ 4,767,000 $ 999,151 $ 4,156,642 $ 442,163 $ 168,195 $ 440,316 $ 21,851 $ 57,854 $ 24,872 11,287 $ $ 556,180 $ 54,178 $ $ $ 2,068,180 $ 489,156 $ 1,923,129 $ 104,912 $ 40,139 $ 72,077 $ 37,002 $ $ 3,836 $ $ 112,915 $ 32,136 $ $ $ 32,136 $ 2,281,454 $ 239 $ 2,273,485 $ $ 7,969 $ $ $ $ $ $ $ 7,969 $ $ 7,969 $ 815,000 $ $ 814,208 $ $ 792 $ $ $ $ $ $ $ 792 $ $ 792 $ 9,444,452 $ 3,264,219 $ 6,109,676 $ 2,758,048 $ 576,728 $ 2,493,142 $ 191,537 $ 59,334 $ 300,067 89,053 $ (2,944) $ 3,130,189 $ 204,587 $ 1,861 $ $ $ 361,556 $ 43 $ 361,591 $ $ (35) $ $ $ (35) $ $ $ (35) $ $ $ $ 216,670 $ 55,370 $ 227,450 $ $ (10,780) $ (10,780) $ $ $ $ $ (10,780) $ $ $ $ 3,354,480 $ 113,923 $ 460,652 $ 2,542,583 $ 351,245 $ 2,673,530 $ 60,374 $ 8,905 $ $ $ 2,742,809 $ 151,019 $ $ $ 151,019 $ 1,036,000 $ 277,627 $ 940,924 $ 42,323 $ 52,753 $ 78,945 $ 16,131 $ $ $ $ 95,076 $ $ $ $ 125,000 $ 6,390 $ 24,132 $ $ 100,868 $ 4,600 $ 8,216 $ $ $ $ 12,816 $ 88,052 $ $ $ 88,052 $ 100,000 $ 24,513 $ 115,350 $ $ (15,350) $ (15,350) $ $ $ $ $ (15,350) $ $ $ $ 475,000 $ 253,777 $ 321,571 $ 9,236 $ 144,193 $ 85,621 $ 45,066 $ 22,742 $ $ $ 153,429 $ $ $ $ 95,000 $ $ 76,902 $ $ 18,098 $ 18,098 $ $ $ $ $ 18,098 $ $ $ $ 305,000 $ 89,098 $ 214,397 $ 8,703 $ 81,900 $ 90,603 $ $ $ $ $ 90,603 $ $ $ $ 37,828 $ $ 37,828 $ $ $ $ $ $ $ $ $ $ $ $
310,000 $ $ 302,831 $ $ 7,169 $ $ $ $ $ $ $ 7,169 $ $ $ 7,169 $ 560,000 $ 380,477 $ 549,131 $ 14,256 $ (3,387) $ (7,197) $ 2,341 $ $ $ $ (4,856) $ 15,725 $ $ $ 15,725 $ 457,000 $ 397,964 $ 447,177 $ 17,626 $ (7,803) $ (5,427) $ 2,156 $ $ $ $ (3,271) $ 13,094 $ $ $ 13,094 $ 350,000 $ 307,505 $ 311,932 $ 7,535 $ 30,533 $ 38,068 $ $ $ $ $ 38,068 $ $ $ $ 203,749 $ 184 $ 943 $ $ 202,806 $ 335 $ 492 $ 2,825 $ 34,153 $ $ 37,805 $ 165,001 $ $ $ 162,892 $ 70,000 $ 66,489 $ 66,489 $ $ 3,511 $ 234 $ $ $ $ $ 234 $ 3,277 $ $ $ 3,277 $ 25,000 $ 14,797 $ 14,797 $ $ 10,203 $ $ $ $ $ $ $ 10,203 $ $ $ $ 253,000 $ 39,635 $ 39,635 $ 1,804 $ 211,561 $ 93,684 $ 47,607 $ 1,072 $ 10,550 47,512 $ $ 200,425 $ 12,940 $ $ $ 12,940 $ 225,000 $ 70,038 $ 70,038 $ 135,864 $ 19,098 $ 139,594 $ (6,170) $ 7,784 $ $ $ 141,208 $ 13,754 $ $ $ $ 350,000 $ 20,236 $ 20,236 $ 311,608 $ 18,156 $ 315,980 $ 9,066 $ $ $ $ 325,046 $ 4,718 $ $ $ $ 24,000 $ 4,929 $ 4,929 $ $ 19,071 $ 19,071 $ $ $ $ $ 19,071 $ $ $ $ 292,717 $ 18,024 $ 18,024 $ 274,693 $ $ 273,149 $ 1,519 $ $ $ $ 274,668 $ 25 $ $ $ 25 $ 7,730
354
354
54,178
202,726
2,109
10,203
13,754
4,718
PROJECT TOTAL _s� --9�,2_2_7,�000-�$ ___ 2�,1_ 4_1 �,0_19_�$ ___ 4�, _62_ 6�,9_5 _9�$ __ �3,_366�,2_3 _1�$ __ �1,_2 _33�,8_ 1_0 _s� -3�.7_9_2.�7 _58_�s __ 1_86_ ,�7 _98_�s __ 4_3�,2_93_�s __ 4_4�,7_0 _3 ___ 4_ 7 �,5_1 _2�$ _____ �s __ �4,_ll_ S�,064-�$ ____ 4_84� , _97_ 7_$�------ s� ______ s ___ 4_5_4 �,1 _93_�s ____ 3 _0,_784_ ST AAAACP JOINT $ 26,250 $ $ $ $ 26,250 $ 26,250 $ $ $ $ $ $ 26,250 $ $ $ $ $ (AAAl)
(AAA 2)
(BBB)
POWER
WATER
JOINT
-$.---13
""
2-,7
--
2-5,-060
----,.$ ---13-,2-l-l-,8-22-.,.$--l-18-,-11-1-,3-68--,$---8-, -45 --
9-,8
--
7 --
7 --,
$---6,-15
--
3-,8
--
1-5--$,--8-,7-90-, --744--$,--2-,36
--
9,-36 __ 2_$.--6
--
68-.-54- 7-.,.$ --3
--
9-8,-23- 0-.,.$--1
--
5 ... 3-,1-37
---.,.$---5 ,-46_2_$,,_ __ 12-,3- 8 ... 5-,48-2--,$---2 ,-2 -28-,2-1-0 """"$,----1-, 8-6
--
1-$,----4
--
70-, -206
---$,---1-,460
-- ,-37
--
2-.,.$ ----2-95-,77
=
2-
$
$
$
40,288,106 $
50,294,566 $
42,142,388 $
132,725,060 $
3,718,237 $
2,975,907 $
6,517,678 $
13,211,822 $
35,126,924 $
47,973,816 $
35,010,628 $
118,111,368 $
3,006,377 $
1,167,044 $
4,286,456 $
8,459,877 $
2,154,805
1,153,706
2,845,304
6,153,815
$
$
2,968,787 $
945,901
$ 4,876,056
$ 8,790,744
66.48%
$
$
$
1,156,235 $
497,757 $
715,370 $
2,369,362 $
65.70%
412,823 $
118,318 $
137,406 $
668,547 $
65.72%
300,067 $
34,068 $
64,095 $
398,230 $
66.43%
89,053 $
4,869 $
59,215 $
153,137 $
67.52%
(2,944) $
8,406 $
$
5,462 $
65.56%
4,924,021 $
1,609,319 $
5,852,142 $
12,385,482 $
237,161 $
711,431 $
1,279,618 $
2,228,210 $
1,861 $
$
$
1,861 $
11,278 $
317,601 $
141,327 $
470,206 $
7,543 $
386,100 $
1,066,729 $
1,460,372 $
216,479
7,730
71,562
295,771
(CCC) = (AAAl x 100% + AAA2 x 45%) x (BBB) $ 2,087,451 $ 538,525 $ 118,395 41,794 $ 21,278 $ 5,511 $ 2,812,954 REVISED ATTACHMENT K-5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
(A) (B) ICJ (D) = (A) -(8)-(C)
Appropriation YTD Expenditures PTO Expenditures Encumbrances Available Balance Pooled Interest Rate in FY 2010-11
Pooled Interest Rate in FY 2011-12
Pool&d Interest Rate in FY 2012-13
Pooled Interest Rate in FY 2013-14
Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015} Interest Amount in FY 2010-11
Interest Amount in FY 2011-12
Interest Amount in FY 2012-13
Interest Amount in FY 2013-14
Estimated Interest Amount in FY 2014-15 (as of March 31, 2015} (DDD1)
(DDD2)
(DDD3)
(DDD4)
(DDD5)
ClassifiCiltion
(EEEl) = (CCC} x (DDD1)
(EEE2) = (CCC} x (DDD2)
(EEE3) = (CCC} x (DDD3)
(EEE4) = (CCC) x (DDD4)
(EEE5) = (CCC) x (DDD5)
As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 Balance due from Wholesale Customers (FFF) =(CCC}+ (EEEl) + (EEE2) + (EEE3) + (EEE4) + (EEE5) 1 Total expenditure only included amount up to the Unused Balance. 2 Expenditures under projects CUW392 and CUW710 were re-allocated to various projects. As a resutt, there are zero balance in expenditures for these projects. 3 Project CUW690 - Customer Care & Billing System will be specially allocated due to limit to Customer Services % (2%} in WSA contract section S.OSE. 4 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009. 5 Actual expenditures exceed available fund balance, assume the exc..d expenditures are from encumbrances. 6 This project has been closed out as of June 6, 2013.
7 This project is split 64.3%/35. 7%, Joint/City} per Revised Attachment K-2. 8 This project has been closed out as of June 30, 2012. 9 Project is included as part of the revenue funded capital project. 10 Project is included as part of the Water Enterprise revenue bond funded capital project. (E) = (El) + (E2) +
�-�(E_1�) ----�(E_2)�---�(�E3�)----�(E_ 4�) ----�(E_5�) ----�(E_6�) -� (E3)+(E4)+(ES) + (E6) Expenditures in
FY 2009-10 ��-_;FY�2�0�1;;0-;,:1,:.l _ _;F,;,Y,,:2;;0=11�-=12:,_L_l _,:,FY,:,,:,20;;;1�2;;;-13:;;,__JIL;,.FY;,.2;;;0;,:1;;;3-;;;1;;:4'"""11_,YT=D=FY=2=014-==1=5:..I Tot.I Expenditures
1.24%
1.11% 1.11%
0.85% 0.85% 0.85%
0.663% 0.663% 0.663% 0.663%
0.499% 0.499% 0.499% 0.499% 0.499% 0.499%
$ 25,884 $ $ $ $ $ $ 25,884
$ 23,171 $ 5,978 $ $ $ $ $ 29,148
$ 17,743 $ 4,577 $ 1,006 $ $ $ $ 23,327
$ 13,840 $ 3,570 $ 785 $ 277 $ $ $ 18,195
$ 10,416 $ 2,687 $ 591 $ 209 $ 106 $ 27 $ 13,694
$ 2,178,506 $ 555,338 $ 120,777 42,279 $ 21,384 $ 5,538 $ 2,923,204 (F) = (C) + (D) - (E)
Unused Balance
11 Projects CUH975 and CUH977 were funded by revenue in FY 2009-10 and FY 2010-11. However, starting: in FY 2011-12, these two projects were funded by Water Revenue Bond Series 20118. As a result, Wholesale Customers were refunded $10,838,326 ($10,519,682 collected in FY 2009-10 and FY 2010-11 plus interest of $318,644) in FY 2011-12. 12 Intentionally left blank.
13 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009. 14 Per discussion with Carlos Jacobo, project CUH810 is a custom work project and should be "POWER" not "JOINT'. These custom works are mainfy for street light maintenance. (G)
Encumbrances
(H)
Appropriation
Transfer Out
through Closeout
Process
(I)
DEOBLIGATE/
OBLIGATION
As of June 30, 2015 As of June 30, 2015 As of June 30, 2015 (J) = (A) - (B)-(E)-(G)
(H)-(1)
Unexpended
Balances of
Appropriation after
Closeout and
Deobligate
As of June 30, 2015
REVISED ATTACHMENT K-5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT L
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Project
Number
REGIONAL
CUW373 Regional
CUW384 Regional
CUW387 Regional
CUW352 Regional
CUW355 Regional
CUW359 Regional
CUW370 Regional
CUW374 Regional
CUW381 Regional
CUW382 Regional
CUW386 Regional
CUW353 Regional
CUW363 Regional
CUW368 Regional
CUW380 Regional
CUW389 Regional
CUW393 Regional
CUW354 Regional
CUW356 Regional
CUW357 Regional
CUW361 Regional
CUW365 Regional
CUW366 Regional
CUW367 Regional
CUW369 Regional
CUW371 Regional
CUW378 Regional
CUW379 Regional
CUW390 Regional
CUW391 Regional
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project Description
San Joaquin Region
San Joaquin Pipeline System Rehabilitation
Tesla Advance Disinfection
Tesla Portal Disinfection
Sunol Valley Region
Alameda Creek Fishery Enhancement
Stand-by Power - Various Locations
New Irvington Tunnel/Alameda Siphon NO.4
Pipeline Readiness Improvements
Calaveras Dam Replacement
SVWTP 40 mgd Addition
SVWTP Finished Water Reservoir
San Antonio Pump Station Upgrade
Bay Division Region
Seismic Upgrade BDPL 3 & 4
SCADA Phase II/Security Upgrades
BDPL Reliability Upgrades
BDPL 3 & 4 Crossover
EBMUD Intertie
BDPL 4 Slipline
Peninsula Region
Lower Crystal Springs Dam Improvement
Crystal Springs Bypass Tunnel
Adit Leak Repairs
Pulgas Balancing Reservoir Rehabilitation and Improvements Cross Connection Control
HTWTP Short Term Improvemetns
HTWTP Long Term Improvements
Capuchino Valve Lot Improvements
Crystal Springs/San Andreas Transmission
Crystal Springs Pipleine 2 Replacement
San Andreas Pipeline 3 Installation
Desalination
Baden & San Pedro Valve Lots Improvements
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project
Number Project Description
San Francisco Region
CUW358 Regional Sunset Reservoir Upgrades - North Basin CUW372 Regional University Mound Reservoir Upgrades - North Basin System-Wide
CUW388 Regional PEIR
CUW392 Regional Program Management Services
CUW394 Regional Watershed Land Acquisition
RETAIL
Reservoirs
CUVV307 Local Summit Reservoir Rehabilitation
CUW310 Local New Northwest Reservoir
CUW319 Local Hunters Point Reservoir Rehabilitation
CUW334 Local Stanford Heights Reservoir Rehabilitation
CUW335 Local Potrero Heights Reservoir Rehabiliation
CUW337 Local Sutro Reservoir Rehabilitation
Pump Stations/Tanks
CUW306 Local Croçker Amazon Pump Station Upgrade
CUW309 Local Lake Merced Pump Station Upgrade
CUW314 Local La Grande Tank Upgrade
CUW318 Local Forest Hill Tank Rehabilitation
CUW320 Local Forest Hilll Pump Station Upgrade
CUW321 Local Forest Knoll Pump Station Upgrade
CUW322 Local Lincoln Park Pump Station Upgrade
CUW323 Local Alemany Pump Station Upgrade
CUW324 Local Mount Davidson Pump Station Upgrade
CUW326 Local Palo Alto Pump Station Upgrade
CUW326 Local Sktview-AquaVista Pump Station Upgrade
CUW327 Local Summit Pump Station Upgrade
CUW328 Local McLaren #1 Tank Rehabilitation
CUW329 Local Potrero Heights Tank Seismic Upgrade
CUW330 Local Forest Knoll Tank Seismic Upgrade
CUW331 Local Lincoln Park Tank Seismic Upgrade
CUW332 Local McLaren #2 Tank Rehabilitation
CUW333 Local Mount Davidson Tank Seismic Upgrade
CUW338 Local La Grande Pump Station Upgrade
CUW339 Local Potrero Heights Pump Station Upgrade
CUW340 Local Vista Francisco Pump Station Upgrade
Page2 of 3
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Project
Number
CUW304 Local
CUW308 Local
CUW311 Local
CUW312 Local
CUW313 Local
CUW315 Local
CUW316 Local
CUW301 Local
CUW302 Local
CUW364 Local
CUW303 Local
CUW305 Local
ATTACHMENT L-1
IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project Description
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
Eastlest Transmission Main
Fulton (§ Sixthe Ave Main Replacement
Water SupplylWater Quality
Groundwater
Recycled Water
Lawrence-Livermore National Laboratory Water Quality Improvements Miscellaneous
Vehicle Service Facility Upgrade
Fire Protection at CCD
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
A TT ACHMENT L-2
03/13/06
$507,815,000
PUBLIC UTILITIES COMMISSION
OF THE CITY AND COUNTY OFSAN FRANCISCO
SAN FRANCiSCO WATER REVENUE BONDS, 2006 SERIES A
$110,065,000
PUBLIC UTILITIES COMMISSION
OF THE CITYAND COUNTY OF SAN FRANCISCO
SAN FRANCISCO WATER REVENUE BONDS, 2006 REFUNDING SERIESB
CERTIFICATE REGARDING USE OF PROCEEDS
The undersigned hereby states and certifesas follows:
(i) The undersigned is the General Manager of the Public Utiities Commission of the City and County of San Francisco (the "Commission"), and is authorized to execute this certificate on behalf of the Commission and is knowledgeable with respect to the matters set forth herein.
(ii) On the date hereof, the Commission is issuing the two series of bonds captioned above (the "2006 Series A Bonds," the "2006 Refunding Series B Bonds" and, together, the "Bonds") pursuant to an Amended and Restated Indenture dated as of August 1, 2002 and the First Supplemental Indenture dated as of March 1, 2006 (collectively, the "Indenture"), both by and between the Commission and U.S. Bank National Association, as trustee (the "Trustee"). (iii) The Trustee wil transfer and deposit the proceeds of the 2006 Series A Bonds received by the Trustee on the date hereof as follows:
(1) $48,212,528.32 will be deposited in the 2006 Series A Gapitalized Interest Account established within the Interest Fund;
(2) $15,958,031.25 will be deposited in the 2006 Series A Reserve Account of the Bond Reserve Fund;
(3) $623,906.09 will be deposited in the 2006 Series A Costs of Issuance Fund; (4) $120,622,352.19 will be deposited in the 2006 Series A Refunding Fund and transferred pursuant to Irrevocable Refunding Instructions of the Commíssion dated the date hereof; and
(5) the remaining $338,600,816.86 wil be transferred to the Treasurer for deposit to the 2006 Senes A Project Fund.
(iv) The proceeds of the 2006 Series A Bonds transferred pursuant to the Irrevocable Refunding Instructions of the Commission wil be used to defease and refund the Commission's Commercial Paper Notes (Water Series) on a current basis. The Notes were issued to finance a portion of the facilities described in Exhibit A hereto. (v) The proceeds of the Bonds deposited in the 2006 Series A Project Fund will be used to finance a portion of the facilties described in Exhibit A hereto.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
A TT ACHMENT L-2
CONTINUED
(vi) The Trustee wil transfer and deposit the proceeds of the 2006 Refunding Series B Bonds received by the Trustee on the date hereof as follows:
(1) $192,498.04 wil be deposited in the 2006 Refunding Series B Costs of Issuance Fund; and
(2) $111,178,241.95 wil be deposited in the 2006 Refunding Series B Refunding Fund.
(vii) The proceeds of the Bonds deposited in the 2006 Refunding Series B Refunding Fund, together with amounts on deposit in the funds and accounts established under the Indenture for the Commission's San Francisco Water Revenue Bonds, 1996 Series A (the "1996 Series A Bonds") and its San Francisco Water Revenue Bonds, 2001 Series A (the "2001 Series A Bonds"), wil be used to refund on an advance basis a portion of the outstanding 1996 Series A Bonds and a portion of the outstanding 2001 Series A Bonds. The portion of the 1996 Series A Bonds being refunded were issued to finance the facilties (the "1996 Project") described in Exhibit B hereto, and the portion of the 2001 Series A Bonds being refunded were used to finance the facilties (the "2001 Project") described in Exhibit B hereto. (viii) Exhibit C hereto attached describes (A) each use to be made by any person of the Project', the 1996 Project and the 2001 Project other than use by the Commission and other non-federal governmental units and other than use by members of the public generally, and (B) payments (if any) directly or indirectly in respect of such use which are to be made after the date hereof;
(ix) Other than as set forth in Exhibit A and Exhibit B, no portion of the proceeds of the Bonds wil be used, directly or indirectly, to make or finance a loan to any person (other than a State or local government unit) or to acquire property which wil be sold or leased to any person (other than a State or local government unit) on an installment a sale basis except as referenced in Exhibit C.
(x) The Commission expects to use the Project for the purposes referenced and discussed in Exhibit Ai Exhibit B, Exhibit C and Exhibit D or for other governmental purposes of the Commission during the entire term ofthe Bonds. ,
(xi) Set forth on Exhibit 0 is the Commission's methodology for determining governmental use and private use with respect to the water enterprise:
(xii) To the best knowledge of the undersigned, the above statements are reasonable and there are no other facts, estimates or circumstances, other than those set forth herein, that would matenally affect the statements made herein.i
Capitalized terms used but not defined herein have the meanings set forth in the Indenture.
IN WITNESS WHEREOF, I have hereunto set my name this 15th day of March, 2006.
By:
2//
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT L-2 (CONTINUED)
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
SUMMARY OF SOURCES AND USES OF FUNDS
(Section 5.04)
Source: Closing Documents (Certificate Regarding Use of Proceeds) Proceeds
Principal
Plus Premium
Minus Underwriter's Discount
Minus Insurance
Net Proceeds
i;07,815,000.00
19,109,138.35
(932,940.06)
(1,973,563.58)
524,017,634.71
Use of Proceeds
Capitalized Interest Fund
Bond Reserve Fund
Insurance Fund
Series A Refunding Fund
Series A Project Fund
Total Uses
48,212,528.32
15,958,031.25
623,906.09
120,622,352.191.
338,600,816.86 f 459,223,169.05
524,017,634.71
Commercial Paper Project Fund Total
Hetch Hetchy
Tesia Portal Disinfection 251,262.58 1,147,302.42 1,398,565.00 Advance Disinfection 429,714.76 5,611,554.24 6,041,269.00 SJPL 4,737,937.28 17,784,667.72 22,522,605.00
Total Hetch Hetchy 5,418,914.62 24,543,524.38 29,962,439.00 SF Regional
University Mouhd - North 55,728.10 5,964,279.90 6,020,008.00 Sunset - North 7,525,896.84 28,782,094.16 36,307,991.00 Groundwater 3,400,973.67 2,963,110.33 6,364,084.00
Recycled Water 1,548,036.76 11,316,958.24 12,864,995.00 Total SF Regiona1 12,530,635.37 49,026,442.63 61,557,078.00 SF Local 45,405,787.71 106,407,313.30 151,813,101.01
Sunol Valley Subregional
Calaveras Dam 9,065,945.51 15,993,818.49 25,059,764.00
Stand-by Power 556,398.67 1,207,319.33 1,763,718.00
Pipeline Readiness 649,566.31 4,942,205.69 5,591,772.00 SAPS Upgrade 213,423.44 1,748,134.56 1,961,558.00
SVWTP Finished Water Res 3,317,203.82 7,838,383.18 11,155,587.00 Irvington Tunnel 4,084,139.65 18,247,176.35 22,331,316.00 Alameda Creek Fishery 656,765.00 1,327,119.00 1,983,884.00 SVWTP 40 mgd Addition 25,378.75 3,474,585.25 3,499,964.00 Total Sunol Valley Subregional 18,568,821.15 54,778,741.85 73,347,563.00
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
This certificate is for illustration only. It was prepared in 2006 and shown groundwater and recycled water projects as regional instead of locaL. In addition, it does not reflect expenditures for the portions of regional assets which in rate base as of June 30, 2008 nor what is expected to be added to rate base through June 30, 2009. For these reasons, the percentages shown for regional and local projects are not accurate.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT L-3
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
(Section 5.04 A)
Project
Number
REGIONAL PROGRAM
San Joaquin Region
San Joaquin Pipeline System Rehabilitation
Tesla Advance Disinfection
Tesla Portal Disinfection
Total San Joaquin Region
CUW373 Regional
CUW384 Regional
CUW387 Regional
CUW352 Regional
CUW355 Regional
CUW359 Regional
CUW370 Regional
CUW374 Regional
CUW381 Regional
CUW382 Regional
CUW386 Regional
CUW353 Regional
CUW363 Regional
CUW368 Regional
CUW380 Regional
CUW389 Regional
CUW393 Regional
CUW354 Regional
CUW356 Regional
CUW357 Regional
CUW361 Regional
CUW365 Regional
CUW366 Regional
CUW367 Regionai
CUW369 Regional
CUW371 Regional
CUW378 Regional
CUW379 Regional
CUW390 Regional
CUW391 Regional
CUW358 Regional
CUW372 Regional
CUW388 Regional
CUW392 Regional
CUW394 Regional
LOCAL PROGRAM
CUW307 Local
CUW310 Local
CUW319 Local
CUW334 Local
CUW335 Local
CUW337 Local
CUW306 Local
CUW309 Local
CUW314 Locai
CUW318 Local
CUW320 Local
CUW321 Local
CUW322 Local
CUW323 Local
CUW324 Local
Project Description
Sunol Valley Region
Alameda Creek Fishery Enhancement
Stand-by Power - Various Locations
New Irvington Tunnel/Alameda Siphon NO.4
Pipeline Readiness Improvements
Calaveras Dam Replacement
svwp 40 mgd Addition
svwP Finished Water Reservoir
San Antonio Pump Station Upgrade
Total Sunol Valley Region
Bay Division Region
Seismic Upgrade BDPL 3 & 4
SCADA Phase II/Security Upgrades
BDPL Reliability Upgrades
BDPL 3 & 4 Crossover
E8MUD Intertie
BDPL 4 Slipline
Total Bay Division Region
Peninsula Region
Lower Crystal Springs Dam Improvement
Crystal Springs 8ypass Tunnel
Adit Leak Repairs
~~fE~~E~~~';~;OO '"' ,m~:.""..m",..'.'.~,:,'\'.:,e,JJt,'.-.:.~.;\~,~~\\ Crytal Springs/San Andreas Transmission _~, " , _) _
Crystal Springs Pipleine 2 Replacement i'"' \ \'.,; '\
San Andreas Pipeline 3 Installation 'f; è\ \ " ,\'(0,'1 Desalination /_ 'r~ \. '\ /~\_\~~)! ,.:Y
Baden & San Pedro Valve L9íel¡prcìÌ!èn~-!tS
Total Peninsula Region '\ \\, .~;~¿\;;,..
\2;'.\;/
San Francisco Region
Sunset Reservoir Upgrades - North 8asin-
University Mound Reservoir Upgrades - North Basin
Total San Francisco Region
System-Wide
PEIR
Program Management Services
Watershed Land Acquisition
Total System-Wide
Total Regional Program
Reservoirs
Summit Reservoir Rehabilitation
New Northwest Reservoir
Hunters Point Reservoir Rehabilitation
Stanford Heights Reservoir Rehabilitation
Potrero Heights Reservoir Rehabilitation
Sutro Reservoir Rehabilitation
Total Reservoirs
Pump Stations/Tanks
Crocker Amazon Pump Station Upgrade
Lake Merced Pump Station Upgrade
La Grande Tank Upgrade
Forest Hill Tank Rehabilitation
Forest Hilll Pump Station Upgrade
Forest Knoll Pump Station Upgrade
Lincoln Park Pump Station Upgrade
Alemany Pump Station Upgrade
Mount Davidson Pump Station Upgrade
Net Financing
Proceeds'
1,398,565
6,041,269
22,522,605
29,962,439
1,983,884
1,763,718
22,331,316
5,591,772
25,059,764
3,499,964
11,155,587
1,961,558
73,347,563
21,234,846
1,313,461
45,235,465
21,239,846
10,743,922
1,219,251
100,986,791
4,2J.°Ata
18¡4Q6,O~~
. ir1',.9tsN'03\
..\\3_92,i.~213
\. \\:C,¡75, 1 09
v' 6,457,624
3,656,979
916,364
5,737,829
6,288,936
3,435,064
652,092
3,023,744
60,090,650
6,020,008
36,307,991
42,327,999
8,308,050
13,323,598
502,660
22,134,308
-328,849,750
Appropriated
Interest
Earnings'
Adjusted
Project
Funding
Expenditures
Thru 6/30/093
Remaining
Balance
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Project
Number
CUW326 Local
CUW326 Local
CUW327 Local
CUW328 Local
CUW329 Local
CUW330 Local
CUW331 Local
CUW332 Local
CUW333' Local
CUW338 Local
CUW339 Local
CUW340 Local
CUW304 Local
CUW308 Local
CUW311 Local
CUW312 Local
CUW313 Local
CUW315 Local
CUW316 Local
CUW301 Local
CUW302 Local
CUW364 Local
CUW303 Local
CUW305 Local
WATER ENTERPRISE REVENUE BOND 2006 SERIES A
ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
(Section 5.04 A)
Project Description
Palo Alto Pump Station Upgrade
Sktview-AquaVista Pump Station Upgrade
Summit Pump Station Upgrade
McLaren #1 Tank Rehabilitation
Potrero Heights Tank Seismic Upgrade
Forest Knoll Tank Seismic Upgrade
Lincoln Park Tank Seismic Upgrade
McLaren #2 Tank Rehabilitation
Mount Davidson Tank Seismic Upgrade
La Grande Pump Station Upgrade
Potrero Heights Pump Station Upgrade
Vista Francisco Pump Station Upgrade
Total Pump StationslTanks
Net Financing
Proceeds1
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
EasUWest Transmission Main
Fulton ~ Sixth Ave Main Replacement ','"
TloalPipelinesNalves "'1/;;2:'\,\ \:,' .).
Water SupplylWater Quality .. (!. \ ¡':::) j \.i
Groundwater ~(~, \\ ~ :\ ,! (. ,:.j'
Recycled Water. it, \ \Y";¿. .,'
Lawrence-Livermore Natioita.1 täi,oj~t~iY.Wáter Quality Improvements Total Water SupplylWater Q"Ii~Ir,:~j'/
\J':;'
/)\)f§j\~\
f,:\'\\'
Miscellaneous
Vehicle SerVice Facility Upgrade
Fire Protection at CCD
Total Miscellaneous
Total Local Program
Grand Total Regional and Local Programs
Unappropriated. Interest Earnings
Percent of Net Proceeds.
Percent of Net Proceeds and Earnings4
'Net financing proceeds available on date of issue (i.e. deposit to project fund) 'Cumulative net of arbitrage rebate liability
3Cumulative
'If financing sources Substantially Expended, proceed allocations are then fixed
Appropriated
Interest
Eamings2
Adjusted
Project
Funding
Expenditures
Thru 6/30/09'
Remaining
Balance
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT M
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
REVENUE-FUNut:D CAPITAL ADDITIONS (Section 5.04.8)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) ATIACHMENI M-1
Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year)
A B C D E F
Wholesale Customer Capital Fund (5W CPF WCF)
G=C.D-F H I=G.H
Based on Proportionate Annual Water Deliveries of ... 68.7% Project Title
CUW262 Regional Water RnR - Treatment Facilities
CUW263 Regional Water RnR - ConveyancefTransmission Systems CUW264 Regional Water - Watersheds I ROW Management
FUW100 Regional Water - Facilties Maintenance
CUW261 Regional Water - Storage
FY 2009.10
Approved
Budget -
Total Regional
$ 1,000,000
$ 7.000,000
$ 500,000
$ 3,700,000
FY 2009-10
Approved
Budget -
WHOLESALE
SHARE
$ 687,000
$ 4,809,000
$ 343,500
$ 2,541,900
Projected
Expended &
Total Fiscal Year Encumbered Appropriated, Encumbered Projected Appropriation - All Years Actual 2009-10 Actual But Not Unencumbered through Surplus 1 All YearsA ExpendituresA ExpendituresA ExpendedA BalanceA 6/30/2010 (Shortall) $ 687,000 $ $ '$ $ 687,000 . $ 229,000 $ 458.000
$ 4,809,000 $ $ $ $ 4,809,000 $ 1,603,000 $ 3,206,000
$ 343.500 $ $ $ $ 343,500 $ 114,000 $ 229.500
$ 2,541,900 $ - $ $ - $ 2,541,900 $ 847,000 $ 1,694.900 Regional Total ~ _.~ $
Source: . SFPUC Commission Approved Budget, February 2009, Same Format . FAMIS - City's Official Financial System of Record
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.8)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) ..
Projected FAMIS.as of June 30, 2010 (Last Day ofBuClget Year) Based on Proportionate Annual Water Deliveries of 00'
Wholesale Customer Capital Fund (5W CPF WCF)
68.7%
FY 2009-10 Projected
FY 2009-10 Approved Expended &
Approved Budget - Total Fiscal Year Encumbered Appropriated, Encumbered Projected Budget - WHOLESALE Appropriation - All Years Actual 2009-10 Actual But Not Unencumbered through Surplus 1 Project Title Total Regional SHARE All YearsA ExpendituresA ExpendituresA ExpendedA BalanceA 6/30/2011 (Shortall) CUW262 Regional Water RnR - Treatment Facilities $ 1,000,000 $ 687,000 $ 687,000 $ 235.000 $ 235,000 $ $ 452,000 $ 409.000 $ 43.000 CUW263 Regional Water RnR - ConveyancefTransmission Systems $ 7,000,000 $ 4,809.000 $ 4,809,000 $ 1,395,000 $ 1,395,000 $ 25,000 $ 3,389,000 $ 1,589.000 $ 1.800,000 CUW264 Regional Water - Watersheds I ROW Management $ 500,000 $ 343.500 $ 343,500 $ 115,000 $ 115.000 $ 50,000 $ 178,500 $ 35.500 $ 143,000 FUW100 Regional Water - Facilities Maintenance $ 3,700,000 $ 2,541,900 $ 2,541,900 $ 850,000 $ 850,000 $ 123,000 $ 1,568,900 $ 768,900 $ 800,000 CUW261 Regional Water - Storage $ - $
Regional Total $ 12,200,000 $ 8,381,400 $ 2,595,000\ $ 2,595,000.J $ 198,000 $ 5,588,400 $ 2,802,400 $ 2,786,000 Source: . SF PUC Commission Approved Budget, February 2009, Same Format · FAMIS - City's Official Financial System of Record .
'\
Shown On Attchment N.2, Schedule 3
Revenue Capital - Actual Expenditures
"Shown on Attchement N-2, Schedule 3
Continuing Appropriation
Needed for Mulit-Year
Revenue Funded Capital
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
N
:E 'õ
.. NZ "
W '"
~ ~
~
os.s
~-:J
.s
~::~'tII §
;g lL
in .l
5 is.
~~Cl ..
~Ë
I/ 0
z ..
o g¡¡:u
ë ,gC Clc: II
;¡ ~
ii ~
c: lL
Uuc~wlLCo.~U
lL i-
i. II
:: 'tZ i:
~ :5W::
ii I/
'C
~
lí'"
-gai
~
Õ
~..o
o
N
.:
.2':i..Õ....
CI
¡¡
11 '"
t"
"ê'a-
:i
C)
.!
i:
~U"
C)
¡¡
~
u.u. a-u
~
'"c::iu.
;gw c-..U
~
~:iU
.!0"
ii
õ
;:
U
ai
Ol'"
i i: f! .c ~
~-8.8 gi~
'è~~~~Q. ~ C (,W W
"#
;;'"
~ i ~ ~ w
ge~f3~N c. "C .. :i
~.îól~CI::
-0
-I
~ i: . g
en ~ to.-
~ ~i~~ c- :i ..c( m ~
Õ
~"-c:
.~
¿¡
~..:ic:
c:
-0
~c:
o
:eoc-
ea-
c:o
"'.
~..ai
"'- -IV Ul ñi
-i .2 'I
'~ e- 0~ :i .ca-CICi
o CDo CD
In ..
CD~ or
00 r:
lßllWU)
0000
00 ~- ri., CO
if ff (ß U) U) (ß fß (ß (ß U) U) El tß
.'"
-g f! 0(
~ ~ BCo :J ;
~ ~ ~
~5
o CDo CDIn ..
~ ",.N. 0.
'" .
~ õ -g.D Z '"
§ "5 ~
u ai "
iJ w
ff(ßU)(ß
If (ß ff ff
c:o .
i; ~ ~
ë g- ~
&: ~
-0
g ~In .."" ~N to
N.O.
o CD
o CD
In ..
.. T""N ..N.O.
'" '"
lßffl0U)WU)WWfftßffWEi
.. i Q. Do D. Do Do Q. D. C. a. 3: ;:
a a 0 a 0a a 0 a 000000cicic:cic:a a 0 a 0o IS 0 0 f'
.. cr-"¡ - c¡
g ¡i:g :i
~ ~ ~ ~"(U t:"C II
~~tl~.ê
~~'~Õ.5
~ "g .Ef~ j~ u. ~
~ ~ ~ ~ ~(I a: S '; 0:
_u~2&~Q)-" .. jj
" ~ ~Ld~~ IIU)otI
ü ~~~~~~~~'~ 55555555a. üuul)uu0u
g"
t ;g
O~ en Wi2 ~Q. ~. Q)
l:š iT c'õ~ã.~
~~:i " ".. 0 iñ
c en "' (9
;l ~ ~ ~
E ~ ~ ~
~ '~ ~ ~:i (, (9 a:
§8ig§~§§ciit~c5lt-å6mCOOONOOo (f i. r- C" 0 0- r- e- Ñ cõ Ñ g c
.~ ~ ~ '~
et ~ ~ ~_O)Ula.æ Ìi .ê i:
~ ~ i ~2ã.1illê"~5:~;;-grt~~ æ ~ æ" ~ "l! .ê 2 c
~ ~ ~ ~
~ jj ~ ~
~:i::U
0000
00 ~~
CDCD'"
'"
g¡
Ñ
..
§ §
C"- .,
gi :S
"" -
'"CD
'"
~..
0000
00ri ~
:g ~"" -
..'"
Ñ
:!Ñ'"
..
~..c:o'¡;
&!
;;
E
il"
E
~
CDo
oN",
~ Š
~ &!
" -u. 0.; E~2
~~
-g ~,. c:
e ..0..5
c- u.
~~'~-~
.!!OE '"E :¡
8C3
g~a- ::u. -0CI u.. .
~:i
oCI
~
..'c:
~:;
'"c:-c:
~i:
lí'"'":iai
ß.."
i=
'C..
~
lí'"'":iai
Õ,.
~
!
~o
N
ÒCO
~"..Õ
'"..
!!:;
11 ~"
'ea-
os.s
~:J.s
~::~'t
II §
~ ~II .l
.2 'g.
õ uCl ..
~ ËI/ 0z ..
o g¡¡: u
ë ,gC Clc: II
;¡ ~
ii ~
c: lL
U U
C ~w lLCo.
~ ulL i-
i. II
::'tz i:
~ :5w ::
ii I/
"'- -II II r;-i .2 'I
'~ e- 0e :J.ra- CI CI
Ol'"
"i-g ¡ã~Õ i:.Q :J 0'~-~ ~ ~ ~
Q.)(c CDw w
.'"
i ! c
~ ~ fJQ. :i ;
~ ~ ~
: :5
¡¡
~
u.a-U
~
'"c:
iÌ
..'"c-..U
~
~:iU
.!..
...!o
;:
"'. .
~ õ "i.Dz'"
~ "S ¡u ai "
iJ w
~.,'"
~ i.. ~ w
g e ~æ ~N Q."C..:i
~.îól~CI::
-I
S! i: i 5
g ~ 1; ';
~ a..g~~ Q,:i..ci m ~
õ
.ê
.~
¿¡
I..:ic:
c:
-0
~c:
o
:eoc-
ea-
c:o
'"":ai
w (, Ul W Ul Ei lß fß U) W U) W U7
tlff6"WElWtllßfßl:Wtflß
o CDa CDIn ..
.e ~.:N ..N~ 0_
fFtßUllßtßlRtlliEltßEltßtl
o CDo CDIn .... ~
gj. ~-
ll Ul (ß lß (ß U) lß lß Eß (ß (ß U) lß
c:o.
ei ~ ~
~ e~
.îct
o CDo CDIn ..
~ ;N.O.
lß Ei El U' U' Ul tl (ß En (ß fß lß W
~ ~"'" ~N ..
NO'" -
ff (ß ff tß tß ti lß tf tß lß Eß tß tl
g g g g g
o a 000ci ci ci ci ci
a a 0 0'0
a i. a a ""-a- ri-oe" - ~
a- a- a- a- a- a- a- a- a- :: ::
g~i:g~g8a MO",OOci 1.- 'r" ci iri ci 0cnIDOO'NOO
o C' i. r- (" a a- 1"" ('j N- (0" Ñ
(ß lß lß ll lß lß lß tß lß ff ff lß W
"'"..
ilc:
..
c:
~
E ~
~ :ß
~ ~g- u.
'" '"
! d1
:l:ii:
l~
il b5
" c:
~ .Qc: ..
~ -~
~ ~(f
~ t6 ~
~ itdi (f;;
~ g~ i: u.9: l! :8ß w '~~to
~ ~~ o:~s~
,êlo:i ëei~D..£ z;ei ~~e-g..~=êi:~w::"§~_§~woeõ-~Q)
a.'§:§~~Ë~~~
n::Æ ~~(~~-gn:_~ci ë (I i: ~.! :: cd -n:~"Ëæ~~~i:n:
l~~e~~'ê~1:i~:~~~~i~3i:iUC)O:l-WI~
õ ~~~Š;~~~~
'ê' 55555555a. OOOOOüoo
'"
.!"'"
l!uCI
~~ ~
ê: '~ ¡ g-II Q.~ 0
~ K:!iU Q. :i i:nic(:EC
ä gi 0 æ
c.- - Cb
..¡ill len 0 Z IX
00 0000ct'r-
~ gs
.,- -
'" ~
.! l!" ""'''"'".c c:u"CI c-."
~~- "
¡ ~
~~~~-0 :ic:UAÎQ"~c:"~ Iio ,..c "CID:
'"
":;
~ 'i...c'c: u"CI
~~-",z
.2 i.. E
~ ti- ..
i~" c:ai 0
o c:- ~
'" 0
~æ
000000MT"-CD CDo CO
"" -
'"'"
~,.
..
00 g gri ~CD CD
o CO
"" -
CD
::
~,.
§ §crr
gi :S
"" -
~..c:o
i
;;
E
il
~
~
CDo
oN",
~ Š
H,,-u. 0.; E" "
.g¡¡
di Ji","i
~ .~
RJ:
~~
'~ E.~ 0
E ~
E :¡
86 g~a- ::u. -0(f u.
'"..In:i::U
åi
l!:i
oCI
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT M-2
REVENUE FUNDED CAPITAL
ANNUAL REPORTING REQUIREMENTS
(Section 5.048)
Part A. Updated Actual Information Through Most Recent Fiscal Year (Due in November) Each year, the SFPUC will provide a report on the status of the regional revenue funded projects with the following information:
Project-level information (through close-out)
1 Scope of project
2 Current cost estimate/budget.
3 . Expected milestone dates (ie, design, environmental, construction period, close-out, etc.) 4 Contract status
5 Reasons for status changes from prior report.
6 Other information relevant to whether project is on time/on budget. 7 For most recently completed fiscal year and estimated for current year:
8 Total expenditures (capital and operating); amounts paid from other sources. 9 Amount of encumbered and unencumbered appropriations
10 Application of any unused appropriations
Wholesale Capital Fund
11 Beginning balance, deposits, capital expenditures (by project), earnings, ending balance. 12 Components of ending balance; wholesale portion of:
13 Appropriated and encumbered
14 Appropriated but unencumbered
Part 8. Proposed Appropriations for Upcoming Year (Due in March) 15 Project information, to the extent not provided in Part A 16 Expected funding needs for regional projects
17 Unused or excess appropropriations carried over.
18 Proposed appropriation for upcoming fiscal year.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Amended Attachment M-3
Wholesale Capital Fund and Balancing Account Adjustment Reference Amended Section 6.08E
A. Cash Flow in Wholesale Capital Fund
FYE 2010 FYE 2011 FYE 2012 FYE 2013 FYE 2014 FYE 2015 FYE 2016 FYE 2017 FYE 2018 FYE 2019 FYE 2020 FYE 2021 FYE 2022 FYE 2023 1 Beginning Total Balance (1) - 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 2 Annual Appropriation (2) 10,476,724 8,636,920 21,737,468 11,285,643 18,668,585 15,432,451 21,138,051 11,184,265 17,847,379 26,424,000 26,420,000 13,210,000 13,210,000 13,210,000 3 Annual Expenditures (3) (1,778,695) (5,202,897) (18,553,119) (10,916,349) (5,758,565) (7,331,312) (6,245,954) (13,892,649) (14,361,409) (18,089,498) (16,723,232) (28,485,215) (33,563,793) (22,018,000) 4 Interest Earnings (4) 120,294 151,929 173,034 137,113 180,672 58,140 115,532 299,936 370,050 475,153 664,783 757,859 711,183 409,280 June 30 Balances Before Balancing Account Transfers
5 Total Balance (5) 8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785 42,508,440 51,910,495 32,848,850 17,206,239 12,807,520 6 Amount Encumbered as of June 30 (6) (1,927,466) (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 7 Unencumbered Balance (7) n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a 41,508,440 50,910,495 31,848,850 15,206,239 10,807,520 8 Transfer From/(To) Balancing Account (8) n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a (959,496) (4,544,290) 4,000,000 4,000,000 4,000,000 Ending Balances After Balancing Account Transfers
9 Ending Total Balance (9) 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 16,807,520 10 Unencumbered Ending Balance (10) n/a n/a n/a n/a 7,156,838 n/a n/a n/a n/a 40,548,944 46,366,205 35,848,850 19,206,239 14,807,520 B. Calculation of Target Balance
11 Target WCF Balance (11) 7,156,838 40,548,944 46,366,205 40,559,076 34,346,800 29,062,000 C. Calculation of Remaining Cumulative Appropriation
12 Cumulative Appropriation Since FYE 2010 (12) 10,476,724 19,113,644 40,851,112 52,136,755 70,805,340 86,237,791 107,375,842 118,560,107 136,407,486 162,831,486 189,251,486 202,461,486 215,671,486 228,881,486 13 Cumulative Expenditures Since FYE 2010 (13) (1,778,695) (6,981,592) (25,534,711) (36,451,060) (42,209,626) (49,540,938) (55,786,891) (69,679,540) (84,040,949) (102,130,447) (118,853,679) (147,338,893) (180,902,686) (202,920,686) 14 Total Remaining Cumulative Appropriation (14) 28,595,715 36,696,854 51,588,951 48,880,567 52,366,537 60,701,040 70,397,808 55,122,593 34,768,800 25,960,800 15 Amount Encumbered as of June 30 (15) (1,927,466) - (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 16 Unencumbered Remaining Cumulative Appropriation (16) n/a n/a n/a 26,668,249 n/a n/a n/a n/a 59,701,040 69,397,808 54,122,593 32,768,800 23,960,800 17 D. Lesser of Target Balance and Unencumbered Remaining Cumulative Appropriation Lesser of Target Balance (line 11) and Unencumbered Remaining Appropriation (line 16) (17) 40,548,944 46,366,205 40,559,076 32,768,800 23,960,800 E. Calculation of Excess Fund Balance and Refund to Wholesale Customers Through Balancing Account 18 Is Unencumbered Balance (line 7) more than line 17? (18) Yes Yes No No No 19 Excess WCF Balance (applied as a negative entry on line 8) (19) 959,496 4,544,290 - - - F. Calculation of Deficiency Fund Balance and Charge to Wholesale Customers Through Balancing Account (This Section is Only Applicable in Any Year When Line 18 is No) 20 Is Unencumbered Balance (line 7) less than line 17? (20) Yes Yes Yes 21 Tentative Amount Before Application of $4 million cap (21) 8,710, 226 17,562,561 13,153,280 22 Is line 21 more than $4,000,000 maximum? (22) Yes Yes Yes 23 Balancing Account Charge (applied as a positive entry on line 8): 4,000, 000 4,000,000 4,000,000 Original 5 Year True-up Method FYEs 2010-2018 Amended Annual True-Up (FYE 2019 and Beyond) See Notes on Page 2 Page 1 of 2
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Notes:
(1) Beginning Total Balance (encumbered and unencumbered). Equal to the prior year ending total balance after balancing account transfers (line 9). (2) Wholesale Share of Revenue Funded Appropriations for Regional capital projects, adjusted for de-appropriations which have been factored into a wholesale revenue requirement, if applicable. FYE 2015 and forward are subject to compliance audit and 7.06 review.
Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided. (3) Wholesale Share of actual Regional capital expenditures funded from Revenue Funded Capital, determined based on proportionate water use in the year of expenditure. Figures from FYE 15 and forward are subject to 7.06 and compliance audit review.
Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided.
The figures in line 3 for FYE 18 and on are for illustrative purposes only. (4) Line 1 times the assumptions below for the SFPUC pool rate. FYE 2010 - 2014 figures are actual and tie to the first 5 year review.
Pool rate assumptions: 0.640% 0.670% 0.930% 1.240% 1.410% 1.600% 1.600% 1.930% 1.930% (5) Total encumbered and unencumbered balance of the Wholesale Capital Fund before Balancing Account adjustments: Line 1 + line 2 + line 3 + line 4. (6) Wholesale Share of the encumbrances for purchase orders or contracts in connection with revenue-funded Regional capital projects; calculated using the proportional annual use of the true-up year. Entered as a negative number.
Not applicable in years with no true-up (FYEs 2010-13 and 2015-18). FYE 2014 figure is actual. FYE 2019 and forward are plug numbers included for illustration. (7) Unencumbered Balance Before Balancing Account transfers: Line 5 + line 6. FYE 2014 figure is actual. Not applicable (n/a) in years with no true-up (FYEs 2010-13 and 2015-18). (8) Negative entries represent refunds to the Wholesale Customers through the Balancing Account and are calculated per Section E below, except for 2014 which is actual pursuant to the original 6.08E.
Positive entries represent charges to the Wholesale Customers through the Balancing Account and are calculated per Section F below. (9) Total Ending Balance After Balancing Account Transfers = Line 5 + line 8. (10) Unencumbered Ending Balance After Balancing Account Transfers = Line 7 + line 8. Must not exceed the amount on line 17, which is the lesser of the Target Balance (line 11) and the Unencumbered Remaining Cumulative Appropriation (line 16). (11) Starting in FYE 2019, the Target Balance is calculated by the formula below, where CY represent the Current Year (for which the transfer is being calculated), CY-1 is the prior year, CY-2 is 2 years prior, etc.:
[line 2: CY]*(4/5) + [line 2: CY-1]*(3/5) + [line 2: CY-2]*(2/5) +[line 2: CY-3]*(1/5); rounded to the nearest dollar. The FYE 2014 figure is the actual target balance under the original section 6.08E. (12) Cumulative Appropriations Since FYE 2010 = prior year line 12 + current year line 2. (13) Cumulative Expenditures Since FYE 2010 = prior year line 13 + current year line 3. Does not include encumbrances. (14) Total Remaining Cumulative Appropriation (encumbered and unencumbered) = line 12 + line 13. (15) Amount encumbered as of June 30 = line 6. Encumbrances are not cumulative. (16) Unencumbered Remaining Cumulative Appropriation = line 14 + line 15. (17) Lesser of Target Balance (line 11) and Unencumbered Remaining Cumulative Appropriation (line 16). Used in formulas in line 19 (Section E) and line 21 (Section F), as applicable. (18) If Yes, go to line 19 for calculation of the excess unencumbered balance. If No, go to line 20. (19) Calculation of Excess Balance: If line 18 = Yes, then line 7 minus line 17. The result appears as a negative amount on line 8. (20) If yes, then go to lines 21-23 for calculation of charge to Wholesale Customers. (21) Initial step in calculating charge: If line 20 = Yes, then line 17 minus line 7; go to line 22. (22) If the result on line 21 is greater than $4,000,000, then the charge to the Wholesale Customers is capped at $4,000,000. (23) Equal to the lesser of line 21 or $4,000,000. The result appears as a positive number on line 8.
See Notes on Page 2 Page 2 of 2
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT N
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
BALANCING ACCOUNT I RATE SETTING CALCULATION
REFERENCE SECTION 6.03.A.3.a
Step 1:
A. Balancing Account as of June 30, 2007
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year C. Wholesale Revenues for Fiscal Year
D. Wholesale Revenue Requirement for Fiscal Year
E. Settlement Credits or Other Adjustments
F. 1984 Agreement Balancing Account Credits
G. Balancing Account as of June 30, 2008
Step 2:
A. Balancing Account as of June 30, 2008
B. Interest on Balancing Account at Pooled Investment Rate for Fiscal Year C. Wholesale Revenues for Fiscal Year "À 'n
D. Wholesale Revenue Requirement for Fiscal Year /?- \\ '\\ \// .. ,\ .¡ \ E. Settlement Credits or Other Adjustments ,;:t ;/:",, ~~ t' \ F. 1984 Agreement Balancing Account Credits /~~~ l\\ U )\: v G. Balancing Account as of June 30, 2009 .::\ c.~.\ \ '\'~ ',_¿:/' . L,\'\~ ~;)-;...:) ¡ ,!\ '\ \\ \\ 'vStep 3: .,.,(-'i\') i 4:, " V.l///. \-~ \....l;j ;1 ~\ /;' A. Balancing Account as of June 30, 2009 / ;,.Y-,l (\?\, ~~j3 'Ç B. Interest on Balancing Account at Pooled Investment Ra1aAór,;lIs~t ye~\r\; C. Wholesale Revenues for ~iscal Year . f\n\;~-=)\J .1,;-- D. Wholesale Reve.nue Requirem~nt for Fiscal y,\~;~r \\ '\ ;1\,(2/;/ E. Settlement Credits or Other AdJustmentsç", ~ ,\ '\ k'c1 F. 1984 Agreement Balancing Account üt~1t~\ '\ \;;j-./
G. Balancing Account as of June 30, 201 ai \\ i\~)\::/
H. Net Change in Wholesale Revenue Co\\~~âgÉ!
i. Total Revenue Deficiency or Surplus '~'.
J. Projected Water Sales in Ccf
K. Deficiency or (Surplus) $/Ccf
L. Deficiency or (Surplus) Ccf as a Percentage of Revenues FY 2007-08
$12,882,000
$554,000
($113,932,000)
$119,224,000
$2,448,614
$0
$21,176,614
84,621,240
ATTACHMENT N-1
FY 2008-09 FY 2009-10
//\
.,.... (,J"
_ :)\/\ \\ í ." ,\.\
(~S?),il:\\l ìJ/;;.1 ~ 'Pi ~ '\ '\ -',.,,;v1 J ò' '\ ~. Jl A c\ 0"I,f '\ '!/iJ¡\.;''~ ','t.f \\ ~/:J
'1 " \/.,/1 \" ''',i ',/
\\l\\/\\;\ .II,.. \. "'b\i '176614
\ -\ \,' ~~1 I\ \\~/ $529 000, ;) ,
\) -: -$123,604,000
$120,562,000
$21,000
$0
$18,684,614
$0
$0
-$127,485,900
$140',994,733
$21,000
$1,997,220
$15,527,053
$4,488,233
$20,015,286
83,205,600 85,920,000
$0.23
15.7%
Note: Dollar amounts are for illustrative purposes only. The Parties have not agreed on the amount of the balancing account as of June 30, 2007, revenue requirement for FY 2007-08, settlement credits for FY 2007-08, and the amount of the balancing account as of June 30,2009.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
BALANCING ACCOUNT I RATE SETTING CALCULATION
METHOD OF CALCULATION
REFERENCE SECTION 6.03.A.3.a
ATTACHMENT N-1
N = The year for which rates are being set
N-1 = The current year
N-2 = The most recently completed year for which actual results are available Calculation Method:
Step 1 Determine the actual revenue differential for year N-2 A. Enter the beginning amount of the Balancing Account
B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amount of the Balancing Account Step 2
Step 3
Determine the projected revenue differential for year N-1 A. Enter the beginning amount of the Balancing Account; this is the same amount as G in Step 1 B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amòunt of the Balancing Account Determine the projected revenue differential for year N A. Enter the beginning amount of the Balancing Account; this is the same amount as G in Step 2 B. Calculate the interest earned at the Pooled Investment Account Rate for (A) C. Enter the actual Wholesale revenues billed
D. Enter the Wholesale Revenue Requirement
E. Enter settlement credits or adjustments, if any
F. Enter carry-over 1984 Agreement credits owed the City, if any G. Calculate the ending amount of the Balancing Account H. Enter the net change in the Wholesale Revenue Coverage, if applicable i. Calculate the total revenue deficiency or surplus (G) + (H) J. Enter the projected water sales to Wholesale Customers in Ccf K. Calculate the required increase in the commodity portion of the rate by dividing (I) by (J) L. Calculate the required increase in revenues by dividing (I) by (C)
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
REFERENCE ARTICLE 5
ATIACHMENT N-2
SCHEDULE 1
EXPENSE CATEGORY CONTRACT SCHEDULE
REFERENCE REFERENCE TOTAL DIRECTDIRECT RETAIL WHOLESALE REGIONAL
JOINT EXPENSE
ALLOCATION
FACTOR
WHOLESALE
SHARE
OPERATING AND MAINTENANCE EXPENSE:
SOURCE OF SUPPLY
PUMPING
TREATMENT
TRANSMISSION & DISTRIBUTION
CUSTOMER ACCOUNTS2
5.05 (A)
5.05 (B)
505 (C)
5.05 (D)
5.05 (E)
SCH8.1
SCH8.1
SCH8.1
SCH8.1
SCH8.1
953 $
i82 $
053 $
232 $
!13 $
/' \/:/"\~. , \'
$ p,!,g~:~t:d\ "ANNUAL USE'
- /:~ '\ ,4'8';8t, \Af'NUAL USE',- cr,. ,.$, \, *~5,Ò:5a 'ANNUAL USE' ,,,:'r"~,\\ 'i¡'1 !!23,is2.!l46\ ANNUAL USE'
i\;fÌl4\$,\i) :(/\;.)V 2%
\ ' \ \, \\v"\O\
15\1M)) k) si~79,572
._~~:.:
$
$
$
$
$
9,364,568
334,210
20,821.372
15,902,690
151,044
TOTALO&M
COMPOSITE % (WHOLESALE SHARE I TOTAL O&M) 5.06 (C)
46,573,883
42.07%
ADMINISTRATIVE AND GENERAL EXPENSES:
COWCAP
SERVICES OF SFPUC BUREAUS
OTHERA&G
COMPLIANCE AUDIT
5.06 (A)
5.06 (B)
5.06 (C)
5.06 (D)
$ 1,238,009 COMPOSITE O&M $ 520,857
$ 14,286.867 ANNUAL USE' $ 9.770,788
$ 8,962,586 COMPOSITE O&M $ 3.770,749
$ 200,000 50% $ 100,000
$ 24.687,462 $ 14.162,394TOTALA&G
PROPERTY TAXES 5.07 $ $ 1,417,293 ANNUAL USE' $ 969.287 CAPITAL. COST RECOVERY
PRE-2009 ASSETS
DEBT SERVICE ON NEW ASSETS .,.-,
REVENUE FUNDED ASSETS - APPROPRIATED TO WHOLESALE CAPITk.bfuAi,ci\ \~. " ì?~ '- -\ '--\~A\\ \ \"\ \ \.
'\ \\'~ '\ '\ ,/-'
\\\:\V~~\\:/.)
\;\"\;/
TOTAL CAPITAL COST RECOVERY
\ .-
.'b.OS ,
.S:04(Äl"'
. 8,04,(B1
WHOLESALE SHARE HETCH HETCHY WATER & POWER 5.04 SCH4
$ 24,051.326
$ 17,952.931
$ 8,381,400
$ 50,385.657
$ 28,903.512
$ 140,994,733
$ 4,488,233
WHOLESALE REVENUE REQUIREMENT
. WHOLESALE REVENUE COVERAGE'
'Proportional Annual Use (68.39%)
2Water Enterprise Share of Customer Accunts Expenses (62% of Total Customer Accunts Expenses) '25% of Wholesale Share of Debt Service
''1
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
WATER ENTERPRISE CAPITAL COST RECOVERY - ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.04.A
ATIACHMENT N-2
SCHEDULE 2
5,561,386 $ 56,181,932
1,276,338 $ 10,919,$';
4,285,048 $ 4§,21,1;1~;~
( " '\\ ~~'\ '\
- /\\$, 156,18'hS'S2 '\/ I"" \ \.~" '\,;;, \ -c' ~ \1019V~i3,t\:? 'A ~ \'.:,\ \ $\ '46.211j4 ir;". \ ',"\ ~ '.' '. \ \. ,ii//\(. ~ 1 ,~ \\ \, \. \, \ \ .._.:/INTEREST PAYMENT (NET) $ 23,3/5~3\,388J~ '()~\51?1.;ee \, \, \) RETAIL PROJECTS $ ,Jf~4P96~ $~ ,1~716!,93,8;d-'REGIONAL PROJECTS A \;~'s¡~~8~, ~~ \ ~~~t.Jl48 ':)~ '\ \ '\ \" __\\ \ '\ \/3.1
TOTAL PRINCIPAL AND INTEREST PAYM,StJT \ \ "\\3~\\1Â~~~ \¿i '5,561,386 RETAIL PROJECTS ~ \ " \ \ \ l \0~1WÍ? ~?~ 1,276,338
REGIONAL PROJECTS \ \ \ \ \, \:/~?l;~95'J6 4,285,048
\ \ \ \~;;~~ /~\ ~" \, \, v \\;//" 68.39% 68.39%
\' \ .'?
\:\1/" $ 15,022,387 $ 2,930,544
USE OF BOND PROCEEDS
RETAIL PROJECTS
REGIONAL PROJECTS
PRINCIPAL PAYMENT
RETAIL PROJECTS
REGIONAL PROJECTS
INTEREST PAYMENT (GROSS)
RETAIL PROJECTS.
REGIONAL PROJECTS
INTEREST PAYMENT (CAPITALIZED)
RETAIL PROJECTS
REGIONAL PROJECTS
PROPORTIONAL ANNUAL USE
WHOLESALE SHARE
2006 BOND
ISSUE SERIES
A
2009 BOND
ISSUE ALL
SERIES
XX BOND
ISSUE ALL
SERIES
xx.xX%
YV.YY%
(';,~)\ "\.\
7" (~Ç\ ",~l \/'_~ \\ " \ '- ,\ '? . \
(í~ '\ '\ \\ \ \ \,il. '?"- \c' , '\ \ \, , /"'.' ' ,
~ \\ \ \\'\- \~. ~~ \ \)-1 \\ 'i ~\' '\" ,,\../ ./
\\)\~ '\'" \.,), '1;:/
\ /)', 'J, ''i
"-¿/
zz.ZZ%
Note: Allocation of bond proceeds shown are for illustrative purposes only. Regional projects wil not include bond proceeds used to construct or acquire assets capitalized prior to 7/1109. Regional projects also wil not include in-city groundwater or in-city recycled water projects.
2-008 BOND
ISSUE ALL
SERIES
31.61%
68.39%
19.42%
80.58%
22.95%
77.05%
$
$
$
8,765,000
2,770,617
5,994,384
$ 23,353,388 $
$ 7,382,006 $
$ 15,971,382 $
68.39%
XX B-OND
ISSUE ALL
SERIES
XXBOND
ISSUE ALL
SERIES
"';.-:
. '" .
XX.XX%r\XV'
YY.YY~// \ '\ \\ 'i\ _ '-'\ ;1\
(~~\\ \)) \\~A
\ \- \ \\ \\ ~~ (r-'~.
'\,\\ )\S\;5? -
v'~'/
zz.ZZ% zz.ZZ%
XXBOND
ISSUE ALL
~ SERIES
TOTAL ALL
OUTSTANDING
BONDS
xx.xx%_
YY,YY%
$ 8,765,000
$ 2,770,617
$ 5,994,384
$ 85,096,706
$ 19,568,875
$ 65,527,831
$ 37,679.774
$ 11,428,961
$ 26,250.813
zz.ZZ%
$ 17,952,931
(TO SCHEDULE 1)
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
WATER ENTERPRISE CAPITAL COST RECOVERY. REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009.10
REFERENCE SECTION 5.04.B
ATIACHMENT N-2
SCHEDULE 3
ALLOCATION
FACTOR
TOTAL ALL YEAS
APPROPRIATION ACTUAL
ALL YEARS EXPENDITURES
PROJECT
APPROPRIATION CLASSIFICATION
WHOLESALE
SHARE
FY 2009-10 ACTUAL ENCUMBERED, NOT APPROPRIATED,
EXPENDITURES EXPENDED UNENCUMBEREDBALACE/,~
CUH980 Treasure Island Improvement Project
CUW253 Facilities Security
CUW260 Local Water R&R
CUW686 Automated Meter Reading System
Total Local
CUW202 Replace Prestressed Concrete Cylr Pipe
CUW261 Regional Water R&R - Storage
CUW262 Regional Water R&R -Treatment Facilities
CUW263 Regional Water R&R ConveyancefTransmission
CUW264 Regional Watersheds/ROW Management
FUW100 Regional Facilities Maintenance
Total Regional
TOTAL ALL PROJECTS
/Ý~r' ,/j0.0% $ $ - $ _ ç :./):~\ \0.0% $ $ - $ _ '(\ '\ -Ç,~ \ \0.0% $ $ - $,;:';"-'. \1\\ '. .~$ \, \$ $ , '\ /' , , ,.",\, \~ \ \0.0% N''", \"" " '.\ 0\. _.\ ',, ,j$ $ '( $1\',~;J!\''\ \"~.;:1 ~.-.;~., \\ "" 'l. :. -..~.1: ~~"'\ \ \',\ \'\ "~ Ç..r\-)
68.7% $ $ ...\ '/\\.\ \'.'l~ '\')\\~¡.t - $
687% $ . $' \ '. ",¡ - \ $" ) .;' . $
68:7% $ 68,7;106' $'\ \, 6£,'7:'000 ''$;'/ 235,000 $
68.7% $ .., 4,89g,Dûa\ ~\ \\ '4SQ9,r).O $ 1 ,395,000 $
68.7% $,,\. \\ 343'\5~0\\ $:,. \', ,9A3,500 $ 115,000 $
68. 7~;"~\ '\'. ~,541..OÐ " .~ ""... 2,541,900 $ 850,000 $ . v-\ ;í (",$\.i. ..'\8\381\00. i So 8,381,400 $ 2,595,000 $ ~..7~)h \\ '\ ~\ \\ '-~~ \. ,.~..,'
;.\ \/( \ \ \ \$,1 '-\ \, \8.;i)1,400 $
~;;'.--\ '\ :,\'''\''_ \ '\ \\ V.J J \)/\\~\ \ '.\ ~\.. \ \ \ ,," i.'~;'::\S,\~;i~;~,jr.~\J v.
\ "\ \. ". \.\.~t;
\ \\ \;.'
3,800,000
500,000
22,347,520
36,001,000
62,648,520
1,000,000
7,000.000
500,000
3,700.000
12,200.000
74,848,520
RETAIL
RETAIL
RETAIL
RETAIL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
REGIONAL
$ $
$ $
$ $
$ $
$ - $
$ $
$ $
235,000 $ $ 452,000
1,395,000 $ 25,000 $ 3,389,000
115,000 $ 50,000 $ 178,500
850,000 $ 123,000 $ 1,568,900
2.595,000 $ 198,000 $ 5,588,400
8,381,400 $ 2,595,000 $ 2,595,000 $ 198,000 $ 5,588,400 (TO SCHEDULE 1) (TO SCHEDULE 1) (TO SCHEDULE 1)
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT N.2
SCHEDULE 4
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF WHOLESALE SHARE OF HETCH HETCHY WATER & POWER FISCAL YEAR 2009-10
REFERENCE ARTICLE 5
JOINT
ALLOCATION
PERCENTAGE
WATER-
RELATED
TOTAL
WHOLESALE WHOLESALE
ALLOCATiON FACTOR SHARE
POWER
SPECIFIC
WATER
SPECIFIC
CONTRACT SCHEDULE
REFERENCE REFERENCE JOINTTOTALEXPENSE CATEGORY
,..-:..:":\
../,,:-;:, ::../
45% .. ,_ $.:Ji\0~~~,038
\~)~~:t:
" '45~,\) $
\4500 $
45% $45% $
OPERATION AND MAINTENANCE
OPERATION
MAINTENANCE
TOTAL OPERATION AND MAINTENANCE
ADUSTO PR~:TIONAL ANNUAL $
ADUSTED PROPORTIONAL ANNUAL $
uSE _
$
7,484,165
4,831,890
12,316,055
31,853,965 $
5,048,039 ~
36,902,004 $
9,557,861 $
3,238,622 ~
12,796,483 $
3,200,394
8,581,951
11,782,345
44,612,220 $
16,868,612 ~
61,480,832 $
5.0881
5.0881
SCH 8.2
SCH 8.2
$
ADUSTD PR~~TIONA ANNUAL $
ADSTED PR~~TIONAL ANNUAL $
ADSTD PR~~TIONAL A.NNUAL $
ADSTD PROPORTIONAl ANNUAl $
USE _
$
ADMINISTRATIVE AND GENERAL
COWCAP
SERVICES OF SFPUC 8UREAUS
OTHER A&G
CUSTOMER ACCOUNTS
TOTAL ADMINISTRATIVE AND GENERAL
348,968
1.959,603
3,280,434
$ - $ :".1,139,579
5,375,656 $ 2,879,65.1" '$"..\ \'" ',\ ',\ '." .14,913,071 $ c(?6,~(~\~\ ,)a'6,,34Q' 347,403 L6\""'. ":I",. ':$\\"'. ',"..'.
20,636, 9P:(¡'~2~~~,72\~~ ,\ \t,T71 ,919'
. ~:/~~~\\\'\ \-.~\t,\ \ ",-_."
452.000~ f,\.?\\ \\;;s\j i\\) v - $ 456,305
\~~~~~\S,j
512,811
2,879,651
4,820,623
5.0882
5.0882
5.0882
5.0882
SCH 8.2
SCH7
SCH 8.2
SCH 8.2
1,139,579
8,255,307
25,581,481
347,403
5,589,004$ 8,213,08535,323.770
ADSTD PROPORTIONAL ANNUA!
U" 139,73245% $ 205,3375.0883 SCH 8.2PROPERTY TAXES
CAPITAlCOST RECOVERY
PRE-2009 ASSETS
DE8T SERVICE ON NEW ASSETS
REVENUE FUNDED ASSETS-APPROPRIATIONS TO WHOLESALE CAPITAL FUND
TOTAL CAPITAL COST RECOVERY
3,118,033ATT K-4
SCH 5
..§,CH~'\
\~~~~~\.\.;~,)
\-:.Y'~-;/
5.0981
5.0982
5.0983 7,740,688
10,858,721
$ 28,903,512
(TO SCHEDULE 1)
WHOLESALE SHARE OF HETCH HETCHY WATER & POWER
WHOLESALE REVENUE COVERAGE'
'Adjusted Proportonal Annual Use (68.39% X 99:50% = 68.05%) 225% of Wholesale Share of Debt Service
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
HETCH HETCHY CAPITAL COST RECOVERY - ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.09.B.1
ATTACHMENT N-2
SCHEDULE 5
XX BOND XX BoND XX BOND XX BOND XX BOND )(OND-XX BOND TOTAL ALL
ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL ISSUE ALL OUTSTANDIN
SERIES SERIES SERIES SERIES SERIES SERIES SERIES G BONDS ,,/\
USE OF BOND PROCEEDS
POWER PROJECTS
WATER PROJECTS
JOINT PROJECTS
PRINCIPAL PAYMENT
POWER SHARE
WATER SHARE
JOINT SHARE
(-s~~;:~\i. ' \ ,\ ',\ ~ .~-, 't/\-'?'
\\\ \\\" \\v');.0'\'~)I\"~ -
\. ,i .;,)...:.;/
xx.XX% XX.X?%~./j,/ .)Ó( XX%_YV.YV% yv.'f.% \ f / Y'( YV% ZZ.ZZ% d'~z:d.z~, \ . .' Z; ZZ%
r \0.\\1\\\' .\'."'/"
" '% ~ I " '\, \ \ \ ~.r ~.,\"V.._\ 'i," -" r'.. \'~.;.' "\\./A \';/ \\ \t\ ~\ .1\ \/~
. n \\./y"Y) Il' .) ~ ." ') ';. -'\~.l
XX.XX%
YV.YV%
ZZ.ZZ%
XX.XX%
YV.YV%
ZZ.ZZ%
XX.XX%
YV.YV%
ZZ.ZZ%
XX.xx%
YV.YV%
ll.ll%
ADJUSTED PROPORTIONAL ANNUAL USE
WHOLESALE SHARE
(~~~\
/'. \ '-\\
/" (:-:-j\\\f:~~~:;~\\,/\ ~" \\\\\1\ \.,\ \ v/Ä-~.\-\~' t.-;.\ ','l\:...¡-:r '\ \1 ~\ \ ~ \ -\'~ '\ //1 /" '0.-\ \\ ,\\ \\ '. ," ..""".:..:' \\:; i' ~\ l\ :\.\ "\ \'Í ,;.'\ i¿) Ji \\. '.' \" 1,, '-, .\. l '" \\ ~ ;; :r\ : (\ Y/\"\ \ -f" '\ \\ 'f~'-¿.~
. . \ -" -\ '--':, \ \~ '\ \ V;:J
/",\ \. \ '\ \, '-". \, \ \ \y~
f ~~ \,., \ ~-r '--.'') ,\ \ Ç¡\ -v 0.", '" \)8\05" /\\,\ ,,68.05 Yo \\\~~~:_;~~) \;;J .
'Water Related = 100% of Water Share + 45% of Joint Share\ \ \ ./ )./ \:~\/'''-
INTEREST PAYMENT (NET)
POWER SHARE
WATER SHARE
JOINT SHARE
TOTAL PRINCIPAL AND INTEREST PAYMENT
POWER SHARE
WATER SHARE
JOINT SHARE
WATER RELATED PRINCIPAL AND INTEREST PAYMENY'
68.05% 68.05% 68.05% 68.05% 68.05%
(TO SCHEDULE 4)
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
HETCH HETCHY CAPITAL COST RECOVERY - REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009.10
REFERENCE SECTION 5.04,8
ATTACHMENT N.2
SCHEDULE 6
APP~~~~~;;ION CLASSIFICATION W~~~~E'¡~~D WAT~~rTED
ALLOCATION
FACTOR
WHOLESALE
SHARE
TOTAL ALL YEARS
APPROPRIATION ACTUAL
ALL YEAS EXPENDITURES
FY2009.10ACTUAL ENCUMBERED NOT APPROPRIATED.
EXPENDITURES EXPENDED UNENCUMBEREDBALNCE
CUH931
CUH977
HH Microwave Replacement
HH Water R&R - Facilities Maintenance
Total Joint
CUH947
CUH971
CUH976
CUH979
CUH983
CUH986
SEA. Go Solar Incentive Project
Alternative Transmission Studies
HH Water R&R - Power Infrastructure
Hunters Point Municipal Power
Civic Center Sustainability District
General Fund Dept - Energy Effciency
Renewable/Generation
Treasure Island Improvement Project
Enterprise Fund Dept - Energy Effciency
Total Power
CUH975 HH Water R&R - Water Infrastructure
Toulumne River Watershed Protection
Total Water
TOTAL ALL WATER RELATED PROJECTS
4.000.000 JOINT
3,500,000 JOINT
7,500,000
4,000,000
1,000,000
16,700,000
1,090,000
7,365,158
3,501,307
2,700,000
325,722
36,682,187
6,000,000 WATER
2,000,000 WATER
8,000,000
96,364,374
AOJUSTEDPROPQRTlON ./.:~~(~' -..,-1,800,000 ~'u"- u" $ 1,224,900 $ r Å,~4,w(r\ $ 1,575,000 AOUS~DN~~l~TlON $ 1,071.788 $,"" '~.1.)i7,.)7-éa 'li 3,375,000 $ 2,296,6ßS \;'$:",\i2~Se:eaá $. \
AlU~lI:.UI'UIl.IlUNA ,f''' '\\ \,) .!\ ,\, -"''. \,'0% $ ANl1AlliSE AUU~'I:U..OIUtI'UNANNUA USE
AUU~II:Ut-U+OHlrlJ
0% $ ANUAl liSE ,:..
0% .. AUu,¡i,~.~~~W./'~
0%
0%
0%
0%
O%'
c.', :ri:~t\v,.~,,\ '\~~\\
.(\ \ \\ i....:C~on~ ~ \ ...;~/6,000.000
..r,., \ \ \ \. ."'.-.... 1-Do.o/¿~ $_, 2,000.000
\, '\ \. \\ '\('G1)) \;. $ 8,000.000
. \ \., ,.\. \-) .~J '..-.:/
\.;,~\:;\'";:. $ 11,375.000
)'\~'
POWER
POWER
POWER
POWER
POWER
POWER
POWER
POWER
POWER
45%
45%
0%
\')
PU:iltil"UlIIUN
ANUAl use
AOSTEOPRoPTION
ANNUA USE
4,083,000
',361,000
5,444,000
7,740,688
4,083,000
, ,361.000
5,444,000
7,740,688
1.224,900
1,071,788
2,296.688
4,083,000
1,361,000
5,44,000
1,224,900
1,071,788
2,296,688
4,083,000
1,361,000
5,44,000
7,740,688 $ 7,740,688 $
(TO SCHEDULE 4) (TO SCHEDULE 4)
$
(TO SCHEDULE 4)
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
SERVICES OF SFPUC BUREAUS - ALLOCATION TO ENTERPRISES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B
ATIACHMENT N-2
SCHEDULE 7
ADJUSTED HETCH HETCHYEXPENDITURE ADJUSTMENTS EXPENDITURE POWER S S
HETCH HETCHY
WATER WATER RETAIL WATER REGIONAL WASTEWATER
/;;..'"\
TOTAL
ALLOCATION FACTORS (SCHEDULE N-7.1)
PUC01 General Manager $
PUC1101 BizServ-Administration $
PUC1102 Finance $
PUC1103 ITS1 $
PUC1106 Human Resources $
PUC1108 Customer Services $
PUC12 External Affairs $
TOTAL $
//0\/~" r~..16.94r. r(~~"" 29.59%
\(~\ '\ "~~\ \ \
$ 453.820 $1;2à)88~'\$.. '\ ë' ~~!51,548, . ,. ,\",' \ '.~ .,,' $ 243,456 $-.\\6:Yti31 \)1\\" 1,207.864
$ 525,902.~ (\ 1,;19S,f;0~ :$/v\\P 2,609,166
$ 966,959 . 5 \ \2\t4~~~ ;$ 4,797,391
$ 4~7,9$8 $ ", \, '~,3Qoìt'34't'$ 2,272,074$ r/" (\ -', $, \ .~...) \...- $ 432,263 $.. t',. " \?'Q1\556 ,$'. \/657,637 $
.!/':":~'\ \ '\.~\ \" \ .-\. \ \34,752.000 $ (12,731,000) $ 48.282,521 $ 5,375,6.56 ¡'$ c,;'" . \ '.\ ~87,g,65i ":V 8,178,424 $ 14,286,867 (TO SCHE9_ULt't)'\ttO¥~l:~U.U¡\È.M/ (TO SCHEDULE 1) (TO SCHEDULE 1) :r"'\~\\ \J'\ '\.\ ...'
\ il .r \,\ \. .. \.//\ ( ). j !,( '!\ "\"\ ''\.."\ ~
\\ \'\ '\ \ -,\1 \"- \1
,\ ,-.~; '\ \'~ "~ ;\ ::\ \ ~ 'Y;'1
".\ ' " \ \, \ \:J !j ",)-
, ,slf~~~\(~0~~~\~\ \~~j .c\ \\.'.".M~'I ,-;)"\ '\ \ \\ ?,\( '0., ./' \' \\ J\ "j '\ ;/ (-\ \ \ '-"\ '~"l 0 J '",::.:/
\ \ \ \ \ \;:;\\..-~;..)
\ \ \ \..;:./\\./ ~)
\ \."\ ))~;.r
\, \\.;;//
\;-;..
7,609,114 $
4,081,981 $
8,817,687 $
18,048,158 $
7,678,483 $
12,262,428 $
3,882,455 $
$
$
$
(1,835,357) $
$
$
$
(12,262,428)
'Adjustment for Transfer of SCADA Expenditures to T&D Joint ($1,730,000)
11.13%
7,609,114 $
4,081,981 $
8,817,687 $
16,212,801 $
7,678,483 $
$
$
847,180
454,478
981,739
1,805,093
854,903
3,882,455
5.96%
1,148,824
36.37%
$ 2,767,682 $ 7,609,114
$ 1,484,749 $ 4,081,981
$ 3,207,280 $ 8,817,687
$ 5,897,123 $ 16,212,801
$ 2,792,914 $ 7,678,483
$ $
$ 1,412,175 $ 3,882,455
$ 17,561,923 $ 48,282,521
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
SERVICES OF SFPUC BUREAUS - ANNUAL SALARIES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B
ATIACHMENT N-2
SCHEDULE 7.1
DEPARTMENT/DIVISION ALLOCATION GROUP
FACTOR CODE SALARIES PERCENTAGE
HETCH HETCHY
POWER
WATER
JOINT
WATER SHARE
POWER SHARE
1 $ 6,677,939
2 $ 1,775,910
$ 9,428,450
45% 2 $ 4.242,803
55% 1 $ 5.185,648
WATER
ADMINISTRATION (WTR01)
RETAIL SHARE
REGIONAL SHARE
HETCH HETCHY WATER SHARE
33.4%
33.3%
33.3%
$
3 $
4 $
2 $
1,009.246
336,415 .,'
336,41h\\
33"'116, \'\!
\¿\\'\ \... ~,\
3 1"~:7;3~é,~~ \ \
./c. :\,~~\4 '~\\1~~~~~i;)\)
,'\ if ,~.:\" ,,\ ~ $\ ':18J184.689
.' ;;:;~.~\\\ \:\ '\ \\ ~ \ ..~~~'NATURAL RESOURCES (WTR06) , ...... \('\(';/\ \ \\\'J :\ \~ '4:",$ 4,682.073 WATE~ RESOURCE PLANNING,;;;,'r~), n. \ \ \ \\ '.j' $
WATER CONSERVATION ..,(')\ \;: :i '\ Ù \, \ \ \;/ 3 $
RETAIL WATER RESOURf;i: F-'nNNIl\'G¡. '\\..."\.;.'(/ 3 $ REGIONAL SHARE (Ni.r\S\;1-Ã~I~~l,'\ \'i\ .:~;I ~ 4 $
'- ' . " ,,\" -'" " ~,'
CDD(WTR03)
WATER QUALITY (WTR04)
WATER SUPPLY & TREATMENT (WTR05)
1,419,760
355,703
1,064,057
WASTEWATER \ ) 5 $ 38,757,578
SALARIES BY GROUP COOE ,
HETCH HE'Tel\jy. ,.f'oÌNE'" . 1 $ 11,863.587
HETCH HEl-y),i'Y'-IkÀTÈR 2 $ 6,355,129
\\\/v
$WATER - RETAIL 3 18,049,040
WATER- REGIONAL 4 $ 31,529,823
WASTEWATER 5 $ 38,757,578
TOTAL SALARIES $ 106,555,156
6.27%
1.67%
3.98%.;,,~")
4.87% V ,.;10', ,
(~~~\:~',ìO'3';'t\ v:;v
\, \:) .,t ,~,) -'"
)-&~1'9%
6.83%
17.05%
4.39%
0.33%
1.00%
36.37%
11.13% (TO SCHEDULE 7)
5.96% (TO SCHEDULE 7)
16.94% (TO SCHEDULE 7)
29.59% (TO SCHEDULE 7)
36.37% (TO SCHEDULE 7)
100.00%
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
WATER ENTERPRISE SUMMARY OF OPERATING EXPENSES
ATIACHMENT N-2
SCHEDULE 8.1
- $ 23,252,946 $ .J)~\A1'6';;32
- $ - L2:~"- -
- $ . 23,252,9~6l$\'\L\~11h\~
- $ 13:.Rer."8.~~\ \.~ \~t¡~43,g,~~
1~,i,t-\t~ \~'~~'~~~~g43,9~~
/\ .,\ i: ' 'Ii \ '\ \;)l:)
3,854,000 $ ,'; (', \',,- ,,' ~ ag-S f\~Y. $" 4342682\ ~ '\ ;/. i i$1/-" '\ ,$ "\ \. '.;:: - $ 3,854,099 $( fi~\\~\ '; "~$\ \) 488,682 $'r \. \'\ l~ ,.\ .'"\" ,\ \ \\ \\Ì\ \\ \ ,j-$ (', , \ $'\ , \, \ \ \\ )\.\'/$ 30445053("-", \ \ \~ \ '\ \ ) \ \', - $ ,-' '. "","' \$ , / $--\-\..\L.'-tr\_\~--i -"/'$ \\ \\ \ \, \\ \~. $ ,-,j - $ ..\; ",)~. \ \.' ,,\ \ \ '\ ~\
,~- .\ \~/~ ~l. \ '\ \. \ ,:) ':\ \.\ '0)Customer Accounts ,//",: \ ",~ \'S \, \ ~;'4Ó'1/j 69' $ Adjustments to Customer AgÇ0U~~tSt)¡ \ ': \~ \l~ \) ,_:/ - $ Adjusted Customer ACGéÙ!:i\s" ~) \ ,"", ¡~ ~, "\;r-7,401, 169 $ I \v , \ \ ' '\ /\ "d~4 r\\ Q::/ 1" '" \'\ \\ \1 '"
Total Adjusted opar~tli;91\EXPè.rse,\ ,\" ,,,:i;; $
'f\ ~" \"\" - " "" 'V\' 1I'~,'\j ~"\\\\\
GeneraJ\\~~drr!~istrat'ive ~\pén);e \?
COt(It'AI"? \ '\ \'\D' ,-.:/" ~ \ \ \ \ ")" ,
Servi.h~\ò~ S~'ltJC\l3ureaus
\ \'\ \~../\\//~J)
Other èlJ~'erai-'&Administrative
Adjustm'aMs to General & Administrative
Adjusted General & Administrative
Operating Expenses
Transmission & Distributions
Adjustments to Transmission & Distribution
Adjusted Transmission & Distribution
Source of Supply
Adjustments to Source of Supply
Adjusted Source of Supply
Pumping
Adjustments to Pumping
Adjusted Pumping
Treatment
Adjustments to Treatment
Adjusted Treatment
Compliance Audit
Total General & Administrative
Propert Taxes
Total
Source: FAMIS/EIS
Note: All adjustments to be separately identified above Retail Regional TotalWholesale
$
$
$
30,163,286 $
- $
30,163,286 $
$
$
$
1,251,062 $
- $
1,251,062 $
$
$
$ 4,342,682
$
- $
30,445,053 $
30,445,053
30,445,053
151,044 $
- $
151,044 $
- $
- $
- $
7,552,213
7,552,213
42,669,517 $ 151,044 $ 67,879,572 $ 110,700,133
$
$
$
8,178,424 $
$
- $
1,238,009 $
14,286,867 $
1,238,009
22,465,291
$
$
$
4,009,891 $
- $
4,009,891 $
- $
- $
- $
8,962,586 $
- $
8,962,586 $
12,972,477
12,972,477
$
$
$
$
100,000 $ 100,000 $ - $ 200,000
12,288,315 $ 100,000 $ 24,487,462 $ 36,875,777
- $ - $ 1,417,293 $ 1,417,293
54,957,832 $ 251,044$ 93,784,327 $ 148,993,203
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
WHOLESALE REVENUE REQUIREMENT SCHEDULES
CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
HETCHY HETCHY WATER & POWER SUMMARY OF OPERATING EXPENSES Operating Expenses
Purchased Power & Wheeling
Adjustments to Purchased Power & Wheeling
Adjusted Purchased Power & Wheeling
Operations
Hydraulic Generation
Transmission & Distribution
Water Quality Expense
Adjustments to Operations
Adjusted Operations
Maintenance
Hydraulic Generation
Transmission & Distribution
Water Quality Expense
Adjustments to Maintenance
Adjusted Maintenance
Totat General & Administrative
Propert Taxes
Total
Source: FAMIS/EIS
Note: All adjustments to be separately identified above Power Water . Joint
$
$
$ 28,953.676
28,953,676
$
$
$
$
$
2.900,291 $
$
- $
- $
2,900,291 $
28,95i6î6
\~;;J;"'\e
A ,,¡/'\ \ \;.~ \ \- $ 3,200,.~~-'\ ~\ ',~ \ ~.1('Öu,t'S5, ~ $ .., \ /\ \$,\ .\;, \ '\ \ \;~')9,557,862 $ (' \ \ ';),$.)/' '9JS57,862 - \t;~~~~\~t~rr\y/ -9,557,.e6,f ,$\( ,\ 3.~O\')í3~, \~ 15.658,547 . (-ù '" \., \. \ v if "i', ((\" ~\\ "~\ \';:Y
$ 1,840.096 $ r"" 3a\~\r\ \-')8,581.952 $
$ 3,359) 8t\ $ \\ \( \\.,l::. - $
$ -;' \ \$ \ \ ,; /$ - $$ ,. :ßt" , \\ \~. \ ',¿; ) - $ - $~, ,7' . \ -'ç.,..:S/~:\. \.~,o ' $\ 3;,,38,622 $ 8,581,952 $~;" 't/. ,/' \. \'~\ \;) Total Adjusted Operating Expe~:~I\~~:,;'\\ \~:~\\\~~:'?:~2P¡( $ 12,796,484 $ General & Administrative ExnehS~;'\ \) ) \ "" \ ~\'
COWCAP " '. . . " /11 'i. ,.
Services of SFPUC,Bùr~\ä.ui;~ \\) $
".\ \ \\\ "t,'" \ v'Customer_~cc~l!rts \ \ \ \ 'í 'J,¡
Adjuslrt 0'f~stoiiap ;~c'chts
Adjuste o,,~r:~ibo.uHts
:..~~"
Other ~.&;:Administrative
Adjustme to General & Administrative
Adjusted General & Administrative
$
5.375.656 $
$
$
$
347,403 $
- $
347,403 $
$
$
$
14.913,071 $
- $
14,913.071 $
$ 20,636,130 $
$
$ 57,538,136 $
$
2,879.651 $
- $
- $
- $
36.070 $
- $
36.070 $
2,915,721 $
- $ - $
15,712,205 $
11,782,346 $
1,139,579 $
- $
10.632.340 $
- $
10,632,340 $
11,771,919 $
452,000 $
24,006,265 $
Total
$
$
$
28,953,676
13.660,670
3,359,385
(151,42)
16.868,613
61,480.836
1.139.579
8,255,307
- $
- $
- $
347,403
347,403
25,581,481
25,581,481
35,323,770
452,000
97.256,606
ATTACHMENT N-2
SCHEDULE 8.2
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document. '?z
I-Z
W
:¡:i
~
mw
~
w..c(m
w..o:i
3:
ozc(
~zw
:¡
W
0:
5aw0:
w::zw
¡¡
0:
w..c(m
w..o:i
3:. ..m .w c(.. .c( am ui
O:ww..
I- U
c( -
3: li
o c(
~ iiu uw z
""w00:O:w
Q. U.
U. w00:wI-.. U
:: c(
00:wI-:i zu 0m u
':",' I~/~ '
\~,~\'~'~
'0~\\\~..,...,,,~_:;. '
'l', ,/-~,X\.
~ IÐ IÐ W IÐ~~='~ ,.,..Aß0~,.,lß Ei fØ~.~r. ",-:..._;-' ,.....\" i I I I i 1\~;;:-~:-;1;~ Ii'
.~.'~..~.'.Ç.~~.f~\
\\"",,'
iÐ El iÐ iÐ iÐ iÐ El ih li fÐ ~r. tl
i ~;;~'~:'~'~'~".'?,;? i,.....~¿' I~ .~:~\
\ .,.:)
)\fr;:~
~~~~i'~?~3"r~~ ~
rõ ~ ~ g ~ \~~;~;:~~"./ ~ M 8¡ i;co_ 1"_ "'_ 0_ M_ N. ¿t..:~ v_ co_o 0 0 a C\ (J ,.._~.~.. ~ ~ r" Ll ~ t:_ r:_ ~ ~_ æç;~,~,;~¿'it.~~~_~_
en (t ~ 'S~"-;;~;~~I~)ß
fØ iÐ ll fß ff IÐ r~,.;kT~;æ: .~~~ ó9
~~:~~\~ \~::~~,~,r;-,\
\\;~/~, (,'
\~~~
1\ \\~, \\ .,_..c:':":::~
\'''';;'è.oil .1"'\ ';1
l d:.' \),()'!\;f~~~~~t~
,..."' '). ,\
0~~~~_::~;~f\~\_.,'- ':) \\
~:-:':~;::$.
..+Z
ElElIÐElfß fh
'"+Z
0:
Li
)- N
-' +
c( Zu
m
u:
'+
z
iÐ tl Eß Eß tl ~
COONe.. ..CD T" f' en v !X
l( N (' CD a !X
oq- -q- ~ c,r r-- C'(0 C" N a U' ..Z C" (l 00 m ,. '"
m- 0- i. inN ~ ..
IÐWtflÐER~
mwmzw0-
XW
m ww um zz c(w Z0. Z W(i 0 I-W ¡: ~~ ¡¡::c( iimClz I-I-Z ~~ ¡S~ ~~~ ~§ 0
ClUl Oo: ~
.~ ~ ~ ~ ff ~z~~::~~ 0
Qo: o.!;z I- -'1-::::uJo:Ul ~
~ O:: 0: ii:: 0
wmo.i-i-U I-0.o
El iÐ Eß Eß fl
mwm
z
w
0.XW
Ul -'~ ~Z WW Z Z0. 0 WX ëi Clw m 0;J ~ zii:: o:wowz u ;:w m I-Cl w I-o:o ¡: 0 ii~ :J ~ ~ .. ¡: Z~ ::Cl~ ~
¡:O-~~~ Cl
~ê3ã:o::J :3~s:~~~ ~ZOlLl-O 1-0~UUlOu
Cl
o:
~ ElliW fl
~ Ei Eß Ul El
lßEßll (f
mw
g
~
W
0. o0:0.
m ~
ti w
m -' 6
~~ u
s: ii ~~ wo: t:
w z U w;:mZO 00i-OW uUWw§1-'wmu:: ~
~~5lL iim CJ 0: W ~00 W:: ~u¡;~~ o:i--'
-'wee;:~ 0: W W 0
ii 0. Cl 0: I-
ê3
~
~
~
~
N
u;
C'o
CJ
in
N
0. ~:i:i
w0:o::i
Ul
w-'
~w-'o:i
s:
J
J
J
J
~
El ll tl El ER El Eß fl
tltlEßtltiEßEß Eß
ti fl tl El El lß Eß fF
El W ll ll Eß El ó9 lß
S i 0000o a C\ (I0) aNN
It- or- r- a:ai C\mco.. CJ..r-- T'-"'N~
fh fl tl Eß ER Eß Eß lß
I-ZW
::
W
Q:
::aw0:
w::Zw
ru0:
W-'
~
W-'o:i
s:
Ul Ul w
!z c ~w Cl W:: w m
w ~5~
!; :: I- W
o ii a~~",i-Clmo:oiiwZ~wo:uwz::cClwU;::: 0 m o::i o: 0
~8(i~bClUOo:i-Uo~~mClo:wZ~5o: ~ m ~ o: o:.O:I-Uw m..wZZ::mco:m::~~¡ßfieeco o:;:Uo:l-ee8ee~(iu~~o:zwwl-::wCl°-,-,zw-,zi-o:o:wwo:i3¡ß¡ß¡ß~ff¡ßZo:-,-,-'o:-,~w00I=..O ;¡~~~~~~
r- 'r!X ..
N~ i.
'" ~
oc:N
UlW
Cl
0:o::iu
w
Ul
::
mmwu
(i
oz
o:
mw::
zw;:w0:
u.o
I-
ow0:
U
0:
I- 0o~WzO:wU_ti~o u.)- w
u Cl
ZWW -'-o:u mu: ~Woo :i
~ s:
o: ~-
m zw w
-' U00::i w
s: 0.
000
000
000
000
0'" '"ON'"o . ..0 ~o
NCJ
It
!X
LL
u
~~
U. I-
U Ul
S2 0~u
I- COZ~w::u. 0: ~UuWSo:!;
Ul 0 iiw)- w
-' U -'o: zo:Ul w Ul
0:- WW U-'
I- u: 0
o:w:i
s: Cl s:
Cl w Cl
w -' WI- o: I-U Ul UWW w
e3 Ô e3
o::i ii
0. s: 0.
000000'" N '"O-f'-..-N N..'" '" N.. Ñ i-.. ..~ ~
~~~
m mWw,:: ::Zz
Ww;: ;:w w
0: 0:
w w mCl Cl w
0: o:::
o: o:Z:i:iw
u u ru
w wO:
~::w;: :: -'
0: -' o:
W 0 Ul
m ;: ~000w W:i
t; t; s:
w w-'
.... o:001-0:0:00. 0. I-
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT O
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT 0
STATEMENT OF WHOLESALE REVENUE REQUIREMENTI CHANGES IN BALANCING ACCOUNT YEAR ENDED JUNE 30
(Section 7.02.B)
FY 2008-09
Allocation to
Wholesale
Customers
FY 2009-10
Allocation to
Wholesale
Customers Difference
Wholesale Revenue Requirement Calculation:
Operating and maintenance (O&M) expense:
San Francisco Water Enterprise:
Source of supply
Pumping
Purification
Transmission and distribution
Customer Accounts
Total SFWE operating and maintenance
$ 9,133,025 $ 9,364,568 $ 231,543
$ 325,946 $ 334,210 $ 8,264
$ 20,437,460 $ 20,821,372 $ 383,912
$ 9,350,279 $ 15,902,690 $ 6,552,411
$ 224,255 $ 151,044 $ (73,211)
$ 39,470,965 $ 46,573,884 $ 7,102,919
Hetch Hetchy Water and Power (HHWP):
Operating expenses
Maintenance expenses
Total HHWP operating and maintenance
\ ....
7,484,165 $;(-2;$75,621)
4,831 ,890/'d.;t\,~05,650
12,316,0?'t\ \(:~ (~\,~69,971)
/;::',, '¡\ 1, \ \\ ,":":) \. "I,/;/ "\l ~!:- \ \\ '~ \,. ;:;/~~\\ \(J )' \\ \\) ,,\~\) '~~
/l\ \\ ((~ "~ ': l. i\. I(\¿
$ 512,438;~ fi $ \ \\i 'g?,q;iiÆ(0 . $ 8,419
$ 1e2~e4'(" \! :i $ \ \\J ~4ß),68 $ 186,604\(\~.. '\ li (, /J :"""' "., . '\ \k/
S:~O'\., \t,4~~ ,., ,y~ .9,770,788
($(', ~\~'!i . .\ '\$ 1 959 603
.- \\ '$\1\ \\ä~S':i~7,t,g;:/' $ Ú70:749\ " " ~." ') ,;" r v /'~', \ '\ \ '. $\ "':¡\:;) $ 3,280,434;':'\ \\ i.' \ $ '.".j 95338 $ 100000I !, \. \ \ \\, \. i , \ \ ) \ \ \ \,.$ 18,824,396 $ 19,751,399
\
$ 10,359,786
$ 4,526,240
$ 14,886,026
$
$
$
Administrative and general (A&G) expenses:
COWCAP
SFWE
HHWP
SF Public Utilities Commission:
SFWE
HHWP
Other A&G - SFWE
Other A&G - HHWP
Compliance audit
Total administrative and general expenses
$ 2,308,953
$ (398,019)
$ (4,464,050)
$ 3,280,434
$ 4,662
$ 927,003
p~o:~r; taxes (outside city Oniy)~,. :~:\ \) )', i\'\
HHWP ,/',\/\ \ 'I,,' \\(\;)...:.,:f ;r;'';) '\ '\ \ \\ _;,\~'', Total propert taxes ,,;:~ \\ \\ \\ """, "\\ \\ v,.
,.~ \\ \~ \\ \'".::: '\ \ % \;'"", 1\ \ \ ~ ,?\!\ ,,;)Capital Cost Re'" ~verv~, \1" 1\ \1\\ ,I¡i .' '\',.., \''0 '-'''Pre-2009 A' \ \ \/-,,~ )!
SFWE ~ ..\ V)C:/,,1,/..:\ ."/
HHWP '. \ Ý.\y',;~
Debt Service o\~JiJ~'Assets
SFWE
HHWP
Revenue Funded Assets
SFWE
HHWP
Total Capital Cost Recovery
',.~J
$ 964,040
$ 120,923
$ 1,084,963
$
$
$
969,287
139,732
1,109,019
$
$
$
5,247
18,809
24,056
Balancing Account June 30
$ 24,051,326
$ 3,118,033
$ 17,952,931
$
$ 8,381,400
$ 7,740,688
$ 46,378,941 $ 61,244,378 $14,865,437
$ 120,645,291 $ 140,994,735 $20,349,444
$ 21,176,614 $
$ 529,415 $
$ (123,604,000) $ (147,247,500)
$ $
$ $ 4,488,233
$ $
$ 21,006 $ 21,006
$ $ 1,997,220
$ 18,768,326 $ 253,694
Total Wholesale Revenue Requirement
Balancing Account July 1
Interest on adjusted beginning balance
Wholesale revenues biled
Excess use charges biled
Wholesale Revenue Coverage Reserve
Other adjustments
Settlement adjustments
1984 Agreement Balancing Account Credits
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT P
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Attachment P
REPRESENTATION LETTER
Certification Pursuant to Water Sales Agreement (the Agreement) between the City and County of San Francisco (San Francisco) and certain wholesale customers in the counties of San Mateo, Santa Clara, and Alameda (the Wholesale Customers) effective July 1,2009.
Each of the undersigned certifies that:
1. I have reviewed San Francisco Water Department and Retch Retchy Water & Power Deparment Report on the Calculation of the Wholesale Revenue Requirement and Statement of Changes in the Balancing Account (the Statement) for the year ended June 30, 200X;
Based on my knowledge, this report and Statement do not contain any untrue statements of a material fact or omit to state a material fact necessary to make the statements made, in light of the circumstances under which such statements were made, not misleading with respect to the period covered by the report;
Based on my knowledge, the Statement and other financial information included in the report, fairly presents in all material respects the proper costs incurred and allocated to the Wholesale Customers in accordance with the provisions of the Agreement.
The below certifying officers and I are responsible for establishing and maintaining internal control over financial reporting and have:
Designed such internal control over financial reporting, or caused such internal control over financial reporting to be designed under our supervision, to provide reasonable assurance regarding the reliability of financial reporting for purposes ofthe preparation of the Statement.
Evaluated the effectiveness of the allocation procedures to ensure compliance with the terms of the Agreement.
Attachment P, Page 1
1870057.1
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
The Statement fully complies with the contractual requirements of the Agreement and fairly presents, in all material respects, the allocation of costs to the Wholesale Customers in accordance with the Agreement.
General Manager, SFPUC Date
Assistant General Manager & Chief Financial Offcer, SFPUC Date Finance Director, SFPUC Date
Accounting Manager, SFPUC Date
Financial Planning Manager, SFPUC Date
Senior Rates Administrator, SFPUC Date
Attachment P, Page 2
1870057.1
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT Q
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Legend
f: 21]
Service Area
- Streams/Rivers
Attachment Q-1
i l:
;=--,,----------+---�c;s ......... ;.... ______ ,.,-
Maximum Service Area - North San Jose Municipal Water
\\oakland-01\data \GISIBAWSCA\Project\2018_07 _ServiceAreas\Attach_ Q-1_SantaClara-ServiceArea.mxd 9/14/2018 11 :45:29 AM
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Legend
L rn M Service Area A: Existing service area
Attachment Q-2
(Z2I Service Area B: Expanded service area, for operational purposes only . , . - Streams/Rivers
" .. '!
·1 " .:;
>lh•h
It.th
•.11•1
11 :,
GI
.,
,, ,,
(I
,•
� ..
•,t ··�
Ji ,1 l1,;.q11(r. 1,\1,,1;
,\
Cup 0 •1li110
l\lVt!:,0
\',' 'dll I
J
··'·t
.... "'------!.' \ ,.,
t �!,....i;'��--..... �::-:T���::1--"'"'."'."""',.,:r,�ol/,j,,iliol,..Q.; ..... �-.:_:.,-,� ... T ... , .. ,. ,, . ,, I· I
(
\
,,,,,., 'h
.,'"'' '; li•I
r..:..-,yr,'4111
llttlt
f I ®
Maximum Service Area - City of Santa Clara
\\oakland-01\data\GISIBAWS CA\Project\2018 _07 _ ServlceAreas\Attach_ Q-2_ SantaClara-ServlceAreaExisting.mxd 9/27/2018 3:49:40 PM I
I
i ·','
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT R
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
ATTACHMENT R – CLASSIFICATION OF EXISTING SYSTEM ASSETS 1 15049417.1
ATTACHMENT R-1
INTRODUCTION TO ATTACHMENT R
Attachment R is composed of three documents (1) this R-1 Introduction to Attachment R, (2) R-2 Special Classification of Discrete Projects for 2018 WSA Amendment Purposes, and (3) R-3 Major Hetch Hetchy Enterprise Existing System Assets. These R series attachments provide a record for purposes of maintaining the historical basis for the allocation of capital costs and operating expenses associated with Existing System Assets generally, with greater detail provided for major Hetch Hetchy Enterprise Existing System Assets due to the complexity of tracking the Water-Only, Power-Only, and Joint classifications as inputs to the Wholesale Revenue Requirement under Sections 5.08 and 5.09 of the Agreement.
Attachment R-2, Special Classification of Discrete Projects for 2018 WSA Amendment Purposes defines a limited number of capital projects involving five Hetch Hetchy Enterprise Existing System Assets where the parties have agreed to classify defined capital project costs separately from the assets’ underlying classification listed on Attachment R-3. The classification listed in Attachment R-3 will continue to control the allocation of capital costs and operating expenses once the defined capital projects described in Attachment R-2 are complete.
Attachment R-3, Major Hetch Hetchy Enterprise Existing System Assets is a record of major assets at the "facility group" level (see below) as of January 1, 2019. The table contains six columns and 578 rows. The facility groups are broken down into individual facilities or assets. The facility group name and classification are provided for each asset. Assets listed on Attachment R-3 are classified as Joint, Water-Only, or Power-Only. Each asset is also assigned a unique identification ("ID") number for ease of reference. Attachment R-3 is not a complete record of all Hetch Hetchy Enterprise Existing System Assets.
General Explanation of Classification.
A “facility group” is a location where a group of facilities is located. A single facility may constitute a facility group. A “facility” is a primary asset in a facility group whose function determines its classification and the classification of appurtenances or sub-assets. An appurtenance is an asset or sub-asset that supports the function of the facility to which it is appurtenant. In most cases the classification of the appurtenance is determined by the classification of the facility to which the appurtenance belongs. The function of the appurtenance may not necessarily control its classification.
The classification of appurtenant assets generally follows the classification of the facility group served. These appurtenant assets include security, offices/housing, and utilities serving the facility group such as domestic water, wastewater, communications and solid waste disposal.
Power distribution assets that provide power to a facility group (e.g. lower voltage power distribution lines) generally carry the classification of the facility group served, but do not include power generation or higher voltage transmission lines for export of power elsewhere, which remain classified as Power-Only. With limited exceptions for roads exclusively accessing Power-Only facilities, roads and bridges are classified as Joint because most roads serve multiple facilities or Joint facilities. Equipment and rolling stock are generally classified as Joint unless the asset has a specialized purpose serving the Power function. Capital costs and operating expenses related to Camp Mather are charged to Power in order to segregate these costs from the Wholesale Revenue Requirement.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
1 15048734.1
ATTACHMENT R-2
SPECIAL CLASSIFICATION OF DISCRETE PROJECTS FOR
2018 WSA AMENDMENT PURPOSES
Asset Asset
Classification
Project Project
Classification1
Lower Cherry
Aqueduct
Joint Lower Cherry Aqueduct Project Water2
Mountain Tunnel Joint Mountain Tunnel Interim Work Water3 Mountain Tunnel Joint Mountain Tunnel Long Term
Repairs
Water
3 Mountain Tunnel Joint Mountain Tunnel Flow Control
Facility (FCF) Project
Joint
5 Kirkwood Penstock Power Kirkwood Penstock Project Joint4 Moccasin Powerhouse
Penstock
Power Moccasin Penstock Project Joint4
Moccasin Lower Dam Water Moccasin Dam Interim Repairs Joint5 Moccasin Lower Dam Water Moccasin Dam Long-Term
Improvements
Joint5
These Project Classifications are Exceptions to the Fixed Asset Classifications in Attachment R-3
Attachment R-3 lists major Hetch Hetchy Enterprise Existing System Assets and their agreed- upon classifications (Power, Joint or Water). The classification for all Existing System Assets is fixed and applies to all related expenditures, including capital, regulatory, operating and maintenance expenses, and whether the expenditure alters, rebuilds or replaces the asset, and any appurtenances.
1 Expires June 30, 2034
2 Project capital costs may include costs incurred in FY 2013-14 and subsequent Fiscal Years until project is complete
3 Project capital costs may include costs incurred in FY 2011-12 and subsequent Fiscal Years until project is complete
4 Project capital costs may include costs incurred in FY 2009-10 and subsequent Fiscal Years until project is complete
5 Project capital costs may include costs incurred in FY 2017-18 and subsequent Fiscal Years until project is complete
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
2 15048734.1
In 2018, the parties agreed to classify certain capital projects (but not the underlying asset classifications shown on Attachment R-3) for a select number of Hetch Hetchy Enterprise Existing System Assets. These projects are defined below. These project-related classification changes, shown on this Attachment R-2, are part of the 2018 amendments to the Agreement and are not precedential for any other asset-related capital cost or operating expense.
The capital costs for the projects defined below shall be allocated in accordance with the project classifications shown on this Attachment R-2 so long as the projects are approved by the SFPUC following necessary CEQA review. Once the project, as defined below, is complete and the Commission adopts a project administrative closeout resolution authorizing final payment to the contractor(s), the separate project classification expires and all subsequent capital costs and operating expenses related to the asset will follow the existing asset classification shown on Attachment R-3. The project classification exceptions will expire on June 30, 2034 and all future capital and operating costs and expenses will follow the asset classification, even if a project has not been completed by the SFPUC by that date.
Unless specified otherwise, the capital costs for each project specified below includes costs incurred by the SFPUC for the construction of the project using debt or revenue funding, along with all project-related planning costs, engineering costs, engineering services, costs to obtain project-related regulatory permits, fees for environmental consultants, mitigation costs, legal fees, and other costs that are required to construct and place the project in operation as a water conveyance or power generation facility, or to serve both functions. The allocation of project capital costs includes expenditures incurred in fiscal years prior to FY 2018-19 where noted.
Project Classification Descriptions6
1. Lower Cherry Aqueduct Project means repairs along the Lower Cherry Aqueduct system from and including the Cherry Creek Diversion Dam downstream to and including a connection to the pool behind Early Intake Dam, including expenditures incurred in FY 2013- 14 and subsequent fiscal years until the project is complete.
2. Mountain Tunnel Interim Work means the investigations, interim repairs to the tunnel as well as improvements to access roads and adits for Adit 5/6 and Adit 8/9 already funded or included in the FY 2017-18 ten-year CIP, including expenditures incurred in FY 2011-12 and subsequent fiscal years until the project is complete.
3. Mountain Tunnel Long Term Repairs means repair or replacement of tunnel lining not performed as part of the Mountain Tunnel Interim Work, contact grouting of the entire tunnel lining, completion of hydraulic improvements, installation of steel lining in sections of the tunnel to accommodate increased pressure, extension of the siphon crossing under the South Fork of the Tuolumne River, an enlarged concrete portal and bulkhead at Early Intake, and roadway access improvements to tunnel entry points at the South Fork Tuolumne River crossing, Adit 8-9 and Adit 5-6. Project capital costs include costs incurred in FY 2011-12 and subsequent fiscal years until the project is complete.
6 SFPUC and BAWSCA discussed and agreed to omit the following projects from this special project classification: 1) Early Intake Diversion Dam and Reservoir, 2) Moccasin Power Tunnel, and 3) Kirkwood Generator Bypass and Moccasin Generator #1 & 2 Bypasses. All capital costs and operating expenses related to these assets will follow the existing asset classification shown on Attachment R-3.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
3 15048734.1
4. Mountain Tunnel Flow Control Facility (FCF) Project means construction of a FCF at the downstream end of Mountain Tunnel to reduce lining damage by eliminating the daily cycling between open channel and pressurized flow conditions inside the tunnel, and to allow access to the tunnel when the elevation of the water surface in Priest Reservoir is higher than the elevation of Priest Portal. The project consists of constructing a bypass tunnel, a FCF access shaft and related appurtenances, installing flow control valves and associated mechanical, electrical, and instrumentation as well as construction of a new Mountain Tunnel adit at Priest Reservoir, and a new access road to the FCF. The bypass will be fully steel lined to accommodate higher operating pressures, and a concrete plug will be constructed at the upstream end where water is diverted into the FCF. Project capital costs include costs incurred in FY 2017-18 and subsequent fiscal years until the project is complete.
5. Kirkwood Penstock Project means repair, rehabilitation or replacement of the penstock between the Canyon Portal Valve House and the outside of the northern wall of the Kirkwood Powerhouse. The Joint classification for this project would exclude valves, electronic controls and other appurtenances needed for power operations but not for delivery of water to the Bay Area. Project capital costs include costs incurred in FY 2009-10 and subsequent fiscal years until the project is complete.
6. Moccasin Dam Interim Repairs means repairs and improvements related to damage caused by the March 22, 2018 storm with the goal of returning the reservoir to service at a restricted water pool elevation. The interim measures include repairs and improvements to the Moccasin Creek Diversion Dam and Bypass, Moccasin Reservoir, access and automation improvements at Gate No. 3 Tower, the Lower Moccasin Dam Auxiliary Spillway, and the downstream channel of Moccasin Creek. Project capital costs include costs incurred in FY 2017-18 and subsequent fiscal years until the project is complete.
7. Moccasin Dam Long-Term Improvements means upgrading the Moccasin Reservoir facilities to meet long-term operational and dam safety needs, including the Lower Moccasin Dam, Moccasin Creek Diversion Dam, spillways, outlet works, and other appurtenant facilities, excluding the Moccasin Low Head Hydropower Plant and appurtenances. The work consists of repairs and upgrades to restore the capability to accommodate changes in flow associated with water delivery and power generation, provide hydraulic control for delivery of water to the Bay Area, permit the discharge of excess water downstream to Don Pedro Reservoir, and satisfy State regulatory requirements and guidelines. The Joint classification for this project would include all work, regardless of whether or not specific elements are required by the State of California. Project capital costs include costs incurred in FY 2017-18 and subsequent fiscal years until project is complete.
8. Moccasin Penstock Project means the repair, rehabilitation or replacement of the Moccasin Penstocks to ensure reliable water delivery to the Bay Area and support power generation at Moccasin Powerhouse. Project facilities would extend from the western end of the Moccasin Power Tunnel to the eastern wall of the Moccasin Powerhouse. The Joint classification for this project would exclude valves, electronic controls and other appurtenances needed for power operations but not for delivery of water to the Bay Area.
Project capital costs include costs incurred in FY 2009-10 and subsequent fiscal years until the project is complete.
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
1 CPSCADA Canyon Tunnel CANYON PORTAL SCADA RTU (FUT.) Joint 1 2 OSHCANTNL Canyon Tunnel OSHAUGHNESSY CANYON POWER TUNNEL Joint 2 3 CV Cherry and Eleanor Dams/Compounds CHERRY VALLEY DAMS AND BUILDINGS Joint 3 4 CVBLDGS Cherry and Eleanor Dams/Compounds CHERRY VALLEY BUILDINGS Joint 4 5 CVFUEL Cherry and Eleanor Dams/Compounds CHERRY VALLEY FUELING STATION Joint 5 6 CVPS Cherry and Eleanor Dams/Compounds CHERRY VALLEY PUMP STATION Power 6 7 ELBAT Cherry and Eleanor Dams/Compounds ELEANOR BATTERY BANK Joint 7 8 ELCOT Cherry and Eleanor Dams/Compounds COTTAGE, LAKE ELEANOR Joint 8 9 ELDORM Cherry and Eleanor Dams/Compounds DORM, COOKHOUSE, GARAGE LAKE ELEANOR Joint 9 10 ELDWSCT Cherry and Eleanor Dams/Compounds LAKE ELEANOR WATER TANK Joint 10 11 ELEANOR Cherry and Eleanor Dams/Compounds LAKE ELEANOR EQUIPMENT Joint 11 12 ELWHSE Cherry and Eleanor Dams/Compounds WAREHOUSE, LAKE ELEANOR Joint 12 13 CVPSPRORLY Cherry and Eleanor Dams/Compounds CHERRY VALLEY PUMP STATION PROTECTIVE RELAYS Power 13 14 CVDM Cherry and Eleanor Dams/Compounds CHERRY VALLEY DAM Joint 14 15 CVDWS Cherry and Eleanor Dams/Compounds CHERRY VALLEY DOMESTIC WATER SYSTEM Joint 15 16 CVVH Cherry and Eleanor Dams/Compounds CHERRY VALLEY VALVE HOUSE Joint 16 17 ELNCHRTNL Cherry and Eleanor Dams/Compounds ELEANOR - CHERRY TUNNEL Joint 17 18 ELNRDM Cherry and Eleanor Dams/Compounds ELEANOR DAM Joint 18 19 ICP Early Intake Dam and Reservoir INTAKE CAMP EQUIPMENT AND GROUNDS Joint 19 20 ICPCT Early Intake Dam and Reservoir INTAKE CAMP COTTAGES Joint 20 21 ICPFUEL Early Intake Dam and Reservoir INTAKE CAMP FUELING SYSTEM Joint 21 22 ICPLINERIGSH Early Intake Dam and Reservoir INTAKE CAMP LINEMENS RIGGING SHED BUILDING NA 22 23 ICPMAIL This row not included by SFPUC INTAKE MAIL SHACK NA 23 24 ICPSAND Early Intake Dam and Reservoir INTAKE CAMP SAND STORAGE BUILDING Joint 24 25 ICPSEW Early Intake Dam and Reservoir INTAKE CAMP SEWAGE SYSTEM Joint 25 26 ICPTV Early Intake Dam and Reservoir INTAKE CAMP TV SYSTEM Joint 26 27 ICPWSTN Early Intake Dam and Reservoir INTAKE WEATHER STATION Joint 27 28 IWSSCADA Early Intake Dam and Reservoir INTAKE DOMESTIC WATER SYS RTU Joint 28 29 ICPEL Early Intake Dam and Reservoir INTAKE CAMP ELECTRICAL SYSTEM Joint 29 30 ICPDWSBFP Early Intake Dam and Reservoir INTAKE DOMESTIC WATER BACK FLOW PREVENTERS, ICP Joint 30 31 ICPPOOL Early Intake Dam and Reservoir INTAKE CAMP SWIMMING POOL Joint 31 32 ICPWTS Early Intake Dam and Reservoir INTAKE CAMP WATER SYSTEM Joint 32 33 ICPDM Early Intake Dam and Reservoir INTAKE CAMP DAM Joint 33 34 INTRES Early Intake Dam and Reservoir INTAKE RESERVOIR Joint 34 35 GPL Holm Powerhouse 22.9KV-GRANITE PORTAL LINE Power 35 36 H1 Holm Powerhouse HOLM UNIT #1 Power 36
37 H1PRORLY Holm Powerhouse HPH UNIT #1 PROTECTIVE RELAYS Power 37 38 H2 Holm Powerhouse HOLM UNIT #2 Power 38
39 H2PRORLY Holm Powerhouse HPH UNIT #2 PROTECTIVE RELAYS Power 39 40 HAX Holm Powerhouse HPH EXCITERS, GOVERNORS, TAIL RACE AND OTHER Power 40 41 HL2TTGE Holm Powerhouse HPH LINE #2 TRANSFER TRIP GE Power 41 42 HPH Holm Powerhouse HOLM POWERHOUSE Power 42
43 HPHBATTERY Holm Powerhouse HPH BATTERY SYSTEM Power 43 44 HPHPEN Holm Powerhouse HOLM POWERHOUSE PENSTOCK Power 44 45 HPHPRORLYTMP Holm Powerhouse TEMP HOLING SPOT FOR PRO RLYS Power 45 46 HPHRF#1 Holm Powerhouse HOLM POWERHOUSE ROOF FAN #1 Power 46 47 HPHRF#2 Holm Powerhouse HOLM POWERHOUSE ROOF FAN #2 Power 47 48 HPHWW Holm Powerhouse HPH TSOV, SLIDE GATES AT TAILRACE, ETC Power 48 49 HPRORLY Holm Powerhouse HPH PROTECTIVE RELAYS Power 49 50 HSPARES Holm Powerhouse ALL HOLM POWERHOUSE SPARES Power 50 51 HVH Holm Powerhouse HOLM VALVE HOUSE Power 51
11/16/2018 15048696_1.xlsx 1
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
52 CVPWRTNL Holm Powerhouse CHERRY POWER TUNNEL Power 52 53 GPSCADA Holm Powerhouse GRANITE PORTAL SCADA RTU (FUT.) Power 53 54 H1ASCADA Holm Powerhouse HPH UNIT 1 ANNUNCIATOR RTU Power 54 55 H2ASCADA Holm Powerhouse HPH UNIT 2 ANNUNCIATOR RTU Power 55 56 HPHSCADA Holm Powerhouse HOLM POWERHOUSE SCADA RTU Power 56 57 HPHVMS Holm Powerhouse HPH VIBRATION MONITORING SYSTEM Power 57 58 KPH2SCADA Kirkwood Powerhouse KPH PENSTOCK MONITORING SYS RTU Power 58 59 KPH Kirkwood Powerhouse KIRKWOOD POWERHOUSE Power 59 60 KPHB Kirkwood Powerhouse KPH BATHROOM Power 60
61 KPHOFFICE Kirkwood Powerhouse KPH OPERATOR OFFICE Power 61 62 KVH Kirkwood Powerhouse KIRKWOOD VALVE HOUSE Joint 62 63 K1 Kirkwood Powerhouse KIRKWOOD UNIT #1 Power 63
64 K1PRORLY Kirkwood Powerhouse KPH UNIT #1 PROTECTIVE RELAYS Power 64 65 K2 Kirkwood Powerhouse KIRKWOOD UNIT #2 Power 65
66 K2PRORLY Kirkwood Powerhouse KPH UNIT #2 PROTECTIVE RELAYS Power 66 67 K3 Kirkwood Powerhouse KIRKWOOD UNIT #3 Power 67
68 K3PRORLY Kirkwood Powerhouse KPH UNIT #3 PROTECTIVE RELAYS Power 68 69 KAX Kirkwood Powerhouse KPH EXCITERS, GOVERNORS, TAIL RACE AND OTHER Power 69 70 KAXBKR5211 Kirkwood Powerhouse KPH BREAKER LOCATION 52-11 MATHER / ICP LINE Power 70 71 KAXBKR5212 Kirkwood Powerhouse KPH BREAKER LOCATION 52-12 CANYON PORTAL LINE Power 71 72 KAXBKR5221 Kirkwood Powerhouse KPH BREAKER LOCATION 52-21 MATHER / ICP LINE Power 72 73 KAXBKR5222 Kirkwood Powerhouse KPH BREAKER LOCATION 52-22 MATHER 22KV LINE Power 73 74 KAXBKR52S1 Kirkwood Powerhouse KPH1 BREAKER LOCATION 52-S1 STATION SERVICE Power 74 75 KAXBKR52S2 Kirkwood Powerhouse KPH2 BREAKER LOCATION 52-S2 STATION SERVICE Power 75 76 KAXBKR52S3 Kirkwood Powerhouse KPH3 BREAKER LOCATION 52-S3 STATION SERVICE Power 76 77 KAXBKRBT Kirkwood Powerhouse KPH BREAKER LOCATION 52-BUS TIE Power 77 78 KAXBKRBT23 Kirkwood Powerhouse KPH BREAKER LOCATION 23-BUS TIE Power 78 79 KAXBKRBT32 Kirkwood Powerhouse KPH BREAKER LOCATION 32-BUS TIE Power 79 80 KAXBKRSS1 Kirkwood Powerhouse KPH1 BREAKER LOCATION 52-SS1 STATION SERVICE Power 80 81 KAXBKRSS2 Kirkwood Powerhouse KPH2 BREAKER LOCATION 52-SS2 STATION SERVICE Power 81 82 KAXBKRSS3 Kirkwood Powerhouse KPH3 BREAKER LOCATION 52-SS3 STATION SERVICE Power 82 83 KAXBREAKERS Kirkwood Powerhouse KIRKWOOD POWERHOUSE BREAKERS Power 83 84 KPHBATTERY Kirkwood Powerhouse KPH BATTERY SYSTEM Power 84 85 KPHDCV Kirkwood Powerhouse KPH DELUGE CONTROL VALVE Power 85 86 KPHGENBRK Kirkwood Powerhouse KPH SPARE GENERATOR BREAKER Power 86 87 KPHOILFLT Kirkwood Powerhouse KPH PORTABLE XFMR OIL FILTER Power 87 88 KPHPEN Kirkwood Powerhouse KIRKWOOD POWERHOUSE PENSTOCK Power 88 89 KPHRF Kirkwood Powerhouse KPH RECIRCULATING FAN Power 89 90 KPRORLY Kirkwood Powerhouse KPH PROTECTIVE RELAYS Power 90 91 KSPARES Kirkwood Powerhouse ALL KIRKWOOD POWERHOUSE SPARES Power 91 92 KPHAXWPV Kirkwood Powerhouse KPH AUX WHEEL PIT VENT Power 92 93 KPHBYPSYS Kirkwood Powerhouse KPH GENERATOR BYPASS Power 93 94 KPHWW Kirkwood Powerhouse KPH TSOV, SLIDE GATES AT TAILRACE, ETC Power 94 95 K1ASCADA Kirkwood Powerhouse KPH UNIT 1 ANNUNCIATOR RTU Power 95 96 K2ASCADA Kirkwood Powerhouse KPH UNIT 2 ANNUNCIATOR RTU Power 96 97 KPH1SCADA Kirkwood Powerhouse KPH SCADA RTU Power 97 98 VIBMONSYS Kirkwood Powerhouse ALL VIBRATION MONITORING SYSTEMS & EQUIPMENT Power 98 99 KPHVMS Kirkwood Powerhouse KPH VIBRATION MONITORING SYSTEM Power 99 100 KPHTRBMTR Kirkwood Powerhouse KPH TURBIDIMETER Water 100 102 RAKERLANDS Support Systems, Utilities and Other RAKER ACT LANDS & US LAND APPLICATIONS Joint 102 103 SJLANDS Support Systems, Utilities and Other SAN JOAQUIN COUNTY LANDS Joint 103 11/16/2018 15048696_1.xlsx 2
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
104 STANISLANDS Support Systems, Utilities and Other STANISLAUS COUNTY LANDS Joint 104 105 TUOLUMNELAN Support Systems, Utilities and Other TUOLUMNE & MARIPOSA COUNTY LANDS Joint 105 106 CC Lower Cherry Creek Aqueduct CHERRY CREEK EQUIPMENT AND BUILDING Joint 106 107 CCAQ Lower Cherry Creek Aqueduct CHERRY CREEK AQUEDUCT Joint 107 108 CCDDM Lower Cherry Creek Aqueduct CHERRY CREEK DIVERSION DAM Joint 108 109 CHDIVTUN Lower Cherry Creek Aqueduct CHERRY DIVERSION TUNNEL Joint 109 110 CVDIVCANAL Lower Cherry Creek Aqueduct CHERRY TO INTAKE DIVERSION CANAL Joint 110 118 MLSSCADA Moccasin Administrative Compound MOCCASIN LIFT STATION RTU Joint 118 119 MPHWS Moccasin Administrative Compound MOCCASIN WEATHER STATION Joint 119 120 MWSSCADA Moccasin Administrative Compound MOCCASIN DOMESTIC WATER SYS RTU Joint 120 121 EQP-HH Moccasin Administrative Compound NON-AUTOMOTIVE EQUIPMENT Joint 121 122 ETESTEQUIP Moccasin Administrative Compound ELECTRONIC TEST EQUIPMENT Joint 122 126 MCPARC Moccasin Administrative Compound MOCCASIN ARCHIVES / RECORDS OFFICE Joint 126 127 MCPBH Moccasin Administrative Compound MOCCASIN BUNKHOUSE Joint 127 128 MCPBLPRK Moccasin Administrative Compound MOCCASIN CAMP BALL PARK Joint 128 129 MCPCARP Moccasin Administrative Compound MOCCASIN CARPENTER SHOP BUILDING Joint 129 130 MCPCARPORT Moccasin Administrative Compound SHOP AREA CAR PORTS Joint 130 131 MCPCH Moccasin Administrative Compound MOCCASIN CLUBHOUSE/ADMIN. BLDG. Joint 131 132 MCPCM Moccasin Administrative Compound MOCCASIN CONSTRUCTION MANAGEMENT OFFICES, MOCCASIN Joint 132 133 MCPCOT10 Moccasin Administrative Compound COTTAGE 10 Joint 133 134 MCPCOT13 Moccasin Administrative Compound CMB SURVEY ADMINISTRATIVE OFFICE Joint 134 135 MCPCOT14 Moccasin Administrative Compound ITS ADMINISTRATIVE OFFICE Joint 135 136 MCPCOT15 Moccasin Administrative Compound GUEST COTTAGE 15 Joint 136 137 MCPCOT16 Moccasin Administrative Compound MOCCASIN FINANCE OFFICE Joint 137 138 MCPCOT17 Moccasin Administrative Compound TRAINING OFFICE Joint 138 139 MCPCOT18 Moccasin Administrative Compound EXERCISE BUILDING Joint 139 140 MCPCOT36 Moccasin Administrative Compound WATERSHED ADMINISTRATIVE OFFICE Joint 140 141 MCPCOT41 Moccasin Administrative Compound GUEST COTTAGE 41 Joint 141 142 MCPCRDBRD Moccasin Administrative Compound MCP CARDBOARD COMPACTOR Joint 142 143 MCPCT Moccasin Administrative Compound MOCCASIN CAMP COTTAGES Joint 143 144 MCPELEC Moccasin Administrative Compound MOCCASIN CAMP ELECTRIC SHOP Joint 144 145 MCPENG Moccasin Administrative Compound MOCCASIN ENGINEERING OFFICE Joint 145 146 MCPFIREGAR Moccasin Administrative Compound MOCCASIN FIRE TRUCK GARAGE Joint 146 147 MCPFLDOFF Moccasin Administrative Compound MOCCASIN FIELD OFFICE BUILDING Joint 147 148 MCPFUEL Moccasin Administrative Compound MOCCASIN CAMP FUELING STATION Joint 148 149 MCPGARD Moccasin Administrative Compound MOCCASIN GARDENERS SHOP Joint 149 150 MCPGREENHS Moccasin Administrative Compound MOCCASIN GREENHOUSE Joint 150 151 MCPLINE Moccasin Administrative Compound MOCCASIN POWER LINE SHOP BUILDING Power 151 152 MCPMACHSP Moccasin Administrative Compound MOCCASIN MACHINE AND AUTO SHOP BLDG Joint 152 153 MCPMERC Moccasin Administrative Compound MOCCASIN EMERGENCY RESPONSE CENTER Joint 153 154 MCPMNTFAC Moccasin Administrative Compound MOCCASIN MAINTENANCE FACILITY Joint 154 156 MCPOMPH Moccasin Administrative Compound MOCC CAMP OLD MOCCASIN POWERHOUSE: Long term storage Joint 156 157 MCPPAINTSP Moccasin Administrative Compound MOCCASIN CAMP PAINT SHOP Joint 157 158 MCPPLAN Moccasin Administrative Compound PLANNING AND SCHEDULING BUILDING Joint 158 159 MCPPLUMB Moccasin Administrative Compound MOCCASIN PLUMBERS SHOP Joint 159 160 MCPPOOL Moccasin Administrative Compound MOCCASIN CAMP SWIMMING POOL Joint 160 161 MCPRECFAL Moccasin Administrative Compound MOCCASIN RECREATIONAL FACILITY Joint 161 162 MCPSAWMIL Moccasin Administrative Compound MOCCASIN SAWMILL FACILITY Joint 162 163 MCPSCADATRLR Moccasin Administrative Compound MOCCASIN SCADA TRAILER, MOCCASIN Joint 163 164 MCPSCHOOL Moccasin Administrative Compound MOCCASIN SCHOOL BUILDING Joint 164 165 MCPSEWLIFT1 Moccasin Administrative Compound MOCCASIN CAMP SEWAGE LIFT STATION 1 Joint 165 11/16/2018 15048696_1.xlsx 3
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
166 MCPSEWSYS Moccasin Administrative Compound MOCCASIN CAMP SEWAGE SYSTEM Joint 166 167 MCPTECH Moccasin Administrative Compound MOCCASIN CAMP TECH SHOP Joint 167 168 MCPTGSTMPFAC Moccasin Administrative Compound MOCCASIN TEMPORARY GUEST ACCOMMODATIONS Joint 168 169 MCPTOOLRM Moccasin Administrative Compound MOCCASIN TOOL ROOM BUILDING Joint 169 170 MCPUEB Moccasin Administrative Compound MOCCASIN Bldg 57 Joint 170 171 MCPWHSE Moccasin Administrative Compound MOCCASIN WAREHOUSE & SHOPS BLDG Joint 171 173 MCPSL Moccasin Administrative Compound MOCCASIN CAMP STREET LIGHTS Joint 173 174 MCPDWS Moccasin Administrative Compound MOCCASIN DOMESTIC WATER SYSTEM Joint 174 175 MCPDWSBFP Moccasin Administrative Compound MOCCASIN DOMESTIC WATER SYSTEM BACK FLOW PREVENTER Joint 175 176 ELECTDVCS Moccasin Administrative Compound SMALL ELECTRONIC DEVICES AND EQUIPMENT, MOCCASIN Joint 176 177 MCPWQ2 Moccasin Administrative Compound MCP WATER QUALITY BUILDING 2 Water 177 178 MCPWQLABS Moccasin Administrative Compound MCP WATER QUALITY LABS Water 178 179 MPFLOSCADA Moccasin Powerhouse MPH PENSTOCK FLOW MTRING SCADA RTU Power 179 180 MPH Moccasin Powerhouse MOCCASIN POWERHOUSE Power 180 181 MPHAUXCMP Moccasin Powerhouse MPH AUX. AIR COMPRESSOR Power 181 182 MPHCR Moccasin Powerhouse MPH MAIN CONTROL ROOM Joint 182 183 MPHHWT Moccasin Powerhouse MOCCASIN POWERHOUSE HOT WATER TANK Joint 183 184 MPHOILROOM Moccasin Powerhouse MPH OIL TREATMENT ROOM Power 184 185 MPHSTOR Moccasin Powerhouse MOCCASIN PH STORAGE BUILDING Power 185 186 M1 Moccasin Powerhouse MOCCASIN UNIT #1 Power 186
187 M1PRORLY Moccasin Powerhouse MPH UNIT #1 PROTECTIVE RELAYS Power 187 188 M2 Moccasin Powerhouse MOCCASIN UNIT #2 Power 188
189 M2PRORLY Moccasin Powerhouse MPH UNIT #2 PROTECTIVE RELAYS Power 189 190 MAX Moccasin Powerhouse MPH EXCITERS, GOVERNORS, TAIL RACE AND OTHER Power 190 191 MAX52BT Moccasin Powerhouse 52-BT BUS TIE CIRCUIT BREAKER LOCATION Power 191 192 MAXBRK Moccasin Powerhouse MOCCASIN POWERHOUSE CIRCUIT BREAKERS Power 192 193 MAXBRKSS1 Moccasin Powerhouse 52-SS1 STATION SERVICE CIRCUIT BREAKER LOCATION Power 193 194 MAXBRKSS2 Moccasin Powerhouse VILLAGE XFMR 52-SS2 STATION SERVICE LOCATION Power 194 195 MBRK52S1 Moccasin Powerhouse 52-S1 CIRCUIT BREAKER LOCATION Power 195 196 MBRK52S2 Moccasin Powerhouse 52-S2 CIRCUIT BREAKER LOCATION Power 196 197 MPHBATTERY Moccasin Powerhouse MPH BATTERY SYSTEM Power 197 198 MPHDELVAL Moccasin Powerhouse MPH DELUGE VALVE SYSTEM Power 198 199 MPHMCB Moccasin Powerhouse MPH MAIN CONTROL BOARD Power 199 200 MPHPEN Moccasin Powerhouse MOCCASIN POWERHOUSE PENSTOCK Power 200 201 MPRORLY Moccasin Powerhouse MPH PROTECTIVE RELAYS Power 201 202 MSPARES Moccasin Powerhouse ALL MPH SPARE EQUIPMENT Power 202 203 MSY Moccasin Powerhouse MOCCASIN SWITCHYARD Power 203 204 MSYLIGHTS Moccasin Powerhouse MSY MERCURY VAPOR LIGHTS Power 204 205 PWRSCHED Moccasin Powerhouse MPH POWER SCHEDULING COMPUTERS Power 205 206 MOCCPWTUS Moccasin Powerhouse MOCCASIN POWER TUNNEL SURGE SHAFT Power 206 207 MPHBYPSYS1 Moccasin Powerhouse MPH GENERATOR BYPASS #1 Power 207 208 MPHBYPSYS2 Moccasin Powerhouse MPH GENERATOR BYPASS #2 Power 208 209 MPHWW Moccasin Powerhouse MPH TSOV, SLIDE GATES AT TAILRACE, ETC Power 209 210 BNVMSCPU Moccasin Powerhouse BENTLY-NEVADA VIBRATION MONITORING SYS CENTRAL PRO Power 210 211 MPHSCADA Moccasin Powerhouse MOCCASIN POWERHOUSE SCADA RTU Power 211 212 PMBSCADA Moccasin Powerhouse PG&E MAIL BOX SCADA RTU Power 212 213 MLHSCADA Moccasin Administrative Compound MOCCASIN LOW-HEAD PWR STA SCADA RTU Power 213 214 MLHVMS Moccasin Administrative Compound MOCC. LOWHEAD VIBRATION MONITORING SYSTEM Power 214 215 MPHVMS Moccasin Administrative Compound MPH VIBRATION MONITORING SYSTEM Power 215 216 MLH Moccasin Administrative Compound MOCCASIN LOW HEAD POWER PLANT Power 216 217 MLHPEN Moccasin Administrative Compound MOCCASIN LOWHEAD PENSTOCK Power 217 11/16/2018 15048696_1.xlsx 4
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
218 M3 Moccasin Administrative Compound MOCCASIN LOWHEAD UNIT Power 218 219 MLHBATTERY Moccasin Administrative Compound MOCCASIN LOW-HEAD BATTERY SYS Power 219 220 MLHMCB Moccasin Administrative Compound MOCC LOWHEAD MAIN CONTROL BOARD Power 220 221 MLHPRORLY Moccasin Administrative Compound MLH PROTECTIVE RELAYS Power 221 222 MLHTS Moccasin Administrative Compound MOCCASIN LOW HEAD TELEPHONE SYSTEM Power 222 223 MPHRESBYP Moccasin Administrative Compound MOCCASIN RESERVOIR BYPASS Water 223 224 MLHPRGCTRL Moccasin Administrative Compound MLH PROGRAMABLE CONTROLLER Power 224 225 MCPFHDWM Moccasin Administrative Compound DOMESTIC WATER METERS / HATCHERY Joint 225 226 MCPBR Moccasin Administrative Compound MCP TIMBER BRIDGE / TRASH RACK Water 226 227 MCPCANAL Moccasin Administrative Compound MOCCASIN CANAL Water 227 228 MCPRES Moccasin Administrative Compound MOCCASIN CAMP RESERVOIR Water 228 229 MOCCLDM Moccasin Administrative Compound MOCCASIN LOWER DAM, MOCCASIN Water 229 230 MOCCUDM Moccasin Administrative Compound MOCCASIN CREEK UPPER DIVERSION DAM , MOCCASIN Water 230 231 MG3SCADA Moccasin Administrative Compound MOCCASIN GATE NO. 3 RTU NA 231 232 FTHTNLJACPU Moccasin Administrative Compound MOCCASIN RESERVOIR TURBIDITY SUPPLY JACK PUMP SITE Water 232 233 KBP Mountain Tunnel KIRKWOOD/INTAKE BYPASS SYSTEM Joint 233 234 MTNTNLDIV Mountain Tunnel MOUNTAIN TUNNEL AND ADITS Joint 234 235 SF Mountain Tunnel SOUTH FORK EQUIPMENT & BUILDINGS Joint 235 236 SFFUEL Mountain Tunnel SOUTH FORK FUELING STATION Joint 236 237 SFOFF Mountain Tunnel SOUTH FORK OFFICE BUILDING Joint 237 238 MT1-2AD Mountain Tunnel MTN TNL DIV 1-2 TUNNEL ACCESS Joint 238 239 MT3-4AD Mountain Tunnel MTN TNL DIV 3-4 TUNNEL ACCESS Joint 239 240 MT5-6AD Mountain Tunnel MTN TNL DIV 5-6 TUNNEL ACCESS Joint 240 241 MT8-9AD Mountain Tunnel MTN TNL DIV 8-9 TUNNEL ACCESS Joint 241 242 MTBIGCRSH Mountain Tunnel MTN TNL DIV BIG CREEK SHAFT, Joint 242 243 MTDSFC Mountain Tunnel SOUTH FORK CROSSING Joint 243 244 MTEIAD Mountain Tunnel MTN TNL DIV ACCESS AT EARLY INTAKE Joint 244 TBD Mountain Tunnel Flow Control Facility Joint TBD
245 MTPROUT Mountain Tunnel Mountain Tunnel Priest Outlet Joint 245 246 MTSECGROT Mountain Tunnel MTN TNL DIV SECOND GARROTE SHAFT, Joint 246 247 SFDWS Mountain Tunnel SOUTH FORK DOMESTIC WATER SYSTEM Joint 247 248 OSHSCADA O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DAM RTU Joint 248 249 OSHSG O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY STREAM GAUGE Joint 249 250 OSHWSTN O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY WEATHER STATION Joint 250 251 OSH O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DAM AND AREA BLDGS. Joint 251 252 OSHCT O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY COTTAGES Joint 252 253 OSHEL O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY CAMP ELECTRICAL Joint 253 254 OSHEQP O'Shaughnessy Dam and Reservoir/CompoundALL OSHAUGHNESSY EQUIPMENT Joint 254 255 OSHDIVTNL O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DIVERSION TUNNEL Joint 255 256 OSHDM O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DAM Joint 256 257 OSHDMWELLAU O'Shaughnessy Dam and Reservoir/CompoundOSH DOMESTIC WELL AUXILIARY BUILDING Joint 257 258 OSHDWS O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DAM DOMESTIC WTR SYS Joint 258 259 OSHDWSBFP O'Shaughnessy Dam and Reservoir/CompoundOSH DOMESTIC WATER BACK FLOW PREVENTERS, OSH Joint 259 260 OSHDWW O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY DOMESTIC WATER WELL SYSTEM, OSH Joint 260 261 OSHFUEL O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY FUELING STATION Joint 261 262 OSHG1 O'Shaughnessy Dam and Reservoir/CompoundOSH DAM GALLERY #1 Joint 262 263 OSHG2 O'Shaughnessy Dam and Reservoir/CompoundOSH DAM GALLERY #2 Joint 263 264 OSHGAR5 O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY GARAGE #5 Joint 264 265 OSHGAR7 O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY GARAGE #7 Joint 265 266 OSHRCKSCRN O'Shaughnessy Dam and Reservoir/CompoundROCK SCREENING PLANT NA 266 267 OSHSEWSYS O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY SEWAGE SYSTEM Joint 267 11/16/2018 15048696_1.xlsx 5
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
268 OSHSTORE3 O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY STORE HOUSE 3 Joint 268 269 OSHSTORE6A O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY STORE HOUSE 6-A Joint 269 270 OSHWDSHD3A O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY WOODSHED 3-A Joint 270 271 OSHWH12 O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY WAREHOUSE #12 Joint 271 272 OSHWLHSE O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY WELL HOUSE Joint 272 273 OSHWTRSHED O'Shaughnessy Dam and Reservoir/CompoundHETCH HETCHY RESERVOIR WATERSHED water quality activities NA 273 274 OWQSCADA O'Shaughnessy Dam and Reservoir/CompoundOSHAUGHNESSY WATER QUALITY RTU Water 274 275 OLDOAKYD Facilities West of Moccasin Gate Tower 120/240V-OLD OAKDALE YARD LINE Joint 275 276 OAKCT Facilities West of Moccasin Gate Tower OAKDALE EMPLOYEE COTTAGE Joint 276 277 OAKDALE Facilities West of Moccasin Gate Tower OLD OAKDALE YARD Joint 277 278 OAKGAR Facilities West of Moccasin Gate Tower OAKDALE GARAGE Joint 278 279 OAKLINE Facilities West of Moccasin Gate Tower OAKDALE LINE SHOP BUILDING Joint 279 280 OAKOFFICE Facilities West of Moccasin Gate Tower OAKDALE OFFICE BUILDING Joint 280 281 OAKWHSE Facilities West of Moccasin Gate Tower OAKDALE WAREHOUSE BUILDING Joint 281 282 CPL Support Systems, Utilities and Other 2.4KV-CANYON PORTAL LINE Joint 282 283 CRL Support Systems, Utilities and Other 22.9KV-CHERRY RIDGE LINE Joint 283 284 CRLC Support Systems, Utilities and Other 22.9KV-CHERRY COMP TO RISER ACCROSS DAM LINE Joint 284 285 CRLCH Support Systems, Utilities and Other 22.9KV-CHERRY COMPOUND LINE Joint 285 286 HL Support Systems, Utilities and Other 22.9KV-HOLM LINE Joint 286 287 ICL Support Systems, Utilities and Other 22.9KV-INTAKE CAMP LINE Joint 287 288 INTCMP Support Systems, Utilities and Other (OLD) INTAKE CAMP LINE NA 288 289 INT-OSH Support Systems, Utilities and Other 22.9KV-INTAKE TO OSH LINE Joint 289 290 IRL Support Systems, Utilities and Other 22.9KV-INTAKE RADIO SITE LINE Joint 290 291 KRT Support Systems, Utilities and Other (OLD) KPH TO RIDGE LINE TIE LINE NA 291 292 MATA Support Systems, Utilities and Other MATHER "A" LINE Power 292 293 MATB Support Systems, Utilities and Other 2.4KV-MATHER "B" LINE Power 293 294 MCPA Support Systems, Utilities and Other 2.4KV-MOCCASIN CAMP "A" LINE Joint 294 295 MCPB Support Systems, Utilities and Other 2.4KV-MOCCASIN CAMP "B" LINE Joint 295 296 MPL Support Systems, Utilities and Other 2.4KV-MOCCASIN PEAK LINE Joint 296 297 OAKPORT Support Systems, Utilities and Other 120/240V-OAKDALE PORTAL LINE Water 297 298 POLES Support Systems, Utilities and Other DISTRIBUTION POLE LINES Joint 298 299 PRL Support Systems, Utilities and Other 2.4KV-PRIEST RESERVOIR LINE Joint 299 300 PRLN Support Systems, Utilities and Other PRIEST RESERVOIR COMM/SIGNAL LINE Joint 300 301 RLT Support Systems, Utilities and Other (OLD) RIDGE LINE TIE LINE NA 301 302 RRLINE Support Systems, Utilities and Other 120/240V-ROCK RIVER LINE Water 302 303 SJVHLN Support Systems, Utilities and Other 120/240V-SAN JOAQUIN VALVE HOUSE LINE Water 303 304 MAXBRKVT1 Support Systems, Utilities and Other VILLAGE XFMR 1, CIRCUIT BREAKER, MPH1 LOCATION Joint 304 305 MAXBRKVT2 Support Systems, Utilities and Other VILLAGE XFMR 2 CIRCUIT BREAKER LOCATION Joint 305 306 TESLP Support Systems, Utilities and Other 12KV-TESLA PORTAL LINE Water 306 307 INTHSFPWLACV Support Systems, Utilities and Other TOP INTAKE HILL/ SOUTH FORK RIVER TOWER LINE ROADS Joint 307 308 ISYL Support Systems, Utilities and Other 22.9KV-INTAKE SWITCHYARD LINE Power 308 309 ISYOILFLT Support Systems, Utilities and Other TRAILER MOUNTED OIL FILTER Power 309 310 ISYPLCCOMM Support Systems, Utilities and Other ISY POWER LINE CARRIER EQUIP Power 310 312 ISY Support Systems, Utilities and Other INTAKE SWITCHYARD Power 312 313 ISYB Support Systems, Utilities and Other ISY BOGUE UNIT Power 313 314 ISYBUSTIE Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. BUS TIE Power 314 315 ISYCRB Support Systems, Utilities and Other INTAKE SWITCHYARD CONTROL ROOM/BUILDING Power 315 316 ISYLIGHTS Support Systems, Utilities and Other SWITCHYARD LIGHTS Power 316 317 ISYLINE1 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 1 Power 317 318 ISYLINE10 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 10 Power 318 319 ISYLINE11 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 11 Power 319 11/16/2018 15048696_1.xlsx 6
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
320 ISYLINE2 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 2 Power 320 321 ISYLINE2.4 Support Systems, Utilities and Other INTAKE CAMP LINE 2.4KV Power 321 322 ISYLINE5 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 5 Power 322 323 ISYLINE6 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 6 Power 323 324 ISYLINE9 Support Systems, Utilities and Other INTAKE SWITCHYARD H.V. LINE 9 Power 324 325 ISYPRORLY Support Systems, Utilities and Other ISY PROTECTIVE RELAYS Power 325 326 LINE11TWR Support Systems, Utilities and Other TRANSMISSION TOWERS, LINE 11 Power 326 327 LINE1-2TWR Support Systems, Utilities and Other TOWERS FOR TRANSMISSION LINES 1 & 2 Power 327 328 LINE3-4TWR Support Systems, Utilities and Other TRANSMISSION TOWERS, LINES 3 & 4 Power 328 329 LINE5-6TWR Support Systems, Utilities and Other TRANSMISSION TOWERS, LINES 5 & 6 Power 329 330 LINE7-8TWR Support Systems, Utilities and Other TRANSMISSION TOWERS, LINES 7 & 8 Power 330 331 LINE910TWR Support Systems, Utilities and Other TRANSMISSION TOWERS, LINES 9 & 10 Power 331 333 MSYLINE3 Support Systems, Utilities and Other MSY H.V. LINE 3 Power 333 334 MSYLINE4 Support Systems, Utilities and Other MSY H.V. LINE 4 Power 334 335 MSYLINE5 Support Systems, Utilities and Other MSY H.V. LINE 5 Power 335 336 MSYLINE6 Support Systems, Utilities and Other MSY H.V. LINE 6 Power 336 337 122OSS Support Systems, Utilities and Other OAKDALE SUBSTATION (TID) Power 337 338 CSPRORLY Support Systems, Utilities and Other CALAVERUS SUBSTATION PROTECTIVE RELAYS Power 338 339 CSSPARES Support Systems, Utilities and Other ALL CAL SUB SPARE EQUIPMENT Power 339 340 MID_TID_SUBS Support Systems, Utilities and Other NON HETCH HETCHY SUBSTATIONS Power 340 341 ROP Support Systems, Utilities and Other ROP SWITCH ROOM Power 341 342 STSUB Support Systems, Utilities and Other STANDIFORD SUBSTATION, MODESTO Power 342 343 DAVISSUB This row not included by SFPUC DAVIS SUB STATION NA 343 344 WDCALSUB Support Systems, Utilities and Other CALAVERAS SUBSTATION Power 344 345 ISYSCADA Support Systems, Utilities and Other INTAKE SWITCHYARD SCADA RTU Power 345 346 CALSCADA Support Systems, Utilities and Other CALAVERAS SUB SCADA RTU Power 346 347 ROPREVMTR Support Systems, Utilities and Other JEM TWO ELEMENT METER Power 347 348 ROPREVREC Support Systems, Utilities and Other ROP REVNUE METERING RECORDER Power 348 349 TISSCADA Support Systems, Utilities and Other TREASURE ISLAND SCADA RTU Power 349 350 REVMETERS Support Systems, Utilities and Other PROJECT BILLABLE REVENUE METERS Power 350 351 PRSTSCADA Priest Regulating Dam and Reservoir PRIEST RESERVOUR SCADA RTU Power 351 352 WPVSCADA Priest Regulating Dam and Reservoir WEST PORTAL VALVEHOUSE RTU Power 352 353 PRBYPASS Priest Regulating Dam and Reservoir PRIEST BYPASS SYSTEM FROM MTN TUNNEL TO GATE TOWER Joint 353 354 PRCANAL Priest Regulating Dam and Reservoir PRIEST CANAL Power 354 355 AUXBUIER Priest Regulating Dam and Reservoir PRIEST RES. AUXILIARY BUILDING ELECTRICAL ROOM Joint 355 356 AUXBUIGR Priest Regulating Dam and Reservoir PRIEST RES. AUXILIARY BUILDING GENERATOR ROOM Joint 356 357 AUXBUIMR Priest Regulating Dam and Reservoir PRIEST RES. AUXILIARY BUILDING MECHANICAL ROOM Joint 357 358 PRGTTWRMN Priest Regulating Dam and Reservoir PRIEST GATE TOWER MAIN , PRIEST Power 358 360 PRMCPWLCRDCV Support Systems, Utilities and Other PRIEST TO MOCCASIN POWER LINE ROADS Power 360 361 PRSRES Priest Regulating Dam and Reservoir PRIEST RESERVOIR Power 361 362 WESTPORTAL Priest Regulating Dam and Reservoir WEST PORTAL EQUIPMENT Power 362 363 MOCCPWTUN Priest Regulating Dam and Reservoir MOCCASIN POWER TUNNEL Power 363 364 PRIESTCOTT Priest Regulating Dam and Reservoir PRIEST COTTAGE Joint 364 365 PRIESTDM Priest Regulating Dam and Reservoir PRIEST DAM Power 365 366 PRWT1 Priest Regulating Dam and Reservoir PRIEST DOMESTIC WATER TANK Joint 366 367 MCPSTORE MOCCASIN GENERAL STORE BLDG 367
368 KPHASS KIRKWOOD P.H. AUTO SPRINKLER SYSTEM 368
369 ELSURVCAB ELEANOR-MIGUEL MEADOW SURVEY CABIN 369
370 GRP (OLD) GRANITE PORTAL LINE 370
371 JONESPOINT JONES POINT MICROWAVE COMMUNICATION SITE 371 372 JPCSBATA JONES POINT BATTERY BANK *A* (3-12 VOLT GELL CELL 372 11/16/2018 15048696_1.xlsx 7
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
373 JPCSBATB JONES POINT BATTERY BANK *B* (3-12 VOLT GELL CELL 373 374 JPCSBLDG JONES POINT COMM SITE EQUIP BUILDING 374
375 JPDISH1 JONES PIONT ANTENNA DISH PATH 1 TO DUCKWALL REPEAT 375 376 JPDISH2 JONES PIONT ANTENNA DISH PATH 2 TO INTAKE SWITCHYA 376 377 JPPVCTRLA JONES POINT PHOTOVOLTAIC CHARGER CONTROL BATTERY B 377 378 JPPVCTRLB JONES POINT PHOTOVOLTAIC CHARGER CONTROL BATTERY B 378 379 JPSOLPNLA JONES POINT SOLAR PANNELS *A* 379
380 JPSOLPNLB JONES POINT SOLAR PANNELS *B* 380
381 JPTOWER JONES PIONT TOWER STRUCTURE 381
382 JPTXALARM JONES POINT REPEATER TRANSMIT ALARM UNIT 382 383 MCPTV MOCCASIN CABLE TELEVISION SYS 383
384 OAKLAND OAKLAND EQUIPMENT AND BUILDINGS 384
385 BMIS MAINFRAME COMPUTER IN S.F. 385
386 HH-RRAS ASSETS THAT ARE RETIRED OR NO LONGER IN SERVICE 386 387 SANFRAN SAN FRANCISCO EQUIPMENT & BUILDINGS 387
388 VALDIV VALLEY DIVISION EQUIPMENT 388
389 1155MKT 1155 MARKET STREET 389
390 COLLEGE SF CITY COLLEGE 390
391 MOSCONE MOSCONE CENTER 391
392 TESCT TESLA COTTAGE 392
393 TESGAR TESLA GARAGE 393
394 TESLAFUEL TESLA PORTAL FUELING STATION 394
395 MOCCPENSRDCV Support Systems, Utilities and Other MOCCASIN CAMP PENSTOCK SOUTH SIDE ROAD CULVERT Joint 395 396 PRIESTAUXBUI Support Systems, Utilities and Other PRIEST RES. AUXILIARY BUILDING, CONTROL ROOM, SUBS Joint 396 397 PRIESTDIRDCV Support Systems, Utilities and Other PRIEST DIRT ROADS PRIEST CULVERT Joint 397 398 PRIESTDIRTRD Support Systems, Utilities and Other PRIEST AREA DIRT ROADS, PRIEST Joint 398 399 PRIESTPARDCV Support Systems, Utilities and Other PRIEST AREA PAVED ROADS, PRIEST CULVERT Joint 399 400 PRIESTPAVERD Support Systems, Utilities and Other PRIEST AREA PAVED ROADS, PRIEST Joint 400 401 PRIESTRDS Support Systems, Utilities and Other PRIEST AREA ROADS, PRIEST Joint 401 402 OSHBR Support Systems, Utilities and Other OSHAUGHNESSY TIMBER BRIDGE Joint 402 403 OSHROADS Support Systems, Utilities and Other OSH AREA ROADS Joint 403 404 CSTRGTNACRCV Support Systems, Utilities and Other PIPELINE TUNNEL RD. - CULVERTS Joint 404 405 CSTRGTNLACCR Support Systems, Utilities and Other PIPELINE TUNNEL RD. - BIRD RD TO ALAMEDA EAST Joint 405 406 DRDTOEEMRD Support Systems, Utilities and Other POWER LINE ACCESS RD - DIRT ACC. RD TO 2 TOWERS Joint 406 407 EMRYRDACCRD Support Systems, Utilities and Other PIPELINE & PWRLINE ACCESS RD (EMERY RD - BIRD RD) Joint 407 408 EMRYRDACRDCV Support Systems, Utilities and Other PIPELINE & PWRLINE ACCESS RD CULVERTS Joint 408 409 FRHYPWLACCRD Support Systems, Utilities and Other FERRETTI ROAD TO HWY 120 TOWER LINE ROADS Joint 409 410 FRHYPWLACRCV Support Systems, Utilities and Other FERRETTI ROAD TO HWY 120 TOWER LINE ROADS Joint 410 411 FTDMPRACC Support Systems, Utilities and Other MARSHES FLAT TO MOCCASIN PEAK RADIO SITE ROAD , Joint 411 412 FTDMPRACCCV Support Systems, Utilities and Other MARSHES FLAT TO MOCCASIN PEAK RADIO SITE ROAD , Joint 412 413 HYMRPWLACCR Support Systems, Utilities and Other HWY 120 TO MERRELL ROAD TOWER LINE ROADS Joint 413 414 ICPCHEL Support Systems, Utilities and Other CHERRY OIL TO ELEANOR ROAD, INTAKE /ELEANOR Joint 414 415 ICPCHELCV Support Systems, Utilities and Other CHERRY OIL TO ELEANOR ROAD CULVERT Joint 415 416 ICPCHERRY Support Systems, Utilities and Other ROAD FROM INTAKE TO CHERRY VALLEY, EARLY INTAKE Joint 416 417 ICPCHERRYCV Support Systems, Utilities and Other ROAD FROM INTAKE TO CHERRY VALLEY, EARLY INTAKE CULV Joint 417 418 ICPHILLRD Support Systems, Utilities and Other ROAD-INTAKE HILL FROM RED HILLS TO INTAKE Joint 418 419 ICPHILLRDCV Support Systems, Utilities and Other ROAD INTAKE HILLFROM RED HILLS TO INTAKE, CULVERTS Joint 419 420 ICPHPHRD Support Systems, Utilities and Other CHERRY OIL TO HPH ROAD,INTAKE/HPH ROAD Power 420 421 ICPHPHRDCV Support Systems, Utilities and Other CHERRY OIL ROADTO HPH ROAD,INTAKE/HPH ROAD CULVERT Power 421 422 ICPMATHER Support Systems, Utilities and Other ROAD FROM TOP OF INTAKE HILL TO CAMP MATHER Joint 422 423 ICPREDHILL Support Systems, Utilities and Other ROADWAY-HWY120 TO INTAKE HILL EARLY INTAKE Joint 423 11/16/2018 15048696_1.xlsx 8
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
424 ICPREDHILLCV Support Systems, Utilities and Other ROADWAY-HWY120 TO INTAKE HILL EARLY INTAKE Joint 424 425 ICPROADS Support Systems, Utilities and Other INTAKE/CHERRY/MATHER/ELEANOR AREA ROADS Joint 425 426 J59RRRPLACRD Support Systems, Utilities and Other POWER LINE ACCESS RD - RD J59 TO ROCK RIVER ROAD Joint 426 428 MCDIRTRDSCV Support Systems, Utilities and Other MOCCASIN DIRT ROADS CULVERTS Joint 428 429 MCPAVERDS Support Systems, Utilities and Other MOCCASIN AREA PAVED ROADS Joint 429 430 MCPAVERDSCV Support Systems, Utilities and Other MOCCASIN AREA PAVED ROADS CULVERTS Joint 430 431 MCPROADS Support Systems, Utilities and Other MOCCASIN AREA ROADS Joint 431 433 MCPRRGCV Support Systems, Utilities and Other MOCCASIN TO PRIEST RAILROAD GRADE , MOCCASIN Joint 433 434 MOCCPENSTSRD Support Systems, Utilities and Other MOCCASIN AREA ROADS PENSTOCK SOUTH SIDE MCP Joint? 434 435 MOCTOMARSFL Support Systems, Utilities and Other MOCCASIN TO MARSH FLAT TOWER 239S TOWER LINE Joint 435 436 MRPCPWLACCRD Support Systems, Utilities and Other MERRELL ROAD TO PRIEST TOWER LINE ROADS Joint 436 437 MRPCPWLACRCV Support Systems, Utilities and Other MERRELL ROAD TO PRIEST TOWER LINE ROADS Joint 437 438 MSJPWLACCRD Support Systems, Utilities and Other POWER LINE ACCESS RD - BIRD RD TO MISSION SAN JOSE Joint 438 439 MT5-6ACRO Support Systems, Utilities and Other MOUNTAIN TUNNEL ACCESS ROAD TO 5-6 ADIT Joint 439 440 MT5-6ACROCV Support Systems, Utilities and Other MOUNTAIN TUNNEL ACCESS ROAD TO 5-6 ADIT CULVERT Joint 440 441 RMBWPLACCRD Support Systems, Utilities and Other PIPELINE ACCESS RD - RMB TO EMERY RD Joint 441 442 RMBWPLACRDC Support Systems, Utilities and Other PIPELINE ACCESS CULVERT RD - RMB TO EMERY RD Joint 442 443 RMBWPWLACCR Support Systems, Utilities and Other POWER LINE ACCESS RD - RMB TO J59 Joint 443 444 RRRLIMPTWLRD Support Systems, Utilities and Other POWER LINE ACCESS RD - ROCK RIVER ROAD LIME PIT Joint 444 446 SFRFRPWLACV Support Systems, Utilities and Other SOUTH FORK RIVER TO FERRETTI ROAD TOWER LINE ROADS Joint 446 447 WESTPORTALRD Support Systems, Utilities and Other WEST PORTAL AREA ROADS Joint 447 448 WILRDTODACRD Support Systems, Utilities and Other POWER LINE ACCESS RD - WILMS ROAD TO DIRT ACC. RD Joint 448 449 WPPAVERDSCV Support Systems, Utilities and Other WEST PORTAL AREA PAVED ROADS CULVERT Joint 449 450 INTHSFPWLACC Support Systems, Utilities and Other TOP INTAKE HILL/ SOUTH FORK RIVER TOWER LINE ROADS Joint 450 451 MARSFLDONPCV Support Systems, Utilities and Other MARSH FLAT TO DON PEDRO TOWER 243S TO TOWER 258S Joint 451 452 MARSFLTODONP Support Systems, Utilities and Other MARSH FLAT TO DON PEDRO TOWER 243S TO TOWER 258S Joint 452 453 MOCMARSFLCCV Support Systems, Utilities and Other MOCCASIN TO MARSH FLAT TOWER 239S TOWER LINE Joint 453 454 MOCMARSFLCV Support Systems, Utilities and Other MOCCASIN TO MARSH FLAT TOWER 239S TOWER LINE Joint 454 455 PRMCPWLACCRD Support Systems, Utilities and Other PRIEST TO MOCCASIN TOWER LINE ROADS Joint 455 456 VDPLACCRD Support Systems, Utilities and Other ALL PIPELINE ACCESS ROADS Joint 456 457 ICPMATHERCV Support Systems, Utilities and Other ROAD FROM TOP OF INTAKE HILL TO CAMP MATHER CULVER Joint 457 458 V-HH-EQP Support Systems, Utilities and Other HEAVY EQUIPMENT Joint 458 459 DWTXALARM Support Systems, Utilities and Other DUCKWALL REPEATER TRANSMIT ALARM UNIT Joint 459 460 MPRRALMRX Support Systems, Utilities and Other MPR REPEATER ALARM RECEIVER Joint 460 461 MPRSCADA Support Systems, Utilities and Other MOCCASIN PEAK RADIO SITE RTU Joint 461 462 SCADA Support Systems, Utilities and Other HHWP SCADA SYSTEM Joint 462 463 SCADAMSTER Support Systems, Utilities and Other NEW L&G 6800 SCADA MASTER NA 463 464 SCADAMSTR Support Systems, Utilities and Other SCADA MASTER STATION A & B NA 464 465 SCADAMSTR-TG Support Systems, Utilities and Other SCADA MASTER, NEW TG8000 EMS SCADA NA 465 466 HHMOCCNET Support Systems, Utilities and Other PROJECT NOVELL 386 NETWORK NA 466 467 BLKNGCARR Support Systems, Utilities and Other BLOCKING CARRIER SYSTEMS Power 467 468 BORCS Support Systems, Utilities and Other BURNOUT RIDGE COMMUNICATION SITE Joint 468 469 BORMICROWAV Support Systems, Utilities and Other BURN OUT RIDGE MICROWAVE COMMUNICATION SITE Joint 469 470 COMM Support Systems, Utilities and Other HHWP COMMUNICATION SYSTEMS Joint 470 471 COMPTREQP Support Systems, Utilities and Other COMPUTER EQUIP, ELECTRONIC DEVICES & SECURITY KEYS Joint 471 472 CTSMICROWAVE Support Systems, Utilities and Other CHERRY MICROWAVE COMMUNICATION SITE Joint 472 473 CVCS Support Systems, Utilities and Other CHERRY VALLEY COMMUNICATION SITE Joint 473 474 DATACOMM Support Systems, Utilities and Other DATA COMMUNICATION SYSTEMS Joint 474 475 DUCKWALL Support Systems, Utilities and Other DUCKWALL MICROWAVE COMMUNICATION SITE Joint 475 476 DWCSBATA Support Systems, Utilities and Other COMM SITE BATTERY BANK *A* (5-12 VOLT GELL CELL BA Joint 476 477 DWCSBATB Support Systems, Utilities and Other COMM SITE BATTERY BANK *B* (5-12 VOLT GELL CELL BA Joint 477 11/16/2018 15048696_1.xlsx 9
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
478 DWCSBLDG Support Systems, Utilities and Other DUCKWALL COMM SITE EQUIP BUILDING Joint 478 479 DWDISH1 Support Systems, Utilities and Other DUCKWALL ANTENNA DISH PATH 1 TO JONES POINT REPEAT Joint 479 480 DWDISH2 Support Systems, Utilities and Other DUCKWALL ANTENNA DISH PATH 2 TO MOCCASIN PEAK REPE Joint 480 481 DWPVCTRLA Support Systems, Utilities and Other DUCKWALL PHOTOVOLTAIC CHARGER CONTROL BATTERY BANK Joint 481 482 DWPVCTRLB Support Systems, Utilities and Other DUCKWALL PHOTOVOLTAIC CHARGER CONTROL BATTERY BANK Joint 482 483 DWSOLPNLA Support Systems, Utilities and Other DUCKWALL SOLAR PANNELS *A* Joint 483 484 DWSOLPNLB Support Systems, Utilities and Other DUCKWALL SOLAR PANNEL*B* Joint 484 485 DWTOWER Support Systems, Utilities and Other DUCKWALL TOWER STRUCTURE Joint 485 486 ICPRAD Support Systems, Utilities and Other ICP RADIO BUILDING Joint 486 487 ICPRADIOSITE Support Systems, Utilities and Other EARLY INTAKE RADIO SITE Joint 487 488 IRSMICROWAVE Support Systems, Utilities and Other INTAKE MICROWAVE COMMUNICATION SITE Joint 488 489 MCPMICROWAV Support Systems, Utilities and Other MOCCASIN CAMP MICROWAVE COMMUNICATION SITE BUILDING Joint 489 490 MCPRADST Support Systems, Utilities and Other OLD MOCCASIN RADIO STATION BLDG NA 490 491 MICROCOMM Support Systems, Utilities and Other MICROWAVE COMMUNICATION SYSTEMS Joint 491 492 MPR Support Systems, Utilities and Other MOCCASIN PK. RADIO SITE Joint 492 493 MPRBLDG Support Systems, Utilities and Other MOCCASIN PK. RADIO SITE BUILDING Joint 493 494 MPRFRBBA Support Systems, Utilities and Other MPR FLOTROL RECTIFIER BATT BANK A Joint 494 495 MPRFRBBB Support Systems, Utilities and Other MPR FLOTROL RECTIFIER BATT BANK B Joint 495 496 MPRGEN Support Systems, Utilities and Other MOCCASIN PEAK RADIO SITE STAND-BY GENERATOR / LP Joint 496 497 MPRGENCU Support Systems, Utilities and Other MPR STNBY GENERATOR CTRL UNIT Joint 497 498 MPRHAL Support Systems, Utilities and Other MOCC PEAK RADIO BUILDING HALON SYS Joint 498 499 OPTICCOMM Support Systems, Utilities and Other OPTICAL FIBER COMMUNICATION SYSTEMS Joint 499 500 PPPCS Support Systems, Utilities and Other POOPENAUT PASS COMMUNICATION SITE Joint 500 501 PPPMICROWAVE Support Systems, Utilities and Other POOPANAUNT PASS MICROWAVE COMMUNICATION SITE Joint 501 502 RADIOCOMM Support Systems, Utilities and Other RADIO COMMUNICATION SYSTEMS Joint 502 503 TELCOMM Support Systems, Utilities and Other TELEPHONE COMMUNICATION SYSTEMS Joint 503 504 TRANFTRIP Support Systems, Utilities and Other TRANSFER TRIP SYSTEMS Power 504 505 WESTPORTCS Support Systems, Utilities and Other WEST PORTAL COMMUNICATION SITE Joint 505 506 PWRLNCARR Support Systems, Utilities and Other POWER LINE CARRIER SYSTEMS Power 506 507 HHKEYS Support Systems, Utilities and Other HETCH HETCHY SECURITY KEYS, MOCCASIN Joint 507 508 WSBSCADA Facilities West of Moccasin Gate Tower WARNERVILLE SHOP BLDG RTU Joint 508 509 WSYSCADA Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD SCADA RTU Joint 509 510 WSYCRB Facilities West of Moccasin Gate Tower WSY CONTROL ROOM/BUILDING, WSY Power 510 511 WSYCT Facilities West of Moccasin Gate Tower WARNERVILLE COTTAGES Joint 511 512 WSYDWS Facilities West of Moccasin Gate Tower WARNERVILLE DOMESTIC WATER SYSTEM , WARNERVILLE Joint 512 513 WSYFUEL Facilities West of Moccasin Gate Tower WARNERVILLE FUELING STATION Joint 513 514 WSYSHPS Facilities West of Moccasin Gate Tower WARNERVILLE SHOPS/OFFICE BUILDING Joint 514 515 WSY Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD/SUBSTATION Power 515 516 WSY115KVT1 Facilities West of Moccasin Gate Tower 115KV NUMBER 1 TRANSFORMER BUS Power 516 517 WSY115KVT2 Facilities West of Moccasin Gate Tower 115KV NUMBER 2 TRANSFORMER BUS Power 517 518 WSY115KVT3 Facilities West of Moccasin Gate Tower 115KV NUMBER 3 TRANSFORMER BUS Power 518 519 WSYBUSTIE Facilities West of Moccasin Gate Tower WARNERVILLE SW YARD BUS TIE 230KV Power 519 520 WSYDELG Facilities West of Moccasin Gate Tower WARNERVILLE SUB DELUGE SYSTEM Power 520 521 WSYLINE5 Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD H.V. LINE 5 Power 521 522 WSYLINE6 Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD H.V. LINE 6 Power 522 523 WSYLINE7 Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD 115KV LINE 7 Power 523 524 WSYLINE8 Facilities West of Moccasin Gate Tower WARNERVILLE SWITCHYARD 115KV LINE 8 Power 524 525 WSYPGEL2BG Facilities West of Moccasin Gate Tower WSY PGE LINE 2 BELLOTA GREGG Power 525 526 WSYPRORLY Facilities West of Moccasin Gate Tower WSY PROTECTIVE RELAYS Power 526 527 WSYSUMP Facilities West of Moccasin Gate Tower WARNERVILLE SWITCH YARD SUMP PUMP Power 527 528 WSYTB1 Facilities West of Moccasin Gate Tower 230KV NUMBER 1 TRANSFORMER BUS Power 528 11/16/2018 15048696_1.xlsx 10
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.
Major Hetch Hetchy Enterprise Existing System Assets Attachment R-3 Maximo
Record
Number
Maximo ID
Location SFPUC Facility Group Facility Classification
Maximo
Record
Number
529 WSYTB2&3 Facilities West of Moccasin Gate Tower 23OKV BUS FOR NUMBER 2&3 XFMR Power 529 530 WSYDWBFP Facilities West of Moccasin Gate Tower WARNERVILLE BACK FLOW PREVENTERS, WSY Joint 530 531 OPVSCADA Facilities West of Moccasin Gate Tower OAKDALE PORTAL VALVEHOUSE RTU Water 531 532 ARVHSCADA Facilities West of Moccasin Gate Tower ALBERS RD VALVE HOUSE SCADA RTU Water 532 533 101PJ4VH Facilities West of Moccasin Gate Tower SJPL3 and SJPL4 JUNCTION VALVEHOUSE Water 533 534 ALBERVH Facilities West of Moccasin Gate Tower ALBERS RD VALVE HOUSE Water 534 535 ALMPORTAL Facilities West of Moccasin Gate Tower ALAMEDA EAST PORTAL Water 535 536 AVH Facilities West of Moccasin Gate Tower ALAMEDA VALVE HOUSE #2 Water 536 537 CASHCRVH Facilities West of Moccasin Gate Tower CASHMAN CREEK VALVE HOUSE Water 537 538 CSTRNGTNL Facilities West of Moccasin Gate Tower COAST RANGE TUNNEL / TESLA - SUNOL Water 538 539 EMERYCOAUX Facilities West of Moccasin Gate Tower EMERY ROAD CROSSOVER AUX CONTROL BUILDING Water 539 540 EMERYCOVH Facilities West of Moccasin Gate Tower EMERY ROAD CROSSOVER VALVE HOUSE Water 540 541 FTDBRNAD Facilities West of Moccasin Gate Tower FOOTHILL TNL BROWNS TUNNEL ACCESS Water 541 542 FTDRMBE Facilities West of Moccasin Gate Tower FOOTHILL TUNNEL RED MNTN BAR EAST Water 542 543 FTDRMBSIPH Facilities West of Moccasin Gate Tower RED MNTN BAR SIPHON , RED MOUNTAIN BAR Water 543 544 FTDRMBSS Facilities West of Moccasin Gate Tower RED MNTN BAR EAST SURGE SHAFT , RED MOUNTAIN BAR Water 544 545 FTHTNLDIV Facilities West of Moccasin Gate Tower FOOTHILL TUNNEL DIVISION Water 545 546 OAKPORTAL Facilities West of Moccasin Gate Tower OAKDALE PORTAL VALVE HOUSES Water 546 547 PELICANCOVH Facilities West of Moccasin Gate Tower PELICAN CROSSOVER VALVE HOUSE Water 547 548 PELICANXOAUX Facilities West of Moccasin Gate Tower PELICAN CROSSOVER AUX CONTROL BUILDING Water 548 549 PL2THSEAUX Facilities West of Moccasin Gate Tower SJPL2, THROTTLING STATION #1, AUXILIARY Water 549 550 PL2THSWAUX Facilities West of Moccasin Gate Tower SJPL2, THROTTLING STATION #2, AUXILIARY Water 550 551 RMBGATHOU Facilities West of Moccasin Gate Tower RED MOUNTAIN BAR WEST GATE HOUSE, RMB Water 551 552 RMBSCADA Facilities West of Moccasin Gate Tower RED MTN. BAR SLIDE GATE RTU Water 552 553 ROSELCOAUX Facilities West of Moccasin Gate Tower ROSELLE AVE CROSSOVER AUX BUILDING Water 553 554 ROSELCOVH Facilities West of Moccasin Gate Tower ROSELLE AVE. CROSSOVER VALVE HOUSE Water 554 555 RR Facilities West of Moccasin Gate Tower ROCK RIVER Water 555 556 RRLSCADA Facilities West of Moccasin Gate Tower ROCK RIVER LIME PLANT RTU Water 556 557 SJCSCADA Facilities West of Moccasin Gate Tower SAN JOAQUIN PIPELINE CROSS-OVER RTU Water 557 558 SJPL Facilities West of Moccasin Gate Tower SAN JOAQUIN VALLEY PIPELINES Water 558 559 SJPL2THSE Facilities West of Moccasin Gate Tower SAN JOAQUIN PIPELINE 2, THROTTLING STATION #1 Water 559 560 SJPL2THSW Facilities West of Moccasin Gate Tower SAN JOAQUIN PIPELINE 2, THROTTLING STATION #2 Water 560 561 SJPL3THS Facilities West of Moccasin Gate Tower SAN JOAQUIN PIPELINE 3,4 THROTTLING STATION Water 561 562 SJVH Facilities West of Moccasin Gate Tower SAN JOAQUIN VALVE HOUSE Water 562 563 SJVHAUXBLDG Facilities West of Moccasin Gate Tower SAN JOAQUIN VALVE HOUSE AUXILLARY BUILDING Water 563 564 SJVSCADA Facilities West of Moccasin Gate Tower SAN JOAQUIN VALVEHOUSE RTU Water 564 565 TESCHLOR Facilities West of Moccasin Gate Tower TESLA CHLORINATION BUILDING Water 565 566 TESGENHSE Facilities West of Moccasin Gate Tower TESLA GENERATOR HOUSE Water 566 567 TESLA-HH Facilities West of Moccasin Gate Tower TESLA PORTAL EQUIPMENT AND BLDGS Water 567 568 TESPORTAL Facilities West of Moccasin Gate Tower TESLA PORTAL VALVE HOUSES Water 568 569 TESPUMPHSE Facilities West of Moccasin Gate Tower TESLA PUMPHOUSE Water 569 570 TPVSCADA Facilities West of Moccasin Gate Tower TESLA PORTAL VALVEHOUSE RTU Water 570 571 TSLDWS Facilities West of Moccasin Gate Tower TESLA DOMESTIC WATER SYSTEM Water 571 572 TSLSEWSYS Facilities West of Moccasin Gate Tower TESLA PORTAL SEWAGE SYSTEM Water 572 573 TUTF Facilities West of Moccasin Gate Tower TESLA ULTRAVIOLET TREATMENT FACILITY Water 573 574 TUVH Facilities West of Moccasin Gate Tower TESLA ULTRAVIOLET VALVE HOUSE Water 574 575 VDHHSHAFT Facilities West of Moccasin Gate Tower HETCH HETCHY SURGE SHAFT Water 575 576 VDOAKOVR Facilities West of Moccasin Gate Tower FTHL TNL OAKDALE PORTAL OVERFLOW SHAFT Water 576 577 VDPEDROADT Facilities West of Moccasin Gate Tower FOOTHILL TNL PEDRO ACCESS Water 577 578 VDRMBW Facilities West of Moccasin Gate Tower RED MNTN BAR WEST Water 578 11/16/2018 15048696_1.xlsx 11
DRAFT--Contact the Office of the City Clerk at (408) 535-1260 or [email protected] for final document.