Agenda packet — City Council and Authorities Concurrent, April 19, 2022 (part 3 of 8)

Water
1 $ 435,639,907
2 $ (32,526,143)
3 $ 62,771,153
$ 465,884,917
4 $ 16,928,503
$ 482,813,420
5 70.1%
$ 326,585,327
6 $ 11,866,881
$ 338,452,207

5.13%
25 Hetch Hetchy
$ 66,135,724
$ . (3,598,189)
$
$ 62,537,535
$ 5,807,023
$ 68,344,558 $ 551,157,978

64.2%
$ 40,149,098 $ 366,734,424
$ 3,728,109 $ 15,594,989
$ 43;877,206 $ 382,329,414
$ 2,004,277 $

5.13%
25 259,836 $
3,118,033 $
2,264,113
$ 24,051,326 27,169,359
Water Assets
$ 57,382,744
$ 3,679,415
$ 1,708,994
$ 62,771,153
$
4/17/2009
ATTACHMENT K-2

WHOLESALE CUSTOMERS' SHARE OF THE BOOK VALUE OF REVENUE FUNDED CAPITAL EXPENDITURES *'PRELIMINARY-TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES*' (Section 5.03)
Ill 12) 13) 14) IS] 16] 17] IBJ [9]
Project CWIPasof FY 2008-09 Reduction for CWIPas Water Related Wholesale No. Pfoject Description Rate Class 6/30/08 Expenditures 02A Funding 6/30/09 CWIP Share A. Water Enterprise
Regional Projects
CUW352 Alameda Creek Fishery Joint s 2,007,607 s 224,582 s 2,232,189 s s CUW353 Seismic Upgrade @ Hayward Fault Joint s 3,129,234 s 1,967,625 s 5,096,859 s s CUW354 LOWER CRYSTAL SPRINGS DAM-REV-SFWD Joint s 7,046,944 $ 1,086,262 $ 8,133,206 $ $ CUW355 STANDBY POWER FACILITIES Joint $ 3,715,276 $ 6,596,849 $ 10,312,125 $ $ CUW357 Adit Leak Repairs Joint $ 783. $ 1,129 $ 1,912 $ $ CUW359 Irvington Tunnel Joint $ 21,391,129 $ 5,176,713 $ 26,567,842 $ $ CUW359 Joint $ 7,837,176 s $ 7,837,176 $ $
CUW361 Joint $ 368,057 $ 1,383,959 $ 1,752,016 s $
CUW361 Joint $ 1,255,545 $ $ 1,255,545 $ $
CUW361 Pulgas Balancing Reservoir Joint $ 1,248,002 $ $ 1,248,002 $ $ CUW361 Joint s 570,179 s $ 570,179 $ $
CUW36J Joint s 712.921 s -· s 712,921 $ $
CUW363 SCADAPhase II Joint s 1,335,371 s 1,738,045 s 3,073,416 $ $ CUW363 Joint s 1,062,050 $ s 1,062,050 $ $
CUW365 Cross Connection Control Joint s 3,635,172 s 547,801 $ 4,182,973 $ s Capitalized in FY 200~-09 CUW367 HTWTP LT lmpr Joint s 8,011,348 s 2,479,731 $ 10,491,079 $ $ CUW368} . , Joint s 23,640,601 $ s 23,640,601 $ $
CUW368 BDPL Hydraulic Capacity Joint $ 17,556,905 $ 4,200,442 $ 21,757,347 $ $ CUW368 Joint $ 2,579,847 $ $ 2,579,847 $ $
CUW370 Pipeline Readiness Joint $ 5,320,934 $ 328,070 $ 5,649,004 s $ CUW371 CSPS and Pipeline Joint $ 11,420,770 $ 3,872,779 $ 15,293,549 s $ CUW372 University Mound (N) Joint $ 4,624,981 $ 1,068,147 $ 5,693,128 $ $ CUW373 }SJPL Joint $ 19,479,341 $ 6,023,849 $ 25,503;190 $ $ CUW373 Joint $ 7,199,051 $ $ 7,199,051 $ $
CUW374 Joint s 31,171,669 $ 4,314,430 $ 35,486,099 s $ Calaveras Dam CUW374 Joint s 2,366,343 s s 2,366,343 $ $ CUW378 CSPL #2 Joint $ 7,453,098 $ 913,369 $ 8,366,467 $ $ CUW379 SAPL #3 Joint $ 5,728,934 $ _588,346 s 6,317,280 $ $ CUW380 BDPK #3&4 Crossovers Joint s 3,855,357 $ 1,083,888 $ 4,939,245 $. $ CUW381} . Joint $ 5,450,995 $ $ 5,450,995 s s CUW381 SVWTP Expansion Joint $ 53,222 s 3,090,520 $ 3,143,742 $ $ CUW381 · Joint s 97,373 s $ 97,373 $ $
CUW382 SVWTP Treated Water Reservoir Joint $ 5,799,505 $ 575 $ 5,800,080 $ $ ·cuw3B4 Tesla Joint s 6,102,621 $ 7,444,942 $ 13,547,563 s $ CUW386 SAPS X-CONNECT & PUMP IMP 96A UEB Joint s 1,374,491 $ 971,625 $ 2,346,116 $ $ CUW388}PEIR Joint s 896,476 s 1,641,717 $ 2,538,193 s $ CUW388 Joint s 1,331,676 s s 1,331,676 $ s CUW390 Desalination Pilot Joint $ 175,165 s $ 175,165 $ $ CUW391 Baden/San Pedro Valve Lots Joint $ 3,964,642 $ 948,589 s 4,913,231 s $ CUW392 Program Management Joint s 2,452,297 s 5,081,444 $ 7,533,741 $ s CUW393 BDPL #4 Condition Assessment Joint s 25.071 $ 294,634 s 319,705 $ $ CUW394 Watershed Envirof!ient Improvement Joint $ 142,924 s 96,027 $ 238,951 $ $ Capitalized in FY 2008-09 CUW101 SAN ANDREAS PLANT EXPANSION #1 Joint $ 182 s 96,027 $ 96,209 s 67,443 CUWlll LOWER CRYSTAL SPRINGS DAM-REV-SFWD Joint $ 40,436 s $ 40,436 $ 28,346 CUW151 Baden PS Joint $ 921 $ 26,760 $ 27,681 $ 19,404
CUW161 Water Treatment Facilities Joint s 75,801 s 605 s 76,406 $ 53,561 CUW178 SAPS X-CONNECT & PUMP IMP 96A UEB Joint $ 104,902 s s 104,902 $ 73,536 CUW202} Joint $ 50,808 s ~ 50,808 $ 35,616
CUW202 Replace PCCP Joint s 285,003 s 64,256 $ 349,259 $ 244,831 CUW202 Joint s 2,365 $ $ 2,365 $ 1,658
CUW127 SCADA Joint s 50,029 s 2,481.274 $ 2,531,303 $ 1,774,443 CUW356 New Crystal Springs BypaSs Tunnel Joint $ 13,992,264 s 5,560,862 16,028,397 s 3,524,729 $ 2,470,835 CUW358 Sunset (N) Joint s 52,494,764 s 4,887,980 55,806,081 $ 1,576,663 s 1,105,241 Capitalized in FY 2008-09 CUW387 Tesla Portal Disinfection Joint s 2,377,262 $ (1,996) 1,223,945 $ 1,151,321 s 807,076 c=m1 Joint s 45,413 s s 4.5,413 $ 31,835
. CUW135 New Lines and Bypass Valves Joint $ 153,983 s 620,156 s 774,139 s 542.671 CUW135 Joint s 8,860 s s 8,860 s 6,211
CUW143 Joint s 5,656 $ s 5,656 $ 3,965
CUW143 HH Water Treatment Plan Joint $ 709,972 s 8,817 s 718,789 s 503,871 CUW143 Joil1t s 96,292 s s 96,292 s 67,501
CUW186 SVWTP IMPROVEMENT PROJECT-CP~-SFWD Joint s 3,604 $ $ 3,604 s 2,526 CUW206} Joint $ 4,365 s s 4,365 s 3,060
CUW206 Tesla Portal/Thomas Shaft Emergency Disinfection Joint s 283,620 s 5,665 s 289,285 $ 202,7.89 CUW206 Joint $ 227,004 s $ 227,004 $ 159,130
CUW231 Millbrae labs Joint s 81,856 s 34,685 $ 116,541 s 81,695 CUW236 TELSA/SJVH WQ MONITORING IMPR Joint s 152,963 $ $ 152,963 $ 107,227 CUW366} · Joint s 16,523 $ $ 16,523 $ 11,583
CUW366 HTWTP ST Improvements Joint s 1,398,798 $ 5,732,626 7,131,424 $ s CUW366 . Joint s 1,452,901 s 1,452,901 $ s CUW120 WATER QUALITY PLANNING STUDY Joint s 577 s $ 577 s 404 CUW164 WATER VULNERABILITY STUDY-UEB Joint s 479 $ $ 479 s 336 CUW18l STANDBY POWER FACILITIES Joint $ 5,905 s s 5,905 s 4,139 CUW2J0 Millbrae Administrative Bldg Remodel Joint s 7,803 s 321,553 s 329,356 s 230.879 CUW220 Calaveras Dam Evaluation Joint s 308,971 s $ 308,971 s 216,589 . CUW227 Watershed Facilities and Fencing Joint s 190.552 $ 206,448 s 397,000 s 278,297 CUW228 Watershed Roads Joint s 358,434 $ 85,337 s 443,771 s 311,083 CUW232 Crystal Springs Dam Discharge Joint s 363,823 s $ 363,823 s 255,040 CUW242} I". f Joint s 311,548 s 22,741 s 334,289 s 234,337 Demo 1t1on o Unsafe Structures CUW242 Joint s 315 s s 315 s 221 CUW261 Regional R&R - Storage Joint s 275,694 $ 277,958 $ 553,652 s 388,110 CUW262} . Joint $ 1,236,895 $ 409,282 s 1,646,177 s 1,153,970 Regional R&R - Treatement CUW262 Joint s 277,383 s s _277,383 s 194.445 _Page 2 of 2 4/17/2009
ATTACHMENT K-2

