Attachment 1 - Water Supply Alternatives Plan — Santa Rosa City Council, October 24, 2023 (part 2 of 2)

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option GW-2: Convert existing emergency wells into groundwater extraction wells Size Units Qty Unit Unit Cost Subtotal
Well Rehabilitation
Well Construction 3 per well $1,440,000 4,320,000
Product Water Distribution
Product Water Line in per inch-dia LF $37 -
Product Water Pump Station HP $6,500 -
Potable Connection LS $100,000 -
Iron and Manganese Treatment 2 per well $600,000 1,200,000 Raw Construction Cost 5,520,000
Construction Contingency 50% 2,760,000
Total Construction Cost 8,280,000
Implementation Cost 40% 3,310,000
Total Capital Cost 11,590,000
Annual Operations & Maintenance Cost (2.19 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
0 $0.20 -
Extraction Wells 2,462 $54 133,814
Extraction Well Energy Use 2,462 $182 448,045
Fixed O&M Construction Cost Unit Cost
Wells $110,780 110,780
Pump Stations - 3.0% -
Pipelines - 0.5% -
Treatment 1,200,000 1.0% 12,000
Total Annual Operations & Maintenance Cost 704,639
Annualized Capital Cost 0.03526 409,000
Total Annualized Cost 1,113,639
Max Project Yield (AFY) 2,462
MAX $/AF 452
Annual Operations & Maintenance Cost (0 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Product Water Pump Station 0 118 0 $0.20 -
Extraction Wells 0 $54 -
Extraction Well Energy Use 0 $182 -
Fixed O&M Qty Unit Construction Cost Unit Cost
Extraction Wells $110,780 110,780
Pump Stations - 3.0% -
Pipelines - 0.5% -
Total Annual Operations & Maintenance Cost 110,780
Annualized Capital Cost 0.03526 409,000
Total Annualized Cost 519,780
Min Project Yield (AFY) 1,436
MIN $/AF 362
Basis of estimate:

Assumes 3 existing emergency wells rehabilitated to become prdocution wells for the City. Assumes the costs to rehabilitate the Leete well. Historic yield for the 3 wells is 2,462 AFY.

Page 2 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option GW-3: ASR Wells
Size Units Qty Unit Unit Cost Subtotal
ASR
New Well Construction 6 per well $5,000,000 30,000,000
Product Water Distribution
Product Water Line 16 in 12,000 per inch-dia LF $37 7,120,000 Product Water Pump Station 210 HP $6,500 1,365,000
Potable Connection 1 LS $100,000 100,000
Raw Construction Cost 38,590,000
Construction Contingency 50% 19,300,000
Total Construction Cost 57,890,000
Implementation Cost 40% 23,160,000
Total Capital Cost 81,050,000
Annual Operations & Maintenance Cost (4.6 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Product Water Pump Station 3,180 118 744,660 $0.20 148,932 ASR Well 5,130 $65 334,589
ASR Well Energy Use 5,130 $218 1,120,295
Fixed O&M Qty Unit Construction Cost Unit Cost
Pump Stations 1,365,000 3.0% 40,950
Pipelines 7,120,000 0.5% 35,600
ASR Well $44,312 44,312
Total Annual Operations & Maintenance Cost 1,724,678
Annualized Capital Cost 0.03526 2,858,000
Total Annualized Cost 4,582,678
Max Project Yield (AFY) 5,130
MAX $/AF 893
Annual Operations & Maintenance Cost (0 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Product Water Pump Station 0 118 0 $0.20 -
ASR Well 5,130 $65 334,589
ASR Well Energy Use 5,130 $218 1,120,295
Fixed O&M Qty Unit Construction Cost Unit Cost
Pump Stations 1,365,000 3.0% 40,950
Pipelines 7,120,000 0.5% 35,600
ASR Well $44,312 44,312
Total Annual Operations & Maintenance Cost 1,575,746
Annualized Capital Cost 0.03526 2,858,000
Total Annualized Cost 4,433,746
Min Project Yield (AFY) 2,993
MIN $/AF 1,482
Basis of estimate:

Constructs six ASR wells in Delta Pond area and wellhead treatment if necessary and tie into the existing distribution system. The costs were built upon existing City O&M data and well rehab of Leete Well.

Page 3 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option PR-1: DPR at LTP
Size Units Qty Unit Unit Cost Subtotal
Equalization 1,820,000 per gallon $1.25 2,275,000
Tertiary to AWTF
Tertiary Water Line to AWPF 24 in 500 per inch-dia LF $37 445,000 Tertiary Pump Station HP $6,500 -

AWTF - DPR
Ozone 11.4 MGD $530,000 6,025,000
BAF 11.4 MGD $480,000 5,457,000
MF/UF 10.6 MGD $1,940,000 20,510,000
Interprocess Tank 220,000 per gallon $1.25 275,000
RO 9.0 MGD $2,340,000 21,028,000
Chemicals (Storage and Feed Systems) 9.0 MGD $200,000 1,797,000 Sitework/Piping/Structures 9.0 MGD $5,050,000 45,381,000 Waste Disposal to Headworks at LTP 10 in 500 per inch-dia LF $37 185,400 Brine Disposal
Zero Liquid Discharge 9.0 per MGD $1,194,000 10,730,000 Product Water Distribution
Product Water Line 20 in 26,330 per inch-dia LF $37 19,528,100 Product Water Pump Station 625 HP $6,500 4,062,500
Potable Connection 1 LS $100,000 100,000
Raw Construction Cost 137,800,000
Construction Contingency 50% 68,900,000
Total Construction Cost 206,700,000
Implementation Cost 40% 82,680,000
Total Capital Cost 289,380,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M QTY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station
Product Water Pump Station 6,241 297 3,669,660 $0.20 733,932 FAT System 7,157,231 $0.20 1,431,446
Ozone/ BAF System 2,004,332 $0.20 400,866
Evaporator 27,178,376 $0.20 5,435,675
Crystallizer 4,982,702 $0.20 996,540
FAT System - Chemicals 1 $326,250 326,250
Ozone/ BAF System - Chemicals 1 $2,250 2,250
Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 4,062,500 3.0% 121,875
Pipelines 20,158,500 0.5% 100,793
Total Annual Operations & Maintenance Cost 10,199,878
Annualized Capital Cost 0.03526 10,203,000
Total Annualized Cost 20,402,878
Max Project Yield (AFY) 10,065
MAX $/AF 2,027
Annual Operations & Maintenance Cost (2.7 mgd production) Annual O&M Variable O&M QTY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station -
Product Water Pump Station 1,872 297 1,100,880 $0.20 220,176 FAT System 2,147,169 $0.20 429,434
Ozone/ BAF System 601,300 $0.20 120,260
Evaporator 8,153,513 $0.20 1,630,703
Crystallizer 1,494,811 $0.20 298,962
FAT System - Chemicals 1 $97,875 97,875
Ozone/ BAF System - Chemicals 1 $675 675
Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 4,062,500 3.0% 121,875
Pipelines 20,158,500 0.5% 100,793
Total Annual Operations & Maintenance Cost 3,671,002
Annualized Capital Cost 0.03526 10,203,000
Total Annualized Cost 13,874,002
Min Project Yield (AFY) 3,019
MIN $/AF 4,595
Basis of estimate:

Option PR-1 would convey the City’s tertiary effluent to an AWPF located at the LTP and return AWPF waste stream to the LTP headworks. The AWPF would include treatment processes in compliance with future anticipated regulations for treated water augmentation. The purified water would be conveyed to SCWA’s 48-inch diameter aqueduct for distribution to the City’s potable water system. PR-1 is limited by the reliable volume of tertiary effluent available, assuming the City would be reducing flow to the Geysers by prioritizing recycled water to its existing irrigation customers and the AWPF. For this level of study it was assumed the City would size the AWPF to meet its 9 MGD peak month supply needs and provide any remaining tertiary water to its existing irrigation customers and then to the Geysers.

Page 4 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option PR-2: Satellite DPR
Size Units Qty Unit Unit Cost Subtotal
Equalization 1,820,000 per gallon $1.25 2,275,000
Tertiary to Satellite AWTF
Tertiary Water Line to DPR 24 in 30,100 per inch-dia LF $37 26,789,000 Tertiary Pump Station 510 HP $6,500 3,315,000

AWTF - DPR
Ozone 11.4 MGD $530,000 6,025,000
BAF 11.4 MGD $480,000 5,457,000
MF/UF 10.6 MGD $1,940,000 20,510,000
Interprocess Tank 220,000 per gallon $1.25 275,000
RO 9.0 MGD $2,340,000 21,028,000
Chemicals (Storage and Feed Systems) 9.0 MGD $200,000 1,797,000 Sitework/Piping/Structures 9.0 MGD $5,050,000 45,381,000 Waste Disposal to Sewer 10 in 7,330 per inch-dia LF $37 2,718,200 Brine Disposal
Zero Liquid Discharge 9.0 per MGD $1,194,000 10,730,000 Product Water Line 20 in 2,050 per inch-dia LF $37 1,520,400 Product Water Pump Station 250 HP $6,500 1,625,000
Potable Connection 1 LS $100,000 100,000
Raw Construction Cost 149,550,000
Construction Contingency 50% 74,780,000
Total Construction Cost 224,330,000
Implementation Cost 40% 89,730,000
Total Capital Cost 314,060,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station 8,056 188 3,005,730 $0.20 601,000 Product Water Pump Station 6,241 120 1,477,080 $0.20 295,000 FAT System 7,157,231 $0.20 1,431,446
Ozone/ BAF System 2,004,332 $0.20 400,866
Evaporator 27,178,376 $0.20 5,435,675
Crystallizer 4,982,702 $0.20 996,540
FAT System - Chemicals 1 $326,250 326,250 Ozone/ BAF System - Chemicals 1 $2,250 2,250 Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 4,940,000 3.0% 148,200
Pipelines 31,027,600 0.5% 155,138
Total Annual Operations & Maintenance Cost 10,442,616
Annualized Capital Cost 0.03526 11,073,000
Total Annualized Cost 21,515,616
Max Project Yield (AFY) 10,065
MAX $/AF 2,138
Annual Operations & Maintenance Cost (2.7 mgd production) Annual O&M Variable O&M GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station 2,417 188 901,710 $0.20 180,000 Product Water Pump Station 1,872 120 443,160 $0.20 89,000 FAT System 2,147,169 $0.20 429,434
Ozone/ BAF System 601,300 $0.20 120,260
Evaporator 8,153,513 $0.20 1,630,703
Crystallizer 1,494,811 $0.20 298,962
FAT System - Chemicals 1 $97,875 97,875 Ozone/ BAF System - Chemicals 1 $675 675 Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 4,940,000 3.0% 148,200
Pipelines 31,027,600 0.5% 155,138
Total Annual Operations & Maintenance Cost 3,800,497
Annualized Capital Cost 0.03526 11,073,000
Total Annualized Cost 14,873,497
Min Project Yield (AFY) 3,019
MIN $/AF 4,926
Basis of estimate:

Option PR-2 would convey the City’s tertiary effluent to a satellite AWPF and return AWPF waste stream to the nearest sewer. The AWPF would include treatment processes in compliance with future anticipated regulations for treated water augmentation. The purified water would be conveyed to SCWA’s 48-inch diameter aqueduct for distribution to the City’s potable water system. The satellite AWPF is assumed to be located on City-owned agricultural leased land, Stone Farm for its proximity to the 48-inch aqueduct. For this level of study it was assumed the City would size the AWPF to meet its 9 MGD peak month supply needs and provide any remaining tertiary water to its existing irrigation customers and then to the Geysers.

Page 5 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option PR-3a: IPR to Delta Pond (GWA)
Size Units Qty Unit Unit Cost Subtotal
Equalization 1,820,000 per gallon $1.25 2,275,000
Tertiary to AWTF
Tertiary Water Line to IPR 24 in 500 per inch-dia LF $37 445,000 Tertiary Pump Station HP $6,500 -

AWTF - IPR
Ozone MGD $530,000 -
BAF MGD $480,000 -
MF/UF 10.6 MGD $1,940,000 20,568,000
Interprocess Tank 221,000 per gallon $1.25 276,000
RO 9.0 MGD $2,340,000 21,087,000
Chemicals (Storage and Feed Systems) 9.0 MGD $200,000 1,802,000 Sitework/Piping/Structures 9.0 MGD $5,050,000 45,509,000 Waste Disposal to Headworks 8 in 500 per inch-dia LF $37 148,300 Brine Disposal
Zero Liquid Discharge 9.0 per MGD $1,194,000 10,760,000 Product Water Distribution
Product Water Line 22 in 41,220 per inch-dia LF $37 33,628,700 Product Water Pump Station 490 HP $6,500 3,185,000
Potable Connection LS $100,000 -
ASR Wells
New Well Construction 500 gpm 12 per well $5,000,000 60,000,000 Raw Construction Cost 199,680,000
Construction Contingency 50% 99,840,000
Total Construction Cost 299,520,000
Implementation Cost 40% 119,810,000
Total Capital Cost 419,330,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station
Product Water Pump Station 6,241 234 2,892,420 $0.20 578,000 FAT System 7,157,231 $0.20 1,431,446
Ozone/ BAF System $0.20 -
Evaporator 27,178,376 $0.20 5,435,675
Crystallizer 4,982,702 $0.20 996,540
FAT System - Chemicals 1 $326,250 326,250 Ozone/ BAF System - Chemicals $2,250 -
ASR Well 10,065 $65 656,445
ASR Well Energy Use 10,065 $218 2,197,955
Fixed O&M Construction Cost Unit Cost
Treatment 52,415,000 1.0% 524,150
Storage 2,551,000 0.5% 12,755
Pump Stations 3,185,000 3.0% 95,550
Pipelines 34,222,000 0.5% 171,110
ASR Wells $265,872 265,872
Total Annual Operations & Maintenance Cost 12,691,749
Annualized Capital Cost 0.03526 14,785,000
Total Annualized Cost 27,476,749
Max Project Yield (AFY) 10,065
MAX $/AF 2,730
Annual Operations & Maintenance Cost (2.7 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station -
Product Water Pump Station 1,872 234 867,690 $0.20 174,000 FAT System 2,147,169 $0.20 429,434
Ozone/ BAF System $0.20 -
Evaporator 8,153,513 $0.20 1,630,703
Crystallizer 1,494,811 $0.20 298,962
FAT System - Chemicals $97,875 97,875
Ozone/ BAF System - Chemicals $675 -
ASR Well 3,024 $65 197,232
ASR Well Energy Use 3,024 $218 660,384
Fixed O&M Construction Cost Unit Cost
Treatment 52,415,000 1.0% 524,150
Storage 2,551,000 0.5% 12,755
Pump Stations 3,185,000 3.0% 95,550
Pipelines 34,222,000 0.5% 171,110
ASR Wells $265,872 265,872
Total Annual Operations & Maintenance Cost 4,558,026
Annualized Capital Cost 0.03526 14,785,000
Total Annualized Cost 19,343,026
Min Project Yield (AFY) 3,019
MIN $/AF 6,406
Basis of estimate:

Option PR-3a would convey the City’s tertiary effluent to an AWPF at LTP and return AWPF waste stream to the headworks at LTP. The AWPF would include treatment processes in compliance with regulations for groundwater recharge. The purified water would be conveyed to a repurposed Delta Pond or a new nearby pond for infiltration; after the minimum retention time of 2-months in the groundwater aquifer, the recharged groundwater could then be extracted. For the 9 MGD supply, 12 new extraction wells would be required. The same assumptions for the GW-1 option were applied for these extraction wells. For this level of study it was assumed the City would size the AWPF to meet its 9 MGD peak month supply needs and provide any remaining tertiary water to its existing irrigation customers and then to the Geysers.

Page 6 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option PR-3c: IPR to Lake Sonoma
Size Units Qty Unit Unit Cost Subtotal
Equalization 1,820,000 per gallon $1.25 2,275,000
Tertiary to AWTF
Tertiary Water Line to IPR 24 in 500 per inch-dia LF $37 445,000 Tertiary Pump Station HP $6,500 -

AWTF - IPR
Ozone MGD $530,000 -
BAF MGD $480,000 -
MF/UF 10.6 MGD $1,940,000 20,568,000
Interprocess Tank 221,000 per gallon $1.25 276,000
RO 9.0 MGD $2,340,000 21,087,000
Chemicals (Storage and Feed Systems) 9.0 MGD $200,000 1,802,000 Sitework/Piping/Structures 9.0 MGD $5,050,000 45,509,000 Waste Disposal to Headworks 8 in 500 per inch-dia LF $37 148,300 Brine Disposal
Zero Liquid Discharge 9.0 per MGD $1,194,000 10,760,000 Purified Water Distribution to Lake Sonoma
Product Water Line 22 in 181,300 per inch-dia LF $37 147,910,600 Product Water Pump Station 2,600 HP $6,500 16,900,000
Potable Connection LS $100,000 -
Raw Construction Cost 267,680,000
Construction Contingency 50% 133,840,000
Total Construction Cost 401,520,000
Implementation Cost 40% 160,610,000
Total Capital Cost 562,130,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station
Product Water Pump Station 6,258 1,233 15,278,040 $0.20 3,056,000 FAT System 7,157,231 $0.20 1,431,446
Ozone/ BAF System $0.20 -
Evaporator 27,178,376 $0.20 5,435,675
Crystallizer 4,982,702 $0.20 996,540
FAT System - Chemicals 1 $326,250 326,250
Ozone/ BAF System - Chemicals $2,250 -
0 1 $837,511 837,511
Fixed O&M Construction Cost Unit Cost
Treatment 52,415,000 1.0% 524,150
Storage 2,551,000 0.5% 12,755
Pump Stations 16,900,000 3.0% 507,000
Pipelines 148,503,900 0.5% 742,520
Total Annual Operations & Maintenance Cost 13,869,847
Annualized Capital Cost 0.03526 19,820,000
Total Annualized Cost 33,689,847
Max Project Yield (AFY) 10,065
MAX $/AF 3,347
Annual Operations & Maintenance Cost (2.7 mgd production) Annual O&M Variable O&M GPM TDH (ft) kwh-yr Unit Cost
Product Water Pump Station 1,877 1,233 4,583,430 $0.20 917,000 FAT System 2,147,169 $0.20 429,434
Ozone/ BAF System $0.20 -
Evaporator 8,153,513 $0.20 1,630,703
Crystallizer 1,494,811 $0.20 298,962
FAT System - Chemicals 1 $97,875 97,875
Ozone/ BAF System - Chemicals $675 -
0 1 $587,422 587,422
Fixed O&M Construction Cost Unit Cost
Treatment 52,415,000 1.0% 524,150
Storage 2,551,000 0.5% 12,755
Pump Stations 16,900,000 3.0% 507,000
Pipelines 148,503,900 0.5% 742,520
Total Annual Operations & Maintenance Cost 5,747,820
Annualized Capital Cost 0.03526 19,820,000
Total Annualized Cost 25,567,820
Min Project Yield (AFY) 3,019
MIN $/AF 8,468
Basis of estimate:

Option PR-3c would convey the City’s tertiary effluent to an AWPF at LTP and return AWPF waste stream to the headworks at LTP. The AWPF would include treatment processes in compliance with regulations for surface water augmentation. The purified water would be conveyed to Lake Sonoma through a new purified water line extending to the Lake assuming the existing Geyser’s pipeline corridor/ easement. After the minimum retention time of 2-months in the surface water body, the water could then be recovered using Sonoma Water's existing infrastructure via the Russian River. For this level of study it was assumed the City would size the AWPF to meet its 9 MGD peak month supply needs and provide any remaining tertiary water to its existing irrigation customers and then to the Geysers.

Page 7 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option PR-4: DPR at LTP
Size Units Qty Unit Unit Cost Subtotal
Equalization 1,820,000 per gallon $1.25 2,275,000
Tertiary to AWTF
Tertiary Water Line to AWPF 24 in 500 per inch-dia LF $37 445,000 Tertiary Pump Station HP $6,500 -

AWTF - DPR
Ozone 11.4 MGD $530,000 6,025,000
BAF 11.4 MGD $480,000 5,457,000
MF/UF 10.6 MGD $1,940,000 20,510,000
Interprocess Tank 220,000 per gallon $1.25 275,000
RO 9.0 MGD $2,340,000 21,028,000
Chemicals (Storage and Feed Systems) 9.0 MGD $200,000 1,797,000 Sitework/Piping/Structures 9.0 MGD $5,050,000 45,381,000 Waste Disposal to Headworks at LTP 10 in 500 per inch-dia LF $37 185,400 Brine Disposal
Zero Liquid Discharge 9.0 per MGD $1,194,000 10,730,000 Product Water Distribution
Product Water Line 20 in 2,200 per inch-dia LF $37 1,631,700 Product Water Pump Station 270 HP $6,500 1,755,000
Potable Connection 1 LS $100,000 100,000
Raw Construction Cost 117,600,000
Construction Contingency 50% 58,800,000
Total Construction Cost 176,400,000
Implementation Cost 40% 70,560,000
Total Capital Cost 246,960,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M QTY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station
Product Water Pump Station 6,241 128 1,587,780 $0.20 317,556 FAT System 7,157,231 $0.20 1,431,446
Ozone/ BAF System 2,004,332 $0.20 400,866
Evaporator 27,178,376 $0.20 5,435,675
Crystallizer 4,982,702 $0.20 996,540
FAT System - Chemicals 1 $326,250 326,250
Ozone/ BAF System - Chemicals 1 $2,250 2,250
Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 1,755,000 3.0% 52,650
Pipelines 2,262,100 0.5% 11,311
Total Annual Operations & Maintenance Cost 9,624,795
Annualized Capital Cost 0.03526 8,707,000
Total Annualized Cost 18,331,795
Max Project Yield (AFY) 10,065
MAX $/AF 1,821
Annual Operations & Maintenance Cost (2.7 mgd production) Annual O&M Variable O&M QTY GPM TDH (ft) kwh-yr Unit Cost
Tertiary Pump Station -
Product Water Pump Station 1,872 128 476,370 $0.20 95,274 FAT System 2,147,169 $0.20 429,434
Ozone/ BAF System 601,300 $0.20 120,260
Evaporator 8,153,513 $0.20 1,630,703
Crystallizer 1,494,811 $0.20 298,962
FAT System - Chemicals 1 $97,875 97,875
Ozone/ BAF System - Chemicals 1 $675 675
Fixed O&M Construction Cost Unit Cost
Treatment 63,750,000 1.0% 637,500
Storage 2,550,000 0.5% 12,750
Pump Stations 1,755,000 3.0% 52,650
Pipelines 2,262,100 0.5% 11,311
Total Annual Operations & Maintenance Cost 3,387,393
Annualized Capital Cost 0.03526 8,707,000
Total Annualized Cost 12,094,393
Min Project Yield (AFY) 3,019
MIN $/AF 4,006
Basis of estimate:

Option PR-4 would convey the City’s tertiary effluent to an AWPF located at the LTP and return AWPF waste stream to the LTP headworks. The AWPF would include treatment processes in compliance with future anticipated regulations for treated water augmentation. The purified water would be conveyed to SCWA’s 48-inch diameter aqueduct for regional distribution south of the City. PR-4 is limited by the reliable volume of tertiary effluent available, assuming the City would be reducing flow to the Geysers by prioritizing recycled water to its existing irrigation customers and the AWPF. For this level of study it was assumed the City would size the AWPF to meet its 9 MGD peak month supply needs and provide any remaining tertiary water to its existing irrigation customers and then to the Geysers.

Page 8 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options June 2023
Option RW-1: Recycled Water Expansion
Basis of estimate:
2023 Cost
Santa Rosa Urban Reuse Project 214,011,000 $
Total Capital Cost 214,011,000 $
Annualized Capital Cost 0.03526
7,546,000 $
Annual O&M Cost 1,270,000 $
Total Annualized Cost 8,816,000 $
Yield (AFY) 3000
$/AF 2939
Complete the nonpotable recycled water expansion project evaluated in the Santa Rosa Urban Reuse Project Feasibility Study.

Page 9 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023 June 2023
Option DE-1: Regional Desalination Full Project City Portion Basis of estimate:

Size Units Qty Unit Unit Cost Subtotal Subtotal
Intake
Intake Screens, Pipeline and Pumps 15 MGD 1 LS $13,236,000 13,236,000 7,941,600 Raw Water Pipe 15 MGD 1 LS $394,000 394,000 236,400 Desalination Plant
Rapid Mix 15 MGD 1 LS $2,033,000 2,033,000 1,219,800 Strainers, UF and Building 15 MGD 1 LS $17,668,000 17,668,000 10,600,800 Filtrate and Backwash Supply Tanks 15 MGD 1 LS $217,000 217,000 130,200 RO Feed Pump Station 15 MGD 1 LS $4,025,000 4,025,000 2,415,000 1st pass RO and Building, Permeate Tank 15 MGD 1 LS $32,591,000 32,591,000 19,554,600 Chlorine Contact Tank 15 MGD 1 LS $993,000 993,000 595,800 Chemical Facilities 15 MGD 1 LS $11,134,000 11,134,000 6,680,400 Backwash Equalization Basin 15 MGD 1 LS $430,000 430,000 258,000 Gravity Thickener 15 MGD 1 LS $2,390,000 2,390,000 1,434,000 Centrifuges 15 MGD 1 LS $6,810,000 6,810,000 4,086,000 O&M Building 15 MGD 1 LS $5,301,000 5,301,000 3,180,600 Sitework/Piping 15 MGD 1 LS $18,861,000 18,861,000 11,316,600 Electrical 15 MGD 1 LS $11,208,000 11,208,000 6,724,800 Instrumentation and Controls 15 MGD 1 LS $5,604,000 5,604,000 Brine Disposal
Brine Pump Station 15 MGD 1 LS $3,977,000 3,977,000 2,386,200 Brine Transmission Line 15 MGD 1 LS $1,763,000 1,763,000 1,057,800 Distribution
Distribution Booster Pumps 15 MGD 1 LS $4,504,000 4,504,000 2,702,400 Treated Water Line 15 MGD 1 LS $328,000 328,000 196,800 Raw Construction Cost 143,470,000 82,720,000
Construction Contingency 50% 71,740,000 41,360,000 Total Construction Cost 215,210,000 124,080,000
Implementation Cost 40% 86,080,000 49,630,000
Total Capital Cost 301,290,000 173,710,000
Annual Operations & Maintenance Cost (15 mgd production) Annual O&M Annual O&M Variable O&M gpm TDH AFY kwh-yr Unit Cost
Desalination Facility 16,800 27,384,000 $0.20 5,476,800 3,286,080 Distribution Booster Pumps 10,417 200 4,125,600 $0.20 825,120 495,072 Brine Pump Station 11,111 100 2,200,320 $0.20 440,064 264,038 Fixed O&M Construction Cost Unit Cost
Treatment 78,291,000 1.0% 782,910 469,746 Storage 430,000 0.5% 2,150 1,290 Pump Stations 21,717,000 3.0% 651,510 390,906 Pipelines 15,721,000 0.5% 78,605 47,163 Total Annual Operations & Maintenance Cost 8,257,159 4,954,295 Annualized Capital Cost 0.03526 10,623,000 6,125,000 Total Annualized Cost 18,880,159 11,079,295
Max Project Yield (AFY) 16,800 10,080
MAX $/AF 1,124 1,099
Annual Operations & Maintenance Cost (5 mgd production) Annual O&M Annual O&M Variable O&M gpm TDH AFY kwh-yr Unit Cost
Desalination Facility 5,600 9,128,000 $0.20 1,825,600 1,095,360 Distribution Booster Pumps 3,472 200 1,375,200 $0.20 275,040 165,024 Brine Pump Station 4,028 100 797,580 $0.20 159,516 95,710 Fixed O&M Construction Cost Unit Cost
Treatment 78,291,000 1.0% 782,910 469,746 Storage 430,000 0.5% 2,150 1,290 Pump Stations 21,717,000 3.0% 651,510 390,906 Pipelines 15,721,000 0.5% 78,605 47,163 Total Annual Operations & Maintenance Cost 3,340,775 2,004,465 Annualized Capital Cost 0.03526 10,623,000 6,125,000 Total Annualized Cost 13,963,775 8,129,465
Min Project Yield (AFY) 2,240 3,360
MIN $/AF 6,234 2,419
The cost estimate for this option is based on a recent cost estimate from the 2021 MMWD Desalination Supply Study. This option is for a regional desalination plant to be located the MMWD’s Pelican Way Maintenance Yard facility in San Rafael, CA. The MMWD study was based on 15 MGD. It's assumed that Santa Rosa would "buy in" for up to 9 MGD of that 15 MGD and would pay a prorated share of capital and O&M costs.

Page 10 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options June 2023
Option DE-2: Ocean Desalination Full Project
Size Units Qty Unit Unit Cost Subtotal
Intake
Intake Screens, Pipeline and Pumps 9 MGD 1 LS $7,942,000 7,942,000 Raw Water Pipe 30 in 2,000 inch-dia LF $37 2,225,000
Desalination Plant
Rapid Mix 9 MGD 1 LS $1,220,000 1,220,000
Strainers, UF and Building 9 MGD 1 LS $10,601,000 10,601,000 Filtrate and Backwash Supply Tanks 9 MGD 1 LS $130,000 130,000 RO Feed Pump Station 9 MGD 1 LS $2,415,000 2,415,000
1st pass RO and Building, Permeate Tank 9 MGD 1 LS $19,555,000 19,555,000 Chlorine Contact Tank 9 MGD 1 LS $596,000 596,000
Chemical Facilities 9 MGD 1 LS $6,680,000 6,680,000
Backwash Equalization Basin 9 MGD 1 LS $258,000 258,000 Gravity Thickener 9 MGD 1 LS $1,434,000 1,434,000
Centrifuges 9 MGD 1 LS $4,086,000 4,086,000
O&M Building 9 MGD 1 LS $3,181,000 3,181,000
Sitework/Piping 9 MGD 1 LS $11,316,000 11,316,000
Electrical 9 MGD 1 LS $6,725,000 6,725,000
Instrumentation and Controls 9 MGD 1 LS $3,363,000 3,363,000 Brine Disposal
Brine Pump Station 290 HP $6,500 1,885,000
Brine Transmission Line 24 in 2,000 inch-dia LF $37 1,780,000 Distribution
Distribution Pump Station 1,880 HP $6,500 12,220,000
Treated Water Line 24 in 92,600 inch-dia LF $37 82,414,000 Raw Construction Cost 180,030,000
Construction Contingency 50% 90,020,000
Total Construction Cost 270,050,000
Implementation Cost 40% 108,020,000
Total Capital Cost 378,070,000
Annual Operations & Maintenance Cost (9mgd production) Annual O&M Variable O&M gpm TDH AFY kwh-yr Unit Cost
Desalination Facility 10,080 45,964,800 $0.20 9,192,960 Distribution Pump Station 6,250 893 11,055,060 $0.20 2,211,012 Brine Pump Station 7,107 122 1,714,410 $0.20 342,882
Fixed O&M Construction Cost Unit Cost
Treatment 46,975,000 1.0% 469,750
Storage 258,000 0.5% 1,290
Pump Stations 22,047,000 3.0% 661,410
Pipelines 94,361,000 0.5% 471,805
Total Annual Operations & Maintenance Cost 13,351,109
Annualized Capital Cost 0.03526 13,330,000
Total Annualized Cost 26,681,109
Max Project Yield (AFY) 10,080
MAX $/AF 2,647
Annual Operations & Maintenance Cost (5mgd production) Annual O&M Variable O&M gpm TDH AFY kwh-yr Unit Cost
Desalination Facility 5,600 25,536,000 $0.20 5,107,200
Distribution Pump Station 3,472 893 6,141,690 $0.20 1,228,338 Brine Pump Station 4,028 122 971,550 $0.20 194,310
Fixed O&M Construction Cost Unit Cost
Treatment 46,975,000 1.0% 469,750
Storage 258,000 0.5% 1,290
Pump Stations 22,047,000 3.0% 661,410
Pipelines 94,361,000 0.5% 471,805
Total Annual Operations & Maintenance Cost 8,134,103
Annualized Capital Cost 0.03526 13,330,000
Total Annualized Cost 21,464,103
Min Project Yield (AFY) 3,360
MIN $/AF 7,941
Basis of estimate:

The cost estimate for this option is based on a recent cost estimate from the 2021 MMWD Desalination Supply Study. This option is for a Santa Rosa owned desalination plant to be located south of Bodega Bay. The MMWD Study was based on 15 mgd, it is assumed Santa Rosa only needs to supply 9mgd, the costs were scaled from the 15 mgd plant down to a 9mgd plant.

Page 11 of 12 ends

Appendix A - Cost Details
Santa Rosa Water Supply Options July 2023
Option SW-1: Divert and store in Aquifer
Size Units Qty Unit Unit Cost Subtotal
Santa Rosa Creek Water Diversion
Diversion Structure, including pumps, spreading basins 10,080 per AF $1,800 18,144,000 Conventional Treatment Plant 9 MGD 1 LS $41,925,000 41,925,000 Extraction Wells
New Well Construction 500 gpm 12 per well $3,500,000 42,000,000 Product Water Distribution
Product Water Line 20 in 3,000 per inch-dia LF $37 2,225,000 Product Water Pump Station 240 HP $6,500 1,560,000
Potable Connection 1 LS $100,000 100,000
Raw Construction Cost 105,950,000
Construction Contingency 50% 52,980,000
Total Construction Cost 158,930,000
Implementation Cost 40% 63,570,000
Total Capital Cost 222,500,000
Annual Operations & Maintenance Cost (9 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Diversion Energy Costs 10,080 $16 163,296
Treatment $418,755 418,755
Product Water Pump Station 6,000 118 465,750 $0.20 93,150 Extraction Wells 10,080 $236 2,382,266
Fixed O&M Construction Cost Unit Cost
Treatment $418,755 418,755
Semi-Annual Basin Clearing $21,200 21,200
Well Inspections $10,000 10,000
Operational Labor Costs $10,000 10,000
Extraction Wells $443,119 443,119
Pump Stations 1,560,000 3.0% 46,800
Pipelines 2,225,000 0.5% 11,125
Total Annual Operations & Maintenance Cost 4,018,467
Annualized Capital Cost 0.03526 7,845,000
Total Annualized Cost 11,863,467
Max Project Yield (AFY) 10,080
MAX $/AF 1,177
Annual Operations & Maintenance Cost (0 mgd production) Annual O&M Variable O&M AFY GPM TDH (ft) kwh-yr Unit Cost
Diversion Energy Costs 0 $16 -
Treatment $0 -
Product Water Pump Station 0 118 0 $0.20 -
Extraction Wells 0 $236 -
Fixed O&M Construction Cost Unit Cost
Treatment $418,755 418,755
Semi-Annual Basin Clearing* $21,200.00 21,200
Well Inspections $10,000.00 10,000
Operational Labor Costs $10,000.00 10,000
Extraction Wells $443,119 443,119
Pump Stations 1,560,000 3.0% 46,800
Pipelines 2,225,000 0.5% 11,125
Total Annual Operations & Maintenance Cost 961,000
Annualized Capital Cost 0.03526 7,845,000
Total Annualized Cost 8,806,000
Min Project Yield (AFY) 1,008
MIN $/AF 8,736
Basis of estimate:

The cost estimate for this option is based on a recent cost estimate from Del Puerto. This option is for a stormwater diversion structure within Santa Rosa Creek to store water in the aquifer. This option assumes spreading basins for percolation into the aquifer and new extraction wells.

Page 12 of 12 ends

City of Santa Rosa (project #0012267.00) Woodard & Curran, Inc.

Feasibility Analysis August 2023

APPENDIX B: SCREENING TOOL DETAIL (BASELINE SCENARIO)

Appendix B - Screening Tool Baseline Scenario
Global modeling parameters and assumptions
apply to all scenarios, all options unless otherwise noted.

Global values
2045 Demand (AF/Y) 25,000 25,000 was given value
Max historic demand 23,993 in 2004, not used in calcs
max active savings 7,584 Table 4-1 UWMP; not used in calcs Sonom Water nominal allotment (AF/Y) 29,100 should be constant Sonoma Water peak historic draft (AF/Y) 20,693 just for info, not used in calcs Current groundwater firm capacity (AF/Y) 1,300
Default Sonoma Water $/AF 1,200
discount rate 2.5%
price of power ($/MWh) $200
first year of simulation 2045
planning horizon (yrs) 50
Sonoma cutback and state-imposed rationing by year type Year type
SCWA
Cutback
State-
imposed
Rationing
Wet 0% 0%
Normal 0% 0%
Dry 30% 10%

Page 1 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : DN Do nothing
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 0.00 as entered in Options definition Fixed OMR ($M/yr) 0.00 as entered in Options definition Fixed capital + OMR ($M/yr) 0.00 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 15
Max rationing 28% based on nominal demand
Max AFY supplemental supply 0 AF/yr
Avg Sonoma Water 21,567 AF/yr
Avg Sonoma Water Cost 25.9 $M/yr
Average AFY supplemental 0 based on scenario usage year-by-year, shown below Max supplemental AFY 0
Average marginal OMR $M/yr 0.00 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 0.00 combining with fixed costs shown above Average $/AF supplemental $0
Avg total cost including supplement + Sonoma 25.9 $M/yr Average OMR $/yr 0.00 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2046 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2047 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2048 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2049 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2050 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2051 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2052 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2053 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2054 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2055 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2056 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2057 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2058 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2059 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2060 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2061 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2062 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2063 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2064 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2065 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2066 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2067 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2068 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2069 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2070 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2071 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2072 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2073 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2074 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2075 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2076 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2077 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2078 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2079 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2080 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2081 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2082 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2083 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2084 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2085 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2086 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2087 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2088 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2089 Dry 30% 25,000 1,300 0 0 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 0 4,610 28% 28% 7,110 0 2090 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2091 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2092 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2093 Normal 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2094 Wet 0% 25,000 1,300 0 0 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
DN
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 2 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : GW-1 Add groundwater extraction wells
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 3.40 as entered in Options definition Fixed OMR ($M/yr) 0.50 as entered in Options definition Fixed capital + OMR ($M/yr) 3.90 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 8,726 AF/yr
Avg Sonoma Water 16,216 AF/yr
Avg Sonoma Water Cost 19.5 $M/yr
Average AFY supplemental 6,734 based on scenario usage year-by-year, shown below Max supplemental AFY 8,726
Average marginal OMR $M/yr 1.78 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 5.68 combining with fixed costs shown above Average $/AF supplemental $843
Avg total cost including supplement + Sonoma 25.1 $M/yr Average OMR $/yr 2.28 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2046 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2047 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2048 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2049 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2050 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2051 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2052 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2053 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2054 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2055 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2056 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2057 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2058 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2059 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2060 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2061 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2062 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2063 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2064 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2065 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2066 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2067 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2068 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2069 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2070 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2071 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2072 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2073 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2074 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2075 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2076 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2077 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2078 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2079 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2080 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2081 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2082 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2083 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2084 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2085 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2086 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2087 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2088 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2089 Dry 30% 25,000 1,300 5,880 10,080 17,820 12,474 10% 22,500 12,474 15.0 8,726 $264 8,726 0 5% 10% 2,500 8,726 2090 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2091 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2092 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2093 Normal 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 2094 Wet 0% 25,000 1,300 5,880 10,080 17,820 17,820 0% 25,000 17,820 21.4 5,880 $264 5,880 0 0% 0% 0 5,880 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
GW-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 3 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : GW-2 Convert emergency wells to production wells Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 0.41 as entered in Options definition Fixed OMR ($M/yr) 0.12 as entered in Options definition Fixed capital + OMR ($M/yr) 0.53 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 15
Max rationing 23% based on nominal demand
Max AFY supplemental supply 2,462 AF/yr
Avg Sonoma Water 20,260 AF/yr
Avg Sonoma Water Cost 24.3 $M/yr
Average AFY supplemental 1,744 based on scenario usage year-by-year, shown below Max supplemental AFY 2,462
Average marginal OMR $M/yr 0.41 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 0.94 combining with fixed costs shown above Average $/AF supplemental $541
Avg total cost including supplement + Sonoma 25.3 $M/yr Average OMR $/yr 0.53 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2046 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2047 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2048 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2049 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2050 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2051 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2052 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2053 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2054 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2055 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2056 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2057 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2058 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2059 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2060 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2061 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2062 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2063 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2064 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2065 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2066 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2067 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2068 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2069 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2070 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2071 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2072 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2073 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2074 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2075 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2076 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2077 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2078 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2079 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2080 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2081 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2082 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2083 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2084 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2085 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2086 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2087 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2088 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2089 Dry 30% 25,000 1,300 1,436 2,462 22,264 15,585 10% 22,500 15,585 18.7 5,615 $236 2,462 3,153 23% 23% 5,653 2,462 2090 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2091 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2092 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2093 Normal 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 2094 Wet 0% 25,000 1,300 1,436 2,462 22,264 22,264 0% 25,000 22,264 26.7 1,436 $236 1,436 0 0% 0% 0 1,436 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
GW-2
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 4 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : GW-3 Add ASR wells
Storage (AF): 5,000 as entered in Options definition
Storage threshold ($/AF): 500 supplemental supply is only used for discretionary storage puts when price is less than this value Capital cost ($M/yr) 2.86 as entered in Options definition Fixed OMR ($M/yr) 0.12 as entered in Options definition Fixed capital + OMR ($M/yr) 2.98 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 15
Max rationing 16% based on nominal demand
Max AFY supplemental supply 5,130 AF/yr
Avg Sonoma Water 18,844 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 3,634 based on scenario usage year-by-year, shown below Max supplemental AFY 5,130
Average marginal OMR $M/yr 6.59 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 9.57 combining with fixed costs shown above Average $/AF supplemental $2,632
Avg total cost including supplement + Sonoma 32.2 $M/yr Average OMR $/yr 6.71 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
Supplemental
Supply
Marginal Cost
$M
Take from
storage (AF)
2045 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2046 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2047 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2048 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2049 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2050 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2051 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2052 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2053 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2054 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2055 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2056 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2057 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2058 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2059 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2060 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2061 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2062 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2063 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2064 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2065 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2066 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2067 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2068 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2069 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2070 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2071 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2072 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2073 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2074 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2075 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2076 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2077 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2078 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2079 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2080 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2081 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2082 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2083 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2084 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2085 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2086 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2087 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2088 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2089 Dry 30% 25,000 1,300 2,993 5,130 20,708 14,495 10% 22,500 14,495 17.4 6,705 $1,813 5,130 1,575 16% 16% 4,075 5,130 9.30 0 2090 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2091 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2092 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2093 Normal 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 2094 Wet 0% 25,000 1,300 2,993 5,130 20,708 20,708 0% 25,000 20,708 24.8 2,993 $1,813 2,993 0 0% 0% 0 2,993 5.42 0 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
GW-3
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 5 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : PR-1 DPR at Laguna Treatment Plant
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 10.20 as entered in Options definition Fixed OMR ($M/yr) 0.87 as entered in Options definition Fixed capital + OMR ($M/yr) 11.08 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,724 AF/yr
Avg Sonoma Water 18,819 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 4,131 based on scenario usage year-by-year, shown below Max supplemental AFY 6,724
Average marginal OMR $M/yr 3.83 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 14.90 combining with fixed costs shown above Average $/AF supplemental $3,608
Avg total cost including supplement + Sonoma 37.5 $M/yr Average OMR $/yr 4.70 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2046 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2047 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2048 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2049 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2050 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2051 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2052 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2053 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2054 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2055 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2056 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2057 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2058 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2059 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2060 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2061 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2062 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2063 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2064 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2065 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2066 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2067 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2068 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2069 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2070 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2071 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2072 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2073 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2074 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2075 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2076 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2077 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2078 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2079 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2080 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2081 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2082 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2083 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2084 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2085 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2086 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2087 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2088 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2089 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $927 6,724 0 0% 10% 2,500 6,724 2090 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2091 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2092 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2093 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 2094 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $927 3,019 0 0% 0% 0 3,019 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
PR-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 6 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : PR-2 Satellite DPR (from RW line)
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 11.07 as entered in Options definition Fixed OMR ($M/yr) 0.95 as entered in Options definition Fixed capital + OMR ($M/yr) 12.03 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,724 AF/yr
Avg Sonoma Water 18,819 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 4,131 based on scenario usage year-by-year, shown below Max supplemental AFY 6,724
Average marginal OMR $M/yr 3.89 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 15.92 combining with fixed costs shown above Average $/AF supplemental $3,854
Avg total cost including supplement + Sonoma 38.5 $M/yr Average OMR $/yr 4.85 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2046 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2047 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2048 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2049 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2050 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2051 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2052 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2053 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2054 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2055 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2056 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2057 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2058 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2059 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2060 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2061 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2062 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2063 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2064 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2065 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2066 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2067 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2068 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2069 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2070 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2071 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2072 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2073 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2074 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2075 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2076 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2077 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2078 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2079 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2080 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2081 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2082 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2083 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2084 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2085 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2086 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2087 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2088 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2089 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $943 6,724 0 0% 10% 2,500 6,724 2090 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2091 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2092 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2093 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 2094 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $943 3,019 0 0% 0% 0 3,019 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
PR-2
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 7 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : PR-3a IPR to Delta Pond
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 14.78 as entered in Options definition Fixed OMR ($M/yr) 1.07 as entered in Options definition Fixed capital + OMR ($M/yr) 15.85 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,724 AF/yr
Avg Sonoma Water 18,819 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 4,131 based on scenario usage year-by-year, shown below Max supplemental AFY 6,724
Average marginal OMR $M/yr 3.87 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 19.72 combining with fixed costs shown above Average $/AF supplemental $4,775
Avg total cost including supplement + Sonoma 42.3 $M/yr Average OMR $/yr 4.94 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2046 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2047 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2048 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2049 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2050 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2051 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2052 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2053 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2054 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2055 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2056 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2057 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2058 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2059 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2060 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2061 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2062 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2063 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2064 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2065 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2066 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2067 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2068 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2069 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2070 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2071 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2072 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2073 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2074 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2075 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2076 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2077 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2078 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2079 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2080 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2081 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2082 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2083 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2084 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2085 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2086 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2087 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2088 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2089 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $936 6,724 0 0% 10% 2,500 6,724 2090 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2091 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2092 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2093 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 2094 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $936 3,019 0 0% 0% 0 3,019 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
PR-3a
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 8 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : PR-3c IPR to Lake Sonoma
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 19.82 as entered in Options definition Fixed OMR ($M/yr) 1.79 as entered in Options definition Fixed capital + OMR ($M/yr) 21.61 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,724 AF/yr
Avg Sonoma Water 18,819 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 4,131 based on scenario usage year-by-year, shown below Max supplemental AFY 6,724
Average marginal OMR $M/yr 4.96 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 26.57 combining with fixed costs shown above Average $/AF supplemental $6,431
Avg total cost including supplement + Sonoma 49.1 $M/yr Average OMR $/yr 6.75 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2046 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2047 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2048 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2049 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2050 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2051 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2052 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2053 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2054 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2055 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2056 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2057 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2058 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2059 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2060 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2061 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2062 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2063 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2064 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2065 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2066 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2067 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2068 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2069 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2070 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2071 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2072 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2073 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2074 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2075 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2076 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2077 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2078 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2079 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2080 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2081 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2082 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2083 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2084 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2085 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2086 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2087 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2088 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2089 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $1,201 6,724 0 0% 10% 2,500 6,724 2090 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2091 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2092 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2093 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 2094 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $1,201 3,019 0 0% 0% 0 3,019 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
PR-3c
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 9 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : PR-4 Regional DPR at LTP
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 8.71 as entered in Options definition Fixed OMR ($M/yr) 0.71 as entered in Options definition Fixed capital + OMR ($M/yr) 9.42 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,724 AF/yr
Avg Sonoma Water 18,819 AF/yr
Avg Sonoma Water Cost 22.6 $M/yr
Average AFY supplemental 4,131 based on scenario usage year-by-year, shown below Max supplemental AFY 6,724
Average marginal OMR $M/yr 3.66 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 13.08 combining with fixed costs shown above Average $/AF supplemental $3,166
Avg total cost including supplement + Sonoma 35.7 $M/yr Average OMR $/yr 4.37 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2046 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2047 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2048 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2049 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2050 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2051 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2052 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2053 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2054 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2055 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2056 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2057 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2058 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2059 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2060 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2061 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2062 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2063 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2064 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2065 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2066 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2067 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2068 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2069 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2070 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2071 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2072 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2073 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2074 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2075 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2076 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2077 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2078 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2079 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2080 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2081 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2082 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2083 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2084 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2085 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2086 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2087 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2088 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2089 Dry 30% 25,000 1,300 3,019 10,065 20,681 14,476 10% 22,500 14,476 17.4 6,724 $885 6,724 0 0% 10% 2,500 6,724 2090 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2091 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2092 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2093 Normal 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 2094 Wet 0% 25,000 1,300 3,019 10,065 20,681 20,681 0% 25,000 20,681 24.8 3,019 $885 3,019 0 0% 0% 0 3,019 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
PR-4
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 10 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : RW-1 Nonpotable Recycled Expansion
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 7.55 as entered in Options definition Fixed OMR ($M/yr) 1.27 as entered in Options definition Fixed capital + OMR ($M/yr) 8.82 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 15
Max rationing 16% based on nominal demand
Max AFY supplemental supply 3,000 AF/yr
Avg Sonoma Water 21,567 AF/yr
Avg Sonoma Water Cost 25.9 $M/yr
Average AFY supplemental 900 based on scenario usage year-by-year, shown below Max supplemental AFY 3,000
Average marginal OMR $M/yr 0.00 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 8.82 combining with fixed costs shown above Average $/AF supplemental $9,795
Avg total cost including supplement + Sonoma 34.7 $M/yr Average OMR $/yr 1.27 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2046 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2047 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2048 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2049 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2050 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2051 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2052 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2053 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2054 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2055 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2056 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2057 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2058 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2059 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2060 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2061 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2062 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2063 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2064 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2065 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2066 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2067 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2068 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2069 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2070 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2071 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2072 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2073 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2074 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2075 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2076 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2077 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2078 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2079 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2080 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2081 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2082 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2083 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2084 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2085 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2086 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2087 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2088 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2089 Dry 30% 25,000 1,300 0 3,000 23,700 16,590 10% 22,500 16,590 19.9 4,610 $0 3,000 1,610 16% 16% 4,110 3,000 2090 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2091 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2092 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2093 Normal 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 2094 Wet 0% 25,000 1,300 0 3,000 23,700 23,700 0% 25,000 23,700 28.4 0 $0 0 0 0% 0% 0 0 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
RW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
RW-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 11 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : DE-1 Regional Desalination (MMWD)
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 6.12 as entered in Options definition Fixed OMR ($M/yr) 0.91 as entered in Options definition Fixed capital + OMR ($M/yr) 7.03 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,962 AF/yr
Avg Sonoma Water 18,509 AF/yr
Avg Sonoma Water Cost 22.2 $M/yr
Average AFY supplemental 4,441 based on scenario usage year-by-year, shown below Max supplemental AFY 6,962
Average marginal OMR $M/yr 1.78 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 8.82 combining with fixed costs shown above Average $/AF supplemental $1,985
Avg total cost including supplement + Sonoma 31.0 $M/yr Average OMR $/yr 2.69 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2046 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2047 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2048 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2049 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2050 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2051 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2052 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2053 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2054 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2055 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2056 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2057 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2058 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2059 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2060 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2061 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2062 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2063 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2064 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2065 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2066 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2067 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2068 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2069 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2070 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2071 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2072 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2073 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2074 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2075 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2076 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2077 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2078 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2079 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2080 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2081 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2082 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2083 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2084 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2085 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2086 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2087 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2088 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2089 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $401 6,962 0 0% 10% 2,500 6,962 2090 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2091 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2092 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2093 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 2094 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $401 3,360 0 0% 0% 0 3,360 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
RW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
DE-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 12 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : DE-2 Ocean Desalination
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 13.33 as entered in Options definition Fixed OMR ($M/yr) 1.60 as entered in Options definition Fixed capital + OMR ($M/yr) 14.93 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,962 AF/yr
Avg Sonoma Water 18,509 AF/yr
Avg Sonoma Water Cost 22.2 $M/yr
Average AFY supplemental 4,441 based on scenario usage year-by-year, shown below Max supplemental AFY 6,962
Average marginal OMR $M/yr 5.17 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 20.11 combining with fixed costs shown above Average $/AF supplemental $4,528
Avg total cost including supplement + Sonoma 42.3 $M/yr Average OMR $/yr 6.78 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2046 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2047 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2048 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2049 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2050 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2051 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2052 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2053 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2054 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2055 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2056 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2057 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2058 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2059 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2060 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2061 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2062 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2063 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2064 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2065 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2066 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2067 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2068 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2069 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2070 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2071 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2072 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2073 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2074 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2075 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2076 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2077 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2078 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2079 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2080 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2081 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2082 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2083 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2084 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2085 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2086 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2087 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2088 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2089 Dry 30% 25,000 1,300 3,360 10,080 20,340 14,238 10% 22,500 14,238 17.1 6,962 $1,165 6,962 0 0% 10% 2,500 6,962 2090 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2091 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2092 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2093 Normal 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 2094 Wet 0% 25,000 1,300 3,360 10,080 20,340 20,340 0% 25,000 20,340 24.4 3,360 $1,165 3,360 0 0% 0% 0 3,360 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
RW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
DE-2
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 13 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : SW-1 Stormwater stored in aquifer
Storage (AF): 5,000 as entered in Options definition
Storage threshold ($/AF): 500 supplemental supply is only used for discretionary storage puts when price is less than this value Capital cost ($M/yr) 7.84 as entered in Options definition Fixed OMR ($M/yr) 0.54 as entered in Options definition Fixed capital + OMR ($M/yr) 8.39 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 0
Max rationing 10% based on nominal demand
Max AFY supplemental supply 6,008 AF/yr
Avg Sonoma Water 20,650 AF/yr
Avg Sonoma Water Cost 24.8 $M/yr
Average AFY supplemental 2,618 based on scenario usage year-by-year, shown below Max supplemental AFY 6,008
Average marginal OMR $M/yr 0.79 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 9.18 combining with fixed costs shown above Average $/AF supplemental $3,507
Avg total cost including supplement + Sonoma 34.0 $M/yr Average OMR $/yr 1.34 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2046 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 6,008 2047 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 2,008 2048 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,208 2049 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2050 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,599 2051 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2052 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,677 2053 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,142 2054 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2055 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,586 2056 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2057 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2058 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2059 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2060 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 3,328 2061 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,472 2062 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2063 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,652 2064 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2065 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,688 2066 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,144 2067 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,035 2068 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,013 2069 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2070 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,560 2071 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,118 2072 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2073 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,581 2074 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2075 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,674 2076 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,141 2077 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,035 2078 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,013 2079 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,009 2080 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2081 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,559 2082 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,118 2083 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,030 2084 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,012 2085 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,009 2086 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,008 2087 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,008 2088 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,008 2089 Dry 30% 25,000 1,300 1,008 10,080 22,692 15,884 10% 22,500 15,884 19.1 5,316 $303 5,316 0 0% 10% 2,500 5,316 2090 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,559 2091 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,118 2092 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,030 2093 Normal 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,012 2094 Wet 0% 25,000 1,300 1,008 10,080 22,692 22,692 0% 25,000 22,692 27.2 1,008 $303 1,008 0 0% 0% 0 1,009 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
SW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
RW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
SW-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 14 of 15 ends

Appendix B - Screening Tool Baseline Scenario
Choose an option to model, and a scenario to model it against. Those are the only two inputs on this sheet! Option : E-1 Efficiency programs
Storage (AF): 0 as entered in Options definition
Storage threshold ($/AF): 0 (n/a)
Capital cost ($M/yr) 5.96 as entered in Options definition Fixed OMR ($M/yr) 0.00 as entered in Options definition Fixed capital + OMR ($M/yr) 5.96 sum of amoritized capital plus fixed OMR Scenario: 2 Replay it again Sam, historic hydrology with base year 1920 Hydrology type: Historic
Base year: 1920 Base year of historic replay
Synthetic hydrology ID: n/a
Synthetic hydrology index: n/a
Sonoma reductions by year type: Wet 0%
Normal 0%
Dry 30%

SUMMARY OF RESULTS
Years with any rationing 15 out of 50 years
Years with rationing over state levels 15
Max rationing 26% based on nominal demand
Max AFY supplemental supply 2,145 AF/yr
Avg Sonoma Water 19,615 AF/yr
Avg Sonoma Water Cost 23.5 $M/yr
Average AFY supplemental 2,145 based on scenario usage year-by-year, shown below Max supplemental AFY 2,145
Average marginal OMR $M/yr 0.00 based on scenario usage year-by-year, shown below Average total $M/yr for supp. Supply 5.96 combining with fixed costs shown above Average $/AF supplemental $2,778
Avg total cost including supplement + Sonoma 29.5 $M/yr Average OMR $/yr 0.00 sum of fixed and marginal OMR
Year Year type
Sonoma
Water %
redu for
year type Demand
Supply
from
existing
wells
Min supp
AF
Max supp
AF
Baseline
demand
for SW
Sonoma
Water
max avail
(AF)
State-
imposed
rationing
for year
type
Eff demand
AF
Sonoma
Water
Sonoma
Water
cost $M
Supply
deficit AF
Supp supply
Marginal cost
$/AF
Supp supply
used for
demand (AF)
AF Residual
shortage
(surplus)
Needed
rationing
based on
supply
Actual
rationing
level Rationing Supp. Supply
2045 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2046 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2047 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2048 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2049 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2050 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2051 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2052 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2053 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2054 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2055 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2056 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2057 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2058 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2059 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2060 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2061 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2062 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2063 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2064 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2065 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2066 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2067 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2068 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2069 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2070 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2071 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2072 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2073 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2074 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2075 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2076 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2077 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2078 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2079 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2080 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2081 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2082 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2083 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2084 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2085 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2086 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2087 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2088 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2089 Dry 30% 25,000 1,300 2,145 2,145 21,555 15,088 10% 22,500 15,088 18.1 6,112 $0 2,145 3,966 26% 26% 6,466 2,145 2090 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2091 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2092 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2093 Normal 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 2094 Wet 0% 25,000 1,300 2,145 2,145 21,555 21,555 0% 25,000 21,555 25.9 2,145 $0 2,145 0 0% 0% 0 2,145 0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
E-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
SW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
DE-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
RW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-4
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3c
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-3a
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
PR-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-3
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-2
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2046 2051 2056 2061 2066 2071 2076 2081 2086
Supply (TAF)
Year
GW-1
sum of fixed and marginal OMR
0 5
10 15
20 25
30 0
5 10
15 20
25 30
2045 2050 2055 2060 2065 2070 2075 2080 2085 2090
Supply (TAF)
Year
E-1
Supply from existing wells Supp. Supply Rationing Sonoma Water Demand

Page 15 of 15 ends

City of Santa Rosa (project #0012267.00) Woodard & Curran, Inc.

Feasibility Analysis August 2023

APPENDIX C: MEMORANDUM ON DESALINATION SUPPLY OPTIONS IN THE

WATER SUPPLY FEASIBILITY ANALYSIS
95 Third Street | 2nd Floor
San Francisco CA 94103
www.woodardcurran.com
T 800.426.4262
T 415.321.3400

MEMORANDUM
DATE: August 31, 2023
RE: Desalination Supply Options in the Water Supply Feasibility Analysis

This memorandum provides additional context for desalination as a potential water supply for the feasibility analysis conducted for the City of Santa Rosa’s Water Supply Alternatives Plan (WSAP).

Strengths and Weaknesses of Desalination as a Water Supply Source Desalination is the process of removing salts from seawater or brackish water. Generally, salty water is piped from its location to the desalination facility, which requires a significant amount of power to run the treatment components. While there are a number of technologies used for treatment, reverse osmosis is the most common. O nce the salts are removed, the water undergoes further adjustments so that it can be introduced into the existing system via storage tanks and pipelines. Depending on the proxim ity of the desalination facility to the end users, the pipeline could be significant and require one or more pump stations to convey the water to a point where it can be introduced into the distribution system. Another pipeline is required to dispose of the brine that is created during the treatment process. Figure 1 shows the general process of an ocean desalination facility.

FIGURE 1: EXAMPLE DIAGRAM OF OCEAN DESALINATION FACILITY

Source: Perez-Zuniga, et.al. September 2020. Fault detection and isolation system based on structural analysis of an industrial seawater reverse osmosis desalination plant.

City of Santa Rosa 2 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 As with any supply type, desalination has a variety of strengths and weaknesses.

Strengths
• Immune to drought and variations in hydrologic conditions that are a concern for surface water (e.g., lakes and streams) , stormwater, and groundwater supply options , thus providing a continuous supply of water.
• Local source for coastal communities located in Mediterranean climates that experience more frequent boom-bust water cycles and for communities with large local sources of brackish water, such as salty groundwater.
• Benefits from advancements in treatment technology, energy efficiency, and availability of renewable energy sources.
• Scalable to meet water needs given that its source (in the case of ocean desalination) is nearly unlimited.
• Desalination facilities perform optimally when running at full capacity, benefiting from economies of scale and lowering the cost of desalinated water.

Weaknesses
• Extensive permitting requirements that can take a decade or more to resolve, particularly for ocean desalination facilities. For example, both the Carlsbad facility and the new recently approved Monterey facility took over 10 years to permit and secure approvals from the California Coastal Commission 1. Recently, the Coastal Commission denied a permit to a proposed facility in Huntington Beach, a project that has been in development for over 20 years2. While there have been some positive signs relative to permitting, including the Governor’s stated interest in desalination and the streamlined permitting process proposed by the State Water Resources Control Board, there remains significant uncertainty given the multiple permitting agencies involved 3. • Financial capital required to build desalination facilities can be in the hundreds of millions of dollars. The recently completed Claude “Bud” Lewis Carlsbad Desalination Plant in Carlsbad, California cost nearly $1 billion, well above initial estimates of $300 million4.
• Carries high annual operating costs due to the energy required in salt removal and treatment.

1 Becker, Rachel. CalMatters. 17 November 2022. Another California desalination plant approved – the most contentious one yet.
2 James, Ian. Los Angeles Times. 12 May 2022. California Coastal Commission rejects plan for Poseidon desalination plant.
3 State Water Resources Control Board. Ocean Plan Requirements for Seawater Desalination Facilities. 4 Dawid, Irvin. Planetizen. 2 November 2016. What Happened to all those Desalination Plants Proposed for California?

City of Santa Rosa 3 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 • Expensive membrane replacement (every three to five years) is critical to maintaining the health of desalination facilities, further contributing to large operation & maintenance costs. In addition, membranes can be “fouled” by algal blooms due to warming oceans, requiring more frequent maintenance, repair, and replacement costs. • Environmental concerns associated with the high greenhouse gas emissions footprint due to substantial energy required for treatment, particularly if the facility is supplied with fossil fuels.
• Environmental concerns associated with waste disposal. Desalination processes generate waste referred to as “brine ,” which can contain highly concentrated salts, heavy metals, cleaning chemical residues, and treatment reaction by -products.

Oftentimes, this waste stream is heated, which can cause concerns for the local environment when its discharged. Current reverse osmosis technology can recover only 50% of water entering treatment for ocean desalination facilities and 85% for brackish water facilities. This means that for an ocean desalination project, every 10 gallons of water treated would result in 5 gallons of brine requiring disposal. If future regulations require waste treatment before disposal, project costs would increase significantly. • Vulnerable to certain climate change related impacts, including rising sea levels and warming ocean temperatures (for ocean desalination projects). By their location alone, ocean desalination projects need to account for rising sea levels, which can be addressed during the design phase of a project. Warming ocean temperatures can create algal blooms, which can hasten the fouling of treatment components. One such example is the Carlsbad desalination facility, which experienced shut -downs and ultimately needed to move intakes and make process changes due to an algal bloom1. • Poor turndown capacity which keeps baseline costs high. Desalination facilities must maintain production levels at a minimum of 30% of capacity or risk the facility’s long - term health and performance. Thus, even in periods when no water from the facility may be needed, the plant must continue producing water and incurring the associated operating costs.

Review of Desalination Options Considered for Santa Rosa As discussed above, an ideal user for desalinated water is one that lives near the source water body and has a consistent demand that can be met with the supply. Santa Rosa has neither of these qualities: it is not proxima te to the ocean nor to another significant source of brackish water and its most significant need for water is during drought or catastrophic events, neither of which occur every year. Despite these challenges and others listed above , the feasibility analysis does consider two desalination supply options: a regional brackish water desalination facility (DE-1) and an ocean desalination facility (DE -2). The two options are further described in the following paragraphs.

1 Rivard, Ry. Voice of San Diego. 29 August 2017. Desal plant is producing less water than promised.

City of Santa Rosa 4 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 DE-1: Regional Brackish Water Desalination
Option DE-1 was conceived as a way to potentially reduce the major operating and capital costs associated with desalination. The defining aspect of the option is treatment of brackish water instead of ocean water, since that would have the potential to greatly lower costs.

However, because Santa Rosa is not located near a large brackish water source, DE -1 cannot move forward without significant involvement from major partners. Santa Rosa would not own or operate the facility so these partners would need to be a driving force in the implementation of any regional brackish water facility. Marin Water, a viable partner for such a project, has been evaluating desalination since the early 1980’s. In its recently released Strategic Water Supply Assessment, Marin Water discusses a Petaluma Brackish Regional Desalination project which it notes as being a late addition to the document and using a number of assumptions to develop its concept and costs1.

Option DE-1 would be implemented as follows:
• MMWD would construct a brackish water desalination plant, using funds provided by Santa Rosa to oversize the plant beyond MMWD’s own needs. In essence, Santa Rosa would have a certain percent stake in the project.
• Santa Rosa would pay MMWD for its share of capital and operating costs. Those costs would include operations even in wet and normal years, which are substantial because current desalination plants need to be run at about 30% of capacity to maintain their readiness.
• Rather than physically transporting the water from the treatment plant to Santa Rosa, Santa Rosa would trade water, such that water which MMWD would otherwise have taken from the Sonoma Water system would instead be taken by Santa Rosa.

Several aspects of the project impact its current viability:

1. Technical questions. The supply of brackish water has not been established, and may be insufficient even for MMWD’s needs, let alone for MMWD plus Santa Rosa. The cost and other technical aspects are not well developed.

2. MMWD may not build the project or may not wish to partner with Santa Rosa . This highlights a unique aspect of this option among the 18 options studied as part of water supply feasibility analysis: while many of the 18 options could potentially be enhanced with regional partnerships, DE-1 stands alone as the only option that simply could not move forward without a regional partner driving the project.

3. The technical and legal bases of the necessary water trade have not been established.

The proposed trade would occur in dry years and thus be limited to the amount of water that MMWD would be allowed to purchase from Sonoma Water in a dry year. In

1Marin Water. May 2023. Strategic Water Supply Assessment. https://www.marinwater.org/sites/default/files/2023-06/MMWD_SWSA_Final%20Draft%20Report.pdf

City of Santa Rosa 5 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 the most recent drought, Sonoma Water reduced MMWD’s supply to about 85% of its minimum take-or-pay amount, or about 4.5 TAF1. This falls short of Santa Rosa’s need for water. Further, MMWD’s contractual right to trade any water it would otherwise purchase from Sonoma Water has not been established.

4. The project would rely entirely on Sonoma Water infrastructure for its operations. This is at odds with the WSAP goal of improving Santa Rosa’s resilience to delivery interruptions from Sonoma Water.

Over time, many of the aspects listed above may resolve , although the fundamental mismatch between the option and the WSAP goal of increased self -sufficiency would remain. The next desalination option, DE-2, was conceived to overcome that concern.

DE-2: Ocean Desalination
Option DE-2 includes the construction and operation of an ocean desalination facility, located roughly 17 miles west of Santa Rosa in Bodega Bay. In contrast to DE -1, this option would be owned and operated by Santa Rosa and serve water directly to City cu stomers, thereby addressing the WSAP goal of providing increased self-sufficiency to the City.

DE-2 has the benefit of a largely unlimited, drought-proof water supply source and, as a result, any facility could be sized to meet whatever need exists. However, there is a minimum practical project size from both a cost and water yield perspective : certain economies of scale would favor a slightly larger project over a slightly smaller project and the City would want to ensure that such a facility would be able to provide a large portion of the water needed. As noted in the water supply feasibility analy sis, Santa Rosa does not require a large amount of water in every year type ; water is only needed during drought and any catastrophic interruptions of Russian River supply. Even though water wouldn’t be needed in an average year, the City would be required to run the desalination facility at 30% capacity to keep the components from souring, a concept referred to as turn-down capacity.

Running such a desalination facility 24/7 incurs very high operational and energy costs, one of the driving factors for DE -2’s high unit cost of water. Also impacting the capital costs of this option is the massive amount of infrastructure required to build this facility and convey the treated water back to Santa Rosa . The pipeline conveying the water to Santa Rosa is over 17 miles, requiring significant initial investment to build and more long -term O&M costs, particularly when that pipeline would require replacement. This pipeline also has the po tential to cross sensitive habitat, which would likely require substantial mitigation and permitting costs.

Given its location, pipeline design must also account for significant topography challenges and fault zones.

1 Marin Water Board meeting packet May 18, 2021 item 7: Due to the dry conditions and reservoir levels Sonoma Water will reduce allocations to their retail customers, including MMWD beginning in July. From July through September MMWD will be restricted to 4-MGD and a slight increase in October to 4.6-MGD. Staff expects that reduced allocation may continue if rainfall is below average in the fall. [In the event, heavy rain in October 2021 ended the restrictions.]

City of Santa Rosa 6 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 Given its already high cost, DE-2 was not analyzed in detail so the currently estimated costs are considered to be best -case with current technology. If detailed studies are done, several technical areas would be analyzed which could result in increased estimated costs. Such technical areas include plant siting, establishing how brine would be disposed, routing the pipeline or tunnel, and providing line power to the plant. Any one of these facets of facility design could drive costs upward from the estimate s included in the water supply feasibility analysis.

Despite the challenges outlined in this memo , future conditions may prompt reconsideration of desalination by Santa Rosa. Those potential future conditions are discussed in the last section of this memo.

Scoring Desalination as a Supply
If the two desalination options had advanced past the screening phase of the analysis, they would have been scored as shown in Table 1 for DE-1 (Regional Brackish) and Table 2 for DE- 2 (Ocean) . Because of the challenges discussed above, neither option scores well in environmental performance and legal, permitting, and regulatory. DE-2 scores favorably in city control and interagency coordination since the option is a city -controlled project. For cost effectiveness, DE-1 scores more favorably with a unit cost of water less than half that of DE -2.

In the future, there may be circumstances that would alter the individual criterion scores, resulting in a better overall score for desalination in Santa Rosa. Triggers that should cause the City to reconsider desalination as a supply are discussed in the next section. Table 3 is a reproduction of the summary scoring table presented in the water supply feasibility analysis with the addition of the two desalination scores. DE -2 (Ocean) has the least total weighted score of the options (18); DE-1 (Regional Brackish) has the least total unweighted score (5) but the same total weighted score as PR -2 (Satellite DPR). While these two overall scores are the same, potable reuse as a supply option is better suited to Santa Rosa than desalination as highlighted in the “Purified Water vs Desalination” side bar above.

City of Santa Rosa 7 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 TABLE 1: DETAILED SCORING FOR OPTION DE-1 (REGIONAL BRACKISH) Criterion Description Score
Cost
effectiveness
Based on conceptual level cost estimates, a brackish
water desalination facility would provide a minimum of
3,360 AFY with an average cost of water of at least
$2,000/AF.
1 Scalability
A brackish water desalination facility could be
constructed in modular phases to best fit City water
needs. Additionally, the facility could be scaled down
30% in low demand periods. However, the facility’s
scalability would potentially be limited not only by the yield of the project itself, but by the terms imposed by potentially multiple project partners. potentially be
limited not only by the yield of the project itself, but by the terms imposed by potentially multiple project
partners.
1 Resiliency
Low resiliency. While the ability to desalinate brackish water into potable supply would improve resiliency in
times of drought or future hydrologic uncertainty, under this supply option, Santa Rosa would be receiving a
partnering agency’s Sonoma Water allocation rather than desalinated water.
0 Equity
The additional desalinated water supply would have no
impact on vulnerable communities. Because this option
relies on a water transfer, ratepayers would be
responsible for contributing to the construction of the desalination facility while ultimately receiving water from Sonoma Water.
1 Environmental
performance
The construction and operation of a brackish water
desalination facility would have a high potential for
environmental impacts due to its high energy demands
and brine production.
0 Legal,
permitting, and
regulatory
High permitting/regulatory effort would be required to
construct a brackish water desalination facility. 0
City control and
interagency
coordination
Coordination with a regional partner for the paper
exchange would be required in addition to continuing
coordination with Sonoma Water if its aqueduct were
used for distribution.
0 Multi-benefit No other benefits provided. 0

City of Santa Rosa 8 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 TABLE 2: DETAILED SCORING FOR OPTION DE-2 (OCEAN)
Criterion Description Score
Cost
effectiveness
Under the baseline scenario cost estimate, a seawater
desalination facility would provide a minimum of 3,360
AFY with an average cost of water of approximately
$4,500/AF. This compares to $1,300/AF for the existing
Sonoma Water supply.
0 Scalability
While the ocean offers an infinitely scalable water supply, a seawater desalination facility would need to be
constructed at full capacity rather than in phases
because it would require the construction of a properly sized pipeline to convey desalinated water to the City.

Additionally, the facility would need to run at 30%
capacity even when not needed to meet City water
supply.
1 Resiliency
Moderate resiliency. The ability to desalinate seawater into potable supply would improve resiliency, even in
times of drought or future hydrologic uncertainty.

However, this supply option is highly sensitive to rising energy costs, decreasing overall cost-effectiveness.

The desalination process is also subject to disruption
from ocean conditions such as red tides, which are
expected to worsen in future years due to climate
change.
1 Equity
The additional desalinated water supply would have no
impact on the City’s vulnerable communities. However,
the City would need to consider potential equity issues if desalinated water were to be delivered to only a portion of its residents.
1 Environmental
performance
The construction and operation of a seawater
desalination facility would have a high potential for
environmental impacts due to its high energy demands
and brine production.
0 Legal,
permitting, and
regulatory
High permitting/regulatory effort would be required to
construct a seawater desalination facility. 0
City control and
interagency
coordination
No significant interagency coordination would be
required. 2
Multi-benefit No other benefits provided. 0

City of Santa Rosa 9 Woodard & Curran, Inc.

Desalination Options Water Supply Feasibility Analysis August 31, 2023 TABLE 3: SUMMARY OF SUPPLY OPTION SCORES WITH DESALINATION OPTIONS Criterion
Groundwater Purified Recycled Water Desalination Stormwater E-1:

Efficiency
Programs
GW-1:

Add
Extraction
Wells
GW-2:

Convert
Emergency
Wells
GW-3:

City ASR
Wells
PR-2:

Satellite
DPR
PR-4:

Regional
DPR
DE-1:

Brackish
Desal
DE-2:

Ocean
Desal
SW-1:

Stormwater
Storage in
Aquifer
Cost
effectiveness *
[$/AF]
2 [$840/AF]
2 [$540/AF]
2 [$1,100/AF]
0 [$3,900/AF]
0 [$3,200/AF]
1 [$2,000/AF]
0 [$4,500/AF]
0 [$3,500/AF]
1 [$2,800/AF]
Scalability
[Yield in AFY]
2 [5,880 -
10,080 AFY]
0 [1,436 - 2,462
AFY]
1 [2,993 - 5,130
AFY]
2 [3,019 - 10,065
AFY]
2 [3,019 - 10,065
AFY]
1 [3,360 - 10,080
AFY]
1 [3,360 - 10,080
AFY]
1 [1,008 - 10,080
AFY]
1 [2,145 AFY]
Resiliency 1 1 2 2 2 0 1 1 1
Equity 1 1 1 1 1 1 1 1 2
Environmental
performance 1 2 1 0 1 0 0 1 2
Legal,
permitting, and
regulatory
1 2 0 0 0 0 0 1 2
City control &
interagency
coordination
2 2 1 2 0 0 2 2 2
Multi-benefit 0 0 1 0 0 0 0 2 1
Total
Unweighted 10 10 9 7 6 3 5 9 12
Total
Weighted 32 26 29 21 22 13 13 19 30
* Costs shown reflect a realistic baseline usage scenario and include both capital and operating costs.

City of Santa Rosa 10 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 Triggers for Reconsidering Desalination in the Future
While the water supply feasibility analysis does not show the desalination options advancing past the screening phase, the City may, at some point in the future, determine that work to further desalination as a supply for Santa Rosa is warranted. Triggers that might cause the City to reconsider desalination include:
• Technology that reduces baseline operating costs. As discussed in this memo, desalination has poor turndown capacity; current technology requires that plants be operated at a minimum of 30% capacity. This results in significant annual operating costs to keep the plant “healthy” while waiting for times when its water is really needed (i.e., during droughts and catastrophic supply interruptions). Advancements in turndown capacity would reduce baseline operating costs and decrease the unit cost of water, particularly for DE-2.
• Less expensive energy prices which reduces operating costs. Because desalination plants require significant amounts of energy, their operating costs are heavily influenced by the cost of energy. The assumption used for costing desalination options in the water supply feasibility analysis was $0.20/kWh. Should there be a sustained drop in price, operating costs would decrease, perhaps making the unit cost of water of ocean desalination more comparable with other supply options. • Project configuration that yields direct water to Santa Rosa. DE-1 is configured as a regional brackish water desalination project that results in a water transfer, wherein Santa Rosa would accept additional Sonoma Water. While this configuration would reduce regional reliance on the Russian River system, it would not reduce the City’s reliance on Sonoma Water. The City could reconsider regional desalination if such a project were to provide desalinated water directly to Santa Rosa, thus reducing the City’s reliance on water from the Russian River system. • Technology that improves water recovery. With current technology, ocean desalination facilities have roughly 50% recovery; brackish facilities have up to 85% recovery. In either case, there is still a significant brine management and disposal challenge. This is one area where the industry is already seeing the impact of technological advances. In a recent City of Santa Monica pilot project, new technology increased recovery from 80% to 90%1. Santa Rosa should monitor advancements in this area as this new technology becomes more widely applied.

Prior to committing implementation funding to additional water supply projects, City s taff should revisit these triggers to determine if any developments or changes in these areas warrant a closer look at a desalination project for Santa Rosa. The Water Supply Alternatives Plan integrates the suggested revisit points in the discussion of Portfolio 4.

1 Sawicki, Emily. Santa Monica Daily Press. 21 January 2022. New water projects set to expand local supply.

City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023

APPENDIX B: LINKS TO RECORDED MEETINGS

List of Recorded Meetings

Date Forum Recording Link
April 28, 2022 City Council/Board of Public Utilities Liaison Subcommittee
Staff presented the project concept and received
input.

Video Recording
May 19, 2022 Board of Public Utilities
Staff presented the project concept, received
input, and requested approval to release a
Request for Proposals for consultant assistance.

Video Recording
Sept. 15, 2022 Board of Public Utilities
Staff presented an update on the consultant
selection process, final scope of work, schedule,
and next steps.

Video Recording
Oct. 13, 2022 Subregional Wastewater Technical Advisory Committee
Staff presented information about the Santa
Rosa’s water use history, water supplies, and the
project purpose, goals, scope of work, and
community engagement. Staff requested that the
SubTAC appoint a member to serve on the
project Stakeholder Group over the next year.

Video Recording
Oct. 26, 2022 Community Webinar #1
The project team presented background
information, the project purpose and approach,
water supply goals, water supply options to be
studied, and the criteria and methods for
studying the options.

Video Recording
Jan. 19, 2023 Board of Public Utilities
The project team conducted a study session and
requested input from the Board and public on
the water resiliency goals, water supply options,
and criteria for assessing the feasibility of the
options.

Video Recording

Date Forum Recording Link
Jan. 25, 2023 Community Webinar #2
The project team updated the community on the
water supply resiliency goals, water supply
options, and the criteria and methods for
studying them.

Video Recording
Feb. 9, 2023 Subregional Wastewater Technical Advisory
Committee
Staff and the project team presented an update
on the water supply resiliency goals, water supply
options, and the criteria and methods for
studying them.

Video Recording
June 26, 2023

Community Webinar #3
Staff and the project team updated the
community on the water supply options study
results, and discussed next steps, including
develop portfolios (mixes) of water supply
options and developing an adaptive plan for
increasing the City’s water supply resiliency and
reliability.

Video Recording
Aug 17, 2023 Board of Public Utilities
The project team provided a study session and
requested input from the Board and public on
the results of the study of water supply options
and proposed portfolios (mixes of water supply
options).

Video Recording
(Go to Item 3.1)

City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023

APPENDIX C: PORTFOLIO 1 EXAMPLE SCHEDULE

City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023

APPENDIX D: PORTFOLIO 2 EXAMPLE SCHEDULE

ID Task Name Duration Start Finish
1 Program Management 500 wks Wed 11/1/23 Tue 5/31/33
2 Water Supply Plan accepted 0 wks Wed 11/1/23 Wed 11/1/23 3 Adopt CIP funding initial capital elements0 wks Mon 7/1/24 Mon 7/1/24 4 Update GWMP 52 wks Wed 11/1/23 Tue 10/29/24
5 Manage Water Supply Elements 500 wks Wed 11/1/23 Tue 5/31/33 6 Outreach 500 wks Wed 11/1/23 Tue 5/31/33
7 E-1 Water Use Efficiency 304 wks Wed 11/1/23 Tue 8/28/29 8 NTP 0 wks Wed 11/1/23 Wed 11/1/23
9 Update Staffing Reso as Required 6 wks Wed 11/1/23 Tue 12/12/23 10 Review external funding opportunities 8 wks Wed 11/1/23 Tue 12/26/23 11 Finalize plan 16 ewks Wed 11/1/23 Wed 2/21/24
12 Phase 1 96 wks Wed 2/21/24 Wed 12/24/25
17 Phase 2 96 wks Wed 12/24/25 Wed 10/27/27
22 Phase 3 96 wks Wed 10/27/27 Tue 8/28/29
27 GW-2 Convert Ex Wells 282 wks Mon 7/1/24 Fri 11/23/29 28 NTP 0 wks Mon 7/1/24 Mon 7/1/24
29 Hydrogeologic Studies 52 wks Mon 7/1/24 Fri 6/27/25
30 CEQA 16 wks Mon 6/16/25 Sun 10/5/25
35 Regulatory Approvals & Interagency Coordination52 wks Mon 10/6/25 Fri 10/2/26 38 Design 52 wks Mon 10/5/26 Fri 10/1/27
39 Construction 52 wks Mon 10/4/27 Fri 9/29/28
40 Initial Operations 52 wks Mon 10/2/28 Fri 9/28/29
41 Assess Performance 8 wks Mon 10/1/29 Fri 11/23/29
42 Determine Remaining Need for Water 0 wks Fri 11/23/29 Fri 11/23/29 43 GW-1 New Wells 400.8 wksMon 7/1/24 Thu 3/4/32
44 Initial NTP 0 wks Mon 7/1/24 Mon 7/1/24
45 Siting Studies 58 wks Mon 7/1/24 Fri 8/8/25
52 Site(s) selected 0 wks Fri 8/8/25 Fri 8/8/25
53 Budget and scope updated 6 wks Mon 8/11/25 Fri 9/19/25 54 NTP #2 0 wks Fri 9/19/25 Fri 9/19/25
55 CEQA 90.8 wks Mon 9/22/25 Thu 6/17/27
73 Regulatory Approvals & Interagency Coordination120.8 wks Fri 2/20/26 Thu 6/15/28 83 Design 70 wks Fri 6/18/27 Thu 10/19/28
84 Construction 116 wks Fri 10/20/28 Thu 1/9/31
88 Initial Operations 52 wks Fri 1/10/31 Thu 1/8/32
89 Assess Performance 8 wks Fri 1/9/32 Thu 3/4/32
90 Determine Remaining Need for Water 0 wks Thu 3/4/32 Thu 3/4/32 11/1/2023
7/1/2024
11/1/2023
7/1/2024
11/23/2029
7/1/2024
8/8/2025
9/19/2025
3/4/2032
2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046 Portfolio 2

City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023

APPENDIX E: PORTFOLIO 3 EXAMPLE SCHEDULE

ID Task Name Duration Start
1Program Management500 wks Wed 11/1/23
2Water Supply Plan accepted0 wks Wed 11/1/23
3Adopt CIP funding initial capital elements0 wks Mon 7/1/24 4Update GWMP52 wks Wed 11/1/23
5Manage Water Supply Elements500 wks Wed 11/1/23
6Outreach500 wks Wed 11/1/23
7E-1 Water Use Efficiency304 wksWed 11/1/23
8NTP0 wks Wed 11/1/23
9Update Staffing Reso as Required6 wks Wed 11/1/23
10Review external funding opportunities8 wks Wed 11/1/23 11Finalize plan16 ewks Wed 11/1/23
12Phase 196 wks Wed 2/21/24
17Phase 296 wks Wed 12/24/25
22Phase 396 wks Wed 10/27/27
27GW-2 Convert Ex Wells282 wksMon 7/1/24
28NTP0 wks Mon 7/1/24
29Hydrogeologic Studies52 wks Mon 7/1/24
30CEQA16 wks Mon 6/16/25
35Regulatory Approvals & Interagency Coordination52 wks Mon 10/6/25 38Design52 wks Mon 10/5/26
39Construction52 wks Mon 10/4/27
40Initial Operations52 wks Mon 10/2/28
41Assess Performance8 wks Mon 10/1/29
42Determine Remaining Need for Water0 wks Fri 11/23/29
43GW-1 New Wells400.8 wksMon 7/1/24
44Initial NTP0 wks Mon 7/1/24
45Siting Studies58 wks Mon 7/1/24
52Site(s) selected0 wks Fri 8/8/25
53Budget and scope updated6 wks Mon 8/11/25
54NTP #20 wks Fri 9/19/25
55CEQA90.8 wks Mon 9/22/25
73Regulatory Approvals & Interagency Coordination120.8 wks Fri 2/20/26 83Design70 wks Fri 6/18/27
84Construction116 wks Fri 10/20/28
88Initial Operations52 wks Fri 1/10/31
89Assess Performance8 wks Fri 1/9/32
90Determine Remaining Need for Water0 wks Thu 3/4/32
91PR-2 Direct Potable Reuse804.8 wksMon 7/1/24
92NTP for Planning Phase only0 wks Mon 7/1/24
93Initial Planning studies104 wks Mon 7/1/24
98Re-assess Needs8 wks Mon 6/29/26
99NTP for Detailed Planning0 wks Thu 3/4/32
100CEQA76 wks Fri 3/5/32
101Permitting104 wks Fri 3/5/32
102NTP for Design Phase0 wks Thu 3/2/34
103Design150 wks Fri 3/3/34
104NTP for Construction Phase0 wks Thu 1/15/37
105Construction150 wks Fri 1/16/37
106In service0 wks Thu 12/1/39
107Determine Remaining Need for Water0 wks Thu 12/1/39
108SW-1 Stormwater Capture in Aquifer602.8 wksMon 7/1/24 109NTP for Planning Phase only0 wks Mon 7/1/24
110Initial Planning Studies104 wks Mon 7/1/24
115Re-assess Needs8 wks Fri 3/5/32
116NTP for Detailed Planning0 wks Thu 4/29/32
117CEQA90 wks Fri 4/30/32
118Permitting52 wks Fri 4/30/32
119NTP for Design Phase0 wks Thu 1/19/34
120Design52 wks Fri 1/20/34
121NTP for Construction Phase0 wks Thu 1/18/35
122Construction52 wks Fri 1/19/35
123In service0 wks Thu 1/17/36
11/1/2023
7/1/2024
11/23/2029
7/1/2024
8/8/2025
9/19/2025
3/4/2032
7/1/2024
3/4/2032
3/2/2034
1/15/2037
12/1/2039
12/1/2039
7/1/2024
4/29/2032
1/19/2034
1/18/2035
1/17/2036
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Portfolio 3

City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023

APPENDIX F: PORTFOLIO 4 EXAMPLE SCHEDULE (BASELINE SCENARIO) ID Task Name Duration Start Finish Predecessors
1 Program Management 500 wks Wed 11/1/23 Tue 5/31/33
2 Water Supply Plan accepted 0 wks Wed 11/1/23 Wed 11/1/23 3 Adopt CIP funding initial capital elements 0 wks Mon 7/1/24 Mon 7/1/24 4 Update GWMP 52 wks Wed 11/1/23 Tue 10/29/24 2
5 Manage Water Supply Elements 500 wks Wed 11/1/23 Tue 5/31/33 2 6 Outreach 500 wks Wed 11/1/23 Tue 5/31/33 2
7 E-1 Water Use Efficiency 304 wks Wed 11/1/23 Tue 8/28/29 8 NTP 0 wks Wed 11/1/23 Wed 11/1/23 2
9 Update Staffing Reso as Required 6 wks Wed 11/1/23 Tue 12/12/23 8 10 Review external funding opportunities 8 wks Wed 11/1/23 Tue 12/26/23 8 11 Finalize plan 16 ewks Wed 11/1/23 Wed 2/21/24 8
12 Phase 1 96 wks Wed 2/21/24 Wed 12/24/25
17 Phase 2 96 wks Wed 12/24/25 Wed 10/27/27
22 Phase 3 96 wks Wed 10/27/27 Tue 8/28/29
27 GW-2 Convert Ex Wells 282 wks Mon 7/1/24 Fri 11/23/29 28 NTP 0 wks Mon 7/1/24 Mon 7/1/24 3
29 Hydrogeologic Studies 52 wks Mon 7/1/24 Fri 6/27/25 28 30 CEQA 16 wks Mon 6/16/25 Sun 10/5/25
35 Regulatory Approvals & Interagency Coordination 52 wks Mon 10/6/25 Fri 10/2/26 38 Design 52 wks Mon 10/5/26 Fri 10/1/27 36,30
39 Construction 52 wks Mon 10/4/27 Fri 9/29/28 38
40 Initial Operations 52 wks Mon 10/2/28 Fri 9/28/29 39 41 Assess Performance 8 wks Mon 10/1/29 Fri 11/23/29 40 42 Determine Remaining Need for Water 0 wks Fri 11/23/29 Fri 11/23/29 41 43 GW-1+ New Wells (ASR and-or Extraction) 624.8 wks Mon 7/1/24 Thu 6/19/36 44 Initial NTP 0 wks Mon 7/1/24 Mon 7/1/24 3
45 Siting Studies 94 wks Mon 7/1/24 Fri 4/17/26
53 Site(s) selected 0 wks Fri 4/17/26 Fri 4/17/26 52
54 Budget and scope updated 6 wks Mon 11/26/29 Fri 1/4/30 42 55 NTP #2 0 wks Fri 1/4/30 Fri 1/4/30 54
56 CEQA 90.8 wks Mon 1/7/30 Thu 10/2/31
74 Regulatory Approvals & Interagency Coordination 120.8 wks Fri 6/7/30 Thu 9/30/32 84 Design 70 wks Fri 10/3/31 Thu 2/3/33 73
85 Construction 116 wks Fri 2/4/33 Thu 4/26/35 83,84
89 Initial Operations 52 wks Fri 4/27/35 Thu 4/24/36 88 90 Assess Performance 8 wks Fri 4/25/36 Thu 6/19/36 89
91 Determine Remaining Need for Water 0 wks Thu 6/19/36 Thu 6/19/36 90 92 PR-2 Direct Potable Reuse 1010.4 wksWed 1/1/25 Thu 5/12/44 93 Assess Final Regulations 12 wks Wed 1/1/25 Tue 3/25/25 2 94 NTP for Planning Phase only 0 wks Tue 3/25/25 Tue 3/25/25 93 95 Initial Planning studies 104 wks Wed 3/26/25 Tue 3/23/27 100 Re-assess Needs 8 wks Fri 6/20/36 Thu 8/14/36 99,42,91,112 101 NTP for Detailed Planning 0 wks Thu 8/14/36 Thu 8/14/36 100 102 CEQA 76 wks Fri 8/15/36 Thu 1/28/38 101
103 Permitting 104 wks Fri 8/15/36 Thu 8/12/38 101
104 NTP for Design Phase 0 wks Thu 8/12/38 Thu 8/12/38 102,103 105 Design 150 wks Fri 8/13/38 Thu 6/27/41 104
106 NTP for Construction Phase 0 wks Thu 6/27/41 Thu 6/27/41 105 107 Construction 150 wks Fri 6/28/41 Thu 5/12/44 106
108 In service 0 wks Thu 5/12/44 Thu 5/12/44 107
109 Determine Remaining Need for Water 0 wks Thu 5/12/44 Thu 5/12/44 108 110 SW-1 Stormwater Capture in Aquifer 566 wks Mon 7/1/24 Fri 5/4/35 111 NTP for Planning Phase only 0 wks Mon 7/1/24 Mon 7/1/24 3 112 Initial Planning Studies 104 wks Mon 7/1/24 Fri 6/26/26 111 117 Re-assess Needs 8 wks Mon 11/26/29 Fri 1/18/30 116,95,42 118 NTP for Detailed Planning (assume synergy with
GW-1 was identified)
0 wks Fri 1/18/30 Fri 1/18/30 117
119 CEQA 90 wks Mon 1/21/30 Fri 10/10/31 118
120 Permitting 52 wks Mon 1/21/30 Fri 1/17/31 118
121 NTP for Design Phase 0 wks Fri 10/10/31 Fri 10/10/31 119,120,84SS 122 Design 70 wks Mon 10/13/31 Fri 2/11/33 121
123 NTP for Construction Phase 0 wks Fri 2/11/33 Fri 2/11/33 122 124 Construction 116 wks Mon 2/14/33 Fri 5/4/35 123
125 In service 0 wks Fri 5/4/35 Fri 5/4/35 124
11/1/2023
7/1/2024
CEQA
Operations
11/23/2029
7/1/2024
4/17/2026 Sites selected
1/4/2030
3/25/2025
7/1/2024
1/18/2030
10/10/2031
Dec JanFebMarAprMayJun Jul AugSepOctNovDec Jan FebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec Jan FebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec JanFebMarAprMayJun Jul AugSepOctNovDec Jan FebMarApr Qtr 4, 2022 Qtr 1, 2023Qtr 2, 2023 Qtr 3, 2023 Qtr 4, 2023 Qtr 1, 2024 Qtr 2, 2024 Qtr 3, 2024 Qtr 4, 2024 Qtr 1, 2025Qtr 2, 2025 Qtr 3, 2025 Qtr 4, 2025 Qtr 1, 2026Qtr 2, 2026 Qtr 3, 2026 Qtr 4, 2026 Qtr 1, 2027Qtr 2, 2027 Qtr 3, 2027 Qtr 4, 2027 Qtr 1, 2028 Qtr 2, 2028 Qtr 3, 2028 Qtr 4, 2028 Qtr 1, 2029Qtr 2, 2029 Qtr 3, 2029 Qtr 4, 2029 Qtr 1, 2030Qtr 2, 2030 Qtr 3, 2030 Qtr 4, 2030 Qtr 1, 2031Qtr 2, 2031 Qtr 3, 2031 Qtr 4, 2031 Qtr 1, 2032 Qtr 2, 2032 Portfolio 4
Wed 8/2/23
City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023
APPENDIX G: PORTFOLIO 4 EXAMPLE SCHEDULE (ALTERNATIVE SCENARIO) ID Task Name Duration Start1Program Management500 wksWed 11/1/232Water Supply Plan accepted0 wksWed 11/1/233Adopt CIP funding initial capital elements0 wksMon 7/1/244Update GWMP52 wksWed 11/1/235Manage Water Supply Elements500 wksWed 11/1/236Outreach500 wksWed 11/1/237E-1 Water Use Efficiency304 wksWed 11/1/238NTP0 wksWed 11/1/239Update Staffing Reso as Required6 wksWed 11/1/2310Review external funding opportunities8 wksWed 11/1/2311Finalize plan16 ewksWed 11/1/2312Phase 196 wksWed 2/21/2413NTP0 wksWed 2/21/2414Onboard initial staff52 ewksWed 2/21/2415Initial implementation52 ewksWed 12/25/2416Phase 1 savings online0 ewksWed 12/24/2517Phase 296 wksWed 12/24/2518NTP Phase 20 wksWed 12/24/2519Onboard Phase 2 staff52 ewksWed 12/24/2520Second phase implementation52 ewksWed 10/28/2621Phase 2 savings online0 wksWed 10/27/2722Phase 396 wksWed 10/27/2723NTP Phase 30 wksWed 10/27/2724Onboard Phase 3 staff52 wksWed 10/27/2725Phase 3 Implementation52 wksWed 8/30/2826Phase 3 savings online0 wksTue 8/28/2927GW-2 Convert Ex Wells282 wksMon 7/1/2428NTP0 wksMon 7/1/2429Hydrogeologic Studies52 wksMon 7/1/2430CEQA 16 wksMon 6/16/2535Regulatory Approvals & Interagency Coordination52 wksMon 10/6/2538Design52 wksMon 10/5/2639Construction52 wksMon 10/4/2740Initial Operations52 wksMon 10/2/2841Assess Performance8 wksMon 10/1/2942Determine Remaining Need for Water0 wksFri 11/23/2943GW-1+ New Wells (ASR and-or Extraction)624.8 wksMon 7/1/2444Initial NTP0 wksMon 7/1/2445Siting Studies94 wksMon 7/1/2453Site(s) selected0 wksFri 4/17/2654Budget and scope updated6 wksMon 11/26/2955NTP #20 wksFri 1/4/3056CEQA90.8 wksMon 1/7/3074Regulatory Approvals & Interagency Coordination120.8 wksFri 6/7/3084Design70 wksFri 10/3/3185Construction116 wksFri 2/4/3389Initial Operations52 wksFri 4/27/3590Assess Performance8 wksFri 4/25/3691Determine Remaining Need for Water0 wksThu 6/19/3692PR-2 Direct Potable Reuse606.4 wksWed 1/1/2593Assess Final Regulations12 wksWed 1/1/2594NTP for Planning Phase only0 wksTue 3/25/2595Initial Planning studies104 wksWed 3/26/25100Re-assess Needs8 wksFri 6/20/36101Project suspended since other options meet needs0 wksThu 8/14/36102SW-1 Stormwater Capture in Aquifer632.8 wksMon 7/1/24103NTP for Planning Phase only0 wksMon 7/1/24104Initial Planning Studies104 wksMon 7/1/24109Assume no synergy with GW-1 exists, project pauses0 wksFri 6/26/26110Reconsider after other options in place8 wksFri 6/20/36111Project suspended since other options meet needs0 wksThu 8/14/36 11/1/2023
7/1/2024
11/1/2023
2/21/2024
12/24/2025
12/24/2025
10/27/2027
10/27/2027
8/28/2029
7/1/2024
11/23/2029
7/1/2024
4/17/2026
1/4/2030
6/19/2036
3/25/2025
8/14/2036
7/1/2024
6/26/2026
8/14/2036
202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045Portfolio 4 variant City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023
APPENDIX H: SANTA ROSA WATER’S RECENT BUDGETS FOR OPERATIONS AND

CAPITAL PROJECTS
Budget Review - Department Expenditures By Program (BUD0109) Santa Rosa Water
Expenditures by Program
2019-20
Actual
2020-21
Actual
2021-22
Actual
2022-23
Actual
2023-24
Current
Budget
Administration 4,391,348 4,758,812 7,865,232 7,638,892 9,663,170 Purchase of Water 16,509,170 17,355,962 15,437,921 12,255,230 17,833,000 Storm Water and Creeks 2,071,496 2,123,052 2,136,786 2,218,252 2,788,806 Water Resources 967,635 1,063,955 1,172,372 1,064,852 1,253,398 Water O&M 15,500,866 16,495,238 17,376,493 14,948,245 21,637,649 Local Wastewater O&M 10,633,746 11,690,420 11,818,549 9,704,859 13,871,941 Wastewater Resource Recovery 22,576,722 24,042,689 24,959,785 20,675,644 31,726,010 Wastewater Resource Distribution 6,743,223 7,167,529 7,296,000 3,927,072 8,630,181 Debt Service 25,694,593 81,340,032 26,806,421 27,663,493 27,668,524 Engineering Resources 3,260,668 3,539,122 3,522,035 3,002,271 3,610,531 Subtotal $108,349,467 $169,576,811 $118,391,594 $103,098,810 $138,683,210 CIP and O&M Projects $30,081,714 $52,431,560 $35,790,769 $253,855,624 $37,739,929 TOTAL $138,431,181 $222,008,371 $154,182,363 $356,954,434 $176,423,139 Department Expenditures By Program
BUD0109 Page 1 of 1
8/14/2023 2:50:30 PM
User: cc
City of Santa Rosa Woodard & Curran, Inc.

Water Supply Alternatives Plan September 8, 2023
APPENDIX I: MEMORANDUM ON DESALINATION SUPPLY OPTIONS IN THE

WATER SUPPLY FEASIBILITY ANALYSIS
95 Third Street | 2nd Floor
San Francisco CA 94103
www.woodardcurran.com
T 800.426.4262
T 415.321.3400

MEMORANDUM
DATE: August 31, 2023
RE: Desalination Supply Options in the Water Supply Feasibility Analysis

This memorandum provides additional context for desalination as a potential water supply for the feasibility analysis conducted for the City of Santa Rosa’s Water Supply Alternatives Plan (WSAP).

FIGURE 1: EXAMPLE DIAGRAM OF OCEAN DESALINATION FACILITY

Source: Perez-Zuniga, et.al. September 2020. Fault detection and isolation system based on structural analysis of an industrial seawater reverse osmosis desalination plant.

City of Santa Rosa 2 Woodard & Curran, Inc.

Desalination Options in the Water Supply Feasibility Analysis August 31, 2023 As with any supply type, desalination has a variety of strengths and weaknesses.

City of Santa Rosa 3 Woodard & Curran, Inc.

1 Rivard, Ry. Voice of San Diego. 29 August 2017. Desal plant is producing less water than promised.

City of Santa Rosa 4 Woodard & Curran, Inc.

Several aspects of the project impact its current viability:

3. The technical and legal bases of the necessary water trade have not been established.

The proposed trade would occur in dry years and thus be limited to the amount of water that MMWD would be allowed to purchase from Sonoma Water in a dry year. In

1Marin Water. May 2023. Strategic Water Supply Assessment. https://www.marinwater.org/sites/default/files/2023-06/MMWD_SWSA_Final%20Draft%20Report.pdf

City of Santa Rosa 5 Woodard & Curran, Inc.

Given its location, pipeline design must also account for significant topography challenges and fault zones.

City of Santa Rosa 6 Woodard & Curran, Inc.

City of Santa Rosa 7 Woodard & Curran, Inc.

City of Santa Rosa 8 Woodard & Curran, Inc.

However, this supply option is highly sensitive to rising energy costs, decreasing overall cost-effectiveness.

City of Santa Rosa 9 Woodard & Curran, Inc.

Efficiency
Programs
GW-1:

Add
Extraction
Wells
GW-2:

Convert
Emergency
Wells
GW-3:

City ASR
Wells
PR-2:

Satellite
DPR
PR-4:

Regional
DPR
DE-1:

Brackish
Desal
DE-2:

Ocean
Desal
SW-1:

City of Santa Rosa 10 Woodard & Curran, Inc.

1 Sawicki, Emily. Santa Monica Daily Press. 21 January 2022. New water projects set to expand local supply.

Santa Rosa City CouncilOctober 24, 2023

Santa Rosa City Council
October 24, 2023