Document Modesto_doc_ca26734013

May 2010 i City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report TABLE OF CONTENTS 1.0 2.0 SUMMARY OF RESULTS 3.0 WATER DISTRIBUTION SYSTEM 3.1 SERVICE 3.2 CURRENT AND PROJECTED WATER 3.3 WATER SUPPLY 3.3.1 Groundwater 3.3.2 Surface Water Supply 3.3.3 Supply Analysis 4.0 JUSTIFICATION AND COST ALLOCATION FOR PROPOSED 4.1 MAJOR PROJECT 4.1.1 Phase Two Expansion (Category 4.1.2 City-Side Improvements related to Expansion (Category 4.1.2.1 Transmission Pipeline 4.1.2.2 Storage Tank Costs 4.1.2.3 Motor Operated Control Valve Costs 4.1.2.4 Unclassified 4.1.3 (Category 4.1.4 City-Side Improvements related to the (Category 4.2 PROJECT 4.2.1 Water Quality Study (Category 4.2.2 Remove Water Tank (Category 4.2.3 New Corporation Yard (Category 6) 4.2.4 Soil Remediation (Category 24) 4.3 PROGRAM IMPROVEMENTS 4.3.1 Existing Tank Improvements (Category 4.3.2 Extend Water Mains Program (Category 8) 4.3.3 Strengthen and Replace Water System Program (Category 4.3.4 Install New Wells Program (Category 4.3.5 Wellhead Treatment Program (Category 4.3.6 Purchase and Install New Generators Program (Category 4.3.7 Water System Security Enhancements (Category 4.3.8 Groundwater Management Plan (Category 4.3.9 Urban Water Management Plan (Category 15) 4.3.10 Water Master Plan (Category 16) 4.3.11 Water System Evaluation (Category 17) 4.3.12 New Water Tanks (Category 4.3.13 Water Meters Program (Category 4.3.14 New or Replacement Pumps (Category ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A Table of Contents May 2010 ii City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 4.3.15 Soil Remediation Program (Category 4.3.16 Utility Cuts Program (Category 5.0 PROJECT SCHEDULE AND COST 6.0 LIST OF ATTACHMENTS Attachment A: Construction Costs for Planning and Design Attachment B: City of Modesto Drinking Water Wells Out of Service in August 2009 Attachment C: Detailed Construction Costs Based on Evaluations in Appendices D through J Attachment D: City 2009 – 2038 CIP Spreadsheet LIST OF APPENDICES APPENDIX A: City of Modesto’s 2010 Water System Engineer’s Report Facilities Inventory of the Existing Water System for the Contiguous Service Area (Facilities Inventory TM) APPENDIX B: City of Modesto’s 2010 Water System Engineer’s Report Existing and Buildout Demand Evaluation (Demand TM) APPENDIX C: City of Modesto’s 2010 Water System Engineer’s Report Comparison of Existing Water Supply and Projected Water Demands (Supply vs. Demand TM) APPENDIX D: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Existing Water System for the Contiguous Service Area (Existing System Evaluation TM) APPENDIX E: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Buildout Water System for the Contiguous Service Area – Option A (Buildout System Evaluation TM) APPENDIX F: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Existing and Buildout Water System for the Grayson Outlying Service Area (Grayson TM) APPENDIX G: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of Existing and Buildout Water System for the Hickman Outlying Service Area (Hickman TM) ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A Table of Contents May 2010 iii City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report APPENDIX H: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Existing Buildout Water System for the Del Rio Outlying Service Area (Del Rio TM) APPENDIX I: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Existing and Buildout Water System for the Turlock Water Outlying Service Area (Turlock TM) APPENDIX J: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Existing and Buildout Water System for the Waterford Outlying Service Area (Waterford TM) APPENDIX K: City of Modesto’s 2010 Water System Engineer’s Report Evaluation of the Buildout Water System for the Contiguous Service Area – Option B (Buildout System Evaluation TM) LIST OF TABLES Table 1. Summary of Water System Cost Categories Between Existing and Future Customers Table 2. Summary of CIP Recommendation Cost Estimates Table 3. Existing and Projected Buildout Table 4. Total Existing Water Supplies During Normal or Wetter Hydrologic Conditions............9 Table 5. Total Existing Water Supplies During a 5-Year Drought at and near Table 6. Preliminary Operational Yield Allocated to Outlying Service Areas and Available to the Contiguous Service Table 7. Summary of CIP Cost Estimates by Improvement Table 8. Summary of Major Project Improvement Cost Table 9. Summary of Project Improvement Cost Table 10. Summary of Program Improvement Cost Estimates Table 11. Proposed Storage Tank Capacities Table 12. Proposed CIP Planning and Construction ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A Table of Contents May 2010 iv City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report LIST OF FIGURES Figure 1. Modesto Service Figure 2. General Plan Service Figure 3. Modesto Service Areas and Location of Groundwater Figure 4. Comparison of Supply and Demand (Wet and Normal Conditions): North Modesto Figure 5. Comparison of Supply and Demand (Multiple Year Drought): North Modesto...........41 Figure 6. Comparison of Supply and Demand (Wet and Normal Conditions): South Modesto Figure 7. Comparison of Supply and Demand (Multiple Year Drought): South Modesto Figure 8. Comparison of Supply and Demand (Wet and Normal Conditions) with South Figure 9. Comparison of Supply and Demand (Multiple Year Drought) with South Modesto Figure 10. Existing Contiguous Service Area Recommended Figure 11. Existing Contiguous Service Area for the Peak Hour Demand Condition Pressures Figure 12. Recommended Buildout Contiguous Service Area System Figure 13. Timing of Major Water Supply and Distribution Facilities Figure 14. Total Annual Figure 15. Cumulative Capital Cost Flow ---PAGE BREAK--- May 2010 1 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 2010 WATER SYSTEM ENGINEER’S REPORT OPTION A (BASED ON PARTICIPATION IN A REGIONAL SURFACE WATER SUPPLY PROJECT USING TURLOCK IRRIGATION DISTRICT WATER) 1.0 INTRODUCTION The purpose of this Engineer’s Report (Report) is to develop a capital improvement program (CIP), which will describe and justify the various improvements needed to provide and maintain reliable water service to existing and future customers, their associated budgetary level cost estimates, and their allocations between existing rate payers vs. future users of the City of Modesto’s (City) water system. This Option A evaluation assumes that a supplemental treated water supply would be received from a Regional Surface Water Supply Project using Turlock Irrigation District (TID) supplied raw water. The CIP addresses system deficiencies and replacement needs based on the hydraulic analyses performed for the contiguous and outlying service areas, as discussed in Appendices A through J. The CIP includes improvements that are needed to meet future buildout (approximately 2038) demands as detailed in Appendix E. In addition, the CIP incorporates projects identified in the City’s existing fiscal year 2009/2010 through 2037/2038 CIP (City’s CIP). The City is proposing to fund the described CIP using primarily water utility rates and capacity charges (connection fees). However, some of the larger improvements, such as regional facilities associated with the proposed involve outside cities and agencies and will include some level of bond financing. This Report presents the methodology used to determine the allocation of total costs and provides the basis for updating the City’s water service rate and capacity charges required for project funding. Subsequent sections of this Report include:  Summary of Results  Water Distribution System Background  Justification and Cost Allocation for Proposed Improvements  Project Schedule and Cost Projections 2.0 SUMMARY OF RESULTS The estimated total cost of the CIP for the water distribution system is $475.7M. The CIP includes improvements required to meet the existing and buildout demands by providing an additional water supply. Detailed information on individual project costs is provided in Section 4. All construction costs in this Report have been adjusted based on the March 2010 Engineer News Record (ENR) construction cost index of 9728.17 for San Francisco. The CIP costs include a total soft cost and contingency mark-up of 50 percent on the estimated ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 2 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report construction cost. The soft cost and contingency mark-up include: Construction Contingency (20 percent), Engineering (10 percent), Construction Management (10 percent), and Program Implementation (10 percent). A detailed discussion of construction costs plus soft cost and contingency mark-up is included in Attachment A. The City’s existing water supply consists of 53,500 af/yr1 of groundwater and 33,602 af/yr of surface water from the Modesto Irrigation District’s (MID) Modesto Regional Water Treatment Plant To meet the needs for additional water supply in North Modesto (the portion of the City’s contiguous service area north of the Tuolumne River), the City and MID are constructing the Phase Two Expansion Project to provide a total treated surface water supply up to 67,204 af/yr (by early 2010). To meet the needs for additional water supply in South Modesto (the portion of the City’s contiguous service area south of the Tuolumne River), this analysis (Option A) assumes the needed supply will be met by treated surface water from the proposed using TID water. Because of water rights issues concerning the place-of-use for water supplied by the TID for a and the fact that the South Modesto system operates somewhat independently from the North Modesto system, the TID supplied surface water will be contracted specifically for use in South Modesto. The City’s existing and future water supply and demands are discussed further in Section 3. As discussed previously, the CIP includes a combination of improvements identified as part of the existing and buildout system analyses performed by West Yost Associates (WYA) and improvements included in the City’s CIP. WYA compared the two CIP databases to confirm that any known redundant improvements were removed. The proposed improvements benefit existing and buildout customers by providing water service that meets safety and performance criteria discussed in the Existing System Evaluation TM (Appendix Buildout System Evaluation TM (Appendix and Outlying Service Area TM’s (Appendices F through These criteria include required storage volume, reliable pumping capacities, and minimum system pressures under different demand conditions. The cost allocation between existing rate payers and future users for each improvement is unique, based on a methodology developed for the specific type of improvement, as described for each project in Section 4. The CIP cost allocated to existing customers is $327.8.0M, or 69 percent of the total overall cost, and the cost allocated to future users is $147.9M, or 31 percent of the total overall cost. The estimated CIP costs and the recommended allocations between customers are summarized in Table 1. Table 2 provides additional details regarding each improvement category. Project summaries for each of the improvements recommended are presented in Section 4 of this Report. 1 This is the City’s current estimate of the preliminary operational yield of the groundwater basin. This preliminary operational yield does not represent the City’s available groundwater pumping capacity. ---PAGE BREAK--- Number Project Category Type(b) Cost, $ Existing / Future, Existing, $ Future, $ 1 Phase Two Expansion Major Project $0 41.9 / 58.1 $0 $0 2 City-Side Improvements related to Phase Two Expansion(d) Major Project $37,563,000 85.6 / 14.4 $32,154,000 $5,409,000 3 Major Project $49,000,000 74.4 / 25.6 $36,456,000 $12,544,000 3A Distribution Improvements: City-Side Improvements related to Major Project $5,600,000 74.4 / 25.6 $4,166,000 $1,434,000 4 Distribution Improvements: Water Quality Study Project $3,186,000 41.9 / 58.1 $1,335,000 $1,851,000 5 Distribution Improvements: Remove Water Tanks Project $0 100 / 0 $0 $0 6 Distribution Improvements: New Corporation Yard Project $8,600,000 64 / 36 $5,504,000 $3,096,000 7 Distribution Improvements: Existing Tank Improvements Program $3,075,000 100 / 0 $3,075,000 $0 8 Distribution Improvements: Extend Water Mains Program $54,745,000 0 / 100 $0 $54,745,000 9 Distribution Improvements: Strengthen and Replace Water System Program $102,565,000 100 / 0 $102,565,000 $0 10 Distribution Improvements: Install New Wells Program $24,431,000 42.3 / 57.7 $10,334,000 $14,097,000 11 Distribution Improvements: Wellhead Treatment Program $29,277,000 100 / 0 $29,277,000 $0 12 Distribution Improvements: Purchase and Install New Generators Program $10,000,000 60 / 40 $6,000,000 $4,000,000 13 Distribution Improvements: Water System Security Enhancements Program $3,176,000 100 / 0 $3,176,000 $0 14 Distribution Improvements: Groundwater Management Plan Program $3,836,000 41.9 / 58.1 $1,607,000 $2,229,000 15 Distribution Improvements: Urban Water Management Plan Program $1,019,000 16.6 / 83.4 $169,000 $850,000 16 Distribution Improvements: Water Master Plan Program $5,199,000 23.1 / 76.9 $1,199,000 $4,000,000 17 Distribution Improvements: Water System Evaluation Program $4,209,000 3.8 / 96.2 $159,000 $4,050,000 18 Distribution Improvements: New Water Tanks Program $47,600,000 16.8 / 83.2 $8,020,000 $39,580,000 19 Distribution Improvements: Water Meters Program $32,986,000 100 / 0 $32,986,000 $0 21 Distribution Improvements: New or Replacement Pumps Program $19,543,000 100 / 0 $19,543,000 $0 22 Soil Remediation Program $1,263,000 100 / 0 $1,263,000 $0 23 Distribution Improvements: Utility Cuts Program $28,844,000 100 / 0 $28,844,000 $0 $475,717,000 $327,832,000 $147,885,000 68.9% 31.1% Project category only includes City's share of total cost for It was assumed that City-Side Improvements related to Phase Two Expansion should be complete by 2013. Costs updated with information provided by City in City's 2009-2038 CIP spreadsheet. Cost allocations (existing and future) are presented in Section 4. Table 1. Summary of Water System Cost Categories Between Existing and Future Customers(a) Total Total Percent Allocation Project is an activity that will occur once and a Program is an activity that will occur periodically. Percentages shown are rounded to the nearest tenth. Water system costs presented in this table include costs from WYA TMs (Appendices D through and the City's 2009-2038 Capital Improvements Program (City's CIP) spreadsheet (see Attachment West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3ciptables Last Revised: 04/01/10 City of Modesto Engineer's Report Option A ---PAGE BREAK--- Recommendation(b) Existing Buildout Total Category 1: Phase Two Expansion Category 1 Subtotal $ - $ - $ - Category 2: City-Side Improvements related to Phase Two Expansion 6 MG North Tank and 18 mgd Booster Pump Station [W363] $ 11,143,000 $ - $ 11,143,000 4 MG West Tank and 12 mgd Booster Pump Station [W133] $ 100,000 $ - $ 100,000 4 MG Industrial Tank and 12 mgd Booster Pump Station [W003] $ 8,900,000 $ - $ 8,900,000 Virginia Corridor Transmission Main [W002] $ 4,656,000 $ 1,344,000 $ 6,000,000 Orangeburg Avenue Transmission Main [W078] $ - $ - $ - Lapham Drive to 7th & B Transmission Main [W099] $ 5,587,000 $ 1,613,000 $ 7,200,000 MID Turnout Control Valves [W361, W005] $ 1,768,000 $ 2,452,000 $ 4,220,000 Other City Identified CIP [W425] $ - $ - $ - Category 2 Subtotal $ 32,154,000 $ 5,409,000 $ 37,563,000 Category 3: Category 20 Subtotal $ 36,456,000 $ 12,544,000 $ 49,000,000 Category 3A: City-Side Improvements related to South Modesto Transmission Pipeline related to [W425] $ 4,166,000 $ 1,434,000 $ 5,600,000 Other City Identified CIP $ - $ - $ - Category 3 Subtotal $ 4,166,000 $ 1,434,000 $ 5,600,000 Category 4: Water Quality Study Category 4 Subtotal $ 1,335,000 $ 1,851,000 $ 3,186,000 Category 5: Remove Water Tanks Category 5 Subtotal $ - $ - $ - Category 6: New Corporation Yard Category 6 Subtotal $ 5,504,000 $ 3,096,000 $ 8,600,000 Category 7: Existing Tank Improvements Category 7 Subtotal $ 3,075,000 $ - $ 3,075,000 Category 8: Extend Water Mains Existing System Transmission Grid Pipeline Recommendations $ - $ - $ - Buildout System Transmission Grid Pipeline Recommendations $ - $ 51,255,000 $ 51,255,000 Del Rio Outlying Service Area Pipeline Improvements $ - $ 2,805,000 $ 2,805,000 Other City Identified CIP [See Attachment D] $ - $ 685,000 $ 685,000 Category 8 Subtotal $ - $ 54,745,000 $ 54,745,000 Category 9: Strengthen and Replace Water System Existing System Peak Hour and Max Day plus Fire Recommendations $ 32,308,500 $ - $ 32,308,500 South Modesto Interim Supply Study System Improvements $ 14,088,000 $ - $ 14,088,000 Del Rio Outlying Service Area Pipeline Improvements $ 763,500 $ - $ 763,500 Grayson Outlying Service Area Pipeline Improvements $ 693,000 $ - $ 693,000 Hickman Outlying Service Area Pipeline Improvements $ 1,628,100 $ - $ 1,628,100 Turlock Outlying Service Area Pipeline Improvements and Interconnection $ 1,834,500 $ - $ 1,834,500 Waterford Outlying Service Area Pipeline Improvements $ 2,548,500 $ - $ 2,548,500 Other City Identified CIP $ 48,700,900 $ - $ 48,700,900 Category 9 Subtotal $ 102,565,000 $ - $ 102,565,000 Category 10: Install New Wells Well 63 – Mildred Perkins Well [W729] $ 521,000 $ 711,000 $ 1,232,000 Well 271 - Replacement Well $ 1,800,000 $ - $ 1,800,000 Buildout Well # 1 w/ 1,500 gpm capacity $ - $ 2,000,000 $ 2,000,000 Del Rio Well w/ 1,000 gpm capacity $ 1,000,000 $ 1,000,000 $ 2,000,000 Grayson Well w/ 400 gpm capacity $ 2,000,000 $ - $ 2,000,000 Hickman Well w/ 600 gpm capacity $ 2,000,000 $ - $ 2,000,000 Waterford Well w/ 800 gpm capacity $ - $ 2,000,000 $ 2,000,000 Other City Identified CIP $ 3,013,000 $ 8,386,000 $ 11,399,000 Category 10 Subtotal $ 10,334,000 $ 14,097,000 $ 24,431,000 Category 11: Wellhead Treatment Well 255 Rehabilitation $ 826,500 $ - $ 826,500 Other City Identified CIP $ 28,450,500 $ - $ 28,450,500 Category 11 Subtotal $ 29,277,000 $ - $ 29,277,000 Category 12: Purchase and Install New Generators Existing Contiguous Service Area System $ 3,200,000 $ - $ 3,200,000 Buildout Contiguous Service Area System $ - $ 4,000,000 $ 4,000,000 Grayson Outlying Service Area $ 400,000 $ - $ 400,000 Hickman Outlying Service Area $ 200,000 $ - $ 200,000 Turlock Outlying Service Area $ 800,000 $ - $ 800,000 Waterford Outlying Service Area $ 800,000 $ - $ 800,000 Other City Identified CIP $ 600,000 $ - $ 600,000 Category 12 Subtotal $ 6,000,000 $ 4,000,000 $ 10,000,000 Category 13: Water System Security Enhancements Category 13 Subtotal $ 3,176,000 $ - $ 3,176,000 Category 14: Groundwater Management Plan Category 14 Subtotal $ 1,607,000 $ 2,229,000 $ 3,836,000 Category 15: Urban Water Management Plan Category 15 Subtotal $ 169,000 $ 850,000 $ 1,019,000 Category 16: Water Master Plan Category 16 Subtotal $ 1,199,000 $ 4,000,000 $ 5,199,000 Category 17: Water System Evaluation Category 17 Subtotal $ 159,000 $ 4,050,000 $ 4,209,000 Category 18: New Water Tanks 0.23 MG Del Rio Tank with 2.0 mgd Booster Pump Station [W377] $ 1,620,000 $ 1,180,000 $ 2,800,000 0.40 MG Hickman Tank with 74 bhp Booster Pump Station [W377] $ 2,800,000 $ - $ 2,800,000 0.66 MG Waterford Tank with 2.0 mgd Booster Pump Station [W377] $ 3,600,000 $ - $ 3,600,000 5.0 MG Modesto Tank and Booster PS located North of Existing Modesto Terminal Tanks [W377] $ - $ 13,200,000 $ 13,200,000 10 MG South Modesto Terminal Tank and 11.5 mgd Booster Pump Station [W377] $ - $ 25,200,000 $ 25,200,000 Other City Identified CIP $ - $ - $ - Category 18 Subtotal $ 8,020,000 $ 39,580,000 $ 47,600,000 Category 19: Water Meters Category 19 Subtotal $ 32,986,000 $ - $ 32,986,000 Category 21: New or Replacement Pumps Category 21 Subtotal $ 19,543,000 $ - $ 19,543,000 Category 22: Soil Remediation Category 22 Subtotal $ 1,263,000 $ - $ 1,263,000 Category 23: Utility Cuts Category 23 Subtotal $ 28,844,000 $ - $ 28,844,000 Total CIP Cost Estimate $ 327,832,000 $ 147,885,000 $ 475,717,000 Table 2. Summary of CIP Recommendation Cost Estimates(a) = City's 2009-2038 CIP spreadsheet Identification Number. Included with recommendations when available. Costs presented are compiled from the system analysis (see Appendices D through J and Attachment and the City’s 2009-2038 CIP spreadsheet (Attachment Costs identified in the system analysis have been incorporated into the City’s CIP spreadsheet. West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3ciptables Last Revised: 04/01/10 City of Modesto Engineer's Report Option A ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 5 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 3.0 WATER DISTRIBUTION SYSTEM BACKGROUND The characteristics of the City’s water distribution system are described in the following three sections:  Service Area  Current and Projected Water Demands  Water Supply 3.1 Service Area The City’s service area consists of one large “contiguous” service area and several “outlying” non-contiguous service areas. The City’s contiguous service area is primarily defined by the current sphere of influence (SOI), Salida, North Ceres and some unincorporated Stanislaus County “islands” within or adjacent to the SOI (Empire is within the SOI). The outlying service areas include Grayson, Hickman, Del Rio, Waterford, Ceres (Walnut Manor), and portions of Turlock. Figure 1 illustrates the location of the City’s contiguous and outlying service areas. The Riverdale Park Tract (approximately 40 acres located in the southwest portion of the contiguous service area) is physically connected to the City’s water system to provide Riverdale with an emergency backup supply, and has only been used when the single well in the Riverdale area was inoperable or could not meet pressure requirements. A records check of the City’s billing data over the last two years indicates the water consumption from this area is negligible; therefore, the existing demands from the Riverdale area have not been included in this analysis. The City’s adopted 1995 Urban Area General Plan (General Plan), with various amendments, includes additional development north and west of the defined contiguous service area, as shown on Figure 2. However, for planning purposes, the City has limited this Report to the service areas shown on Figure 1. The system wide buildout is projected to occur by 2038. However, political, environmental, or economical factors may change the actual year of buildout. 3.2 Current and Projected Water Demands In 2002, the City retained WYA to develop hydraulic models of the City’s contiguous and outlying water systems. These models were updated in 2005, 2007 and 2009 (for this Report) to reflect new facilities and improvements within the systems. Current and projected water demands were developed for the hydraulic models in order to serve as a basis for evaluating the City’s existing and future water supply and infrastructure needs. The City’s existing and projected hydraulic model demands and required system improvements were developed using 2000 to 2009 metered consumption and production data, City of Modesto General Plan land use information, and acreage information provided by the City. For projecting future water demands, a baseline Average Day demand is required. As discussed in the Demand TM (Appendix there is no precise way to measure customer water use due to unaccounted for water and the City’s current billing procedure of having some residential flat-fee accounts, except to select and set a baseline demand equal to a production quantity at some specific point in time. Therefore, throughout this Report, by definition, the system wide baseline ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 6 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report demand (“demand”) includes both customer water use (the amount actually measured and billed) and unaccounted for water (unmeasured system losses). For this analysis, the Average Day production of 2006 was set as the baseline demand from which future demand distributions were built. Since the existing baseline demand is established as equal to production, it is assumed that future projections of water demands would also equal production. A summary of the 2006 and projected buildout (2038) demands for the contiguous and outlying service areas is provided in Table 3. The system wide Maximum Day peaking factor and Peak Hour peaking factor developed in the Demand TM (Appendix B) are 1.75 and 2.46, respectively. System wide 2006 Maximum Day demands are 131.4 million gallons per day (mgd), and Peak Hour demands are 173.0 mgd. At buildout, Maximum Day demands are projected to increase to 182.4 mgd, and Peak Hour demands are expected to increase to 259.1 mgd. Table 3. Existing and Projected Buildout Demands 2006 Demands(a) Projected Buildout (2038) Demands(b) Service Area AD, mgd MD, mgd PH, mgd AD, mgd MD, mgd PH, mgd Contiguous(c) 67.1 98.2 171.9 241.6 Outlying(d,e) 3.2 131.4 173.0 5.4 10.6 17.5 Total 70.3 131.4 173.0 103.6 182.4 259.1 Data obtained from Tables 5 and 6, and Peak Hour production section of the Demand TM (Appendix Data obtained from Table 13 of the Demand TM (Appendix Contiguous service area includes current SOI, Salida, North Ceres and some unincorporated Stanislaus County “islands” within or adjacent to the SOI (Empire is within the SOI) as shown on Figure 1. Outlying service areas include Grayson, Hickman, Del Rio, Waterford, Ceres (Walnut Manor), and portions of Turlock. The projected Maximum Day and Peak Hour demands for the outlying service areas were calculated using individual peaking factors that were developed for each outlying service area (Appendices F through AD = Average Day Demand MD = Maximum Day Demand PH = Peak Hour Demand The projected demands shown in Table 3 reflect water use characteristics that account for long-term water conservation strategies implemented since 1990 and for specific Stage 1 conservation measures that have been in effect since March of 2003.2 These conservation measures include, but are not limited to: installing meters at water connections, limiting or eliminating landscape watering on Mondays, and public information programs for residents and institutions. Increased water conservation would most likely lower the unit water use factors and unaccounted for water. Similarly, future water consumption may also vary depending on various factors including, but not limited to, increased metering, public awareness for water conservation, economic conditions, weather patterns, and types of development. For the purposes 2 These conservation measures are discussed in more detail in the City’s 2005 Urban Water Master Plan (2005 UWMP). ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 7 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report of water supply planning, no additional conservation savings are incorporated into the projections. The overall water use, including all customer classes (i.e. commercial, industrial, and residential), is estimated to be 227 gallons per capita per day. This calculation is based on actual 2005 water production minus 15 percent unaccounted for water and the estimated 2005 population within the City’s service area of 264,209 (2005 UWMP). 3.3 Water Supply The City has two existing water supply sources: local groundwater and treated surface water purchased from MID. The combination of these water supply sources allow the City to employ a conjunctive use operational strategy that is described further in this section and also in the 2005 UWMP. This section includes a discussion of the following topics:  Groundwater Supply  Surface Water Supply  Supply Analysis 3.3.1 Groundwater Supply The City’s service area is located within the San Joaquin Valley Groundwater Basin (SJV Basin) and serves the contiguous and outlying service areas. The groundwater supply is pumped from the following three subbasins within the SJV Basin:  Modesto Subbasin  Turlock Subbasin  Delta-Mendota Subbasin The City’s contiguous service area and some outlying service areas span both the Modesto and Turlock Subbasins. North Modesto, Salida, Empire, Del Rio, and Waterford are located in the Modesto Subbasin. South Modesto, Turlock, North Ceres, Ceres (Walnut Manor), and Hickman are located in the Turlock Subbasin. Grayson is located in the Delta-Mendota Subbasin. Figure 3 illustrates the location of the City’s service area in relation to the boundaries of these three subbasins. The City developed a preliminary operational yield of 53,500 af/yr for the three groundwater subbasins (underlying the City’s service area), as discussed in the 2005 UWMP and the Supply vs. Demand TM (Appendix The preliminary operational yield is used to assess groundwater reliability for planning level type analyses such as this Report. This preliminary operational yield is based on historical groundwater pumpage by the City from the Modesto, Turlock, and Delta-Mendota Subbasins, and was developed by the City to maintain a minimum average groundwater elevation of 40 feet above mean sea level (ft msl). ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 8 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report The general conclusion from the City’s analysis is that if the total, long-term average groundwater pumpage quantity is held at or below 53,500 af/yr,3 then stable groundwater levels will result, at approximately 40 ft msl within and near the City’s contiguous service area. If groundwater pumpage is significantly less than 53,500 af/yr, groundwater levels will probably rise, thereby increasing the quantity of available groundwater stored within the basin for later use via “in-lieu” groundwater banking. Alternatively, if more than 53,500 af/yr is extracted during dry years), groundwater levels will probably decline. The preliminary operational yield is a long-term average. Therefore, this yield was assumed available to the City during all hydrologic conditions (dry, normal, and wet years). However, actual groundwater extractions may be lower in wet years and higher in dry years. Consequently, for the purpose of supply analysis, the preliminary groundwater operational yield available to the City between 2006 and 2038 was assumed equal to the long-term average, or 53,500 af/yr. 3.3.2 Surface Water Supply The City purchases treated surface water from the MID during all hydrologic conditions (dry, normal, and wet years); however, specific reductions have previously been agreed upon between the City and MID during dry years that meet certain criteria similar to the 1991 hydrologic conditions. The MID has historic surface water rights on the Tuolumne River, which allow the District to deliver some of its raw water to the The became operational in 1995 and provides the City with an annual average supply of 30 mgd (33,602 af/yr), with a functional peaking capacity of 42.5 mgd that helps meet the Maximum Day and Peak Hour demands of North Modesto (the Plant is permitted by the State to produce up to 45 mgd; however, other limitations at the currently prevent MID from producing this volume of supply). The planned Phase Two Expansion Project, currently under construction (completion expected by early 2010), will double the annual average capacity of the plant to 60 mgd (67,204 af/yr). The terminal reservoir facilities (booster pump station and tanks) and a portion of the transmission pipelines traversing the City are owned and operated by MID, and provide treated surface water to the City’s contiguous service area (north of the Tuolumne River) via an existing “Amended and Restated Water Treatment and Delivery Agreement between Modesto Irrigation District and the City of Modesto” (AR TDA), dated October 2005 (2005 UWMP). The AR TDA is the controlling document regarding delivery terms of MID’s treated surface water to the City; under the AR TDA, MID can reduce supply in dry years. The AR TDA also limits the use of MID surface water supplies to areas of the City located north of the Tuolumne River, along the southern boundary of MID’s service area. 3.3.3 Supply Analysis The conjunctive use operational strategy described above enables the City to extract more than the preliminary operational yield to meet supply deficits because it also banks and stores excess groundwater during normal or wetter hydrologic conditions. 3 Per discussion with City staff on 5/8/08. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 9 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Tables 4 and 5 summarize the existing water supplies available to the City during normal or wetter hydrologic conditions and during a five-year drought, respectively. The existing surface water supply shown in Table 4 is based on the available supply from MID before and after the Phase Two Expansion Project. Table 4. Total Existing Water Supplies During Normal or Wetter Hydrologic Conditions, af/yr Supply 2006 2010 2015 2020 2025 (Buildout) 2038 Groundwater(a) 53,500 53,500 53,500 53,500 53,500 53,500 Surface Water(b) 33,602 67,204 67,204 67,204 67,204 67,204 Total 87,102 120,704 120,704 120,704 120,704 120,704 Preliminary operational yield provided by the City. Includes all groundwater from contiguous and outlying service areas. Based on the AR TDA, in which 33,602 af/yr is supplied from the original and 67,204 af/yr is supplied after the Phase Two Expansion Project. The surface water values shown in Table 5 are based on annual reductions to the normal surface water supply of 67,204 af/yr, based on the 2005 UWMP. The annual reductions are applied over a 5-year drought interval and would be 4.3 percent, 8.6 percent, 12.9 percent, 17.1 percent, and 21.4 percent, respectively, for each of the 5 years. Table 5. Total Existing Water Supplies During a 5-Year Drought at and near Buildout, af/yr Supply Year 1 (2034) Year 2 (2035) Year 3 (2036) Year 4 (2037) Year 5 (2038) Groundwater(a) 53,500 53,500 53,500 53,500 53,500 Surface Water(b) 64,324 61,444 58,563 55,683 52,803 Total 117,824 114,944 112,063 109,183 106,303 Preliminary operational yield provided by the City. Includes all groundwater from contiguous and outlying service areas. Dry year surface water reductions obtained from the 2005 UWMP. Assumes the Phase Two Expansion Project is operational. Water supply and demands are compared for three areas: the outlying service areas, portions of the contiguous service area north of the Tuolumne River (North Modesto), and portions of the contiguous service area south of the Tuolumne River (South Modesto). The outlying service areas use groundwater supply only, and therefore have priority use of the groundwater supplies from their respective subbasins. Consequently, the outlying service areas have sufficient water supply during all hydrologic conditions (wet, normal, drought), as discussed in the Supply vs. Demand TM (Appendix up to their projected demands at buildout. Table 6 presents the portion of the preliminary operational yield used by each outlying service area and the remaining groundwater available for the contiguous service area. ---PAGE BREAK--- Subbasin Outlying Service Area 2006(e) 2010 2015 2020 2025 2030 2038(f) Del Rio Demand 694 841 1,026 1,210 1,395 1,579 1,874 Waterford Demand 2,111 2,224 2,366 2,508 2,649 2,791 3,018 Subtotal 2,805 3,065 3,392 3,718 4,044 4,370 4,892 Preliminary Operational Yield 48,286 48,286 48,286 48,286 48,286 48,286 48,286 Remaining Groundwater Yield 45,481 45,221 44,894 44,568 44,242 43,916 43,394 Hickman Demand 194 228 270 312 354 396 464 Turlock Demand 353 353 353 353 353 353 353 Ceres (Walnut Manor) Demand 29 29 29 29 29 29 29 Subtotal 576 610 652 694 736 778 846 Preliminary Operational Yield 4,900 4,900 4,900 4,900 4,900 4,900 4,900 Remaining Groundwater Yield 4,324 4,290 4,248 4,206 4,164 4,122 4,054 Grayson Demand 176 193 215 236 258 280 314 Preliminary Operational Yield 314 314 314 314 314 314 314 Remaining Groundwater Yield 138 121 99 78 56 34 0 49,804 49,510 49,141 48,773 48,405 48,037 47,448 Assumes normal or wetter hydrologic conditions. Preliminary operational yield allocated based on Table 2. Modesto Turlock Delta-Mendota Table 6. Preliminary Operational Yield Allocated to Outlying Service Areas and Available to the Contiguous Service Area, af/yr(a,b) Based on Table 5, Appendix B (Demand TM). Demands in South Modesto based on demands allocated in the existing system model. Based on Table 13, Appendix B (Demand TM). Buildout demands in South Modesto were calculated based on land uses south of the Tuolumne River. This is the remaining groundwater available for the contiguous service area. It does not include groundwater from the Delta-Mendota Subbasin because there is not a physical connection between the water systems of Grayson and the contiguous service area. Total Preliminary Operational Yield for Contiguous Service Area Projected demands in 2010, 2015, 2020, 2025, and 2030 were linearly interpolated using 2006 and projected buildout (2038) demands, and subsequently reduced by 10 percent to account for the expected reduction in water use as a result of the City's ongoing residential meter installation program. West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091031ceC2 Last Revised: 10/08/2009 City of Modesto Engineer's Report Option A ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 11 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report North Modesto also has sufficient groundwater and surface water supply during normal or wetter hydrologic conditions, as discussed in the Supply vs. Demand TM (Appendix C) and shown on Figure 4. Surplus groundwater is also available during normal or wetter hydrologic conditions. However, during a 5-year drought scenario (buildout was assumed to occur at Year additional groundwater extraction beyond the preliminary operational yield (from either existing or new wells) is required during the last year of the drought to meet demands for North Modesto, as shown on Figure 5. The AR TDA does not allow the City to use MID surface water supplies to meet demands in South Modesto; consequently, the only existing water supply source for South Modesto is groundwater from the Turlock and Modesto Subbasins. Figure 6 shows that South Modesto has sufficient water supplies through buildout (2038) during normal or wetter hydrologic conditions, assuming that surplus groundwater from the Modesto Subbasin can be conveyed and used in South Modesto. During a 5-year drought scenario (buildout was assumed to occur at Year an additional water supply is required during the last three years of the drought to meet demands for South Modesto, as shown on Figure 7. The preferred supply option assumes that during certain periods, the City can extract more than the preliminary operational yield to meet supply deficits because it banks and stores excess groundwater during normal or wetter hydrologic conditions. However, this preferred supply option is highly dependent upon the preliminary operational yield estimate of 53,500 af/yr. Since further studies to verify and refine the preliminary operational yield have not been completed, the following potential supply options were briefly reviewed in the Supply vs. Demand TM (Appendix  More Refined Operational Yield Estimate,  Regional Surface Water Supply Project with the Turlock Irrigation District (TID),  Phase Three Expansion Project,  Development of Recycled Water Options,  Additional In-Lieu Groundwater Banking and Aquifer Storage Recovery (ASR),  Conversion to Metered-Based Billing, and  Additional Water Conservation and Revised Water Shortage Contingency Plan. The decision to participate or further investigate other potential supply options should not be based solely on this planning level analysis. The City may have compelling reasons or unique opportunities to pursue one or more of the potential supply options, and additional transmission and distribution system constraints may also influence or justify the participation in the other potential supply options. While all of the bulleted items above would have a positive effect on the supply issue to some degree, the most influential (and that covered in this analysis - Option A) is based on the City’s full participation in the proposed as an additional supply source for customers in south Modesto. CIP costs were not developed for the options above and ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 12 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report are not discussed further in this Report, except for the and associated City-Side Improvements needed to receive that water supply. Figures 8 and 9 show that with the City receiving treated surface water from the proposed South Modesto would have a sufficient water supply through buildout; during both normal and wetter hydrologic conditions and during a 5-year drought scenario, respectively. 4.0 JUSTIFICATION AND COST ALLOCATION FOR PROPOSED IMPROVEMENTS The following recommended improvements are necessary to satisfy the projected demands described in the previous section and maintain quality service to existing and future customers. The CIP that has been developed in this Report (Attachment D) is a compilation of the City’s annual CIP (projected to buildout expected in 2038) and recommendations identified in Appendices D through J of this Report. This CIP has been developed to identify and prioritize the needed improvements, and to provide associated cost estimates. These CIP recommendations only identify improvements at a master plan level and do not constitute a design of such improvements. Subsequent detailed design is required to determine the exact sizes, locations, and costs of the proposed improvements. Each recommended improvement identified as part of the existing or buildout system evaluation was grouped into one of the 23 CIP categories based on the nature of the recommendation. For example, a recommendation to construct a larger diameter pipeline for the buildout system will be considered an improvement that would be classified as Extend Water Mains (Category In addition, the City has water system projects that have been identified and are included in the City’s CIP and separated into primary and secondary groupings. Primary level CIPs provide an overall program description and funding umbrella for the related secondary projects. Secondary level CIPs identify the specific stand-alone projects related to the Primary CIP that have been separated out because, in most cases, these projects are expected to begin in the near-term. Costs for both primary and secondary level CIPs have been provided by the City and are incorporated into the Report as Attachment D. The cost allocation for the 23 CIP categories identified in Table 1 and 2 are grouped into the following three improvement types based on improvement frequency:  Major Project Improvements: These projects will occur once and are associated with large joint ventures with other agencies or cities City-Side Improvements related to the  Project Improvements: These projects will occur once or very infrequently construction of a Corporation Yard).  Program Improvements: These program related projects will occur more periodically and over time updating the Water Master Plan). Table 7 provides a summary of the total cost estimates (at buildout) as separated by improvement type. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 13 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Table 7. Summary of CIP Cost Estimates by Improvement Type Improvement Type Cost, $M(a) Major Project Improvements 92.2 Project Improvements 12.0 Program Improvements 371.5 Total 475.7 Costs based on the San Francisco March 2010 dollars (ENR Construction Index = 9728.17). This section will also describe the methodology used to allocate a percentage of the total cost between existing and future customers for each of the 23 proposed CIP categories. Since the recommended projects will benefit existing and future customers, the total cost of each these improvements is split between these two categories, as shown on Table 1 and 2. Existing costs include improvements necessary for reliable water quality and system performance for existing customers. Buildout costs include all improvements that are necessary for customers after fiscal year 2009/2010 and within the buildout planning horizon, currently estimated as 2038. The buildout costs represent the future users’ share of all the proposed improvements. The split between existing and future customers is clearly defined in most of the CIP categories based on the hydraulic evaluations or description of the improvements. As shown in the Buildout Evaluation TM (Appendix the existing and buildout contiguous service area demands are 67.1 mgd and 98.2 mgd, respectively. It is also anticipated that existing residential customers will reduce water use by 10 percent (4.3 mgd) due to conversion of existing residential customers to metered use. Existing customers will use 64.0 percent of total flow, and future customers will provide a 35.4 mgd demand increase (98.2 mgd – (67.1 mgd - 4.2 mgd) = 35.4 mgd) to the system and use 36.0 percent of total flow. The justification and cost allocation methodology for each individual project or program classified by improvement type are described in the subsections below. 4.1 Major Project Improvements Major Project Improvements are joint ventures between the City and other agencies or cities and are generally one-time projects. Funding for these projects can be supplied by external sources or the City. There are four Major Project Improvements, as listed below:  Phase Two Expansion Expansion)  City-Side Improvements related to the Phase Two Expansion  Regional Surface Water Supply Project with the Turlock Irrigation District (TID)  City-Side Improvements related to the ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 14 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Costs have been allocated to existing and future customers for each of the major project improvements and are summarized in Table 8. Table 8. Summary of Major Project Improvement Cost Estimates Cost, $M Project Category Existing Customers Future Customers Total Phase Two Expansion (Category 1) - - - City-Side Improvements Related to Phase Two Expansion (Category 2) 32.15 5.41 37.56 (Category 3) 36.46 12.54 49.00 City-Side Improvements Related to the (Category 3A) 4.17 1.43 5.60 Total Major Project Improvement Costs 72.78 19.38 92.16 Provided by City staff from the latest cost estimate provided by TID (February 2009) and only represents the City of Modesto’s share (approximate total cost of the is $182.5 The justification and cost allocation for each Major Project Improvement is provided in the following subsections. References in parentheses designate the Category Number of the project as listed in Table 1 and 2. 4.1.1 Phase Two Expansion (Category 1) Description: This project will expand MID’s capacity from an annual average of 30 mgd to 60 mgd. The was originally planned for an annual average capacity of 60 mgd, to be constructed in two phases. The original phase of the water treatment plant has an annual average capacity of 30 mgd, (with a functional peaking capacity of 42.5 mgd that helps meet the Maximum Day and Peak Hour demands of North Modesto), and includes the MID owned transmission mains, terminal reservoirs, turnouts, and associated booster pump station, which were all completed in 1995. It is anticipated that the second phase of the treatment plant will be operational by early 2010 and utilize membrane filtration treatment technology. The second phase will be constructed within the existing footprint of the and MID will continue to own and operate the facility. The second phase will also provide an annual average supply of 30 mgd, for a total treatment plant capacity of 60 mgd. This project is substantially complete, and has no budgeted expenditures in the current CIP. Justification: As shown on Table 3, the City has a projected Average Day buildout demand of 98.2 mgd for the contiguous service area. However, since MID source supplies are limited to serving the North Modesto service area per the AR TDA, the supplies provided by the Expansion must also be limited to projected demands for the North Modesto service area. The projected Average Day buildout demand of South Modesto is 9.8 mgd, based on system demands allocated using projected land use as discussed in the Buildout System Evaluation TM ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 15 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report (Appendix Therefore, the projected Average Day buildout system demand in the North Modesto service area is 88.8 mgd (98.2 mgd – 9.4 mgd = 88.8 mgd).4 To meet these buildout demands in North Modesto, the City has two available sources: groundwater and MID supplied surface water. The City’s reliable groundwater production available to North Modesto is limited to 38.7 mgd (43,394 af/yr, Table as discussed in the Supply vs. Demand TM (Appendix and the 60 mgd from the (which includes the Phase Two Expansion), for a total supply of 98.7 mgd to meet the 88.8 mgd demand. In addition to serving buildout demands for North Modesto, this new supply from the Expansion will help the City replace reliable groundwater production capacity that has been lost due to water quality concerns. The City’s August 2009 Wells Out of Service Report in Attachment B describes wells that have been removed from service due to water quality issues. Cost Allocation: Although there are no costs in the current CIP for this project, the cost methodology developed for the Phase Two Expansion is presented here, since this same methodology is used for some project elements of the City-Side Improvements related to the Phase Two Expansion (Category Because the expansion is required to address both current and future water supply needs, the total cost of the Expansion should be shared by existing and future customers. As an existing system improvement, the Expansion would help replace the supplies that are taken out of service due to water quality concerns. Based on the out of service wells identified in Attachment B, these supplies account for 20.9 percent of the existing available groundwater supply in the North Modesto service area [19,800 gpm /94,753 gpm = 20.9 percent, Table 1 of Facilities Inventory TM (Appendix With an existing Average Day demand of 60.1 mgd for North Modesto only (67.1 mgd – 7.0 mgd), as detailed in Table 1 of Buildout System Evaluation TM (Appendix the supply amount that the Expansion would help replace is approximately 12.6 mgd (20.9 percent of 60.1 mgd). Hence, the total allocation of costs to existing customers is 41.9 percent (12.6 mgd divided by 30 mgd, the Average Day functional peaking capacity of the Expansion). Funding for the remainder of the expansion costs (58.1 percent) will be allocated to future customers. Total Cost: $0 Allocation to Existing Customers: $0 / 41.9% Allocation to Future Customers: $0 / 58.1% 4.1.2 City-Side Improvements related to Expansion (Category 2) Description: This project is to provide funding for the design, construction, and rights-of-way acquisition for the Tier 1 and most of the Tier 2 City-side improvements necessary to accommodate the increased production capacity of the Phase Two Expansion. Projects include: the West, North, and Industrial Tanks; their associated booster pump stations; transmission and distribution pipelines; flow/pressure regulating valves, and other related facilities. 4 Refer to the Buildout System Evaluation TM (Appendix E) for discussion on buildout demands. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 16 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Justification: An analysis conducted for MID in 1991 evaluated and recommended that two storage tanks and two booster pump stations be constructed for the City’s contiguous service area as part of “Stage II,” which was initially planned to be completed by 2005 (from Modesto Domestic Water Project Transmission Facility Pre-Design Hydraulic Analysis and Report completed by B&V in 1991). These proposed facilities have not been constructed, and are still required to further integrate the MID transmission mains with the City’s distribution system. WYA conducted an analysis that confirmed the continued need for the two tanks and booster pump stations originally identified in 1991. This analysis identified additional facilities required to fully integrate the delivery of MID treated surface water into the existing system and provide existing customers with a more reliable water system. These City-Side Improvements include a total of three storage tanks (including associated booster pump stations and connecting transmission lines), three major transmission pipelines, and up to 35 turnouts (connection points from the existing MID transmission system to the City’s distribution system) with various levels of control. Figure 10 illustrates the locations of the proposed tanks, booster pump stations, and transmission pipelines. As discussed further in the Existing System Evaluation TM (Appendix the City’s acceptable operational criterion for pressure is a minimum of 40 pounds per square inch (psi) during Maximum Day and Peak Hour demand conditions. The City’s existing system is experiencing low pressures (less than 40 psi) in scattered portions of its contiguous service area during a Peak Hour condition, as shown on Figure 11. System pressures will continue to decrease if more wells are taken out of service. The City-Side Improvements proposed will help correct low pressures currently observed during Peak Hour conditions. In addition, the increase in surface supply could serve as a replacement source for groundwater wells that might be taken out of service for water quality issues, thus increasing the amount of available reliable supply. Therefore, these facilities will provide acceptable operational performance compliance with acceptable system operational criteria) and supply reliability for existing customers within the City’s contiguous service area. In addition to alleviating existing system deficiencies to benefit existing customers, these City-Side Improvements will also help distribute additional treated surface water produced by the Phase Two Expansion project, and therefore benefit future customers. Cost Allocation: The cost allocation for existing and future customers for the City-Side Improvements related to the Phase Two Expansion project varies according to the type of facility, as described below. The total cost for all improvements is $37,563,000, as provided in the City’s CIP. The overall allocation for all improvements to existing and future customers is as follows: Total Cost: $37,563,000 Allocation to Existing Customers: $32,154,000 /85.6% Allocation to Future Customers: $5,409,000 / 14.4% 4.1.2.1 Transmission Pipeline Costs To be consistent with the cost allocation applied in the “Engineer’s Report - Justification and Cost Allocation for Proposed Water System Improvements” (WYA, 2004), costs were allocated between existing and future customers based on average flows through segments of the proposed ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 17 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report transmission main (using the City’s hydraulic model), proportionally weighted by the total length of the pipeline segment, under current and future Maximum Day demand conditions. Using this approach, 77.6 percent of cost is attributable to existing customers, and 22.4 percent to future customers. Based on a total cost of $13,200,000, the cost attributable to existing customers is therefore $10,243,000, and the cost to future customers is $2,957,000 (Table Total Cost: $13,200,000 Allocation to Existing Customers: $10,243,000 / 77.6% Allocation to Future Customers: $2,957,000 /22.4% 4.1.2.2 Storage Tank Costs The storage component of the City-Side Improvements serves existing customers within the City’s contiguous service area. Existing system storage is required to meet the following criteria:  Operational Storage: 25 percent of the Maximum Day demand.  Fire Flow Storage: The required fire flow times the duration period, as required by the City’s Fire Marshall. For further detail, see Existing System Evaluation TM (Appendix  Emergency Storage: Average Day demand for one day. As presented in the Existing System Evaluation TM (Appendix the existing water system has a storage deficiency of 37.4 million gallons without the addition of any new storage facilities. The proposed tanks are part of a system of improvements that will alleviate the existing system deficiency. Since the total storage added by these proposed tanks is less than the existing system’s storage deficiency, the total storage cost of $20,143,000 is allocated entirely to existing customers based on storage requirements identified in the existing system analysis, as shown in Table 2. Total Cost: $20,143,000 Allocation to Existing Customers: $20,143,000 /100.0% Allocation to Future Customers: $0 /0.0% 4.1.2.3 Motor Operated Control Valve Costs The City will use new motor operated control valves to control the flow of treated surface water from the Phase Two Expansion. Therefore, the costs for the valves are allocated based on the same methodology used for the Phase Two Expansion project. At a total cost of $4,220,000, the allocation is as follows: Total Cost: $4,220,000 Allocation to Existing Customers: $1,768,000 / 41.9% Allocation to Future Customers: $2,452,000/ 58.1% ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 18 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 4.1.2.4 Unclassified Costs The City’s current CIP includes no expenditures for Unclassified Costs in Category 2. 4.1.3 (Category 3) Description: This fund will cover the City's share of its participation (in conjunction with three other local Cities) in the development of a and its related transmission pipelines, that would supply surface water to those three other cities and the South Modesto area. This fund does not include annual operation and maintenance costs. The City’s participation in the would include the construction of regional facilities including what could be a 40.5 mgd surface water treatment plant (treatment plant capacity has not been finalized) and transmission pipelines for water conveyance to four cities considering participation: Modesto, Turlock, Ceres, and Hughson. According to the Final Environmental Impact Report, the plant was expected to begin delivering water between 2010 and 2011. However, based on the current schedule, this goal does not seem achievable. For purposes of this Report, it is assumed that a will be operational in 2013. Justification: The City is currently pursuing the option of participating in a (with TID supplied water) to provide an additional supply source for customers in South Modesto. Of the 14 available groundwater wells in South Modesto, in August 2009, five of the wells were out of service due to water quality concerns organics and uranium), as documented in the City’s Out of Service Well Report (Attachment It is expected that this decrease in reliable groundwater production capacity will at a minimum remain the same or will continue to decrease as other wells are taken out of service due to changes in regulations decreased MCL for arsenic). Adding TID supplied surface water to the City’s available supply sources would help alleviate this problem of decreased groundwater reliability in the South Modesto service area. Cost Allocation: The City’s cost for participating in the is $49,000,000. This cost includes participation in the treatment, pumping, and conveyance facilities necessary to deliver water from the to the City’s proposed turnout at the intersection of East Whitmore Avenue and Morgan Road. The recommended cost allocation for the is based on the ratio of existing South Modesto Maximum Day demand (12.2 mgd) to the projected buildout Maximum Day demand (16.4 mgd).5 The existing Maximum Day demand is 74.4 percent of the projected buildout Maximum Day demand. Therefore, 74.4 percent of the cost for these facilities is allocated to existing customers and 25.6 percent to future customers. Total Cost: $49,000,000 Allocation to Existing Customers: $36,456,000 / 74.4% Allocation to Future Customers: $12,544,000 / 25.6% 5 Maximum Day demands presented in the Buildout System Evaluation (Appendix ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 19 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 4.1.4 City-Side Improvements related to the (Category 3A) Description: This includes the design, construction, right-of-way acquisitions, etc. for the City- side improvements necessary to accommodate new surface water delivered from the proposed The City-Side Improvements include a 10.0 MG terminal storage tank, 11.5 mgd booster pump station (both shown in Category 18), and associated transmission and distribution pipelines with turnout locations to connect to the City’s distribution system. Storage associated with the City-Side improvements related to the is shown in Category 18. Justification: Similar to the need for City-Side Improvements related to the Phase Two Expansion to help convey the additional supply to the City’s distribution system; these Improvements are needed for the City to effectively use the additional surface water supply from the proposed to better meet peak demands, maintain sufficient service pressures, improve water quality, and offset wells out of service in the South Modesto service area. Since the South Modesto service area is not completely built out, these improvements would benefit both existing and future customers. Cost Allocation: The cost of the City-Side Transmission Improvements related to the of $5,600,000 is presented in Table C2 of Attachment C. This cost is allocated using the same methodology as for the in which 74.4 percent of the costs are allocated to existing customers and 25.6 percent of the costs are allocated to future customers. Total Cost: $5,600,000 Allocation to Existing Customers: $4,166,000 / 74.4% Allocation to Future Customers: $1,434,000 / 25.6% 4.2 Project Improvements Project improvements are one-time or infrequent projects that have been identified as necessary to improve or remedy issues related to the City’s water system. There are four Project Improvements, as listed below:  Water Quality Study  Remove Water Tanks  New Corporation Yard  Soil Remediation Costs have been allocated to existing and future customers for each of the projects and are summarized in Table 9. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 20 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Table 9. Summary of Project Improvement Cost Estimates Cost, $M Project Category Existing Customers Future Customers Total Water Quality Study (Category 4) 1.33 1.85 3.18 Remove Water Tanks (Category 5) 0.00 0.00 0.00 New Corporation Yard (Category 6) 5.50 3.10 8.60 Soil Remediation (Category 22) 0.26 0.00 0.26 Total 7.09 4.95 12.04 The justification and cost allocation for each Project Improvement is provided in the following subsections. References in parentheses designate the Category Number of the project as listed in Table 1 and 2. 4.2.1 Water Quality Study (Category 4) Description: This project will provide funding for a variety of system wide water quality studies and activities, including future wellhead treatment methods, groundwater blending, modifying well operations, screening off problematic water strata, installing monitoring wells, aquifer recharge and recovery wells, and actions to protect deterioration of the groundwater supply and quality. This study is needed to identify the most cost effective methods to manage the City's groundwater resources for meeting the City's water supply needs. Justification: The out of service wells identified in Attachment B indicates that the City had 24.5 percent of its wells out of service (representing 22.7 percent of the total available groundwater production capacity) due to water quality concerns (25 out of service / 102 total = 24.5 percent). Additionally, it is expected that more stringent regulations on groundwater quality in the future will result in decreased MCL allowances. These additional restrictions would require the City to shut down, replace, or provide wellhead treatment to more of its existing groundwater wells. This study is a first step in developing a plan to stabilize the City’s reliable groundwater supply and identify the most cost effective methods to manage existing groundwater resources. This study will focus on identifying projects wellhead treatment, blending, and aquifer storage and recovery) that will enhance groundwater production capacity and improve water quality, and will also help identify future well locations that may be required for future customers. The study should be coordinated with other existing City groundwater management plans and groundwater basin studies. Cost Allocation: The total cost of $3,186,000 is allocated to both existing and future customers. Costs attributed to existing customers are allocated based on the same proportionate share as the portion of the Phase Two Expansion required to replace lost groundwater pumping capacity; the water quality study will support activities needed to avoid replacing lost groundwater production capacity with new capacity. Therefore, the allocation to ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 21 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report existing customers is 41.9 percent ($1,335,000) and 58.1 percent to future customers ($1,851,000) Total Cost: $3,186,000 Allocation to Existing Customers: $1,335,000 / 41.9% Allocation to Future Customers: $1,851,000 / 58.1% 4.2.2 Remove Water Tank (Category 5) Description: Remove the existing, unused Water Tank Justification: Existing elevated storage Tank 1 has been out of service for a number of years and is not seismically stable. A study to evaluate the potential to seismically retrofit it concluded that a retrofit would not be economically feasible (City, 2004). Consequently, it was recommended that Tank 1 be demolished because of the safety risk it poses. Cost Allocation: The total cost for this work is since work has been completed. Since the removal of Tank 1 represents an existing system deficiency, existing customers are allocated 100 percent of the cost of this project. Total Cost: $0 Allocation to Existing Customers: $0 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.2.3 New Corporation Yard (Category 6) Description: This project will develop (e.g. planning, design, property acquisition, construction, etc.) a new Water Division Corporation Yard. Justification: The City has identified plans to construct a new corporation yard to replace the existing facility. Costs include property acquisition (approximately 8 acres), design and construction of a new building (approximately 10,000 sf), and site development (parking, landscaping, lighting, security measures, etc.). The site would also be used to store soil, concrete, and asphalt removed during construction of water projects for later reuse as part of the City’s recycling program. Property acquisition is planned in fiscal year 2010/2011, with design in 2011/2012, and construction in fiscal year 2012/2013. Cost Allocation: The total cost is $8,600,000. Though this project would replace the existing corporation yard, it will also benefit both existing and future customers as the City’s demands increase. Therefore, costs for this project are allocated to existing and future customers. It is assumed that the corporation yard would serve the total buildout system average day demand of 98.2 mgd at 100 percent. Based on an existing average day demand of 67.1 mgd, and an anticipated reduction in existing residential water use of 4.3 mgd due to conversion to metered use, existing customers are allocated a proportionate share of 64.0 percent [(67.1 mgd – 4.3 mgd)/98.2 mgd = 64.0 percent]. Future customers are responsible for the remaining 36.0 percent. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 22 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report The cost allocation for existing customers is $5,504,000 (64.0 percent) and future customers is $3,096,000 (36.0 percent). Total Cost: $8,600,000 Allocation to Existing Customers: $5,504,000 / 64.0% Allocation to Future Customers: $3,096,000 / 36.0% 4.2.4 Soil Remediation (Category 22) Description: During the construction of the Kansas-Needham Overcrossing, soil contamination was discovered immediately north of the bridge. This project will provide funding to monitor the hydrocarbon contamination and to develop a Corrective Action Plan to begin remediation of the contaminated soil. Justification: The project provides funding to monitor the hydrocarbon contamination and to develop a Corrective Action Plan and begin remediation of the contaminated soil. Cost Allocation: The total cost of this project is $263,000. Since the project is related to an existing system deficiency, the costs are allocated at 100 percent to existing customers. Total Cost: $263,000 Allocation to Existing Customers: $263,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3 Program Improvements Program improvements are long-term, sometimes periodic projects that have been identified as necessary to improve or remedy issues related to the City’s water system. There are sixteen Program Improvements, as listed below:  Existing Tank Improvements  Extend Water Mains Program  Strengthen and Replace Water System Program  Install New Wells Program  Wellhead Treatment Program  Purchase and Install New Generators Program  Water System Security Enhancements  Groundwater Management Plan  Urban Water Management Plan  Water Master Plan  Water System Evaluation  New Water Tanks ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 23 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report  Water Meters Program  New or Replacement Pumps  Soil Remediation Program  Utility Cuts Program Costs have been allocated to existing and future customers for each of the program improvements and are summarized in Table 10. Table 10. Summary of Program Improvement Cost Estimates Cost, $M Project Category Existing Customers Future Customers Total Existing Tank Improvements (Category 7) 3.08 - 3.08 Extend Water Mains Program (Category 8) - 54.74 54.74 Strengthen and Replace Water System Program (Category 9) 102.57 - 102.57 Install New Wells Program (Category 10) 10.33 14.10 24.43 Wellhead Treatment Program (Category 11) 29.27 - 29.27 Purchase and Install New Generators Program (Category 12) 6.00 4.00 10.00 Water System Security Enhancements (Category 13) 3.18 - 3.18 Groundwater Management Plan (Category 14) 1.61 2.23 3.84 Urban Water Management Plan (Category 15) 0.17 0.85 1.02 Water Master Plan (Category 16) 1.20 4.00 5.20 Water System Evaluation (Category 17) 0.16 4.05 4.21 New Water Tanks (Category 18) 8.02 39.58 47.60 Water Meters (Category 19) 32.99 - 32.99 New or Replacement Pumps (Category 21) 19.54 - 19.54 Soil Remediation (Category 22) 1.00 - 1.00 Utility Cuts Program (Category 23) 28.84 28.84 Total 247.96 123.55 371.51 The justification and cost allocation for each Program Improvement is provided in the following subsections. References in parentheses designate the Category Number of the program as listed in Table 1 and 2. 4.3.1 Existing Tank Improvements (Category 7) Description: This project provides funding for interior and exterior enhancements to the water storage tanks; improving water quality, system efficiency, and prolonging their useful life. The improvements are generally routine maintenance items tank inspections, re-coating, ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 24 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report sealing, replacement of existing appurtenances, etc.) as well as fall protection safety enhancements. Justification: The goal of this program is to maintain system integrity via tank improvements, which will help the City meet the required storage volume criteria established in hydraulic evaluations detailed in the Existing System Evaluation TM (Appendix Cost Allocation: This program is funded at $275,000 in FY 2009/10 and $200,000 in alternate years thereafter. It is assumed that this program would be required until the year 2038; therefore, using this assumption, the total cost of this program is $3,075,000. Although future customers might receive some benefit from the maintenance of these tanks, the tanks are existing facilities and these improvements are targeted to help maintain existing system performance. Therefore, 100 percent of the total cost for this category is allocated to existing customers. Total Cost: $3,075,000 Allocation to Existing Customers: $3,075,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.2 Extend Water Mains Program (Category 8) Description: This project extends water mains, on an as-needed basis, into developing areas to meet the demands of new growth. Typically, this includes the installation of 12" diameter and larger pipes, fire hydrants and valves, on a one-half mile grid. Projects to complete distribution pipeline "looping" are included to improve service reliability to new water service areas. These projects may be constructed by developers through reimbursement agreements or by the City. Justification: This program includes new or upsized water mains that are recommended as part of proposed near-term and long-term developments and buildout system recommendations, as well additional water mains identified in the CIP. This program creates a large diameter distribution grid in the contiguous service area by extending or looping existing water mains 12-inch diameter pipelines) to help maintain adequate system performance under the existing Maximum Day and Peak Hour demand conditions. The program adds about twenty eight miles of upsized pipelines to the distribution grid; these pipes will also enable the City to more efficiently integrate and distribute additional treated surface water from the upcoming Phase Two Expansion. Specific improvements are identified and detailed under the title, “Transmission Grid Improvement Pipeline Recommendations” and “Development Pipeline Recommendations” in Attachment C, Tables C2 and C3. Cost Allocation: The total program cost of $54,745,000 is based on recommendations made as part of the buildout analysis described in the Buildout System Evaluation TM (Appendix the Del Rio System Evaluation TM (Appendix and the City’s CIP. The City’s CIP projects have a total cost of $685,000; other projects identified through the buildout evaluation have a total cost of $54,060,000. The program is summarized in Table 1 and 2. This program is required to support future demands from future customers. Therefore, costs are allocated entirely to future users. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 25 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Total Cost: $54,745,000 Allocation to Existing Customers: $0 / 0.0% Allocation to Future Customers: $54,745,000 / 100.0% 4.3.3 Strengthen and Replace Water System Program (Category 9) Description: On an as-needed basis, this project replaces and upgrades deficient water mains throughout the water system service areas. The “looping” of system pipelines may also be included, so as to provide an increase in service reliability. This project includes funding for replacement of broken valves, blow-offs and other appurtenances. The City has implemented a valve-turning program that will find many existing valves are frozen and will need to be replaced. This project is also established to address various safety issues, including fall protection, as related to the installation and maintenance of water tanks, etc. Justification: This strengthen and replace water system program includes pipeline repair and replacement (R&R) projects, along with projects identified from the hydraulic model as part of the proposed existing and buildout system recommendations. Pipelines have a finite life expectancy, and eventually corrode and leak, or otherwise fail. Projects associated with improving system hydraulics were identified in the analyses conducted by WYA6, and include the following categories detailed in Attachment C: the “Transmission Grid Improvement,” “Peak Hour Improvement,” and “Maximum Day plus Fire Flow Pipeline Recommendations” part of Table C1; the “South Modesto Pipeline Improvements” part of Table C2; and the “Pipeline Improvement Recommendations” part of Table C3. These improvements are illustrated in Figures 10 (existing system) and 12 (buildout system).7 System needs are expected to change over time as pipelines are replaced, and additional knowledge is gained on the condition of the water system. The City should continue to update the list of rehabilitation projects that comprise this CIP category (and associated costs) as these changes are identified. Cost Allocation: The total cost of the program is $102,565,000. This cost includes the pipeline recommendations based on the existing and buildout evaluations, as listed in Tables C1 through C3 and other City CIP projects. This program is intended to maintain existing system performance by strengthening and replacing pipelines that have reached the end of their useful life; therefore, the program benefits existing customers, including, among other areas, the Bret Harte Neighborhood and the Downtown area. Though these improvements would eventually benefit future customers, it is assumed for this Report that only appropriate costs for future pipelines will be paid by future customers. 6 Refer to Appendices D through J for details on specific improvements and explanations included as part of this CIP category for existing and buildout water systems. 7 Only improvements related to South Modesto, shown on Figure 11, are included in this category. Other buildout related improvements are included in Category ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 26 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Total Cost: $102,565,000 Allocation to Existing Customers: $102,565,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.4 Install New Wells Program (Category 10) Description: This program is based on two components: first, the need to sometime abandon and replace an existing well due to poor production output, structural problems, or water quality issues, and second, the recommendations from the hydraulic evaluations detailed in Appendices D through J, and shown in Attachment C, Tables C1 through C3. The program will: replace wells previously taken out of service due to water quality concerns organics and uranium) and that are deemed unsuitable for rehabilitation; replace older, low producing wells that are reaching the end of their service life; add new wells to help alleviate low flow problems and/or maintain adequate system pressures for existing customers; and provide additional capacity to meet increasing demands for new growth. As discussed previously, 25 wells were designated as out of service in August 2009, reducing well production capacity by approximately 22.7 percent. Justification: Since one of the primary sources of supply is groundwater, these new wells will help maintain or increase the groundwater supply. This program will replace groundwater wells that have reached the end of their service life and/or add new wells to meet increasing water demands. The program is expected to produce approximately one new well every two years, mainly as new supply sources for the water system. It should be noted that historically, the City has replaced fewer wells than scheduled. Cost Allocation: The total cost for this program is $24,431,000. The costs are allocated to existing and future customers based on the required number of wells for the existing system and the projected required number of wells for the buildout system. Of the 13 wells identified, five are replacement of existing wells or are required for existing supply adequacy (Mildred Perkins, Grayson, Hickman, Well 226, and Well 271), one (Del Rio) is split between existing and future needs, and the remaining wells are needed for future growth. Therefore, 42.3 percent of the cost of this program (5.5/13) is allocated to existing customers and 57.7 percent to future customers. Total Cost: $24,431,000 Allocation to Existing Customers: $10,334,000 / 42.3% Allocation to Future Customers: $14,097,000 / 57.7% 4.3.5 Wellhead Treatment Program (Category 11) Description: This program provides funding for the design and construction of wellhead treatment or blending facilities for wells throughout the water service area that are currently off- line due to high contaminant levels or are at risk of exceeding mandated MCLs. This program also includes funding for site specific groundwater studies, pilot-plant projects, etc. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 27 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Justification: The program rehabilitates existing groundwater wells that the City has shut down because of water quality concerns organics and uranium), but are not candidates for replacement, as defined in the Install New Wells Program (Category 10). This program includes evaluating various wellhead treatments and available treatment alternatives that will bring key wells back into production. Bringing as many of these wells back on-line will help stabilize the City’s reliable groundwater production capacity. The program is expected to bring back on-line, on average, approximately one well every other year as an existing supply source to the water system. This program includes a new project to add wellhead treatment to a Turlock service area well as shown in Attachment C, Table C3. Cost Allocation: The total cost of the program is $29,277,000. Costs for this program only include wells in the existing system because it is not currently possible to predict which of the future wells will require treatment. Therefore, 100 percent of the costs are allocated to existing customers. Total Cost: $29,277,000 Allocation to Existing Customers: $29,277,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.6 Purchase and Install New Generators Program (Category 12) Description: This program provides funding to purchase and install generators for back-up power at various tank and well sites throughout the water system. Providing emergency power to these facilities during power interruptions or outages of the main grid is critical to maintaining water service throughout the system. Justification: This program installs back-up generators at City-owned booster pump stations for tanks and groundwater wells. As part of the City’s groundwater resources management strategy, a portion of the groundwater basin’s existing storage volume will be relied upon to provide storage for City supplies in lieu of constructing surface storage tanks. This strategy is discussed further in the Existing System Evaluation TM (Appendix In order for the City to exercise this strategy and meet established performance criteria during a power outage, key wells and booster pumps will require generators for back-up power that are funded by this program. Cost Allocation: The total cost for this category is $10,000,000, which includes costs listed in Tables C1 through C3, and Tanks 7 and 8 Purchase/Install Generators. The improvements identified in these two sources are associated with existing facilities; however, individual improvements are triggered by either existing customer demands or future customer demands, as described in Appendices D and E. Therefore, the costs are allocated based on whether the need for the back-up generator was a result of existing or buildout demands. Of the total 50 recommended generators, 30 are recommended for the existing system (Table C1, Table C3 and City CIP, Tanks 7 and 8 boosters) and the remaining generators are for future system needs. Using this methodology, existing customers are allocated $6,000,000 (60.0 percent) and future customers are allocated $4,000,000 (40.0 percent). Total Cost: $10,000,000 Allocation to Existing Customers: $6,000,000 / 60.0% Allocation to Future Customers: $4,000,000 /40.0% ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 28 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 4.3.7 Water System Security Enhancements (Category 13) Description: This project is established to design and implement the water system security improvements as identified in the March 2003 Water System Vulnerability Assessment (VA), as completed to comply with the Public Health Security and Bioterrorism Response Act of 2001. The study evaluated the security of the water distribution system and identified projects to increase security of the water distribution system. Justification: This program helps the City meet state and federal requirements and implement the recommendations presented in the 2003 Water System Vulnerability Assessment. Cost Allocation: The total cost of this program is $3,176,000 as detailed in the CIP. The purpose of this program is to install security enhancements at existing water facilities to comply with newly authorized regulations. Though future customers may benefit from these security enhancements, existing customers are allocated 100 percent of the category costs, since the improvements identified in the CIP are associated with existing system facilities. Total Cost: $3,176,000 Allocation to Existing Customers: $3,176,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.8 Groundwater Management Plan (Category 14) Description: This project will provide funding to develop programs that are identified through the integrated regional groundwater management plan (IRGMP) in the Modesto Groundwater Basin and the groundwater management plan (GWMP) in the Turlock Groundwater Basin. The two groundwater management plans were developed with respective jurisdictions that share a common groundwater basin. These programs are needed to effectively manage the groundwater basin as a safe and sustaining water supply. They include, but are not limited to groundwater quality monitoring, groundwater replenishment studies, and continued participation in regional groundwater related activities. A portion of these implementation programs may be funded through future grants. Grant application preparation is also included in the CIP. Periodic amendments to the plan may be necessary in addition to the five year updates mandated by the State. Justification: The IRGMP and GWMP identify goals and objectives needed to effectively manage the groundwater basin(s) as a safe and sustainable water supply. Work through this program will be coordinated with other jurisdictions to implement the IRGMP and GWMP, along with periodic amendments and updates as necessary. Participation in this program will also allow the City to become eligible for grants that can be used on various groundwater related projects recharge programs and ASR wells). In addition to maintaining a City groundwater management program, two groundwater management plans developed by different entities, Stanislaus and Tuolumne River Groundwater Basin Association and Turlock Groundwater Basin Association (TGBA), were included as part of this program’s costs. Cost Allocation: This program will benefit both existing and future customers, so the costs are allocated to existing and future customers. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 29 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Based on the information provided in the CIP, the total cost of this program is $3,836,000. For this CIP category, it is assumed that the costs would need to be continued to the year 2038. The groundwater management plan will also help activities associated with replacing lost groundwater production capacity. Therefore, costs attributed to existing customers are allocated based on the same proportionate share as the portion of the Phase Two Expansion required to replace lost groundwater pumping capacity. The allocation to existing customers is 41.9 percent ($1,607,000) and to future customers is 58.1 percent ($2,229,000). Total Cost: $3,836,000 Allocation to Existing Customers: $1,607,000 / 41.9% Allocation to Future Customers: $2,229,000 / 58.1% 4.3.9 Urban Water Management Plan (Category 15) Description: This will provide funding for implementation programs that are developed from the Urban Water Management Plan (UWMP). These programs will help ensure the reliability of the water supply including conservation programs, residential plumbing retrofit, recycled water implementation and water system audits. A portion of these implementation programs may be funded through future grants. Grant application preparation is also included in the CIP. Periodic amendments to the plan may be necessary in addition to the five year updates mandated by the State. Justification: In 1983, the California Legislature enacted the Urban Water Management Planning Act (Water Code Sections 10610 – 10656), requiring that every urban water supplier that provides water to 3,000 or more customers, or that provides over 3,000 acre-feet of water annually, make every effort to ensure the appropriate level of reliability in its water service and plan for future growth. More specifically, the act requires that urban water suppliers ensure adequate service during normal, dry, and multiple dry years, define current and future water use, and define existing conservation measures. The City is required to comply with the Urban Water Management Planning Act and prepare an updated UWMP every 5 years. The next update is scheduled to occur in 2010, and will recur every five years thereafter. Cost Allocation: It is assumed that this program would be required until the year 2038, with budgeting of plans on a five-year cycle (six plans total). The total cost of this program is $1,019,000. This program will benefit both existing and future customers because the UWMP is established to assist decisions that affect existing system performance and is updated every five years. Since future customers benefit only from updates of the UWMP, all but fiscal year 2009/2010 and 2010/2011 costs of $169,000 are allocated to future customers. Fiscal year 2009/2010 and 2010/2011 costs are assigned to existing customers. Total Cost: $1,019,000 Allocation to Existing Customers: $169,000 / 16.6% Allocation to Future Customers: $850,000 / 83.4% ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 30 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 4.3.10 Water Master Plan (Category 16) Description: This project will provide funding for the preparation of a system-wide Water Master Plan (WMP) and complete the associated environmental review (CEQA) work. The WMP will address, among other items, future sources of supply, water quality issues, water demands, conjunctive use strategies, water system modeling updates and capital improvements (for both existing and future customers). This program will update, at five-year intervals, a WMP document that evaluates the hydraulic and operational performance of the City’s water system. Justification: The WMP allows the City to assess the impacts of future planned water system expansions, compare existing and planned supplies to existing and projected demands, and develop a capital improvement plan for both existing and future customers. The City does not currently have a WMP. Therefore, it is recommended that the City complete a WMP and then update it every five years. It is expected that work will begin on the WMP during the 2009/2010 fiscal year and be completed the following fiscal year. Cost Allocation: It is assumed that this program would be required until the year 2038; therefore, using this assumption, the total cost of this program is $5,199,000. Costs attributed to future customers are based on the proportionate share of the costs required outside of the fiscal year 2009/2010 and 2010/2011 cost of a water master plan ($1,199,000). Consequently, the total allocation to future customers is 76.9 percent ($4,000,000 divided by $5,199,000). Funding for the fiscal years 2009/2010 and 2010/2011 cost is provided by existing customers. Total Cost: $5,199,000 Allocation to Existing Customers: $1,199,000 /23.1% Allocation to Future Customers: $4,000,000 / 76.9% 4.3.11 Water System Evaluation (Category 17) Description: This program will provide funding for the preparation of "as-needed" engineering studies and water system evaluations throughout the water service areas. These studies and evaluations are normally related to demand expectations, supply capabilities, the potential loss of key groundwater production wells, capital deficiencies, regulatory impacts, environmental reviews, water supply assessments, hydraulic modeling support, and other water system related activities exploratory discussions with Oakdale Irrigation District). These studies will be smaller than a WMP, and will occur between updates of the WMP. This program also includes funding for maintenance of the hydraulic modeling software and hydraulic model updates. Justification: Periodically, the City needs to conduct time critical engineering studies and evaluations of the water system. The City typically conducts these engineering evaluations and water system studies in response to proposed private development projects, regulatory agency requirements, and to increase the City staff’s level of understanding of the entire water system between updates of the WMP. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 31 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Cost Allocation: The total cost of this program is $4,209,000. Since the purpose of this program is to conduct various time critical engineering studies and water system evaluations required for existing and future expansions, costs are allocated to existing and future customers. Existing customers are allocated $159,000 for the fiscal years 2009/2010 and 2010/2011. The remaining costs are allocated to future customers. Total Cost: $4,209,000 Allocation to Existing Customers: $159,000 / 3.8% Allocation to Future Customers: $4,050,000 / 96.2% 4.3.12 New Water Tanks (Category 18) Description: This will provide funding for new water tanks throughout the service area (e.g. Del Rio, Waterford, Hickman, South Modesto, etc.); including booster pump stations, generators for back-up power, and other associated facilities. Justification: Using previously established performance and design criteria,8 storage requirements for the contiguous and outlying service areas should provide sufficient storage to address the following three supply components:  Operational Storage: 25 percent of the Maximum Day demand.  Fire Flow Storage: Meets the required fire flow times the duration period, as required by the City’s Fire Department. However, two simultaneous fire flow events were assumed for storage to provide a more conservative fire flow storage estimate.  Emergency Storage: one Average Day demand. The proposed storage capacities provided by new storage tanks (beyond those previously identified as part of the City-Side Improvements related to the Phase Two Expansion), as determined in the hydraulic analyses presented in Appendices E through J, are listed in Table 11. Table 11. Proposed Storage Tank Capacities(a) Service Area Size, MG Del Rio 0.23 Hickman 0.40 Waterford 0.66 Adjacent to the Terminal Reservoirs 5.00 South Modesto 10.00 Total 16.29 These recommendations are only a master plan level identification, and subsequent detailed design is required to determine the exact sizes. 8 Details can be found in the Existing System Evaluation TM (Appendix ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 32 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Cost Allocation: The projects for this category are listed in Tables C2 and C3, and have a total cost of $47,600,000. Since the construction of these new tanks will benefit both existing and future customers, costs are allocated to both groups. Of the total cost for storage, $8,020,000 ($1,620,000 of the Del Rio cost, and all of the Hickman and Waterford costs) is needed for existing customers and the remainder ($1,180,000 of the Del Rio cost, and all of the Contiguous Service Area cost) is needed for future growth. Therefore, 16.8 percent of costs in this category ($8,020,000/47,600,000) is allocated to existing customers, and 83.2 percent to future growth. Total Cost: $47,600,000 Allocation to Existing Customers: $8,020,000 / 16.8% Allocation to Future Customers: $39,580,000 / 83.2% 4.3.13 Water Meters Program (Category 19) Description: This program is established to fund the purchase and installation of automated meters readers for customers throughout the service area, as well as upgrading existing obsolete meters. City staff estimates that approximately 3,700 meters will be installed per year over the next 10 years. Justification: This work is mandated by State law and must be complete by 2025 (the City’s actual completion target is 2020). Cost Allocation: Program costs identified in the CIP total $32,986,000. Since future customers are required to have meters installed as new areas are developed, this program directly affects and benefits existing customers only. Therefore, 100 percent of these costs are allocated to existing customers. Total Cost: $32,986,000 Allocation to Existing Customers: $32,986,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.14 New or Replacement Pumps (Category 21) Description: On an as needed basis, this project replaces deficient water pumps at wells that are beyond their useful life and/or too costly to repair. On average, 8 to 10 pump replacements will be made annually (approximately 10 percent of all wells in operation). Justification: Similar to the need to replace aging pipeline infrastructure in the water system over time, it is also necessary to replace existing deficient water pumps at wells on an as-needed basis in the contiguous and outlying service areas. In particular, pumps may need replacement over time if pump efficiency decreases or if the pump experiences mechanical problems that cannot be remedied with routine maintenance. The City’s CIP is based on staff estimates that would allow for 8-10 pumps to be replaced annually. Cost Allocation: The costs for this category are extended to the year 2038 at $900,000 per year to account for the continued necessary maintenance of the pumps in the water system. This assumption results in a total program cost of $19,543,000. ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 33 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report Since these improvements are primarily focused on maintaining existing system performance, costs are only allocated to existing customers. Total Cost: $19,543,000 Allocation to Existing Customers: $19,543,000 / 100.0% Allocation to Future Customers: $0 / 0.0% 4.3.15 Soil Remediation Program (Category 22) Description: The Soil Remediation Program actively protects the groundwater supply source, by providing funds for identifying sources of contamination, monitoring, testing, developing a corrective action plan, and remediation of the contamination. Justification: The City uses both groundwater and surface water to provide drinking water to its customers, with groundwater representing the majority of the current supply. This program is needed to help protect the City’s groundwater supply. Cost Allocation: The total cost for the Soil Remediation Program is $1,263,000. However, $263,000 is for the Kansas-Needham Soil Remediation Project, which is included in Section 3.0 Project Improvements. Therefore, the cost applicable to general programs is $1,000,000. The Soil Remediation Program includes activities to protect the existing water supply. Therefore the cost of this program is allocated to existing users. Total Cost: $1,000,000 Allocation to Existing Customers: $1,000,000 / 0% Allocation to Future Customers: $0 / 0% 4.3.16 Utility Cuts Program (Category 23) Description: This project funds pavement repairs related to utility construction activities, such as the installation of water lines, valve replacement, water connections, and leak repairs. This project receives partial funding from the General Fund $264,000 annually. Justification: The City maintains this project in the City’s CIP to cover costs beyond funds included as part of the Strengthen and Replace Water System Program (Category Cost Allocation: The total cost of this project as provided in the CIP is $28,844,000. Utility cuts are required for pavement repairs related to utility construction activities such as the Strengthen and Replace Water System Program, which will benefit existing customers. Therefore, 100 percent of the cost is allocated to existing customers. Total Cost: $28,844,000 Allocation to Existing Customers: $28,844,000 / 100.0% Allocation to Future Customers: $0 / 0.0% ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 34 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 5.0 PROJECT SCHEDULE AND COST PROJECTIONS The proposed CIP expenditures by year, which incorporate non-redundant expenditure information from the City’s fiscal year 2009/2010 through 2037/2038 CIP, are summarized in Table 12. Projects identified in this Report have been broken out into design and construction phases to help the City prepare associated budgets. Those projects that resolve existing system deficiencies and support the have been placed as the highest priority, beginning with design in the 2009/2010 fiscal year. It does not appear that the will be in service by 2011 as indicated in the project Final EIR. For purposes of this Report, it is assumed that construction of this project will take place from 2013 through 2015. Projects to meet future needs are called out annually for the first five years, from fiscal year 2009/2010 through 2013/2014. Following that time period, projects are identified in six-year milestones. Table 12 shows the anticipated cost per fiscal year for each of the CIP projects, and the total cost for each fiscal year. Figure 13 presents a schedule starting in 2010 for the construction of the recommended capital improvement projects to eliminate deficiencies in the existing and buildout water system. Projected annual expenditures and cumulative annual expenditures are illustrated in Figures 14 and 15, respectively. The costs are shown in March 2010 dollars. ---PAGE BREAK--- Project 2009/10 2010/11 2011/12 2012/13 2013/14 2015-20 2021-26 2027-32 2033-38 Design Regional Facilities for 1.20 2.80 Construct Regional Facilities for 15.00 20.00 10.00 Design City Facilities for 0.56 Construct City Facilities for 2.80 2.24 Design Existing System Pipe Upgrades 1.62 1.62 Construct Existing System Pipe Upgrades 9.69 9.69 9.69 Design/Construct Buildout System Pipelines 0.50 0.50 1.81 1.92 1.92 11.53 11.53 11.53 11.53 Design/Construct Back Up Generators at Wells 0.20 0.20 0.20 0.20 0.20 2.20 Design/Construct Buildout Backup Generators at Wells 0.60 3.40 Design/Construct Back Up Generators for Outlying Areas 0.40 0.40 0.40 0.40 0.40 0.20 Rehabilitate Well 255 0.83 Design/Construct Replacement Well 271 1.80 Design/Construct Del Rio Existing Improvements 0.85 0.91 1.80 Design/Construct Del Rio Buildout Improvements 1.33 1.33 1.33 Design/Construct Grayson Existing Improvements 0.69 Design/Construct Hickman Existing Improvements 0.89 0.89 0.89 0.89 0.89 Design/Construct Turlock Existing Improvements 0.37 0.37 0.37 0.37 0.37 Design/Construct Waterford Existing Improvements 1.23 1.23 1.23 1.23 1.23 Design 5.0 MG North Modesto Storage Tank 1.30 Construct 5.0 MG North Modesto Storage Tank 11.90 Design/Construct Well 63 – Mildred Perkins Well 1.23 Design/Construct Waterford Well 0.30 1.70 Design/Construct Buildout Well 1 2.00 Design/Construct City's Planned CIP Year(b) 21.70 20.04 10.58 18.66 15.41 68.65 49.66 40.13 40.13 Total 30.87 41.57 27.53 54.18 43.98 107.70 66.58 51.65 51.66 Does not call out individual planned City CIP, except where noted. Costs include construction of Regional Facilities. Costs included are based on City's 2009-2038 CIP budget spreadsheet timeline. Estimated Costs, million dollars Table 12. Proposed CIP Planning and Construction Schedule(a) West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceopA3ciptables Last Revised: 04/01/10 City of Modesto Engineer's Report Option A ---PAGE BREAK--- 2010 Water System Engineer’s Report – Option A May 2010 36 City of Modesto o:\c\418\02-07-22\wp\er\20091031ceOpA1 Engineer’s Report 6.0 REFERENCES B&V. 1991. Modesto Domestic Water Project Transmission Facility Pre-Design Hydraulic Analysis and Report. B&V. 2004. Draft Phase II Predesign Report. City of Modesto. 2008. City of Modesto: 2009-2018 Capital Improvement Program. City of Modesto. 2007. City of Modesto South Modesto Interim Water Supply Study. City of Modesto. September 2007. City of Modesto Drinking Water Wells Out of Service in September 2007. City of Modesto. June 8, 2004. City of Modesto Interoffice Memorandum: Phase II Expansion Project Subsequent EIR Administrative Draft. City of Modesto. 1995, amended 2003. Urban Area General Plan. RMC. May 2007. City of Modesto/Modesto Irrigation District Joint Urban Water Management Plan 2005 Update. ---PAGE BREAK--- D r y Cre e k Tuolu m ne Ri v e r Stani s l a u s Riv er San J o aq u in R i ve r FIGURE 1 City of Modesto MODESTO SERVICE AREAS NOTES: O\C\418\020722\GIS\Figures\Water Supply\Fig 1_Modesto Service Area.mxd Contiguous Service Area Outlying Service Area Street Modesto Salida Empire Grayson Hickman Turlock Waterford Del Rio North Ceres (Portion Served by Modesto) ·I}þ 132 ·I}þ 99 LEGEND: 0 1 2 0.5 Scale in Miles Ceres (Walnut Manor) ---PAGE BREAK--- Figure 2. General Plan Service Areas Figure 2. General Plan Service Areas ---PAGE BREAK--- Stan i s la u s Ri v e r Dr y Cr e e k Tuol umn e River San J o aq u in R i ve r FIGURE 3 City of Modesto MODESTO SERVICE AREAS AND LOCATION OF GROUNDWATER SUBBASINS NOTES: O\C\418\020722\GIS\Figures\Water Supply\Fig 2_Modesto Service Area GW.mxd Modesto Subbasin Turlock Subbasin Delta-Mendota Subbasin Contiguous Service Area Outlying Service Area Street Modesto Salida Empire Grayson Hickman Turlock Waterford Del Rio North Ceres (Portion Served by Modesto) ·I}þ 132 ·I}þ 99 LEGEND: 0 1 2 0.5 Scale in Miles Ceres (Walnut Manor) ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091031ceC2 Last Revised: 06/10/08 City of Modesto Engineer's Report Option A Figure 4. Comparison of Supply and Demand (Wet and Normal Conditions): North Modesto 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,602 33,437 34,252 35,067 5,541 6,356 7,171 7,986 8,801 9,616 10,431 11,248 12,374 13,500 14,625 15,751 16,877 18,003 19,128 20,254 21,380 22,505 23,631 24,757 25,883 27,008 28,134 29,260 30,386 31,511 42,125 41,244 40,364 39,484 38,603 37,723 36,843 35,962 35,082 34,202 33,320 32,129 30,938 29,747 28,556 27,365 26,174 24,983 20,219 19,028 17,837 16,646 15,455 14,264 13,073 35,882 3,095 3,910 4,726 12,044 11,883 23,792 22,601 21,410 10,283 11,164 9,403 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 110,000 120,000 130,000 140,000 150,000 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Year acre-feet Surface Water Initial Phase) Surface Water Phase Two) Groundwater Supply Required (Modesto Subbasin) Supplemental Groundwater Available (Modesto Subbasin) Demand (North Modesto) Notes: - Assumes normal or wetter hydrologic conditions. - Based on allocation of preliminary operational yield presented in Table 2 and remaining groundwater yield amounts shown in Table 5. - Assumes Phase Two Expansion of the is available by 2010. - The demand line was established from a linear interpolation between 2006 and buildout (2038) demands shown in Table 1; which takes into account a demand reduction of 10 percent due to the City's ongoing water meter installation program. ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091031ceC2 Last Revised: 11/18/09 City of Modesto Engineer's Report Option A Figure 5. Comparison of Supply and Demand (Multiple Year Drought): North Modesto 67,204 64,324 61,444 58,563 55,683 52,803 27,008 29,888 33,894 37,901 41,907 43,394 16,646 13,766 9,695 2,518 5,623 1,552 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 110,000 120,000 130,000 140,000 Normal or Wetter (2034) Year 1 (2034) Year 2 (2035) Year 3 (2036) Year 4 (2037) Year 5 (2038) Drought Year acre-feet Surface Water Modesto Subbasin Groundwater Additional Supply Required Supplemental Groundwater Available (Modesto Subbasin) Demand (North Modesto) Since preliminary operational yield is a long- term average, additional groundwater is assumed available during drier periods. Note: - See Figure 4 to determine the yearly groundwater supply from the Modesto Subbasin during a multiple year drought. - Surface water reductions are based on the AR TDA between MID and the City (see Section 3.2.3). - The demand line is the same as that used in Figure 4. ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091031ceC2 Last Revised: 06/10/08 City of Modesto Engineer's Report Option A Figure 6. Comparison of Supply and Demand (Wet and Normal Conditions): South Modesto 4,324 4,315 4,307 4,298 4,290 4,282 4,273 4,265 4,256 4,248 4,239 4,231 4,223 4,214 4,206 4,197 4,189 4,181 4,172 4,164 4,155 4,147 4,138 4,130 4,122 4,113 4,105 4,096 4,088 4,079 4,071 4,063 4,054 3,835 3,975 4,114 4,253 4,392 4,531 4,671 4,810 4,949 5,015 5,082 5,148 5,215 5,281 5,348 5,452 5,557 5,662 5,767 5,871 5,976 6,081 6,186 6,291 6,395 6,500 6,605 6,710 6,814 6,919 7,024 7,129 7,234 4,649 5,945 7,240 8,536 9,832 11,128 12,423 13,719 20,198 21,493 22,789 24,085 25,380 26,676 27,972 28,921 29,867 30,814 31,761 32,708 33,654 34,674 35,693 36,713 37,732 6,170 7,189 8,209 5,150 18,902 17,606 16,310 15,015 0 2,500 5,000 7,500 10,000 12,500 15,000 17,500 20,000 22,500 25,000 27,500 30,000 32,500 35,000 37,500 40,000 42,500 45,000 47,500 50,000 52,500 55,000 57,500 60,000 62,500 65,000 67,500 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Year acre-feet Groundwater Supply Required (Turlock Subbasin) Transferred Groundwater Supply Required (Modesto Subbasin) Surplus Groundwater (Modesto Subbasin) Additional Supply Requirement Demand (South Modesto) Notes: - Assumes normal or wetter hydrologic conditions. - Based on allocation of preliminary operational yield presented in Table 2 and remaining groundwater yield amounts shown in Table 5. - Surplus groundwater available from the Modesto Subbasin equals the amount of preliminary operational yield supply that was not required to meet projected demands. - The demand line was established from a linear interpolation between the 2006 and buildout (2038) demands shown in Table 1; which takes into account a demand reduction of 10 percent due to the City's ongoing water meter installation program. ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091031ceC2 Last Revised: 11/18/09 City of Modesto Engineer's Report Option A Figure 7. Comparison of Supply and Demand (Multiple Year Drought): South Modesto 4,088 4,088 4,079 4,071 4,063 4,054 6,814 6,814 6,919 1,552 5,623 7,234 5,576 1,401 9,832 6,952 2,776 0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 16,000 18,000 20,000 22,000 24,000 Normal or Wetter (2034) Year 1 (2034) Year 2 (2035) Year 3 (2036) Year 4 (2037) Year 5 (2038) Drought Year acre-feet Turlock Subbasin Groundwater Supplemental Groundwater from Modesto Subbasin Additional Supply Required Surplus Groundwater (Modesto Subbasin) Demand (South Modesto) Since preliminary operational yield is a long- term average, additional groundwater is assumed available during drier periods. Note: - See Figure 5 to determine the yearly groundwater supply from the Modesto Subbasin during a multiple year drought. - The demand line is the same as that used in Figure 6. ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091118bjhC2 Last Revised: 11/18/09 City of Modesto Engineer's Report Option A Figure 8. Comparison of Supply and Demand (Wet and Normal Conditions) with South Modesto 4,324 4,315 4,307 4,298 4,290 4,282 4,273 4,265 4,256 4,248 4,239 4,231 4,223 4,214 4,206 4,197 4,189 4,181 4,172 4,164 4,155 4,147 4,138 4,130 4,122 4,113 4,105 4,096 4,088 4,079 4,071 4,063 4,054 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 6,720 3,835 3,975 4,114 4,253 4,392 4,531 4,671 4,810 6,720 6,720 6,720 6,720 6,720 514 409 304 199 94 34,674 35,693 36,713 37,732 6,170 7,189 8,209 5,150 0 2,500 5,000 7,500 10,000 12,500 15,000 17,500 20,000 22,500 25,000 27,500 30,000 32,500 35,000 37,500 40,000 42,500 45,000 47,500 50,000 52,500 55,000 57,500 60,000 62,500 65,000 67,500 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Year acre-feet Groundwater Supply Required (Turlock Subbasin) Additional Supply From Transferred Groundwater Supply Required (Modesto Subbasin) Surplus Groundwater (Modesto Subbasin) Demand (South Modesto) Notes: - Assumes normal or wetter hydrologic conditions. - Based on allocation of preliminary operational yield presented in Table 2 and remaining groundwater yield amounts shown in Table 5 of Appendix C. - Surplus groundwater available from the Modesto Subbasin equals the amount of preliminary operational yield supply that was not required to meet projected demands. - The demand line was established from a linear interpolation between the 2006 and buildout (2038) demands shown in Table 1 of Appendix C; which takes into account a demand reduction of 10 percent due to the City's ongoing water meter installation program. ---PAGE BREAK--- West Yost Associates o:\c\418\02-07-22\wp\er\appc\20091118bjhC2 Last Revised: 11/18/09 City of Modesto Engineer's Report Option A Figure 9. Comparison of Supply and Demand (Multiple Year Drought) with South Modesto 4,088 4,088 4,079 4,071 4,063 4,054 6,720 6,720 6,720 6,720 6,720 6,720 94 94 199 304 409 514 0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 16,000 18,000 20,000 22,000 24,000 Normal or Wetter (2034) Year 1 (2034) Year 2 (2035) Year 3 (2036) Year 4 (2037) Year 5 (2038) Drought Year acre-feet Turlock Subbasin Groundwater Additional Supply From Supplemental Groundwater from Modesto Subbasin Demand (South Modesto) Note: - The demand line is the same as that used in Figure 6. ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK--- U T U T U T U T U T U T U T U T U T U T U T U T U T U T TR01SOI DV-TV DV-KMC DV-NC DV-FV DV-KW DV-KBPE DV-MR DV-KBPS DV-WP DV-PR DV-PM DV-WG DV-KMC DV-KBPE DV-TV DV-FV DV-TV DV-WP DV-TV DV-NC DV-TV DV-KMC DV-KBPS DV-PM DV-KW DV-WP DV-WP DV-PM DV-FV DV-TV DV-TV DV-FV DV-TV DV-TV DV-TV DV-KBPE DV-TV DV-PR DV-WP DV-TV DV-WG DV-KBPE DV-TV DV-TV DV-TV DV-TV DV-KMC DV-KBPS DV-TV DV-KMC DV-TV DV-TV DV-TV DV-TV DV-TV DV-WG SB11SOI SB13SOI SB21SOI SB14SOI SB20SOI SB16SOI SB03SOI SB08SOI SB09SOI SB07SOI SB15SOI SB06SOI SB10SOI SB17SOI SB05SOI SB04SOI DV-RD SB01SOI SB12SOI SB19SOI MID02WT01 DV-MH DV-PL SB08SOI SB03SOI SB13SOI SB01SOI SB11SOI SB06SOI SB08SOI SB10SOI SB21SOI DV-RD SB03SOI DV-RD SB07SOI SB08SOI SB03SOI SB03SOI SB11SOI SB01SOI SB07SOI SB20SOI SB21SOI SB21SOI SB01SOI SB13SOI SB21SOI SB08SOI SB20SOI SB03SOI SB03SOI SB16SOI SB20SOI SB07SOI SB07SOI SB08SOI SB21SOI SB03SOI SB17SOI SB07SOI SB03SOI SB07SOI SB20SOI SB13SOI SB21SOI SB03SOI SB21SOI SB11SOI SB08SOI SB20SOI SB20SOI SB01SOI SB10SOI SB21SOI SB20SOI SB12SOI SB03SOI SB07SOI SB07SOI SB06SOI SB03SOI SB20SOI SB13SOI SB12SOI TR06SOI FF19366 FF18472 FF19598 4IN-UPSIZE PH01 PH02 TR04SOI FF13686 TR05SOI FF10728 FF13452 TR07SOI FF10712 FF13602 FF10718 4IN-UPSIZE 4IN-UPSIZE PH02 TR04SOI 4IN-UPSIZE 4IN-UPSIZE PH02 TR05SOI TR07SOI 4IN-UPSIZE 4IN-UPSIZE TR06SOI TR06SOI FF19598 4IN-UPSIZE Tank 7 Tank 8 Tank 6 Tank 4 Tank 3 Tank 5 Tank 10 West Tank North Tank Buildout Tank Industrial Tank MID Terminal Reservoir South Modesto Terminal Tank 065 061 064 063 FMC 066 062 055 038 019 305 287 284 223 216 214 100 049 236 053 050 044 024 021 008 313 312 310 308 307 304 301 300 299 298 297 296 294 293 292 291 290 288 285 283 281 279 278 277 269 267 265 264 262 260 259 250 247 241 237 232 229 226 225 212 211 204 059 058 057 056 052 051 048 047 046 045 043 042 041 039 040 037 036 034 033 032 030 025 022 018 017 016 014 010 007 006 004 003 002 001 Tivoli SOI 01 Plastipak Shelter Cove 217 054 029 Grogan FIGURE 12 City of Modesto RECOMMENDED BUILDOUT CONTIGUOUS SERVICE AREA SYSTEM CIP NOTES: LEGEND: O\C\418\020722\GIS\Figs\TIDTM\418020722-FIG7-BuildoutCIP.mxd 0 3,500 7,000 1,750 Scale in Feet Contiguous Service Area Boundary City Limits U T Existing Tank & Pump Station U T Proposed South Modesto Terminal Tank & Pump Station U T Recommended CIP Tank Existing Active Well Existing Inactive Well Existing Blending Well Proposed Near-term Well Proposed Buildout Well Recommended CIP Well Existing Pipeline Existing MID Transmission Pipeline Proposed Near-term Pipeline Proposed Buildout Pipeline Recommended Near-term CIP Pipeline Improvement Street - Inactive wells based on City's August 2009 Out of Service Well Report - Existing facilities include recommended Existing System CIP facilities detailed in Existing System Evaluation TM (Appendix D) - Near-term pipeline alignments based on information provided by City and developers ---PAGE BREAK--- ---PAGE BREAK--- West Yost Associates o:\c\418\02 07 22\wp\er\OpA\20091031ceOpA2Fig14&15 Last Revised: 04-10-10 City of Modesto Engineer's Report Option A Figure 14. Total Annual Expenditures 30.87 41.57 27.53 54.18 43.98 36.67 17.90 18.40 11.35 14.75 8.63 9.51 8.81 14.94 15.11 10.49 7.72 8.92 7.25 11.02 8.20 8.93 7.33 8.93 9.23 10.00 7.23 8.93 7.33 0 10 20 30 40 50 60 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26 2026/27 2027/28 2028/29 2029/30 2030/31 2031/32 2032/33 2033/34 2034/35 2035/36 2036/37 2037/38 Fiscal Year Annual Capital Cost, $M ---PAGE BREAK--- West Yost Associates o:\c\418\02 07 22\wp\er\OpA\20091031ceOpA2Fig14&15 Last Revised: 04-10-10 City of Modesto Engineer's Report Option A Figure 15. Cumulative Capital Cost Flow 72.44 99.97 154.15 198.13 234.80 252.70 271.10 282.45 297.20 407.80 30.87 305.83 315.34 324.15 339.09 354.20 364.69 372.41 381.33 388.58 399.60 416.73 424.06 432.99 442.22 452.22 459.46 468.39 475.72 0 100 200 300 400 [PHONE REDACTED]/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26 2026/27 2027/28 2028/29 2029/30 2030/31 2031/32 2032/33 2033/34 2034/35 2035/36 2036/37 2037/38 Fiscal Year Cumulative Capital Cost, $M ---PAGE BREAK--- ATTACHMENT A Construction Costs for Planning and Design ---PAGE BREAK--- West Yost Associates A-1 o:\c\418\02-07-22\wp\TID\050708ap5AppA ATTACHMENT A. CONSTRUCTION COSTS FOR PLANNING AND DESIGN For budgetary estimating purposes, construction costs used to estimate the cost of recommended water system facility improvements are presented in Tables A-1 through A-3. The costs were developed in the City of Modesto Water System Hydraulic Model Update Project, Task 4D. Revised Design System Performance Criteria Technical Memorandum dated June 17, 2004 prepared by WYA. The unit costs were based on data supplied by manufacturers, published industry standard cost data and curves, and construction costs for similar facilities built by the City and/or other public agencies with similar construction cost indexes. All construction costs have been adjusted to reflect March 2010 costs at an Engineer News Record (ENR) construction cost index of 9728.17 for San Francisco. These costs are to be used for conceptual cost estimates only, and should be updated regularly. Additionally, these costs are for construction only and do not include unexpected construction costs variations in final quantities) or cost estimates for land acquisition, engineering, legal costs, environmental review, inspections and/or contract administration. These additional cost items are referred to as contingency costs and are described below. Construction cost data presented in this technical memorandum are not intended to represent the lowest prices in the industry for each type of construction; rather they are representative of average or typical construction costs. The planning level cost estimates have been prepared for guidance in evaluating various options, and are intended for budgetary purposes only, within the context of this Engineer’s Report. Pipelines Unit construction costs for water pipelines 6 through 36 inches in diameter are provided in Table A-1. These costs are to be used for typical pipeline construction in urban areas (urban) and construction across open fields or areas that are not yet developed (rural). These costs generally include pipe materials, trenching, placing and jointing pipe, valves, fittings, hydrants, service connections, placing imported pipe bedding, native backfill material, and asphalt pavement replacement, if required. ---PAGE BREAK--- West Yost Associates A-2 o:\c\411\02-07-22\wp\TID\050708ap5AppA Table A-1. Unit Construction Costs for Pipelines(a) Unit Construction Cost, $/lineal foot Pipe Diameter, inches Rural Urban 6 61 76 8 67 101 10 81 123 12 95 136 14 109 149 16 122 163 18 136 178 20 142 197 24 168 218 30 236 273 36 314 354 Based on costs developed for the 2004 Report, multiplied by the San Francisco ENR construction cost index ratio from May 2004 (7064.14) to March 2010 (9728.17). Treated Water Storage Tanks Table A-2 lists the estimated total construction costs for water storage tanks in the size ranges of 1.0 to 6.0 million gallons (MG). Because these costs represent budgetary numbers for planning purposes, WYA based them on partially buried pre-stressed concrete tanks rather than above ground steel tanks; this provides the City with a more conservative planning budget. As previously stated, these costs are representative of construction conducted under normal excavation and foundation conditions, and would be significantly higher for special or difficult foundation requirements. Table A-2. Construction Costs for Treated Water Storage Tanks(a) Capacity, MG Estimated Construction Cost Pre-Stressed Concrete Storage Tank, $ 1.0 1,370,000 2.0 2,760,000 3.0 4,130,000 4.0 5,510,000 5.0 6,880,000 6.0 8,270,000 Based on costs developed for the 2004 Report, multiplied by the San Francisco ENR construction cost index ratio from May 2004 (7064.14) to March 2010 (9728.17). ---PAGE BREAK--- West Yost Associates A-3 o:\c\411\02-07-22\wp\TID\050708ap5AppA Treated Water Booster Pump Stations Distribution pumping station costs vary considerably, depending on such factors as architectural design, pumping head, and station capacity. Estimated average construction costs for distribution pumping stations, as shown in Table A-3 are based on enclosed stations with architectural and landscaping treatment suitable for residential areas. Pump station cost estimates include backup/standby generators and SCADA. Table A-3. Construction Costs for Booster Pump Stations(a) Capacity, Horsepower Estimated Construction Cost, $ 50 800,000 75 920,000 100 1,020,000 125 1,110,000 150 1,200,000 175 1,290,000 200 1,370,000 250 1,570,000 300 1,670,000 350 1,800,000 400 1,940,000 Based on costs developed for the 2004 Report, multiplied by the San Francisco ENR construction cost index ratio from May 2004 (7064.14) to March 2010 (9728.17). Municipal Groundwater Production Wells Well construction consists of pilot hole drilling, water quality/soil sampling, pilot hole reaming, well construction, well development and providing the necessary housing, pump, motor, automatic control equipment, discharge piping, SCADA, and disinfection equipment. In the 2004 Report, the cost was estimated to be approximately $1,000,000 per well, for a 1,500 to 2,000- gpm well, approximately 400 to 500 feet deep. Multiplied by the ratio of the May 2004 and March 2010 ENR construction cost indices for San Francisco (9728.17/7064.14 = 1.38), the cost of a new well in 2008 dollars would be approximately $1,380,000 per well. These costs are representative of construction conducted under normal drilling conditions, and would be significantly higher for special or difficult locations. With markups for soft costs (see Contingencies and Other Project Costs, below), the total capital cost for wells is $2.07M. Based on review with the City, the capital cost was rounded to $2.0M, and a base construction well cost of $1.33M was used. Contingencies and Other Project Costs Contingency costs must be reviewed on a case-by-case basis because they will vary considerably with each project. However, to assist the City in budgeting for these future construction projects, contingency costs will be added to the planning budget as percentages of the total construction cost, divided into two categories: Construction Contingency Costs and Other Project Fees Costs. ---PAGE BREAK--- West Yost Associates A-4 o:\c\411\02-07-22\wp\TID\050708ap5AppA Construction Contingency Costs: The construction costs presented above are representative of the construction of water system facilities under normal construction conditions and schedules; consequently, it is appropriate to allow for uncertainties unavoidably associated with the preliminary layout of projects. Such factors as unexpected construction conditions, the need for unforeseen mechanical items, and variations in final quantities are a few of the items that can increase project costs for which it is wise to make allowances in preliminary estimates. An allowance of 20 percent of the base construction cost will be included to cover such project related construction contingencies. Other Project Fees: Other project fees are divided into 3 subcategories, totaling 30%: 10% engineering, 10% construction management, and 10% program implementation. Engineering services associated with new facilities include preliminary investigations and reports, right-of- way acquisition, foundation explorations, preparation of drawings and specifications during construction, surveying and staking, sampling of testing material, and start-up services. For this study, engineering costs are assumed to be 10 percent of the base construction cost estimates. Construction management covers such items as contract management and inspection during construction. The cost of these items can also vary, but for the purpose of this study, it is assumed that construction management charges will equal approximately 10 percent of the base construction costs. Finally, there are program implementation costs, which cover such items as legal fees, environmental/CEQA compliance requirements, financing expenses, administrative costs, and interest during construction. The cost of these items can also vary, but for the purpose of this study, it is assumed that program implementation costs will equal approximately 10 percent of the base construction costs. As shown below, the total cost of all project construction contingencies and fees: construction, engineering services, construction management, and program implementation is 50 percent of the base construction costs for each project. Example: Base Construction Cost $1,000,000 Construction Contingency (20 200,000 Engineering Costs (10%) 100,000 Construction Management (10%) 100,000 Program Implementation (10%) 100,000 Total Cost $1,500,000 ---PAGE BREAK--- ATTACHMENT B City of Modesto Drinking Water Wells Out of Service in August 2009 ---PAGE BREAK--- Public Works Department Memorandum DATE: September 11, 2009 TO: Greg Nyhoff, City Manager FROM: David Savidge, Water Systems Manager, Public Works SUBJECT: City of Modesto Drinking Water Wells Out of Service in August 2009. This information is provided to you each month in compliance with the State Department of Public Health (DPH) requirement that the City Council be notified whenever a drinking water well: 1) exceeds a Maximum Contaminant Level (MCL), 2) exceeds an Action Level, or 3) is taken out of service because it has exceeded either the MCL or the Action Level. This notification must occur within 30 days of the discovery or well closure. These regulations are found in the Health and Safety Code, Section 4028.5. Maximum Contaminant Levels (MCL) are set by either the DHS or the U.S. Environmental Protection Agency. Before an MCL is established, both economic and health considerations must be weighed. Once established, an MCL is enforceable based on health considerations only. On the other hand, Action Levels are not enforceable standards but policy decisions are frequently based on them. It is important to note that a well may, after follow-up testing, meet water quality standards and be returned to service. Since the August 1st report, the number of off line wells is at 25 with a combined reduction in well production capacity of approximately 17.3%. The attached site map shows the location of the wells taken out of service because they have exceeded either the MCL or the Action Level. cc: City Council Nick Pinhey, Public Works Director City of Modesto ---PAGE BREAK--- Wells Out of Service during Month of August 2009: Well # Production Capacity (Gallons per Minute) Reason Other Comments 18 750 19 600 32 800 53 1,500 214 400 236 750 285 1,000 293 825 306 210 Nitrate 02 1,500 08 775 14 1,500 21 1,500 22 1,000 24 1,500 34 1,250 44 1,250 55 1,500 66 1590 283 800 304 525 Uranium Blending is best treatment for uranium. A good water source must first be found. Wells 14 and 34 also exceed the MCL for Gross Alpha. A blending solution is being explored for well 55. 03 800 PCE Property has been purchased and a process is in place to hire an engineer to design a treatment system using GAC. 49 795 226 675 Arsenic Blending is the best treatment for Arsenic. A blend project is in place now for Well 49, A test hole is planned for Well 226 to explore new sources of water. 37 1,250 Gross Alpha Blending is best treatment for Gross Alpha. ---PAGE BREAK--- TULLY RD E HATCH RD OAKDALE RD SISK RD YOSEMITE BLV MAZE BLV SYLVAN AVE H ST E WHITMORE AVE ROSELLE AVE MITCHELL RD COFFEE RD PARADISE RD FLOYD AVE W HATCH RD CLARIBEL RD KIERNAN AVE MILNES RD BLUE GUM AVE CLAUS RD SCENIC DR E BRIGGSMORE AVE E ORANGEBURG AVE S CARPENTER RD BECKWITH RD W WHITMORE AVE PARKER RD KANSAS AVE S 7TH ST CENTRAL AVE J ST PRESCOTT RD MORGAN RD DALE RD N SANTA FE AVE CLARATINA AVE STANDIFORD AVE TERMINAL AVE CARVER RD S 9TH ST D ST EL VISTA AVE L ST N 9TH ST MC HENRY AVE PELANDALE AVE LA LOMA AVE N CARPE NTER RD W BRIGGSMORE AVE LAKEWOOD AVE NEEDHAM AVE B ST DOWNEY AVE W ORAN G E B URG AVE CROWS LANDING RD PARADISE AVE G ST TUOL U MNE B LV 9TH ST W ORANGEBURG AVE MAZE BLV N CARPENTER RD CROWS LANDING RD 9TH ST LA LOMA AVE MAZE BLV DALE RD E WHITMORE AVE PELANDALE AVE SISK RD STANDIFORD AVE YOSEMITE BLV PELANDALE AVE 9TH ST E O RANG E BU R G AVE COFFEE RD G ST KIERNAN AVE MC HENRY AVE BECKWITH RD PRESCOTT RD BLUE GUM AVE CLAUS RD MC HENRY AVE CLARIBEL RD KIERNAN AVE N 9TH ST CROWS LANDING RD SCENIC DR FLOYD AVE KANSAS AVE PARADISE RD CARVER RD W BRIGGSMORE AVE E BRIGGSMORE AVE E BRIGGSMORE AVE MC HENRY AVE S CARPENTER RD S 7TH ST PARADISE RD CROWS LANDING R D 2 3 7 6 8 1 4 61 19 58 66 64 62 41 45 52 36 39 32 65 46 37 18 16 17 14 49 29 55 59 40 56 34 44 53 10 22 43 50 48 21 51 42 30 38 47 54 25 24 33 57 260 226 229 305 223 287 211 204 212 279 307 265 278 300 267 269 264 262 283 236 237 241 225 284 299 250 297 290 288 281 285 247 312 298 313 100 217 216 214 213 232 301 304 310 296 294 293 277 308 292 291 259 LADD RD MC HENRY AVE CARVER RD ST JOHNS RD PATTERSON RD HOGUE RD STEWART RD LAGO CI SPY GLASS DR COUNTRY CLUB DR DEL CIELO WY TULLY RD HILLCREST DR HARTLEY DR DEL RIO DR SKITTONE RD DEL CIELO CI OAKMONT DR COUNTRY VIEW DR ISLE DR RIVER NINE DR AVENIDA DEL RIO RIVEROAKS DR BING WY CAROLINA CT CARVER RD 289 282 271 HICKMAN RD LAKE RD I ST MONTPELIER RD 6TH ST DALLAS RD EMMA LN KYLIE PL 4TH ST ELMA ST DAVIS ST KIM ST LORENZO ST 5TH ST RIVERVIEW RD MADY WY 309 272 F ST YOSEMITE BLV E ST D ST G ST BENTLEY ST TIM BELL RD C ST N REINWAY AVE H ST HICKMAN RD MAIN ST VINEYARD RD WELCH ST B ST SKYLINE BLV DORSEY ST PECAN AVE KADOTA AVE BONNIE BRAE AVE HARBOR DR S REINWAY AVE CHURCH ST N WESTERN AVE QUICKSILVER ST RIVERSIDE RD GOLDMINE AVE RIVERCREST DR I ST N PASADENA AVE WASHINGTON RD ODEN DR LA GALLINA AVE FEARL DR CHAD WY FLORA WY AMY LN CENTER ST S WESTERN AVE BECKY WY N APPLING RD S APPLING RD MARINA LN SUMMERS ST WASHBURN AVE COASTAL LN HERNANDEZ AVE BROOK WY BAKER ST CURRAN DR FOUNTAIN DR OAKDALE WATERFORD HWY HEATHER DR STAR AVE TISDELL DR MIRANDY LN DOCKSIDE DR RIVER POINTE DR WATERWAY DR SAWMILL AVE BRISK AVE CLARKS MILL AVE KATY CT ENID DR SEAN CT LYN WY STEIN WY SNOWFLOWER DR PEEL LN MAGNETITE WY ROSE WY BARNES AVE CHAFFEE LN PETICHIA PL RIVER BEND LN LARRY WY S E ST COVEY ST AURA CT BAUXITE CT BECKY WY MAIN ST WELCH ST C ST 245 302 286 242 303 244 CAROLYN DR HWY 99 S WALNUT RD S VERDUGA RD 5TH ST DEEP SEA LN KAY CI H ST I ST G ST FISK CT REXHAM CT LORI CT W F ST 9TH ST PIONEER AVE I ST DELS LN JORDAN AVE MARKET ST JOETT DR S 1ST ST N OLIVE AVE EBES CT DUKE CT FENN CT NORTH AVE 5TH ST ABIGAIL LN IVANHOE LN PRIVATE ST (SUN GARDEN) MAIN ST CORTA VISTA ST A ST CHRIS LN SERR DR TIGERS DR LAMAR CT NIAGRA ST ALEX WY OXFORD AVE RADFORD WY HIGH ST N OLIVE AVE NIKKI ANN WY N VERDUGA RD JOETT DR PAVILLION WY ANNING DR COUNTRY LN SIERRA VISTA DR DELS LN HAMPTON WY EAST AVE CORELLO ST SPRUCE ST N THOR ST BAYLOR AVE CROWELL RD PIEDMONT AVE CROWELL RD VASSAR AVE E MONTE VISTA AVE DREW AVE GEER RD S 1ST ST JESSICA ST ANNING DR KAREN WY LAMBERT WY POLYVIEW DR SIMON DR LACY WY LUKAS ST HOPE CT B ST GEER RD KEENE CT OAK ST BELL ST H ST GEER RD N OLIVE AVE ASHLEY CT PAISLEY LN SKYWAY CT D ST W F ST VILLA ST COLUMBIA ST MITCHELL AVE BRISTOL PARK CI N PALM ST N FRONT ST COLBY AVE B ST WALLACE ST SUE DR D ST BELL ST JAMES LN HIGH ST KINGS CT WEST MAIN ST WEST MAIN ST GEER RD D ST FLORENCE ST B ST A ST PARK ST SHASTA ST CAJUN CT VILLAGE PARK CT ANDRE LN N DENAIR AVE A ST JASON DR CRANE AVE N THOR ST S PALM ST S GOLDEN STATE BLV DIVANIAN DR ABIGAIL LN EDGEWOOD DR SHADOW PARK DR WEST MAIN ST BRIAN LN YALE CT BRUCE LN E CANAL DR FLOWER ST PARK ST 6TH ST BEREA DR BRYCE AVE OGDEN WY DOMINGO CT N GOLDEN STATE BLV LINN CT WEST MAIN ST W OLIVE AVE FLOWER ST GERALD CT JULIAN ST TEAKWOOD ST DERR RD CAHILL AVE LYONS AVE EAST AVE MERRITT ST YOSEMITE ST SYCAMORE ST WEST AVE SOUTH PEDRAS RD CAHILL AVE COOPER AVE BURMAN DR FARR ST DELS LN E MAIN ST 3RD ST S LAUREL ST LOCUST ST 6TH ST 3RD ST 4TH ST S BROADWAY AVE 3RD ST SYLVA ST WEST AVE SOUTH S 1ST ST HIGH ST KENNETH DR KENSINGTON CT HAVEN WY CHESTNUT ST PRIMROSE LN FARR ST EAST AVE ARBOR WY TRAMWAY PL LINDA VISTA DR MIRA FLORES DR FLOWER ST FULKERTH RD TANAGER DR EASTGATE DR CARRIAGE CT BEL AIR CT DUQUESNE WY ACCESS N OLIVE AVE ALPHA RD NODA ST N GOLDEN STATE BLV S BERKELEY AVE RALEIGH CT BRISTOL PARK CI DAFFODIL LN LARKSPUR PL KIMBERLY SHEA DR 5TH ST CROWELL RD BLEVINS CT SWANPARK DR BURMAN DR DOGWOOD DR FULKERTH RD NORDIC WY ERIN WY VALDOSTA DR BUTTE WY WEST AVE SOUTH 7TH ST S ORANGE ST NORTH AVE W HAWKEYE AVE N 1ST ST MELONES DR LEERAE CT KATIE WY RAINER WY GARY ST N GOLDEN STATE BLV N 1ST ST ANNING DR AZUSA CT WILEY CT N BROADWAY AVE REGIS ST LANDER AVE ANGELUS ST PORSCHE STRASSE ASHLAND CT ST CAHILL AVE COOPER AVE WEST MAIN ST FOSBERG RD LYONS AVE E CANAL DR HIGH ST RADCLIFFE WY JOYNICHOLE DR CASTOR ST LEE AVE LEXINGTON AVE VILLANOVA DR NOBLE LN BLUETHROAT DR JORDAN AVE ALPHA RD CYNDA ST SOUTH AVE PARNELL AVE WILLIAMS AVE COLE AVE JEFFREY CT TELLURIDE LN TARTAN RD GEER RD ANNHURST AVE WILLIAMS AVE PARNELL AVE DR SOUTH AVE COLORADO AVE N QUINCY RD N OLIVE AVE LA SALLE DR TOKAY AVE HOGAN DR SOUTH AVE E HAWKEYE AVE W OLIVE AVE BRISTOL PARK CI KEVIN WY N QUINCY RD SOUTH AVE MURRAY ST BERNELL AVE DOW ST RUNYAN DR DELS LN KENWOOD AVE N DENAIR AVE DELS LN YALE AVE COLUMBIA ST E MAIN ST SIERRA ST N DAUBENBERGER RD SIERRA ST GEORGETOWN AVE E SYRACUSE AVE E MONTE VISTA AVE STARR AVE N OLIVE AVE N TULLY RD WY EL CAPITAN DR E HAWKEYE AVE DE PAUW DR N BERKELEY AVE W MONTE VISTA AVE ARBOR WY CLARK ST WABASH DR E CANAL DR E MARSHALL ST LANDER AVE ZINFANDEL LN CARRIGAN ST TOKAY AVE N JOHNSON RD ALMOND AVE EARLHAM DR S CENTER ST N OLIVE AVE ROCKFORD WY ESCONDIDO AVE E MONTE VISTA AVE N DENAIR AVE EL CAMINO DR BETHANY AVE WESTMINSTER LN PRIVATE RD E MONTE VISTA AVE D ST C ST SMITH DR SYCAMORE ST MERRITT ST ST JOETT DR E MARSHALL ST FLOWER ST FLORENCE ST COLORADO AVE W OLIVE AVE E CANAL DR S ORANGE ST BETHANY AVE NORTH AVE W F ST CARLETON DR N GOLDEN STATE BLV N DENAIR AVE PORTER WY N WALNUT RD MITCHELL AVE CLARK ST HEDSTROM RD E TUOLUMNE RD E OLIVE AVE BALL CT GEORGETOWN AVE MANTON AVE W TUOLUMNE RD S GOLDEN STATE BLV ALPHA RD WINDSOR CT SEBASTIAN DR 8TH ST CARMICHAEL WY 20TH CENTURY BLV 5TH ST SOUTH AVE SHERWOOD DR CAMELLIA ST FOREST DR E MINNESOTA AVE S 1ST ST S ROSE ST E HAWKEYE AVE COLUMBIA ST N JOHNSON RD 8TH ST MARIPOSA DR S MINARET AVE S ROSE ST ALPHA RD HIGH ST E MAIN ST NORTH AVE PARK ST STARR AVE E CANAL DR VENTURE LN CAMPBELL WY TAMMI WY PARK ST W TUOLUMNE RD N GOLDEN STATE BLV BIRCHWOOD WY VERMONT AVE PRIVATE RD (CENTURION PLAZA) S SODERQUIST RD WEST AVE SOUTH COLORADO AVE CROWELL RD VANDERBILT AVE N GOLDEN STATE BLV SUNSET DR CARLETON DR PRIVATE CT (ELIZABETH) BOTHUN RD DIVANIAN DR WALLACE ST S ROSE ST GEER RD PEDRAS RD E CANAL DR EL CAPITAN DR EL CAMINO DR GEER RD LESTER RD TAMPA ST MARLEE DR E MARSHALL ST S GOLDEN STATE BLV S CENTER ST N SODERQUIST RD ALASKA ST OPPELT WY MYERS WY EAST AVE JULIE AVE ESTATES DR S MINARET AVE GEER RD XAVIER AVE PEDRAS RD N PALM ST N DENAIR AVE ASHLAND AVE E MONTE VISTA AVE N OLIVE AVE HAYES DR ROCKWOOD AVE 20TH CENTURY BLV S MINARET AVE W HAWKEYE AVE N GOLDEN STATE BLV HAMMOND DR E HAWKEYE AVE EDWARD DR PIONEER AVE ANGELUS ST E MINNESOTA AVE S JOHNSON RD E TUOLUMNE RD DELS LN E MINNESOTA AVE N WARING RD WEST MAIN ST E MONTE VISTA AVE TORNELL AVE E MONTE VISTA AVE PENN AVE E HAWKEYE AVE EVELLE LN ANGELUS ST BRIER RD N BERKELEY AVE DELBON AVE E TUOLUMNE RD CALIFORNIA AVE EAST AVE S 1ST ST (Old) BRIER RD E HAWKEYE AVE N DAUBENBERGER RD N BROADWAY AVE LESTER RD HWY 99 (OFF RAMP) N S GOLDEN STATE BLV CHESTNUT ST HWY 99 UNIVERSITY CI PORSCHE STRASSE N OLIVE AVE HWY 99 N QUINCY RD W CANAL DR MARIPOSA DR W CANAL DR S QUINCY RD E MONTE VISTA AVE JULIAN ST E TUOLUMNE RD EAST AVE PAULSON RD MIDDLE DR S JOHNSON RD N SODERQUIST RD EAST AVE N GOLDEN STATE BLV N WARING RD LESTER RD S DAUBENBERGER RD E MONTE VISTA AVE N FRONT ST S TULLY RD S 1ST ST HWY 99 255 275 306 256 RIVER RD LAIRD ST HITO DR MARY ST WILSON ST W GRAYSON RD JESSIE ST MINNIE ST SMITH ST COX RD AMELIA ST MARTHA ST STAKES ST CHARLES ST YAMAMOTO WY 295 274 Grayson Del Rio Waterford Hickman Turlock City of Modesto Water System Well Off-Line for MCL or Action Level Well In Service ---PAGE BREAK--- ATTACHMENT C Detailed Construction Costs Based on Evaluations in Appendices D through J ---PAGE BREAK--- CIP CIP Line Item Cost with Recommendation Category Reason Size Quantity Unit Cost(b) Mark-ups(c) City-Side Improvements Related to Phase Two Expansion North Tank(d) 2 Supply 6 mg $0 $0 West Tank(d) 2 Supply 4 mg $0 $0 Industrial Tank(d) 2 Supply 4 mg $0 $0 North Tank Pump Station(d) 2 Supply 18 mgd $0 $0 West Tank Pump Station(d) 2 Supply 12 mgd $0 $0 Industrial Tank Pump Station(d) 2 Supply 12 mgd $0 $0 Virginia Corridor Transmissmion Main(d) 2 Supply $0 $0 Orangeburg Transmissmion Main(d) 2 Supply $0 $0 Yosemite Boulevard Transmissmion Main(d) 2 Supply $0 $0 Control Valves at MID Turnouts(d) 2 Supply 35 valves $0 $0 $0 $0 New Well Mildred Perkins Well(f) 10 Supply 1,500 gpm $821,300 $1,232,000 $821,300 $1,232,000 Purchase and Install Backup Generators Well 001, 004, 007, 016, 050, 058, 100, 213, 217, 232, 237, 241, 267, 278, 284, and 312 12 Storage $2,133,000 $3,200,000 $2,133,000 $3,200,000 Transmission Grid Improvement Pipeline Recommendations (Strengthen and Replace Water System) Veneman Avenue between Covenant Avenue and Sash Court 9 Grid 12 inch 830 feet $113,000 $169,500 Along Standiford Avenue between Carver Avenue and McHenry Avenue 9 Grid 12 inch 13,170 feet $1,796,000 $2,694,000 Along Sylvan Avenue between McHenry Avenue and Coffee Road 9 Grid 12 inch 4,970 feet $678,000 $1,017,000 Sylvan Avenue between Palmwood Drive and Oakdale Road 9 Grid 12 inch 1,990 feet $271,000 $406,500 Along Sisk Road between Rumble Road and Orangeburg Avenue 9 Grid 12 inch 14,100 feet $1,922,000 $2,883,000 Along Orangeburg Avenue between Sisk Road and Carver Avenue 9 Grid 12 inch 1,050 feet $143,000 $214,500 Along Carver Avenue between Standiford Avenue and Orangeburg Avenue 9 Grid 12 inch 9,210 feet $1,256,000 $1,884,000 Along Coffee Road between Standiford Avenue and Scenic Drive 9 Grid 12 inch 12,730 feet $1,735,000 $2,602,500 Along Scenic Drive between Coffee Road and Claus Road 9 Grid 12 inch 17,210 feet $2,346,000 $3,519,000 Along Claus Road between Briggsmore Avenue and Scenic Drive 9 Grid 12 inch 3,340 feet $455,000 $682,500 Along Roselle Avenue between Floyd Avenue and Scenic Drive 9 Grid 12 inch 8,440 feet $1,151,000 $1,726,500 Along Morris Avenue between Coffee Road and Bodem Street 9 Grid 12 inch 2,900 feet $396,000 $594,000 Along Scenic Drive between Burney Street and Bodem Street 9 Grid 12 inch 1,150 feet $157,000 $235,500 Along Bodem Street between Morris Avenue and Scenic Avenue 9 Grid 12 inch 1,500 feet $205,000 $307,500 Along Burney Street between Downey Avenue and G Street 9 Grid 12 inch 670 feet $91,000 $136,500 Along Paradise Road between Chicago Avenue and Sutter Avenue 9 Grid 12 inch 1,260 feet $172,000 $258,000 Along Paradise Road between Chicago Avenue and 1st Street 9 Grid 12 inch 1,680 feet $229,000 $343,500 Along H Street between 1st Street and 8th Street 9 Grid 12 inch 2,490 feet $339,000 $508,500 Along Robertson Road between Vernon Avenue and Sutter Avenue 9 Grid 12 inch 4,700 feet $641,000 $961,500 Along Kansas Avenue between Carpenter Road and 9th Street 9 Grid 12 inch 8,490 feet $1,158,000 $1,737,000 Along Carpenter Road between Blue Gum Avenue and California Avenue 9 Grid 12 inch 10,650 feet $1,452,000 $2,178,000 Along Ustick Road between Hatch Road and Boise Avenue 9 Grid 12 inch 2,680 feet $365,000 $547,500 $17,071,000 $25,606,500 Peak Hour Improvement Pipeline Recommendations (Strengthen and Replace Water System) Santa Rosa Avenue between Mono Drive and Oregon Drive 9 Pressure 8 inch 1,670 feet $168,000 $252,000 Oregon Drive between Santa Rosa Avenue and Santa Rita Avenue 9 Pressure 8 inch 510 feet $51,000 $76,500 Beverly Drive between Victoria Drive and Picardy Drive 9 Pressure 8 inch 450 feet $45,000 $67,500 Alley between Victoria Drive and Vernon Avenue between Victoria Drive and Beverly Drive 9 Pressure 8 inch 870 feet $87,000 $130,500 Paradise Avenue between Alturas Avenue and Sutter Avenue 9 Pressure 8 inch 510 feet $51,000 $76,500 Paradise Avenue east of Vernon Avenue 9 Pressure 8 inch 130 feet $13,000 $19,500 $415,000 $622,500 Maximum Day plus Fire Flow Improvement Pipeline Recommendations (Strengthen and Replace Along Wylie Drive east of Brighton Avenue 9 Fireflow 8 inch 90 feet $9,000 $13,500 Along Brighton Avenue between Wylie Drive and Scenic Drive (East Side of Street) 9 Fireflow 8 inch 2,990 feet $301,000 $451,500 County Center 3 Court north of Scenic Drive 9 Fireflow 8 inch 1,010 feet $102,000 $153,000 Vista Drive between Dorchester Avenue and Rio Vista Drive 9 Fireflow 8 inch 590 feet $59,000 $88,500 Dorchester Avenue between Vista Drive and Devonshire Avenue 9 Fireflow 8 inch 1,120 feet $113,000 $169,500 Havasu Drive between Wild Palms Drive and East Orangeburg Avenue 9 Fireflow 8 inch 1,010 feet $102,000 $153,000 Wild Palms Drive between Fransen Lane and Havasu Drive 9 Fireflow 8 inch 1,210 feet $122,000 $183,000 Palmdale Drive between Wild Palms Drive and East Orangeburg Avenue 9 Fireflow 8 inch 1,010 feet $102,000 $153,000 Fransen Lane between Wild Palms Drive and East Orangeburg Avenue 9 Fireflow 8 inch 1,020 feet $103,000 $154,500 Wycliffe Drive south of Scenic Drive 9 Fireflow 8 inch 1,200 feet $121,000 $181,500 La Loma Avenue between Rowland Avenue and Covena Avenue 9 Fireflow 10 inch 400 feet $49,000 $73,500 La Loma Avenue between Santa Barbara Avenue and Rowland Avenue 9 Fireflow 8 inch 1,150 feet $116,000 $174,000 Pirinen Lane between Pamplona Way and Penny Lane 9 Fireflow 8 inch 1,010 feet $102,000 $153,000 Pamplona Way between Capistrano Drive and Pirinen Lane 9 Fireflow 8 inch 700 feet $70,000 $105,000 Capistrano Drive between Pamplona Way and Penny Lane 9 Fireflow 8 inch 660 feet $66,000 $99,000 Tyson Street between Church Street and Downing Lane 9 Fireflow 8 inch 870 feet $87,000 $130,500 Intertie at Intersection of Tyson Street and Church Street between Pipelines along Church Street 9 Fireflow 8 inch 20 feet $2,000 $3,000 Along McCoy Avenue east of Church Street (Connect Pipelines along Church Street) 9 Fireflow 8 inch 10 feet $1,000 $1,500 Along Third Street west of Church Street (Connect Pipelines along Church Street) 9 Fireflow 8 inch 30 feet $3,000 $4,500 Alley between Imperial Avenue and Inyo Avenue between Tucson Avenue and Rutherford Street 9 Fireflow 8 inch 1,650 feet $166,000 $249,000 Avenue between Crater Avenue and Hatch Road 9 Fireflow 8 inch 2,960 feet $298,000 $447,000 Along Imperial Avenue immediately west of Crows Landing Avenue 9 Fireflow 8 inch 350 feet $35,000 $52,500 West of Crows Landing Avenue between Glenn Avenue and Imperial Avenue 9 Fireflow 8 inch 480 feet $48,000 $72,000 Herndon Road between Eugene Avenue and Joyce Avenue 9 Fireflow 10 inch 1,000 feet $123,000 $184,500 Alley between Concord Avenue and College Avenue between Granger Avenue and Pearl Street 9 Fireflow 8 inch 620 feet $62,000 $93,000 Pearl Street between Concord Avenue and Bronson Avenue 9 Fireflow 8 inch 940 feet $94,000 $141,000 Stoddard Avenue between Orange Avenue and Virginia Avenue 9 Fireflow 8 inch 190 feet $19,000 $28,500 Bennett Avenue between Elm Avenue and Laurel Avenue 9 Fireflow 8 inch 510 feet $51,000 $76,500 Alley between 4th and 5th Street between Washington Street and Sierra Lane 9 Fireflow 8 inch 3,560 feet $358,000 $537,000 Loma Vista Way between Morton Boulevard and Kelley Street 9 Fireflow 8 inch 650 feet $65,000 $97,500 Kelley Street between James Street and Loma Vista Way 9 Fireflow 8 inch 440 feet $44,000 $66,000 Pleasant Street between Kelley Street and Jennie Street 9 Fireflow 8 inch 1,660 feet $166,000 $249,000 Along Roseburg Avenue east of McHenry Avenue to Existing Pipeline 9 Fireflow 10 inch 120 feet $15,000 $22,500 Along Palm Avenue east of McHenry Avenue to Existing Pipeline 9 Fireflow 8 inch 30 feet $3,000 $4,500 Along Corson Avenue east of McHenry Avenue to Existing Pipeline 9 Fireflow 8 inch 100 feet $10,000 $15,000 Along Fairmont Avenue east of McHenry Avenue to Existing Pipeline 9 Fireflow 8 inch 330 feet $33,000 $49,500 Palm Avenue between McHenry Avenue and Ila Way 9 Fireflow 8 inch 680 feet $68,000 $102,000 Ila Way between Palm Avenue and Corson Avenue 9 Fireflow 8 inch 320 feet $32,000 $48,000 Rose Avenue between Palm Avenue and Corson Avenue 9 Fireflow 8 inch 340 feet $34,000 $51,000 Corson Avenue between McHenry Avenue and Melrose Avenue 9 Fireflow 8 inch 2,210 feet $222,000 $333,000 Kimble Street between Corson Avenue and Fairmont Avenue 9 Fireflow 8 inch 570 feet $57,000 $85,500 Fairmont Avenue between McHenry Avenue and Patricia Lane 9 Fireflow 8 inch 1,210 feet $122,000 $183,000 Patricia Lane between Fairmont Avenue and Hintze Avenue 9 Fireflow 8 inch 690 feet $69,000 $103,500 Vecino Avenue between Fairmont Avenue and Morris Avenue 9 Fireflow 8 inch 1,860 feet $187,000 $280,500 Claremont Avenue between Sylvan Avenue and Dyer Lane 9 Fireflow 8 inch 180 feet $18,000 $27,000 Dyer Lane between Norton Avenue and Claremont Avenue 9 Fireflow 8 inch 240 feet $24,000 $36,000 $4,053,000 $6,079,500 Grand Total $24,493,000 $36,741,000 Table C1. Detailed CIP Recommendations from Existing System Evaluation for Existing Contiguous Service Area(a) City-Side Improvements Related to Phase Two Expansion Subtotal New Well Subtotal Backup Generator Subtotal Transmission Grid Improvement Subtotal Peak Hour Improvement Subtotal Project partially completed. Planned for completion in City FY 2009/2010 CIP. Cost includes generator installation. Maximum Day plus Fire Flow Improvement Subtotal Recommendations based on Existing System Evaluation presented in Appendix D. Costs based on March 2010 San Francisco Engineering News Record (ENR) Index (9728.17). Soft cost and contingency mark-ups of 50% include: construction contingency engineering construction management and program implementation Cost listed as part of City's 2009-2038 CIP spreadsheet (included as Attachment Funding for project provided by developer. West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3AttC Last Revised: 04-10-10 1 of 1 City of Modesto Engineer's Report Attachment C ---PAGE BREAK--- CIP CIP Line Item Cost with Recommendation Category Reason Size Quantity Unit Cost(b) Mark-ups(c) City-Side Improvements Related to TID South Modesto Terminal Tank 18 City TID 10.0 mg $13,760,000 $20,640,000 South Modesto Terminal Tank Pump Station 18 City TID 11.5 mgd $2,028,000 $3,042,000 Whitmore Avenue between Morgan Road and Crows Landing Road 3A City TID 24 inch 5,540 feet $1,205,000 $1,807,500 Whitmore Avenue between Crows Landing Road and Carpenter Road 3A City TID 16 inch 10,630 feet $1,727,000 $2,590,500 Carpenter Road between Hatch Road and Whitmore Avenue 3A City TID 16 inch 4,710 feet $765,000 $1,147,500 TID Connection to Distribution 3A City TID 16 inch 60 feet $10,000 $15,000 TID Connection to Distribution 3A City TID 12 inch 190 feet $26,000 $39,000 $19,521,000 $29,281,500 New Water Tank North Modesto Tank 18 Storage 5.0 mg $6,880,000 $10,320,000 North Modesto Tank Booster Pump Station 18 Storage 10.0 MGD $1,940,000 $2,910,000 $8,820,000 $13,230,000 New Wells Tivoli Well(d) 10 Supply $0 $0 FMC Well(d) 10 Supply $0 $0 Grogan Well(d) 10 Supply 1,000 gpm $0 $0 Plastipak Well(d) 10 Supply 1,000 gpm $0 $0 Shelter Cove Well 10 Supply 1,000 gpm $0 $0 SOI 1 Well 10 Supply 1,500 gpm $1,333,000 $2,000,000 $1,333,000 $2,000,000 Purchase and Install Backup Generators Wells 010, 017, 036, 045, 047, 048, 056, 204, 211, 216, 247, 250, 259, 262, 264, 265, 281, 291, 292 and 307 12 Storage $2,667,000 $4,000,000 $2,667,000 $4,000,000 Transmission Grid Improvement Pipeline Recommendations (Extend Water Mains) Kiernan Avenue between Stoddard Road and Dale Road 8 Grid 16 5,320 feet $865,000 $1,297,500 Kiernan Avenue between Dale Avenue and American Avenue 8 Grid 16 1,280 feet $208,000 $312,000 Technology Drive between Stoddard Road and Dale Road 8 Grid 12 3,630 feet $495,000 $742,500 Bangs Avenue between American Avenue and Carver Road 8 Grid 12 2,560 feet $714,000 $1,071,000 Bangs Avenue between Stoddard Road and Chapman Road 8 Grid 12 1,690 feet $230,000 $345,000 Chapman Road between Bangs Avenue and Kiernan Avenue 8 Grid 12 2,580 feet $352,000 $528,000 Dale Road south of Kiernan Avenue 8 Grid 12 150 feet $20,000 $30,000 Kiernan Avenue between American Avenue and Terminal Avenue 8 Grid 12 34,980 feet $4,769,000 $7,153,500 East of Morrow Road between Kiernan Avenue and Avignon Lane 8 Grid 12 2,520 feet $344,000 $516,000 Carver Road between Kiernan Avenue and Avignon Lane 8 Grid 12 2,630 feet $359,000 $538,500 Tully Road between Kiernan Avenue and Avignon Lane 8 Grid 12 3,050 feet $416,000 $624,000 East of Tully Road between Kiernan Avenue and Avignon Lane 8 Grid 12 2,700 feet $368,000 $552,000 Henry Avenue between Claribel Avenue and Bangs Avenue 8 Grid 12 1,240 feet $169,000 $253,500 East of Henry Avenue between Claribel Avenue and Claratina Avenue 8 Grid 12 2,600 feet $354,000 $531,000 Coffee Road between Claribel Avenue and Claratina Avenue 8 Grid 12 2,640 feet $360,000 $540,000 Coffee Road between Claribel Avenue and Bangs Avenue 8 Grid 12 1,300 feet $177,000 $265,500 Oakdale Road between Claribel Avenue and Claratina Avenue 8 Grid 12 3,930 feet $536,000 $804,000 East of Oakdale Road between Claribel Avenue and Claratina Avenue 8 Grid 12 3,970 feet $541,000 $811,500 Roselle Avenue between Claribel Avenue and Plainview Road 8 Grid 12 670 feet $91,000 $136,500 Roselle Avenue south of Plainview Road 8 Grid 16 2,630 feet $427,000 $640,500 Roselle Avenue between Sylvan Avenue and Claratina Avenue 8 Grid 16 4,000 feet $650,000 $975,000 Plainview Road between McHenry Avenue and Oakdale Road 8 Grid 12 10,520 feet $1,434,000 $2,151,000 Plainview Road between Oakdale Road and Litt Road 8 Grid 16 7,930 feet $1,289,000 $1,933,500 Mabel Avenue between Roselle Avenue and Litt Road 8 Grid 12 2,890 feet $394,000 $591,000 Litt Road between Claribel Avenue and Sylvan Avenue 8 Grid 12 6,840 feet $933,000 $1,399,500 Terminal Avenue between Parker Road and Plainview Avenue 8 Grid 12 14,210 feet $1,937,000 $2,905,500 Hillglen Avenue between Roselle Avenue and Esta Avenue 8 Grid 10 1,320 feet $162,000 $243,000 Floyd Avenue between Claus Road and Santa Fe Avenue 8 Grid 12 1,150 feet $157,000 $235,500 Meryl Avenue between Claus Road and Santa Fe Avenue 8 Grid 12 1,910 feet $260,000 $390,000 Morse Avenue between McDonald Avenue and Brink Avenue 8 Grid 12 6,080 feet $829,000 $1,243,500 Morse Road between McDonald Avenue and Kansas Avenue 8 Grid 12 6,110 feet $833,000 $1,249,500 Shoemaker Avenue between Morse Avenue and Brink Avenue 8 Grid 12 2,990 feet $408,000 $612,000 Brink Avenue between Shoemaker Avenue and north of North Avenue 8 Grid 16 5,680 feet $923,000 $1,384,500 Nebraska Avenue between Kansas Avenue and Maze Boulevard 8 Grid 16 2,670 feet $434,000 $651,000 Maze Boulevard between Rosemore Avenue and Carpenter Road 8 Grid 12 2,710 feet $369,000 $553,500 Maze Boulevard between Rosemore Avenue and Carpenter Road 8 Grid 16 2,660 feet $432,000 $648,000 Woodland Avenue between Morse Road and Carpenter Road 8 Grid 12 5,300 feet $723,000 $1,084,500 Grimes Avenue between Maze Boulevard and California Avenue 8 Grid 12 5,610 feet $765,000 $1,147,500 Grimes Avenue between Chicago Avenue and Paradise Road 8 Grid 12 2,950 feet $402,000 $603,000 Paradise Road between Grimes Avenue and Ohio Avenue 8 Grid 12 2,740 feet $374,000 $561,000 California Avenue between Grimes Avenue and Carpenter Road 8 Grid 12 4,010 feet $547,000 $820,500 Ohio Avenue between Chicago Avenue and California Avenue 8 Grid 12 2,580 feet $352,000 $528,000 Ohio Avenue between Chicago Avenue and Paradise Road 8 Grid 12 2,560 feet $349,000 $523,500 Houser Lane between Ohio Avenue and Carpenter Road 8 Grid 12 1,370 feet $187,000 $280,500 Parkdale Drive 8 Grid 12 1,130 feet $154,000 $231,000 Vivian Road between Whitmore Avenue and Hatch Road 8 Grid 12 4,900 feet $668,000 $1,002,000 Whitmore Avenue between Vivian Road and Carpenter Road 8 Grid 12 5,290 feet $721,000 $1,081,500 Carpenter Road north of Whitmore Avenue 8 Grid 12 2,190 feet $299,000 $448,500 Whitmore-Carpenter Development 8 Grid 12 11,710 feet $1,596,000 $2,394,000 North of Hatch Road and west of Carpenter Road(e) 8 Grid 10 8,350 feet $0 $0 North of Hatch Road and west of Carpenter Road(e) 8 Grid 8 7,150 feet $0 $0 SOI Buildout Pipelines for Empire Region 8 Grid 12 27,830 feet $3,794,000 $5,691,000 $34,170,000 $51,255,000 Table C2. Detailed CIP Recommendations for Buildout Contiguous Service Area(a) City-Side Improvements Related to TID Subtotal New Water Tank Subtotal New Well Subtotal Backup Generator Subtotal Transmission Grid Subtotal West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3erAttC Last Revised: 04-10-10 1 of 3 City of Modesto Engineer's Report Attachment C ---PAGE BREAK--- CIP CIP Line Item Cost with Recommendation Category Reason Size Quantity Unit Cost(b) Mark-ups(c) Table C2. Detailed CIP Recommendations for Buildout Contiguous Service Area(a) Development Pipeline Recommendations (Extend Water Mains) Kiernan Business Park East Development(d) 8 12 inch 10,370 feet $0 $0 Promenade Development(d) 8 12 inch 6,680 feet $0 $0 Kaiser Medical Center Development(d) 8 12 inch 6,710 feet $0 $0 Kaiser Medical Center Development(d) 8 16 inch 3,700 feet $0 $0 Kiernan Business Park South Development(d) 8 12 inch 4,920 feet $0 $0 Woodglen Development(d) 8 12 inch 20,840 feet $0 $0 Woodglen Development(d) 8 10 inch 80 feet $0 $0 Woodglen Development(d) 8 8 inch 690 feet $0 $0 Pelandale-McHenry Development(d) 8 10 inch 4,950 feet $0 $0 Pelandale-McHenry Development(d) 8 8 inch 4,740 feet $0 $0 Martin Development(d) 8 16 inch 960 feet $0 $0 Martin Development(d) 8 12 inch 100 feet $0 $0 Martin Development(d) 8 10 inch 3,630 feet $0 $0 Martin Development(d) 8 8 inch 1,870 feet $0 $0 Tivoli Development(d) 8 16 inch 10,710 feet $0 $0 Tivoli Development(d) 8 12 inch 21,290 feet $0 $0 Ninth and Carver Development(d) 8 10 inch 4,140 feet $0 $0 Kansas-Woodland Development(d) 8 12 inch 3,330 feet $0 $0 Kansas-Woodland Development(d) 8 10 inch 1,630 feet $0 $0 Westport Landing Development(d) 8 12 inch 12,710 feet $0 $0 Westport Landing Development(d) 8 8 inch 13,900 feet $0 $0 Bava Brothers Development(d) 8 12 inch 1,850 feet $0 $0 Bava Brothers Development(d) 8 8 inch 5,920 feet $0 $0 $0 $0 Peak Hour and Maximum Day Plus Fire Flow South Modesto Pipeline Improvements (Strengthen and Replace Water System) Clayton Avenue between Carver Road and North 9th Street(e) 9 Pressure 12 inch 1,890 feet $0 $0 North 9th Street between Clayton Avenue and Culpepper Avenue(e) 9 Pressure 12 inch 890 feet $0 $0 Blue Gum Avenue between Culpepper Avenue and Carpenter Avenue(e) 9 Pressure 12 inch 970 feet $0 $0 Carpenter Road from Blue Gum Avenue to south of Moccasin Drive 9 Pressure 12 inch 7,100 feet $966,929 $1,450,393 Woodland Avenue between Carpenter Road and North 9th Street 9 Pressure 12 inch 4,160 feet $566,539 $849,808 Beverly Drive between alley west of Normandy Drive and west of Ritsch Lane 9 Pressure 8 inch 1,080 feet $108,864 $163,296 Alley between Ridge Road and Robertson Road from west of Dunning Lane to east of Hilltop Lane 9 Pressure 8 inch 970 feet $97,776 $146,664 Paradise Road near intersection with Vernon Avenue 9 Pressure 8 inch 130 feet $13,104 $19,656 Paradise Avenue between Martin Luther King Drive and Madison Street 9 Pressure 8 inch 510 feet $51,408 $77,112 Santa Rosa Avenue between Mono Drive and Oregon Drive 9 Pressure 8 inch 1,670 feet $168,336 $252,504 Oregon Drive between Santa Rosa Avenue and Santa Rita Avenue 9 Pressure 8 inch 510 feet $51,408 $77,112 Santa Rita Avenue between Mono Drive and Tenaya Drive 9 Pressure 8 inch 1,670 feet $85,680 $128,520 Along Carpenter Road between Kansas Avenue and Elm Avenue 9 Pressure 12 inch 510 feet $141,635 $212,452 Along Vernon Avenue between Chicago Avenue and Beverly Drive 9 Pressure 8 inch 850 feet $204,624 $306,936 Along Carpenter Road between Chicago Avenue and Beverly Drive 9 Pressure 8 inch 1,040 feet $89,712 $134,568 Along Beverly Drive between Carpenter Road and Giahos Avenue 9 Pressure 8 inch 2,030 feet $9,072 $13,608 Along Beverly Drive between Vernon Avenue and Picardy Drive 9 Pressure 8 inch 890 feet $128,016 $192,024 Along Vernon Avenue north of Robertson Road 9 Pressure 8 inch 90 feet $59,472 $89,208 Between Hilltop Lane and Vernon Avenue south of Manor Drive 9 Pressure 8 inch 1,270 feet $77,616 $116,424 Along Dunning Lane between Paradise Road and Robertson Road 9 Pressure 8 inch 590 feet $57,456 $86,184 Along Paradise Road between Ohio Avenue and Dunning Lane 9 Pressure 8 inch 770 feet $18,144 $27,216 Between Rosemore Avenue and Avondale Avenue 9 Fireflow 8 inch 390 feet $39,312 $58,968 Between Avondale Avenue and Greenlawn Avenue 9 Fireflow 8 inch 490 feet $49,392 $74,088 Between Greenlawn Avenue and Woodlane Avenue 9 Fireflow 8 inch 410 feet $41,328 $61,992 West of Woodlane Avenue between Parkdale Drive and Riverdale Avenue 9 Fireflow 8 inch 250 feet $25,200 $37,800 Along Conrad Way west of Ustick Road 9 Fireflow 8 inch 800 feet $80,640 $120,960 Along Dalby Court 9 Fireflow 8 inch 360 feet $36,288 $54,432 Alley north of Glenn Avenue between Tucson Avenue and Ustick Road 9 Fireflow 8 inch 850 feet $85,680 $128,520 Alley between Glenn Avenue and Imperial Avenue between Tucson Avenue and Rutherford Street 9 Fireflow 8 inch 800 feet $80,640 $120,960 Alley between Imperial Avenue and Inyo Avenue between Tucson Avenue and Mt. Oso Way 9 Fireflow 8 inch 3,990 feet $402,192 $603,288 Mt. Oso Way between Inyo Avenue and Lassen Avenue 9 Fireflow 8 inch 330 feet $33,264 $49,896 Alley between Inyo Avenue and Lassen Avenue between Tucson Avenue and Mt. Oso Way 9 Fireflow 8 inch 3,770 feet $380,016 $570,024 Alley between Lassen Avenue and Marin Avenue between Tucson Avenue and west of Dallas Street 9 Fireflow 8 inch 4,150 feet $418,320 $627,480 Alley between Glenn Avenue and Imperial Avenue between Guthrie Street and alley west of Crows Landing 9 Fireflow 8 inch 2,990 feet $301,392 $452,088 Alley west of Crows Landing Road between Glenn Avenue and Imperial Avenue 9 Fireflow 8 inch 480 feet $48,384 $72,576 Imperial Avenue from Dallas Street to Crows Landing Road 9 Fireflow 8 inch 2,310 feet $232,848 $349,272 Alley between Marin Avenue and Modoc Avenue between Tucson Avenue and Ustick Road 9 Fireflow 8 inch 720 feet $72,576 $108,864 Alley between Modoc Avenue and Placer Avenue between Tucson Avenue and Ustick Road 9 Fireflow 8 inch 720 feet $72,576 $108,864 Alley between Placer Avenue and Plumas Avenue between Tucson Avenue and Ustick Road 9 Fireflow 8 inch 770 feet $77,616 $116,424 Alley between Plumas Avenue and Whitmore Avenue between Tucson Avenue and Ustick Road 9 Fireflow 8 inch 720 feet $72,576 $108,864 Algen Avenue between Mt. McKinley Court and Crows Landing Road 9 Fireflow 8 inch 800 feet $80,640 $120,960 Along Mt. McKinley Court 9 Fireflow 8 inch 530 feet $53,424 $80,136 Along Mt. Whitney Court 9 Fireflow 8 inch 540 feet $54,432 $81,648 Along Mt. Everest Court 9 Fireflow 8 inch 520 feet $52,416 $78,624 Along Mt. Hood Court 9 Fireflow 8 inch 520 feet $52,416 $78,624 Along Algen Court 9 Fireflow 8 inch 520 feet $52,416 $78,624 Guthrie Street between Glenn Avenue and Imperial Way 9 Fireflow 8 inch 190 feet $19,152 $28,728 Alley between Las Vegas Street and Dallas Street between Butte Avenue and Glenn Avenue 9 Fireflow 8 inch 1,280 feet $129,024 $193,536 Olivero Road between Crow Landing and Jim Way 9 Fireflow 8 inch 2,480 feet $249,984 $374,976 Along western portion of Kendee Road 9 Fireflow 8 inch 340 feet $34,272 $51,408 West of Crows Landing Road between Kendee Road to north of Crater Avenue 9 Fireflow 8 inch 330 feet $33,264 $49,896 Alley north of Crater Avenue between Cascade Avenue and Avenue 9 Fireflow 8 inch 620 feet $62,496 $93,744 Avenue between alley north of Crater Avenue and alley north of Hatch Road 9 Fireflow 8 inch 720 feet $72,576 $108,864 Alley between Crater Avenue and Glacier Avenue between Cascade Avenue and Avenue 9 Fireflow 8 inch 650 feet $65,520 $98,280 Alley between Glacier Avenue and Hatch Road between Cascade Avenue and Avenue 9 Fireflow 8 inch 620 feet $62,496 $93,744 Pipelines in Area between Wells 29 and 30 9 Fireflow 8 inch 2,780 feet $280,224 $420,336 Connection between existing pipelines in area between Wells 29 and 30 to Zeff Road 9 Fireflow 8 inch 80 feet $8,064 $12,096 Sonora Avenue between 9th Street and Janopaul Lane 9 Fireflow 8 inch 850 feet $85,680 $128,520 Pipelines in Industrial Area between Hosmer Avenue and River Road west of South 9th Street 9 Fireflow 10 inch 2,670 feet $326,399 $489,598 Souza Avenue between Road and Avon Street 9 Fireflow 8 inch 1,300 feet $131,040 $196,560 Ryder Way between River Road and Souza Avenue 9 Fireflow 8 inch 860 feet $86,688 $130,032 Development Pipeline Subtotal West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3erAttC Last Revised: 04-10-10 2 of 3 City of Modesto Engineer's Report Attachment C ---PAGE BREAK--- CIP CIP Line Item Cost with Recommendation Category Reason Size Quantity Unit Cost(b) Mark-ups(c) Table C2. Detailed CIP Recommendations for Buildout Contiguous Service Area(a) Alley north of Lombardo Avenue between Road and Perfidia Street 9 Fireflow 8 inch 1,310 feet $132,048 $198,072 Alley between Lombardo Avenue and Sonora Avenue between Road and Perfidia Street 9 Fireflow 8 inch 2,980 feet $300,384 $450,576 Anthony Avenue between alley south of Lombardo Avenue and Sonora Avenue 9 Fireflow 8 inch 350 feet $35,280 $52,920 Romeo Avenue between alley south of Lombardo Avenue and Sonora Avenue 9 Fireflow 8 inch 350 feet $35,280 $52,920 Perfidia Street between alley south of Lombardo Avenue and Sonora Avenue 9 Fireflow 8 inch 340 feet $34,272 $51,408 Sonora Avenue between Road and Avon Street 9 Fireflow 8 inch 1,510 feet $152,208 $228,312 Acadia Street between Pecos Avenue and Bewley Avenue 9 Fireflow 8 inch 680 feet $68,544 $102,816 Alley between Pecos Avenue and Vito Avenue between Leo Avenue and Herndon Road 9 Fireflow 8 inch 450 feet $45,360 $68,040 Alley between Vito Avenue and Sam Avenue between Leo Avenue and Herndon Road 9 Fireflow 8 inch 670 feet $67,536 $101,304 Alley between Sam Avenue and Nadine Avenue between Leo Avenue and Herndon Road 9 Fireflow 8 inch 920 feet $92,736 $139,104 Alley between Nadine Avenue and Eugene Avenue between Leo Avenue and Herndon Road 9 Fireflow 8 inch 830 feet $83,664 $125,496 Alley between Eugene Avenue and Joyce Avenue between Leo Avenue and Herndon Road 9 Fireflow 8 inch 520 feet $52,416 $78,624 Herndon Road between Eugene Avenue and Herndon Court 9 Fireflow 8 inch 1,000 feet $100,800 $151,200 Alley west of Herndon Road between Joyce Avenue and Herndon Court 9 Fireflow 8 inch 620 feet $62,496 $93,744 Leo Avenue between Sam Avenue and Road 9 Fireflow 8 inch 160 feet $16,128 $24,192 Road between alley south of Joyce Avenue and dead end at north 9 Fireflow 8 inch 2,190 feet $220,752 $331,128 9th Street south of Pecos Avenue 9 Fireflow 10 inch 2,630 feet $321,509 $482,263 Acadia Street between Valente Way and Pecos Avenue 9 Fireflow 8 inch 380 feet $38,304 $57,456 Valencia Street between Valente Way and Pecos Avenue 9 Fireflow 8 inch 390 feet $39,312 $58,968 Sanchez Way and Stone Leaf Court 9 Fireflow 8 inch 540 feet $54,432 $81,648 $9,392,109 $14,088,000 Grand Total (rounded) $75,903,000 $113,855,000 Pipeline is existing and does not require construction. South Modesto Pipeline Improvements Subtotal Recommendations based on Existing System Evaluation presented in Appendix D. Costs based on March 2010 San Francisco Engineering News Record (ENR) Index (9728.17). Soft cost and contingency mark-ups of 50% include: construction contingency engineering construction management and program implementation (10%) Funding for project provided by developer. West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3erAttC Last Revised: 04-10-10 3 of 3 City of Modesto Engineer's Report Attachment C ---PAGE BREAK--- CIP CIP Recommendation Category Reason Size Quantity Unit Line Item(b) With Mark-ups(c) Line Item(b) With Mark-ups(c) Line Item(b) With Mark-ups(c) New Water Tanks - Del Rio Del Rio Storage Tank 18 Storage 0.23 mg Del Rio Storage Tank Booster Pump Station 18 Storage 2.0 mgd 1,080,000 $ 1,620,000 $ 787,000 $ 1,180,000 $ 1,867,000 $ 2,800,000 $ New Water Tanks - Hickman Hickman Storage Tank 18 Storage 0.40 mg Hickman Storage Tank Booster Pump Station 18 Storage 72 bhp 1,867,000 $ 2,800,000 $ - $ - $ 1,867,000 $ 2,800,000 $ New Water Tanks - Waterford Waterford Storage Tank 18 Storage 0.66 mg Waterford Storage Tank Booster Pump Station 18 Storage 2.0 mgd 2,400,000 $ 3,600,000 $ - $ - $ 2,400,000 $ 3,600,000 $ New Well - Del Rio New Del Rio Well with Backup Generator 10 Supply 1,000 gpm 666,000 $ 1,000,000 $ 667,000 $ 1,000,000 $ 1,333,000 $ 2,000,000 $ Replacement Well for Well 271 with Backup Generator 10 Supply 1,200,000 $ 1,800,000 $ - $ 1,200,000 $ 1,800,000 $ 1,866,000 $ 2,800,000 $ 667,000 $ 1,000,000 $ 2,533,000 $ 3,800,000 $ New Well - Grayson New Grayson Well with Backup Generator 10 Supply 400 gpm 1,333,000 $ 2,000,000 $ - $ 1,333,000 $ 2,000,000 $ 1,333,000 $ 2,000,000 $ - $ - $ 1,333,000 $ 2,000,000 $ New Well - Hickman New Hickman Well with Backup Generator 10 Supply 600 gpm 1,333,000 $ 2,000,000 $ - $ 1,333,000 $ 2,000,000 $ 1,333,000 $ 2,000,000 $ - $ - $ 1,333,000 $ 2,000,000 $ New Well - Waterford New Waterford Well with Backup Generator(d) 10 Supply 700 gpm - $ 1,333,000 $ 2,000,000 $ 1,333,000 $ 2,000,000 $ - $ - $ 1,333,000 $ 2,000,000 $ 1,333,000 $ 2,000,000 $ Rehabilitate Existing Well - Turlock Rehabilitate Well 255 11 Supply 551,000 $ 826,500 $ - $ 551,000 $ 826,500 $ 551,000 $ 826,500 $ - $ - $ 551,000 $ 826,500 $ Backup Generators - Grayson Well 274 12 133,000 $ 200,000 $ - $ 133,000 $ 200,000 $ Tank 9 Booster Pump #1 12 133,000 $ 200,000 $ - $ 133,000 $ 200,000 $ 266,000 $ 400,000 $ - $ - $ 266,000 $ 400,000 $ Backup Generators - Hickman Well 309 12 133,000 $ 200,000 $ - $ 133,000 $ 200,000 $ 133,000 $ 200,000 $ - $ - $ 133,000 $ 200,000 $ Backup Generators - Turlock Wells 255, 256, 275, 306 12 533,000 $ 800,000 $ - $ 533,000 $ 800,000 $ 533,000 $ 800,000 $ - $ - $ 533,000 $ 800,000 $ Backup Generators - Waterford Well 242, 244, 245, 286 12 533,000 $ 800,000 $ - $ 533,000 $ 800,000 $ 533,000 $ 800,000 $ - $ - $ 533,000 $ 800,000 $ Pump Station Improvements - Grayson Tank 9 Booster Pump 100 HP expansion 12 1,022,000 $ 1,533,000 $ - $ 1,022,000 $ 1,533,000 $ 1,022,000 $ 1,533,000 $ - $ - $ 1,022,000 $ 1,533,000 $ Pipeline Improvement Recommendations - Del Rio (Strengthen and Replace Water Mains) Carver Road between Riveroaks Drive and Thunderbird Drive 9 Fireflow 8 inch 230 feet 23,000 $ 34,500 $ - $ 23,000 $ 34,500 $ Thunderbird Drive between Oakmont Drive and Del Rio Drive 9 Fireflow 8 inch 410 feet 42,000 $ 63,000 $ - $ 42,000 $ 63,000 $ Oakmont Drive between Thunderbird Drive and Country Club Drive 9 Fireflow 8 inch 760 feet 76,000 $ 114,000 $ - $ 76,000 $ 114,000 $ Alley between Oakmont Drive and Del Rio Drive south of Tamarisk Drive 9 Fireflow 8 inch 200 feet 20,000 $ 30,000 $ - $ 20,000 $ 30,000 $ Proposed New Tank Site to Distribution System 9 Supply 10 inch 2,370 feet 290,000 $ 435,000 $ - $ 290,000 $ 435,000 $ Proposed New Well Site to Distribution System 8/9 Supply 10 inch 740 feet 58,000 $ 87,000 $ 34,000 $ 51,000 $ 92,000 $ 138,000 $ Future Development Pipelines 8 Grid 10 inch 15,000 feet - $ 1,836,000 $ 2,754,000 $ 1,836,000 $ 2,754,000 $ 509,000 $ 763,500 $ 1,870,000 $ 2,805,000 $ 2,379,000 $ 3,568,500 $ Pipeline Improvement Recommendations - Grayson (Strengthen and Replace Water Mains) Minne Street from Tank 9 to Laird Road 9 Fireflow 8 inch 810 feet 81,000 $ 121,500 $ - $ 81,000 $ 121,500 $ Laird Road from Minnie Street to Amelia Street 9 Fireflow 8 inch 700 feet 70,000 $ 105,000 $ - $ 70,000 $ 105,000 $ Stakes Street and Charles Street from Minnie Street to Mary Street 9 Fireflow 8 inch 1,640 feet 165,000 $ 247,500 $ - $ 165,000 $ 247,500 $ River Road from Mary Street to Amelia Street 9 Fireflow 8 inch 750 feet 75,000 $ 112,500 $ - $ 75,000 $ 112,500 $ Mary Street from Laird Road to River Road 9 Fireflow 8 inch 710 feet 71,000 $ 106,500 $ - $ 71,000 $ 106,500 $ 462,000 $ 693,000 $ - $ - $ 462,000 $ 693,000 $ Pipeline Improvement Recommendations - Hickman (Strengthen and Replace Water Mains) Along Montpelier Road from Lake Road to Emma Lane 9 Fireflow 12 inch 2,360 feet 322,200 $ 483,300 $ - $ 322,200 $ 483,300 $ Along Lake Road from Montpelier Road to I Street 9 Fireflow 8 inch 800 feet 80,100 $ 120,150 $ - $ 80,100 $ 120,150 $ Along I Street from Lake Road to 4th Street 9 Fireflow 8 inch 1,030 feet 103,200 $ 154,800 $ - $ 103,200 $ 154,800 $ Along I Street from Lake Road to 4th Street 9 Fireflow 8 inch 760 feet 76,600 $ 114,900 $ - $ 76,600 $ 114,900 $ Tie-In between two north-south mains along Montpelier Road 9 Fireflow 10 inch 20 feet 2,300 $ 3,450 $ - $ 2,300 $ 3,450 $ Along Davis Street from Hickman Road to Elma Street 9 Fireflow 8 inch 530 feet 53,100 $ 79,650 $ - $ 53,100 $ 79,650 $ Along Kim Street from Hickman Road to Lorenzo Street & along Kim Court & Lorenzo Street 9 Fireflow 8 inch 1,310 feet 131,900 $ 197,850 $ - $ 131,900 $ 197,850 $ Along Hickman Road from Lake Road to Kim Street 9 Fireflow 10 inch 1,040 feet 127,300 $ 190,950 $ - $ 127,300 $ 190,950 $ Along 6th Street from Elma Street to Well 309 9 Fireflow 10 inch 810 feet 99,400 $ 149,100 $ - $ 99,400 $ 149,100 $ Along Lake Road from Hickman Road to Well 272 9 Fireflow 10 inch 310 feet 37,900 $ 56,850 $ - $ 37,900 $ 56,850 $ Along Lake Road from Well 272 to Montpelier Road 9 Head loss 12 inch 380 feet 51,400 $ 77,100 $ - $ 51,400 $ 77,100 $ 1,085,400 $ 1,628,100 $ - $ - $ 1,085,400 $ 1,628,100 $ Pipeline Improvement Recommendations - Turlock (Strengthen and Replace Water Mains) Northern Service Island 4-inch Diameter Pipelines 9 Fireflow 8 inch 2,300 feet 235,000 $ 352,500 $ - $ 235,000 $ 352,500 $ Central Service Island 4-inch Diameter Pipelines 9 Fireflow 8 inch 2,400 feet 245,000 $ 367,500 $ - $ 245,000 $ 367,500 $ Southern Service Island 4-inch Diameter Pipelines 9 Fireflow 8 inch 5,700 feet 578,000 $ 867,000 $ - $ 578,000 $ 867,000 $ Emergency Interconnections with the City of Turlock 11 Supply 3 ea 165,000 $ 247,500 $ 165,000 $ 247,500 $ 1,223,000 $ 1,834,500 $ - $ - $ 1,223,000 $ 1,834,500 $ Pipeline Improvement Recommendations - Waterford (Strengthen and Replace Water Mains) Along Bentley Street from Tim Bell Road to Harriett Drive 9 Fireflow 8 inch 1,260 feet 127,000 $ 190,500 $ - $ 127,000 $ 190,500 $ Along Peel Lane from Bentley Street to dead end 9 Fireflow 8 inch 460 feet 46,000 $ 69,000 $ - $ 46,000 $ 69,000 $ Along alley between D Street and E Street from Bentley Street to Welch Street 9 Fireflow 8 inch 530 feet 53,000 $ 79,500 $ - $ 53,000 $ 79,500 $ Along Welch Street from alley north of E Street to alley south of Covey Street 9 Fireflow 8 inch 420 feet 42,000 $ 63,000 $ - $ 42,000 $ 63,000 $ Along alley south of Covey Street from Welch Street to Covey Street bend 9 Fireflow 8 inch 310 feet 31,000 $ 46,500 $ - $ 31,000 $ 46,500 $ Along Covey Street from alley to Tim Bell Road 9 Fireflow 8 inch 410 feet 42,000 $ 63,000 $ - $ 42,000 $ 63,000 $ Along Center Street from Yosemite Boulevard to Terrace Court 9 Fireflow 8 inch 570 feet 58,000 $ 87,000 $ - $ 58,000 $ 87,000 $ Along Terrace Court from Center Street to dead end 9 Fireflow 8 inch 330 feet 33,000 $ 49,500 $ - $ 33,000 $ 49,500 $ Along C Street from Oden Drive to La Gallina Avenue 9 Fireflow 8 inch 330 feet 33,000 $ 49,500 $ - $ 33,000 $ 49,500 $ Along alley between C Street and D Street from La Gallina Avenue to Main Street 9 Fireflow 8 inch 1,070 feet 107,000 $ 160,500 $ - $ 107,000 $ 160,500 $ Along Chaffee Lane from Bentley Street to dead end 9 Fireflow 8 inch 550 feet 56,000 $ 84,000 $ - $ 56,000 $ 84,000 $ Along alley between E Street and F Street from La Gallina Avenue to Yosemite Blvd 9 Fireflow 8 inch 3,200 feet 322,000 $ 483,000 $ - $ 322,000 $ 483,000 $ Along Welch Street from alley south of G Street to alley south of E Street 9 Fireflow 8 inch 850 feet 85,000 $ 127,500 $ - $ 85,000 $ 127,500 $ Along south side of Yosemite Boulevard from Hickman Road to N. Appling Road 9 Fireflow 8 inch 2,130 feet 214,000 $ 321,000 $ - $ 214,000 $ 321,000 $ Along Hickman Street from Baker Street to N. Appling Road 9 Fireflow 8 inch 310 feet 31,000 $ 46,500 $ - $ 31,000 $ 46,500 $ Along N. Appling Road from Hickman Street to Yosemite Boulevard 9 Fireflow 8 inch 350 feet 35,000 $ 52,500 $ - $ 35,000 $ 52,500 $ Along Yosemite Boulevard between Reinway Avenue and North Pasadena Avenue 9 Fireflow 8 inch 980 feet 98,000 $ 147,000 $ - $ 98,000 $ 147,000 $ Along Tim Bell Road just south of Bonnie Brae Avenue and Vineyard Rd 9 Fireflow 8 inch 490 feet 49,000 $ 73,500 $ - $ 49,000 $ 73,500 $ Along Skyline Blvd and Lyn Way from Bentley Street to Lyn Way 9 Fireflow 10 inch 1,940 feet 237,000 $ 355,500 $ - $ 237,000 $ 355,500 $ 1,699,000 $ 2,548,500 $ - $ - $ 1,699,000 $ 2,548,500 $ Table C3. Detailed CIP Recommendations for Outlying Service Areas(a) Existing Costs Future Costs Total Costs Del Rio New Water Tanks Subtotal Hickman New Water Tanks Subtotal Waterford New Water Tanks Subtotal Del Rio New Well Subtotal Grayson New Well Subtotal Hickman New Well Subtotal Waterford New Well Subtotal Turlock Wellhead Treatment Subtotal Grayson Backup Generators Subtotal Hickman Backup Generators Subtotal Turlock Backup Generator Subtotal Waterford Backup Generator Subtotal Grayson Pump Station Improvements Subtotal Del Rio Pipeline Subtotal Soft cost and contingency mark-ups of 50% include: construction contingency engineering construction management and program implementation Cost listed as part of City's 2009-2038 CIP spreadsheet (Included as Attachment Grayson Pipeline Subtotal Hickman Pipeline Subtotal Turlock Pipeline Subtotal Waterford Pipeline Subtotal Recommendations based on Existing System Evaluation presented in Appendix D. Costs based on March 2010 San Francisco Engineering News Record (ENR) Index (9728.17). West Yost Associates o:\c\418\02-07-22\wp\er\20091031ceOpA3erAttC Last Revised: 04-10-10 1 of 1 City of Modesto Engineer's Report Attachment C ---PAGE BREAK--- ATTACHMENT D City 2009 – 2038 CIP Spreadsheet ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Category 1: Phase Two Expansion W425 A202 Phase 2 Expansion: Plant Improvements (funded) 41.9% 58.1% - $ Subtotal Category 1 - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 2: City-Side Improvements related to Phase Two Expansion W425 W425 Imp.: (Primary) 41.9% 58.1% - $ W416C W002 Imp.: Claratina & VA Corridor Trans Main-Sec 77.6% 22.4% 6,000,000 $ 3,000,000 $ 3,000,000 $ W425 W003 Imp.: Industrial Tank/Pipeline 100.0% 0.0% 8,900,000 $ 450,000 $ 450000 6,000,000 $ 2,000,000 $ W425 W361 Imp.: Tier 1 PRVS 41.9% 58.1% 20,000 $ 20,000 $ W425 W363 Imp.: Tier 1 North Tank 100.0% 0.0% 11,143,000 $ 143,000 $ 8,000,000 $ 3,000,000 $ W425 W005 Imp.: Tier 2 PRVS 41.9% 58.1% 4,200,000 $ 4,200,000 $ W425 W133 Imp.: West Tank/Pipelines 100.0% 0.0% 100,000 $ 100,000 $ W425 W099 Imp.: Lapham - 7th & B (Secondary) 77.6% 22.4% 7,200,000 $ 7,200,000 $ W425 W078 Imp.: Orangeburg Ave Trans Main (Secondary) 77.6% 22.4% - $ Done Subtotal Category 2 37,563,000 $ 3,713,000 $ 15,650,000 $ 3,000,000 $ 13,200,000 $ 2,000,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 3: Regional Surface Water Supply Project W414 W414C Regional Surface Water Supply Plant (Individual) 74.4% 25.6% 49,000,000 $ 1,200,000 $ 2,800,000 $ 15,000,000 $ 20,000,000 $ 10,000,000 $ Subtotal Category 3 49,000,000 $ 1,200,000 $ 2,800,000 $ - $ 15,000,000 $ 20,000,000 $ 10,000,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 3A: City-side Improvements related to W135 W425 Cityside Improvements For 74.4% 25.6% 5,600,000 $ - $ 560,000 $ 2,800,000 $ 2,240,000 $ Subtotal Category 3A 5,600,000 $ - $ - $ 560,000 $ 2,800,000 $ 2,240,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 4: Water Quality Study W415F W415 Water Quality Study (Individual) 41.9% 58.1% 3,186,000 $ 236,000 $ 500,000 $ 500,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ Subtotal Category 4 3,186,000 $ 236,000 $ 500,000 $ 500,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ Category 5: Remove Water Tanks 6100 Remove Water Tank #1 100.0% 0.0% - $ - $ - $ Subtotal Category 5 - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 6: New Corporation Yard W458 W458 Water Division Corp Yard (Individual) 64.0% 36.0% 8,600,000 $ - $ 1,500,000 $ 1,000,000 $ 6,100,000 $ Subtotal Category 6 8,600,000 $ - $ - $ - $ 1,500,000 $ 1,000,000 $ 6,100,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Category 7: Existing Tank Improvements W438 W438 Water Tank Improvements (Primary) 100.0% 0.0% 3,075,000 $ 275,000 $ 200,000 $ - $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ Subtotal Category 7 3,075,000 $ 275,000 $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ Category 8: Extend Water Mains W426 W379 Claratina-BETW Coffee & Oakdale Main Extension 0.0% 100.0% - $ Done W426 W008 Claratina-McHenry 12" Main 0.0% 100.0% - $ Done W428 W610 Extend Water Mains - New Developments (Secondary) 0.0% 100.0% 220,000 $ 220,000 $ W426 W426 Extend Water Mains (Primary) 0.0% 100.0% 52,760,000 $ 500,000 $ 500,000 $ 1,814,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ W426 W371 Kiernan At Dale Intersection Main Extension (Secondary) 0.0% 100.0% - $ Done W426 New Kiernan Ave. Water Main Extension 100.0% 1,300,000 $ 806,000 $ 494,000 $ W426 New Sylvan: Litt to Summer Dr Water Main Extension 100.0% 288,000 $ 288,000 $ W426 W572 Pelendale Landscape Waterline (Secondary) 0.0% 100.0% - $ Done W426 W367 Pelendale Waterline Extension to U.P.R.R.-Secondary 0.0% 100.0% - $ Done W426 W798 Sylvan/Roselle H2O (Secondary) 0.0% 100.0% - $ Done W426 W387 Tank #5 Fill Line 0.0% 100.0% 177,000 $ 177,000 $ Subtotal Category 8 54,745,000 $ 897,000 $ 1,594,000 $ 2,308,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ Category 9: Strengthen and Replace Water System W428 W457 E. Orangeburg - Water Main Replacement (Secondary) 100.0% 0.0% 479,000 $ 479,000 $ W428 W980 I St. Main Replacement (Secondary) - reline, not replace 100.0% 0.0% 200,000 $ 200,000 $ W428 W615 Modesto System Improvements (Secondary) 100.0% 0.0% 739,000 $ 739,000 $ W428 W973 N Western Ave Mains (Secondary) 100.0% 0.0% - $ Done W428 W616 Outlying System Improvements (Secondary) 100.0% 0.0% 998,000 $ 998,000 $ W428 Outlying System Improvements (Del Rio) 100.0% 0.0% 763,500 $ 349,500 $ 414,000 $ W428 Outlying System Improvements (Grayson) 100.0% 0.0% 693,000 $ - $ 693,000 $ W428 Outlying System Improvements (Hickman) 100.0% 0.0% 1,628,100 $ 542,700 $ 542,700 $ 542,700 $ W428 Outlying System Improvements (Turlock) 100.0% 0.0% 1,835,000 $ - $ 1,835,000 $ W428 Outlying System Improvements (Waterford) 100.0% 0.0% 2,548,500 $ 849,500 $ 849,500 $ 849,500 $ W455 W376 South Modesto Pump Station 100.0% 0.0% - $ Done W428 W119 SR 132 Main Replacement (Secondary) 100.0% 0.0% 1,400,000 $ 1,400,000 $ W428 W001 Strength/Repl Tuolumne-Neece (Secondary) 100.0% 0.0% - $ Done W428 W373 Strengthen & Replace Wtr Sys West Modesto-Secondary 100.0% 0.0% 150,000 $ 150,000 $ - $ W428 W022 System Wide Water Valve Replacement (Secondary) 100.0% 0.0% 5,800,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ W428 W428 Strengthen and Replace Water System (Primary) 100.0% 0.0% 85,331,000 $ 1,831,000 $ 2,500,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ Subtotal Category 9 102,565,100 $ 7,738,700 $ 5,199,200 $ 4,592,200 $ 5,035,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ Existing Primary Secondary Description Bldout Total Cost Done =100% complete or under construction with sufficient funds encumbered for completion. Printed 5/14/2010 10:09 AM 1 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Existing Primary Secondary Description Bldout Total Cost Done =100% complete or under construction with sufficient funds encumbered for completion. Category 10: Install New Wells W441 W017 Del Rio - Well Replacement (Secondary) was W456 42.3% 57.7% 1,940,000 $ 140,000 $ 1,800,000 $ W441 W441 Install New and Replacement Wells (Primary) 42.3% 57.7% 16,150,000 $ 150,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ W441 W729 Mildred Perkins Well 63 (Secondary) 42.3% 57.7% 1,232,000 $ 1,232,000 $ W441 W624 Test Holes-Various Locations (Secondary) 42.3% 57.7% 823,000 $ 423,000 $ 150,000 $ 150,000 $ 50,000 $ 50,000 $ W441 W018 Tivoli Well 42.3% 57.7% 286,000 $ 286,000 $ W441 W019 Waterford Well 42.3% 57.7% 2,000,000 $ 300,000 $ 1,700,000 $ W441 W407 Well 226 Replacement Well (Secondary) 42.3% 57.7% 2,000,000 $ 1,500,000 $ 500,000 $ Subtotal Category 10 24,431,000 $ 3,731,000 $ 4,750,000 $ 2,150,000 $ 3,750,000 $ 2,050,000 $ - $ - $ - $ - $ 2,000,000 $ - $ - $ - $ - $ 2,000,000 $ - $ Category 11: Wellhead Treatment W430 W730 California St./Well 283 Blending Line (Secondary) 100.0% 0.0% 478,000 $ 478,000 $ W426 W976 GAC Wells - Nitrate Analyzer (Secondary) 100.0% 0.0% 50,000 $ - $ 50,000 $ W430 W629 Grayson Nitrate Pilot (Secondary) 100.0% 0.0% - $ Done W430 W386 Salida Wells Arsenic Treatments 100.0% 0.0% 1,740,000 $ 540,000 $ 1,200,000 $ W430 W459 Well 285 - Empire Wellhead Treatment 100.0% 0.0% - $ $ In primary W430 W601 Well 226: Arsenic Pilot Plant (Secondary) 100.0% 0.0% - $ Done W430 W742 Well 236 Blending Line (Secondary) 100.0% 0.0% 494,000 $ 494,000 $ W430 W383 Well 293 - Beard - Wellhead Treatment (Secondary) 100.0% 0.0% 50,000 $ 50,000 $ W430 W544 Well 49 Blending Line (Secondary) 100.0% 0.0% - $ Done W430 W593 Well 53 Blending Line (Secondary) 100.0% 0.0% 488,000 $ 488,000 $ W430 W717 Wellhead Contaminant Study (Secondary) 100.0% 0.0% - $ Done W430 W368 Wellhead Treatment Well 21 Uranium (Secondary) study 100.0% 0.0% 100,000 $ 100,000 $ W430 W430 Wellhead Treatment & Well Rehabilitation (Primary) 100.0% 0.0% 24,000,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ W430 W714 Wellhead Treatment Well 3 - PCE (Secondary) 100.0% 0.0% 1,280,000 $ 280,000 $ 1,000,000 $ W430 W720 Wellhead Treatment Well 66 Galas (Secondary) 100.0% 0.0% 502,000 $ 2,000 $ 500,000 $ W430 W705 Whitmore/Well 55 Blending Line (Secondary) 100.0% 0.0% 95,000 $ - $ 95,000 $ Subtotal Category 11 29,277,000 $ 3,394,000 $ 3,588,000 $ 2,795,000 $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ Category 12: Purchase & Install New Backup Generators (Existing Wells) W433 W433 Purchase & Install New Generators (Primary) 60.0% 40.0% 9,518,000 $ 118,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ W433 W392 Tank 7 & 8 Purchase/Install Generators (Secondary) 60.0% 40.0% 482,000 $ 482,000 $ Subtotal Category 12 10,000,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ Category 13: Water System Security Enhancements W435 W605 Security (VA) - Codoni Site (Secondary) 100.0% 0.0% - $ Done W435 W603 Security (VA) -Tank 5 Site (Secondary) 100.0% 0.0% - $ Done W435 W604 Security (VA) -Tank 6 Site (Secondary) 100.0% 0.0% - $ Done W435 W719 Security (VA) -Tank 7 Site (Secondary) 100.0% 0.0% - $ Done W435 W723 Security (VA) -Well 14 Site (Secondary) 100.0% 0.0% - $ Done W435 W721 Security (VA) -Well Site 2 (Secondary) 100.0% 0.0% - $ Done W435 W724 Security (VA) -Well Site 25 (Secondary) 100.0% 0.0% - $ Done W435 W722 Security (VA) -Well Site 7 (Secondary) 100.0% 0.0% - $ Done W435 W607 Water Security System Design-All Sites (Secondary) 100.0% 0.0% - $ Done 09/10 W428 W706 Water System Safety (Secondary) 100.0% 0.0% - $ Done W435 W435 Water System Security Enhancements (Primary) 100.0% 0.0% 3,176,000 $ 426,000 $ 500,000 $ 500,000 $ 500,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ Subtotal Category 13 3,176,000 $ 426,000 $ 500,000 $ 500,000 $ 500,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ - $ - $ - $ - $ - $ - $ - $ Category 14: Groundwater Management Plan W440 W440 Groundwater Management Planning & Implementation (Primary) 41.9% 58.1% 70,000 $ 70,000 $ W440 W620 Groundwater Management Plan (Secondary) 41.9% 58.1% 2,496,000 $ 6,000 $ 390,000 $ 50,000 $ 100,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 100,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 100,000 $ 75,000 $ 75,000 $ W440 W621 TGBA Groundwater Management Plan (Secondary) 41.9% 58.1% 1,270,000 $ 9,000 $ 11,000 $ 20,000 $ 50,000 $ 20,000 $ 30,000 $ 30,000 $ 30,000 $ 50,000 $ 30,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 50,000 $ Subtotal Category 14 3,836,000 $ 85,000 $ 401,000 $ 70,000 $ 150,000 $ 95,000 $ 105,000 $ 105,000 $ 105,000 $ 150,000 $ 105,000 $ 115,000 $ 115,000 $ 115,000 $ 140,000 $ 115,000 $ 125,000 $ Category 15: Urban Water Management Plan W410C W410 Urban Water Management Planning & Implementation (Individual) 16.6% 83.4% 1,019,000 $ 149,000 $ 20,000 $ 170,000 $ 170,000 $ 170,000 $ Subtotal Category 15 1,019,000 $ 149,000 $ 20,000 $ - $ - $ - $ 170,000 $ - $ - $ - $ - $ 170,000 $ - $ - $ - $ - $ 170,000 $ Category 16: Water Master Plan W439 W439 Water Master Plan (Individual) 23.1% 76.9% 5,199,000 $ 617,000 $ 582,000 $ 800,000 $ 800,000 $ 800,000 $ Subtotal Category 16 5,199,000 $ 617,000 $ 582,000 $ - $ - $ - $ 800,000 $ - $ - $ - $ - $ 800,000 $ - $ - $ - $ - $ 800,000 $ Category 17: Water System Evaluation W436 W436 Water System Analysis - Primary 3.8% 96.2% - $ W436 W608 Modesto Water Systems Analysis (Secondary) 3.8% 96.2% 3,220,000 $ 32,000 $ 83,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ A436 W609 Outlying Areas Water Systems Analysis (Secondary) 3.8% 96.2% 989,000 $ 44,000 $ - $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ Subtotal Category 17 4,209,000 $ 76,000 $ 83,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ Category 18: New Water Tanks W377 W377 New Water Tanks - Del Rio (Primary) 57.9% 42.2% 2,800,000 $ 500,000 $ 500,000 $ 1,800,000 $ W377 W377 New Water Tanks - Hickman (Primary) 100.0% 0.0% 2,800,000 $ 300,000 $ 500,000 $ 2,000,000 $ W377 W377 New Water Tanks - South Modesto (Primary) - 10.0 MG total 0.0% 100.0% 25,200,000 $ 1,500,000 $ 1,500,000 $ 5,300,000 $ 5,300,000 $ 1,000,000 $ 5,300,000 $ 5,300,000 $ W377 W377 New Water Tanks - North Modesto (Primary) - 5.0 MG at MID site 0.0% 100.0% 13,200,000 $ 1,300,000 $ 6,600,000 $ 5,300,000 $ W377 W377 New Water Tanks - Waterford (Primary) 100.0% 0.0% 3,600,000 $ 300,000 $ 500,000 $ 2,800,000 $ Subtotal Category 18 47,600,000 $ 2,600,000 $ 1,500,000 $ 5,300,000 $ 2,800,000 $ 5,300,000 $ 6,600,000 $ 6,600,000 $ 5,300,000 $ - $ - $ - $ - $ 1,000,000 $ 5,300,000 $ 5,300,000 $ - $ Category 19: Water Meters W416C W703 Hickman Residential Meters (Secondary) $ in Primary 100.0% 0.0% - $ - $ W416C W381 Modesto Residential Water Meters (Secondary) 100.0% 0.0% 986,000 $ 986,000 $ W416C W704 Salida Residential Meters (Secondary) 100.0% 0.0% - $ Done W416C W416 Water Meters (Primary) 100.0% 0.0% 32,000,000 $ 2,000,000 $ 2,000,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ W416C W702 Waterford Residential Meters (Secondary) $ in Primary 100.0% 0.0% - $ - $ Subtotal Category 19 32,986,000 $ 2,986,000 $ 2,000,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ 3,500,000 $ - $ - $ - $ - $ - $ - $ Printed 5/14/2010 10:09 AM 2 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Existing Primary Secondary Description Bldout Total Cost Done =100% complete or under construction with sufficient funds encumbered for completion. Category 21: New or Replacement Pumps W455 W622 Replace Pumps - System Wide (Secondary) 100.0% 0.0% 82,000 $ 82,000 $ W455 Replace Pumps (Primary) 100.0% 0.0% 19,461,000 $ 961,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ Subtotal Category 21 19,543,000 $ 1,043,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 500,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ Category 22: Soil Remediation W011 W011 Kansas-Needham Soil Remediation Project 100.0% 0.0% 263,000 $ 263,000 $ W011 Soil Remediation Program 100.0% 0.0% 1,000,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ Subtotal Category 24 1,263,000 $ 263,000 $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ - $ - $ Category 23: Utility Cuts W445 W445 Utility Cuts Streets 100.0% 0.0% 28,844,000 $ 844,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ Subtotal Category 23 28,844,000 $ 844,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ Total Planned Capital Project Costs (Current Dollars) 475,717,100 $ 30,873,700 $ 41,567,200 $ 27,525,200 $ 54,181,000 $ 43,981,000 $ 36,671,000 $ 17,901,000 $ 18,401,000 $ 11,346,000 $ 14,751,000 $ 8,631,000 $ 9,511,000 $ 8,811,000 $ 14,936,000 $ 15,111,000 $ 10,491,000 $ Printed 5/14/2010 10:09 AM 3 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) Category 1: Phase Two Expansion W425 A202 Phase 2 Expansion: Plant Improvements (funded) 41.9% 58.1% Subtotal Category 1 Category 2: City-Side Improvements related to Phase Two Expansion W425 W425 Imp.: (Primary) 41.9% 58.1% W416C W002 Imp.: Claratina & VA Corridor Trans Main-Sec 77.6% 22.4% W425 W003 Imp.: Industrial Tank/Pipeline 100.0% 0.0% W425 W361 Imp.: Tier 1 PRVS 41.9% 58.1% W425 W363 Imp.: Tier 1 North Tank 100.0% 0.0% W425 W005 Imp.: Tier 2 PRVS 41.9% 58.1% W425 W133 Imp.: West Tank/Pipelines 100.0% 0.0% W425 W099 Imp.: Lapham - 7th & B (Secondary) 77.6% 22.4% W425 W078 Imp.: Orangeburg Ave Trans Main (Secondary) 77.6% 22.4% Subtotal Category 2 Category 3: Regional Surface Water Supply Project W414 W414C Regional Surface Water Supply Plant (Individual) 74.4% 25.6% Subtotal Category 3 Category 3A: City-side Improvements related to W135 W425 Cityside Improvements For 74.4% 25.6% Subtotal Category 3A Category 4: Water Quality Study W415F W415 Water Quality Study (Individual) 41.9% 58.1% Subtotal Category 4 Category 5: Remove Water Tanks 6100 Remove Water Tank #1 100.0% 0.0% Subtotal Category 5 Category 6: New Corporation Yard W458 W458 Water Division Corp Yard (Individual) 64.0% 36.0% Subtotal Category 6 Category 7: Existing Tank Improvements W438 W438 Water Tank Improvements (Primary) 100.0% 0.0% Subtotal Category 7 Category 8: Extend Water Mains W426 W379 Claratina-BETW Coffee & Oakdale Main Extension 0.0% 100.0% W426 W008 Claratina-McHenry 12" Main 0.0% 100.0% W428 W610 Extend Water Mains - New Developments (Secondary) 0.0% 100.0% W426 W426 Extend Water Mains (Primary) 0.0% 100.0% W426 W371 Kiernan At Dale Intersection Main Extension (Secondary) 0.0% 100.0% W426 New Kiernan Ave. Water Main Extension 100.0% W426 New Sylvan: Litt to Summer Dr Water Main Extension 100.0% W426 W572 Pelendale Landscape Waterline (Secondary) 0.0% 100.0% W426 W367 Pelendale Waterline Extension to U.P.R.R.-Secondary 0.0% 100.0% W426 W798 Sylvan/Roselle H2O (Secondary) 0.0% 100.0% W426 W387 Tank #5 Fill Line 0.0% 100.0% Subtotal Category 8 Category 9: Strengthen and Replace Water System W428 W457 E. Orangeburg - Water Main Replacement (Secondary) 100.0% 0.0% W428 W980 I St. Main Replacement (Secondary) - reline, not replace 100.0% 0.0% W428 W615 Modesto System Improvements (Secondary) 100.0% 0.0% W428 W973 N Western Ave Mains (Secondary) 100.0% 0.0% W428 W616 Outlying System Improvements (Secondary) 100.0% 0.0% W428 Outlying System Improvements (Del Rio) 100.0% 0.0% W428 Outlying System Improvements (Grayson) 100.0% 0.0% W428 Outlying System Improvements (Hickman) 100.0% 0.0% W428 Outlying System Improvements (Turlock) 100.0% 0.0% W428 Outlying System Improvements (Waterford) 100.0% 0.0% W455 W376 South Modesto Pump Station 100.0% 0.0% W428 W119 SR 132 Main Replacement (Secondary) 100.0% 0.0% W428 W001 Strength/Repl Tuolumne-Neece (Secondary) 100.0% 0.0% W428 W373 Strengthen & Replace Wtr Sys West Modesto-Secondary 100.0% 0.0% W428 W022 System Wide Water Valve Replacement (Secondary) 100.0% 0.0% W428 W428 Strengthen and Replace Water System (Primary) 100.0% 0.0% Subtotal Category 9 Existing Primary Secondary Description Bldout FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 FY 2035 FY 2036 FY 2037 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 200,000 $ - $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 1,921,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,000,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ 3,200,000 $ Printed 5/14/2010 10:09 AM 4 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) Existing Primary Secondary Description Bldout Category 10: Install New Wells W441 W017 Del Rio - Well Replacement (Secondary) was W456 42.3% 57.7% W441 W441 Install New and Replacement Wells (Primary) 42.3% 57.7% W441 W729 Mildred Perkins Well 63 (Secondary) 42.3% 57.7% W441 W624 Test Holes-Various Locations (Secondary) 42.3% 57.7% W441 W018 Tivoli Well 42.3% 57.7% W441 W019 Waterford Well 42.3% 57.7% W441 W407 Well 226 Replacement Well (Secondary) 42.3% 57.7% Subtotal Category 10 Category 11: Wellhead Treatment W430 W730 California St./Well 283 Blending Line (Secondary) 100.0% 0.0% W426 W976 GAC Wells - Nitrate Analyzer (Secondary) 100.0% 0.0% W430 W629 Grayson Nitrate Pilot (Secondary) 100.0% 0.0% W430 W386 Salida Wells Arsenic Treatments 100.0% 0.0% W430 W459 Well 285 - Empire Wellhead Treatment 100.0% 0.0% W430 W601 Well 226: Arsenic Pilot Plant (Secondary) 100.0% 0.0% W430 W742 Well 236 Blending Line (Secondary) 100.0% 0.0% W430 W383 Well 293 - Beard - Wellhead Treatment (Secondary) 100.0% 0.0% W430 W544 Well 49 Blending Line (Secondary) 100.0% 0.0% W430 W593 Well 53 Blending Line (Secondary) 100.0% 0.0% W430 W717 Wellhead Contaminant Study (Secondary) 100.0% 0.0% W430 W368 Wellhead Treatment Well 21 Uranium (Secondary) study 100.0% 0.0% W430 W430 Wellhead Treatment & Well Rehabilitation (Primary) 100.0% 0.0% W430 W714 Wellhead Treatment Well 3 - PCE (Secondary) 100.0% 0.0% W430 W720 Wellhead Treatment Well 66 Galas (Secondary) 100.0% 0.0% W430 W705 Whitmore/Well 55 Blending Line (Secondary) 100.0% 0.0% Subtotal Category 11 Category 12: Purchase & Install New Backup Generators (Existing Wells) W433 W433 Purchase & Install New Generators (Primary) 60.0% 40.0% W433 W392 Tank 7 & 8 Purchase/Install Generators (Secondary) 60.0% 40.0% Subtotal Category 12 Category 13: Water System Security Enhancements W435 W605 Security (VA) - Codoni Site (Secondary) 100.0% 0.0% W435 W603 Security (VA) -Tank 5 Site (Secondary) 100.0% 0.0% W435 W604 Security (VA) -Tank 6 Site (Secondary) 100.0% 0.0% W435 W719 Security (VA) -Tank 7 Site (Secondary) 100.0% 0.0% W435 W723 Security (VA) -Well 14 Site (Secondary) 100.0% 0.0% W435 W721 Security (VA) -Well Site 2 (Secondary) 100.0% 0.0% W435 W724 Security (VA) -Well Site 25 (Secondary) 100.0% 0.0% W435 W722 Security (VA) -Well Site 7 (Secondary) 100.0% 0.0% W435 W607 Water Security System Design-All Sites (Secondary) 100.0% 0.0% W428 W706 Water System Safety (Secondary) 100.0% 0.0% W435 W435 Water System Security Enhancements (Primary) 100.0% 0.0% Subtotal Category 13 Category 14: Groundwater Management Plan W440 W440 Groundwater Management Planning & Implementation (Primary) 41.9% 58.1% W440 W620 Groundwater Management Plan (Secondary) 41.9% 58.1% W440 W621 TGBA Groundwater Management Plan (Secondary) 41.9% 58.1% Subtotal Category 14 Category 15: Urban Water Management Plan W410C W410 Urban Water Management Planning & Implementation (Individual) 16.6% 83.4% Subtotal Category 15 Category 16: Water Master Plan W439 W439 Water Master Plan (Individual) 23.1% 76.9% Subtotal Category 16 Category 17: Water System Evaluation W436 W436 Water System Analysis - Primary 3.8% 96.2% W436 W608 Modesto Water Systems Analysis (Secondary) 3.8% 96.2% A436 W609 Outlying Areas Water Systems Analysis (Secondary) 3.8% 96.2% Subtotal Category 17 Category 18: New Water Tanks W377 W377 New Water Tanks - Del Rio (Primary) 57.9% 42.2% W377 W377 New Water Tanks - Hickman (Primary) 100.0% 0.0% W377 W377 New Water Tanks - South Modesto (Primary) - 10.0 MG total 0.0% 100.0% W377 W377 New Water Tanks - North Modesto (Primary) - 5.0 MG at MID site 0.0% 100.0% W377 W377 New Water Tanks - Waterford (Primary) 100.0% 0.0% Subtotal Category 18 Category 19: Water Meters W416C W703 Hickman Residential Meters (Secondary) $ in Primary 100.0% 0.0% W416C W381 Modesto Residential Water Meters (Secondary) 100.0% 0.0% W416C W704 Salida Residential Meters (Secondary) 100.0% 0.0% W416C W416 Water Meters (Primary) 100.0% 0.0% W416C W702 Waterford Residential Meters (Secondary) $ in Primary 100.0% 0.0% Subtotal Category 19 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 FY 2035 FY 2036 FY 2037 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2,000,000 $ 2,000,000 $ - $ - $ - $ 2,000,000 $ - $ - $ - $ - $ 2,000,000 $ - $ - $ - $ - $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 1,500,000 $ - $ 400,000 $ 400,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 75,000 $ 75,000 $ 100,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 60,000 $ 125,000 $ 125,000 $ 150,000 $ 125,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 170,000 $ 170,000 $ - $ - $ - $ - $ 170,000 $ - $ - $ - $ - $ 170,000 $ - $ - $ - $ 800,000 $ 800,000 $ - $ - $ - $ - $ 800,000 $ - $ - $ - $ - $ 800,000 $ - $ - $ - $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 115,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Printed 5/14/2010 10:09 AM 5 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP ---PAGE BREAK--- City of Modesto Water Capital Improvement Program - Revenue Requirement (Option A) Revenue Requirement (Current Dollars) Existing Primary Secondary Description Bldout Category 21: New or Replacement Pumps W455 W622 Replace Pumps - System Wide (Secondary) 100.0% 0.0% W455 Replace Pumps (Primary) 100.0% 0.0% Subtotal Category 21 Category 22: Soil Remediation W011 W011 Kansas-Needham Soil Remediation Project 100.0% 0.0% W011 Soil Remediation Program 100.0% 0.0% Subtotal Category 24 Category 23: Utility Cuts W445 W445 Utility Cuts Streets 100.0% 0.0% Subtotal Category 23 Total Planned Capital Project Costs (Current Dollars) FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 FY 2035 FY 2036 FY 2037 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 750,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ - $ - $ 100,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 7,721,000 $ 8,921,000 $ 7,246,000 $ 11,021,000 $ 8,201,000 $ 8,931,000 $ 7,331,000 $ 8,931,000 $ 9,231,000 $ 10,001,000 $ 7,231,000 $ 8,931,000 $ 7,331,000 $ Printed 5/14/2010 10:09 AM 6 o:\c\418\02-07-22\wp\er\Rev CIP from FCS 2-3-10_Jim 3-16-10 PLB 4-01-10.xls Option A CIP