WHOLESALE CUSTOMERS' SHARE OF THE BOOK VALUE OF REVENUE FUNDED CAPITAL EXPENDITURES **PRELIMINARY· TO BE SUBSTITUTEO WITH FINAL 6/30/09 VALUES** (Section 5.03)
Ill 12) (3J 14] [SJ [6J [7J [BJ [9J
Project CWIPasof FY 2008-09 Reduction for CWIPas Water Related Wholesale No. Project Description Rate Class 6/30/08 Expenditures 02A Funding 6/30/09 CWIP Share Cuwis3 ]Regional R&R - Transmission Joint s 768,422 s 797,659 s 1,566,081 s 1,097,823 CUW263 · Joint s 1,224,094 s s 1,224,094 $ 858,090
CUW360 PLANNING -WSTD Sunol Quarry Reservoirs Joint s 2,513 s $ 2,513 $ 1,762 CUW934 BOA/BAW/13/F2/SFWD-CONT PROJ-OPER FD Joint $ 59,479 $ (2,210J 998,005 s (940,736J s (659,456) TOTAL REGIONAL WATER PROJECTS $ 313,100,517 $ 84,802,574 ·$379,397,925 $ 18,505,166 $ 12,972,121 less Projects to1 be Capitalized in FY 2008-09 $ 1,576,663 $ 1,105,241 ADJUSTED TOTAL REGIONAL WATER PROJECTS $ 16,928,503 $ 11,866,881 Wholesale Direct
None

8. Hetch Hetchy Water&_ Power
CUH703 Priest Reservoir By-pass Joint 47,164 s 47,164 s 21,224 $ 13,626 CUH762 SJPL Reparis Water 53,616 255,011 s 308,627 $ 308,627 $ 198,139 CUH766 HH Security Improvements Joint 164,478 · 261,601 s 426,079 $ 191,736 s 123,094 CUH767 Power Transformers Power s $ s CUH803 Street Lights Power 40,506 $ 40,506 $ s CUH804 HH Roads Joint 341,240 s 341,240 s 153,558 s 98,584 CUH829 HH SCADA Joint s s s CUH842 Moccasin Cottages Renovations Joint· s $ $ CUH846 New Moccasin Penstock Power 543,073 $ 543,073 $ $ CUHBSl Turbine Generator Renovations Power 111,755 926,254 $ 1,038,009 $ s CUHB68 Moccasin Energy Absorber Power $ $ $ CUH876 Moccasin Phone System Joint 15,677 s 15,677 $ 7,055 s 4,529 CUH878 O'Shaugnessy Discharge/Toulumne River Chan.nel lmpr. Joint 31,953 168,076 $ 200,029 $ 90,013 $ 57,788 CUHB91 Metering Muni Load Power 18 4,361 $ 4,379 $ $
CUHB93 Cherry/Eleanor Pump Upgrade Power 17,012 $ 17,012 $ $ CUH896 Street Lights Power 9,294 568,794 $ 578,088 $ $
CUH899 Canyon Tunnel Penstock Power 6,210 21,804 s 28,014 $ $ CUH915 UG Assessment/Hunters Point Power 961,755 ; 1,668,663 $ 2,630,418 $ $ ·cuH926 Pipe Purchase Water · 13,667 $ 13,667 $ 13,667 $ 8,774 CUH93l Microwave Replacement Joint 3,157,491 156,270 $ 3,313,761 s 1,491,192 $ 957,346 CUH932 HH SCADA Joint $ $ $
CUHB25 Distribution System Power 446,419 109,797 $ 556,216 $ $ CUH941 HHP SCADA Security & Control, East/O'Shaugnessy Joint 1,433,974 246,948 $ 1,680,922 $ 756,415 $ 485,618 CUH942 O'Shaugnessy Dam Discharge Needle Valves joint $ $ $ CUH943 Renewable Energy Power $ s $
CUH9.45 SJPL Crossovers Water $ $ s CUH946 Facility ,Maintenance Joint 239 $ 239 $ 108 $ 69 CUH947 Sustainable Energy Account Power 441,226 1,838,396 $ 2,279,622 $ $ CUH948 Facility Maintenance -Transmission Lines Power 70,631 101,295 $ 17\,926 $ $ CUH949 POW Maintenance Power $ $ $
CUH950 HPH/KPH/MPH Power 1,236,853 1,167,621 $ 2,404,474 $ $ CUH955 Solar Monitoring Power 222 $ 222 $ $
CUH956 Facility Maintenance - Gate Valves Water 275,213 $ 275,213 $ 275,213 $ 176,687 CUH957 Moccasin Corrison Control Joint 48,023 110,986 $ 159,009 $ 71,554 s 45,938 CUH958 Generation Metering Power 18,811 s 18,811 $ $
CUH959 Moccasin Reservoir Water Quality Water 109,379 $ 109,379 $ 109,379 $ 70,221 CUH960 Solar Power Project Power 6,48~ (5,333) $ 1,147 $ $ CUH861 MECA Solar Power 26,369 s 26,369 $ s CUH962 SF Electrical Reliability Power 9,672,565 2,653 $ 9,675,218 $ $ CUH964 Watershed Lan Purchase Water 75,756 $ 75,756 $ 75,756 $ 48,635 CUH966 MECA - Demand Reduction Power $ $ $
CUH969 SFIA SCADA Power $ $ $
CUH971 Neward - CCSF Tran mission Project Power 235,120 54,602 $ 289,722 $ $ CUH972 Load Metering Power 145,039 1,274 $ 146,313 $ $
CUH973' Distribution Assessment Power $ $ $
CUH975 Hetch Hetchy Water R&R Power 130,100 $ 130,100 $ $ CUH975 'Hetch Hetchy Water R&R Water 52,613 516,524 $ 569,137 $ 569,137 $ 3°65,386 CUH975 Hetch Hetchy Water R&R Joint 999,854 887,864 $ 1,887,718 $ 849,473 $ 545,362 CUH976 KPH Rewind Power 1,053,295 1,417,914 $ 2,471,209 $ $ CUH977 Facilities Maintenance - Water Joint 770,839 1,049,878 $ 1,820,717 $ 819,323 $ 526,005 CUH978 Community Choice Aggregation Power 5,571 101,075 $ 106,646 $ $ CUH979 Hunters Point Distribution Power 1,926,977 532,011 $ 2,458,988 $ $ CUH981 Shore Power for Cruise Ships Power 2,690 $ 2,690 $ $ CUH986 SEA - Energy Efficiency Power 15,262 $ 15,262 $ $ CUW687 525 Golden Gate Joint 4,105 $ 4,105 $ 1,847 $ 1,186 IUH004 Auto Maintenance Joint 3,882 $ 3,882 f 1,747 $ 1,122 PUHSOl SF Environment Energy/Green Power Power 66,107 $ 66,107 $ $ PYEAES Youth Employment Joint $ $ $
TOTAL HHWP PROJECTS 23,987,888 12,964,974 36,952,862 5,807,023 $ 3,728,109 C TOTAL COMBINED WATER AND HHWP $ 337,088,405 $ 97,767,548 $379,397,925 55,458,028 $ 15,594,990 Noles
6/30/08 CWIP per FAMIS
. FY 2008-09 Expenditures posted through 3/20/09 per FAMIS

3. Wholesale share of CWIP.70.1'¼ {see Note 5 Attachment K-1)

4. Water Related HHWP CWIP includes 100% of Water and 45% of Joint

5. Wholesale share of CWIP 64.2% {see Note S Attachment K-1)

6. Fund 2A expenditures are funded by Series 2006A bond proceeds, proceeds of commercial paper redeemed from 2006A proceeds and earnings on such proceeds, as applicable;

Page 3 of 2 ends

ATTACHMENT K-3
25 VEAR PAYOFF SCHEOULE FOR EXISITING RATE BASE

WATER ENTERPRISE REGIONAL ASSETS AND ONE DIRECT WHOLESALE ASSET **PRELIMINARY - TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES** (Section 5.03)
Water Assets
6/30/09 Wholesale Share of Net Plant & CWIP (Attachment K-1) 338,452,207 Interest Rate: 5.13%
Term: 25
Monthly Principal & Interest Calculation: 2,004,277
Annual Wholesale Revenue Requirement: 24,051,326
Fiscal Yr Annual Year End
Ending Principal Interest Payment (Wtr) Balance
Jun-10 6,848,259 17,203,067 24,051,326 331,603,948
Jun-11 7,207,954 16,843,372 24,051,326 . 324,395,994
Jun-12 7,586,541 16,464,785 24,051,326 316,809,453
Jun-13 7,985,013 16,066,313 24,051,326 308,824,439
Jun-14 8,404,415 15,646,911 24,051,326 300,420,024
Jun-15 8,845,844 15,205,482 24,051,326 291,574,180
Jun-16 9,310,459 14,740,867 24,051,326 282,263,721
Jun-17 9,799,478 14,251,848 24,051,326 272,464,243
Jun-18 10,314,181 13,737,145 24,051,326 262,150,062
Jun-19 10,855,919 13,195,407 24,051,326 251,294,143
Jun-20 11,426,110 12,625,216 24,051,326 239,868,033
Jun-21 12,026,250 12,025,076 24,051,326 227,841,784
Jun-22 12,657,911 11,393,415 24,051,326 215,183,873
Jun-23 13,322,749 10,728,577 24,051,326 201,861,123
Jun-24 · 14,022,507 10,028,819 24,051,326 187,838,616
Jun-25 14,759,019 9,292,307 24,051,326 173,079,597
Jun-26 15,534,215 8,517,111 24,051,326 157,545,382
Jun-27 16,350;127 7,701,199 24,051,326 141,195,254
Jun-28 17,208,894 6,842,432 24,051,326 123,986,361
Jun-29 18;112,766 5,938,560 24,051,326 105,873,594
Jun-30 19,064,113 4,987,213 24,051,326 86,809,482
Jun-31 20,065,428 3,985,898 24,051,326 66,744,054
Jun-32 21,119,335 2,931,991 24,051,326 45,624,719
Jun-33 22,228,597 1,822,729 24,051,326 23,396,122
Jun-34 23,396,122 655,204 24,051,326 0
Totals: 338,452,207 262,830,943 601,283,150
Water . Page 4 of 1 4/17/2009
ATTACHMENT K-4
25 YEAR PAYOFF SCHEDULE FOR EXISTING RATE BASE
HETCH HETCHY WATER ASSETS AND WATER-RELATED PORTION OF JOINT AS~ETS **PRELIMINARY-TO BE SUBSTITUTED WITH FINAL 6/30/09 VALUES** (Section 5.03)
Hetch Hetchy
6/30/09 Wholesale Share of Net Plant & CWIP (Attachment K-1) 43,877,206 Interest Rate: 5.13%
Term: 25
Monthly Principal & Interest Calculation: 259,836
Annual Wholesale Revenue Requirement: 3,118,033
Fiscal Yr Annual Year End
Ending Principal · Interest Payment (HH) Balance
Jun-10 887,814 2,230,219 3,118,033 42,989,393
· Jun-11 934,445 2,183,588 3,118,033 42,054,948
Jun-12 983,525 2,134,507 3,118,033 41,071,423
Jun-13 1,035,183 2,082,849 3,118,033 ,40,036,239
Jun-14 1,089,555 2,028,478 3,118,033 38,946,685
Jun-15 1,146,782 1,971,250 3,118,033 37,799,903
Jun-16 1,207,015 1,911,017 3,118,033 36,592,887
Jun-17 1,270,412 1,847,621 3,118,033 35,322,475
Jun-18 . 1,337,138 1,780,.894 3,118,033 33,985,337
Jun-19 1,407,370 1,710,663 3,118,033 32,577,967
Jun-20 1,481,290 1,636,743 3,118,033 31,096,678
Jun-21 1,559,092 1,558,940 3,118,033 29,537,585
Jun-22 1,640,981 1,477,051 3,118,033 27,896,604
Jun-23 1,727,172 1,390,861 · 3,118,033 26,169,432
Jun-24 1,8i7,889 1,300,144 3,118,033 24,351,544
Jun-25 1,913,371 1,204,662 3,118,033 22,438,173
Jun-26 2,013,868 1,104,165 3,118,033 20,424,305
Jun-27 2,119,643 998,389 3,118,033 18,304,662
Jun-28 2,230,974 887,058 3,118,033 16,073,688
Jun-29 2,348,153 769,880 3,118~033 13,725,535
Jun-30 2,471,486 · 646,546 3,118,033 11,254,048
Jun-31 2,601,298 516,735 3,118,033 8,652,751
Jun-32 2,737,927 380,106 3,118,033 5,914,824
Jun-33 2,881,733 236,300 3,118,033 3,033,091
Jun-34 3,033,091 84,941 3,118,033 0
43,877,206 34,073,607 77,950,813
Hetch Hetchy Page 5 of 1 4/17/2009
ATTACHMENT K-5

UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS CONSTRUCTION WORK IN PROGRESS AS OF MARCH 30, 2009
. (Section 5.04)
Appropriatio YTD PTO Available
Project Project Title Fund T~pe Subfund Classification n Exeenditures Expenditures Encumbrances Balances Notes Water Assets
CUW257 WATERSHED PROTECTION SW AAAACP REGIONAL 1,448.720 29,653 413,529 141.643 893,548 CUW250 WATERSHED TRAILS&RECREATION IMPRO' SW AAAACP REGIONAL 387.639 9.431 112.689. 6.675 268,275 CUW261 REGIONAL WATER STORAGE RNR -BUDGEl SW AAAACP REGIONAL 1.750,000 250,970 526,664 26,687 1,196,648 Annual R&R CUW242 DEMOLITION UNSAFE STRUCTURES SW AAAACP REGIONAL 1,000,000 22,647 407,820 21,524 570,656 CUW263 CONVEYANCErrRANSMISSION - BUDGET SW AAAACP REGIONAL 7,825,000 763,603 3.378.543 125,990 4,320,466 Annual R&R CUW264 WATERSHED ROADS· BUDGET SW AAAACP REGIONAL 3.000,000 77,074 1,391,500 162,401 1.446,099 Annual R&R CUW262 TREATMENT FACSIWQ IMPROVE-BUDGET SW AAAACP REGIONAL 4,801,000 399,073 2,704,204 349,016 1,747,780 Annual R&R CUW168 ALAMEDA CREEK FISH RELEASE SW AAAACP REGIONAL 1,537,398 46,624 1,040,919 152,647 343,832 CUW231 MILLBRAE LAB CAPITAL IMPROVEMENTS SW AAAACP REGIONAL 770,000 19,119 532,135 0 237,865 CUW227 WATERSHED FENCES/FACILITES SW AAAACP REGIONAL 3,000,000 206,222 2,223,776 581,926 194,298 CUW253 FACILITIES SECURITY PROJECT SW AAAACP REGIONAL 5,300,000 73,048 4.146,944 113,124 1,039,931 CUW210 MILLBRAE ADMIN BLDG INTERIM REMODEL SW AAAACP REGIONAL 2,407,700 284,902 1,935,204 160 472,337 CUW228 WATERSHED ROADS RECONSTRUCTION SW AAAACP REGIONAL 5,170,000 82,992 4,413,061 18.598 738,340 CUW202 SAN ANTONIO PIPELINE EMERGENCY REPP SW AAAACP REGIONAL 1,400.000 6,012 1,269.190 61.727 69,083 CUW148 ENVIRONMENTAL & REGULATORY COMP SW AAAACP REGIONAL 3,241,279 0 3,014,995 184,774 41,510 CUW135 NEW LINE & BYPASS VALVES SW AAAACP REGIONAL 4,829,680 2,103 4,689,067 0 140,613 CUW143 HETCH HETCHY WATER TREATMENT PLAN SW AAAACP REGIONAL 18,821,529 0 18,452,053 47,947 321,529 CUW161 TREATMENT FACILITIES IMPROVEMENTS SW AAAACP REGIONAL 15,028,319 334 14,747,873 0 280.446 CUW241 FACILITIES MAINT SUPPORT STRUCTURES SW AAAACP REGIONAL 5,000,000 8,390 4,988,882 0 11,118 CUW392 PROGRAM MANAGEMENT SERVICES - WSIF SW AAAACP LOCAUREGIONAL 1,837,000 (98,519) 751,659 71,973 1,013,368 CUW127 INST SCADA SYSTEM SW AAAACP LOCAUREGIONAL 13,156,681 2,481,274 8,653,641 0 4,503,040 CUW710 OCIP PROJECT CONTROL SW AAAACP LOCAUREGIONAL 2,497,881 235,706 2,496,959 0 922 TOTAL ALL PROJECTS 104,209,826 4,900,661 82,291,307 2,066,813 19,851,706 LOCAL PROJECTS LOCAL 0 0 0 0 0
JOINT LOCAL AND REGIONAL PROJECTS LOCAUREGIONAL 17,491,562 2,618,462 11,902,259 7.1,973 5,517,330 REGIONAL PROJECTS REGIONAL 86,718,264 2,282,199 70,389,048 1,994,840 14,334,376 TOTAL ALL PROJECTS 104,209,826 4,900,661 82,291,307 2,066,813 19,851,706 Hetchy Hetchy Assets
CUH975 WATER INFRASTRUCTURE-BUDGET ST AAAACP WATER 9,000,000 1,534,488 2,806,592 3,565,023 2,628,385 CUH964 WATERSHED PROPERTY PURCHASES ST AAAACP WATER 800,000 75,756 454,756 0 345,244 CUH957 FAC MAINTENANCE-WATER TRANSPORTAT ST AAAACP WATER 3,400,000 110,986 2,885,394 209,138 305,<169 CUH703 PRIEST RESERVOIR DIVERSION CHANNEL ST AAAACP WATER 21,210,344 47,164 20,166,993 0 1,043,351 CUH926 PIPELINE PURCHASE REPLACEMENT PIPE ST AAAACP WATER 159,860 13,667 157,489 0 2,371 CUH762 SAN JOAQUIN PIPELINE REPAIRS ST AAAACP WATER 41,469,206 255,011 41,215,761 134,652 118,792 CUW687 525 GOLDEN GATE ST AAAACP JOINT 280,600 4,105 26,437 0 254,163 CUH977 FACILITIES MAINTENANCE - BUDGET ST AAAACP JOINT 9,300,000 1,049,878 3,578,478 803,231 4,918,290 CUH931 HH MICROWAVE REPLACEMENT ST AAAACP JOINT 4,767,000 156,270 3,313,761 1,227,242 225,997 CUH941 HH SCADA SECURITY & CONTROL, EAST ST AAAACP JOINT 2,068,180 246,948 1,680,922 256;198 131,060 CUH804 HETCH-HETCHY ROADS REBUILDING ST AAAACP JOINT 4,175,027 341,240 3,544,483 113,314 517,230 CUH766 HETCHY FACILITIES SECURITY IMPROV. ST AAAACP JOINT 2;086,692 261,601 1,960,386 62,470 63,836 CUH876 MOCCASIN PHONE SYSTEM ST AAAACP JOINT 1,610,000 15,677 1,528,780 0 81,220 CUH878 O'SHAUGENESSY DIS.REPAIRS ST AAAACP JOINT 7,179,009 33,750 7,101,644 9,297 68,068 CUH810 VARIOUS OLD JOB ST AAAACP JOINT 7,613,638 18,690 7,538,034 1,561 74,044 CUH946 FAC MAINTENANCE-SUPPORT STRUCTURE ST AAAACP JOINT 2,281,454 :·239 2,273,485 0 7,969 CUH949 RIGHT OF WAY MAINTENANCE ST AAAACP JOINT 815,000 0 814,208 166 626 TOTAL A_LL PROJECTS 118,216,010 4,16_5,470 101,047,602 6,382,292 10,786,117 POWER PROJECTS POWER 0 0 0 0 0
WATER PROJECTS WATER 76,039,410 2,037,072 67,686,985 3,908,812 4,443,613 JOINT PROJECTS JOINT 42,176,600 2,128,397 33,360,617 2,473,480 6,342,504 TOTAL All PROJECTS 118,216,010- 4,165,470 101,047,602 6,382,292 10,786,117 1891569.2 Revised Attachment K-1
... l
.
---j
1 i
REVISED ATTACHMENT K-1

WHOLESALE CUSTOMERS' SHARE OF NET BOOK VALUE OF EXISTING ASSETS AS OF JUNE 30, 2009
(Section 5.03)
Notes Water Hetch Hetchi'.

Regional System Net Plant as of 6/30/09 1, 5 $485,580,249 1 $63,528,861 2 Regional Cor:istruction-Work in Progress as 6/30/09 2 $35,072,164 3 $7,507,984 3 Total Net Plant and Construction Work In Progress $520,652,413 $71,036,845 Regional System ·Allocation Factor 3 70.1% 64.2%
Wholesale Share of Regional System Net Plant $340,391 ,755 $40,785,529 Wholesale Share of Construction Work fn·Progress 4 $11 ,025,550 $4,820,126 Total Wholesale Share· of Net Plant and CWIP $351 ,417,305 $45,605,655 Interest Rate 5.13% 5.13%
Term (Yrs) 25 25
Monthly Principal & Interest $2,081 ,055 $270,072
Annual Wholesale Revenue Requirement Amouot $24,972,661 $3,240,861 Notes

1. FAACS 120D Report as of6/30/09

2. CWIP based on balance as 6/30/09, with adjustments from the Agreed~Upon Procedures Report. See K-2 fo'r details.

3. Fixed allocation factors based on dollar weighted 5-year average of J-Table allocation factors (2003-04 through 2007~08) Total
$549,109,110
$42,580,148
$591 ,689,258
$381,177,284
. $15,845,676
$397,022,960
$2,351,127
$28,213,522

4. Projects CUW127 SCADA, CUW687/934 525 Golden Gate, and CUW690 Customer Care and Billing are specially allocated, see K-2 for details

5. A round_ing difference of $3,846 was identified by the SFPUC relating to various cumulative prior year differences in net utility plant.

Under Se~_lon 5.030, the Parties agreed that the Wholesale Customers' share of net book values of existing regional assets . as of 06/30/2008 are accurate. However, to match Attachment K to the FY08-09 Audited SRRC, the SFPUC will credit the 1984 Balancing Account for $79.

Original Rate Base, FYOB-09 SRRC
Adjusted Rate Base
1984 Balancing Account Credit
$19,367,641
$19,367,562
$79
APPROVED IN ACCORDANCE WITH ARTICLE V, SECTION 5.03D OF THE WATER SUPPLY AGREEMENT BETWEEN THE CITY & COUNTY OF SAN FRANCISCO & WHOLESALE CUSTOMERS:

CITY AND COUNTY OF SAN FRANCISCO
Date: S { + , 2011

BAY AREA WATER SUPPLY AND CONSERVATION AGENCY
Acting on behalf of the Wholesale Customers
By:--->4,,<W\......:.z:::AU=Jl-'--H"='Aa...=;;..._;: Arthur R. Jensen . ~F ·- General Manager
Date: 5/ ;f: , 2011

Page 1 of 4 ends

Revised Attachment K-2
J
\
,;
J
9 REVISED ATTACHMENT K-2 ·

WHOLESALE CUSTOMERS' SHARE OF REVENUE FUNDEO CAPITAL EXPENDITURES CONSTRUCTION WORK IN PROGRESS AS OF JUNE 30, 2009
-1
(Section 6,03)
(1) (2) (3) (4) (4a) (4b) (5) (6) i Adjusted
7 Rate CWJP asor CWIPas of Waler Related Wholesale
j
Project No. Project Description Class 6130/09 Adjustments 06130/09 CWJP Share Funding Source/ Notes A. Water Enterprise

1. Regional Projects
CUW111/112 Lower Crystal Springs Dam Joint 52,615 0 52,615 36,8B3 ACP/ll6A CUW127 SCADA Joint 30,952 0 30,952 13,951 ACP/98A Spi!I 64.3%/35.Q¾JoinVCity CUW135 New Lines and Bypass Valves Joint 69,818 (6,018) - 63,800 44,724 98A CUW143 HH Waler Treatment Joint 1,157 (1,157) 0 0 ACP
CUW168 Alameda HCP -EIS/EIR Joint 26,428 0 26.428 18,526 ACP CUW181 Standby Power Facilifies Joint 5,905 0 5,905 4,139 ACP CUW202 Replace PCCP Joint 414,754 o. 414,754 290,743 ACP/96N98A CUW206 Thomas Shaft Roadway Joint 530,329 0 530,329 371,761 96N988 CUW208 Lawrence-Livermore CiJy 0 0 0 0 ACP
CUW220 Calaveras Dam Evaluation Joint 308,971 0 308,971 216,588 ACP CUW227 Watershed Facilities and Fencing Joint 235,658 D 235,658 165,196 ACP CUW228 Watershed Roads Joint 443.771 0 443,771 311,083 ACP CUW231 Millbrae labs lmprovemanl Joint 58,081 0 58,081 40,715 ACP/98B CUW238 Tesla/SJVH WO Monitoring· Joint 5,596 (5,596) 0 0 98B CUW242 DemoliUon or unsafe S!rlJclures ·Joint 2,534 0 2,534 1,m ACP CUW248 SunoVNiles Dam Removal Joint 81,111 D 81,111 56,859 ACP CUW253 WO Projects Joint 72,144 0 72,144 50,573 ACP
. CUW261 Regional R&R - Storage Joint 706,684 0 706,684 495,386 ACP CUW262 Regional R&R - Treatment Joint 575,064 D 575,064 403,120 ACP CUW263 Regional R&R - Transmission Joint 1,433,996 0 1,433,996 1,005,231 ACP.

CUW264 Watershed Roads· Joint 198,163 0 .198,183 138,912 ACP CUW354 Lower Ciystal Springs Dam Joint 857,235 0 857,235 600,922 ACP CUW355 Standby Power Facilities Jolnt 37,875 0 37,875 28,550 ACP CUW356 New Crystal Springs Bypass Tunnel Joint 3,671,856 0 3,671,856 2,573,971 96A/98A CUW359/CUW12· Irvington Tunnel Joint 2,095,122 0 2,095,122 1,468,681 ACP CUW368 BDPL Hydraulic Capacity Joint 1,612,592 0 1,612,592 1,130,427 ACP CUW371 CSPS and Pipeline Joint 221,690 0 221,690 155,404 ACP CUW374 Cslaveras Dam Joint 544,618 0 544,618 381,777 ACP CUW382 SVWTP Treated WalerResevoir Joint 32,153 D 32,153 22,539 ACP CUW384/CUW23! Tesla Disinlectton Joint . 230,019 0 230,019 161,244 ACP CUW387 CSPL#2 JoJnt 1,195,062 0 1,195,062 837,739 96N9BB CUW392 Program Management Special 979,694 (979,694) 0 o Special CUW685 Emergency OperaUons Center Joint 185 0 185 129 ACP CUW687/ll34 525 Golden Gate Joint 15,797,679 0 15,797,679 0 will be paid for as lease in lieu ofrenl CUW690 Customer Cara & Billing Spec/al 3,535,118 0 3,535,118 0 Note A CUW710 OCIP Special 2496,959 2,495,959 0 0 Special
TOTAL REGIONAL PROJECTS 38,561,597 (3,489,434) 35,072,164 11,025,550

2. 'Mlolesa!e Direct
None
B. Hatch Hetchy Waler & Power
CUH703_ Priest Reservoir Bypass Joint 574 0 574 258 166 ACP CUH762 SJPL Repair, Waler 66,609 0 66,609 66,609 42,763 ACP CUH766 HH Security Improvements Joint 284,456 0 284,456 128,005 82,179 ACP CUH804 HHRoads Joint 567,503 0 567,503 255,376 163,952 ACP CUH846 New Moccasin Penstock Power 543,074 0 543,074 0 0 ACP CUH931 Microwave Replacement Joint 4,156,642 0 4,156,642 1,870,489 1,200,854 ACP CUH941 HH SCADA Security & Contrcl Joint 702,709 0 702,709 316,219 203,013 ACP CUH950 Penstock Renovation Power 561,536 0 561,536 0 0 ACP CUH957 Moccasin Conis!on Control Water 314,805 0 314,805 314,805 202,105 ACP CUH959 Moccasin Reservoir Water Quality Water 109,379 0 109,379 109,379 70,221 ACP CUH964 Watershed Land Purchase Water 47,768 a 47,768 47,768 30,667 ACP CUH975 HH Water R&R • Joint Facilities Joint 2.495,322 0 2,495,322 1,122,895 720,898 ACP CUH975 HH Water R&R - Ki!l(wood Pens lock Assessment Power 460,170 0 460,170 ·o 0 ACP GUH975 HH Water R&R - SJPL Rehabilitation/RR Lime Slaker Waler 2,330,076 D 2,330,076 2,330,076 1,495,909 ACP CUH977 FaclllUes Maintenance - Water Joint 2,076,186 0 2,076,186 934,284 599,810 ACP CUH998 Camp Mather Leach Field Joint 26,270 0 26270 11,822 7,569 ACP TOTAL HETCH HETCHY WATER & POWER 14,743,078 0 14,743,078 7,507,984 4,820,126 TOTAL COMBINED WATER ANO HHWP 53,304,675 (3,489.434) 49,815,242 7,507,984 · 15,845,676 ['Joie A: CUW690 - Qustomer Care & Billing
This project will be spec/ally a/located. SFPUC will reffect $70,702.36 ($3,535,117.97 x 2%) as an adjustment to lhe Balancing Account in favor of the Retail customers.

Page2of4
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 & CWIP: 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 PrepayEnding Principal Interest Total ment End Ba l (6/30) Jun-10 7,110,596 17,862,065 24,972,661 344,306,709
Jun-11 7,484,069 17;488,591 24,972,661 · 336,822,640
Jun-12 7,877,159 17,095,502 24,972,661 328,945,481
Jun-13 13,715,985 11,256,676 24,972,661 315,229,496 0
Jun-14
Jun-15
Jun-16
Jun-17
Jun-18
Jun-19
.Jun-20
Jun-21
Jun-22
Jun-23
Jun-24
Jun-25
Jun-26
Jun-27
Jun-28
Jun-29
Jun-30
Jun-31
Jun-32
Jun-33
Jun-34
36,187,809 63,702,834 99,890,643 315,229,496
Note: The monthly supporting calculation for fiscal year 2012-13 is attached.

Revised Attachment K-3
Monthly Calculations for Updated 1(-3 Schedule for FY 2012-13 Based on February 2013 Prepayment
(Water)
6/30/12 Unpaid Balance
Interest Rate:

Origina!Term:

Monthly Principal & Interest Calculation through 6/30/13 Anl')ual Wholesale Revenue Requirement through 6/30/13:

Prepayment Date
Month Beginning
Ending Mo. Pmt Balance Principal (ll
6/30/12 n/a n/a
7/30/12 2,081,055 328,945,481 674,813
8/30/12 2,081,055 328,270,667 677,698
9/30/12 2,081,055 327,592,970 680,595
10/30/12 2,081,055 326,912,374 683,505
11/30/12 2,081,055 326,228,870 686,427
12/30/12 2,081,055 325,542,443 689,361
1/30/13 2,081,055 324,853,082 692,308
2/28/13 2,081,055 324,160,774 695,268
3/30/13 2,081,055 8,236,010 2,045,846
4/30/13 2,081,055 6,190,164 2,054,592
5/30/13 2,081,055 4,135,572 2,063,375
6/30/13 2,081,055 2,072,19� 2,072,196
Total (Rev K-3): 13,715,985
Current K-3 1�1
: 8,290,896
Additlonal Principal Amortized: 5,425,089
Interest (
ll
n/a
1,406,242
1,403,357
1,400,460
1,397,550
1,394,628
1,391,694
1,388,747
1,385,787
35,209
26,463
17,680
8,859
11,256,676
16,681,765
Total
n/a
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
2,081,055
24,972,661 I
24,972,661
{1) Starting in March, the Prepayment is applied to the monthly Interest calculations and monthly p_rincipal . 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 PrepayBalance 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
REVISED ATTACHMENT 1(-4
(Section 5,03)
ANNUAL PAYMENTS FOR WHOLESALE SHARE OF 6/30/09 NET PLANT & CWIP . (HETCH HETCHV ASSETS)
Revised for February 2013 Prepayment
6/30/09 Wholesale Share of Net Plant & CWIP:

Interest Rate:

Original Term:

Monthly Principal & Interest Calculation through 6/30/13:

Annual Wholesale Revenue Requirement through 6/30/13:

Fiscal Yr PrepayEnding Principal Interest Total ment
Juh-10 922,787 2,318,074 3,240,861
Jun-11 971,255 2,269,606 3,240,861
Jun-12 1,022,269 2,218,592 3,240,861
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
45,605,655

5.13%
25 270,072
3,240,861,
End Bal (6/30)
44,682,868
43,711,612
42,689,343
0 Monthly Calculations for Updated K Schedules for FY 2012·13 Based on February 2013 Prepayment
(Hetch Hetchy)
6/30/12 Unpaid Balance
Interest Rate:

Original Term:

Monthly Principal & Interest Calculation through 6/30/13 Annual Wholesale Revenue Requirement through 6/30/13:

Est. Prepayment Date
Month Beginning
Ending Mo. Pmt Balance Principal (ll Interest (l ) Total 6/30/12 n/a . n/a n/a n/a
7/30/12 270,072 42,689,343 87,575 182,497 270,072
8/30/12 270,072 42,601,769 87,949 182,123 270,072
9/30/12 270,072 42,513,820 88,325 181,747 270,072
10/30/12 270,072 42,425,494 88,703 181,369 270,072
11/30/12 270,072 42,336,792 89,082 180,990 270,072
12/30/12 270,072 42,247,710 89,463 180,609 270,072
1/30/13 270,072 42,158,247 89,845 180,227 270,072
2/28/13 270,072 42,068,402 90,229 179,842 270,072
3/30/13 270,072 1,068,839 265,502 4,569 270,072
4/30/13 270,072 803,337 266,637 3,434 270,072
5/30/13 270,072 536,699 267,777 2,294 270,072
6/30/13 270,072 268,922- 268,922 1,150 270,072
Total (Rev K-4): 1,780,010 1,460,850 3,240,861 1
Current K-4 (
21: 1,075,962 2,164,899 3,240,861
Additional Principal Amortized (K-4): 704,048
Plus Additional K·3 Principal: 5,425,089
Combined Addltlonal Principal: 6,129,137
(1) Starting In March, t he 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 Im.pact 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
42,689,343

5.13%
2S
270,072
3,240,861
2/27/13
Ending PrepayBalance ment
42,689,343
42,601,769
42,513,820
42,425,494
42,336,792
42,247,710
42,158,247
42,068,402
41,978,172 40,909,333 (1)
803,337
536,699
268,922
0 40,909,333
Combined
Prepayment
356,138,829

REVISED
Revised Attachment K-5
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)
6/30/09 Wholesale Share of Unexpended Appropriations of CWIP Interest Rate:

Term:

Monthly Principal & Interest Calculation:

Annual Wholesale Revenue Requirement:

Fiscal Yr Ending Principal Interest
Jun-1 5 $549,366 $254,740
Jun-16 $571,748 $232,358
Jun-17 $595,042 $209,064
Jun-18 $619,285 $184,821
Jul-19 $644,516 $159,590
Jun-20 $670,775 $133,332
Jun-21 $698,103 $106,004
Jun-22 $726,545 $77,562
Jul-23 $756,145 $47,961
Jun-24 $786,952 $17,155
Totals: $6,618,478 $1,422,587
Annual Payment
$804,106
$804,106
$804,106
$804,106
$804,106
$804,106
$804,106
$804,106
$804,106
$804,106
$8,041 ,065
$
Revised
6,618,478

4.00%
10 $67,009
$804,106
Year End Balance
$6,069,112
$5,497,363
$4,902,321
$4,283,035
$3,638,519
$2,967,745
$2,269,642
$1,543,097
$786,952
$0
Difference Difference
(Increase) from (Increase) from
Original
5,394
Audited Audited Original
$ 6,618,021 $ 457 $ 6,613,084 $
$804,051 $ 55 $803,451 $655
K-5 (WTR) as of 6-30-1 5

REVISED
Revised Attachment K-5
ATTACHMENT K-5
10 YEAR PAYOFF SCHEDULES FOR EXISTING RATE BASE

HETCH HETCHY ENTERPRISE UNEXPENDED APPROPRIATIONS FOR REVENUE-FUNDED REGIONAL ASSETS

CONSTRUCTION WORK IN PROGRESS (CWIP)
6/30/09 Wholesale Share of Unexpended Appropnallons of CWIP Interest Rate:

Term·
Monthly Principal & Interest Calculation:

Annual Wholesale Revenue Requirement:

AS OF JUNE JO, 2009
(Section 5.0JC)
Fiscal Yr Ending Principal Interest Total End_ Balance Principal Interest Annual Payment Jun-15 $20,592 $9,004 $29,596
Jun-16 $21,431 $8,165 $29,596
Jun-17 $22,304 $7,292 $29,596
Jun-18 $23,213 $6,383 $29,596
Ju~19 $24,159 $5,437 $29,596
Jun-20 $25,143 $4,453 $29,596
Jun-21 $26,167 $3,429 $29,596
Jun-22 $27,233 $2,363 $29,596
Jul-23 $28,343 $1,253 $29,596
Jun-24 $29,498 $98 $29,596
Totals: $2,923,204 $628,318 $3,551,522
$2,680,563
$2,428,037
$2,165,223
$1,891,701
$1,607,036
$1,310,773
$1,002,440
$681,544
$347,575
($0)
$242,640
$252,526
$262,814
$273,522
$284,665
$296,263
$308,333
$320,895
$333,969
$347,575
$2,923,204
$112,512 $355,152
$102,626 $355,152
$92,338 $355,152
$81,631 $355,152
$70,487 $355,152
$58,889 $355,152
$46,819 $355,152
$34,257 $355,152
$21,183 $355,152
$7,577 $355,152
$628,318 $3,551,522
Revised
$ 2,923,204 $

4.00%
10 $29,596
$355,152
Year End Balance
$2,680,563
$2,428,037
$2,165,223
$1,891,701
$1,607,036
$1,310,773
$1,002,440
$681 ,544
$347,575
($0)
Difference
(Increase) from
Audited
8,720 $
Audited
2,914,484 $
$354,093 $ 1,059
Difference
llncreasel
Original from Original
2,912,877 $ 10,326
$353,898 $1,254
K-5 (HHP) as of 6-30-15
Review of Unexpended Balances of Appropriated Funds (Not Included in CWIP 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_) �---�(E4_) �---
�(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_
20__
1_0-_1 ... 1 _ ...... F... Y 2_01__1-_12_ _..._ I .. ..... FY 201__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 2
1 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 SYSTEM7'
1 PROGRAM MANAGEMENT SERVICES - WSIF�'·'·"
OCIP PROJECT CONTROL2'
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
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
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, 2 015
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

Page 1 of 5 ends

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,"'2s7"'""
,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 ---,$,-----=3
734,-
,5
:,9
"'
6 -,-,$,---,6
--=
,z-=74
7 ,
"'12,.,
4 C-$,-------$,-----: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,�432- -�$--1-1,�401-- .,..$---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
Proltct Tide Fund Type Sublund
s
s
$
$
- $
- s
- $
s
$
- s
- s
- $
$
- s
- s
$
s
s
$
s
s
$
- s
$ - s
s
$
s
s
s
$
s
s
s
$
- $
s
s
s
s
$
- s
$
K-5
K-5
K-5
Addition 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
Addition to K-5 CUH774
WATER INFRASTRUCTURE - BUDGET'· 10· 11

O'SHAUGENESSY WATER SYSTEM RENOVATION'
HETCHY FACILITIES SECURllY IMPROV.'
OLD MOCCASIN POWERHOUSE REHAB.'
K-5 CUHB04 HETCH-HETCHY ROADS REBUILDING'
K-5 CUH810 VARIOUS OLD JOB1
'� 5' 14
Addition to K-5 CUH846 MOCCASIN PENSTOCK REPLACEMENT'

MOCCASIN PHONE SYSTEM
O'SHAUGENESSY DIS. REPAIRS
K-5 CUH876
K-5 CUH878
Addition to K-5
Addition to K-5
K-5
K-5
K-5
K-5
Addition 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
Addition to K-5 CUW269
FACILITIES MAINTENANCE - BUDGET' 10'"
FIBER STUDv'

Page 2 of 5 ends

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
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)�---�
(E3_�) ---�(E4_�) ---�(E5_) �____ (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,:,,:,:201� ;:,
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�_27, _000�-�$ ___ 2�,1_4_1,0�19__�$ ___ 4�,62__6�,95_9_�$ __ �3,366 _�,2_31_�$ __ �1,2_33_,8�_1_0 _s� -3�.7_92_.�758__�s __ 1_86_,7�98__�s __ 43_,2�93__�s __ 4_4�,70_3 ____ 4_7,5�_12_�$ _____ �s __ �4,_ll_S,064 �-�$ ____ 4_84�,97__7_$�------ s� ______ s ___ 4_5_4,1�93__�s ____ 30,_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-,790- -,--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
~ ~
$
s
s
$
s
s
s
s
s
$
s
s
s
s
$
$
$
$
s
s
s
s
$
l s
$
s
s
$
$
$
$
$
s
s
s
s
$
$
$
s
$
s
$
s
s
s
s
$
s
$
s
s
s
s
s
s
s
$
s
$
$

Page 3 of 5 ends

(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) +
�-�
(E1_) �----�(E_
2)�---�(E�
3 �
)----�(E_4�)----�(E5_) �----�(E6_�) -� (E3)+(E4)+(ES) + (E6) Expenditures in
FY 2009-10 ��-_;FY�
2�
0�
1;;0-;,:
1,:.
l _ _;F,;,
Y,,:
2;;
011= �
-12=:,_L_l _,:,
FY,:,,:,20;;;
1�2;;;-13:;;,__JIL;,.FY;,.
2;;;
0;,:
1;;;
3-;;;
1;;:
4'"""11_,
YTD==FY=2=0==14-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
ProjKtTitle ~ ~ L
~

ATTACHMENT L
ATTACHMENT L-1

IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project
Number

REGIONAL
CUW373 Regional
CUW384 Regional
CUW387 Regional
CUW352 Regional
CUW355 Regional
CUW359 Regional
CUW370 Regional
CUW37 4 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
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 lntertie
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 lmprovemetns
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

Page 1 of 3 ends

Project
Number
CUW358
CUW372
CUW388
CUW392
CUW394
RETAIL
CUVV307
CUW310
CUW319
CUW334
CUW335
CUW337
CUW306
CUW309
CUW314
CUW318
CUW320
CUW321
CUW322
CUW323
CUW324
CUW326
CUW326
CUW327
CUW328
CUW329
CUW330
CUW331
CUW332
CUW333
CUW338
CUW339
CUW340
ATTACHMENT L-1

IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
Project Description
San Francisco Region
Regional Sunset Reservoir Upgrades - North Basin
Regional University Mound Reservoir Upgrades - North Basin System-Wide
Regional PEIR
Regional Program Management Services
Regional Watershed Land Acquisition
Reservoirs
Local Summit Reservoir Rehabilitation
Local New Northwest Reservoir
Local Hunters Point Reservoir Rehabilitation
Local Stanford Heights Reservoir Rehabilitation
Local Potrero Heights Reservoir Rehabiliation
Local Sutro Reservoir Rehabilitation
Pump Stations/Tanks
Local Cro9ker Amazon Pump Station Upgrade
Local Lake Merced Pump Station Upgrade
Local La Grande Tank Upgrade
Local Forest Hill Tank Rehabilitation
Local Forest Hilll Pump Station Upgrade
Local Forest Knoll Pump Station Upgrade
Local Lincoln Park Pump Station Upgrade
Local Alemany Pump Station Upgrade
Local Mount Davidson Pump Station Upgrade
Local Palo Alto Pump Station Upgrade
Local Sktview-AquaVista Pump Station Upgrade
Local Summit Pump Station Upgrade
Local McLaren #1 Tank Rehabilitation
Local Potrero Heights Tank Seismic Upgrade
Local Forest Knoll Tank Seismic Upgrade
Local Lincoln Park Tank Seismic Upgrade
Local McLaren #2 Tank Rehabilitation
Local Mount Davidson Tank Seismic Upgrade
Local La Grande Pump Station Upgrade
Local Potrero Heights Pump Station Upgrade
Local Vista Francisco Pump Station Upgrade
Page2 of 3
ATTACHMENT L-1

IDENTIFICATION OF WSIP PROJECTS AS REGIONAL/RETAIL
(Section 5.04)
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
Project Description
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
East/West Transmission Main
Fulton @ Sixthe Ave Main Replacement
Water Supply/Water Quality
Groundwater
Recycled Water
Lawrence-Livermore National Laboratory Water Quality Improvements Miscellaneous
Vehicle Service Facility Upgrade
Fire Protection at CCD

Page 3 of 3 ends

ATTACHMENT L-2
03/13/06
$507,815,000

PUBLIC UTILITIES COMMISSION

OF THE CITY AND COUNTY OF SAN 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 SERIES B

CERTIFICATE REGARDING USE OF PROCEEDS
The undersigned hereby states and certifies as follows:
(i) The undersigned is the General Manager of the Public Utilities 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 will 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 Capitalized 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 Commission dated the date hereof; and
(5) the remaining $338,600,816.86 will be transferred to the Treasurer for deposit to the 2006 Series A Project Fund.
(iv) The proceeds of the 2006 Series A Bonds transferred pursuant to the Irrevocable Refunding Instructions of the Commission will 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 facilities described in Exhibit A hereto.

ATTACHMENT L-2

CONTINUED
(vi) The Trustee will 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 will be deposited in the 2006 Refunding Series B Costs of Issuance Fund; and
(2) $111,178,241.95 will 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"), will 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 facilities (the "1996 Project") described in Exhibit B hereto, and the portion of the 2001 Series A Bonds being refunded were used to finance the facilities (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 (8) 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 will 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 will 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 A, Exhibit 8, Exhibit C and Exhibit D or for other governmental purposes of the Commission during the entire term of the Bonds. ,
(xi) Set forth on Exhibit D 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 materially 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.

PUBLIC UTILITl~-OMMISSION OF THE
CITY ANrN~,9F ~AN FRANCISCO
By: __ ,,_,~......____;;=-'---------
2 //
General Manager
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
Use of Proceeds
Capitalized Interest Fund
Bond Reserve Fund
Insurance Fund
Series A Refunding Fund
Series A Project Fund
Total Uses
Hetch Hetchy
Tesla Portal Disinfection
Advance Disinfection
SJPL
Total Hetch Hetchy
SF Regional
University Mouhd - North
Sunset - North
Groundwater
Recycled Water
Total SF Regiona1
SF Local
Sunol Valley Subregional
Calaveras Dam
Stand-by Power
Pipeline Readiness
SAPS Upgrade
SVWTP Finished Water Res
Irvington Tunnel
Alameda Creek Fishery
SVWTP 40 mgd Addition
Total Sunol Valley Subregional
~07,815,000.00
19,109, 138.35
(932,940.06)
{1,973,563.58)
524,017,634.71
48,212,528.32
15,958,031.25
623,906.09
120,622,352.19}
338,600,816.86 459,223,169.05
524,017,634.71
Commercial Paper Project Fund
251,262.58 1,147,302.42
429,714.76 5,611,554.24
4,737,937.28 17,784,667.72
5,418,914.62 24,543,524.38
55,728.10 5,964,279.90
7,525,896.84 28,782,094.16
3,400,973.67 2,963,110.33
1,548,036.76 11,316,958.24
12,530,635.37 49,026,442.63
45,405,787.71 106,407,313.30
9,065,945.51 15,993,818.49
556,398.67 1,207,319.33
649,566.31 4,942,205.69
213,423.44 1,748,134.56
3,317,203.82 7,838,383.18
4,084,139.65 18,247,176.35
656,765.00 1,327,119.00
25,378.75 3,474,585.25
18,568,821.15 54,778,741.85

Page 1 of 2 ends

Total
1,398,565.00
6,041,269.00
22,522,605.00
29,962,439.00
6,020,008.00
36,307,991.00
6,364,084.00
12,864,995.00
61,557,078.00
151,813,101.01
25,059,764.00
1,763,718.00
5,591,772.00
1,961,558.00
11,155,587.00
22,331,316.00
1,983,884.00
3,499,964.00
73,347,563.00
ATTACHMENT L-2 (CONTINUED)
WATER ENTERPRISE REVENUE BOND 2006 SERIES A

SUMMARY OF SOURCES AND USES OF FUNDS
(Section 5.04)
Miscellaneous
PEIR 3,204,177.44 5,103,872.56 8,308,050.00
PPPCMS Services 2,964,786.31 10,358,811.69 13,323,598.00 Watershed Land Acquisition 502,660.00 502,660.00
Total Miscellaneous 6,168,963.75 15,965,344.25 22,134,308.00 LLNL 133,156.60 282,702.40 415,859.00
Bay Division Subregional
Seismic Upgrade BDPL 3 & 4 4,758,306.54 16,481,539.46 21,239,846.00 BDPL Reliability 4,360,664.44 40,874,800.56 45,235,465.00 BDPL 3 & 4 Crossover 802,494.94 493,817.06 1,296,312.00 SCADA Phase 11 65,497.37 1,247,963.63 1,313,461.00
EBMUD lntertie 6,668,906.37 4,075,015.63 10,743,922.00
BDPL 4 Slipline 1,219,251.00 1,219,251.00
Total Bay Division Subregional 16,655,869.66 64,392,387.34 81,048,257.00 Peninsula Subregional
Capuchino Valve Lot 162,584.69 753,779.31 916,364.00
CS/SA Transmission 2,288,853.10 3,448,975.90 5,737,829.00 Adit Leak Repair 255,334.99 1,650,368.01 1,905,703.00
HTWTP Short Term 2,874,763.69 3,582,860.31 6,457,624.00.

Cross Connection Control 1,150,559.48 324,549.52 1,475,109.00 CS Bypass Tunnel 2,873,475.22 15,532,584.78 18,406,060.00 LCS Dam Improvement 931,587.07 3,278,932.93 4,210,520.00 Pulgas Balancing Reservoir 1,218,341.39 2,706,284.61 3,924,626.00 HTWTP Long Term 1,107,185.77 2,549,793.23 3,656,979.00
Baden & San Pedro Valve Lots 60,203.48 2,963,540.52 3,023,744.00 Total Peninsula Subregional 12,922,888.88 36,791,669.12 49,714,558.00 San Francisco Subregional
CSPL 2 Replacement 1,269,111.95 5,019,824.05 6,288,936.00 SAPL3 1,492,584.40 1,942,479.60 3,435,064.00
Desalination 55,618.10 596,473.90 652,092.00
Total San Francisco Subregional 2,817,314.45 7,558,777.55 10,376,092.00 Grand Total 120,622,352.19 · 359,746,902.82 480,369,255.01 Regional 328,140,295.00
Local 152,228,960.01
480,369,255.01
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.

Page 2 of 2 ends

68.31%

31.69%
Project
Number
ATTACHMENT L-3
WATER ENTERPRISE REVENUE BOND 2006 SERIES A

ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
Project Description
(Section 5.04 A)
Net Financing
Proceeds1
Appropriated
Interest
Earnings'

REGIONAL PROGRAM
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
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 Local
CUW318 Local
CUW320 Local
CUW321 Local
CUW322 Local
CUW323 Local
CUW324 Local
San Joaquin Region
San Joaquin Pipeline System Rehabilitation
Tesla Advance Disinfection
Tesla Portal Disinfection
Total San Joaquin Region
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
Total Sunol Valley Region
Bay Division Region
Seismic Upgrade BDPL 3 & 4
SCADA Phase II/Security Upgrades
BDPL Reliability Upgrades
BDPL 3 & 4 Crossover
EBMUD lntertie
BDPL 4 Slipline
Total Bay Division Region
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
Peninsula Region
Lower Crystal Springs Dam Improvement 4,2).0,:>i?
Crystal Springs Bypass Tunnel 1.8,4Q6.,0~0,
Adil Leak Repairs , ,' ,1·,.9\;5,'703\
Pulgas Balancing Reservoir Rehabilitation and Improvements .. · ..\ \3.:\l2,i.~2ll ~~It5.g§i:. ,c;,·,-._·,,,._',:_:_·,·.:.;,J:\'.·.
0 _;1\,'j~S', t 1iE:~
Crystal Springs/San Andreas Transmission . ,, /, _' .· 5,737,829 Crystal Springs Pipleine 2 Replacement i'"• \ \''•,; \ 6,288,936 San Andreas Pipeline 3 Installation if, \ \ ,. '\'(0,'/ 3,435,064 Desalination .,,, f\ \\ ,,,\'~~} ,.::.Y 652,092
Baden & San Pedro Valve L9~ l[i\prcii(en.~-!,its 3 023,744 Total Peninsula Region \ \\ "~'J:V' 60,090,650
San Francisco Region
\)'\;.:/
Sunset Reservoir Upgrades - North Basin·
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 S_tation Upgrade
Lincoln Park Pump Station Upgrade
Alemany Pump Station Upgrade
Mount Davidson Pump Station Upgrade

Page 1 ends

6,020,008
36,307,991
42,327,999
8,308,050
13,323,598
502,660
22,134,308
·328,849,750
Adjusted
Project
Funding
Expenditures
Thru 6/30/093
.,.·.\
~ :)
@~~f\\
Remaining
Balance
Project
Number
CUW326 Local
CUW326 Local
CUW327 Local
CUW328 Local
CUW329 Local
CUW330 Local
CUW331 Local
CUW332 Local
cuw333· Local
CUW338 Local
CUW339 Local
CUW340 Local
CUW304 Local
CUW308 Local
CUW311 Local
CUW312 Local
CUW313 Local
CUW315 Local
CUW316 Local
CUW301 Local
CUW302 Local
CUW364 Local
CUW303 Local
CUW305 Local
WATER ENTERPRISE REVENUE BOND 2006 SERIES A

ANNUAL REPORT ON EXPENDITURES OF AND EARNINGS ON PROCEEDS AS OF JUNE 30, 2009
(Section 5.04 A)
Project Description
Palo Alto Pump Station Upgrade
Sktview-AquaVista Pump Station Upgrade
Summit Pump Station Upgrade
McLaren #1 Tank Rehabilitation
Potrero Heights Tank Seismic Upgrade
Forest Knoll Tank Seismic Upgrade
Lincoln Park Tank Seismic Upgrade
McLaren #2 Tank Rehabilitation
Mount Davidson Tank Seismic Upgrade
La Grande Pump Station Upgrade
Potrero Heights Pump Station Upgrade
Vista Francisco Pump Station Upgrade
Total Pump Stations/Tanks
PipelinesNalves
North University Mound System Upgrade
Motorize Key Valves
Sunset Circulation Improvements
Lincoln Way Transmission Line
Noe Valley Transmission Main, Phase 2
East/West Transmission Main
Fulton@ Sixth Ave Main Replacement
TloalPipelinesNalves ,.-···1..\·\. ( \ 1 ... __ \··
<''\ :' {:.:..-. \\. \ \) , Water Supply/Water Quality . (t \ i\::J ) \.i Groundwater :(~. \\ ~ '.'-. i ( :,;/ Recycled Water .. /:. \ \ ,\ '';JI •-·· Lawrence-Livermore Natio11-l\ ~~.oj~t~/y,Water Quality Improvements Total Water Supply/Water QLC11~1f ';:,J, '" \Jo:/ 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 Proceeds4
Percent of Net Proceeds and Earnings4
Net Financing
Proceeds1
Appropriated
Interest
Eamings2
'Net financing proceeds available on date of issue (i.e. deposit to project fund) 'Cumulative net of arbitrage rebate liability 3
Cumulative
4 11 financing sources Substantially Expended, proceed allocations are then fixed

Page 2 of 2 ends

Adjusted
Project
Funding
Expenditures
Thru 6/30/093
Remaining
Balance

ATTACHMENT M
REVENUE-FUNut::D CAPITAL ADDITIONS (Section 5.04.B)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) Based on Proportionate Annual Water Deliveries of ...

Project Title
CUW262 Regional Water RnR - Treatment Facilities
CUW263 Regional Water RnR - ConveyancefTransmission Systems CUW264 Regional Water - Watersheds/ ROW Management
FUW100 Regional Water - Facilities Maintenance
CUW261 Regional Water - Storage
A
FY 2009-10
Approved
Budget• -
Total Re9ional
$ 1,000,000
$ 7,000,000
$ 500,000
$ 3,700,000
B

68.7%
FY 2009-10
Approved
Budget -

WHOLESALE
SHARE
$ 687.000
$ 4.809.000
$ 343.500
$ 2,541,900
Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year)

C D E F
Wholesale Customer Capital Fund (SW CPF WCF)
Total Fiscal Year
Appropriation - All Years Actual 2009-10 Actual
All YearsA ExpendituresA ExpendituresA
$ 687,000 $
$ 4,809,000 $
$ 343,500. $
$ 2,541,900 $
$
$
$
$
Encumbered
But Not
Expended A
"$
$
$
$
G=C-D-F
Appropriated,
Unencumbered
BalanceA
$ 687,000
$ 4,809,000
$ 343,500
$ 2,541,900
Regional Total $ 12,200,000 Q'.:: 8,381,:i) $ 8,381,400 $ $ * SFPUC Commission Approved Budget, February 2009, Same Format ~ $ $ 8,381,400
Source:
• FAMIS - City's Official Financial System of Record
REVENUE-FUNDED CAPITAL ADDITIONS (Section 5.04.B)
Subfund: 5W CPF WCF - Wholesale Customer Capital Fund (Water) Based on Proportionate Annual Water Deliveries of •.• 68.7% FY 2009-10
FY 2009-10 Approved
Approved Budget -
Budget• - WHOLESALE
Project Title Total Re9ional SHARE
CUW262 Regional Water RnR - Treatment Facilities $ 1,000,000 $ 687,000 CUW263 Regional Water RnR - ConveyancefTransmission Systems $ 7,000,000 $ 4,809,000 CUW264 Regional Water - Watersheds/ ROW Management $ 500,000 $ 343,500 FUW100 Regional Water - Facilities Maintenance $ 3,700,000 $ 2,541,900 CUW261 Regional Water - Storage $ $
Regional Total $ 12,200,000
Source: * SFPUC Commission Approved Budget, February 2009, Same Format • FAMIS - City's Official Financial System of Record ·
ies to Budget Hearing Materials
· Projected FAMIS.as of June 30, 2010 (Last Day of Budget Year) Wholesale Customer Capital Fund (SW CPF WCF)
Total Fiscal Year Encumbered Appropriated,
Appropriation - All Years Actual 2009-10 Actual But Not Unencumbered All YearsA ExpendituresA ExpendituresA Expended A BalanceA $ 687,000 $ 235,000 $ 235,000 $ $ 452,000
$ 4,809,000 $ 1,395,000 $ 1,395,000 $ 25,000 $ 3,389,000 $ 343,500 $ 115,000 $ 115,000 $ 50,000 $ 178,500
$ 2,541,900 $ 850,000 $ 850,000 $ 123,000 $ 1,568,900
$ 8,381,400 $ 198,000 $ 5,588,400
' Shown On Attachment N-2, Schedule 3
Revenue Capital - Actual Expenditures
. ies to Budget Hearing Materials
Shown on Attachment N-2, Schedule 3
ATTACHMENI M-1

Page 1 of 2 ends

H l=G-H
Projected
Expended &
Encumbered Projected
through Surplus/
6/30/2010 (Shortfall)
.$ 229,000 $ 458,000
$ 1,603,000 $ 3,206,000
$ 114,000 $ 229,500
$ 847,000 $ 1,694,900
$ S,SBB,400
Projected
Expended &
Encumbered Projected
through Surplus/
6/30/2011 (Shortfall)
$ 409,000 $ 43,000
$ 1,589,000 $ 1,800,000
$ 35,500 $ 143,000
$ 768,900 $ 800,000
$ 2,802,400 $ 2,786,000
' Shown on Attachement N-2, Schedule 3
Continuing Appropriation
Needed for Mulit-Year
Revenue Funded Capital
REVENUE-FUNDED CAPTIAL ADDITIONS (Section S.04.B)
Subfund: ST CPF WCF - Wholesale Customer Capital Fund (Hetch Hetchy) Projected FAMIS as of July 1, 2009 (Day 1 of New Budget Year) A B C D E F G=C-D-F
. Wholesale Customer Capital Fund (SW CPF WCF)
Base~ on Proportionate Annual Water Deliveries of ... 68.1% FY 2009-10
FY 2009-10 Approved
Approved Budget- Total Fiscal Year Encumbered Appropriated, Budget• - WHOLESALE Appropriation - All Years Actual 2009-1 0 Actual Bu1Not Unencumbered Project Title Total Regional SHARE All YearsA Exeenditures" Exeenditures" Exeended" Balance" CUH931 HH Microwave Replacement $ 4,000,000 J $ 1,224,900 $ 1,224,900 $ $ $ $ 1,224,900 CUH977 HH Water R&R - Facilities Maintenance $ 3,500,000 J $ 1,071,788 $ 1,071,788 $ $ $ $ 1,071,788 CUH947 SEA - Go Solar lncen~ve Porject $ 4,000,000 p $ $ $ $ $ $ CUH971 Alternative Transmission Studies $ 1,000,000 p $ $ $ $ $ $ CUH976 HH Water R&R - Power Infrastructure $ 16,700,000 p $ $ CUH979 Hunters Point Municipal Power $ p $ $
CUH983 Civic Center Sustainability District $ 1,090,000 p $ $ CUH986 General Fund Dept - Energy Efficiency $ 7,365,158 p $ $ Renewable/Generation $ 3,501,307 p $ $
Treasure Island Improvement Project $ 2,700,000 p $ $
Enterprise Fund Dept - Energy Efficiency $ 325,722 p $ $ CUH975 HH Water R&R - Water Infrastructure $ 6,000,000 w $ 4,083,000 $ 4,083,000 Toulumne River Watershed Protection $ 2,000,000 w $ 1,361,000 $ 1,361,000 Regional Total $ 52,182,187 ct 7,740,:i) $ 7,740,688 $ $ $ $ 2,296,688 Source: • SFPUC Comm1ss1on Approved Budget, February 2009, Same Format ~~-~ .. ·-·~ .. -~,. " FAMIS - City's Official Financial System of Record REVENUE-FUNDED CAPTIAL ADDITIONS (Section S.04.B) Projected FAMIS as of June 30, 2010 (Last Day of Budget Year) Subfund: ST CPF WCF - Wholesale Customer Capital Fund (Hetch Hetchy) Wholesale Customer Cap~al Fund (SW CPF WCF)
Based on Proportionate Annual Water Deliveries of ... 68.1% FY 2009-10
FY 2009-10 Approved
Approved Budget- Total Fiscal Year Encumbered Appropriated, Budget"- WHOLESALE Appropriation - All Years Actual 2009-10 Actual Bu1 Not Unencumbered Project Title Total Regional SHARE All Years" ExeendituresA Exeenditures" ExeendedA Balance" CUH931 HH Microwave Replacement $ 4,000,000 J $ 1.224,900 $ 1,224,900 $ 1,224,900 $ 1,224,900 $ $ CUH977 HH Water R&R - Facilities Maintenance $ 3,500,000 J $ 1,071,788 $ 1,071,788 $ 1,071,788 $ 1,071,788 $ $ (1) CUH947 SEA - Go Solar Incentive Porject $ 4,000,000 p $ $ $ $ $ $ CUH971 Alternative Transmission Studies $ 1,000,000 p $ $ $ $ $ $ CUH976 HH Water R&R - Power Infrastructure $ 16,700,000 p $ $ $ $ $ $ CUH979 Hunters Point Municipal Power $ p $ $ $ $ $ $
CUH983 Civic Center Sustainability District $ 1,090,000 p $ $ $ $ $ $ CUH986 General Fund Dept - Energy Efficiency $ 7,365,158 p $ $ $ $ $ $ Renewable/Generation $ 3,501,307 p $ $ $ $ $ $
Treasure Island Improvement Project $ 2,700,000 p $ $ $ $ $ $ Enterprise Fund Dept - Energy Efficiency $ 325,722 p $ $ $ $ $ $ CUH975 HH Water R&R - Water Infrastructure $ 6,000,000 w $ 4,083,000 $ 4,083,000 $ 4,083,000 $ 4,083,000 $ $ Toulumne River Watershed Protection $ 2,000,000 w $ 1,361,000 $ 1,361,000 $ 1,361,000 $ 1,361,000 $ $ Regional Total $ 52,182,187 7,740,688 $ 7,740 68 $ 7,740,688 $ $ ' Source: • SFPUC Commission Approved Budget, February 2009, Same Format Shown On Attachment N-2, Schedule 6 11 FAMIS - City's Official Financial System of Record Revenue Capital - Actual Expenditures Ties to Budget Hearing Materials
Shown on Attachment N-2, Schedule 6
H l=G-H
Projected
Expended &
Encumbered Projected
through Surplus/
6/30/2010 (Shortfall)
$ 408,000 $ 816,900
$ 357,000 $ 714,788
$ $
$ $
$
$
$
$
$
$
$
$ 1,361,000
$ 454,000
$
Projected
Expended &
Encumbered Projected
through Surplus/
6/30/2011 (Shortfall)
$ $
$ (1) $
$ $
$ $
$ $
$ $
$ $
$ $
$ $
$ $
$ $
$ $
$ $
$ (1! $
' Show on Attachment N-2, Schedule 6
Continuing Appropriation
Needed for Mulit-Year
Revenue Funded Capital
ATTACHMENT M-1

Page 2 of 2 ends

ATTACHMENT M-2

REVENUE FUNDED CAPITAL

ANNUAL REPORTING REQUIREMENTS
(Section 5.048}
Part A. Updated Actual Information Through Most Recent Fiscal Vear (Due in November) Each year, the SFPUC will provide a report on the status of the regional revenue funded projects with the following information:

Project-level information (through close-out)
1 Scope of project
2 Current cost estimate/budget.
3 . Expected milestone dates (ie, design, environmental, construction period, close-out, etc.) 4 Contract status
5 Reasons for status changes from prior report.
6 Other information relevant to whether project is on time/on budget. 7 For most recently completed fiscal year and estimated for current year:
8 Total expenditures (capital and operating); amounts paid from other sources. 9 Amount of encumbered and unencumbered appropriations
10 Application of any unused appropriations
Wholesale Capital Fund
11 Beginning balance, deposits, capital expenditures (by project), earnings, ending balance. 12 Components of ending balance; wholesale portion of:
13 Appropriated and encumbered
14 Appropriated but unencumbered
Part 8. Proposed Appropriations for Upcoming Year (Due in March) 15 Project information, to the extent not provided in Part A 16 Expected funding needs for regional projects
17 Unused or excess appropropriations carried over.
18 Proposed appropriation for upcoming fiscal year.

Amended Attachment M-3
Wholesale Capital Fund and Balancing Account Adjustment Reference Amended Section 6.08E
A. Cash Flow in Wholesale Capital Fund
FYE 2010 FYE 2011 FYE 2012 FYE 2013 FYE 2014 FYE 2015 FYE 2016 FYE 2017 FYE 2018 FYE 2019 FYE 2020 FYE 2021 FYE 2022 FYE 2023 1 Beginning Total Balance (1) - 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 2 Annual Appropriation (2) 10,476,724 8,636,920 21,737,468 11,285,643 18,668,585 15,432,451 21,138,051 11,184,265 17,847,379 26,424,000 26,420,000 13,210,000 13,210,000 13,210,000 3 Annual Expenditures (3) (1,778,695) (5,202,897) (18,553,119) (10,916,349) (5,758,565) (7,331,312) (6,245,954) (13,892,649) (14,361,409) (18,089,498) (16,723,232) (28,485,215) (33,563,793) (22,018,000) 4 Interest Earnings (4) 120,294 151,929 173,034 137,113 180,672 58,140 115,532 299,936 370,050 475,153 664,783 757,859 711,183 409,280 June 30 Balances Before Balancing Account Transfers
5 Total Balance (5) 8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785 42,508,440 51,910,495 32,848,850 17,206,239 12,807,520 6 Amount Encumbered as of June 30 (6) (1,927,466) (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 7 Unencumbered Balance (7) n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a 41,508,440 50,910,495 31,848,850 15,206,239 10,807,520 8 Transfer From/(To) Balancing Account (8) n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a (959,496) (4,544,290) 4,000,000 4,000,000 4,000,000 Ending Balances After Balancing Account Transfers
9 Ending Total Balance (9) 8,818,323 12,404,275 15,761,658 16,268,065 9,084,304 17,243,583 32,251,212 29,842,765 33,698,785 41,548,944 47,366,205 36,848,850 21,206,239 16,807,520 10 Unencumbered Ending Balance (10) n/a n/a n/a n/a 7,156,838 n/a n/a n/a n/a 40,548,944 46,366,205 35,848,850 19,206,239 14,807,520 B. Calculation of Target Balance
11 Target WCF Balance (11) 7,156,838 40,548,944 46,366,205 40,559,076 34,346,800 29,062,000 C. Calculation of Remaining Cumulative Appropriation
12 Cumulative Appropriation Since FYE 2010 (12) 10,476,724 19,113,644 40,851,112 52,136,755 70,805,340 86,237,791 107,375,842 118,560,107 136,407,486 162,831,486 189,251,486 202,461,486 215,671,486 228,881,486 13 Cumulative Expenditures Since FYE 2010 (13) (1,778,695) (6,981,592) (25,534,711) (36,451,060) (42,209,626) (49,540,938) (55,786,891) (69,679,540) (84,040,949) (102,130,447) (118,853,679) (147,338,893) (180,902,686) (202,920,686) 14 Total Remaining Cumulative Appropriation (14) 28,595,715 36,696,854 51,588,951 48,880,567 52,366,537 60,701,040 70,397,808 55,122,593 34,768,800 25,960,800 15 Amount Encumbered as of June 30 (15) (1,927,466) - (1,000,000) (1,000,000) (1,000,000) (2,000,000) (2,000,000) 16 Unencumbered Remaining Cumulative Appropriation (16) n/a n/a n/a 26,668,249 n/a n/a n/a n/a 59,701,040 69,397,808 54,122,593 32,768,800 23,960,800 17 D. Lesser of Target Balance and Unencumbered Remaining Cumulative Appropriation Lesser of Target Balance (line 11) and Unencumbered Remaining Appropriation (line 16) (17) 40,548,944 46,366,205 40,559,076 32,768,800 23,960,800 E. Calculation of Excess Fund Balance and Refund to Wholesale Customers Through Balancing Account 18 Is Unencumbered Balance (line 7) more than line 17? (18) Yes Yes No No No 19 Excess WCF Balance (applied as a negative entry on line 8) (19) 959,496 4,544,290 - - - F. Calculation of Deficiency Fund Balance and Charge to Wholesale Customers Through Balancing Account (This Section is Only Applicable in Any Year When Line 18 is No) 20 Is Unencumbered Balance (line 7) less than line 17? (20) Yes Yes Yes 21 Tentative Amount Before Application of $4 million cap (21) 8,710,226 17,562,561 13,153,280 22 Is line 21 more than $4,000,000 maximum? (22) Yes Yes Yes 23 Balancing Account Charge (applied as a positive entry on line 8): 4,000,000 4,000,000 4,000,000 Original 5 Year True-up Method FYEs 2010-2018 Amended Annual True-Up (FYE 2019 and Beyond) See Notes on Page 2 Page 1 of 2
I
I I
Notes:
(1) Beginning Total Balance (encumbered and unencumbered). Equal to the prior year ending total balance after balancing account transfers (line 9). (2) Wholesale Share of Revenue Funded Appropriations for Regional capital projects, adjusted for de-appropriations which have been factored into a wholesale revenue requirement, if applicable. FYE 2015 and forward are subject to compliance audit and 7.06 review.

Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided. (3) Wholesale Share of actual Regional capital expenditures funded from Revenue Funded Capital, determined based on proportionate water use in the year of expenditure. Figures from FYE 15 and forward are subject to 7.06 and compliance audit review.

Detail by Regional project in the format used in the 2010 - 2014 true-up to be separately provided.

The figures in line 3 for FYE 18 and on are for illustrative purposes only. (4) Line 1 times the assumptions below for the SFPUC pool rate. FYE 2010 - 2014 figures are actual and tie to the first 5 year review.

Pool rate assumptions: 0.640% 0.670% 0.930% 1.240% 1.410% 1.600% 1.600% 1.930% 1.930% (5) Total encumbered and unencumbered balance of the Wholesale Capital Fund before Balancing Account adjustments: Line 1 + line 2 + line 3 + line 4. (6) Wholesale Share of the encumbrances for purchase orders or contracts in connection with revenue-funded Regional capital projects; calculated using the proportional annual use of the true-up year. Entered as a negative number.

Not applicable in years with no true-up (FYEs 2010-13 and 2015-18). FYE 2014 figure is actual. FYE 2019 and forward are plug numbers included for illustration. (7) Unencumbered Balance Before Balancing Account transfers: Line 5 + line 6. FYE 2014 figure is actual. Not applicable (n/a) in years with no true-up (FYEs 2010-13 and 2015-18). (8) Negative entries represent refunds to the Wholesale Customers through the Balancing Account and are calculated per Section E below, except for 2014 which is actual pursuant to the original 6.08E.

Positive entries represent charges to the Wholesale Customers through the Balancing Account and are calculated per Section F below. (9) Total Ending Balance After Balancing Account Transfers = Line 5 + line 8. (10) Unencumbered Ending Balance After Balancing Account Transfers = Line 7 + line 8. Must not exceed the amount on line 17, which is the lesser of the Target Balance (line 11) and the Unencumbered Remaining Cumulative Appropriation (line 16). (11) Starting in FYE 2019, the Target Balance is calculated by the formula below, where CY represent the Current Year (for which the transfer is being calculated), CY-1 is the prior year, CY-2 is 2 years prior, etc.:
[line 2: CY]*(4/5) + [line 2: CY-1]*(3/5) + [line 2: CY-2]*(2/5) +[line 2: CY-3]*(1/5); rounded to the nearest dollar. The FYE 2014 figure is the actual target balance under the original section 6.08E. (12) Cumulative Appropriations Since FYE 2010 = prior year line 12 + current year line 2. (13) Cumulative Expenditures Since FYE 2010 = prior year line 13 + current year line 3. Does not include encumbrances. (14) Total Remaining Cumulative Appropriation (encumbered and unencumbered) = line 12 + line 13. (15) Amount encumbered as of June 30 = line 6. Encumbrances are not cumulative. (16) Unencumbered Remaining Cumulative Appropriation = line 14 + line 15. (17) Lesser of Target Balance (line 11) and Unencumbered Remaining Cumulative Appropriation (line 16). Used in formulas in line 19 (Section E) and line 21 (Section F), as applicable. (18) If Yes, go to line 19 for calculation of the excess unencumbered balance. If No, go to line 20. (19) Calculation of Excess Balance: If line 18 = Yes, then line 7 minus line 17. The result appears as a negative amount on line 8. (20) If yes, then go to lines 21-23 for calculation of charge to Wholesale Customers. (21) Initial step in calculating charge: If line 20 = Yes, then line 17 minus line 7; go to line 22. (22) If the result on line 21 is greater than $4,000,000, then the charge to the Wholesale Customers is capped at $4,000,000. (23) Equal to the lesser of line 21 or $4,000,000. The result appears as a positive number on line 8.

See Notes on Page 2 Page 2 of 2

ATTACHMENT N

BALANCING ACCOUNT/ 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
FY 2007-08
$12,882,000
$554,000
($113,932,000)
$119,224,000
$2,448,614
$0
$21,176,614
/,/'.\
((', \ \ D. Wholesale Revenue Requirement for Fiscal Year /?-.., '\ _ '-~ \ E s ttl t C d't 0th Ad' t t /(,c?-,. 1 i ·,,, _l . e emen re Is or er JUS mens ,_;::::ti(' tr t• h_ \\', __ :\ F 1984A tB I . A t·c d't _,,.,..,..~~\ ~,, \ '.' tt\\ :\ >;/ . greemen a ancing ccoun re I s 7 ---~\ "\\ \} /) \::>
G. Balancing Account as of June 30, 2009 ;,--'°\ t;:\\ \ \\',7.::;;::,· Step 3: .-', (/A ;J : c\:.'• ', ~.l ,./.,.,., ,~\..,..,,:,,:\I?\,,,;, A. Balancing Account as of June 30, 2009 / ; .. '(-:, ( \ '"" ~~pi v B. Interest on Balancing Account at Pooled Investment RateAor,;frls¢at_ Y~~\r\; C. Wholesale Revenues for ~iscal Year . f\ n\'::'~-=~ \J ,,,;, .. D. Wholesale Reve_nue Requ1rem~nt for Fiscal 'r'.ll \\ '\ \ \'(,:1_:/ E. Settlement Credits or Other Adjustments;;::;,, \ \\ ', '>::.-,) F. 1984 Agreement Balancing Account ~~,~\ \ '~j-..:c:::_,,.

G. Balancing Account as of June 30, 201 q, \ \ ,\~~\;::> H. Net Change in Wholesale Revenue Co,\~~age
I. Total Revenue Deficiency or Surplus ,~, ·
J. Projected Water Sales in Ccf 84,621,240
K. Deficiency or (Surplus) $/Ccf
L. Deficiency or (Surplus) Ccf as a Percentage of Revenues FY 2008-09
83,205,600
FY 2009-10
ATTACHMENT N-1

Page 1 ends

$0
$0
-$127,485,900
$140',994,733
$21,000
$1,997,220
$15,527,053
$4,488,233
$20,015,286
85,920,000
$0.23

15.7%
Note: Dollar amounts are for illustrative purposes only. The Parties have not agreed on the amount of the balancing account as of June 30, 2007, revenue requirement for FY 2007-08, settlement credits for FY 2007-08, and the amount of the balancing account as of June 30, 2009.

BALANCING ACCOUNT/ RATE SETTING CALCULATION

METHOD OF CALCULATION
REFERENCE SECTION 6.03.A.3.a
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 Step 2
Step 3
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 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 Rev~nue 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 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) ATTACHMENT N-1
Page2

WHOLESALE REVENUE REQUIREMENT SCHEDULES

CALCULATION OF WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10
REFERENCE ARTICLE 5

EXPENSE CATEGORY
OPERATING AND MAINTENANCE EXPENSE:

SOURCE OF SUPPLY

PUMPING

TREATMENT

TRANSMISSION & DISTRIBUTION
CUSTOMER ACCOUNTS2

TOTALO&M
COMPOSITE% (WHOLESALE SHARE/ TOTAL O&M)
ADMINISTRATIVE AND GENERAL EXPENSES:

COWCAP

SERVICES OF SFPUC BUREAUS

OTHERA&G

COMPLIANCE AUDIT

TOTALA&G

PROPERTY TAXES

TOTAL CAPITAL COST RECOVERY

WHOLESALE SHARE HETCH HETCHY WATER & POWER

WHOLESALE REVENUE REQUIREMENT
. WHOLESALE REVENUE COVERAGE'
1 Proportional Annual Use (68.39%)

CONTRACT SCHEDULE

REFERENCE REFERENCE

5.05 (A)

5.05 (8)
505 (C)

5.05 (D)

5.05 (E)

5.06 (C)

5.06 (A)

5.06 (8)

5.06 (C)

5.06 (DJ

5.07 \ .,
s:os . · 5:04 <A>\ · ;;,o'l',(Bl

5.04 SCHB.1
SCHB.1
SCHB.1
SCHB.1
SCHB.1
SCHB.1
SCH4
2 Water Enterprise Share of Customer Accounts Expenses (62% of Total Customer Accounts Expenses) 3 25% of Wholesale Share of Debt Service
$
$
$
$
$
$
$

TOTAL DIRECT

DIRECT RETAIL WHOLESALE
14,943,953 $
4,342,682 $
30,445,053 $
53,416,232 $
7,552,213 $
$
$
$
$
$
$
$

REGIONAL
1,238,009
14,286,867
8,962,586
200,000
24,687,462
1,417.293

JOINT EXPENSE

ALLOCATION
FACTOR

COMPOSITE O&M
ANNUAL USE1

COMPOSITE O&M
50%
ANNUALUSE1
ATTACHMENT N-2
SCHEDULE 1

WHOLESALE
SHARE
$ 9,364,568
$ 334,210
$ 20,821,372
$ 15.902,690
$ 151,044
46,573,883

42.07%
$ 520,857
$ 9,770,788
$ 3,770,749
$ 100,000
$ 14,162,394
$ 969,287
$ 24,051,326
$ 17,952,931
$ 8,381,400
$ 50,385,657
$ 28,903,512
$ 140,994,733
$ 4,488,233

WHOLESALE REVENUE REQUIREMENT SCHEDULES

WATER ENTERPRISE CAPITAL COST RECOVERY -ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.04.A

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
$
$
$

31.61%

68.39%
8,765,000
2,770,617
5,994,384
$ 23,353,388 $
$ 7,382,006 $
$ 15,971,382 $
2008 BOND

ISSUE ALL
SERIES

22.95%

77.05%
2009 BOND

ISSUE ALL
SERIES

19.42%

80.58%

68.39%

XXXX BOND

ISSUE ALL
SERIES
XX.XX%
VY.VY%
ZZ.ZZ%
Note: Allocation of bond proceeds shown are for illustrative purposes only. Regional projects will not include bond proceeds used to construct or acquire assets capitalized prior to 7/1/09. Regional projects also will not include in-city groundwater or in-city recycled water projects.

XXXX BOND

ISSUE ALL
SERIES
ZZ.ZZ%

XXXXBOND

ISSUE ALL
SERIES
ZZ.ZZ%
ATTACHMENT N-2
SCHEDULE 2

XXXXBOND

ISSUE ALL
~ SERIES

TOTAL ALL

OUTSTANDING
BONDS
YY.YY% XX.XX%-
ZZ.ZZ%
$ 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
$ 17,952,931
(TO SCHEDULE 1)

WHOLESALE REVENUE REQUIREMENT SCHEDULES

WATER ENTERPRISE CAPITAL COST RECOVERY - REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009-10
REFERENCE SECTION 5.04.B
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 Conveyance/Transmission
CUW264 Regional Watersheds/ROW Management
FUW100 Regional Facilities Mainten.ance
Total Regional

TOTAL ALL PROJECTS

PROJECT APPROPRIATION CLASSIFICATION
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

ALLOCATION
FACTOR

WHOLESALE
SHARE

TOTAL ALL YEARS

APPROPRIATION ACTUAL

ALL YEARS EXPENDITURES
ATTACHMENT N-2
SCHEDULE 3
FY 2009-10 ACTUAL ENCUMBERED, NOT APPROPRIATED,

EXPENDITURES EXPENDED UNENCUMBERED BALANCE
$ $
$ $
$ $
$ $
$ - $
$ $
$ $
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)

WHOLESALE REVENUE REQUIREMENT SCHEDULES

CALCULATION OF WHOLESALE SHARE OF HETCH HETCHY WATER & POWER FISCAL YEAR 2009-10
REFERENCE ARTICLE 5

EXPENSE CATEGORY

OPERATION AND MAINTENANCE

OPERATION

MAINTENANCE

TOTAL OPERATION AND MAINTENANCE

ADMINISTRATIVE AND GENERAL
COWCAP

SERVICES OF SFPUC BUREAUS

OTHER A&G

CUSTOMER ACCOUNTS

TOTAL ADMINISTRATIVE AND GENERAL

PROPERTY TAXES

CAPITAL'COST RECOVERY
PRE-2009 ASSETS

DEBT SERVICE ON NEW ASSETS

REVENUE FUNDED ASSETS-APPROPRIATIONS TO WHOLESALE CAPITAL FUND

TOTAL CAPITAL COST RECOVERY

WHOLESALE SHARE OF HETCH HETCHY WATER & POWER

WHOLESALE REVENUE COVERAGE'
'Adjusted Proportional Annual Use (68.39% X ss:so% = 68.05%) 2 25% of Wholesale Share of Debt Service

CONTRACT SCHEDULE

REFERENCE REFERENCE

5.0881

5.08 B 1

5.08 B2

5.08 B 2

5.08 B 3

5.09 B 1

5.09 B 2

5.09 B 3
SCH 8.2
SCH 8.2
SCH 8.2
SCH7
SCH 8.2
SCH 8.2
SCH 8.2
ATT K-4
SCH 5

TOTAL POWER

SPECIFIC
WATER

SPECIFIC JOINT
$ 44,612,220 $ 31,853,965 $ 9,557,861 $ 3,200,394
$ 16,868,612 $ 5,048,039 $ 3,238,622 $ 8,581,951
$ 61,480,832 $ 36,902,004 $ 12,796,483 $ 11,782,345
1,139,579 $
$ 8,255,307 $
$ 25,581,481 $
$ 347,403 $
__ §_CH~\
\~~~:\_\_;~-> . \)\-;.,/
JOINT

ALLOCATION

PERCENTAGE
\45o/o
45%
WATERRELATED
TOTAL
$ 2,879,651
$ 4,820,623
45% ~$ ____ _
$ 8,213,085
ATTACHMENT N-2
SCHEDULE4

WHOLESALE WHOLESALE

ALLOCATION FACTOR SHARE

ADJUSTED PRQPORTIONAL ANNUAL
use ADJUSTED PROPORTIONAL ANNUAL
USE

ADJUSTED PROPORTIONAL ANNUAL
USE
AO.JUSTED PROPORTIONAL ANNUAL
USE
AOJUSTeO PROPORTIONAL ANNUAL
USE

ADJUSTED PROPORTIONAL ANNUAL
USE
$
$
$
$
$
$
$
$
$
7,484,165
4,831,890
12,316,055
348,968
1,959,603
3,280,434
5,589,004
45% 2051337 AOJUSTEOPR~~TIONALANNUAL $ 139,732
$ 3,118,033
$
$ 7,740,688
10,858,721
$ 28,903,512
(TO SCHEDULE 1)

WHOLESALE REVENUE REQUIREMENT SCHEDULES

HETCH HETCHY CAPITAL COST RECOVERY - ANNUAL DEBT SERVICE FISCAL YEAR 2009-10
REFERENCE SECTION 5.09.B.1

USE OF BOND PROCEEDS

POWER PROJECTS

WATER PROJECTS

JOINT PROJECTS

PRINCIPAL PAYMENT

POWER SHARE

WATER SHARE

JOINT SHARE

INTEREST PAYMENT (NET)

POWER SHARE

WATER SHARE

JOINT SHARE

TOTAL PRINCIPAL AND INTEREST PAYMENT

POWER SHARE

WATER SHARE

JOINT SHARE
WATER RELATED PRINCIPAL AND INTEREST PAYMEN11

ADJUSTED PROPORTIONAL ANNUAL USE

WHOLESALE SHARE

XXXX BOND

ISSUE ALL
SERIES
)000(%
VY.VY%
ZZ.ZZ%

XXXX BOND

ISSUE ALL
SERIES
)0(.)0(%
VY.VY%
ZZ.ZZ¾

XXXX BOND

ISSUE ALL
SERIES
)0(_)0(%
VY.VY%
ZZ.ZZ%

68.05%

XXXX BOND

ISSUE ALL
SERIES
)O(_)O(O/o
VY.VY%
ZZ.ZZ%

68.05%

XXXX BOND

ISSUE ALL
SERIES

68.05%

XXXX BOND

ISSUE ALL
SERIES

68.05%
ATTACHMENT N-2
SCHEDULE 5

XXXX BOND

ISSUE ALL
SERIES

68.05%
ToTALALL

OUTSTANDIN

G BONDS
(TO SCHEDULE 4)

WHOLESALE REVENUE REQUIREMENT SCHEDULES

HETCH HETCHY CAPITAL COST RECOVERY - REVENUE FUNDED CAPITAL PROJECTS FISCAL YEAR 2009-10
REFERENCE SECTION 5.04.B
CUH931 HH Microwave Replacement 4.000.000 JOINT
CUH977 HH Water R&R - Facilities Maintenance 3.500.000 JOINT Total Joint 7.500.000
CUH947 SEA - Go Solar Incentive Project 4.000.000 POWER CUH971 Alternative Transmission Studies 1.000.000 POWER CUH976 HH Water R&R - Power Infrastructure 16.700.000 POWER CUH979 Hunters Point Municipal Power POWER
CUH983 Civic Center Sustainability District 1.090.000 POWER CUH986 General Fund Dept - Energy Efficiency 7.365.158 POWER Renewable/Generation 3.501.307 POWER
Treasure Island Improvement Project 2.700.000 POWER
Enterprise Fund Dept - Energy Efficiency 325.722 POWER
Total Power $ 36.682.187
CUH975 HH Water R&R - Water Infrastructure $ 6.000.000 WATER Toulumne River Watershed Protection $ 2,000.000 WATER
Total Water 8.000,000
TOTAL ALL WATER RELATED PROJECTS 96,364.374 \ \ \
ATTACHMENT N-2
SCHEDULE 6

ALLOCATION
FACTOR

WHOLESALE
SHARE

TOTAL ALL YEARS
APPROPRIATION ACTUAL FY2009-10ACTUAL ENCUMBERED, NOT APPROPRIATED.

EXPENDITURES EXPENDED UNE:~~~~RED ALL YEARS EXPENDITURES 45%
45%
,,.~;,_ .. -;.,.- .. -
1,800,000 AOJUS~:u~~TIONAI. $ 1,224,900 $ r),2~.4.;s~b\_$: 1.224,900 1,575,000 AOJUS~DN~~~TIONAl $ 1,071,788 $ .•• ·.,1):)n,1-ea'S -~\~1~_0_7_1~,7_88_ 1,224,900 $
1,071,788 ~$ _____ _
3,375,000 $ 2,296,6~~ \s.,,\ 12~~:s~§ $, ·, 2.296.688 2,296,688 $ AUJU:l11:.U1-'!,11)1'U,.CIIUNAl.
0% ANNUAL USE
AUJU:llt:Ul-'!,IOl-'U,.CIIIJNAI.
0% ANNUAL USE
AJ.)JU:ilt:Ut-'Hu+'OHIIIJNAI.
0% ANNUALUSE :•
Q% AUJU:lltut'>!lJtpH'W.ltl,'f
0%
0%
0%
0%
,--;;<\::~ f \ '1., \ ,,/ \ \;:~ ,.~\ ;/ ~.,✓., ; ',. \ ,~\, \_ \ -~ \. PWI.Jti"ltut'HUl"UH.lllJNAI. !\ \ \\ 1..-_-.-t'c-~O\>, ~\ ,,_;/6,QQQ,QQQ ANNUAi.USE . \ \ \ \ .':''•-._ t()Q.o/6\ $> 2,QQQ,QQQ AOJUST.!°N~~TIONAL \ \ \ \ \ '\(\~l )} \;• $ 8,000,000
\:~}:~~) ,_,., $ 11,375,000
)\~·
4,083,000 $
1,361.000 $
5,444,000 $
7,740,688 $
4,083,000 $
1,361.000 $
5,444,000 $
7,740,688 $
4,083.000 $ 4,083,000
1,361,000 ~$ ___ 1~_3_6~1~0~0~0
5,444.000 $ 5,444,000
7,740.688 $ 7,740,688 $
(TO SCHEDULE 4) (TO SCHEDULE 4)
$
(TO SCHEDULE 4)

WHOLESALE REVENUE REQUIREMENT SCHEDULES

SERVICES OF SFPUC BUREAUS - ALLOCATION TO ENTERPRISES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B

ADJUSTED

EXPENDITURE ADJUSTMENTS EXPENDITURE HETCH HETCHY

S S POWER
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
$
$
$
$
$
$
$
$
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) 7,609,114 $
4,081,981 $
8,817,687 $
16,212,801 $
7,678,483 $
$
3,882,455 $

11.13%
847,180
454,478
981,739
1,805,093
854,903

HETCH HETCHY
WATER

5.96%

WATER RETAIL
ATTACHMENT N-2
SCHEDULE7

WATER REGIONAL WASTEWATER
_,,;;,:,,.,-'1\

36.37%
$ 2,767,682
$ 1,484,749
$ 3,207,280
$ 5,897,123
$ 2,792,914
$
$ 1,412,175
$ 17,561,923
TOTAL
$ 7,609,114
$ 4,081,981
$ 8,817,687
$ 16,212,801
$ 7,678,483
$
$ 3,882,455
$ 48,282,521

WHOLESALE REVENUE REQUIREMENT SCHEDULES

SERVICES OF SFPUC BUREAUS - ANNUAL SALARIES
FISCAL YEAR 2009-10
REFERENCE SECTION 5.05.B

DEPARTMENT/DIVISION

HETCH HETCHY
POWER
WATER
JOINT
WATER

WATER SHARE

POWER SHARE
ADMINISTRATION (WTR01)

RETAIL SHARE

REGIONAL SHARE

HETCH HETCHY WATER SHARE
CDD(WTR03)
WATER QUALITY (WTR04)
WATER SUPPLY & TREATMENT (WTR05)

WASTEWATER
SALARIES !~T~~o~;T~~~~ POW~
HETCH HEl\;ki'y ·_ V,VATER
\ \ \/
\/

WATER - RETAIL

WATER- REGIONAL

WASTEWATER

TOTAL SALARIES

ALLOCATION GROUP

FACTOR CODE
45%
55%

33.4%

33.3%

33.3%
1 $
2 $
$
2 $
1 $
$
3 $
4 $
2 $
5 $
1 $
2 $
3 $
4 $
5 $
$

SALARIES
6,677,939
1,775,910
9,428,450
4,242,803
5,185,648
1,419,760
355,703
1,064,057
38,757,578
11,863,587
6,355,129
18,049,040
31,529,823
38,757,578
106,555,156

PERCENTAGE

6.27%

1.67%

3.98% a;'\~) 4.87% v .. \0', \
(~~1\:~
:, \Q'3',;'¥\ v';V \"1:J l ~) _,. )-&:i's%

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%
ATTACHMENT N-2
SCHEDULE 7.1

WHOLESALE REVENUE REQUIREMENT SCHEDULES

CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10

WATER ENTERPRISE SUMMARY OF OPERATING EXPENSES
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
$
$
$
$
Retail
42,669,517 $
$
8,178,424 $
Wholesale
151,044 $
$
- $
Regional
67,879,572 $
1,238,009 $
14,286,867 $
ATTACHMENT N-2
SCHEDULE 8.1
Total
4,342,682
30,445,053
110,700,133
1,238,009
22,465,291
$ 4,009,891 $ - $ 8,962,586 $ 12,972,477
~$ ______ - ~$ _____ - _$ ______ - ~$ ____ _
Adjusted General & Administrative $
Compliance Audit $
Total General & Administrative $
Property Taxes $
Total $
Source: FAMIS/EIS
Note: All adjustments to be separately identified above 4,009,891 $
100,000 $
12,288,315 $
- $
54,957,832 $

Page 9 of 10 ends

- $ 8,962,586 $ 12,972,477
100,000 $
100,000 $
- $
251,044 $
- $ 200,000
24,487,462 $ 36,875,777
1,417,293 $ 1,417,293
93,784,327 $ 148,993,203

WHOLESALE REVENUE REQUIREMENT SCHEDULES

CALCULATION OF THE WHOLESALE REVENUE REQUIREMENT
FISCAL YEAR 2009-10

HETCHY HETCHY WATER & POWER SUMMARY OF OPERATING EXPENSES Power
Operating Expenses
Purchased Power & Wheeling $ 28,953,676
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
$ 28,953,676
$ 2,900,291 $
$ $
$ - $
~$ _____ - $
$ 2,900,291 $
Water
- $
$
$
2,879,651 $
· Joint
$
$
11,782,346 $
1,139,579 $
- $
$ 347,403 $ - $ - $
Total
28,953,676
13,660,670
3,359,385
61,480,836
1,139,579
8,255,307
347,403
.;._$ _____ - .;._$ _____ - .;._$ _____ - .;._$ ____ _
$ 347,403 $ - $ - $ 347,403
$ 14,913,071 $ 36,070 $ 10,632,340 $ 25,581,481
.;._$ _____ - .;._$ _____ - .;._$ _____ - .:..$ ____ _
$ 14,913,071 $ 36,070 $ 10,632,340 $
TotatGeneral & Administrative
Property Taxes
Total
Source: FAMIS/EIS
$
$
$
Note: All adjustments to be separately identified above 20,636,130 $
- $
57,538,136 $
2,915,721 $
- $
15,712,205 $
11,771,919 $
452,000 $
24,006,265 $
25,581,481
35,323,770
452,000
97,256,606
ATTACHMENT N-2
SCHEDULE 8.2

SCHEDULE OF PROJECTED WATER SALES, WHOLESALE REVENUE REQUIREMENTS, AND WHOLESALE RATES CONTRACT REFERENCE: ARTICLE 6.03.A.3

OPERATION AND MAINTENANCE EXPENSES

SOURCE OF SUPPLY

PUMPING

TREATMENT

TRANSMISSION & DISTRIBUTION

CUSTOMER ACCOUNTS

TOTAL OPERATION AND MAINTENANCE EXPENSES

ADMINISTRATIVE AND GENERAL EXPENSES
COWCAP

SF PUBLIC UTILITIES COMMISSION

OTHERA&G

COMPLIANCE AUDIT

TOTAL ADMINISTRATIVE AND GENERAL EXPENSES

PROPERTY TAXES

CAPITAL COST RECOVERY
PRE 2009 ASSETS

DEBT SERVICE ON NEW ASSETS

REVENUE FUNDED CAPITAL

TOTAL CAPITAL COST RECOVERY

WHOLESALE SHARE HHW&P

WHOLESALE REVENUE REQUIREMENT
BALANCING ACCOUNT AS OF JUNE 30

INTEREST ON BALANCING ACCOUNT

WHOLESALE REVENUES AT EXSITING RATE

WHOLESALE EXCESS USE CHARGES

SETTLEMENT CREDITS AND OTHER ADJUSTMENTS
1984 AGREEMENT BALANCING ACCOUNT CREDITS

WHOLESALE DEBIT SERVICE COVERAGE RESERVE

WHOLESALE DEFICIENCY OR CREDIT

PERCENT WHOLESALE DEFICIENCY OR CREDIT OF REVENUES AND EXCESS USE CHARGES

PROJECTED WATER SALES (CCF)
WHOLESALE DEFICIENCY OR CREDIT ($/CCF)
PROJECTED WHOLESALE RATE (UNIT COST ($/CCF)

PROJECTED SERVICE CHARGE REVENUES

PROJECTED VOLUME CHARGE REVENUES

TOTAL WHOLESALE REVENUES
N N+1

FISCAL YEAR
N+2
9,364,568 $
334,210 $
20,821,372 $
15,902,690 $
- $
- $
- $
- $
$
$
$
$
$ 151,044 ~$ ____ _ $
$ 46,573,884 $
$ 140 994 734
$
$
- $
$
- $
$ - $ - $
$ $ - $
$ (127,485,900) $ - $
$ - $ - $
$ 21,000 $ - $
$ 1,997,220 $ - $
- $
- $
- $
$
- $
- $
- $
- $
- $
- $
- $
- $
$ 4,488,233 ~$ _____ - ~$ ____ _ $
$ 20,015,287 $ - $ $

15.7%
85,920,000 0 0

0.23 0 0

1.66 0 0
$ 4,620,300
$ 142,627,200
$ 147,247,500
ATTACHMENT N-3
N+3 N+4
- $
- $
- $
- $
$
$
- $
- $
$
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
- $
$
0 0
0 0
0 0

ATTACHMENT O
ATTACHMENT 0

STATEMENT OF WHOLESALE REVENUE REQUIREMENT/ CHANGES IN BALANCING ACCOUNT YEAR ENDED JUNE 30
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
Hetch Hetchy Water and Power (HHWP):

Operating expen_ses
Maintenance expenses
Total HHWP operating and maintenance
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
Total Wholesale Revenue Requirement
Balancing Account July 1
Interest on adjusted begin_ning balance
Wholesale revenues billed
Excess use charges billed
Wholesale Revenue Coverage Reserve
Other adjustments
Settlement adjustments
1984 Agreement Balancing Account Credits
Balancing Account June 30
(Section 7.02.B)
FY 2008-09
Allocation to
Wholesale
Customers
$ 9,133,025
$ 325,946
$ 20,437,460
$ 9,350,279
$ 224,255
$ 39,470,965
$ 10,359,786
$ 4,526,240
$ 14,886,026
$ 964,040
$ 120,923
$ 1,084,963
$ 46,378,941
$ 120,645,291
$ 21,176,614
$ 529,415
$ (123,604,000)
$
$
$
$ 21,006
$
$ 18,768,326
FY 2009-10
Allocation to
Wholesale
Customers
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
9,364,568
334,210
20,821,372
15,902,690
151,044
46,573,884
969,287
139,732
1,109,019
24,051,326
3,118,033
17,952,931
8,381,400
7,740,688
61,244,378
140,994,735
(147,247,500)
4,488,233
21,006
1,997,220
253,694
Difference
$ 231,543
$ 8,264
$ 383,912
$ 6,552,411
$ (73,211)
$ 7,102,919
$ 2,308,953
$ (398,019)
$ (4,464,050)
$ 3,280,434
$ 4,662
$ 927,003
$
$
$
5,247
18,809
24,056
$14,865,437
$20,349,444

ATTACHMENT P
Attachment P

REPRESENTATION LETTER
Certification Pursuant to Water Sales Agreement (the Agreement) between the City and County of San Francisco (San Francisco) and certain wholesale customers in the counties of San Mateo, Santa Clara, and Alameda (the Wholesale Customers) effective July 1, 2009.

Each of the undersigned certifies that:

1. I have reviewed San Francisco Water Department and Retch Hetchy Water & Power Department 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 of the preparation of the Statement.

Evaluated the effectiveness of the allocation procedures to ensure compliance with the terms of the Agreement.

Attachment P, Page 1
1870057.1
The Statement fully complies with the contractual requirements of the Agreement and fairly presents, in all material respects, the allocation of costs to the Wholesale Customers in accordance with the Agreement.

General Manager, SFPUC Date
Assistant General Manager & Chief Financial Officer, SFPUC Date Finance Director, SFPUC Date
Accounting Manager, SFPUC Date
Financial Planning Manager, SFPUC Date
Senior Rates Administrator, SFPUC Date
Attachment P, Page 2
1870057.1

ATTACHMENT Q
Legend
f: 21] Service Area
- Streams/Rivers
Attachment Q-1
i l:
;=--,,----------+---�c;s ......... ;.... ______ ,.,-
Maximum Service Area - North San Jose Municipal Water
\\oakland-01\data\GISIBAWSCA\Project\2018_07 _ServiceAreas\Attach_ Q-1_SantaClara-ServiceArea.mxd 9/14/2018 11 :45:29 AM N
i
125
Miles
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;
,\
Cup0 •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\GISIBAWSCA\Project\2018 _07 _ ServlceAreas\Attach_ Q-2_ SantaClara-ServlceAreaExisting.mxd 9/27/2018 3:49:40 PM I
I
i ·','
,.
u

ATTACHMENT R
ATTACHMENT R – CLASSIFICATION OF EXISTING SYSTEM ASSETS 1 15049417.1
ATTACHMENT R-1

INTRODUCTION TO ATTACHMENT R
Attachment R is composed of three documents (1) this R-1 Introduction to Attachment R, (2) R-2 Special Classification of Discrete Projects for 2018 WSA Amendment Purposes, and (3) R-3 Major Hetch Hetchy Enterprise Existing System Assets. These R series attachments provide a record for purposes of maintaining the historical basis for the allocation of capital costs and operating expenses associated with Existing System Assets generally, with greater detail provided for major Hetch Hetchy Enterprise Existing System Assets due to the complexity of tracking the Water-Only, Power-Only, and Joint classifications as inputs to the Wholesale Revenue Requirement under Sections 5.08 and 5.09 of the Agreement.

Attachment R-2, Special Classification of Discrete Projects for 2018 WSA Amendment Purposes defines a limited number of capital projects involving five Hetch Hetchy Enterprise Existing System Assets where the parties have agreed to classify defined capital project costs separately from the assets’ underlying classification listed on Attachment R-3. The classification listed in Attachment R-3 will continue to control the allocation of capital costs and operating expenses once the defined capital projects described in Attachment R-2 are complete.

Attachment R-3, Major Hetch Hetchy Enterprise Existing System Assets is a record of major assets at the "facility group" level (see below) as of January 1, 2019. The table contains six columns and 578 rows. The facility groups are broken down into individual facilities or assets. The facility group name and classification are provided for each asset. Assets listed on Attachment R-3 are classified as Joint, Water-Only, or Power-Only. Each asset is also assigned a unique identification ("ID") number for ease of reference. Attachment R-3 is not a complete record of all Hetch Hetchy Enterprise Existing System Assets.

General Explanation of Classification. A “facility group” is a location where a group of facilities is located. A single facility may constitute a facility group. A “facility” is a primary asset in a facility group whose function determines its classification and the classification of appurtenances or sub-assets. An appurtenance is an asset or sub-asset that supports the function of the facility to which it is appurtenant. In most cases the classification of the appurtenance is determined by the classification of the facility to which the appurtenance belongs. The function of the appurtenance may not necessarily control its classification.

The classification of appurtenant assets generally follows the classification of the facility group served. These appurtenant assets include security, offices/housing, and utilities serving the facility group such as domestic water, wastewater, communications and solid waste disposal.

Power distribution assets that provide power to a facility group (e.g. lower voltage power distribution lines) generally carry the classification of the facility group served, but do not include power generation or higher voltage transmission lines for export of power elsewhere, which remain classified as Power-Only. With limited exceptions for roads exclusively accessing Power-Only facilities, roads and bridges are classified as Joint because most roads serve multiple facilities or Joint facilities. Equipment and rolling stock are generally classified as Joint unless the asset has a specialized purpose serving the Power function. Capital costs and operating expenses related to Camp Mather are charged to Power in order to segregate these costs from the Wholesale Revenue Requirement.
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
Water3
Mountain Tunnel Joint Mountain Tunnel Flow Control
Facility (FCF) Project
Joint5
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 agreedupon 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
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.
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.

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
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
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
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
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
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
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
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
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
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
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
1 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03

3.04 Permanent Transfers of Individual Supply Guarantees and Minimum Annual Purchase Quantities
A. A Wholesale Customer that has an Individual Supply Guarantee may transfer a portion of it to one or more other Wholesale Customers, as provided in this section.

B. Transfers of a portion of an Individual Supply Guarantee must be permanent., as opposed to temporary or time-limited. Notwithstanding the previous sentence, a portion of an Individual Supply Guarantee that has been transferred under this section may be included in another transfer under this section at a later date. The minimum quantity that may be transferred is 1/10th of a MGD.

C. Transfers of a portion of a Minimum Annual Purchase Quantity may be included in transfers of a portion of an Individual Supply Guarantee and are subject to the same requirements for Individual Supply Guarantee transfers in this section as well as the following conditions:

1. Transferor of Minimum Annual Purchase Quantity. A Wholesale Customer subject to the minimum annual purchase requirements of Section 3.07.C may transfer both a portion of its Individual Supply Guarantee and a portion of its Minimum Annual Purchase Quantity to one or more Wholesale Customers that have an Individual Supply Guarantee. The process by which such a transfer may be proposed and approved is set forth in subparts D and E of this section. A Wholesale Customer that had a Minimum Annual Purchase Quantity at the start of the Term of this Agreement may not cumulatively transfer, over the course of one or multiple transfers, more than half (50%) of its Minimum Annual Purchase Quantity as first specified in Attachment E at the start of the Term of this Agreement. Wholesale Customers that had a Minimum Annual Purchase Quantity at the start of the Term of this Agreement may not cumulatively transfer, over the course of one or multiple transfers, more than 6 MGD of the total aggregate Minimum Annual Purchase Quantity specified in Attachment E at the start of the Term of this Agreement. A Wholesale Customer that received a Minimum Annual Purchase Quantity through a transfer under this section may cumulatively transfer, over the course of one or multiple transfers, a portion of or all of the Minimum Annual Purchase Quantity it received pursuant to this section. The effect of such a transfer will be a reduction in the transferor’s Individual Supply Guarantee, specified in Attachment C, and a reduction in the transferor’s 2 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03 Minimum Annual Purchase Quantity, specified in Attachment E. The SFPUC and BAWSCA will update Attachments C and E to reflect such changes, pursuant to Section 3.04.F. The reduction in the transferor’s permanent Minimum Annual Purchase Quantity shall become effective in the same fiscal year in which the transfer becomes effective.

2. Transferee of Minimum Annual Purchase Quantity. A Wholesale Customer that has an Individual Supply Guarantee may be the recipient, or transferee, of both a portion of Individual Supply Guarantee and a portion of Minimum Annual Purchase Quantity from another Wholesale Customer that has an Individual Supply Guarantee, whether or not the transferee is already subject to the minimum annual purchase requirements of Section 3.07.C.

When such a transfer is approved and effective, the transferee will initially have a revised Individual Supply Guarantee and a Temporary Modified Minimum Annual Purchase Quantity, which will be reflected on Attachments C and E-1, respectively, pursuant to Section 3.04.F. A Temporary Modified Minimum Annual Purchase Quantity will become effective in the same fiscal year in which the transfer becomes effective. The transferee’s Temporary Modified Minimum Annual Purchase Quantity will ultimately be replaced by a permanent Minimum Annual Purchase Quantity, as described in this sub-section, which will be reflected on Attachment E pursuant to Section 3.04.F.

3. Calculation of Temporary Modified Minimum Annual Purchase Quantity.

The Temporary Modified Minimum Annual Purchase Quantity that a transferee receives from a transfer under this sub-section is the sum of (1) the average annual (fiscal year) quantity of water purchased by the transferee from the SFPUC (plus Imputed Sales, if applicable) in the most recent five previous non-drought fiscal years, plus (2) the relevant reduction in the transferor's Minimum Annual Purchase Quantity. For this calculation, the five previous nondrought fiscal years need not be consecutive. Notwithstanding the preceding sentences in this paragraph, if a transferee has an existing Temporary Modified Minimum Annual Purchase Quantity at the time of a new transfer under this sub-section, the transferee’s new Temporary Modified Minimum Annual Purchase Quantity under the new transfer will be the sum of (1) the transferee’s existing Temporary Modified Minimum Annual Purchase Quantity, plus (2) the relevant reduction in the transferor’s Minimum Annual Purchase Quantity. Attachment E-2 contains sample calculations of the Temporary Modified Minimum Annual Purchase Quantity for transferees who are subject to, or not yet subject to, the minimum annual purchase requirements of Section 3.07.C.

REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03 3 17168182.1

4. Duration and Expiration of Temporary Modified Minimum Annual Purchase Quantity.
a. Once a transfer under this sub-section is approved and effective, the transferee is required to purchase from the SFPUC its Temporary Modified Minimum Annual Purchase Quantity until the quantity of water delivered annually to the transferee by the SFPUC meets or exceeds the Temporary Modified Minimum Annual Purchase Quantity for three consecutive fiscal years. It may take many years for the quantity of water delivered to meet or exceed this amount. The transferee’s Temporary Modified Minimum Annual Purchase Quantity is subject to waiver by the SFPUC as described in Section 3.07.C. However, even in the event of such a waiver, a fiscal year in which the transferee still purchases from the SFPUC an amount of water that meets or exceeds its Temporary Modified Minimum Annual Purchase Quantity will count as a fiscal year in which the transferee has met or exceeded its Temporary Modified Minimum Annual Purchase Quantity for the purposes of this paragraph. b. Once the quantity of water delivered to the transferee by the SFPUC reaches the milestone described in the preceding paragraph, the transferee will no longer be subject to the Temporary Modified Minimum Annual Purchase Quantity. Instead, the transferee will have a new permanent Minimum Annual Purchase Quantity, which will equal the sum of (1) its previous Minimum Annual Purchase Quantity, if applicable, plus (2) the relevant reduction in the transferor’s Minimum Annual Purchase Quantity. The transferee’s new permanent Minimum Annual Purchase Quantity will be reflected on Attachment E, and its expired Temporary Modified Minimum Annual Purchase Quantity will be removed from Attachment E-1, pursuant to Section 3.04.F. Any other Temporary Modified Minimum Annual Purchase Quantities of the transferee will remain in effect on Attachment E-1.

D. Transfers of portions of Individual Supply Guarantees, including transfers of portions of Minimum Annual Purchase Quantities, are subject to approval by the SFPUC.

SFPUC review is limited to determining (1) whether a proposed transfer complies with the Act, and (2) whether the affected facilities in the Regional Water System have sufficient capacity to accommodate delivery of the increased amount of water to the proposed transferee.

E. The participants in a proposed transfer shall provide written notice to the SFPUC and BAWSCA specifying (1) the amount of the Individual Supply Guarantee proposed to be transferred, (2) the proposed effective date of the transfer, which shall not be less than 60 days 4 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03 after the notice is submitted to the SFPUC, and (3) the Individual Supply Guarantees of both participants resulting from the transfer. If a proposed transfer includes the transfer of a portion of Minimum Annual Purchase Quantity, then the participants will provide additional written notice specifying (4) the amount of the Minimum Annual Purchase Quantity proposed to be transferred, (5) transferee's Temporary Modified Minimum Annual Purchase Quantity and permanent Minimum Annual Purchase Quantity under the transfer, and (6) the transferor's new Minimum Annual Purchase Quantity under the transfer. The SFPUC may require that the participants in any proposed transfer provide additional information reasonably necessary to evaluate the operational impacts of the transfer.proposed transfer and any additional information that will assist the SFPUC in its review of the proposed transfer. The SFPUC will not unreasonably withhold or delay its approval of a proposed transfer; if the SFPUC does not act on the written notice provided by the participants within 60 days, the transfer will be deemed to have been approved. An approved transfer becomes effective on the proposed effective date set forth in the written notice of the proposed transfer provided to the SFPUC and BAWSCA.

F. Within 30 days after the transfer has become effective, both the transferor and the transferee will provide written notice to the SFPUC and BAWSCA. By September 30 of each year during the Term, the SFPUC and BAWSCA will prepare an updated Attachment C, and updated Attachments E and E-1 where applicable, to reflect the effects of transfers occurring during the immediately preceding fiscal year. By September 30 of each year during the Term, the Individual Water Sales Contracts between San Francisco and any Wholesale Customers who are participants in a transfer under this Section will be amended with the written concurrence of San Francisco and those Wholesale Customers to reflect the effects of transfers occurring during the immediately preceding fiscal year, as necessary.

G. Amounts transferred will remain subject to pro rata reduction under the circumstances described in Section 3.02.C and according to the formula set forth in Attachment D.

H. A proposed transfer that does not satisfy the requirements of this section may be presented as an amendment to this Agreement pursuant to Section 2.03. 5 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03

3.07 Restrictions on Purchases of Water from Others; Minimum Annual Purchases A. Each Wholesale Customer (except for Alameda County Water District and the cities of Milpitas, Mountain View and Sunnyvale) agrees that it will not contract for, purchase or receive, with or without compensation, directly or indirectly, from any person, corporation, governmental agency or other entity, any water for delivery or use within its service area without the prior written consent of San Francisco.

B. The prohibition in subsection A does not apply to:

1. recycled water;

2. water necessary on an emergency and temporary basis, provided that the Wholesale Customer promptly gives San Francisco notice of the nature of the emergency, the amount of water that has been or is to be purchased, and the expected duration of the emergency; or

3. water in excess of a Wholesale Customer’s Individual Supply Guarantee.

C. Alameda County Water District and the cities of Milpitas, Mountain View and Sunnyvale may purchase water from sources other than San Francisco, provided that San Francisco shall require that each purchase a minimum annual quantity of water from San Francisco. These minimum quantitiesMinimum Annual Purchase Quantities are set out in Attachment E and shall also be included in the Individual Water Sales Contracts between San Francisco and each of these four Wholesale Customers. The minimum purchase requirement in these Individual Water Sales Contracts Pursuant to Section 3.04, certain Wholesale Customers may also be required to purchase Temporary Modified Minimum Annual Purchase Quantities, set out in Attachment E-1, from San Francisco. Attachment E will be updated pursuant to Section 3.04 to reflect any reduction in existing Minimum Annual Purchase Quantities and any addition of new Minimum Annual Purchase Quantities when Temporary Modified Minimum Annual Purchase Quantities expire and are removed from Attachment E-1; Individual Water Sales Contracts between San Francisco and any Wholesale Customers who are participants in a transfer under Section 3.04 will similarly be amended, as necessary. After the end of each fiscal year, the SFPUC will send a written notice to each Wholesale Customer that is subject to the minimum annual purchase requirements of this section with a copy to BAWSCA. The notice will include: (1) the quantity of water delivered to the Wholesale Customer during the previous fiscal year; (2) whether or not the Wholesale Customer met its minimum annual purchase 6 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03 requirement under this section; (3) any Imputed Sales charged to the Wholesale Customer; and (4) the status of any Temporary Modified Minimum Annual Purchase Quantity of the Wholesale Customer, if applicable. The minimum annual purchase requirements set out in Attachments E and E-1 will be waived during a Drought or other period of water shortage if the water San Francisco makes available to these Wholesale Customers is less than its minimum purchase quantity.Minimum Annual Purchase Quantity, and may be waived during a state of emergency declared by the Governor of California that impacts water supply use or deliveries from the Regional Water System.
7 17168182.1
REDLINE COMPARING 2018 AMENDED AND RESTATED WATER SUPPLY AGREEMENT TO MINIMUM PURCHASE AMENDMENT: SECTIONS 3.04, 3.07, AND 2.03

2.03 Amendments
…
C. Amendments to Attachments. The following attachments may be amended with the written concurrence of San Francisco and BAWSCA on behalf of the Wholesale Customers:

Attachment Name
C Individual Supply Guarantees (amendments reflecting section 3.04 transfers only)
E Minimum Annual Purchase Quantities (amendments reflecting section 3.04 transfers only)
E-1 Temporary Modified Minimum Annual Purchase Quantities G Water Quality Notification and Communications Plan
(2019 Update of 2017 Plan, Rev. 6)
J Water Use Measurement and Tabulation
L-1 Identification of WSIP Projects as Regional/Retail
N-1 Balancing Account/Rate Setting Calculation Table
N-2 Wholesale Revenue Requirement Schedules
N-3 Schedule of Projected Water Sales, Wholesale Revenue Requirement and Wholesale Rates
P Management Representation Letter
R Classification of Existing System Assets (Subject to Section 5.11) Amendments to these attachments shall be approved on behalf of San Francisco by the Commission and on behalf of BAWSCA by its Board of Directors, unless the Commission by resolution delegates such authority to the General Manager of the SFPUC or the Board of Directors by resolution delegates such authority to the General Manager/CEO of BAWSCA.

Resolution Approving a Minimum Purchase Transfer From the City of Mountain View to the City of East Palo Alto

Page 1 of 5 ends

Rev: 11/22/17
RESOLUTION NO. _____

A RESOLUTION OF THE CITY OF SANTA CLARA, CALIFORNIA

APPROVING A MINIMUM PURCHASE TRANSFER FROM THE

CITY OF MOUNTAIN VIEW TO THE CITY OF EAST PALO ALTO
BE IT RESOLVED BY THE CITY OF SANTA CLARA AS FOLLOWS:

WHEREAS, the City and County of San Francisco ("San Francisco") Public Utilities Commission ("SFPUC" or "Commission") operates the Regional Water System, which delivers water to water supply agencies in Alameda, San Mateo, and Santa Clara Counties (collectively, “the Parties”); WHEREAS, in April 2003, water supply agencies in Alameda, San Mateo and Santa Clara Counties (collectively, the "Wholesale Customers") established the Bay Area Water Supply and Conservation Agency ("BAWSCA"), as authorized by Water Code Section 81300 et seq.; WHEREAS, WHEREAS, in November of 2018, San Francisco and the Wholesale Customers (the "Parties") entered into the Amended and Restated Water Supply Agreement ("WSA"); WHEREAS, the Parties have identified intra-system water transfers as one potential solution to long-term water reliability needs among the Wholesale Customers; WHEREAS, in 2017, the City of Mountain View ("Mountain View") and the City of East Palo Alto ("East Palo Alto") were interested in transferring 1.0 million gallons per day ("MGD") of Mountain View's Minimum Annual Purchase Quantity (“Minimum Purchase”) to East Palo Alto, however, at the time, there was no procedure in the WSA to effectuate such a transfer without amending the WSA;
WHEREAS, in 2017, Mountain View and East Palo Alto executed a water rights transfer agreement in which East Palo Alto agreed to pay Mountain View $5 Million for the permanent transfer of all rights, title, interest to 1.0 MGD of Mountain View’s Individual Supply Guarantee (ISG) to East Palo Alto;
WHEREAS, in August 2018, BAWSCA and San Francisco provided the Wholesale Customers a revised Attachment C to the Water Supply Agreement reflecting the updated ISG amounts for Mountain View and East Palo Alto, as a result of the 1.0 MGD transfer of ISG from Mountain Resolution Approving a Minimum Purchase Transfer From the City of Mountain View to the City of East Palo Alto

Page 2 of 5 ends

Rev: 11/22/17
View to East Palo Alto;
WHEREAS, Mountain View continues to be subject to a Minimum Purchase of 8.93 MGD and the financial obligation of paying for imputed sales for the portion of Minimum Purchase that it does not use;
WHEREAS, in 2020, Mountain View and East Palo Alto began discussing a possible future transfer of a portion of Mountain View's Minimum Purchase to East Palo Alto; WHEREAS, *summarize the specific reasons the resolution is being adopted here; text should be left justified and double spaced;
WHEREAS, on January 26, 2021, the SFPUC adopted the 2021 Amended and Restated Water Supply Agreement ("2021 WSA"), which includes a new procedure by which Wholesale Customers with ISGs may participate in permanent expedited transfers of a portion of Minimum Purchase and ISG, without creating new or different risks to the water supply and financial interests of Wholesale Customers not participating in such transfers; WHEREAS, the 2021 WSA has been or will be presented to the governing body of each Wholesale Customer, and if approved, will permit Wholesale Customers with an ISG to transfer and accept a portion of another Wholesale Customer’s Minimum Purchase, if certain requirements are satisfied;
WHEREAS, on April 20, 2021, East Palo Alto approved the conversion of the 1.0 MGD of Mountain View's ISG sold to East Palo Alto in 2017 into a transfer of up to 1.0 MGD of Mountain View's Minimum Purchase to East Palo Alto, in increments of 0.25 MGD or other amount, subject to the City Council’s approval of an agreement for each incremental transfer and the approval of the Wholesale Customers and San Francisco;
WHEREAS, on June 8, 2021, Mountain View approved the conversion of the 1.0 MGD of Mountain View's ISG sold to East Palo Alto in 2017 into a transfer of up to 1.0 MGD of Mountain View's Minimum Purchase to East Palo Alto, in increments of 0.25 MGD, subject to the City Council’s approval of an agreement for each incremental transfer and the approval of the Resolution Approving a Minimum Purchase Transfer From the City of Mountain View to the City of East Palo Alto

Page 3 of 5 ends

Rev: 11/22/17
Wholesale Customers and San Francisco;
WHEREAS, East Palo Alto and Mountain View are authorized and prepared to execute a negotiated agreement memorializing the terms and conditions of a 0.25 MGD transfer of Mountain View's Minimum Purchase to East Palo Alto;
WHEREAS, as noted below, one of the conditions of the negotiated agreement between Mountain View and East Palo Alto is that, in exchange for the 0.25 MGD of Minimum Purchase transfer, Mountain View will provide East Palo Alto with an immediate Right-of-First Refusal for drought water transfers at the same volume as the Minimum Purchase transfer, pursuant to Appendix H of the 2021 WSA;
WHEREAS, in conjunction with consideration of the 2021 WSA, East Palo Alto and Mountain View propose the Wholesale Customers and San Francisco approve, in advance, the terms and conditions for converting up to 1.0 MGD of Mountain View's ISG purchased by East Palo Alto in 2017 into a transfer of 1.0 MGD of Mountain View's Minimum Purchase to East Palo Alto, in 0.25 MGD increments, if Mountain View and East Palo Alto mutually agree to such incremental transfers in the future and provided the conditions outlined below are met; WHEREAS, if up to 1.0 MGD of Mountain View's ISG purchased by East Palo Alto in 2017 is converted into a transfer of up to 1.0 MGD of Mountain View's Minimum Purchase to East Palo Alto, up to 1.0 MGD of Minimum Purchase, in 0.25 MGD increments, will be counted towards the total Minimum Purchase that may be transferred pursuant to Section 3.04.C.1 of the 2021 WSA; WHEREAS, this parallel action continues to require the calculation of a Temporary Modified Minimum Annual Purchase Quantity, set out in Attachment E-1 in the 2021 WSA; however, the transferor, Mountain View, is responsible for the imputed sales associated with transfers to East Palo Alto up to 1.0 MGD, until the terms and conditions outlined below are satisfied; and, WHEREAS, in accordance with the water transfer provisions of the 2021 WSA, Mountain View and East Palo Alto will coordinate with San Francisco and BAWSCA to document Temporary Modified Minimum Annual Purchase Quantities to be included on Attachment E-1, transferred Resolution Approving a Minimum Purchase Transfer From the City of Mountain View to the City of East Palo Alto

Page 4 of 5 ends

Rev: 11/22/17
Minimum Annual Purchase Quantities to be included on Attachment E, when timely, and amendments to each cities' Individual Water Sales Contract with San Francisco.

NOW THEREFORE, BE IT FURTHER RESOLVED BY THE CITY OF SANTA CLARA AS FOLLOWS:

1. The Santa Clara City Council approves, in advance, the conversion of up to 1.0 MGD of Mountain View's ISG, sold to East Palo Alto in 2017 into a transfer of 1.0 MGD of Mountain View's ISG plus up to 1.0 MGD of Mountain View’s Minimum Purchase to East Palo Alto, in 0.25 MGD increments, if all of the following terms and conditions are satisfied:

A. Mountain View will transfer up to 1.0 MGD of its Minimum Purchase to East Palo Alto, in increments of 0.25 MGD, subject to the Mountain View City Council's and the East Palo Alto City Council's approval of an agreement for each incremental transfer.

B. For each incremental transfer, a Temporary Modified Minimum Annual Purchase Quantity will be calculated for East Palo Alto that is equal to the City's five-year average water use from the SFPUC for the most recent non-drought years prior to the 2017 ISG purchase, plus the incremental transfer amount(s).

C. For each incremental transfer, Mountain View will maintain, and be responsible for paying any imputed sales for, its Minimum Purchase requirement in effect at that time, as set forth in Attachment E of the WSA, including up to 1.0 MGD ISG transfer to East Palo Alto, until East Palo Alto's water use meets the Temporary Modified Minimum Annual Purchase Quantity for three consecutive years.

D. East Palo Alto will not be required to pay imputed sales associated with the Temporary Modified Minimum Annual Purchase Quantity for any incremental transfer of the 1.0 MGD of Mountain View's Minimum Purchase requirement.

E. For each incremental transfer, once East Palo Alto has met the Temporary Modified Minimum Annual Purchase Quantity for three consecutive years, the incremental portion of Mountain View's Minimum Purchase transferred to East Palo Alto will become East Resolution Approving a Minimum Purchase Transfer From the City of Mountain View to the City of East Palo Alto

Page 5 of 5 ends

Rev: 11/22/17
Palo Alto's Minimum Purchase, and Mountain View's Minimum Purchase will be reduced by an equivalent amount. East Palo Alto's new Minimum Purchase will be included in Attachment E and both cities' Individual Water Sales Contracts will be updated to reflect this transfer.

F. With exception of the incremental transfers that are the subject of this resolution and the agreement between East Palo Alto and Mountain View described herein, any additional transfers of Minimum Purchase, either from another Wholesale Customer or from Mountain View in excess of the 1.0 MGD, are subject to Section 3.04 of the 2021 WSA.

2. Effective date. This resolution shall become effective immediately.

I HEREBY CERTIFY THE FOREGOING TO BE A TRUE COPY OF A RESOLUTION PASSED

AND ADOPTED BY THE CITY OF SANTA CLARA, CALIFORNIA, AT A REGULAR MEETING THEREOF HELD ON THE 19th DAY OF April, 2022, BY THE FOLLOWING VOTE:

AYES: COUNCILORS:

NOES: COUNCILORS:

ABSENT: COUNCILORS:

ABSTAINED: COUNCILORS:

ATTEST: ______________________________

NORA PIMENTEL, MMC

ASSISTANT CITY CLERK

CITY OF SANTA CLARA
S:\Attorney\RESOLUTIONS\Form Resolution-City.doc
City of Santa Clara
Agenda Report
1500 Warburton Avenue
Santa Clara, CA 95050
santaclaraca.gov
@SantaClaraCity
22-442 Agenda Date: 4/19/2022

REPORT TO COUNCIL

SUBJECT
Action on Amendment No. 1 to the Agreement with Gates and Associates Landscape Architecture, Inc. for Design Professional Services for the Westwood Oaks Playground Rehabilitation Project

COUNCIL PILLAR

1. Deliver and Enhance High Quality Efficient Services and Infrastructure

2. Enhance Community Sports, Recreational and Arts Assets

BACKGROUND
On July 6, 2021, City Council approved a design professional services agreement with Gates and Associates Landscape Architecture, Inc. (Gates and Associates) for the first phase of the Westwood Oaks Playground Rehabilitation Project (Project). The first phase of the Project includes preparation of concepts for the park and a schematic design for the playground rehabilitation, community outreach, presentation of the schematic design to the Parks and Recreation Commission, and action from the City Council. The proposed schematic design (SD) incorporated feedback from both the Parks and Recreation Commission and the community; the SD will be presented to City Council on April 19, 2022 (RTC 22-179). The second phase of the Project includes preparing the necessary documents and providing support for the design and construction of the playground improvements.

DISCUSSION
In February 2021, the City issued a Request for Proposals (RFP) to solicit proposals for both phases of the Project. A total of four proposals were received and a proposal review panel consisting of staff from the Department of Public Works and Parks & Recreation Department evaluated each proposal against the criteria set forth in the RFP. As indicated in the beginning of this report, the City Council approved an agreement with Gates and Associates Landscape Architecture, Inc. (Gates & Associates) in July 2021 for the first phase of the project (RTC 21-234).The proposed Amendment No. 1 (Attachment 1) amends the scope of services to include services needed for the second phase of the project. The added scope of services generally includes: project management and coordination, preparation of detailed design and construction documents (plans, specifications, and engineer’s estimate) for public works bidding, assistance with obtaining building permit, and engineering support services during bid, award, and construction stages.

Staff recommends approval of Amendment No. 1 to the Agreement with Gates and Associates Landscape Architecture, Inc. to complete design services needed for the Westwood Oaks Playground Rehabilitation Project. Approval of this amendment will provide the design professional services necessary to complete the design of the Project and proceed to construction in a timely manner. Design of the Project is anticipated to be completed by spring 2023 and construction of the Project is anticipated to be completed by summer 2024. The agreement includes a section covering prevailing wage requirements.

City of Santa Clara Page 1 of 2 Printed on 4/14/2022
powered by Legistar™
22-442 Agenda Date: 4/19/2022

ENVIRONMENTAL REVIEW
Council action on this item does not constitute a “project” within the meaning of the California Environmental Quality Act ("CEQA") because it is an administrative activity that will not result in direct or indirect physical changes in the environment as set forth in section 15378(b)(5) of the CEQA Guidelines.

FISCAL IMPACT
The not-to-exceed amount under the current Agreement is $92,817. The proposed Amendment No. 1 increases the total not-to-exceed amount to $275,472. This amount includes $250,068 for basic services and $25,404 for additional services. Staff is requesting a 15 percent contingency, which is included in the not-to-exceed amount, for the second phase of design due to the age of the park and potential unforeseen conditions that may require additional efforts. There is sufficient funding available in the Westwood Oaks Park Playground Rehabilitation Project (CIP 3136).

COORDINATION
This report has been coordinated with the Parks & Recreation Department, Finance Department and the City Attorney’s Office.

PUBLIC CONTACT
Public contact was made by posting the Council agenda on the City’s official-notice bulletin board outside City Hall Council Chambers. A complete agenda packet is available on the City’s website and in the City Clerk’s Office at least 72 hours prior to a Regular Meeting and 24 hours prior to a Special Meeting. A hard copy of any agenda report may be requested by contacting the City Clerk’s Office at (408) 615-2220, email [email protected] <mailto:[email protected]> or at the public information desk at any City of Santa Clara public library.

RECOMMENDATION

1. Approve and authorize the Office of the City Manager or designee to execute Amendment No. 1 to the Agreement for Design Professional Services with Gates and Associates Landscape Architecture, Inc. for the Westwood Oaks Playground Rehabilitation Project in the amount not-toexceed $275,472; and

2. Authorize the Office of the City Manager or designee to make minor modifications to the agreement if needed.

Reviewed by: Craig Mobeck, Director of Public Works
Approved by: Office of the City Manager

ATTACHMENTS

1. Amendment No. 1

2. Original Agreement
City of Santa Clara Page 2 of 2 Printed on 4/14/2022
powered by Legistar™
Amendment No. 1 to Agreement/Gates and Associates, Inc. Page 1 Rev. 10/25/19
Ebix Insurance No. S200004741
AMENDMENT NO. 1

TO THE AGREEMENT FOR SERVICES

BETWEEN THE

CITY OF SANTA CLARA, CALIFORNIA,
AND
GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.

FOR

WESTWOOD OAKS PLAYGROUND REHABILITATION PROJECT

PREAMBLE
This agreement (“Amendment No. 1”) is entered into between the City of Santa Clara, California, a chartered California municipal corporation (City) and Gates and Associates Landscape Architecture, Inc., a California corporation, (Consultant). City and Contractor may be referred to individually as a “Party” or collectively as the “Parties” or the “Parties to this Agreement.”

RECITALS
A. The Parties previously entered into an agreement entitled “Agreement for Design Professional Services Between the City of Santa Clara, California, and Gates and Associates Landscape Architecture, Inc. for Westwood Oaks Playground Rehabilitation Project”, dated July 21, 2021 (Agreement); and B. The Parties entered into the Agreement for the purpose of having Consultant to provide landscape and engineering design services for the first phase of the Westwood Oaks Playground Rehabilitation Project (Project), as fully described in the Agreement; and the Parties now wish to amend the Agreement to provide landscape and engineering design services for the second phase of the project, which includes preparing bid documents (plans, specifications, and engineer’s estimate - PS&E) for public works bidding based on selected schematic playground rehabilitation plan, assisting with obtaining Building and Fire permits , and providing engineering support services during bid and award, construction, and post-construction phases of the Project.

NOW, THEREFORE, the Parties agree as follows:

AMENDMENT TERMS AND CONDITIONS

1. Section 6 of the Agreement, entitled “Compensation and Payment” is amended to read as follows:

In consideration for Consultant’s complete performance of Services, City shall pay Consultant for all materials provided and Services rendered by Consultant in accordance with Exhibit B, entitled “SCHEDULE OF FEES.” Amendment No. 1 to Agreement/Gates and Associates, Inc. Page 2 Rev. 10/25/2019
The maximum compensation of this Agreement two hundred seventy-five thousand four hundred seventy-two dollars ($275,472) subject to budget appropriations, which includes all payments that may be authorized for Services and for expenses, supplies, materials and equipment required to perform the Services. All work performed or materials provided in excess of the maximum compensation shall be at Consultant’s expense.

Consultant shall not be entitled to any payment above the maximum compensation under any circumstance.

2. Exhibit A, entitled “Scope of Services, Exhibit B, entitled “Schedule of Fees”, Exhibit C, entitled “Insurance Requirements”, and Exhibit E, entitles “Milestone Schedule,” of the Agreement are amended to read per Attachment No. 1:

3. Except as set forth herein, all other terms and conditions of the Agreement shall remain in full force and effect. In case of a conflict in the terms of the Agreement and this Amendment No. 1, the provisions of this Amendment No. 1 shall control.

Amendment No. 1 to Agreement/Gates and Associates, Inc. Page 3 Rev. 10/25/2019
The Parties acknowledge and accept the terms and conditions of this Amendment No. 1 as evidenced by the following signatures of their duly authorized representatives.

CITY OF SANTA CLARA, CALIFORNIA
a chartered California municipal corporation
Approved as to Form: Dated:

Office of the City Attorney
City of Santa Clara
Office of the City Manager
City Manager
1500 Warburton Avenue
Santa Clara, CA 95050
Telephone: (408) 615-2210
Fax: (408) 241-6771
“CITY”
GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.
a California Corporation
Dated:

By (Signature):

Name: Linda Gates
Title: Director of Strategy
Principal Place of
Business Address:
2671 Crow Canyon Road
San Ramon, California 94583
Email Address: [email protected]
Telephone: (925) 736-8176
Fax: (925) 833-8901
“CONTRACTOR”
Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 1

AGREEMENT FOR DESIGN PROFESSIONAL SERVICES

BETWEEN THE

CITY OF SANTA CLARA, CALIFORNIA,
AND
GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.

FOR

WESTWOOD OAKS PLAYGROUND REHABILITATION PROJECT

EXHIBIT A

SCOPE OF SERVICES
The Services to be performed for the City by the Consultant under this Agreement are set forth below.

I. GENERAL
This Scope of Services is anticipated as necessary to meet City’s objectives as described under Section II, BACKGROUND AND PROJECT, and Section III, DESCRIPTION OF SERVICES of this document. Consultant and City agree that this Scope of Services incorporates Consultant’s professional qualifications and experience and will meet the City’s objectives.

Consultant will be expected to provide complete, professional, high-quality Services and products; to consult City personnel, and others who are involved with the project; and to provide the expertise, guidance, advice, and assistance in accomplishing the work.

II. BACKGROUND AND PROJECT
Dedicated in 1961, 1.75 acres Westwood Oaks Park (Park) contains a recreation building, restrooms, an open play area, a playground, and various park amenities.

The Park is bounded by La Herran Drive to the east, and residential properties to the north, west, and south. Park’s playground and community building are located at 460 La Herran Drive. The site was assessed for condition in 2017 and the playground was deemed to be in critical condition while the building is in poor condition.

Consultant to perform all work necessary to meet the project goal including but not limited to : site, facility, and technology assessment; ADA evaluation, community outreach; develop a site specific master plan and playground rehabilitation plan; obtain a recommendation for approval from the Parks & Recreation Commission (PRC) and City Council (CC); develop selected playground schematic plan into bid documents (plans, specifications, and engineer’s estimate - PS&E) for public works bidding; provide assistance in obtaining Building and Fire permits for selected playground equipment; and provide engineering support services during bid and award, construction, and post-construction phases (PROJECT).

ATTACHMENT No. 1
Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 2
III. DESCRIPTION OF SERVICES
All design work shall be done in accordance with the Department of Transportation Standard Specifications and Details, City Standard Plans and Specifications, ADA Design Guidelines, latest building and fire codes, and other applicable codes and standards recommended by the Consultant. Below is an outline of required services; however, it is the responsibility of the consultant to independently assess the PROJECT and provide improvement recommendations to meet the goals for this PROJECT.

Required Services
Consultant shall provide landscape and engineering design services in two complete phases for the Westwood Oaks Playground Rehabilitation Project as indicated below.

Phase I:

1. Perform site, architectural, facility, and technology assessment (for the park building).

2. Evaluate ADA pedestrian pathway

3. Perform robust community outreach (surveys, meetings, consensus building etc.), to develop Site Specific Master Plan and Playground Schematic Plan (all inclusive)

4. Obtain a recommendation for approval from the PRC and subsequent approval from CC.

Phase II:

1. Develop selected playground schematic plan into bid documents (PS&E) for public works bidding

2. Provide assistance in obtaining a building permit.

3. Provide engineering support services during bid and award, construction, and post-construction phases.

4. Design ADA Pedestrians’ path of travel from public right-of-way, including on-street parking and sidewalk, to and within the new playground per ADA Design Guidelines.

5. Design conduit from street pullbox to a location in the closest proximity to building to provide future data connection

6. Landscape design of the improved area adjacent to the playground, not the entire park.

7. Irrigation design of the improved area near the playground, not the entire park.

Consultant shall provide the Services described herein through a project team, comprised of Consultant and sub-consultants identified as follows:

1. Consultant: GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 3

2. Sub-consultants to GATES AND ASSOCIATES LANDSCAPE
ARCHITECTURE, INC.:
1) Sandis – Surveying and Civil Engineering
2) BSK Engineers – Geotechnical Engineering
3) HY Architects – Building Assessment
4) Atium Engineer – Electrical Engineering
5) Hortscience – Arborist
6) Capital Engineering – Mechanical and Plumbing Engineering 7) KYASE – Structural Engineering
8) David Powers & Associates – Environmental
9) Proactive Risk Solutions – Certified Playground Inspector Any changes to the project team through the course of the Services shall be approved in writing by City.

