Loading...
HomeMy WebLinkAboutAgenda 05/25/2021 rc--:uuminranmu'uumum'uumur liar May 25, 2021 City of Port Angeles Council Meeting Agenda This meeting will be conducted virtually. To attend the meeting virtually, follow the instructions below, or visit www,-d1yQf`pa.us for more info regarding our virtual meetings. For audio only please call 1-844-992-4726 Use access code: 142 576 3983 If you are joining in through the Webex link: 11tt2s.//6tvofl)G�.v�ebex.conu/cityof G1/a11 tG1 l�hl�?MTID e0lc444000830479127ec81984do�cffe The access code and link are good for the May 25, 2021 meeting only. A. Call to Order — Special Meeting at 5:00 p.m. B. Roll Call C. Capital Facilities Plan (CFP) and Transportation Improvement Plan (TIP) Work Session • Presentation by Finance Director Sarina Carrizosa on the CFP and TIP for the years 2022-2027 D. Adjournment—7:00 p.m. Month Day,2021 Port Angeles City Council Meeting Page 1 2022 –2027 CAPITAL FACILITIES PLAN CITY COUNCIL WORKSESSION MAY 25, 2021 2 Overview of Capital Facilities Planning and process Citywide funding sources and expenses Capital Projects Cash Flows and : General Governmental Medic 1 Electric Water Wastewater CSO Concluding Statements Questions & Discussion CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 OV E R V I E W OUTLINE Solid Waste Stormwater Equipment Services Information Technology Transportation 3CAPITAL FACILITIES PLANNING Provides adequate public facilities to serve existing and new development. Reduces the cost of serving new development with public facilities. Ensures that these facilities will be in place when development occurs. Helps the City maximize our limited resources efficiently by planning for our needs, prioritizing and coordinating projects and identifying funding options. OV E R V I E W CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 4 OV E R V I E W CITY COUNCIL DIRECTIVES Little to no rate impact. Set aside cash that is equal to the prior years’ depreciation. Leverage projects. No new debt. Focus on preventable maintenance to increase asset life. As approved during the 2018 –2023 CFP process. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 5 OV E R V I E W HOW DOES THE CFP RELATE TO OTHER CITY DOCUMENTS? CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 6 OV E R V I E W CAPACITY The Strategic Plan approved by City Council in March of 2021includes an Issue of Critical Importance regarding Capacity, with a goal to: “Build capacity of the City to better meet the community’s needs, invest in improvements, focus on improving economic outcomes and maintain what we have.” A key focus area in this category is to reduce the CFP backlog. Capacity was also a primary focus area in the City’s workplan. Projects prioritized in the proposed CFP have taken into consideration the capacity to complete projects as well as potential alternatives to allow completion of projects. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 7 OV E R V I E W WHO HAS INPUT ON THE CFP? Capital Facilities Plan City CouncilCitizens, Boards & Advisories City Staff CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 JA N . - M A R C H Departmental development and review M A R C H - AP R I L Director Prioritization and City Manager review AP R I L Finance Department prepares cash analysis, funding options and CFP/TIP Document M A Y CFP/TIP Reviewed by City Council, Utility Advisory Committee (UAC) and Port Angeles Citizens JU N E Council conducts the 1st and 2nd Public Hearing and reading of the CFP/TIP resolution for consideration of adoption TIP is filed with the State 8 OV E R V I E W THE CFP PROCESS CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 9 OV E R V I E W THE CFP PROCESS This stage of the CFP process is City Council’s opportunity to: Learn about all capital projects. Have a policy level discussion about the CFP & TIP. Review and revise priorities. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 10 OV E R V I E W FUNDING SOURCES CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 Revenues 2021 2022 2023 2024 2025 2026 2027CSO (incl debt)2,362,200 2,306,500 2,306,500 2,305,900 2,306,300 2,307,500 2,308,800 Electric 878,800 800,000 800,000 800,000 800,000 800,000 800,000 Equipment Services 897,200 1,035,600 1,140,500 1,257,500 1,379,000 1,387,000 1,261,400 General Government 2,123,600 5,681,800 596,200 1,232,000 486,000 449,000 449,000 Information Technologies 2,035,000 600,000 180,100 380,100 180,100 - 210,000 Medic 1 49,600 49,600 50,500 50,500 50,500 50,500 50,600 Solid Waste (incl debt)1,555,500 1,848,300 1,455,000 1,460,200 1,465,600 1,471,000 1,476,500 Stormwater 425,000 434,000 443,000 452,000 971,300 470,000 479,000 Transportation 8,277,800 1,669,200 3,932,700 6,685,500 5,639,000 8,186,300 3,153,900 Wastewater 900,000 950,000 1,000,000 1,050,000 1,100,000 1,150,000 1,050,000 Water 650,000 725,000 800,000 875,000 950,000 1,025,000 750,000 Totals 20,154,700 16,100,000 12,704,500 16,548,700 15,327,800 17,296,300 11,989,200 Revenue by Type 2021 2022 2023 2024 2025 2026 2027Utility 7,909,800 7,882,700 7,869,400 8,327,600 8,055,800 8,105,500 7,840,000 Grant 6,555,400 3,630,300 2,247,500 5,225,500 4,710,300 6,900,000 1,800,000 General Fund 2,423,600 1,495,700 1,055,400 1,201,000 1,066,200 907,200 816,200 Donations 140,000 150,000 - - - - - Interest 150,400 84,000 67,600 71,700 77,400 94,000 99,100 REET 1,095,000 460,000 550,000 788,500 470,000 330,000 450,000 IT from Reserves 675,000 - - - - - - Internal service funds 12,600 5,800 6,800 10,000 6,800 1,000 7,700 Pencom 200,300 1,550,000 50,000 50,000 50,000 50,000 50,000 Range User Fees 16,300 16,300 16,300 16,300 16,300 16,300 16,300 Lodging Tax 211,000 11,000 11,000 11,000 11,000 11,000 11,000 Transportation Tax 765,300 814,200 830,500 847,100 864,000 881,300 898,900 Totals 20,154,700 16,100,000 12,704,500 16,548,700 15,327,800 17,296,300 11,989,200 11 OV E R V I E W REVENUES BY TYPE & YEAR CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 - 2 4 6 8 10 12 14 16 18 20 2021 2022 2023 2024 2025 2026 2027 Mil l i o n s REVENUES BY TYPE & YEAR Utility Grant Interest General Fund Donations REET IT from Reserves Lodging Tax Transportation Tax 12 OV E R V I E W SPENDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 Budget Expenditures 2021 2022 2023 2024 2025 2026 2027CSO (incl debt)2,506,400 2,320,100 2,398,300 2,243,800 2,101,900 2,092,800 2,092,100 Electric 8,060,700 1,800,000 1,350,000 400,000 400,000 1,600,000 650,000 Equipment Services 2,603,300 1,334,200 1,384,600 1,351,600 1,392,000 1,630,300 1,455,300 General Government 3,490,300 5,709,600 520,200 1,156,000 410,000 607,300 357,300 Information Technologies 2,342,900 775,000 180,000 280,000 180,000 - 210,000 Medic 1 36,000 37,000 - - 40,000 223,200 - Solid Waste (incl debt)1,691,500 2,605,100 1,193,900 1,192,800 1,194,300 1,194,500 1,193,800 Stormwater 591,200 965,000 826,200 1,348,000 643,000 292,400 1,271,000 Transportation 9,110,500 2,653,200 3,970,000 7,314,000 5,310,000 8,510,000 3,060,000 Wastewater 1,966,000 1,660,000 2,370,000 695,000 400,000 850,000 350,000 Water 1,167,500 2,235,000 685,000 1,792,000 790,000 1,550,000 50,000 Totals 33,566,300 22,094,200 14,878,200 17,773,200 12,861,200 18,550,500 10,689,500 CAPITAL FACILITIES PLAN 13 OV E R V I E W SPENDING BY TYPE & YEAR CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 - 5 10 15 20 25 30 35 40 2021 2022 2023 2024 2025 2026 2027 Mil l i o n s SPENDING BY PROJECT TYPE AND YEAR CSO (incl debt)Electric Equipment Services General Government Information Technologies Solid Waste (incl debt)Stormwater Transportation Wastewater Water Medic 1 14 OV E R V I E W CASH BALANCES CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 - 2 4 6 8 10 12 14 Mi l l i o n s CASH BALANCES PROJECTED BY PROJECT TYPE 2021 Beginning Cash 2027 Projected Cash 15 OV E R V I E W CASH RATIO CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 1.0 0.3 2.8 1.2 22.1 - 2.5 8.3 1.3 1.4 1.0 - 5.0 10.0 15.0 20.0 25.0 Cash Ratio to Depreciation Cash Ratio to Depreciation 16CHANGES FROM THE 2021-2026 CFP Many projects that were planned in 2020 were carried into 2021 as a result of the pandemic. This in turn delayed, or shifted, several projects in later years. Revenue collected or reserved for these projects will remain in the capital accounts for later completion of these projects. OV E R V I E W CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 17CHANGES FROM THE 2021-2026 CFP OV E R V I E W CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 PROJECT TOTAL Total 2021-2026 CFP 191,923,950 13,335,800 19,774,800 21,925,900 52,560,050 84,327,400 2020 Actuals (1,983,278) 2,238,152 (4,221,430) - - - Roll forward to 2021 and other years - - (15,553,370) 6,798,500 8,754,870 - New projects 11,857,000 - - 1,062,000 8,795,000 2,000,000 Cost changes 12,535,768 3,258,648 - 3,277,500 6,418,280 (418,660) Net changes with Unfunded (919,000) - - (3,008,000) 71,000 2,018,000 Total 2022-2027 CFP 213,414,441 18,832,600 - 30,055,900 76,599,200 87,926,740 PRIOR / FUTURE YEARS 2021 2022-2027 UNFUNDED2020 18 OV E R V I E W REVENUE SHORTFALL PLANNING Each individual project in the CFP has been carefully vetted to ensure that Council priorities have been met, revenue options are available and the projects moving forward will improve, enhance or restore City assets. However, revenue changes resulting from the COVID-19 pandemic remain uncertain. Staff is continually following and adjusting revenue estimates. The CFP will prepare the City to move forward if revenues allow. Potentially projects may be delayed if revenue collection does not meet expectations. It is important to note that revenue collection as related to capital projects met budget expectations for 2020. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 19 OV E R V I E W REVENUE SHORTFALL PLANNING Are other funding sources available? Do they require a match? Will we lose funding if project is not completed on schedule? What are the anticipated costs if we do not move ahead? Liabilities? Staff time? Inefficiencies? Will the project result in an increase in revenue for the City? 1 2 3 4 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 20 OV E R V I E W ADDITIONAL CONSIDERATIONS Potential decreases in revenues supporting projects. Impacts to utility rates. Impacts to the City’s ability to deliver essential services to the community. Evaluate the current bidding climate for affordability. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 21 OV E R V I E W ON-GOING REVIEW Revenue examination will continue to remain stringent due to the current COVID Pandemic. We are prepared to move forward if revenues stay positive. Likewise, we are prepared to postpone projects if revenues do not meet expectations. If needed, project scope may change slightly to keep infrastructure from further deterioration while keeping projects within a changing revenue scope. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 22 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 GENERAL GOVERNMENTAL PUBLIC SAFETY PARKS & RECREATION 23CASH FLOW –GOVERNMENTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 GO V E R N M E N T A L CASH FLOW ANALYSIS 2021 2022 2023 2024 2025 2026 2027Beginning balance 2,675,150 1,308,450 1,280,650 1,356,650 1,432,650 1,508,650 1,350,350 Funding sources:Utilities 225,500 60,500 85,500 60,500 60,500 60,500 60,500 Grants 394,500 3,049,700 - 700,000 - - - AR less AP (for cash flow)General Fund Funding 911,000 694,300 283,400 244,200 198,200 161,200 161,200 Donations 90,000 150,000 - - - - - Other Funds 502,600 1,727,300 227,300 227,300 227,300 227,300 227,300 - - - - - - Spending:Capital Investment (3,490,300) (5,709,600) (520,200) (1,156,000) (410,000) (607,300) (357,300) Ending Cash Balance 1,308,450 1,280,650 1,356,650 1,432,650 1,508,650 1,350,350 1,442,050 Projected Depreciation 954,603 1,203,745 1,343,890 1,398,089 1,417,355 1,432,292 1,472,230 Cash to depreciation ratio 1.37 1.06 1.01 1.02 1.06 0.94 0.98 24CLOSED & NEW PROJECTS Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 GO V E R N M E N T A L PROJECTS COMPLETED IN 2020 ACTUAL BUDGET GG1113 Facility Security Projects 49,872 91,000 PD0116 Mobile Data Terminal Replacements 16,731 25,000 PD0307 Police Regional Training & Gun Range Facility 39,360 40,000 PD0120 Police Taser Replacements 13,056 13,100 PD0119 Computer Aided Dispatch 261,351 260,000 FD0219 EOC/911/Westside Fire Station 62,840 48,000 PK0216 Facility Improvement Revolving Fund 16,519 15,000 PK0418 Civic Field Upgrades 136,315 135,200 PK0318 Waterfront Trail Rip-Rap Repair 93,809 103,000 PK0520 Civic Field Goal Posts 9,562 9,600 699,415 739,900 TOTAL COMPLETED PROJECTS NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETPD0121EOC/911 Dispatch (Pencom center)5 4,000,000 - FD0121 West Side Fire Station UF 3,000,000 - TOTAL 7,000,000 - 25 Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 GENERAL GOVERNMENTAL -ACTIVE & PRIORITIZED & UNFUNDED PROJECTS GO V E R N M E N T A L Number Title GENERAL GOVERNMENT/FACILITIES GG0303 NICE Program R R 837,100 787,100 75,000 - GG1113 Facility Security Projects A A 256,000 256,000 134,400 - ACTIVE TOTALS 1,093,100 1,043,100 209,400 - - GG0416 City Hall Fire Detection System 3 3 75,000 75,000 75,000 - GG0516 Senior Center Fire Detection System 4 4 50,000 50,000 50,000 - PRIORITIZED TOTALS 125,000 125,000 125,000 - - GG0119 Ennis Creek Fish Barrier Removal UF 6 950,000 1,200,040 - - 199,700 GG0916 Valley Creek Restoration Phase III UF UF 2,110,900 2,110,900 - - UNFUNDED TOTALS 3,060,900 3,310,940 - - 199,700 GRAND TOTAL GENERAL GOVERNMENTAL PROJECTS 4,279,000 4,479,040 334,400 - 199,700 GENERAL GOVERNMENT CAPITAL PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 26 Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 PUBLIC SAFETY -ACTIVE & PRIORITIZED PROJECTS GO V E R N M E N T A L Number Title PUBLIC SAFETY FD0415 Fire Department Turn-Out Gear R R 160,300 160,300 - - 25,000 FD0615 Fire Hoses R R 42,400 47,400 10,000 - FD0218 Self Contained Breathing Apparatus R R 250,000 250,000 - - CAPPC Pencom Capital R R 660,400 710,400 158,900 - PD0307 Police Regional Training & Gun Range Facility R R 200,000 232,000 32,000 - PD0116 Mobile Data Terminal Replacements A R 214,400 230,400 24,300 - 118,400 PD0120 Police Taser Replacements A A 120,000 130,600 27,200 2,200 PD0119 Computer Aided Dispatch/Law Enforcement Records Management System A A 300,000 301,400 40,000 - ACTIVE TOTALS 1,947,500 2,062,500 292,400 2,200 143,400 FD0315 Fire Station Garage Door Replacement 1 1 50,000 50,000 50,000 - FD0318 Emergency Management Pods 2 2 150,000 150,000 100,000 50,000 PD0121 EOC/911 Dispatch (Pencom center)NEW 5 New 4,000,000 - - 2,500,000 PRIORITIZED TOTALS 200,000 4,200,000 150,000 50,000 2,500,000 TOTAL PUBLIC SAFETY ACTIVE & PRIORITIZED PROJECTS 2,147,500 6,262,500 442,400 52,200 2,643,400 AMEND. REQUEST GRANT FUNDING GOVERNMENT CAPITAL PROJECTS - PUBLIC SAFETY 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET 27 Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 PUBLIC SAFETY -UNFUNDED GO V E R N M E N T A L Number Title PUBLIC SAFETY FD0121 West Side Fire Station NEW UF New 3,000,000 - - FD0120 Fire Station Front Driveway Repair UF UF 30,000 30,000 - - GG0616 Fire Hall HVAC UF UF 45,000 45,000 - - FD0216 Fire Training Facility UF UF 80,000 80,000 - - FD0316 Senior Center EOC Generator (Secondary City EOC)UF UF 150,000 150,000 - - FD0416 Radio Transmittor Generator (I & 10th Streets)UF UF 15,000 15,000 - - UNFUNDED TOTALS 320,000 3,320,000 - - - 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING GOVERNMENT CAPITAL PROJECTS - PUBLIC SAFETY 28 Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 PARKS & RECREATION -ACTIVE PROJECTS GO V E R N M E N T A L Number Title PARKS AND RECREATION PK0216 Facility Improvement Revolving Fund R R 105,000 121,500 15,000 - PK0205 Restroom Replacement Program R R 1,200,000 1,350,000 450,000 - PK0418 Civic Field Upgrades R R 110,000 112,500 - - PK0318 Waterfront Trail Rip-Rap Repair R R 683,000 593,000 109,200 - 32,000 PK0819 City Pier Railing Replacement A A 565,000 565,000 362,200 (130,000) PK0120 24 Hour Restroom Pilot Project A A 200,000 200,000 200,000 - PK0220 Synthetic Field Turf at Volunteer Field A A 1,200,000 1,200,000 - - 1,050,000 PK0219 Generation II Dream Playground A A 475,000 475,000 346,900 - PK0719 Parks Maintenance Building A A 756,500 706,500 250,000 - PK0919 Fine Arts Center Capital Improvements A A 40,200 83,700 40,200 3,200 PK0119 Erickson Playfield Pump Track A A 400,000 650,000 650,000 250,000 350,000 PK0519 City Pier Erosion Stabilization & Sidewalk Repair (Peabody Creek)5 A 290,000 290,000 290,000 - ACTIVE TOTALS 6,024,700 6,347,200 2,713,500 123,200 1,432,000 AMEND. REQUEST GRANT FUNDING 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET GOVERNMENT CAPITAL PROJECTS - PARKS & RECREATION 29 Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 PARKS & RECREATION -UNFUNDED GO V E R N M E N T A L Number Title PARKS AND RECREATION PK0316 Locomotive #4 Refurbishment UF UF 250,000 250,000 - - PK0319 City Pier Inspection Repairs UF UF 835,000 900,000 - - PK0320 HVAC Upgrades at City Hall & Sr Center UF UF 1,000,000 1,750,000 - - PK0406 Shane & Elks Field Lighting UF UF 1,000,000 1,000,000 - - PK0420 Ediz Hook Boat Launch Repairs UF UF 250,000 275,000 - - PK0802 Neighborhood Park Development UF UF 250,000 250,000 - - UNFUNDED TOTALS 3,585,000 4,425,000 - - - GOVERNMENT CAPITAL PROJECTS - PARKS & RECREATION 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING MEDIC 1 30 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 31CASH FLOW –MEDIC 1 CASH FLOW ANALYSIS 2021 2022 2023 2024 2025 2026 2027Beginning balance 1,332,899 1,346,499 1,359,099 1,409,599 1,460,099 1,470,599 1,297,899 Funding sources:Utilities 49,600 49,600 50,500 50,500 50,500 50,500 50,600 Grants - - - - - - - Use of existing reserves in Medic 1 - - - - - - - General Fund - - - - - - - Interest/Donations - - - - - - - Other Funds - - - - - - - Spending:- - - - - - - Capital Investment (36,000) (37,000) - - (40,000) (223,200) - Ending Cash Balance 1,346,499 1,359,099 1,409,599 1,460,099 1,470,599 1,297,899 1,348,499 Projected Depreciation 52,370 58,824 58,542 47,703 53,103 72,521 61,100 Cash to depreciation ratio 25.71 23.10 24.08 30.61 27.69 17.90 22.07 ME D I C 1 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 32 ME D I C 1 MEDIC 1 CLOSED & ACTIVE PROJECTS Indicates the project is newIndicates 2020 comparison ME D I C 1 PROJECTS COMPLETED IN 2020 ACTUAL BUDGET CAPM1 Medic 1 Revolving 170,729 183,200 170,729 183,200 TOTAL COMPLETED PROJECTS CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 Number TitleCAPM1Medic 1 Revolving R R 366,400 353,900 - (30,600) FD0118 Defibrillator Revolving Account R R 256,000 221,000 36,000 - ACTIVE TOTALS 622,400 574,900 36,000 (30,600) - MEDIC 1 PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING ELECTRIC 33 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 34CASH FLOW –ELECTRIC EL E C T R I C CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 12,585,718 5,403,818 4,403,818 3,853,818 4,253,818 4,653,818 3,853,818 Funding sources:Electric Rates Transfer 800,000 800,000 800,000 800,000 800,000 800,000 800,000 For building from ReservesAdjustments for cash timingGeneral Fund - - - - - - - Donations/Insurance 50,000 - - - - - - Other Funds/Grants 28,800 - - - - - - Spending:Project cost (8,060,700) (1,800,000) (1,350,000) (400,000) (400,000) (1,600,000) (650,000) Ending Cash Balance 5,403,818 4,403,818 3,853,818 4,253,818 4,653,818 3,853,818 4,003,818 Depreciation 1,512,166 1,684,777 1,688,535 1,715,413 1,698,454 1,622,385 1,585,188 Depreciation to Cash Ratio 3.57 2.61 2.28 2.48 2.74 2.38 2.53 CASH FLOW ANALYSIS 35 EL E C T R I C CLOSED & NEW PROJECTS Indicates the project is newIndicates 2020 comparison NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETCL0221Underground Cable Replacement - 2026 11 250,000 - CL0121 Overhead Reconductoring - 2027 13 250,000 - CL0321 Underground Cable Replacement - 2027 14 250,000 - TOTAL 750,000 - PROJECTS COMPLETED IN 2020 Actual BudgetCLCAP/CL0212 Distribution/Overhead/Poles/Yard Lighting 53,435 200,000 CL0319 Underground Cable Replacement 2020 147,617 200,000 TOTAL COMPLETED PROJECTS 201,052 400,000 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 36 EL E C T R I C ACTIVE PROJECTS Indicates the project is newIndicates 2020 comparison Number TitleCLCAPMaintenance Capital Contribution R R 1,150,000 1,102,000 150,000 (50,000) CL0414 Construct New Light Ops Building A A 6,400,000 6,399,900 5,970,800 - CL0916 Replace Laurel Street Substation Switchgear A A 500,000 500,000 500,000 - CL0220 Laurel Street LTC Load Tap Changer Replacement 5 A 200,000 200,000 200,000 - CL0716 F Street Substation Switchgear 1 A 500,000 500,000 500,000 - CL0320 F Street LTC Load Tap Changer Replacement 6 A 200,000 200,000 200,000 - CL0119 Overhead Reconductoring - 2020 2 A 200,000 250,000 241,900 50,000 CL0419 Underground Cable Replacement - 2021 9 A 250,000 250,000 250,000 - CL0620 Electric Vehicle Charging Station 10 A 48,000 48,000 48,000 - 28,800 ACTIVE TOTALS 9,448,000 9,449,900 8,060,700 - 28,800 ELECTRIC PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL GRANT FUNDING 2021 PROPOSED BUDGET AMEND. REQUEST CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 37 EL E C T R I C PRIORITIZED Indicates the project is newIndicates 2020 comparison Number TitleCL0217I Street Substation Switchgear Replacement 4 1 500,000 500,000 - (500,000) CL0420 College Street LTC Load Tap Changer Replacement 7 2 200,000 200,000 - (200,000) CL0919 "A" Street Substation Switchgear Replacement 8 3 500,000 500,000 - (500,000) CL0519 Underground Cable Replacement - 2022 11 4 250,000 250,000 - - CL0216 City/PUD Service Area Capital Needs 12 5 400,000 400,000 - - CL0117 Washington Street Substation Switchgear 13 6 500,000 500,000 - - CL0819 Overhead Reconductoring - 2023 14 7 200,000 250,000 - - CL0619 Underground Cable Replacement - 2023 15 8 250,000 250,000 - - CL0719 Underground Cable Replacement - 2024 16 9 250,000 250,000 - - CL1019 Underground Cable Replacement - 2025 17 10 250,000 250,000 - - CL0221 Underground Cable Replacement - 2026 -11 -250,000 - - CL0120 F Street Transformer Replacement 18 12 1,200,000 1,200,000 - - CL0121 Overhead Reconductoring - 2027 -13 -250,000 - - CL0321 Underground Cable Replacement - 2027 -14 -250,000 - - PRIORITIZED TOTALS 4,500,000 5,300,000 - (1,200,000) - ELECTRIC PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 38 EL E C T R I C UNFUNDED Indicates the project is newIndicates 2020 comparison Number TitleCL0202Feeder Tie Hwy 101, Porter to Golf Course Road UF UF 350,000 350,000 - - CL0816 College Street Substation Switchgear UF UF 500,000 500,000 - - CL0520 Substation Seismic Bracing UF UF 500,000 500,000 - - UNFUNDED TOTALS 1,350,000 1,350,000 - - - 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING ELECTRIC PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 WATER 39 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 40 W A T E R CASH FLOW –WATER 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 4,460,403 3,942,903 2,432,903 2,547,903 1,630,903 1,790,903 1,265,903 Funding sources:Water Rates 650,000 725,000 800,000 875,000 950,000 1,025,000 750,000 GrantsBonds/Interest/OtherGeneral FundDonationsOther Funds Spending: Project Costs (1,167,500) (2,235,000) (685,000) (1,792,000) (790,000) (1,550,000) (50,000) Ending Cash Balance 3,942,903 2,432,903 2,547,903 1,630,903 1,790,903 1,265,903 1,965,903 Depreciation 1,745,307 1,766,904 1,838,507 1,842,289 1,866,604 1,916,506 1,900,469 Depreciation to Cash Ratio 2.26 1.38 1.39 0.89 0.96 0.66 1.03 CASH FLOW ANALYSIS CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 41 W A T E R CLOSED & NEW PROJECTS NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETWT0321Facility Assessment (NEW)3 8,000 8,000 WT0221 Race Street Water Main Replacement South (N 4 637,000 637,000 WT0121 White Creek & 3rd St Crossing Main (NEW)5 400,000 - WT0421 Race Street Water Main Replacement North (N 6 125,000 125,000 TOTAL 1,170,000 770,000 PROJECTS COMPLETED IN 2020 ACTUAL BudgetWT0118Ranney Well Roof 60,550 90,000 WT0520 Sodium Hypochorlite Generaton System 143,327 151,200 TOTAL COMPLETED PROJECTS 203,877 241,200 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 42 W A T E R ACTIVE PROJECTS Indicates the project is newIndicates 2020 comparison Number Title WATERCAPWT General Water Equipment R R 466,300 466,300 50,000 (81,500) WT0220 Ranney Well Generator Relocate A A 175,000 175,000 175,000 - WT0419 Decant Facility at Transfer Station - Water Soils Decant Bays A A 200,000 800,000 28,500 (165,000) ACTIVE TOTALS 841,300 1,441,300 253,500 (246,500) - WATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 43 W A T E R PRIORITIZED PROJECTS Indicates the project is newIndicates 2020 comparison Number TitleWT0218Reservoir Instrumentation Repairs 2 1 275,000 246,100 44,000 (228,900) WT0619 Peabody Reservoir Inlet Pipe Replacement 3 2 340,000 340,000 40,000 (300,000) WT0321 Facility Assessment (NEW)-3 - 8,000 8,000 8,000 WT0221 Race Street Water Main Replacement South (NEW)-4 - 637,000 637,000 637,000 WT0121 White Creek & 3rd St Crossing Main (NEW)-5 - 400,000 - - WT0421 Race Street Water Main Replacement North (NEW)-6 - 125,000 125,000 125,000 WT0519 Water Treatment Plant Repairs 4 7 170,000 180,000 60,000 (110,000) WT0319 Ground Water Resiliency Program 5 8 1,400,000 1,275,000 - (650,000) WT0420 Ennis Creek Water Main Relocate 8 9 200,000 200,000 - - WT0111 Liberty Street Water Main 9 10 485,700 485,700 - - WT0512 East 4th Street Water Main 11 11 472,000 472,000 - - WT0212 East 6th Street Water Main 12 12 340,000 340,000 - - WT0612 3rd & Vine Street Main 7 13 360,000 360,000 - (360,000) WT0219 Peabody Heights Floating Cover Replacement 10 14 400,000 400,000 - - WT0412 West 4th Street Water Main 13 15 1,500,000 1,500,000 - - PRIORITIZED TOTALS 5,942,700 6,968,800 914,000 (878,900) - 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING WATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 44 W A T E R UNFUNDED Indicates the project is newIndicates 2020 comparison Number TitleWT0320Morse Creek Transmission Main Eval/Design 6 UF 400,000 400,000 - (400,000) WT0120 Water System SCADA Upgrade (Accomplished W/Service TSI)1 UF 650,000 650,000 - (650,000) WT0717 Race/Caroline Street Fire Flow UF UF 670,000 670,000 - - WT0112 10th Street Water Main UF UF 905,000 905,000 - - WT0116 Marine Drive Main Replacement Phase II UF UF 1,500,000 1,500,000 - - WT0117 Mill Creek Reservoir Expansion UF UF 3,400,000 3,400,000 - - WT0119 McDougal Pressure Subzone UF UF 700,000 700,000 - - WT0214 Transmission Main East of Golf Course Road UF UF 2,275,000 2,275,000 - - WT0217 Airport/Edgewood Drive Water Main Extension UF UF 5,000,000 5,000,000 - - WT0314 Tumwater Truck Route Commercial Fire Flow (LID)UF UF 289,000 289,000 - - WT0317 Scribner Booster Station Upgrade UF UF 1,500,000 1,500,000 - - WT0318 Viewcrest/Laurel Intertie/PRV UF UF 200,000 200,000 - - WT0417 1st/Laurel Street Fire Flow UF UF 384,000 384,000 - - WT0418 10th/11th Alley Water Main Replacement UF UF 150,000 150,000 - - WT0517 6th/Laurel and 5th Street Fire Flow UF UF 641,000 641,000 - - WT0617 Porter Street Zone PRV Improvements UF UF 300,000 300,000 - - WT0817 St Andrews Place Fire Flow Loop UF UF 530,000 530,000 - - WT0917 East First Street Fire Flow UF UF 92,000 92,000 - - WT1017 18th Street Fire Flow UF UF 480,500 480,500 - - WT1117 Lauridsen Blvd/Tumwater Fire Flow UF UF 560,000 560,000 - - UNFUNDED TOTALS 20,626,500 20,626,500 - (1,050,000) - WATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 WASTEWATER & CSO 45 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 46CASH FLOW –WASTEWATER & CSO 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 3,927,128 2,861,128 2,151,128 781,128 1,136,128 1,836,128 2,136,128 Funding sources:Wastewater Rates 900,000 950,000 1,000,000 1,050,000 1,100,000 1,150,000 1,050,000 Grants Spending: Project Costs (1,966,000) (1,660,000) (2,370,000) (695,000) (400,000) (850,000) (350,000) Ending Cash Balance 2,861,128 2,151,128 781,128 1,136,128 1,836,128 2,136,128 2,836,128 Depreciation 2,087,263 2,069,438 2,093,298 2,079,963 2,046,664 1,972,033 1,973,306 Depreciation to Cash Ratio 1.37 1.04 0.37 0.55 0.90 1.08 1.44 CASH FLOW ANALYSIS - WASTEWATER CASH FLOW ANALYSIS -CSO 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 918,257 774,057 760,457 668,657 730,757 935,157 1,149,857 Funding sources:CSO fee 2,301,900 2,301,900 2,301,900 2,301,900 2,301,900 2,301,900 2,301,900 Interest Earnings 60,300 4,600 4,600 4,000 4,400 5,600 6,900 Spending:Debt Payments (projected)2,316,400 2,305,100 2,248,300 2,243,800 2,101,900 2,092,800 2,092,100 Project costs 190,000 15,000 150,000 - - - - Ending Cash Balance 774,057 760,457 668,657 730,757 935,157 1,149,857 1,366,557 WA S T E W A T E R & C S O CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 47 WA S T E W A T E R CLOSED & NEW PROJECTS NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETWW0121Facility Assessment 5 8,000 8,000 WW0221 Pump Station #17 Improvements UF - - TOTAL 8,000 8,000 PROJECTS COMPLETED IN 2020 Actual BudgetCAPWWMisc Pumps for WWTP 21,586 126,000 TOTAL COMPLETED PROJECTS 21,586 126,000 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 48 WA S T E W A T E R ACTIVE PROJECTS Indicates the project is newIndicates 2020 comparison Number Title WASTEWATERCAPWWGeneral Wastewater Equipment R R 693,300 709,400 120,500 (50,000) WW0308 Pump Station #3 Replacement A A 1,479,600 1,479,600 497,500 - WW0319 Wastewater Comprehensive Plan 1 A 300,000 300,000 300,000 - WW0618 2019 Neighborhood Sewer Rehab A A 300,000 300,000 286,500 6,500 WW0718 2020 Neighborhood Sewer Rehabilitation 4 A 300,000 300,000 300,000 - WW0818 2021 Neighborhood Sewer Rehabilitation 6 A 300,000 300,000 300,000 - WW0519 Decant Facility at Transfer Station - Wastewater Soils Decant Ba A A 200,000 600,000 28,500 (165,000) ACTIVE TOTALS 3,572,900 3,989,000 1,833,000 (208,500) - 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING WASTEWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 49 WA S T E W A T E R PRIORITIZED PROJECTS Indicates the project is newIndicates 2020 comparison Number TitleWW0220West 4th Street Capacity Improvement 8 1 500,000 500,000 75,000 - WW0120 Pump Station 3 Force Main Replacement 16 2 2,200,000 2,250,000 - - WW0420 WWTP Potable Water Air-Gap 7 3 75,000 150,000 50,000 25,000 WW0320 WWTP Septic Truck Pad Repair UF 4 120,000 120,000 - - WW0121 Facility Assessment -5 - 8,000 8,000 8,000 WW0520 Sanitary Force Main Relocate (Lees Creek)9 6 200,000 200,000 - - WW0508 Digester Mixing Improvement WWTP 5 7 600,000 600,000 - (50,000) WW0516 WWTP Boiler Replacement 13 8 115,000 115,000 - - WW0419 WWTP HVAC Replacement 3 9 200,000 200,000 - (200,000) WW0715 Oak Street Sewer Separation 10 10 275,000 275,000 - - WW0815 Laurel Street Sewer Separation 11 11 275,000 275,000 - - WW0918 2025 Neighborhood Sewer Rehabilitation 12 12 300,000 300,000 - (6,500) WW1018 2026 Neighborhood Sewer Rehabilitation 14 13 300,000 300,000 - - WW1118 2027 Neighborhood Sewer Rehabilitation 15 14 300,000 300,000 - - PRIORITIZED TOTALS 5,460,000 5,593,000 133,000 (223,500) - 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING WASTEWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 50 CS O CSO -PRIORITIZED PROJECTS Indicates the project is newIndicates 2020 comparison Number Title COMBINED SEWER OVERFLOWWW0117Francis Street Pigging Bypass 1 1 190,000 190,000 190,000 - WW0316 CSO 6 and 7 Reconstruction 2 2 208,400 208,400 - - PRIORITIZED TOTALS 398,400 398,400 190,000 - - CSO PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 51 WA S T E W A T E R UNFUNDED Indicates the project is newIndicates 2020 comparison Number TitleWW0415Pump Station #5 Rehabilitation UF UF - - - - WW0915 Pump Station #6 Improvements UF UF - - - - WW0110 Aeration Blower Replacement UF UF 550,000 550,000 - - WW0217 Ennis Creek Force Main Removal UF UF 225,000 225,000 - - WW0608 Waste Activated Sludge Thickening WWTP UF UF 1,500,000 1,500,000 - - WW1115 1st & 2nd Streets Alley Sewer Separation UF UF 120,000 120,000 - - WW1215 Shane Park Sewer Separation UF UF 280,000 280,000 - - WW1315 Pine Hill Sewer Separation UF UF 275,000 275,000 - - WW0119 Biosolid Pyrolysis UF UF 4,000,000 4,000,000 - - WW0518 Francis Street Sewer Trestle Repair UF UF 50,000 50,000 - - WW0221 Pump Station #17 Improvements -UF - - - - UNFUNDED TOTALS 7,000,000 7,000,000 - - - WASTEWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 SOLID WASTE 52 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 53CASH FLOW –SOLID WASTE 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 3,093,654 2,957,654 2,200,854 2,461,954 2,729,354 3,000,654 3,277,154 Landfill Surcharge*1,361,000 1,361,000 1,361,000 1,361,000 1,361,000 1,361,000 1,361,000 Funding sources:Solid Waste Rates 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Grants 76,500 378,100 - - - - - Bonds (net used & paid)(1,194,000) (1,194,300) (1,193,900) (1,192,800) (1,194,300) (1,194,500) (1,193,800) General Fund - - - - - - - Donations - - - - - - - Interest Income 68,000 59,200 44,000 49,200 54,600 60,000 65,500 Spending:Project Cost (497,500) (1,410,800) - - - - - Ending Cash Balance 2,957,654 2,200,854 2,461,954 2,729,354 3,000,654 3,277,154 3,559,854 Depreciation 333,927 348,061 429,404 429,404 429,404 429,404 427,962 Cash/Depreciation 8.86 6.32 5.73 6.36 6.99 7.63 8.32 CASH FLOW ANALYSIS SO L I D W A S T E CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 54 SO L I D W A S T E CLOSED & NEW PROJECTS Indicates the project is newIndicates 2020 comparison NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETSW0121Landfill Access Road Repair 2 515,000 60,000 SW0221 Facility Assessment 3 8,000 8,000 SW0321 Landfill Access Road Repair - Phase 2 UF - - TOTAL 523,000 68,000 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 55 SO L I D W A S T E ACTIVE & PRIORITIZED PROJECTS Indicates the project is newIndicates 2020 comparison Number Title SOLID WASTE SW0112 Decant Facility at Transfer Station A A 672,400 966,900 154,500 (486,300) 474,300 SW0117 Landfill Operating Software A A 200,000 200,000 200,000 - ACTIVE TOTALS 872,400 1,166,900 354,500 (486,300) 474,300 Number TitleSW0120Landfill Pump Station 17 Repair 1 1 190,000 250,000 75,000 (115,000) SW0121 Landfill Access Road Repair -2 - 515,000 60,000 60,000 SW0221 Facility Assessment -3 - 8,000 8,000 8,000 PRIORITIZED TOTALS 190,000 773,000 143,000 (47,000) - SOLID WASTE PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING SOLID WASTE PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 56 SO L I D W A S T E UNFUNDED Indicates the project is newIndicates 2020 comparison Number TitleSW0321Landfill Access Road Repair - Phase 2 -UF - - - - SW0218 Landfill Security Fencing UF UF 200,000 200,000 - - UNFUNDED TOTALS 200,000 200,000 - - - SOLID WASTE PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 STORMWATER 57 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 58CASH FLOW –STORMWATER 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 2,571,973 2,405,773 1,874,773 1,491,573 595,573 923,873 1,101,473 Funding sources:Utilities Reserves*425,000 434,000 443,000 452,000 461,000 470,000 479,000 Grants - - - - 510,300 - - Bonds - - - - - - - General Fund - - - - - - - Donations/Insurance - - - - - - - Other Funds - - - - - - - Spending:Project cost (591,200) (965,000) (826,200) (1,348,000) (643,000) (292,400) (1,271,000) 2,405,773 1,874,773 1,491,573 595,573 923,873 1,101,473 309,473 Depreciation 178,095 176,602 214,992 223,225 242,603 229,986 229,986 Depreciation to Cash Ratio 13.51 10.62 6.94 2.67 3.81 4.79 1.35 CASH FLOW ANALYSIS Ending Cash Balance ST O R M W A T E R CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 59 ST O R M W A T E R CLOSED & NEW PROJECTS NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETDR0121Facility Assessment 2 8,000 8,000 TOTAL 8,000 8,000 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 60 ST O R M W A T E R ACTIVE & PRIORITIZED PROJECTS Indicates the project is newIndicates 2020 comparison Number Title STORMWATER DR0213 H Street Stormwater Outfall A A 560,000 645,500 80,000 (475,500) DR0120 Decant Facility at Transfer Station - Stormwater Soils Decant Ba A A 200,000 1,000,000 28,500 (165,000) DR0119 N Street Outfall Improvement 1 A 312,500 362,500 362,500 50,000 ACTIVE TOTALS 1,072,500 2,008,000 471,000 (590,500) - Number TitleDR0804Lincoln Park/Big Boy Pond Study 2 1 110,000 112,200 112,200 2,200 DR0121 Facility Assessment -2 - 8,000 8,000 8,000 DR0404 Stormwater at Canyon Edge & Ahlvers 3 3 3,560,000 3,631,200 - - DR0115 Liberty Street Stormwater Improvement 5 4 2,520,000 2,570,400 - - DR0117 Peabody Street Water Quality Project 4 5 651,000 665,000 - - 510,300 DR0219 Outfall to Creek Improvement Program 7 6 146,000 150,000 - - DR0215 Francis Street Outfall Repair A 7 65,000 67,000 - (65,000) PRIORITIZED TOTALS 7,052,000 7,203,800 120,200 (54,800) 510,300 2021 PROJECT TOTAL STORMWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING STORMWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 61 ST O R M W A T E R UNFUNDED Indicates the project is newIndicates 2020 comparison Number TitleDR0304Stormwater at Laurel Street & US 101 6 UF 660,000 674,000 - - DR0112 Valley Creek Culvert & Outfall UF UF 910,000 929,000 - - UNFUNDED TOTALS 1,570,000 1,603,000 - - - 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING STORMWATER PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 EQUIPMENT SERVICES 62 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 63CASH FLOW –EQUIPMENT SERVICES 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 2,571,973 2,405,773 1,874,773 1,491,573 595,573 923,873 1,101,473 Funding sources:Utilities Reserves*425,000 434,000 443,000 452,000 461,000 470,000 479,000 Grants - - - - 510,300 - - Bonds - - - - - - - General Fund - - - - - - - Donations/Insurance - - - - - - - Other Funds - - - - - - - Spending:Project cost (591,200) (965,000) (826,200) (1,348,000) (643,000) (292,400) (1,271,000) 2,405,773 1,874,773 1,491,573 595,573 923,873 1,101,473 309,473 Depreciation 178,095 176,602 214,992 223,225 242,603 229,986 229,986 Depreciation to Cash Ratio 13.51 10.62 6.94 2.67 3.81 4.79 1.35 CASH FLOW ANALYSIS Ending Cash Balance EQ U I P M E N T S E R V I C E S CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 64 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 EQ U I P M E N T S E R V I C E S PREVIOUS YEARS’ REPLACEMENTS DEPARTMENT/ VEHICLE REPLACES CARRY FWD FROM 2019 ***WASTEWATER*** 3500 TRUCK 1652 62,100 ***PARKS*** GMC SIERRA 3500 PU 4327 49,500 ***ELECTRIC*** PICKUP TRUCK 6902 35,900 Total 147,500 2020 65 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 EQ U I P M E N T S E R V I C E S CURRENT REPLACEMENT DEPARTMENT/ VEHICLE REPLACES PROPOSED 2021 DEPARTMENT/ VEHICLE REPLACES PROPOSED 2021 ***POLICE*** ***WATER*** POLICE CRUISER - FORD CROWN VICTORIA 1411 51,500 GMC 5-8 CY DUMP TRUCK 1782 230,000 POLICE CRUISER - FORD CROWN VICTORIA 4103 51,500 GMC CANYON PICK-UP 6702 39,500 POLICE CRUISER - FORD CROWN VICTORIA 5107 51,500 Total 269,500 POLICE CRUISER - DODGE CHARGER K9 PATROL 910 64,800 ***SOLID WASTE*** POLICE CRUISER - DODGE CHARGER PATROL 1110 61,400 GARBAGE TRUCK 1081 368,200 POLICE CRUISER - CHEVROLET CAPRICE K9 PATROL 1312 64,800 TOYOTA PRIUS 5802 40,100 Total 345,500 Total 408,300 *** FIRE DEPT ******EQUIPMENT SERVICES*** GMC SIERRA 1500 4X4 PICK-UP 4200 47,200 CATERPILLAR 5000 LB FORKLIF 1247 34,700 Total 47,200 DODGE CARAVAN VAN 5602 30,000 ***PARKS***Total 64,700 DODGE 4X4 FLATBED TRUCK W/SNOW PLOW 1887 82,300 ***STREET*** GRASSHOPPER MOWER 1888 19,800 FREIGHTLINER 5YD DUMP TRUCK 1579 212,000 Total 102,100 FREIGHTLINER 10YD DUMP TRUCK 1603 318,400 ***ELECTRIC***GMC SIERRA 3500 SERVICE TRUCK 4701 83,100 MANLIFT TRUCK 155 275,600 NEW HOLLAND TRACTOR W/ BOOM MOWER 1506 173,600 GMC SAVANA VAN 6901 48,000 FREIGHTLINER HOT ASPHALT PATCH TRUCK 1568 255,300 Total 323,600 Total 1,042,400 GRAND TOTAL 2,603,300 20212021 INFORMATION TECHNOLOGY 66 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 67CASH FLOW –INFORMATION TECHNOLOGY IT CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 2021 2022 2023 2024 2025 2026 2027Beginning Cash Balance 1,815,957 833,057 658,057 658,157 758,257 758,357 758,357 Funding sources: Utilities Reserves 241,200 475,200 120,300 272,800 120,300 - 140,300 Grants - - - - - - - Use of existing reserves in IT 675,000 - - - - - - General Fund 1,107,200 120,000 54,000 98,300 54,000 - 63,000 Interest/Donations - - - - - - - Other Funds 11,600 4,800 5,800 9,000 5,800 - 6,700 Project Costs (2,342,900) (775,000) (180,000) (280,000) (180,000) - (210,000) 833,057 658,057 658,157 758,257 758,357 758,357 758,357 ####425,205 674,986 671,852 635,062 625,432 623,452 613,570 Depreciation to Cash Ratio 1.96 0.97 0.98 1.19 1.21 1.22 1.24 CASH FLOW ANALYSIS Ending Cash Balance Depreciation 68 IT ACTIVE PROJECTS Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 Number Title INFORMATION SERVICESIT0714Data Backup Systems Replacement R R 210,000 420,000 210,000 - IT0514 Data Storage Array Systems R R 150,000 165,000 - (150,000) IT0319 Network Refresh R R 280,000 280,000 - - IT0918 Internal Network Segmentation & VLAN Configuration A A 221,000 221,000 9,900 - IT0816 Facility and Class Management Scheduling A A 10,000 10,000 10,000 - IT0214 Records Management System A A 104,100 104,100 30,000 - IT0416 Cemetery Software A A 30,000 30,000 30,000 - IT0119 Wireless Bridge A A 60,000 60,000 36,000 - ACTIVE TOTALS 1,065,100 1,290,100 325,900 (150,000) - AMEND. REQUEST GRANT FUNDING INFORMATION SERVICES PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET 69 IT PRIORITIZED & UNFUNDED PROJECTS Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 Number TitleIT0716ERP Road Map & Replacement 1 1 50,000 2,281,000 1,756,000 1,675,000 IT0219 City Hall Wireless Network 2 2 21,000 21,000 21,000 - IT1018 UPS Replacement - Disaster Recovery Data Center 3 3 60,000 60,000 60,000 60,000 IT0617 Executime Scheduling Module 5 4 30,000 30,000 30,000 - IT0618 Virtual Server Replacements 6 5 450,000 450,000 150,000 - IT0320 ESRI Migration to Arc Pro UF 6 100,000 100,000 - - PRIORITIZED TOTALS 711,000 2,942,000 2,017,000 1,735,000 - IT0120 Development Services Permitting Software UF UF 100,000 100,000 - - IT0216 Business License System UF UF 125,000 125,000 - - IT0220 On/Off Boarding Software UF UF 25,000 25,000 - - UNFUNDED TOTALS 250,000 250,000 - - - 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING INFORMATION SERVICES PROJECTS 70 CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TRANSPORTATION IMPROVEMENT PLAN 71CASH FLOW –TRANSPORTATION & TBD TR A N S P O R T A T I O N CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 2021B 2022 2023 2024 2025 2026 2027Beginning Cash Balance 2,984,458 2,151,758 1,167,758 1,130,458 501,958 830,958 507,258 Funding sources:Utilities Reserves 428,300 125,000 234,700 384,400 125,000 125,000 125,000 Grants 6,055,600 202,500 2,247,500 4,525,500 4,200,000 6,900,000 1,800,000 Adjustments for Cash Timing - - - - - - - General Fund 8,600 217,500 220,000 290,000 130,000 100,000 30,000 Donations/Insurance - - - - - - - REET/other 1,020,000 310,000 400,000 638,500 320,000 180,000 300,000 .2% Trans Tax 765,300 814,200 830,500 847,100 864,000 881,300 898,900 Project Costs (9,110,500) (2,653,200) (3,970,000) (7,314,000) (5,310,000) (8,510,000) (3,060,000) Emergency Street Repairs 2,151,758 1,167,758 1,130,458 501,958 830,958 507,258 601,158 Projected Depreciation 1,367,367 1,670,280 1,745,763 1,852,005 1,991,736 2,156,215 2,296,242 Cash to depreciation ratio 1.57 0.70 0.65 0.27 0.42 0.24 0.26 CASH FLOW ANALYSIS Ending Cash Balance 72CLOSED & NEW PROJECTS -TBD CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N PROJECTS COMPLETED IN 2020 - TRANSPORATION BENEFIT DISTRICT PROJECTS ACTUAL BudgetTR1299Park Avenue Chip Seal (Peabody to Race Streets)101,774 130,000 TR1516 Peabody Street Chip Seal Phase I (Lauridsen Blvd to 8th St)125,771 125,000 TR0215 Peabody Street Chip Seal Phase III (Ahlvers Rd to Park Ave)151,396 200,000 TR0315 Peabody Street Chip Seal Phase II (Park Ave to Lauridsen Blvd 217,728 225,000 TOTAL COMPLETED PROJECTS 691,761 680,000 NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETTR0121Pavement Management Plan 1 200,000 200,000 TR0221 Marine Dr Paving (Valley to Hill Street)12 1,600,000 - TOTAL 1,800,000 200,000 73ACTIVE PROJECTS -TBD Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION BENEFIT DISTRICT PROJECTSTR1118Revolving Street Improvements R R 224,500 254,500 60,000 - TR0414 Peabody Creek/Lincoln Street Culvert Repair A A 3,447,000 3,447,000 357,200 - 2,550,000 TR0218 Lincoln Street Safety A A 1,585,000 2,020,000 1,894,000 417,300 1,285,000 TR0615 Golf Course Road Chip Seal (1st St to City limits) 1 A 300,000 400,000 400,000 100,000 TR0320 2021 Pavement Preservation 5 A 400,000 400,000 400,000 - ACTIVE TOTALS 5,956,500 6,521,500 3,111,200 517,300 3,835,000 GRANT FUNDING TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST 74PRIORITIZED PROJECTS -TBD Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION BENEFIT DISTRICT PROJECTSTR0121Pavement Management Plan NEW 1 New 200,000 200,000 200,000 TR0616 ADA - Francis Street 4 2 315,000 315,000 315,000 - 300,000 TR0115 N Street Chip Seal (5th to 18th Streets)9 3 300,000 400,000 - - TR0518 I Street Chip Seal (5th to 16th Streets) 10 4 300,000 350,000 - - TR0316 8th Street Chip Seal (A to I Streets) 11 5 300,000 400,000 - - TR0618 Stevens Middle School Walking Routes 6 7 665,000 815,000 - (15,000) 650,000 TR1799 Truck Route at Hwy 101 Intersection 17 8 6,650,000 7,200,000 - - 7,000,000 TR0420 2023 Pavement Preservation 24 9 400,000 400,000 - - TR0716 ADA - Peabody Street 25 10 310,000 320,000 - - TR0119 8th Street Paving (Lincoln to A Streets)29 11 1,115,000 1,130,000 - - 700,000 TR0221 Marine Dr Paving (Valley to Hill Street)NEW 12 New 1,600,000 - - 1,400,000 TR0117 Liberty Street Reconstruction 14 13 460,000 510,000 - - TR0417 Ennis Street Pavement Repair 13 14 100,000 100,000 - - TR1416 Hamilton School Walking Routes 3 15 915,000 1,515,000 - - 1,090,000 TR0915 Park Avenue Paving Overlay (Race to Liberty Streets)26 16 390,000 520,000 - - TR0520 2024 Pavement Preservation 27 17 400,000 400,000 - - TR0620 2026 Pavement Preservation 30 18 400,000 400,000 - - TR0419 Lauridsen Blvd Reconstuction (L St to City Limits)31 19 700,000 1,000,000 - - 600,000 TR0720 18th Street Chip Seal 32 20 300,000 300,000 - - TR0818 Railroad Ave Overlay UF33 21 215,000 300,000 - - TR0219 5th Street Chip Seal (A to M Streets)12 22 350,000 350,000 - - PRIORITIZED TOTALS 14,585,000 18,525,000 515,000 185,000 11,740,000 TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 75UNFUNDED -TBD Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION BENEFIT DISTRICT PROJECTSTR0499Laurel St/Ahlvers Road Overlay UF34 UF 450,000 850,000 - - TR0816 ADA - Cherry Street UF36 UF 340,000 340,000 - - TR1015 Cherry Street Area Chip Seal UF37 UF 750,000 750,000 - - TR0916 ADA - Oak & Laurel Streets UF 39 UF 300,000 300,000 - - TR1899 Lincoln, Laurel and Lauridsen Intersection UF 41 UF 1,800,000 1,800,000 - - TR0104 2nd & Valley Streets Pavement UF 43 UF 550,000 550,000 - - TR0308 O Street Improvements UF 48 UF 1,500,000 1,500,000 - - TR0599 Hill Street Intersection Reconstuction UF 49 UF 485,000 485,000 - - TR0317 Chase Street Vicinity Chip Seal UF 51 UF 320,000 320,000 - - UNFUNDED TOTALS 6,495,000 6,895,000 - - - TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 76CLOSED & NEW PROJECTS -TRANSPORTATION CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N PROJECTS COMPLETED IN 2020 - TRANSPORATION PROJECT ACTUAL BudgetTR12165th & Liberty Streets Solar Speed Display 21,837 50,000 TR0519 Peabody Street Sidewalk Repair 73,255 94,900 TOTAL COMPLETED PROJECTS 691,761 144,900 NEW PROJECTS IN 2022-2027 CFP PRIORITY PROJECT TOTAL 2021 PROPOSED BUDGETTR0321Speed Feedback Sign Program 13 90,000 - TR0421 Valley Street Culvert Crossing 16 1,500,000 - TR0621 Facility Assessment 17 8,000 8,000 TOTAL 1,598,000 8,000 77ACTIVE PROJECTS -TRANSPORTATION Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION PROJECTSTR0405Alley Paving Revolving Funding R R 985,100 1,120,100 450,000 - TR1120 Complete Streets Revolving Fund R R 500,000 500,000 - - TR0114 Hill Street - Olympic Discovery Trail A A 3,941,600 3,941,600 7,500 (3,714,000) 198,000 TR0209 Race Street Complete Design & Construction Phase I A A 4,712,400 5,262,400 4,745,600 550,000 4,851,100 ACTIVE TOTALS 10,139,100 10,824,100 5,203,100 (3,164,000) 5,049,100 TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 78PRIORITIZED PROJECTS -TRANSPORTATION Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION PROJECTSTR0918Downtown Tree/Sidewalk Replacement Phase III 7 1 300,000 300,000 - (300,000) TR0101 Laurel Street Stairs Replacement 8 2 485,000 535,000 34,700 (450,000) TR0120 Signal Controller Upgrades 1st/Front 21 3 1,585,000 1,585,000 - - 1,562,500 TR1399 Traffic Signal Interconnect/Preemption 23 4 600,000 660,000 - - TR1215 City Hall East Parking Lot LID 15 5 610,700 751,900 71,700 (8,800) 593,400 TR0715 16th Street LID (C to L Streets)16 6 1,060,000 1,121,000 166,800 24,700 875,500 TR1020 N Street Solar Speed Display 19 7 30,000 30,000 - - TR0920 Lauridsen Blvd Flashing Beacons 18 8 40,000 40,000 - (40,000) TR0416 1St/2nd/Valley/Oak Green Alley R 9 472,200 472,200 - - 337,500 TR0919 Traffic Safety Camera Program 2 10 35,000 35,000 - (35,000) TR0909 Wayfinding & ODT Signage A 11 312,000 312,000 - (298,200) TR1116 School Area Speed Signs (Near Franklin)22 12 50,000 50,000 - - TR0321 Speed Feedback Sign Program NEW 13 New 90,000 - - TR0220 Traffic Circle Program 20 14 1,180,000 1,180,000 - (80,000) 1,170,000 TR0318 8th/10th Street Bike Lanes 28 15 400,000 400,000 - - 300,000 TR0421 Valley Street Culvert Crossing NEW 16 New 1,500,000 - - 1,300,000 TR0621 Facility Assessment NEW 17 New 8,000 8,000 8,000 PRIORITIZED TOTALS 7,159,900 9,070,100 281,200 (1,179,300) 6,138,900 TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 79UNFUNDED -TRANSPORTATION Indicates the project is newIndicates 2020 comparison CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 TR A N S P O R T A T I O N Number Title TRANSPORTATION PROJECTSTR0113Waterfront Redevelopment Phase III UF 35 UF 20,000,000 20,000,000 - - TR1016 18th Street Bike Accessibility UF 38 UF 800,000 800,000 - - TR1109 Marine Drive Bulkhead Repairs UF 40 UF - - - - TR0212 Caroline Street Slide Repair UF 42 UF 375,000 375,000 - - TR1009 1st, Front & Race Street Nodes UF 44 UF 423,000 423,000 - - TR0516 Nancy Lane Pavement UF 45 UF 200,000 200,000 - - TR0506 Valley Creek Trail Loop UF 46 UF 100,000 100,000 - - TR0208 Alternate Cross-Town Route Study UF 47 UF 220,000 220,000 - - TR1316 Traffic Control UF 50 UF 300,000 300,000 - - TR1018 Zig Zag at Oak Street UF 52 UF 500,000 500,000 - - TR0619 Race Street Complete Construction Phase II UF 53 UF 6,000,000 6,000,000 - - TR0719 First & Front Street Decoupling UF 54 UF - - - - TR0819 Sidewalks for Mt Angeles Rd & Porter St UF 55 UF 1,000,000 1,000,000 - - TR0521 I to M Paving and Sidewalk Local Improvement District NEW UF New 2,000,000 - - UNFUNDED TOTALS 29,918,000 31,918,000 - - - TRANSPORTATION PROJECTS 2020 PRIORITY 2021 PRIORITY 2020 PROJECT TOTAL 2021 PROJECT TOTAL 2021 PROPOSED BUDGET AMEND. REQUEST GRANT FUNDING 80 CO N C L U S I O N CLOSING STATEMENT The City has made great strides toward building a robust and sustainable capital budget as outlined in the Strategic and Comprehensive Plans. In order to achieve this balance guidance was utilized in the form of: Financial Policies. City Council Direction. The Strategic, Comprehensive and City Work Plans. Port Angeles Citizens Input. It is due to the efforts to build a strong foundation in the past that the City is able to continue to look into the future. CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 81 CO N C L U S I O N UPCOMING CFP EVENTS JUNE 1 JUNE 15 CFP/TIP Public Hearing & 1st Reading of Resolution CFP/TIP Public Hearing & 2nd Reading of Resolution CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021 82 CO N C L U S I O N QUESTIONS & DISCUSSION CFP & TIP COUNCIL WORKSESSION –MAY 25, 2021