Loading...
HomeMy WebLinkAbout10 Budget Workshop AGENDA ITEM #10 Public Utility District m MEETING DATE: September 20, 2023 TO: Board of Directors FROM: Michael Salmon, Chief Financial Officer SUBJECT: FY2024-2025 Budget - Workshop #2 APPROVED BY: Brian C. Wright, General Manager RECOMMENDATION: a) Receive the information from this workshop item and provide strategic direction to staff regarding Budget 2024 & 2025 preparations. b) Schedule the Budget Public Hearing on 11/1/2023 for the Budget 2024 & 2025. BACKGROUND: The District prepares a budget on a biennial basis. This is the 2nd workshop for the FY2024-25 budget development, utilizing the current budget, actual and forecast trends, as well as the strategic plan as the foundational basis. The current Board approved (6/7/2023) Budget 2024-25 workshops and the approval schedule is as follows: • August 16, 2023 (completed) — Workshop #1 - Discussion of Goals, Objectives, and Key Assumptions; • September 20, 2023 (tonight) — Workshop #2 — Purchased Power Plan, Operating & Capital Budgets for Electric and Water Utilities, and Financial Master Plan drafts; Public Hearing Notice of 11/1/2023 Public Hearing on Budget 2024 & 2025 Approval • October 18, 2023 (5pm-7pm) — Workshop #3 — Operating and Capital Budgets for all support services, Revenue/Rates, Reserves & Financial Master Plan drafts • November 1, 2023 (6pm start) — Public Hearing and Action Item — Review and approval of Budget 2024 & 2025 District's Mission The Mission of the Truckee Donner Public Utility District is to provide reliable, high quality utility and customer services while managing District resources in a safe, open, responsible, and environmentally sound manner at the lowest practical cost. Values of the District Page 1 of 5 Page 14 of 28 Safety — Safety is our way Safety is our first priority. We are committed to the health and safety of our employees, customers, and the community through the continuous practice of prevention, education, and awareness. Communication — Send and receive Foster positive engagement by creating a strong communicative environment that includes; active listening, transparency, clear, concise, and the timely transmission of information, with empathy and respect. This also includes providing and receiving honest feedback. Integrity — Honest and ethical Highest quality service to the public and employees, utilizing honesty and ethics as our base principles. Accountability — Own it A strong performing team with the obligation and willingness to accept responsibility for our actions, maintaining a sense of humility and inclusiveness. Timeliness — Meet our goals and commitments A highly effective agency and responsive organization meeting goals and expectations in a timely manner. Work Life Balance — Work hard, play hard We value every employee and foster a healthy work life balance culture, allowing employees to bring their best selves to work every day. Strategic Plan In May 2021, the Board adopted a Strategic Plan, and in 2023 updated the Strategic Plan. The plan includes four key initiatives as follows: ❑ Community Broadband ❑ Service Reliability and Safety ❑ Net Carbon Reduction ❑ Local Watershed Stewardship Reference Documents The following links provide useful financial information: 1. 2022 Annual Comprehensive Financial Report 2. 2022 and 2023 Budget (Current Budget) 3. District Code Title 3 Finance and Accounting 4. Strategic Plan Initiatives 2023 Update 5 .Strategic Plan 2021 — 2024 This budget process is essential in planning operational and capital expenses that are in alignment with the District's Mission, Values, and Strategic Plan. ANALYSIS AND BODY: 1. Purchased Power Page 2 of 5 Page 15 of 28 • For FY23, purchased power represents 50% of Electric Utility's operating expenses. • Demand is relatively consistent, however growth is occurring (demand and customer), weather does influence, and electrification momentum is strong. • Costs can be volatile, as we saw in to second half of 2022 and January of 2023 • YTD June 2023 cost of$7.95 million is $959,000 or 14% over budget and the FY23 forecast of $15.22 million is $1.2 million or 9% over budget. • For FY24 and FY25, staff developed a detailed purchased power estimate of $14.924 million and $15.615 million respectively. • For FY24, the $14.924M is $0.787M or 6% greater than FY23 budget. This increase is driven by multiple factors including customer growth, demand growth, power cost per MW increases, power source mix shifts, transmission cost increases, and energy imbalance market (EIM) costs. The recently added generation source brought online in 2023 Red Mesa solar power source has been factored at 17,500 MWH or 10% of power supply mix. • Attachment 1 provides a detail schedule of purchased power budget. • The budget for FY23 was 171,823 MWH purchased and the budget for FY24 is 174,000. Both a 3 year and 5 year average were analyzed and adjusted for customer growth and demand trends in developing FY24's 174,000. • FY22 and Forecast FY23 MWH purchased are 173,824 and 178,119 respectively. • The district has an Electric Rate Reserve policy (50% of annual power costs) with a balance of $4.8 million as of June 30, 2023. This reserve balance was drawn down by $2,36M in April 2023 to address material purchased power cost overruns in 2022 and January of 2023. Replenishment of this draw from electric rates is proposed to occur over 3 years. A legal settlement of $480k for CVPIA related purchased power from more than a decade ago was received in 2023, and these funds are recommended to be credited to the rate reserve. Net replenishment for the April draw equates to $627,000 for FY24, Fy25, and FY26. The replenishment has an approximate 1 .9% impact on electric rates. • The $0.787M cost increase for the FY24 budget as compared to the FY23 budget, drives a related 50% increase in the rate reserve requirement of $393,500. Staff recommends funding for this increase be spread over three years, resulting in $131,000 per year from FY24-FY26. This reserve funding increase has an approximate 0.4% impact on electric rates per year. • AB32 Cap & Trade cash funds have been consistently utilized as a non-rates funding source. Consistent with budget, utilization in FY22 was $1 M and FY23 was $550,000. The Financial Master Plan anticipates the utilization amount to be $350,000. This decrease of $200,000 equates to a shift to rates for funding with an approximate 0.6% impact on electric rates. 2. Personnel Page 3 of 5 Page 16 of 28 • The District has reviewed the organizational structure over last 12-18 months and has developed several recommended changes to align the structure with the evolving landscape of public utility maintenance and operations, consistent with the District's Mission, Values, and Strategic Plan. • Changes approved in 2022 and 2023 that differ from Budget, and impact 2024 and 2025 Budget: 1. Additions — none 2. Eliminations - none 3. Modifications or re-classifications o Electric Ops — Electrician position planned in budget elimination via attrition has not occurred, therefore +1 FTE in 2023. This position is not planned or budgeted for in FY24 or FY25 ■ All of above; 0 FTE's net impact on Budget 2024/2025 compared to Budget 2023 • Recommended changes proposed for Budget 2024/2025 o FY24 - Add 1 +2 FTE - $413,000 incremental, including overhead ■ IT - Network Administrator ■ Admin - Management Analyst • FY24 - Change 12 range re-classifications, 1 position change - $80,000 incremental, including overhead o IT - Network Administrator to Senior Network Administrator (Re- classification) o IT - Data Analyst & Admin to BI Developer (Re-classification) o Electric - Meter Reader to Defensible Space/Veg Management Manager (Re-classification) • FY25 - Change 11 range upgrade/promotion - $24,750 incremental, including overhead o General Management - Communications Specialist to Senior Communications Specialist (Re-classification) • Net FTE Change, + 2.0 (2 to operating expense, 0 to capital) • 81.0 Budget 2023 • 83.0 Budget 2024 and 2025 Page 4 of 5 Page 17 of 28 3. Capital Expenditures • Electric, Water, Fleet and IT have updated the ten year capital improvement plans for this budget cycle. • Attachment 2 provides summary and detailed information. GOALS AND OBJECTIVES: District Code 1.05.020 Objectives: 1. Responsibly serve the public. 2. Provide a healthy and safe work environment for all District employees. 3. Provide reliable and high quality water supply and distribution system to meet current and future needs. 4. Provide reliable and high quality electric supply and distribution system to meet current and future needs. 5. Manage the District in an environmentally sound manner. 6. Manage the District in an effective, efficient and fiscally responsible manner. District Code 1.05.030 Goals: 1. Manage for Financial Stability and Resiliency 3. Engage with our customers and communities in a welcoming and transparent way to identify opportunities. 5. Developing an inclusive culture drives organizational integration and success. FISCAL IMPACT: None for this workshop. ATTACHMENTS: 1. Purchased Power 2. Capital Plan for Budget Page 5 of 5 Page 18 of 28 TDPUD Purchased Power Detail Budget 2024 For 3 year Average,years MWH Cost /MWH utilized are 2020, 2021, 2022 Total 174,000 $ 14,924,000 $ 85.77 Enviro.Compliance/other $ 24,000 $ 0.14 NVE -Transmission $ 880,600 $ 5.06 NVE - EIM $ 389,400 $ 2.24 TCID 6,580 $ 217,000 $ 32.98 MWH-3yrAvg, $current+7% Stampede 9,770 $ 469,000 $ 48.00 MWH-3yrAvg, $current+50% UAMPS, Net Total 157,650 $ 12,944,000 $ 82.11 POOL 14,768 $ 1,528,689 $ 103.51 TRANS-JORDAN 26,010 $ 2,377,633 $ 91.41 OUT SCHED $ 12,188 $ 0.07 PX (2,448) $ 131,077 $ (53.54) MWH used UAMPS current Budget (3yr avg + 2.6%, for PV WIND 408 $ 39,961 $ 97.94 customer growth and demand NEBO 15,825 $ 1,405,977 $ 88.85 growth) HORSE BUTTE 46,630 $ 3,461,212 $ 74.23 For$/MWH utilized 3yr avg + VEYO 8,456 $ 843,434 $ 99.74 2.0% FALLON/TDPUD 30,501 $ 1,752,853 $ 57.47 RED MESA 17,500 $ 822,500 $ 47.00 Other Costs UAMPS $ 665,476 $ 3.82 MWH /MWH Actual 2022 173,824 Budget 2023 $ 82.25 Budget 2023 171,823 Budget 2024 $ 85.77 Forecast 2023 178,119 Change $ 3.52 Budget 2024 174,000 4.3% Budget 2025 176,100 1.2% Budget 2025 $ 88.67 3.4% Page 19 of 28 Truckee Donner Public Utility District TDPUD Capital Budget 2024&2025 and Forecast 2026-2033 (Working Draft) Capital Expenditures Summary ELECTRIC Division,by Funding Source 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 10 YR TOTALS Electric Department Expenditures: Facility Fees 0 500,000 0 0 0 0 0 0 0 0 500,000 Operating(Rates) 12,103,500 12,350,700 11,759,900 5,940,400 6,131,400 8,598,300 7,115,500 7,265,600 4,939,100 5,020,800 81,225,200 Operating(Rates)New Debt 0 6,500,000 0 0 0 0 0 0 0 0 6,500,000 Capital Reserve 2,560,000 4,700,000 0 0 0 0 0 0 0 0 7,260,000 0 subtotal(see subschedule for projects) 14,663,500 24,050,700 11,759,900 5,940,400 6,131,400 8,598,300 7,115,500 7,265,600 4,939,100 5,020,800 95,485,200 Information Technology projects 390,000 228,250 462,250 615,250 543,250 297,000 432,000 229,250 208,250 136,750 3,542,250 funded from Operating(Rates)(see subschedule for projects) Vehicle Reserves Expenditures 497,193 763,164 356,143 452,159 628,608 390,133 325,724 602,411 517,435 659,784 5,192,754 funded from Vehicle Reserves(via Rates)(see subschedule for projects) Capital Expenditures,subtotal 15,550,693 25,042,114 12,578,293 7,007,809 7,303,258 9,285,433 7,873,224 8,097,261 5,664,785 5,817,334 104,226,204 Contributed Capital projects(est.) 2,300,000 2,369,000 2,440,000 2,513,000 2,588,000 2,666,000 2,746,000 2,828,000 2,913,000 3,000,000 26,363,000 funded by transaction customers Electric Division Total $ 17,850,693 $ 27,411,114 $ 15,018,293 $ 9,520,809 $ 9,891,258 $ 11,951,433 $ 10,619,224 $ 10,925,261 $ 8,577,785 $ 8,817,334 $ 130,583,204 WATER Division by Funding Source 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 10 YR TOTALS Water Department Expenditures: Facility Fees 0 0 0 0 0 0 0 0 0 0 0 Operating(Rates) 4,877,700 7,443,568 9,461,875 8,977,547 6,522,686 10,234,881 8,051,843 9,674,811 8,265,643 7,970,124 81,480,678 Operating(Rates)New Debt 0 0 0 0 0 0 0 0 0 0 0 0 0 subtotal(see subschedule for projects) $ 4,877,700 $ 7,443,568 $ 9,461,875 $ 8,977,547 $ 6,522,686 $ 10,234,881 $ 8,051,843 $ 9,674,811 $ 8,265,643 $ 7,970,124 $ 81,480,678 Information Technology projects 390,000 228,250 462,250 615,250 543,250 297,000 432,000 229,250 208,250 136,750 3,542,250 funded from Operating(Rates)(see subschedule for projects) Vehicle Reserves Expenditures 644,306 157,720 189,546 193,335 224,727 292,600 335,683 380,499 304,074 461,903 3,184,393 funded from Vehicle Reserves(via Rates)(see subschedule for projects) Capital Expenditures,subtotal 5,912,006 7,829,538 10,113,671 9,786,132 7,290,663 10,824,481 8,819,526 10,284,560 8,777,967 8,568,777 88,207,321 Contributed Capital projects 0 0 0 0 0 0 0 0 0 0 0 funded by transaction customers Water Division Total $ 5,912,006 $ 7,829,538 $ 10,113,671 $ 9,786,132 $ 7,290,663 $ 10,824,481 $ 8,819,526 $ 10,284,560 $ 8,777,967 $ 8,568,777 $ 88,207,321 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget 10yrSummary Page 20 of 28 Truckee Donner Public Utility District TDPUD Capital Budget 2024&2025 and Forecast 2026-2033 (Working Draft) ELECTRIC Department I row Funding 10 YR Total 2024 2025 2026 2027 2028 2029 2030 2031 2032 1 2033 ref Source Project Name 1 OR Conduit&Boxes -BWO $ 172,800 $ 15,000 15,500 $ 16,000 $ 16,500 $ 17,000 $ 17,500 $ 18,000 $ 18,500 $ 19,100 $ 19,700 2 OR Line Extensions&Upgrades 6,592,700 575,000 592,300 610,100 628,400 647,300 666,700 686,700 707,300 728,500 750,400 3 OR Pole replacements 6,847,600 597,300 615,200 633,700 652,700 672,300 692,500 713,200 734,600 756,700 779,400 4 5 OR Mantis Valley Substation Rebuild 2,129,500 1,237,400 892,100 - - - - - - - - 6 OR Glenshire Substation Construction 2,792,600 643,100 2,149,500 i.. ......... ................................................................................................................................................................................................ 7� Glenshire Substation Construction -Facility Fees portion 500,000 - 500,000 - - - - 8 OR Battery Storage Project 9,250,000 250,000 3,000,000 1,500,000 1,500,000 1,500,000 1,500,000 9........._OR........._ELF Deployment..........................................................................................................................................................._1,461,300... 1,461,300 - - - - - - - - - 10 OR Reliability Improvement Projects 8,225,300 717,500 739,000 761,200 784,000 807,600 831,800 856,700 882,400 908,900 936,200 11 OR Distnbution System Capital Improvement Projects 13,261 600 1,156,800 1,191,500 1,227,300 1,264,100 1,302,000 1,341,100 1,381,300 1,422,700 1,465,400 1,509,400 12 - ............ 13 OR SCADA Reliability Improvement Projects 6,461,000 1,711,000 250,000 4,500,000 - - - - - - - 14 OR SRIP Pole Replacements Contingency 691 000 340,400 350,600 - - - - - - - - Ti - 16 OR Joint Agency Cost Sharing Projects 5,185,500 121,000 498,500 513,500 528,900 544,700 561,100 577,900 595,300 613,100 631,500 17 OR Joint Agency Contingency Project:TOT West River Streetsa 611,800 611,800 - - - - - - - - - ................................................................................................................................................................................................................................................ 18 OR 19 OR Electric System Master Plan Projects 4,062,300 1,314,300 1,353,700 1,394,300 ........................ ................ ......................... 20 OR Electric SCADA System Upgrade Project 829,300 659,500 169,800 - - - - 21 OR Substation Security Improvements 1,393,906 215,500 222,000 228,600 235,500 242,500 249,800 22 OR - 23 OR Digital Electric System Map Hardware 20,600 20,600 - - - - - ............................................................................................................................................................................................................................................................................. 24 OR Drone Inspection Equipment 103,000 103,000 - - - - - - - - - ............................................................................................................................................................................................................................................................................. 25 OR Safety Equipment(every year placeholder) 590,300 51,500 53,000 54,600 56,300 58,000 59,700 61,500 63,300 65,200 67,200 ............................................................................................................................................................................................................................................................................. 26 . Meter Testing Equipment(every other year) 290,800 51,500 - 54,600 - 58,000 - 61,500 - 65,200 - ......... ................ ..............................................,....ti...e........:....................................................................................................................................................................................................................................'27ORMeter ......................... 2,388,100 2,459,700 2,533,500 - - ........................ ....................28 OR 29 OR CONTINGENCY 2,871,000 250,000 258,000 266,000 274,000 282,000 290,000 299,000 308,000 317,000 327,000 30 OR 31 CR District Building East Wing 175,000 175,000 .............................. ...............................................................................................l.........................................................................................................................................-.........1.................................................................................-.........1..............................................................................................................................................................................-........... 32 CR District Building HVAC Improvements 85,000 85,000 - 33 CR Land/Building(Capital Reserve) 7,000,000 2,300,000 4,700,000 34 ORD Land/Building(2022 Debt Proceeds Use) 6,500,000 6,500,000 35 OR Land/Building(current rates) - 36 - 37 ELECTRIC DEPARTMENT TOTAL: $ 95,485,200 $ 14,663,500 $ 24,050,700 $ 11,759,900 $ 5,940,400 $ 6,131,400 $ 8,598,300 $ 7,115,500 $ 7,265,600 $ 4,939,100 $ 5,020,800 by Funding Source Totals 10 YR TOTALS 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 FF Facility Fees 500,000 0 500,000 0 0 0 0 0 0 0 0 OR Operating(Rates) 81,225,200 12,103,500 12,350,700 11,759,900 5,940,400 6,131,400 8,598,300 7,115,500 7,265,600 4,939,100 5,020,800 ORD Operating(Rates)Debt Issuance 6,500,000 0 6,500,000 0 0 0 0 0 0 0 0 CR Capital Reserves 7,260,000 2,560,000 4,700,000 0 0 0 0 0 0 0 0 OS Other Sources 0 0 0 0 0 0 0 0 0 0 0 ELECTRIC DEPARTMENT TOTAL: $ 95,485,200 $ 14,663,500 $ 24,050,700 $ 11,759,900 $ 5,940,400 $ 6,131,400 $ 8,598,300 $ 7,115,500 $ 7,265,600 $ 4,939,100 $ 5,020,800 Note-this schedule excludes Contributed Capital,IT, and Vehicle projects. Page 21 of 28 Truckee Donner Public Utility District TDPUD Capital Bud et 2024&2025 and Forecast 2026-2033 Workin Draft WATER UTILITY row Funding 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 ref Source Project Type 1 OR New PRV Station $ - $ - $ 204,504 i$ - i$ - i$ - i$ - i$ - i$ - i$ 2 OR New Pipeline 337,862 i 1,734,361 i 5,002,209 i 618,449 1,195,103 i 1,504,222 1,242,509 i 1,946,473 i 2,024,332 i 1,479,160 3 OR Pipeline Replacement 1,945,603 2,023,427 2,104,364 2,188,538 2,276,079 2,367,123 2,461,808 2,560,281 2,662,691 2,769,199 4 OR Pump Station Replacement 1,149,045 i 3,442,933 i 2,182,880 i 5 OR Pump Station Rehabilitation 654,806 s 680,998 s 708,238 s 736,568 s 1,340,552 s 1,394,175 s 1,449,942 s 2,154,200 s 2,240,367 s 2,329,981 6 OR PRV Rehabilitation 202,476 78,965 82,124 85,409 88,825 92,378 96,074 99,916 103,913 108,070 7 OR Well Rehabilitation 117,638 122,344 127,238 379,338 288,298 83,490 86,829 90,302 93,914 97,671 8 OR Well Replacement 468,658 s 9 OR Tank Rehabilitation 915,189 s 951,798 s 989,868 s 1,029,465 s 1,070,643 s 876,978 s 912,057 s 948,540 s 986,481 s 1,025,940 10 OR New Tank 11 OR Water SCADA 112,486 s 116,986 s 121,665 s 126,532 s 131,593 s 136,857 s 142,331 s 148,024 s 153,945 s 160,103 12 OR Generator 13 OR Facilities metering impv i 224,972 116,986 121,665 126,532 131,593 14 OR Equipment test bench 15 OR Pipe Modification fire flow 32,013 76,112 16 OR Service Modification sery pressure 92,737 167,671 i 17 OR Meter Rebuild newProject Type 241,918 18 OR Meter MTUs placeholder 1,596,778 i 1,660,293 i 1,727,075 i 19 20 ORD New Pipeline 21 ORD Pipeline Replacement 22 ORD New Tank 23 ORD Well Replacement 24 ORD Pump Station Replacement 25 26 FF New Tank 27 28 29 30 WATER DEPARTMENT TOTAL: i$ 4,877,700 $ 7,443,568 $ 9,461,875 $ 8,977,547 $ 6,522,686 $ 10,234,881 $ 8,051,843 $ 9,674,811 $ 8,265,643 $ 7,970,124 by Funding Source Totals 10 YR TOTALS 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 FF Facility Fees 0 OR Operating(Rates) 81,480,678 i 4,877,700 7,443,568 9,461,875 8,977,547 6,522,686 10,234,881 i 8,051,843 9,674,811 i 8,265,643 7,970,124 ORD Operating(Rates)Debt Issuance 0 CR 0i OS 0i WATER DEPARTMENT TOTAL: $ 81,480,678 $ 4,877,700 $ 7,443,568 $ 9,461,875 $ 8,977,547 $ 6,522,686 $ 10,234,881 $ 8,051,843 $ 9,674,811 $ 8,265,643 $ 7,970,124 Note-this schedule excludes Contributed Capital,IT and Vehicle projects. Page 22 of 28 Water Division: 2024 - 2033 Capital Improvement Projects List WATER DEPARMENT-TOTALS by YEAR New Debt Financed Facility Capital Other and Funding Source Rates Rates Fees Reserve Sources TDPUD Capital Budget 2024&2025 and Forecast 2026-2033 (Working Draft) Year OR ORD FF CR OS Total 2024 4,877,700 0 io 0 0 4,877,700 2025 7,443,568 0 0 0 7,443,568 2026 9,461,875 0 0 0 9,461,875 2027 8,977,547 0 0 0 8,977,547 2028 6,522,686 0 0 0 6,522,686 2029 10,234,881 0 0 0 10,234,881 2030 8,051,843 0 0 0 8,051,843 2031 9,674,811 0 0 0 9,674,811 2032 8,265,643 0 0 0 8,265,643 2033 7,970,124 0 0 0 7,970,124 Note-this schedule excludes Contributed Capital and Vehicle projects. 10 yr Total 81,480,678 0 0 0 0 81,480,678 Water Utility Detail by Year FUNDING UNIT CONSTRUCTION FACILITY TYPE DESCRIPTION LENGTH,FT DIAM,IN YEAR SOURCE JUSTIFICATION QUANTITY UNITS COST COST 2024 PROJECTS Facilities Facility Metering Improvements-Project D Ponderosa HDR/prosser Heights NA NA 2024 OR Life-Cycle Replacement 1 EA $ 112,486.40 $ 112,486 HDR/Prosser Villaqe Well Pit/Prosser Anex Pit/ProsHeights Well? Facilities Asphalt Replacement(x sites) NA NA 2024 OR Life-Cycle Replacement 1 EA $ 112,486.40 $ 112,486 New Pipeline 8-inch pipeline from Martiswoods Tower to Kleckner Court(need to finish tank 650 8 2024 OR Fire Flow 650 feet $ 519.79 $ 337,862 first) Pipe Modification Relocate Fire Hydrants on Hansel Avenue NA NA 2024 OR Fire Flow 2 EA $ 16,006.36 $ 32,013 Service Modification Chanqe Pressure Zone of Services on Hansel Avenue NA NA 2024 OR Provide Adequate Service Pressure 6 EA $ 15,456.15 $ 92,737 Pipeline Replacement 8"Water Main Replacement Northwoods 3000 8 2024 OR Life-Cycle Replacement 3000 feet $ 510.08 $ 1,530,241 Pipeline Replacement 12"Water Main Replacement(Northwoods) 500 12 2024 OR Life-Cycle Replacement 500 feet $ 830.72 $ 415,362 Well Rehabilitation Pump and Motor Replacement(600-1000 GPM)Prosser Annex NA NA 2024 OR Life-Cycle Replacement 1 EA $ 117,638.28 $ 117,638 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit(6170 A) NA NA 2024 OR Life-Cycle Replacement 1 EA $ 305,063.12 $ 305,063 Tank Rehabilitation Interior and Exterior Coatinq Replacement,Seimic Retrofit(Wolf Estates) NA NA 2024 OR Life-Cycle Replacement 1 EA $ 305,063.12 $ 305,063 Tank Rehabilitation Int.&Exterior Coatinq Replacement,Seimic Retrofit(Sommerset#1) NA NA 2024 OR Life-Cycle Replacement 1 EA $ 305,063.12 $ 305,063 Pump Station Rehabilitation Pump Replacement(100 HP)(Soma Sierra/Donner trails) NA NA 2024 OR Life-Cycle Replacement 4 EA $ 163,701.46 $ 654,806 PRV Rehabilitation Interior Rehabilitation and Maintenance(Michael Way,DPR(donner Lake), NA NA 2024 OR Life-Cycle Replacement 4 EA $ 25,309.44 $ 101,238 Glenshirex2) PRV Rehabilitation Interior Rehabilitation and Maintenance(Michael Way,DPR(donner Lake), NA NA 2024 OR Life-Cycle Replacement 4 EA $ 25,309.44 $ 101,238 Glenshirez2) Pump Station Replacement Martiswoods PS replacement/Remove Tower(MOVED TO 2027) NA NA 2024 OR System Reliability 1 EA $ - $ - Meter Rebuild New Meters 2024 OR Operational Efficiency 614 EA $ 337.00 $ 206,918 Meter Rebuild Meter Body Rebuild Per SB 999 Water Performance NA NA 2024 OR Operational Efficiency 140 EA $ 250.00 $ 35,000 Water SCADA Water SCADA Updates NA NA 2024 OR Life-Cycle Replacement 1 EA $ 112,486.40 $ 112,486 2024 Total $ 4,877,700 2025 PROJECTS Well Replacement Northside Well Replacement(Above Ground Facilities,Pump and Motor) NA NA 2025 OR Life-Cycle Replacement 1 EA $ 468,658.35 $ 468,658 Facilities Asphalt ReDlacement(x sites) NA NA 2025 OR Life-Cycle Replacement 1 EA $ 116,985.86 $ 116,986 New Pipeline 12-inch pipeline in Skislope Way below Ski Lodge Tank Site 1500 12 2025 OR Fire Flow 1500 feet $ 839.32 $ 1,258,973 New Pipeline 8-inch pipeline in Skislope Way below Ski Lodge Tank Site 550 8 2025 OR Fire Flow 548 feet $ 867.50 $ 475,388 Pipeline Replacement 8"Water Main Replacement(Ski Bowl Condos) 3000 8 2025 OR Life-Cycle Replacement 3000 feet $ 530.48 $ 1,591,451 Pipeline Replacement 12"Water Main Replacement 500 12 2025 OR Life-Cycle Replacement 500 feet $ 863.95 $ 431,976 Well Rehabilitation Pump and Motor Replacement(600-1000 GPM)Prosser Heights NA NA 2025 OR Life-Cycle Replacement 1 EA $ 122,343.81 $ 122,344 Pump Station Replacement Pinnacle Hydropneumatic Pump Station(corrected Qtyfrom 1 to 3 req.) NA NA 2025 OR Life-Cycle Replacement 3 EA $ 383,015.11 $ 1,149,045 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit(Somerset#2) NA NA 2025 OR Life-Cycle Replacement 1 EA $ 317,265.64 $ 317,266 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit(Blank incase steel NA NA 2025 OR Life-Cycle Replacement 1 EA $ 317,265.64 $ 317,266 h�A�f Cnmurcu}1 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit(Gateway Tank) NA NA 2025 OR Life-Cycle Replacement 1 EA $ 317,265.64 $ 317,266 Pump Station Rehabilitation Pump Replacement(100 HP)Northside Building NA NA 2025 OR Life-Cycle Replacement 4 EA $ 170,249.52 $ 680,998 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2025 OR Life-Cycle Replacement 3 EA $ 26,321.82 $ 78,965 Water SCADA Water SCADA Updates NA NA 2025 OR Life-Cycle Replacement 1 EA $ 116,985.86 $ 116,986 2025 Total $ 7,443,568 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget Water 10yr Page 4 of 9 Page 23 of 28 Water Division: 2024 - 2033 Capital Improvement Projects List Water Utility Detail by Year FUNDING UNIT CONSTRUCTION FACILITY TYPE DESCRIPTION LENGTH,FT DIAM,IN YEAR SOURCE JUSTIFICATION QUANTITY UNITS COST COST - 2026 PROJECTS Facilities Asphalt Replacement(x sites NA NA 2026 OR Life-Cycle Replacement 1 EA $ 121,665.29 121,665 New Pipeline 8-inch pipeline across Donner Pass Road to south of Fire Station No.92 550 8 2026 OR Fire Flow 550 feet $ 654.13 $ 359,773 New Pipeline 8-inch pipeline from Royal Way to Royal Crest Extension 1500 8 2026 OR Fire Flow 1500 feet $ 482.51 $ 723,761 New Pipeline 8-inch pipeline SitzmarkW to Mougle Ln to extend Sitzmark Hydro Zone 425 8 2026 OR Provide Adequate Service Pressure 425 feet $ 565.43 $ 240,307 New Pipeline Replace cross-country pipeline between Schussing Wy&St.Bernard Dr. 475 8 2026 OR Water Quality 475 feet $ 679.50 $ 322,763 New Pipeline Obeiwald PRV Site Piping(moved form 2023) 100 8 2026 OR Fire Flow 100 feet $ 655.72 $ 65,572 New PRV Station Oberwald PRV Station(Moved from 2023) NA NA 2026 OR Fire Flow 1 EA $ 102,251.87 $ 102,252 New Pipeline Pathway PRV Site Piping(Moved from 2023) 100 8 2026 OR Fire Flow 100 feet $ 655.72 $ 65,572 New PRV Station Pathway PRV Station(Moved from 2023) NA NA 2026 OR Fire Flow 1 EA $ 102,251.87 $ 102,252 New Pipeline 8-inch pipeline in Sitzmark way to extend Sitzmark Hydro Zone(moved from qn9qi 300 8 2026 OR Provide Adequate Service Pressure 300 feet $ 831.44 $ 249,431 New Pipeline 8-inch pipeline in Davos Drive to extend Stockholm Zone(Moved from 2023) 1100 8 2026 OR Provide Adequate Service Pressure 1100 feet $ 850.10 $ 935,110 New Pipeline Replace cross-country pipeline between Alder Creek Road&Wolfgang Road 500 8 2026 OR Water Quality 500 feet $ 665.67 $ 332,834 (Moved from 2023) New Pipeline 8-inch pipeline in Northwoods Boulevard to extend Donner View Zone 500 8 2026 OR Provide Adequate Service Pressure 500 feet $ 869.86 $ 434,929 New Pipeline 8-inch pipeline in Rocky Lane to extend Donner Trails Hydro Zone 1500 8 2026 OR Provide Adequate Service Pressure 1500 feet $ 848.10 $ 1,272,157 Pipeline Replacement 8"Water Main Replacement 3000 8 2026 OR Life-Cycle Replacement 3000 feet $ 551.70 $ 1,655,109 Pipeline Replacement 12"Water Main Replacement 500 12 2026 OR Life-Cycle Replacement 500 feet $ 898.51 $ 449,255 Well Rehabilitation Pump and Motor Replacement(600-1000 GPM) NA NA 2026 OR Life-Cycle Replacement 1 EA $ 127,237.56 $ 127,238 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit(Donner Lake) NA NA 2026 OR Life-Cycle Replacement 1 EA $ 329,956.27 $ 329,956 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2026 OR Life-Cycle Replacement 1 EA $ 329,956.27 $ 329,956 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2026 OR Life-Cycle Replacement 1 EA $ 329,956.27 $ 329,956 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2026 OR Life-Cycle Replacement 4 EA $ 177,059.50 $ 708,238 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2026 OR Life-Cycle Replacement 3 EA $ 27,374.69 $ 82,124 Water SCADA Water SCADA Updates NA NA 2026 OR Life-Cycle Replacement 1 EA $ 121,665.29 $ 121,665 2026 Total $ 9,461,875 2027 PROJECTS Facilities 1phalt Replacement(x sites) NA NA 2027 OR Life-Cycle Replacement 1 EA $ 126,531.90- New Pipeline 6-inch pipeline in McPhetres Street 200 6 2027 OR Fire Flow 202 feet $ 624.65 $ 126,179 New Pipeline 8-inch pipeline in Blueberry Road and Purple Sage Road to extend Palisades 550 8 2027 OR Provide Adequate Service Pressure 550 feet $ 895.04 $ 492,270 WvH-7- Service Modification Change Pressure Zone of Services on Roundhill Drive NA NA 2027 OR Provide Adequate Service Pressure 7 EA $ 23,953.06 $ 167,671 Pipe Modification Install Piping Connection at Glenshire Drive&Somerset Drive NA NA 2027 OR Water Quality 1 EA $ 76,111.98 $ 76,112 Pipeline Replacement 8"Water Main Replacement 3000 8 2027 OR Life-Cycle Replacement 3000 feet $ 573.77 $ 1,721,313 Pipeline Replacement 12"Water Main Replacement 500 12 2027 OR Life-Cycle Replacement 500 feet $ 934.45 $ 467,225 Well Rehabilitation Sanders Well Replacement(Above Ground Facilities,Pump and Motor) NA NA 2027 OR Life-Cycle Replacement 1 EA $ 379,337.58 $ 379,338 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2027 OR Life-Cycle Replacement 1 EA $ 343,154.52 $ 343,155 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2027 OR Life-Cycle Replacement 1 EA $ 343,154.52 $ 343,155 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2027 OR Life-Cycle Replacement 1 EA $ 343,154.52 $ 343,155 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2027 OR Life-Cycle Replacement 4 EA $ 184,141.88 $ 736,568 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2027 OR Life-Cycle Replacement 3 EA $ 28,469.68 $ 85,409 Pump Station Replacement Madiswoods PS replacement/Remove Tower(includes generator) NA NA 2027 OR System Reliability 1 EA $ 3,442,933.00 $ 3,442,933 Water SCADA Water SCADA Updates NA NA 2027 OR Life-Cycle Replacement 1 EA $ 126,531.90 $ 126,532 2027 Total $ 8,977,547 ' 2028 PROJECTS Facilities Asphalt Replacement(x site. NA NA 2028 OR Life-Cycle Replacement 1 EA $ 131,593.18- New Pipeline 8-inch pipeline in Olympic Boulevard from East Ridge Road to Kayhoe Court 1300 8 2028 OR Fire Flow 1300 feet $ 919.31 $ 1,195,103 Pipeline Replacement 8"Water Main Replacement 3000 8 2028 OR Life-Cycle Replacement 3000 feet $ 596.72 $ 1,790,165 Pipeline Replacement 12"Water Main Replacement 500 12 2028 OR Life-Cycle Replacement 500 feet $ 971.83 $ 485,914 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2028 OR Life-Cycle Replacement 1 EA $ 80,278.42 $ 80,278 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget Water 10yr Page 5 of 9 Page 24 of 28 Water Division: 2024 - 2033 Capital Improvement Projects List Water Utility Detail by Year FUNDING UNIT CONSTRUCTION FACILITY TYPE DESCRIPTION LENGTH,FT DIAM,IN YEAR SOURCE JUSTIFICATION QUANTITY UNITS COST COST Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2028 OR Life-Cycle Replacement 1 EA $ 356,880.70 $ 356,881 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2028 OR Life-Cycle Replacement 1 EA $ 356,880.70 $ 356,881 Tank Rehabilitation Interior and Exterior Coating Replacement,Seimic Retrofit NA NA 2028 OR Life-Cycle Replacement 1 EA $ 356,880.70 $ 356,881 Well Rehabilitation Airport Well Pump and Motor Replacement(Versus the 2021 project? NA NA 2028 OR Life-Cycle Replacement 1 EA $ 208,019.76 $ 208,020 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2028 OR Life-Cycle Replacement 4 EA $ 191,507.55 $ 766,030 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2028 OR Life-Cycle Replacement 3 EA $ 95,753.78 $ 287,261 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2028 OR Life-Cycle Replacement 3 EA $ 95,753.78 $ 287,261 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2028 OR Life-Cycle Replacement 3 EA $ 29,608.47 $ 88,825 Water SCADA Water SCADA Updates NA NA 2028 OR Life-Cycle Replacement 1 EA $ 131,593.18 $ 131,593 2028 Total $ 6,522,686 2029 PROJECTS New Pipeline 8-inch pipeline?location 1550 8 2029 OR Provide Adequate Service Pressure 1550 feet $ 970.47 $ 1,504,222 Pipeline Replacement 8"Water Main Replacement 3000 8 2029 OR Life-Cycle Replacement 3000 feet $ 620.59 $ 1,861,772 Pipeline Replacement 12"Water Main Replacement 500 12 2029 OR Life-Cycle Replacement 500 feet $ 1,010.70 $ 505,351 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2029 OR Life-Cycle Replacement 1 EA $ 83,489.55 $ 83,490 Pump Station Replacement Innsbruck Pump Station NA NA 2029 OR Life-Cycle Replacement 1 EA $ 2,182,879.68 $ 2,182,880 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2029 OR Life-Cycle Replacement 4 EA $ 199,167.85 $ 796,671 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2029 OR Life-Cycle Replacement 3 EA $ 99,583.93 $ 298,752 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2029 OR Life-Cycle Replacement 3 EA $ 99,583.93 $ 298,752 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2029 OR Life-Cycle Replacement 1 EA $ 292,326.35 $ 292,326 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2029 OR Life-Cycle Replacement 1 EA $ 292,326.35 $ 292,326 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2029 OR Life-Cycle Replacement 1 EA $ 292,326.35 $ 292,326 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2029 OR Life-Cycle Replacement 3 EA $ 30,792.80 $ 92,378 Meter MTUs Meter MTUs lifecycle replacement Year 1 of 3 NA NA 2029 OR Life-Cycle Replacement 4667 EA $ 342.14 $ 1,596,778 Water SCADA Water SCADA Updates NA NA 2029 OR Life-Cycle Replacement 1 EA $ 136,856.91 $ 136,857 2029 Total $ 10,234,881 2030 PROJECTS New Pipeline 4-inch pipeline in Northwoods Boulevard to extend Stockholm Zone 500 4 2030 OR Provide Adequate Service Pressure 500 feet $ 703.63 $ 351,814 New Pipeline 8-inch pipeline in Aspenwood Road to extend Palisades Hydro Zone 325 8 2030 OR Provide Adequate Service Pressure 325 feet $ 1,009.28 $ 328,018 New Pipeline 8-inch pipeline in Sitzmark Way to extend Sitzmark Hydro Zone 300 8 2030 OR Provide Adequate Service Pressure 300 feet $ 972.66 $ 291,799 New Pipeline 8-inch pipeline in Skislope Way to extend Donner View Hydro Zone 250 8 2030 OR Provide Adequate Service Pressure 250 feet $ 1,083.51 $ 270,878 Pipeline Replacement 8"Water Main Replacement 3000 8 2030 OR Life-Cycle Replacement 3000 feet $ 645.41 $ 1,936,243 Pipeline Replacement 12"Water Main Replacement 500 12 2030 OR Life-Cycle Replacement 500 feet $ 1,051.13 $ 525,565 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2030 OR Life-Cycle Replacement 1 EA $ 86,829.14 $ 86,829 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2030 OR Life-Cycle Replacement 1 EA $ 304,019.40 $ 304,019 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2030 OR Life-Cycle Replacement 1 EA $ 304,019.40 $ 304,019 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2030 OR Life-Cycle Replacement 1 EA $ 304,019.40 $ 304,019 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2030 OR Life-Cycle Replacement 4 EA $ 207,134.57 $ 828,538 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2030 OR Life-Cycle Replacement 3 EA $ 103,567.28 $ 310,702 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2030 OR Life-Cycle Replacement 3 EA $ 103,567.28 $ 310,702 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2030 OR Life-Cycle Replacement 3 EA $ 32,024.52 $ 96,074 Meter MTUs Meter MTUs lifecycle replacement Year 2 of 3 NA NA 2030 OR Life-Cycle Replacement 4666 EA $ 355.83 $ 1,660,293 Water SCADA Water SCADA Updates NA NA 2030 OR Life-Cycle Replacement 1 EA $ 142,331.18 $ 142,331 2030 Total $ 8,051,843 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget Water 10yr Page 6 of 9 Page 25 of 28 Water Division: 2024 - 2033 Capital Improvement Projects List Water Utility Detail by Year FUNDING UNIT CONSTRUCTION FACILITY TYPE DESCRIPTION LENGTH,FT DIAM,IN YEAR SOURCE JUSTIFICATION QUANTITY UNITS COST COST 2031 PROJECTS (REPLICATED 2030+Inflation Factor as a PLACEHOLDER) New Pipeline 12-inch pipeline in Glacier Way&Skislope Way(MOVED FROM 2024) 1750 12 2031 OR Fire Flow 1750 feet $ 1,112.27 $ 1,946,473 Pipeline Replacement 8"Water Main Replacement 3000 8 2031 OR Life-Cycle Replacement 3000 feet $ 671.23 $ 2,013,693 Pipeline Replacement 12"Water Main Replacement 500 12 2031 OR Life-Cycle Replacement 500 feet $ 1,093.18 $ 546,588 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2031 OR Life-Cycle Replacement 1 EA $ 90,302.30 $ 90,302 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2031 OR Life-Cycle Replacement 1 EA $ 316,180.18 $ 316,180 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2031 OR Life-Cycle Replacement 1 EA $ 316,180.18 $ 316,180 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2031 OR Life-Cycle Replacement 1 EA $ 316,180.18 $ 316,180 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2031 OR Life-Cycle Replacement 4 EA $ 215,419.95 $ 861,680 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2031 OR Life-Cycle Replacement 3 EA $ 107,709.98 $ 323,130 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2031 OR Life-Cycle Replacement 3 EA $ 107,709.98 $ 323,130 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2031 OR Life-Cycle Replacement 3 EA $ 107,709.98 $ 323,130 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2031 OR Life-Cycle Replacement 3 EA $ 107,709.98 $ 323,130 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2031 OR Life-Cycle Replacement 3 EA $ 33,305.50 $ 99,916 Meter MTUs Meter MTUs lifecycle replacement Year 3 of 3 NA NA 2031 OR Life-Cycle Replacement 4667 EA $ 370.06 $ 1,727,075 Water SCADA Water SCADA Updates NA NA 2031 OR Life-Cycle Replacement 1 EA $ 148,024.43 $ 148,024 2031 Total $ 9,674,811 2032 PROJECTS (REPLICATED 2031+Inflation Factor as a PLACEHOLDER) (EXCD METERS) New Pipeline 12-inch pipeline in Glacier Way&Skislope Way(MOVED FROM 2024) 1750 12 2032 OR Fire Flow 1750 feet $ 1,156.76 $ 2,024,332 Pipeline Replacement 8"Water Main Replacement 3000 8 2032 OR Life-Cycle Replacement 3000 feet $ 698.08 $ 2,094,240 Pipeline Replacement 12"Water Main Replacement 500 12 2032 OR Life-Cycle Replacement 500 feet $ 1,136.90 $ 568,451 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2032 OR Life-Cycle Replacement 1 EA $ 93,914.39 $ 93,914 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2032 OR Life-Cycle Replacement 1 EA $ 328,827.39 $ 328,827 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2032 OR Life-Cycle Replacement 1 EA $ 328,827.39 $ 328,827 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2032 OR Life-Cycle Replacement 1 EA $ 328,827.39 $ 328,827 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2032 OR Life-Cycle Replacement 4 EA $ 224,036.75 $ 896,147 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2032 OR Life-Cycle Replacement 3 EA $ 112,018.37 $ 336,055 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2032 OR Life-Cycle Replacement 3 EA $ 112,018.37 $ 336,055 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2032 OR Life-Cycle Replacement 3 EA $ 112,018.37 $ 336,055 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2032 OR Life-Cycle Replacement 3 EA $ 112,018.37 $ 336,055 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2032 OR Life-Cycle Replacement 3 EA $ 34,637.72 $ 103,913 Water SCADA Water SCADA Updates NA NA 2032 OR Life-Cycle Replacement 1 EA $ 153,945.41 $ 153,945 2032 Total $ 8,265,643 2033 PROJECTS (REPLICATED 2031+Inflation Factor as a PLACEHOLDER) (EXCD METERS) New Pipeline 12-inch pipeline in Glacier Way&Skislope Way(MOVED FROM 2024) 1750 12 2033 OR Fire Flow 1750 feet $ 845.23 $ 1,479,160 Pipeline Replacement 8"Water Main Replacement 3000 8 2033 OR Life-Cycle Replacement 3000 feet $ 726.00 $ 2,178,010 Pipeline Replacement 12"Water Main Replacement 500 12 2033 OR Life-Cycle Replacement 500 feet $ 1,182.38 $ 591,189 Well Rehabilitation Pump and Motor Replacement(300-500 GPM) NA NA 2033 OR Life-Cycle Replacement 1 EA $ 97,670.97 $ 97,671 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2033 OR Life-Cycle Replacement 1 EA $ 341,980.48 $ 341,980 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2033 OR Life-Cycle Replacement 1 EA $ 341,980.48 $ 341,980 Tank Rehabilitation Interior and Exterior Coating Replacement NA NA 2033 OR Life-Cycle Replacement 1 EA $ 341,980.48 $ 341,980 Pump Station Rehabilitation Pump Replacement(100 HP) NA NA 2033 OR Life-Cycle Replacement 4 EA $ 232,998.22 $ 931,993 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2033 OR Life-Cycle Replacement 3 EA $ 116,499.11 $ 349,497 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2033 OR Life-Cycle Replacement 3 EA $ 116,499.11 $ 349,497 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2033 OR Life-Cycle Replacement 3 EA $ 116,499.11 $ 349,497 Pump Station Rehabilitation Pump Replacement(25 HP) NA NA 2033 OR Life-Cycle Replacement 3 EA $ 116,499.11 $ 349,497 PRV Rehabilitation Interior Rehabilitation and Maintenance NA NA 2033 OR Life-Cycle Replacement 3 EA $ 36,023.22 $ 108,070 Water SCADA Water SCADA Updates NA NA 2033 OR Life-Cycle Replacement 1 EA $ 160,103.22 $ 160,103 2033 Total $ 7,970,124 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget Water 10yr Page 7 of 9 Page 26 of 28 TDPUD Capital Budget 2024&2025 and Forecast 2026-2033 (Working Draft) Capital Projects Expenditure Plan -Information Technology Project Name Split 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 E W Hardware Refresh 50% 50% 410,000 294,500 160,500 164,500 518,500 374,000 192,000 184,500 190,500 195,500 Enterprise Software 50% 50% 200,000 500,000 200,000 Data Center UPS 50% 50% 100,000 100,000 Radio System 50% 50% 150,000 1,000,000 150,000 Phone System 50% 50% 60,000 50,000 GIS Upgrade 50% 50% 500,000 500,000 Security Operations Center 50% 50% 100,000 100,000 (SOC) Contingency 50% 50% 60,000 62,000 64,000 66,000 68,000 70,000 72,000 74,000 76,000 78,000 Annual Totals 780,000 456,500 924,500 1,230,500 1,086,500 594,000 864,000 458,500 416,500 273,500 Electric Total 390,000 228,250 462,250 615,250 543,250 297,000 432,000 229,250 208,250 136,750 Water Total 390,000 228,250 462,250 615,250 543,250 297,000 432,000 229,250 208,250 136,750 10 year total 7,084,500 Electric 3,542,250 Water 3,542,250 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget IT Page 8 of 9 Page 27 of 28 TDPUD Capital Budget 2024&2025 and Forecast 2026-2033 (Working Draft) Capital Projects Expenditure Plan -Vehicles Project Name 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 E Electric fleet 497,193 763,164 356,143 452,159 628,608 390,133 325,724 602,411 517,435 659,784 W Water fleet 644,306 157,720 189,546 193,335 224,727 292,600 335,683 380,499 304,074 461,903 Total $ 1,141,499 $ 920,884 $ 545,689 $ 6457494 $ 853,335 $ 6827733 $ 6617407 $ 982,910 $ 8217509 $ 171217687 Electric Division 497,193 763,164 356,143 452,159 628,608 390,133 325,724 602,411 517,435 659,784 Water Division 644,306 157,720 189,546 193,335 224,727 292,600 335,683 380,499 304,074 461,903 10 year total 8,377,147 Eletric Fleet includes support pool vehicles. Electric 5,192,754 Water 3,184,393 Current fleet count, 81 There are 6 additions in proposed vehicle reserves capital plan, highlighted below. Current average age of fleet, 9.9 years old. For 10-year plan,the average age at replacement year is 16.1 Future years include 2.0%inflation factor applied to current replacement cost estimates. Electrtic Water Electrtic Water #323 11 Ford F-550(11yo) 149,602 #324 11 Ford F-550(11yo) 149,602 # 325 11 Ford F-550(11yo) 149,602 #301 '06 Chevy Silverado 3500(18yo) - 101,647 13 Ford Escape(10yo) 56,290 - New Pole Trailer 44,166 - #503'06 Chevy Silverado 3500(17yo) 152,633 - New Electric Excavator and attachments 143,540 - New Substation/Inspector Truck 103,704 - New IT Truck 66,249 - New Digger Derrick 450,537 - New Line Crew UTV 88,332 - 08 John Deer 410 J (15yo) - 157,720 New 3500 Foreman Truck 116,261 89 Backhoe Transport Trailer(33yo) - 38,645 2023 763,164 1577720 04 Dump Trailer(18yo) 38,645 - 06 Halmark Leak Trailer(16yo) - 55,208 2022 497,193 644,306 9/12/2023 11:53 AM I:\BUDGET\CYB\Capital\Capital Plan for Budget Vehicles Page 28 of 28