IV. RESPONSIBILITIES OF CITY
CITY will provide the following information and support for the project as-available and applicable:

A. Record drawings (as-available)
B. CITY’s Standard Details, Specifications, Benchmark, and Design Criteria.

C. Storm Drain (SD), Sanitary Sewer (SS), Electric, Fiber, Water and Recycled Water Block Book Maps (as-available).

D. Geographic Information System (GIS) data including land parcels, street centerlines, City sanitary sewers, City storm drains, and aerial photographic tiles
E. Payment of permit application fees with other internal departments, if required.

F. Filing exemption under the California Environmental Quality Act, if applicable.

Besides the above, the City will work closely with the consultant to provide any other data or records, as available and necessary for the work involved.

V. BASIC SCOPE OF SERVICES

PROJECT MANAGEMENT
CONSULTANT shall:

A. Manage its team and overall project activities consistent with the direction from CITY in order to meet the project schedule and budget. Manage sub-consultants, maintain Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 4
schedule and budget, anticipate and mitigate potential design issues and delays and coordinate and update the City on the overall progress of the Project.

B. Any field work that involves subsurface excavation and/or coring, consultant is required to submit plan of work to the City for review and approval prior to proceeding.

C. Organize and attend project meetings with the City to discuss project progress, decisions, and direction and to coordinate activities. Meetings shall be held at key project milestones and shall include, but are not limited to:

1. Kick-off Meeting (Phase I)

2. Preliminary/Evaluation Meeting (Phase I)

3. Community meeting (Phase I)

4. Parks and Recreation Commission Meeting (Phase I)

5. City Council Meeting (Phase I)

6. 35% Design Review Meeting (Phase II)

7. 75% Design Review Meeting (Phase II)

8. Punch list/Project acceptance Meeting (Phase II)
D. Coordinate with CITY, design team members, consultants, utility companies, other government agencies, and other affected parties as required throughout the duration of the project as well as the Quality Assurance/Quality Control (QA/QC) activities for project deliverables.

E. Prepare, monitor, and update progress schedule in MS Project format beginning at the kickoff meeting and ending at contract award for the last submittal package.

Schedule shall show significant milestones for the project. CONSULTANT shall notify CITY if there are delays or potential delays in any phase of the project. In such cases, CONSULTANT shall make up the schedule in subsequent phases of the project or provide information to CITY substantiating a request for time extension (which may not be approved). The schedule shall be maintained at all times and shall be updated each time progress and milestones are achieved and/or changed.

F. Meetings: Meetings shall be budgeted for and invoiced under each respective Task or activity requiring a meeting and not as project management. Preparation for meetings shall be considered as included in the Task or activity for which the meeting is involved. A kick-off meeting shall be conducted with designated CITY staff prior to beginning work to review anticipated Tasks and schedule, review available information and needs, and address any outstanding questions regarding the project moving forward raised by CITY or CONSULTANT. During the course of Services while there is active work on the PROJECT, CONSULTANT shall schedule and attend brief bi-weekly (every other week) conference calls with CITY. The purpose of the bi-weekly conference calls will be to keep CITY appraised on the PROJECT's progress and address any issues that may arise during the course of Services.

G. Provide monthly progress reports.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 5
H. Stakeholder Coordination: CONSULTANT shall coordinate with project stakeholders as needed to inform each stakeholder of the project work and incorporate any necessary accommodations into the final submittal documents.

I. Provide Review/Plan Check Log (Response Matrix) summarizing comments received from various City Departments/Divisions and agencies. Response Matrix shall include, but not be limited to, commenting department/division or agency, comments, response to comments, action items, and person responsible for follow up.

Consultant shall be responsible for resolving comments from each commenter and shall identify to City any comments that cannot be resolved to have final discussion and resolution. Submit Response Matrix in electronic format with each route of plan check submittal.

J. Conduct QC reviews in accordance with its QA Program guidelines. CONSULTANT shall provide a copy of its QA Program guidelines and shall provide a QC report at the end of each Task. Time spent for QA-QC reviews for specific deliverables shall be budgeted and billed under each respective task requiring QA-QC review and not as Project Management.

K. Invoicing and Contract Administration: CONSULTANT administrative staff time spent preparing invoices for Services complete shall be considered as included in the overhead of the CONSULTANT’s basic hourly rates and shall not be billed.

Additionally, addressing administrative issues regarding the professional Services agreement, such as preparing additional Services requests or budget modifications, shall also be considered as included in the overhead of the CONSULTANT’s basic hourly rates and shall not be billed.

Deliverables:

1. Progress schedules in MS Project format (submitted electronically as an 11” x 17” pdf file and in native MS Project format).

2. QA Program guidelines and QC reports for each Task (in pdf file).

3. Meeting agendas, preparation materials, and meeting minutes for each project meeting (in pdf file).

4. Monthly progress reports and invoices (in pdf file).

Phase I
Task 1.0: Preliminary Engineering/Evaluation

1.1 Attend Project Kick-Off Meeting.

1.2 Visit Project’s site to inspect site conditions, existing equipment, and facilities to determine the existing conditions and propose recommendations to City for the improvements. Contact all regulatory agencies that will affect the proposed works to determine applicable codes and ordinances.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 6

1.3 Perform necessary evaluations of the site, equipment, facilities, and ADA pathway to identify opportunities and constraints and review Facility Condition Assessment completed by the City in 2017. Prepare an evaluation report for the site noting condition of existing facilities, infrastructures, code issues, and regulatory issues.

Provide upgrade or replacement recommendations according to the evaluation and report review.

1.4 Provide draft community and stakeholder engagement strategies.

1.5 Meet with City staff to obtain additional information and input as needed. Provide all necessary design services, including but not limited to landscape, civil, structural, electrical, and mechanical design according to the evaluation and recommendations, and the following design criteria:

1.5.1 2019 California Building Codes.

1.5.2 2019 California Fire Codes.

1.5.3 2019 National Fire Protection Association (NFPA): 2019 NFPA 72.

1.5.4 Playcore grant requirements.

1.5.5 Remote alarm/communication for HVAC system.

1.5.6 WIFI and electronic access for building.

1.5.7 Parks and Recreations Design Standards.

1.5.8 Comply with age-friendly, inclusionary design standards, and values.

1.5.9 Sustainability and green infrastructure guidelines in National Recreation and Park Association (NRPA).

1.5.10 Fall protection system for roof-top equipment (if needed).

1.5.11 Playground safety, hazard identification, equipment specifications, surfacing/space requirements guidelines in NRPA’s Certified Playground Safety Inspector (CPSI) program. Consultant shall have CPSI as part of its team.

1.6 Perform geotechnical investigation and provide report.

1.7 Work with City staff and community to develop park master and playground schematic plan(s).

1.8 Perform needed topographic survey for existing site, plans layout, and final approved improvements (from the evaluation/recommendation) for use as base layout for the Project’s master and playground schematic plans.

1.9 Provide project estimate that includes an itemized list of bid items. The project estimate shall be accurate and prepared based upon current construction pricing and escalated to mid construction. CONSULTANT shall review recent bids, and contact vendors, suppliers, and contractors as necessary to develop an accurate cost estimate. The CONSULTANT shall provide the assumptions and supporting documents used to prepare the estimate. The project estimate shall consider the following factors:

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 7

1. Recent similar Projects bided in the Bay Area, especially in the South Bay.

2. Current economic trend.

3. When the Project will be bided.

4. When construction will occur.

5. The risks that contractors need to consider for the Project.

1.10 Develop project schedule. Schedule shall include all needed times to complete all tasks, including City’s review times, permitting process, and construction period.

1.11 Meet with City staff to review City comments on park master and schematic design, and gain concurrence as to how the documents will be revised as appropriate to incorporate City comments.

1.12 Plan, coordinate, schedule, attend meetings, and produce meeting minutes with action items for all meetings with the City as deemed necessary to efficiently complete this phase of the design in a timely manner.

Task 1 Deliverables – Electronic and hard copy format:

1. Evaluation report (draft and final) – One (1) PDF of draft and final report and one (1) Microsoft Word file of final report.

2. Soil report – One (1) PDF

3. Draft park master & schematic plans: One (1) PDF and one (1) AutoCAD file.

4. Consultant’s CPSI signs off on schematic design for playground with emphasis on all elements of play and related requirements for the playground.

5. Project schedule – One (1) PDF and one (1) Microsoft Project file.

6. Budget estimate – One (1) PDF and one (1) Microsoft Excel file.

7. Miscellaneous project information (as requested).

8. Meeting minutes – one (1) PDF and one (1) Microsoft Word file.

Task 2.0: Community Outreach
Consultant shall work closely with City staff to develop meeting strategy and format to engage the community.

2.1 Develop presentation materials, exhibits, design alternatives, and questionnaires for public workshops/meetings.

2.2 Plan, coordinate, schedule, attend workshops/meetings, and produce meeting minutes. Plan for three (3) workshops/meetings.

2.3 Based on community’s input, refine, and develop final park master plan and playground schematic plan.

2.4 Produce meeting minutes with action items.

Task 2 Deliverables – Electronic and hard copy format:

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 8

1. Exhibits, alternative, & questionnaires – PDFs and hard copies as needed.

2. Final master & schematic plans: One (1) PDF and one (1) AutoCAD file

3. Miscellaneous Project information (as requested).

4. Meeting minutes – one (1) PDF and one (1) Microsoft Word file.

Task 3.0: PRC & CC Meetings
Consultant shall assist City staff to present the Project to Parks & Recreation Commission and City Council.

3.1 Prepare PowerPoint presentation using City template, including plans and alternatives, for Parks & Recreation Commission meetings. Plan for two (2) PRC meetings.

3.2 Prepare PowerPoint presentation, including plans and alternatives, for City Council Meetings. Plan for two (2) meetings.

3.3 Produce meeting minutes with action items.

3.4 Provide CEQA determination and assist in filing paperwork.

Task 3 Deliverables – Electronic and hard copy format:

1. Presentation materials, exhibits, & alternative – PDFs and MS PowerPoint file.

2. Revised final master & schematic plans: One (1) PDF and one (1) AutoCAD file.

3. Miscellaneous Project information (as requested).

4. Meeting minutes – one (1) PDF and one (1) Microsoft Word file Phase II
Task 4.0: 35% Construction Documents
Based on the approved playground schematic plans, approved project scope within budget, and any adjustments authorized or directed by the City, the Consultant shall develop and refine the design, and prepare construction documents. Consultant’s CPSI shall review and certify bid documents to meet and comply with all regulation regarding playground safety.

Plans shall be drawn to scale, on D-size (24” X 36”) sheets, at an engineering scale up to 1” = 40’ maximum, conforming to City’s Design Criteria. Plans are to be drawn by AutoCAD 2021 or earlier versions, using City-provided standard AutoCAD template with background layout from Consultant’s topographic survey.

4.1 Prepare 35% construction documents and supporting information for the City’s review, including, but not limited to:

4.1.1 Consultants shall follow City’s Design Criteria and plan format to prepare Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 9
35% Plans and supporting information for the City’s review, including but not limited to the followings:

A. Plans with details of major design components as necessary such as:

1. Site drawing

2. Landscape drawings

2. Playground drawings

3. Park Amenity drawings

4. Electrical drawings

5. Civil drawings

6. Structural drawings

B. 35% Plans shall include all existing utilities on-site and immediate surrounding off-site areas. Pertinent background information as relating to proposed improvements such as, but not be limited to, playground layouts, fence, gate, picnic area, pedestrian pathway, property lines, site entrance/exist driveway, adjacent streets shall be shown.

C. Design Playground to meet following criteria:

1. Elements of Play: swinging, climbing, brachiating, spinning, sliding, balancing, sensory and free play.;

2. Play Value: design that addresses how many persons served, how often and how long equipment is used.;

3. Inclusion: a thoughtful application of universal design principles that provide diverse activities that address physical, socialemotional, sensory, cognitive, and communicative needs of all children and where generations can play together regardless of age and limitation.;

4. Physical Activity: intentionally promote physical activity through active play and encourage the developmental progression of skills through healthy movement (developmentally appropriate for beginner, intermediate, advanced levels).;

5. Nature: design the play environment within a living landscape, supporting the natural habitat/biodiversity and health of plants, animals, and water.

6. Playcore Grant requirements.

7. Playground Safety: Guidelines and requirements from NRPA’s CPSI program.

D. Refer to the City website for Building Permit and Fire Department Permit application package requirements.

4.2 Prepare an updated engineering cost estimate. If 35% engineering cost estimate prepared at this point exceeds the preliminary construction budget approved at the end of the preliminary engineering/evaluation phase, the Consultant shall explain and justify the increase and shall submit a list of proposed modifications to bring Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 10
the cost within budget.

4.3 Prepare an updated project schedule.

4.4 Meet with City staff as needed to review City comments on 35% submittal and gain concurrence as to how the documents will be revised, as appropriate, to incorporate City comments.

4.5 Provide comments from Consultant’s CPSI on playground design and confirmation of safety compliance of 35% construction documents.

4.6 Plan, coordinate, schedule, attend meetings, and produce meeting minutes with action items for all meetings with the City as deemed necessary to efficiently complete this phase of the design in a timely manner.

4.7 Conduct a quality control (QC) review of design documents (Plans, Specifications, and Engineer’s Cost Estimates).

4.8 CITY will circulate the submittal package to internal CITY departments for review and comments. CONSULTANT shall be responsible for submitting the package to external stakeholders if required. CONSULTANT shall prepare written responses to all written comments received. All redlined drawings shall be returned with CONSULTANT’s response on the redlined drawings.

4.9 CONSULTANT shall be responsible for resolving comments from each commenter and shall identify to CITY any comments that cannot be resolved. CONSULTANT shall conduct a 35% comments review meeting with CITY to discuss comments on the submittal package, to identify any significant design issues, and gain concurrence as to how the design shall be revised as appropriate to incorporate CITY’s comments.

4.10 Pathway Upgrades to ADA
Provide Phase II Construction Documentation thru Post Construction to replace and correct all CBC accessibility issues to the perimeter sidewalks and pathways for the park such as broken concrete, excessive slopes, trip hazards, and crack / gap hazards. New work shall generally match the existing locations, grading, and layout of existing flatwork to be repaired or replaced. The replacement sidewalk shall meet the city’s maintenance access needs and may have an increased width of 8’ vehicular concrete. Deliverables will include all additional coordination, cost estimation, demolition, layout, grading, drainage improvements, lighting/ electrical plan, pervious paving surfaces, landscaping, irrigation, and details for the access improvement work.

Task 4 Deliverables – Electronic and hard copy format:

1. 35% Plans – One (1) PDF and one (1) AutoCAD file.

2. 35% Engineering cost estimate – One (1) PDF and one (1) Microsoft Excel file.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 11

3. Updated project schedule – One (1) PDF and one (1) Microsoft Project file.

4. Quality control checklist for 35% PS&E submittal – One (1) PDF and one (1) Microsoft Word or Excel file.

5. CPSI comment/report – One (1) PDF.

6. Written response matrix – One (1) PDF and one (1) Microsoft Word or Excel file.

7. Miscellaneous Project information (as requested).

8. Meeting minutes – One (1) PDF and one (1) Microsoft Word file.

Task 5.0: 75% Construction Documents
Based on City’s comments and direction on the 35% PS&E, Consultant shall revise the 35% PS&E to produce the 75% PS&E. Consultant shall:

5.1 Prepare 75% construction documents and supporting information for the City’s review and approval.

5.1.1 Construction details of proposed improvements shall be included in the 75% Plans.

5.1.2 Provide technical specifications.

5.1.3 Provide Structural plans and calculations for Light post footings and playground structure footings.

5.1.3 Provide modified sections to City standard specifications to suit Project.

Modified sections include, but not be limited to, general information, summary of work, measurement and payment for bid items, permitting and agency regulatory requirements, etc.

5.1.4 Provide required information to the City’s Project Specific Specification Book (Division 0, 1, and 2). Required information from Consultant for City’s frontend specifications are, but not be limited to, the followings:

1. Description of work

2. Type of Contractor’s License required

3. Construction Schedule

4. Bid Schedule

5. Requirements for Contractor’s Statement of Qualifications (e.g. experience requirements for similar work and contract values)

6. Identification of any changes to the City’s standard specifications that are required.

5.2 Prepare an updated engineering cost estimate. If the cost is higher than allocated construction budget, Consultant need to create Add Alternate items so that the project cost estimate is within available project budget.

5.3 Prepare an updated project schedule.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 12

5.4 Meet with City staff, as needed, to review City comments on 75% submittal and gain concurrence as to how the documents will be revised as appropriate to incorporate City comments.

5.5 Provide comments from Consultant’s CPSI on playground design and confirmation of safety compliance of 75% construction documents.

5.6 Plan, coordinate, schedule, attend meetings, and produce meeting minutes with action items for all meetings with the City as deemed necessary to efficiently complete this phase of the design in a timely manner.

5.7 Provide written response matrix to City’s comments on 35% PS&E.

5.8 Conduct a quality control (QC) review of design documents (Plans, Specifications, and Engineer’s Cost Estimates).

Task 5 Deliverables – Electronic and hard copy format:

1. 75% Plans – One (1) PDF and one (1) AutoCAD file.

2. 75% Specifications – One (1) PDF and one (1) Microsoft Word file.

3. 75% Engineering cost estimate – One (1) PDF and one (1) Microsoft Excel file.

4. Updated project schedule – One (1) PDF and one (1) Microsoft Project file.

5. Meeting minutes – One (1) PDF and one (1) Microsoft Word file.

6. Quality control checklist for 75% design submittal.

7. CPSI comment/report – One (1) PDF

8. Written response matrix – One (1) PDF and one (1) Microsoft Word or Excel file.

Task 6.0: 100% Construction Documents
Based on City’s comments and direction on the 75% PS&E, Consultant shall revise the 75% PS&E to produce the 100% PS&E. Consultant shall:

6.1 Prepare 100% construction documents and supporting documents.

6.1.1 Phase percentage statement such as “100% Plans. Not for Construction” shall be removed from the 100% Plans and each sheet of the plans set shall be stamped and signed by the Consultant’s Engineer of appropriate discipline.

6.1.2 Specifications shall be stamped and signed (on Document 00030 – Seal) by Consultant’s Project Engineer.

6.2 Prepare an updated Engineering Cost Estimate with backups and justifications for unit pricing.

6.3 Prepare an updated Project Schedule.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 13

6.4 Provide Documents for City’s PS&E approval process. Required documents are, but not be limited to, engineer’s estimate using the schedule of quantities format, recent similar project bid summaries to validate engineer’s estimate, consultant Peer Review Certification, consultant Lessons Learned from other similar projects that were applied to this Project.

6.5 100% PS&E shall be Peer reviewed and Certification of Peer Review shall be submitted with the 100% Submittal.

6.6.1 A statement (see statement in Sub-Section 5.6.2 below) to indicate Peer Review has been performed and signature of the Engineer who performed it shall be added to the Plans Cover Sheet.

Certification of Peer Review: The following paragraph shall be put on the company letter head, dated, and signed by the Peer Review Engineer. “The undersigned hereby certifies that a professional peer review of these plans and the required designs was conducted by me, a professional landscape architect with expertise and experience in the appropriate fields of landscaping equal to or greater than the Architect of Record, and that appropriate corrections have been made.”

6.6 Prepare and submit Special Inspection Form for the Project.

6.7 Meet with City staffs as needed to review City comments on 100% submittal and gain concurrence as to how the documents will be revised as appropriate to incorporate City comments.

6.8 Provide comments from Consultant’s CPSI on playground design and confirmation of safety compliance of 100% construction documents.

6.9 Plan, coordinate, schedule, attend meetings, and produce meeting minutes with action items for all meetings with the City as deemed necessary to efficiently complete this phase of the design in a timely manner.

6.10 Provide written response matrix to City’s comments on 75% PS&E.

6.11 Provide list of potential bidders including company name, email address, contact number, and address of business.

Task 6 Deliverables – Electronic and hard copy format:

1. 100% Plans – One (1) PDF and one (1) AutoCAD file.

2. 100% Specifications – one (1) PDF and one (1) Microsoft Word file.

3. Structural Calculations – One (1) PDF.

4. Consultant Lessons Learned – One (1) PDF.

5. Certification of Peer Review – One (1) PDF.

6. 100% Engineering Cost Estimate – One (1) PDF and one (1) Microsoft Excel file.

7. Updated Project Schedule – One (1) PDF and one (1) Microsoft Project file.

8. All Permit application packages with all necessary supporting documentations.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 14
9 Special Inspection Form – One (1) PDF.

10. Meeting minutes – One (1) PDF and one (1) Microsoft Word file.

11. Quality control checklist for 100% design submittal.

12. CPSI comment/report – One (1) PDF

13. Written response matrix – One (1) PDF and one (1) Microsoft Word or Excel file Task 7.0: Bid Documents (P&S)
Based on City’s comments and direction on the 100% PS&E, Consultant shall revise the 100% PS&E to produce the Bid Documents. Consultant shall:

7.1 Incorporate City review comments of 100% PS&E into Bid Documents.

7.2 Incorporate permit issuers’ comments into P&S and coordinate with permitting departments and agencies to obtain acceptance of permit application package.

7.3 Prepare Bid Documents (P&S).

7.3.1 Bid Plans shall be wet stamped and signed by the Consultant’s Engineer of appropriate discipline. Plans shall be drawn to scale and plotted onto D-size sheets.

7.3.2 Bid Specifications shall be wet stamped and signed (on Document 00030 – Seal) by Consultant’s Project Engineer.

7.4 Plan, coordinate, schedule, attend meetings, and produce meeting minutes with action items for all meetings with the City as deemed necessary to efficiently complete this phase of the design in a timely manner.

Task 7 Deliverables – Electronic and hard copy format:

1. Bid Plans – One (1) PDF of wet-signed/stamped, D-size and one (1) AutoCAD file.

2. Bid Specifications – One (1) PDF of wet-signed/stamped, A-size and one (1) Word file.

3. Written response matrix – One (1) PDF and one (1) Microsoft Word or Excel file.

4. Quality control checklist for bit set submittal.

5. Final Building and Fire permits.

6. Meeting minutes – One (1) PDF and one (1) Microsoft Word file.

7. Written response matrix – One (1) PDF and one (1) Microsoft Word or Excel file.

Task 8.0: Bid and Award Phase
Consultant shall provide assistance to the City during the bidding and award phase, answer questions from bidders, help and prepare exhibits for addenda when necessary, assist the City in evaluation of bids received, and provide a written recommendation for the award of contract, when requested.

Consultant shall:

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 15

8.1 Attend and conduct Pre-Bid Conference/Sites Visit.

8.2 Assist the City with responses to bidder’s inquiries through the City’s Project Manager.

8.3 Assist the City with addenda to the construction documents as needed to respond to bidder’s inquiries and clarify the intent of bid documents.

8.4 Assist the City in evaluating bids (if required by the City).

8.5 Within fourteen (14) days from the bid opening date, prepare and submit a conformed set of contract documents (Plans and Specifications) incorporating any and all addenda (if needed).

Task 8 Deliverables – Electronic and hard copy format:

1. Written response to bidder’s inquiries – Signed PDF.

2. Support information for addenda – Signed PDF.

3. Written recommendation letter to award of contract for the Project – Signed PDF.

4. Conformed Set (if needed) – One (1) PDF of Plans and Specifications, one (1) AutoCAD file of Plans, and one (1) Microsoft Word file of Specifications.

Task 9.0: Construction Phase
Consultant’s responsibility to provide basic services for the construction phase under this Agreement commences with the “Notice to Proceed” (NTP) of the contract for construction and terminates on the date the City approves the certificate of completion of the Project.

9.1 Consultant will assist the City in providing administration of the contract for construction. Duties, responsibilities and limitation of authority of Consultant shall not be restricted, modified, or extended without written agreement of the City.

9.2 Consultant shall attend the Pre-construction meeting.

9.3 Consultant shall visit the site as required for the benefit of the Project during this phase. During these site visits, Consultant shall attend job progress meetings, presubmittal meetings, pre-installation meeting, and other meetings as required by the City. Consultant’s structural, civil, and electrical sub-consultants shall visit the site as required when work related to their discipline is in progress.

9.4 Consultant shall have CPSI perform an onsite visit and inspection for conformance of playground installation to satisfy Bid Documents and provide report.

9.5 Consultant shall make construction observation visits throughout the construction phase. Consultant shall issue an observation report after each visit. Assume up to three (3) meetings.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 16

9.6 In addition to the construction observation visits, Consultant shall review technical submittals, shop drawings, product data, product samples, and product warranties from the contractor for conformance with the specifications and drawings. The Consultant’s action shall be taken with such reasonable promptness so as to cause no delay in the work, while allowing sufficient time in Consultant’s judgment to permit adequate review. The Consultant will be allowed a maximum of seven (7) calendar days for review of submittals. Consultant’s review shall not constitute review of safety precautions or, unless otherwise specifically stated by Consultant, of construction means, methods, techniques, sequences or procedures.

Consultant’s review of specific items shall not indicate approval of an assembly of which the item is a component. When professional certification of performance characteristics of materials, systems or equipment is required by the contract documents, Consultant shall be entitled to rely upon such certification to establish that the materials, systems or equipment will meet the performance criteria required by the contract document.

9.7 Consultant shall respond to Contractor’s Request for Information (RFI) and Request for Substitution (RFS). Interpretations and decisions of the Consultant shall be consistent with the intent of and reasonably inferable from the Contract Documents and shall be in writing or in the form of drawings. Consultant shall be allowed a maximum of seven (7) calendar days to respond to RFIs and RFSs that impact the Project schedule or a maximum of fourteen (14) calendar days to respond to RFIs and RFSs that do not impact the Project schedule.

9.8 The Consultant shall prepare the Scope of Work, including sketches, for Field Instructions issued to the Contractor. When requested by the City, Consultant shall review Change Order (CO) pricing and provide written responses for the City’s review and finalizing said COs
Task 9 Deliverables – Electronic and hard copy format:

1. Signed PDFs of Reviewed Contractor Submittals, Shop Drawings, RFIs, RFSs, and Field Instructions.

2. Signed PDFs of COs’ recommendations.

3. Signed PDFs of Field reports by Consultant and sub-consultants.

Task 10.0: Post-Construction Phase

10.1 When requested by the City, Consultant shall conduct reviews to assist the City to determine the date or dates of Substantial Completion and the date of Final Completion. Consultant’s decisions with City approval on matters relating to aesthetic effect may be final if consistent with the intent expressed in the Contract Documents.

10.2 Upon request by Contractor, in accordance with contract Specifications, for Substantial Completion and later Final Completion, Consultant shall assist City in determining if the Project is ready for the stage of completion requested by the Contractor. Consultant shall provide City with a written recommendation.

Design Professional Agreement with Gates and Associates/Exhibit A-Scopes of Services Rev. 04-12-21 Page 17

10.3 Consultant shall perform a walk-through of the Project site, review Contractor Punch List, and provide written response with status and action of items on the Punch List. Consultant shall attend final walk-through of the Project site with the City, verify Punch List completion, and provide written response with recommendation regarding Project acceptance and close-out.

10.4 Consultant shall review Contractor-supplied Operation and Maintenance manuals and Warranties to determine their completeness and compliance with Construction Contract and provide written recommendation for acceptance.

10.5 Consultant’s CPSI shall inspect and certify the playground prior to its open to the public. Provide CPSI Certification within five (5) days of final inspection.

10.6 Provide a complete set of the Record Drawings and all X-ref files “bound,” including other associated fonts, plot style files on AutoCAD, including electronic copies in PDF format. CONSULTANT may, at its own expense, prepare and retain a copy of each drawing for its permanent file.

10.7 At ten (10) months following the issuance of final completion and prior to the expiration of any guarantees, City and all its Consultants shall visit the Project with Contractor and: 1) Review the work and identify observable defects and deficiencies, 2) Evaluate the performance, durability and appearance of installed products, materials and system as they relate to suitability for the intended use; 3) Evaluate the Project’s function and City’s use of the Project as reflection of the original program intent; and 4) Submit a written memorandum to City concerning the foregoing.

Task 10 Deliverables – Electronic and hard copy format:

1. Substantial Completion/Final Completion recommendations and Reviewed Punch List – One (1) signed PDF.

2. Record Drawings – One (1) PDFs and one (1) AutoCAD files on CD/DVD.

3. CPSI Certification – One (1) PDF.

4. 10 Months Report – One (1) signed PDF.

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 18

AGREEMENT FOR DESIGN PROFESSIONAL SERVICES

BETWEEN THE

CITY OF SANTA CLARA, CALIFORNIA,
AND
GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.

FOR

WESTWOOD OAKS PLAYGROUND REHABILITATION PROJECT

EXHIBIT B

SCHEDULE OF FEES
I. GENERAL PAYMENT
The total payment to the Consultant for Basic Services, as stated in Exhibit A, shall not exceed $250,068. The amount billed to City for pre-approved Additional Services shall not exceed the sum of $25,404. In no event shall the amount billed to City by Consultant for Services under this Agreement exceed $275,472, subject to budget appropriations.

Consultant shall bill City on a monthly basis for Services provided by Consultant during the preceding month on an invoice and in a format approved by City and subject to verification and approval by City. Billing shall be proportionate to the Services performed for each task completed. The invoice shall describe the Task completed, and percentage completed by Task, and total during the invoice period.

The invoice shall also show the total to be paid for the invoice period. City will pay Consultant within thirty (30) days of City’s receipt of an approved invoice.

II. BASIC SERVICES
The total payment to Consultant for all work necessary for performing all Tasks, as stated in Exhibit A, shall be in proportion to Services rendered and on a Timeand-Material not-to-exceed basis.

The Consultant fee allocated to each Task, as shown below, shall be the Consultant’s full compensation for all the Consultant Services required for the Project and by this Agreement, as directed by the City, and no additional compensation shall be allowed. The total amount of all the Tasks is a not-toexceed amount.

The amount for each Task and the total amount of all the Tasks are as listed below:

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 19
Description of work and task Cost for Basic
Services
Phase 1 Design
Task No. 1 – Preliminary Engineering and Evaluation
(Completed)
$59,725
Task No. 2 – Community Outreach (Completed) $13,865
Task No. 3 – Parks and Recreation Commission and City
Council’s Approval (Completed)
$7,120
Phase 2 Design
Task No. 4 – 35% Construction Documents $39,520
Task No. 5 – 75% Construction Documents $42,445
Task No. 6 – 100% Construction Documents $26,643
Task No. 7 – Bid Documents $12,045
Task No. 8 – Bid and Award Phase $8,565
Task No. 9 – Construction Phase $29,185
Task No. 10 – Post-Construction Phase $10,955
TOTAL COST $250,068
In no event shall the amount billed to City by Consultant for BASIC SERVICES under this Agreement exceed two hundred fifty thousand sixty-eight dollars ($250,068).

III. REIMBURSABLE EXPENSES
There are no reimbursable expenses.

IV. ADDITIONAL SERVICES
Additional Services consists of work not included in the Scope of Services outlined within this Agreement. Pre-approved Additional Services shall be billed to City at the fixed hourly rates shown below in Section V, RATE SCHEDULE, or at an agreed negotiated lump sum price. Monthly billing for Additional Services shall be consistent with the term set forth in this Agreement. Payment for any Additional Services is allowed only if written authorization is given by the City Engineer in advance of the work to be performed. Additional Services shall not exceed $25,404.

V. RATE SCHEDULE
Personnel Charges
Charges for personnel engaged in professional and/or technical work are based on the actual hours directly chargeable to the project.

The pay rates for the project by classification are listed below:

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 20
Primary Consultant – GATES AND ASSOCIATES LANDSCAPE
ARCHITECTURE, INC.:

I. HOURLY FEES
HOURLY FEES FOR SERVICES OF:

Partner
Principal
Associate Principal
Senior Associate
Job Captain
Sr. Irrigation Designer
Irrigation Design Technician
Sr. Visual Communications Designer
Community Outreach Facilitator
Marketing Coordinator
Administrative/Drafter
II. EXPENSES (REIMBURSABLES)

RATE SCHEDULE
GATES+ ASSOCIATES
RATE PER HOUR:
$190.00 - $225.00
$160.00 - $195.00
$140.00 - $165.00
$130.00 -$145.00
$120.00 -$135.00
$145.00 -$170.00
$95.00 -$115.00
$130.00 -$155.00
$145.00 -$175.00
$95.00 - $145.00
$90.00 - $125.00
A. Consultants at approximately the same rates indicated above or on consu ltant fee schedules.

B. Other direct expenses at cost which may include:

1. Printing and reproduction costs.

2. Mileage and travel costs.

3. Miscellaneous
Hourly rates may be adjusted on January 1 of each year and shall apply for any services rendered after that date.

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 21
Subconsultant Billing Rates:

SAND IS STANDARD HOURLY CHARGE RATES @ SAND IS
• Enforced January 1, 2021 Through December 31, 2021

ENGINEERING AND QSD/P SERVICES HOURLY RATE
Project Control Specialist/ Clerical $90.00
Computer/ Field/ Engineer Technician Level I $105.00
Level II $115.00
Level Ill $125.00
Sr. Engineer Technician $130.00
Field Technician Level I $105.00
Level II $125.00
Level Ill $135.00
Design Engineer Level I $120.00
Level II $125.00
Level Ill $130.00
Project Engineer/ Traffic Engineer Level I $140.00
Level II $155.00
Level Ill $175.00
Senior Engineer Level I $190.00
Engineering Project Manager Level I $185.00
Level II $215.00
Associate Project Manager/ Senior Project Manager/
Senior Traffic Engineer $235.00
Principal $350.00
Forensic Review/ Analysis/ Claim Support $250.00
SURVEYING SERVICES/ HIGH DEFIHITIDN SCANNING/ 3-D MODELING SERVICES CAO/ Surveying/ Scanning Technician Level I $105.00
Level II $110.00
Level Ill $125.00
Project Surveyor/ Scanning Specialist Level I $135.00
Level II $145.00
Level Ill $175.00
Survey Project Manager Level I $185.00
Level II $215.00
Senior Field Survey Supervisor(PLS) $235.00
Utility Locating Services 1-Person Crew $175.00
Utility Locating Manager $150.00
Traffic Safety Flagger $115.00
1-Person Survey Crew $195.00
2-Person Crew $305.00
2-Person Survey Crew w/ Apprentice $385.00
Reimbursable Costs Printing, monuments, materials, outside services and consultants, courier/delivery services, express/ overnight mail, travel/per diem, agency fees advances, etc., at cost plus 10%.

Overtime All overtime charges are invoiced on the basis of one and one-half times the above rates. Double time invoiced at two times the above rates.

Escalation Escalation for future years shall be at a minimum of 3.5% increase per year. Sand is at its sole discretion may utilize its subsidiaries to perform the services presented in this proposal.

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 22

FEE SCHEDULE
································-····-········································································· Hourly Rates
Principal $235/hr.

Associate $190/hr.

Architect 3 $180/hr.

Architect 2 $160/hr.

Architect 1 $150/hr.

Job Captain $130/hr.

Senior Draftsperson $120/hr.

Draftsperson $115/hr.

Jr. Draftsperson $105/hr.

Int. Project Designer $130/hr.

Int. Staff Designer $110/hr.

Administrative Staff S 85/hr.

Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 23
BSK Associates - January 1, 2021 to June 30, 2021 Prevailing Wage Schedule of Fees

PERSONNH RA TES
PROfESSIONAl STAFF TECHNICAi. STAFF (_PREVAILING WAGE~
Principal $ 248.00 Field Supervisor $ 171.00
Senior Professional $ 22 1.00 Group 1 -Special Inspector $ 149.00 Project Professional II $ 204.00 Group 2 -Special Inspector $ 142.00 Project Professional I $ 171.00 Group 3 -Engineering Technician $ 129.00 staff Professional II $ 154.00 Group 4 - Technician $ 112.00 staff Professional I $ 138.00 Ground Penetrating Radar Scanning Technician $ 289.00 SeismicGIS $ 193.00 Core Dri lling Technician $ 210.00
GIS Specialist $ 138.00 Floor Flatness Testing Technician $ 189.00 Information Specialist II $ 154.00 Sample Pickup/ Transportation/ Delivery $ 108.00 Information Specialist I $ 138.00 Laboratory Technician $ 108.00 CAD $ 100.00 Administrative Assistant/ Clerical $ 86.00 Project Administrator $ 95.00 litigation support 1.Sx standard rate

EQUIPMENT BASIS OF CHARGES FOR FIELD TECHNICIAN SERVICES Nuclear Gauge (Day) $ 61.00 Field Work from Oto 4 hours Bill 4 hours Ult rasonrc Weld Equipment (Day) $ 61.00 Field Work from 4 to 8 hours Bill 8 hours Torque Wrench (Day) $ 61.00 Field Workover8 hours/Saturdays Bill timeandahalf Proof load Equipment {Day) $ 61.00 Sundays, holi days and over 12 hours Bi ll double t ime Rebar Locator/ Pachometer $ 110.00 Swing shift (4:00pm to Midnight) Add $20.00 per hour Hand Auger (Day) $ 221.00 Graveyard Shift Add $30.00 per hour Water Meter (Day) $ 56.00 Show-op t ime (no work performed) Bill 2 hours Drilling Kit - Paint, stakes and lath -(Project) $ 29.00 Sampling or cylinder pick.up, minimum charge Bill 2 hours Drilling Supplies - Reuse of tubes/caps (Project) $ 276.00 Manometer (Day) $ 22 1.00 DIR/PREVAILING WAGEADMINISTRA nON FEES (.MONTHL ri Double Ring lnfiltrometer (Day) $ 551.00 Certified Payroll/ DIR Upload $ 300.00 Non-Performance Certified Payroll/ DIR Upload $ 100.00
ANAL YSISSOFTWARE USAGE FEES Subcontractor Management/ Compliance Forms $ 100.00 glNT(Project) $ 56.00 Addit ional LCP Track.er or Other Compliance Software $ 200.00 LPile {Project) $ 56.00 Addit ional special Forms, as reqUired $ 150.00 APi le(Proj ect) $ 56.00
SHAFT (Project) $ 56.00 REIMBURSABLES
GROUP (Project) $ 110.00 Mileage (Portal to Portal) 0.88 Cliq (Project) $ 56.00 Per Diem (as required) 150.00
LlquefyPro (Project) $ 56.00 Bridge Toll Cost+l5%
liq lT(Project) $ 56.00 Parking Fees Cost +15%
NovoUQ(Project) $ 56.00 Subconsultant/Subcontractor Services, Vendors, and Expenses Cost+15% Slide {Project) $ 110.00 Proj ect Administration Fees 7%oflnvoice Settle3D (Project) $ 110.00 DIR Administration Fees 3% of Invoice ArcGIS (Project) $ 56.00 Proj ect Setup (Proj ect) $500.00 EZ-FRISK (Per Project Site/Site Class) $ 525.00
MATERIALS lABalA TORY TESB
SOILS
Moisture Density Curves California Bearing Ratio {CBR}
standard Proctor, 4" (ASTM/AASHTO) $ 256.00 CBR at 100%(AS1M D1883 or AASHTO T-180) 557.00 Modified Proctor, 4"Mold (ASTM/AASHTO) $ 256.00 CBR at 95% (AS1M D1883 or AASHTOT-180) $ 1,079.00 Modified Proctor, 6" mold (ASTM D1557) $ 272.00
caltrans Maximum Wet Density(CT2 16) $ 233.00 Permeability Tests Check Point $ 148.00 Rigid Wall Permeabilit y (ASTM 02434) $ 307.00 Flexible Wall Permeability (ASTM D5084) $ 478.00
Particle Size Analysis Remolded Flexwall Perm (AS1M D5084) $ 608.00 Sieve Analysis w/Wash (ASTM 0422) $ 185.00
M inus #200 Wash, Soil (ASTM 01140) $ 90.00 Soil Corrosivity Tests Hydrometer Analysis (ASTM 0422) $ 244.00 M inimum Resistivfty ofSoi ls(CT643) $ 153.00 Double Hydromet er (ASTM 04221) $ 340.00 pH $ 71.00
Specific Gravity of Soi l (ASTM 0854) $ 174.00 Soluble Sulfate, Chloride and Sulfide $ 142.00 Visual Classificati on (ASTM 02488) $ 47.00 Oxidation Reduct ion of Soil $ 61.00 Sand Equivalent (AS1M D24 19) $ 137.00
%Organics in Soil {ASTM D2974) $ 149.00 Soil Cement Tests Freeze Thaw Abrasion (ASTM D560) $ 681.00
Atterberg Limits/ Swell Tests Wetting-Drying Abrasion (ASTM 0559) $ 647.00 Plasticity Index {ASTM 04318) $ 238.00 Preparation of Freeze-Thaw or Wetting-OryingTests $ 818.00 Shrink.age limits of Soils (ASTM 0427) $ 222.00 Soil Cement Compression (ASTM 01633) $ 261.00 Expansion Index ofSoils(UBC No. 29) $ 256.00 Cement Content Soi l Cement (ASTM C1084) $ 261.00 Moisture Density Test Other
Tube Density $ 54.00 Sample Preparation $ 71.00
fv'lo isture Content of Soils (ASTM 02216) $ 47.00 Crumb Test Oisperstion {ASTM 06572) $ 85.00 Pinhole Dispersion Test {ASTM) $ 272.00
"R" Value Determination Sand Density cal ibrati on {ASTM D1566) $ 102.00 R-Value of Soils (CT301) $ 432.00
R-Value of Treated Mat erials (CT 301)) $ 478.00 Unconfined Compression Unconfined Compression {ASTM D2166) $ 137.00
Consolidation Tests
Consolidation (ASTMD2435) $ 455.00 Shear Tests
Consol idation, Extra Points (ASTM D2435} $ 61.00 Direct Shear, Undisturbed (ASTM 03080) $ 238.00 Collapse Potential of Soils (ASTM D2435) $ 222.00 Direct Shear, Remolded (ASTM 03080) $ 285.00 Remolded Consol idation (ASTM 02435) $ 386.00 Triaxial Compression Testing QUOTE One-Oimen Swel l of Soil (ASTM 04546) $ 142.00
Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 24
Fees for Services
HortScience I Bartlett Consulting
Hourly Rates
Principals
Consulting Arborist
Expert Witness
Arborist
GIS/CAD Special ist
Clerk
$220.00/hour
$180.00/hour
$300.00/hour
$150.00/hour
$150.00/hour
$70.00/hour
• H O RT SCIENCE
w. BARTLETT CONSULTING A Divi~•on of The F.A. Bctrtleu Tree Expert Comp.my Hourly fees are portal-to-portal . Direct expenses such as reproduction and shipping shall be reimbursed at cost plus 15%. Mileage shall be reimbursed at the latest published IRS rate, currently $0.56 per mile (from Pleasanton).

March 2021
Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 25
!mB DAVID J, POWERS B~~ & ASSOCIATES, INC.

CHARGE RATE SCHEDULE1
Title Hourly Rate
Senior Principal $ 300.00
Principal Project Manager $ 275.00
Senior Environmental Specialist $ 240.00
Senior Project Manager $ 215.00
Environmental Specialist $ 200.00
Biologist $ 190.00
Project Manager $ 190.00
Associate Project Manager $ 160.00
Assistant Project Manager $ 130.00
Researcher $ 115.00
Draftsperson/Graphic Artist $ 120.00
Document Processor/Quality Control $ 110.00
Administrative Manager $ 110.00
Office Support $ 95.00
Materials, outside services and subconsultants include a 15% adm inistration fee .

Mileage will be charged per the current IRS standa rd mileage rate at the time costs occur.

Subject to revis ion June 1, 2021.

L David J. Powers & Associates, Inc. (DJP&A) provides regular, clear, and accurate invoices, in accordance with normal company bil ling procedures. The cost estimate prepared for th is project does not include special 3ccounting or bookkeeping procedures, nor does it include preparation of extraordinary or unique statements or Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 26

IHOURLY FEES
HOURLY FEES FOR SERVICES OF:

Engineering
Drafting
Administrative

IHOURLY FEES
HOURLY FEES FOR SERVICES OF:

Doug Evers

RATE SCHEDULE

AT IUM ENG INEER ING
RATE PER HOUR:
$180
$125
$90

RATE SCHEDULE

PROACTIVE RISK SO LUTIONS
RATE PER HOUR:
$95 -$125
Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 27

CAPITAL
ENGINEERING CONSULTANTS, INC.

Capital Engineering Consultants, Inc.
2021 Billing Rates
Sr. Principal
Principal
Director
Sr. Project Manager
Project Manager
Field Services
Senior Engineer
Engineer
Senior Designer
Designer
Technician / CADD
Intern
Project Administrator
Sr. Admin.

Clerical / Admin.
$230.00 I hour
$210 .00 I hour
$200.00 I hour
$190.00 I hour
$182 .00 I hour
$180.00 I hour
$164.00 I hour
$149.00 I hour
$139.00 / hour
$128.00 / hour
$118.00 I hour
$113.00 I hour
$98.00 I hour
$67 .00 I hour
$54.00 I hour
Design Professional Agreement with Gates and Associates/Exhibit B-Schedule of Fees Rev. 04-12-21 Page 28
~ KAMYAN&ASSOCIATES
~ Structura l Engineers
STAFF
Principal Engineer
Project Manager
Senior Structural Engineer
Staff Engineer
CAD Drafters

BILLING RATE SCHEDULE
Jrmumy, _o_J

HOURLY RATE
$225 per hour
$190 per hour
$175 per hour
$150 per hour
$110 per hour
Design Professional Agreement with Gates and Associates/Exhibit C-Insurance Requirements Page 1 Rev. 09-28-18

AGREEMENT FOR DESIGN PROFESSIONAL SERVICES

BETWEEN THE

CITY OF SANTA CLARA, CALIFORNIA,
AND
GATES AND ASSOCIATES LANDSCAPE ARCHITECTURE, INC.

FOR

WESTWOOD OAKS PLAYGROUND REHABILITATION PROJECT

EXHIBIT C

INSURANCE REQUIREMENTS
Without limiting the Contractor’s indemnification of the City, and prior to commencing any of the Services required under this Agreement, the Contractor shall provide and maintain in full force and effect during the period of performance of the Agreement and for twenty-four (24) months following acceptance by the City, at its sole cost and expense, the following insurance policies from insurance companies authorized to do business in the State of California. These policies shall be primary insurance as to the City of Santa Clara so that any other coverage held by the City shall not contribute to any loss under Contractor’s insurance. The minimum coverages, provisions and endorsements are as follows:

A. COMMERCIAL GENERAL LIABILITY INSURANCE

1. Commercial General Liability Insurance policy which provides coverage at least as broad as Insurance Services Office form CG 00 01. Policy limits are subject to review, but shall in no event be less than, the following:
$1,000,000 Each Occurrence
$2,000,000 General Aggregate
$2,000,000 Products/Completed Operations Aggregate
$1,000,000 Personal Injury

2. Exact structure and layering of the coverage shall be left to the discretion of Contractor; however, any excess or umbrella policies used to meet the required limits shall be at least as broad as the underlying coverage and shall otherwise follow form.

3. The following provisions shall apply to the Commercial Liability policy as well as any umbrella policy maintained by the Contractor to comply with the insurance requirements of this Agreement:
a. Coverage shall be on a “pay on behalf” basis with defense costs payable in addition to policy limits;
b. There shall be no cross liability exclusion which precludes coverage for claims or suits by one insured against another; and Design Professional Agreement with Gates and Associates/Exhibit C-Insurance Requirements Page 2 Rev. 09-28-18
c. Coverage shall apply separately to each insured against whom a claim is made or a suit is brought, except with respect to the limits of liability.

B. BUSINESS AUTOMOBILE LIABILITY INSURANCE
Business automobile liability insurance policy which provides coverage at least as broad as ISO form CA 00 01 with policy limits a minimum limit of not less than one million dollars ($1,000,000) each accident using, or providing coverage at least as broad as, Insurance Services Office form CA 00 01. Liability coverage shall apply to all owned (if any), non-owned and hired autos.

C. WORKERS’ COMPENSATION

1. Workers’ Compensation Insurance Policy as required by statute and employer’s liability with limits of at least one million dollars ($1,000,000) policy limit Bodily Injury by disease, one million dollars ($1,000,000) each accident/Bodily Injury and one million dollars ($1,000,000) each employee Bodily Injury by disease.

2. The indemnification and hold harmless obligations of Contractor included in this Agreement shall not be limited in any way by any limitation on the amount or type of damage, compensation or benefit payable by or for Contractor or any subcontractor under any Workers’ Compensation Act(s), Disability Benefits Act(s) or other employee benefits act(s).

3. This policy must include a Waiver of Subrogation in favor of the City of Santa Clara, its City Council, commissions, officers, employees, volunteers and agents.

D. PROFESSIONAL LIABILITY
Professional Liability or Errors and Omissions Insurance as appropriate shall be written on a policy form coverage specifically designed to protect against negligent acts, errors or omissions of the Contractor. Covered services as designated in the policy must specifically include work performed under this agreement. Coverage shall be in an amount of not less than one million dollars ($1,000,000) per claim or two million dollars ($2,000,000) aggregate. Any coverage containing a deductible or self-retention must first be approved in writing by the City Attorney’s Office.

E. COMPLIANCE WITH REQUIREMENTS
All of the following clauses and/or endorsements, or similar provisions, must be part of each commercial general liability policy, and each umbrella or excess policy.

Design Professional Agreement with Gates and Associates/Exhibit C-Insurance Requirements Page 3 Rev. 09-28-18

1. Additional Insureds. City of Santa Clara, its City Council, commissions, officers, employees, volunteers and agents are hereby added as additional insureds in respect to liability arising out of Contractor’s work for City, using Insurance Services Office (ISO) Endorsement CG 20 10 11 85, or the combination of CG 20 10 03 97 and CG 20 37 10 01, or its equivalent.

2. Primary and non-contributing. Each insurance policy provided by Contractor shall contain language or be endorsed to contain wording making it primary insurance as respects to, and not requiring contribution from, any other insurance which the indemnities may possess, including any self-insurance or self-insured retention they may have. Any other insurance indemnities may possess shall be considered excess insurance only and shall not be called upon to contribute with Contractor’s insurance.

3. Cancellation.
a. Each insurance policy shall contain language or be endorsed to reflect that no cancellation or modification of the coverage provided due to non-payment of premiums shall be effective until written notice has been given to City at least ten (10) days prior to the effective date of such modification or cancellation. In the event of non-renewal, written notice shall be given at least ten (10) days prior to the effective date of non-renewal.
b. Each insurance policy shall contain language or be endorsed to reflect that no cancellation or modification of the coverage provided for any cause save and except non-payment of premiums shall be effective until written notice has been given to City at least thirty (30) days prior to the effective date of such modification or cancellation. In the event of non-renewal, written notice shall be given at least thirty (30) days prior to the effective date of nonrenewal.

4. Other Endorsements. Other endorsements may be required for policies other than the commercial general liability policy if specified in the description of required insurance set forth in Sections A through E of this Exhibit C, above.

F. ADDITIONAL INSURANCE RELATED PROVISIONS
Contractor and City agree as follows:

1. Contractor agrees to ensure that subcontractors, and any other party involved with the Services, who is brought onto or involved in the performance of the Services by Contractor, provide the same minimum insurance coverage required of Contractor, except as with respect to Design Professional Agreement with Gates and Associates/Exhibit C-Insurance Requirements Page 4 Rev. 09-28-18
limits. Contractor agrees to monitor and review all such coverage and assumes all responsibility for ensuring that such coverage is provided in conformity with the requirements of this Agreement. Contractor agrees that upon request by City, all agreements with, and insurance compliance documents provided by, such subcontractors and others engaged in the project will be submitted to City for review.

2. Contractor agrees to be responsible for ensuring that no contract used by any party involved in any way with the project reserves the right to charge City or Contractor for the cost of additional insurance coverage required by this Agreement. Any such provisions are to be deleted with reference to City. It is not the intent of City to reimburse any third party for the cost of complying with these requirements. There shall be no recourse against City for payment of premiums or other amounts with respect thereto.

3. The City reserves the right to withhold payments from the Contractor in the event of material noncompliance with the insurance requirements set forth in this Agreement.

G. EVIDENCE OF COVERAGE
Prior to commencement of any Services under this Agreement, Contractor, and each and every subcontractor (of every tier) shall, at its sole cost and expense, provide and maintain not less than the minimum insurance coverage with the endorsements and deductibles indicated in this Agreement. Such insurance coverage shall be maintained with insurers, and under forms of policies, satisfactory to City and as described in this Agreement. Contractor shall file with the City all certificates and endorsements for the required insurance policies for City’s approval as to adequacy of the insurance protection.

H. EVIDENCE OF COMPLIANCE
Contractor or its insurance broker shall provide the required proof of insurance compliance, consisting of Insurance Services Office (ISO) endorsement forms or their equivalent and the ACORD form 25-S certificate of insurance (or its equivalent), evidencing all required coverage shall be delivered to City, or its representative as set forth below, at or prior to execution of this Agreement.

Upon City’s request, Contractor shall submit to City copies of the actual insurance policies or renewals or replacements. Unless otherwise required by the terms of this Agreement, all certificates, endorsements, coverage verifications and other items required to be delivered to City pursuant to this Agreement shall be mailed to:

EBIX Inc.

City of Santa Clara Public Works Department
P.O. Box 100085 – S2 or 1 Ebix Way
Duluth, GA 30096 John’s Creek, GA 30097
----
Design Professional Agreement with Gates and Associates/Exhibit C-Insurance Requirements Page 5 Rev. 09-28-18
Telephone number: 951-766-2280
Fax number: 770-325-0409
Email address: [email protected]
I. QUALIFYING INSURERS
All of the insurance companies providing insurance for Contractor shall have, and provide written proof of, an A. M. Best rating of at least A minus 6 (A- VI) or shall be an insurance company of equal financial stability that is approved by the City or its insurance compliance representatives.

Page 1 ends

City Council and Authorities ConcurrentApril 19, 2022

City Council and Authorities Concurrent
April 19, 2022