Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Council Packet 05/26/2020
2021 –2026 CAPITAL FACILITIES PLAN May 26, 2020 CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW2OUTLINE2 Overview of Capital Facilities Planning and process Citywide cash flow, funding sources and expenses Capital Projects: Governmental –General, Public Safety, Parks Electric Water Wastewater CSO Solid Waste Stormwater Equipment Services IT Transportation Concluding Statements Questions & Discussion CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW3CAPITAL 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. CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW4CITY 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. CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW5HOW DOES THE CFP RELATE TO OTHER CITY DOCUMENTS? CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW6WHO HAS INPUT ON THE CFP? Capital Facilities Plan City Council Citizens, Boards & Advisories City Staff JAN. -MARCHDepartmental development and review MARCH -APRILDirector Prioritization and City Manager review APRILFinance Department prepares cash analysis, funding options and CFP/TIP Document MAYCFP/TIP Reviewed by City Council, Utility Advisory Committee (UAC) and Port Angeles Citizens JUNECouncil conducts the 1st and 2nd Public Hearing and reading of the CFP/TIP resolution for consideration of adoption TIP is filed with the State CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW7THE CFP PROCESS CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW8THE CFP PROCESS This stage of the CFP process is Council’s opportunity to: Learn about all projects Have a policy level discussion on CFP Review and revise priorities CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW9FUNDING SOURCES Budget Revenues 2020 2021 2022 2023 2024 2025 2026 CSO 2,331,900 2,335,322 2,332,421 2,333,039 2,331,045 2,332,087 2,333,226 Electric 3,350,000 850,000 800,000 800,000 800,000 800,000 800,000 Equipment Services 867,485 929,775 950,410 961,680 969,036 1,003,277 1,006,529 General Government 2,148,746 2,451,900 1,044,900 1,309,800 546,800 570,800 454,500 Information Technologies 283,800 283,800 283,800 283,800 283,800 283,800 283,800 Solid Waste (incl debt)1,551,646 1,857,719 1,469,347 1,474,848 1,480,467 1,486,222 1,492,060 Stormwater 400,000 425,000 434,000 943,000 452,000 461,000 470,000 Transportation 1,883,600 10,808,906 7,158,718 3,467,142 1,873,385 2,089,953 7,606,852 Wastewater 850,000 900,000 950,000 1,000,000 1,050,000 1,100,000 1,150,000 Water 568,000 650,000 725,000 800,000 875,000 950,000 1,025,000 Totals 14,235,177 21,492,422 16,148,597 13,373,310 10,661,534 11,077,139 16,621,967 CAPITAL FACILITIES PLAN CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW10FUNDING SOURCES Budget Revenue by Type 2020 2021 2022 2023 2024 2025 2026 Utility 7,996,100 7,903,500 8,140,210 7,715,130 7,819,661 7,982,452 8,112,004 Grant 731,000 8,557,300 5,338,000 2,618,000 508,000 1,008,000 6,508,000 General Fund 1,275,146 1,642,600 1,299,600 873,100 850,100 882,100 850,800 Donations 260,000 930,000 - 700,000 - - - nterest 125,631 124,616 125,768 131,137 131,587 135,834 140,511 REET 431,300 1,480,000 375,000 450,000 450,000 150,000 75,000 Elec Building from Reserves 2,200,000 - - - - - - nternal service funds 7,500 7,500 7,500 7,500 7,500 7,500 7,500 Pencom 116,900 50,000 50,000 50,000 50,000 50,000 50,000 User Fees 16,300 16,300 16,300 16,300 16,300 16,300 16,300 Lodging Tax 310,000 - - - - - - Transportation Tax 765,300 780,606 796,218 812,142 828,385 844,953 861,852 Totals 14,235,177 21,492,422 16,148,597 13,373,310 10,661,534 11,077,139 16,621,967 CAPITAL FACILITIES PLAN CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW11REVENUES BY TYPE & YEAR –ALL FUNDS - 5 10 15 20 25 2020 2021 2022 2023 2024 2025 2026Millions Utility Grant General Fund Donations Interest REET Elec Building from Reserves Lodging Tax Transportation Tax CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW12SPENDING Budget Expenditures 2020 2021 2022 2023 2024 2025 2026 CSO 2,294,158 2,480,351 2,301,543 2,432,736 2,278,928 2,275,121 2,271,314 Electric 8,872,864 1,198,000 600,000 1,300,000 400,000 400,000 1,350,000 Equipment Services 1,642,400 871,100 1,015,800 1,034,250 1,290,000 1,257,300 1,203,700 General Government 2,494,358 2,389,000 1,045,838 1,218,000 455,000 517,000 884,200 nformation Technologies 596,000 360,000 - 180,000 280,000 180,000 - Solid Waste (incl debt)1,763,000 1,661,300 1,194,300 1,193,900 1,192,750 1,194,325 1,194,544 Stormwater 118,037 1,125,000 281,000 1,930,000 220,000 1,251,000 655,000 Transportation 1,900,910 10,823,517 7,695,000 3,475,000 1,940,000 1,885,000 8,330,000 Wastewater 2,410,622 925,000 1,270,000 1,320,000 350,000 250,000 2,050,000 Water 806,000 2,604,000 1,000,000 520,000 722,000 590,000 1,550,000 Totals 22,898,348 24,437,267 16,403,481 14,603,886 9,128,678 9,799,746 19,488,757 CAPITAL FACILITIES PLAN CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW13SPENDING BY TYPE & YEAR –ALL FUNDS - 5 10 15 20 25 30 2020 2021 2022 2023 2024 2025 2026Millions CSO Electric Equipment Services General Government Information Technologies Solid Waste (incl debt)Stormwater Transportation Wastewater Water CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW14CASH BALANCES - 2 4 6 8 10 12 Millions2020 Beginning Cash 2026 Projected Cash CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW15CASH RATIO 0.4 0.2 3.6 2.0 - 1.3 6.8 0.5 0.7 0.6 - 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 Cash Ratio to Depreciation CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW16REVENUE SHORTFALL PLANNING Each individual project in the CFP/TIP 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, due to current challenges it is possible that some projects will need to be delayed as resources are shifted elsewhere. Revenue changes resulting from the COVID-19 pandemic remain uncertain. Staff is continually following and adjusting revenue estimates CFP will prepare the City to move forward if revenues allow. Potentially new projects may be held until July when more revenue data is available. CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW17REVENUE 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 CITY COUNCIL WORKSESSION –MAY 26, 2020 OVERVIEW18ADDITIONAL CONSIDERATIONS Potential decreases in revenues supporting projects Impacts to utility rates Anticipated injection to the local economy Impacts to the City’s ability to deliver essential services to the community Evaluate the current bidding climate for affordability GENERAL GOVERNMENTAL PUBLIC SAFETY PARKS & RECREATION CITY COUNCIL WORKSESSION –MAY 26, 2020 19 CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL20CASH FLOW CASH FLOW ANALYSIS 2020 2021 2022 2023 2024 2025 2026Beginning balance 1,625,233 1,279,621 1,342,521 1,341,583 1,433,383 1,525,183 1,578,983 Funding sources:Utilities 375,200 292,100 128,100 135,000 110,000 112,000 112,000 Grants 57,000 8,000 8,000 8,000 8,000 8,000 8,000 AR less AP (for cash flow)- - - - - - General Fund Funding 728,346 1,055,500 692,500 250,500 212,500 234,500 193,200 Donations 210,000 880,000 - 700,000 - - - Other Funds 778,200 216,300 216,300 216,300 216,300 216,300 141,300 Spending:Capital Investment (2,494,358) (2,389,000) (1,045,838) (1,218,000) (455,000) (517,000) (884,200) Ending Cash Balance 1,279,621 1,342,521 1,341,583 1,433,383 1,525,183 1,578,983 1,149,283 Projected Depreciation 1,022,179 1,183,963 1,443,081 1,761,216 2,119,831 2,494,591 2,893,497 Cash to depreciation ratio 1.25 1.13 0.93 0.81 0.72 0.63 0.40 CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL21CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2019 ACTUAL BUDGET CAPGF Finger Printing Machine 9,620 9,300 CAPPC Pencom Equipment 53,698 118,000 CAPLE Blighted Properties 12,000 18,000 FD0615 Fire Hoses 7,398 10,000 PD0116 Mobile Data Terminal replacements 26,959 28,800 FD0118 Defibrillator replacement 34,139 38,200 109,676 222,300 TOTAL COMPLETED PROJECTS NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALCAPM1Medic 1 Revolving R 366,400 PD0120 Police Taser Repalcements A 120,000 FD0120 Fire Station Front Driveway Repair UF 30,000 PK0120 24 Hour Restroom Pilot Project A 200,000 PK0220 Field Turf at Volunteer Field A 1,200,000 PK0320 HVAC Upgrades at City Hall & Sr Center UF 1,000,000 PK0802 Neighborhood Park Development UF 250,000 3,166,400 CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL22GENERAL GOVERNMENTAL -ACTIVE & PRIORITIZED PROJECTS Number Title GG0303 NICE Program R R 732,100 837,103 125,000 12,500 - GG1113 Facility Security Projects 2 A 184,268 256,000 91,000 - - 916,368 1,093,103 216,000 12,500 AMEND. REQUEST 2019 PROJECT TOTAL 2019 PRIORITY GRANT FUNDING GENERAL GOVERNMENT CAPITAL PROJECTS 2020 PRIORITY 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS Indicates the project is newIndicates 2019 comparison Number Title 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 - - 125,000 125,000 125,000 - AMEND. REQUEST GRANT FUNDING GENERAL GOVERNMENT CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL23GENERAL GOVERNMENTAL –UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title GG0916 Valley Creek Restoration Phase III UF UF 2,110,940 2,110,900 GG0119 Ennis Creek Fish Barrier Removal UF UF 950,000 950,000 GG0418 City Entrance Monuments UF UF 125,000 125,000 GG0319 Peabody Creek Daylight UF UF - - 3,185,940 3,185,900 GENERAL GOVERNMENT CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL24PUBLIC SAFETY -ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison Number Title CAPPC Pencom Capital R R 555,475 660,388 108,900 - - CAPM1 Medic 1 Revolving -R - 366,400 183,200 - - FD0415 Fire Department Turn-Out Gear R R 160,316 160,316 - - - FD0615 Fire Hoses R R 40,643 42,398 5,000 - - FD0118 Defibrillator Revolving Account R R 216,883 256,022 35,000 - - FD0218 Self Contained Breathing Apparatus R R - 250,000 - - - PD0307 Police Regional Training & Gun Range Facility UF R 80,000 200,000 40,000 40,000 - PD0116 Mobile Data Terminal Replacements A A 140,467 214,426 25,000 - Y PD0120 Police Taser Repalcements -A - 120,000 12,000 12,000 - PD0119 Computer Aided Dispatch/Law Enforcement Records Management System 1 A 300,000 300,000 160,000 (140,000) - 1,493,784 2,569,950 569,100 (88,000) AMEND. REQUEST 2020 PROPOSED BUDGET GRANT FUNDING PUBLIC SAFETY CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL25PUBLIC SAFETY –PRIORITIZED Indicates the project is newIndicates 2019 comparison Number Title FD0315 Fire Station Garage Door Replacement 7 1 50,000 50,000 50,000 - - FD0318 Emergency Management Pods 6 2 150,000 150,000 50,000 - - FD0219 EOC/911/Westside Fire Station UF 6 - 4,750,000 48,000 8,000 - 200,000 4,950,000 148,000 8,000 AMEND. REQUEST GRANT FUNDING PUBLIC SAFETY CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL26PUBLIC SAFETY –UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title FD0120 Fire Station Front Driveway Repair -UF - 30,000 GG0616 Fire Hall HVAC UF UF - 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 245,000 320,000 PUBLIC SAFETY CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL27PARKS & RECREATION ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison Number Title PK0216 Facility Improvement Revolving Fund R R 105,000 105,000 15,000 - - PK0205 Restroom Replacement Program R R 600,000 1,200,000 300,000 - - PK0418 Civic Field Upgrades A R 98,676 110,000 110,000 35,200 - PK0318 Waterfront Trail Rip-Rap Repair UF R 6,700,000 663,000 63,000 13,000 Y PK0819 City Pier Railing Replacement 9 A 165,000 565,000 163,046 46 - PK0120 24 Hour Restroom Pilot Project -A - 200,000 200,000 200,000 - PK0220 Field Turf at Volunteer Field -A - 1,200,000 - - Donation PK0219 Generation II Dream Playground 8 A 425,000 475,000 475,000 (135,000) Donation PK0719 Parks Maintenance Building 11 A 500,000 756,500 50,000 - - PK0919 Fine Arts Center Capital Improvements -A 50,000 40,212 40,212 12 - PK0119 Erickson Playfield Pump Track UF A 100,000 400,000 10,000 10,000 Donation 8,743,676 5,714,712 1,426,258 123,258 AMEND. REQUEST GRANT FUNDING PARKS & RECREATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL28PARKS & RECREATION –PRIORITIZED Indicates the project is newIndicates 2019 comparison Number Title PK0519 City Pier Erosion Stabilization & Sidewalk Repair (Peabody Creek)UF 5 - 290,000 10,000 10,000 - - 290,000 10,000 10,000 GRANT FUNDING AMEND. REQUEST PARKS & RECREATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 GOVERNMENTAL29PARKS & RECREATION –UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title PK0316 Locomotive #4 Refurbishment UF UF 50,000 250,000 PK0319 City Pier Inspection Repairs UF UF - 835,000 PK0320 HVAC Upgrades at City Hall & Sr Center -UF - 1,000,000 PK0406 Shane & Elks Field Lighting UF UF 500,000 1,000,000 PK0420 Ediz Hook Boat Launch Repairs -UF - 250,000 PK0802 Neighborhood Park Development UF UF 500,000 250,000 1,050,000 3,585,000 PARKS & RECREATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS ELECTRIC CITY COUNCIL WORKSESSION –MAY 26, 2020 30 CITY COUNCIL WORKSESSION –MAY 26, 2020 ELECTRIC31CASH FLOW 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 10,034,163 4,511,299 4,163,299 4,363,299 3,863,299 4,263,299 4,663,299 Funding sources:Electric Rates Transfer 1,100,000 800,000 800,000 800,000 800,000 800,000 800,000 For building from Reserves 2,200,000 - - - - - - Adjustments for cash timingGeneral Fund - - - - - - - Donations/Insurance 50,000 50,000 - - - - - Other Funds - - - - - - - Spending:Project cost (8,872,864) (1,198,000) (600,000) (1,300,000) (400,000) (400,000) (1,350,000) Ending Cash Balance 4,511,299 4,163,299 4,363,299 3,863,299 4,263,299 4,663,299 4,113,299 Depreciation 1,708,763 1,914,937 2,125,548 2,360,560 2,651,976 2,948,753 3,207,137 Depreciation to Cash Ratio 2.64 2.17 2.05 1.64 1.61 1.58 1.28 CASH FLOW ANALYSIS CITY COUNCIL WORKSESSION –MAY 26, 2020 ELECTRIC32CLOSED & ACTIVE PROJECTS PROJECTS COMPLETED IN 2019 Actual BudgetCL0219Underground Cable Replacement 2019 215,028 220,000 CL0218 Leasehold Improvements 95,530 150,000 TOTAL COMPLETED PROJECTS 310,558 370,000 Indicates the project is newIndicates 2019 comparison Number Title CLCAP Maintenance Capital Contribution -R - 1,150,000 200,000 (450,000) - CL0414 Construct New Light Ops Building A A 6,400,000 6,400,000 6,322,864 290,064 - CL0916 Replace Laurel Street Substation Switchgear A A 500,000 500,000 500,000 - - 6,900,000 8,050,000 7,022,864 (159,936) GRANT FUNDING AMEND. REQUEST ELECTRIC CAPITAL PROJECTS 2020 PRIORITY 2019 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 ELECTRIC33PRIORITIZED Indicates the project is newIndicates 2019 comparison Number Title CL0716 F Street Substation Switchgear 1 1 1,500,000 500,000 500,000 (1,000,000) - CL0119 Overhead Reconductoring - 2020 2 2 200,000 200,000 200,000 - - CL0319 Underground Cable Replacement - 2020 3 3 200,000 250,000 250,000 48,000 - CL0217 I Street Substation Switchgear Replacement 4 4 500,000 500,000 500,000 500,000 - CL0220 Laurel Street LTC Replacement -5 - 200,000 200,000 200,000 - CL0320 F Street LTC Replacement -6 - 200,000 200,000 200,000 - CL0420 College Street LTC Replacement -7 - 200,000 - - - CL0919 "A" Street Substation Switchgear Replacement 5 8 500,000 500,000 - - - CL0419 Underground Cable Replacement - 2021 6 9 200,000 250,000 - - - CL0620 Electric Vehicle Charging Station -10 - 48,000 - - Y CL0519 Underground Cable Replacement - 2022 7 11 200,000 250,000 - - - CL0216 City/PUD Service Area Capital Needs 12 12 400,000 400,000 - (200,000) - CL0117 Washington Street Substation Switchgear 8 13 500,000 500,000 - - - CL0819 Overhead Reconductoring - 2023 9 14 200,000 200,000 - - - CL0619 Underground Cable Replacement - 2023 10 15 200,000 250,000 - - - CL0719 Underground Cable Replacement - 2024 11 16 200,000 250,000 - - - CL1019 Underground Cable Replacement - 2025 15 17 200,000 250,000 - - - CL0120 F Street Transformer Replacement -18 - 1,200,000 - - - 5,000,000 6,148,000 1,850,000 (252,000) GRANT FUNDING AMEND. REQUEST ELECTRIC CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 ELECTRIC34UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title CL0202 Feeder Tie Hwy 101, Porter to Golf Course 13 UF 260,000 350,000 - - - CL0816 College Street Substation Switchgear UF UF 500,000 500,000 - - - CL0520 Substation Seismic Bracing -UF - 500,000 - - - 760,000 1,350,000 - - GRANT FUNDING AMEND. REQUEST ELECTRIC CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS WATER CITY COUNCIL WORKSESSION –MAY 26, 2020 35 CITY COUNCIL WORKSESSION –MAY 26, 2020 WATER36CASH FLOW 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 3,807,410 3,569,410 1,615,410 1,340,410 1,620,410 1,773,410 2,133,410 Funding sources:Water Rates 568,000 650,000 725,000 800,000 875,000 950,000 1,025,000 Grants - - - - - - - Bonds/Interest/Other - - - - - - - General Fund - - - - - - - Donations - - - - - - - Other Funds - - - - - - - Spending: Project Costs (806,000) (2,604,000) (1,000,000) (520,000) (722,000) (590,000) (1,550,000) Ending Cash Balance 3,569,410 1,615,410 1,340,410 1,620,410 1,773,410 2,133,410 1,608,410 Depreciation 1,857,058 1,892,334 1,966,443 2,068,898 2,191,755 2,335,066 2,506,176 Depreciation to Cash Ratio 1.92 0.85 0.68 0.78 0.81 0.91 0.64 CASH FLOW ANALYSIS CITY COUNCIL WORKSESSION –MAY 26, 2020 WATER37CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2019 ACTUAL BudgetCAPWT Miscellaneous Water Capital 6,561 59,500 WT0518 10th Street Water Main to N 284,649 330,000 WT0215 Marine Channel Bridge - Water 68,871 83,200 TOTAL COMPLETED PROJECTS 360,081 472,700 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALWT0220Ranney Well Generator Relocate A 175,000WT0120Water System SCADA Upgrade 1 650,000WT0320Morse Creek Transmission Main Eval/Design 6 400,000WT0420Ennis Creek Water Main Relocate 8 200,000 1,425,000 CITY COUNCIL WORKSESSION –MAY 26, 2020 WATER38ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison Number Title CAPWT General Water Equipment 10 R 469,239 466,300 50,000 (51,000) - WT0118 Ranney Well Roof A A 90,333 90,333 90,000 - - WT0220 Ranney Well Generator Relocate -A - 175,000 175,000 175,000 - WT0419 Decant Facility at Transfer Station - Water Soils Decant Bays A A 150,000 200,000 25,000 (125,000) - 709,572 931,633 340,000 (1,000) GRANT FUNDING AMEND. REQUEST 2020 PROPOSED BUDGET WATER CAPITAL PROJECTS 2020 PRIORITY 2020 PROJECT TOTAL 2019 PRIORITY 2019 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 WATER39PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison Number Title WT0120 Water System SCADA Upgrade -1 - 650,000 150,000 150,000 - WT0218 Reservoir Repairs A 2 175,000 275,000 31,000 (144,000) - WT0619 Peabody Reservoir Inlet Pipe Replacement 9 3 230,000 340,000 105,000 (125,000) - WT0519 Water Treatment Plant Repairs 3 4 170,000 170,000 30,000 (140,000) - WT0319 Ground Water Resiliency Program 1 5 600,000 1,400,000 150,000 - - WT0320 Morse Creek Transmission Main Eval/Design -6 - 400,000 - - - WT0612 3rd & Vine Street Main A 7 361,000 360,000 - (361,000) - WT0420 Ennis Creek Water Main Relocate -8 - 200,000 - - - WT0111 Liberty Street Water Main 5 9 455,609 485,739 - - - WT0219 Peabody Heights Floating Cover Replacement 7 10 400,000 400,000 - - - WT0512 East 4th Street Water Main A 11 405,000 472,000 - (405,000) - WT0212 East 6th Street Water Main 2 12 368,200 340,000 - (57,200) - WT0412 West 4th Street Water Main 4 13 1,239,400 1,500,000 - - - 4,404,209 6,992,739 466,000 (1,082,200) GRANT FUNDING AMEND. REQUEST WATER CAPITAL PROJECTS 2020 PROPOSED BUDGET 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2019 PRIORITY TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 WATER40UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title WT0717 Race/Caroline Street Fire Flow 6 UF 120,000 670,000 WT0112 10th Street Water Main 8 UF 176,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 18,297,500 19,576,500 WATER CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS WASTEWATER CITY COUNCIL WORKSESSION –MAY 26, 2020 41 CITY COUNCIL WORKSESSION –MAY 26, 2020 WASTEWATER42CASH FLOW CASH FLOW ANALYSIS - WASTEWATER 2020B 2021 2022 2023 2024 2025 2026Beginning Cash Balance 3,648,076 2,087,454 2,062,454 1,742,454 1,422,454 2,122,454 2,972,454 Funding sources:Wastewater Rates 850,000 900,000 950,000 1,000,000 1,050,000 1,100,000 1,150,000 Grants - - - - - - - Bonds/Interest/Other - - - - - - - General Fund - - - - - - Donations - - - - - - - Other Funds - - - - - - - Spending: Project Costs (2,410,622) (925,000) (1,270,000) (1,320,000) (350,000) (250,000) (2,050,000) Ending Cash Balance 2,087,454 2,062,454 1,742,454 1,422,454 2,122,454 2,972,454 2,072,454 Depreciation 2,434,130 2,463,944 2,490,667 2,598,380 2,744,333 2,889,342 3,040,592 Depreciation to Cash Ratio 0.86 0.84 0.70 0.55 0.77 1.03 0.68 CASH FLOW ANALYSIS - CSO 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 1,633,344 1,671,086 1,526,057 1,556,935 1,457,239 1,509,355 1,566,321 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 30,000 33,422 30,521 31,139 29,145 30,187 31,326 Spending:Debt Payments (projected)2,294,158 2,290,351 2,286,543 2,282,736 2,278,928 2,275,121 2,271,314 Project costs - 190,000 15,000 150,000 - - - Ending Cash Balance 1,671,086 1,526,057 1,556,935 1,457,239 1,509,355 1,566,321 1,628,234 CITY COUNCIL WORKSESSION –MAY 26, 2020 WASTEWATER43CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2019 Actual BudgetWW0205Biosolids Dewatering 1,412,926 1,435,000 WW0315 Marine Channel Bridge 75,816 89,900 WW1218 10th St Sewer Main 19,834 23,000 CAPWW Misc Pumps for WWTP 64,440 84,000 TOTAL COMPLETED PROJECTS 160,091 196,900 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALWW0420WWTP Potable Water Air-Gap 7 75,000WW0220West 4th Street Capacity Improvement 8 500,000WW0520Sanitary Force Main Relocate (Lees Creek)9 200,000WW0120Pump Station 3 Force Main Replacement 16 2,200,000WW0320WWTP Septic Truck Pad Repair UF 120,000 3,095,000 CITY COUNCIL WORKSESSION –MAY 26, 2020 WASTEWATER44ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison Number Title CAPWW General Wastewater Equipment 11 R 586,835 693,275 126,000 - - WW0308 Pump Station #3 Replacement A A 1,042,358 1,479,613 1,309,622 437,322 - WW0618 2019 Neighborhood Sewer Rehab A A 300,000 300,000 300,000 - - WW0519 Decant Facility at Transfer Station - Wastewater Soils Decant Bays A A 150,000 200,000 25,000 (125,000) - 2,079,193 2,672,888 1,760,622 312,322 GRANT FUNDING AMEND. REQUEST 2020 PROPOSED BUDGET WASTEWATER CAPITAL PROJECTS 2020 PRIORITY 2020 PROJECT TOTAL 2019 PRIORITY 2019 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 WASTEWATER45PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison Number Title WW0319 Wastewater Comprehensive Plan 4 1 300,000 300,000 200,000 - - WW0219 WWTP Digester Cleaning and Repair 2 2 100,000 100,000 100,000 - - WW0419 WWTP HVAC Replacement 1 3 200,000 200,000 50,000 (150,000) - WW0718 2020 Neighborhood Sewer Rehabilitation 5 4 300,000 300,000 300,000 - - WW0508 Digester Mixing Improvement WWTP 3 5 600,000 600,000 - (50,000) - WW0818 2021 Neighborhood Sewer Rehabilitation 6 6 300,000 300,000 - - - WW0420 WWTP Potable Water Air-Gap -7 - 75,000 - - - WW0220 West 4th Street Capacity Improvement -8 - 500,000 - - - WW0520 Sanitary Force Main Relocate (Lees Creek)-9 - 200,000 - - - WW0715 Oak Street Sewer Separation A 10 275,000 275,000 - (275,000) - WW0815 Laurel Street Sewer Separation A 11 275,000 275,000 - (275,000) - WW0918 2022 Neighborhood Sewer Rehabilitation 7 12 300,000 300,000 - - - WW0516 WWTP Boiler Replacement 8 13 115,000 115,000 - - - WW1018 2023 Neighborhood Sewer Rehabilitation 9 14 300,000 300,000 - - - WW1118 2024 Neighborhood Sewer Rehabilitation 10 15 300,000 300,000 - - - WW0120 Pump Station 3 Force Main Replacement -16 - 2,200,000 - - - 3,365,000 6,340,000 650,000 (750,000) GRANT FUNDING AMEND. REQUEST WASTEWATER CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 CSO46CSO -PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison Number Title WW0117 Francis Street Pigging Bypass -1 190,000 190,000 - (190,000) - WW0316 CSO 6 and 7 Reconstruction -2 208,449 208,449 - - - 398,449 398,449 - (190,000) GRANT FUNDING AMEND. REQUEST CSO CAPITAL PROJECTS 2020 PRIORITY 2019 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 WASTEWATER47UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title WW0415 Pump 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 2,000,000 4,000,000 WW0518 Francis Street Sewer Trestle Repair UF UF 50,000 50,000 WW0320 WWTP Septic Truck Pad Repair -UF - 120,000 5,000,000 7,120,000 WASTEWATER CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS SOLID WASTE CITY COUNCIL WORKSESSION –MAY 26, 2020 48 CITY COUNCIL WORKSESSION –MAY 26, 2020 SOLID WASTE49CASH FLOW 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 2,932,304 2,720,950 2,917,369 3,192,417 3,473,365 3,761,082 4,052,979 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 82,000 392,300 - - - - - Bonds (net used & paid)(1,193,000) (1,194,000) (1,194,300) (1,193,900) (1,192,750) (1,194,325) (1,194,544) Interest Income 58,646 54,419 58,347 63,848 69,467 75,222 81,060 Spending:Project Cost (570,000) (467,300) - - - - - Ending Cash Balance 2,720,950 2,917,369 3,192,417 3,473,365 3,761,082 4,052,979 4,350,495 Depreciation 342,297 369,827 424,252 478,676 533,101 587,525 641,950 Cash/Depreciation 7.9 7.9 7.5 7.3 7.1 6.9 6.8 CASH FLOW ANALYSIS CITY COUNCIL WORKSESSION –MAY 26, 2020 SOLID WASTE50CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2018 Actual BudgetSW0217Landfill Flare Replacement 157,274 198,500 TOTAL COMPLETED PROJECTS 157,274 198,500 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALSW0120Landfill Pump Station 17 Repair 1 190,000 190,000 Indicates the project is newIndicates 2019 comparison CITY COUNCIL WORKSESSION –MAY 26, 2020 SOLID WASTE51ACTIVE & PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison Number Title SW0112 Decant Facility at Transfer Station A A 637,354 672,354 180,000 (432,300) Y SW0117 Landfill Operating Software A A 80,000 200,000 200,000 120,000 - 717,354 872,354 380,000 (312,300) GRANT FUNDING AMEND. REQUEST 2020 PROPOSED BUDGET SOLID WASTE CAPITAL PROJECTS 2020 PRIORITY 2020 PROJECT TOTAL 2019 PRIORITY 2019 PROJECT TOTAL TOTALS Number Title SW0120 Landfill Pump Station 17 Repair -1 - 190,000 190,000 190,000 - - 190,000 190,000 190,000 GRANT FUNDING AMEND. REQUEST SOLID WASTE CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 SOLID WASTE52UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title SW0218 Landfill Security Fencing UF UF 200,000 200,000 200,000 200,000 SOLID WASTE CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS STORMWATER CITY COUNCIL WORKSESSION –MAY 26, 2020 53 CITY COUNCIL WORKSESSION –MAY 26, 2020 STORMWATER54CASH FLOW 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 2,178,493 2,460,456 1,760,456 1,913,456 926,456 1,158,456 368,456 Funding sources:Utilities Reserves*400,000 425,000 434,000 443,000 452,000 461,000 470,000 Grants - - - 500,000 - - - Bonds - - - - - - - General Fund - - - - - - - Donations/Insurance - - - - - - - Other Funds - - - - - - - Spending:Project cost (118,037) (1,125,000) (281,000) (1,930,000) (220,000) (1,251,000) (655,000) 2,460,456 1,760,456 1,913,456 926,456 1,158,456 368,456 183,456 Depreciation 179,604 180,710 193,406 216,410 265,966 317,355 364,199 Depreciation to Cash Ratio 13.70 9.74 9.89 4.28 4.36 1.16 0.50 CASH FLOW ANALYSIS Ending Cash Balance CITY COUNCIL WORKSESSION –MAY 26, 2020 STORMWATER55CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2019 Actual BudgetDR011810th Street Stormwater 328,235 387,300 DR0319 Lauridsen Blvd Stormwater 25,300 25,300 TOTAL COMPLETED PROJECTS 353,535 412,600 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALDR0120A200,000 200,000 Decant Facility at Transfer Station - Stormwater Soils Decant Bays CITY COUNCIL WORKSESSION –MAY 26, 2020 STORMWATER56ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison Number Title DR0213 H Street Stormwater Outfall A A 514,463 560,000 5,537 (504,463) - DR0215 Francis Street Outfall Repair A A 35,000 65,000 25,000 (10,000) - DR0120 Decant Facility at Transfer Station - Stormwater Soils Decant Bays A A 637,354 200,000 25,000 25,000 - 1,186,817 825,000 55,537 (489,463) GRANT FUNDING STORMWATER CAPITAL PROJECTS 2020 PRIORITY 2019 PRIORITY 2019 PROJECT TOTAL AMEND. REQUEST 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 STORMWATER57PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison Number Title DR0119 N Street Outfall Improvement 4 1 250,000 312,500 62,500 62,500 - DR0804 Lincoln Park/Big Boy Pond Study 7 2 100,000 110,000 - - - DR0404 Stormwater at Canyon Edge & Ahlvers 1 3 1,045,000 3,560,000 - (120,000) - DR0117 Peabody Street Water Quality Project 2 4 620,000 651,000 - - Y DR0115 Liberty Street Stormwater Improvement 3 5 1,135,000 2,520,000 - - - DR0304 Stormwater at Laurel Street & US 101 5 6 575,000 660,000 - - - DR0219 Outfall to Creek Improvement Program 6 7 140,000 146,000 - - - 3,865,000 7,959,500 62,500 (57,500) GRANT FUNDING AMEND. REQUEST STORMWATER CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 STORMWATER58UNFUNDED Indicates the project is newIndicates 2019 comparison Number Title DR0112 Valley Creek Culvert & Outfall UF UF - 910,000 - 910,000 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS STORMWATER CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY EQUIPMENT SERVICES CITY COUNCIL WORKSESSION –MAY 26, 2020 59 CITY COUNCIL WORKSESSION –MAY 26, 2020 EQUIPMENT 60CASH FLOW CASH FLOW ANALYSIS ACTUAL 2019 BUDGET 2020 2021 2022 2023 2024 2025 20264,274,153 4,519,937 3,745,022 3,803,697 3,738,307 3,665,737 3,344,773 3,090,750 (742,055) (1,642,400) (871,100) (1,015,800) (1,034,250) (1,290,000) (1,257,300) (1,203,700) 637,641 475,800 498,000 498,510 495,030 490,561 517,352 512,904 198,900 353,700 394,000 414,000 429,500 444,500 454,500 464,500 149,297 36,985 36,775 36,900 36,150 32,975 30,425 28,125 2,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Ending Cash Balance 4,519,937 3,745,022 3,803,697 3,738,307 3,665,737 3,344,773 3,090,750 2,893,579 Internal Service Funds Beginning Cash BalanceVehicle purchasesFunding sources:Utilities ReservesGeneral FundSales, Interest & Grants CITY COUNCIL WORKSESSION –MAY 26, 2020 EQUIPMENT61PREVIOUS YEARS’ REPLACEMENTS DEPARTMENT VEHICLE REPLACES EQ #2020 CFP POLICE POLICE CRUISER - DODGE CHARGER 6104 48,857 POLICE CRUISER - DODGE CHARGER 911 46,553 POLICE CRUISER - DODGE CHARGER 1111 46,335 FIRE FORD AMBULANCE 6 176,061 GMC ENVOY - W/FORD EXPLORER 4201 41,807 FORD TAURUS SEDAN - W/FORD 5202 40,717 EQUIPMENT SERVICES PONTIAC VIBE - W/ HYUNDAI SONATA 5425 24,597 WASTEWATER DODGE 3500 TRUCK 1652 65,025 STREET NEW ENGINE BLOCK 7505 23,582 PARKS SAVANA VAN 4400 47,001 GMC SIERRA 3500 PU 4327 57,700 Add'l expenses on Vehicle 1837 1837 320 SOLID WASTE 2500 W/LIFTGATE 4501 53,486 ELECTRIC Hyd Winch with Capstan 1650a 30,946 MANLIFT TRUCK 155 - PICKUP TRUCK 6902 39,068 742,055 TOTAL 2019 CITY COUNCIL WORKSESSION –MAY 26, 2020 EQUIPMENT62CURRENT REPLACEMENT DEPARTMENT VEHICLE REPLACES EQ #2020 CFP POLICE POLICE CRUISER 1411 50,400 POLICE CRUISER 4103 50,400 POLICE CRUISER 5107 50,400 FIRE DEPARTMENT GMC SIERRA 1500 4X4 PICK-UP 4200 44,600 WATER AIR COMPRESSOR 1776 26,000 GMC 5-8 CY DUMP TRUCK 1782 204,200 STREET 6-8 Yd Dump Truck 1579 156,100 FREIGHTLINER 5YD DUMP TRUCK 1603 318,400 GMC SIERRA 3500 SERVICE TRUCK 4701 74,300 SOLID WASTE TOYOTA PRIUS 5802 37,800 GARBAGE TRUCK 1081 354,200 ELECTRIC MANLIFT TRUCK 155 275,600 TOTAL 1,642,400 2020 INFORMATION TECHNOLOGY CITY COUNCIL WORKSESSION –MAY 26, 2020 63 CITY COUNCIL WORKSESSION –MAY 26, 2020 IT64CASH FLOW 2020 2021 2022 2023 2024 2025 2026Beginning Cash Balance 1,507,014 1,194,814 1,118,614 1,402,414 1,506,214 1,510,014 1,613,814 Funding sources: Utilities Reserves 204,200 204,200 204,200 204,200 204,200 204,200 204,200 Grants - - - - - - - Use of existing reserves in IT - - - - - - - General Fund 73,100 73,100 73,100 73,100 73,100 73,100 73,100 Interest/Donations - - - - - - - Other Funds 6,500 6,500 6,500 6,500 6,500 6,500 6,500 Project Costs (596,000) (360,000) - (180,000) (280,000) (180,000) - 1,194,814 1,118,614 1,402,414 1,506,214 1,510,014 1,613,814 1,897,614 538,471 535,268 544,937 539,157 635,147 782,838 931,975 955,710 Depreciation to Cash Ratio 2.23 2.05 2.60 2.37 1.93 1.73 1.99 Depreciation CASH FLOW ANALYSIS Ending Cash Balance CITY COUNCIL WORKSESSION –MAY 26, 2020 IT65CLOSED & NEW PROJECTS PROJECTS COMPLETED IN 2019 Actual BudgetIT0217 - SCADA Server replacements 84,138 84,900 TOTAL COMPLETED PROJECTS 84,138 84,900 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALIT0120Development Services Permitting Software UF 100,000IT0220On/Off Boarding Software UF 25,000IT0320ESRI Migration to Arc Pro UF 100,000 225,000 Indicates the project is newIndicates 2019 comparison CITY COUNCIL WORKSESSION –MAY 26, 2020 IT66ACTIVE PROJECTS Indicates the project is newIndicates 2019 comparison IT0714 Data Backup Systems Replacement 2 R 210,000 210,000 210,000 - - IT0514 Data Storage Array Systems 4 R 150,000 150,000 - - - IT0319 Network Refresh 6 R 280,000 280,000 - - - IT0918 Internal Network Segmentation & VLAN Configuration A A 220,977 220,977 130,000 - - IT0218 Click2Gov3 / Fusion A A 14,885 14,885 5,000 - - IT0816 Facility and Class Management Scheduling A A 10,000 10,000 10,000 - - IT0214 Records Management System A A 104,109 104,109 - - - IT0416 Cemetery Software 9 A 30,000 30,000 30,000 - - IT0119 Wireless Bridge 5 A 60,000 60,000 60,000 - - 1,079,971 1,079,970 445,000 - 2020 PROJECT TOTAL 2020 PROPOSED BUDGET 2019 PRIORITY 2019 PROJECT TOTAL AMEND. REQUEST GRANT FUNDINGINFORMATION TECHNOLOGY PROJECTS 2020 PRIORITY TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 IT67PRIORITIZED PROJECTS Indicates the project is newIndicates 2019 comparison IT0716 ERP Road Map 3 1 50,000 50,000 50,000 - - IT0219 City Hall Wireless Network 7 2 21,000 21,000 21,000 - - IT1018 UPS Replacement - Disaster Recovery Data Center 8 3 60,000 60,000 60,000 - - IT1118 IT Security Audit 11 4 20,000 20,000 20,000 - - IT0617 Executime Scheduling Module UF 5 30,000 30,000 - - - IT0618 Virtual Server Replacements 1 6 450,000 450,000 - - - 631,000 631,000 151,000 - 2020 PROJECT TOTAL 2020 PROPOSED BUDGET INFORMATION TECHNOLOGY PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL AMEND. REQUEST GRANT FUNDING TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 IT68UNFUNDED Indicates the project is newIndicates 2019 comparison IT0120 Development Services Permitting Software -UF - 100,000 IT0216 Business License System UF UF 125,000 125,000 IT1213 Enterprise Information System UF UF 3,200,000 3,200,000 IT0220 On/Off Boarding Software -UF - 25,000 IT0320 ESRI Migration to Arc Pro -UF - 100,000 3,325,000 3,550,000 INFORMATION TECHNOLOGY PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS TRANSPORTATION IMPROVEMENT PLAN CITY COUNCIL WORKSESSION –MAY 26, 2020 69 CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION70CASH FLOW 2016 2020B 2021 2022 2023 2024 2025 2026Beginning Cash Balance 2,056,221 2,038,911 2,024,300 1,488,019 1,480,161 1,413,546 1,618,499 Funding sources:Utilities Reserves 310,000 421,300 687,500 125,000 125,000 125,000 125,000 Grants 592,000 8,157,000 5,330,000 2,110,000 500,000 1,000,000 6,500,000 General Fund 120,000 120,000 120,000 120,000 120,000 120,000 120,000 REET 96,300 1,330,000 225,000 300,000 300,000 - - .2% Trans Tax 765,300 780,606 796,218 812,142 828,385 844,953 861,852 Project Costs (1,900,910) (10,823,517) (7,695,000) (3,475,000) (1,940,000) (1,885,000) (8,330,000) 2,038,911 2,024,300 1,488,019 1,480,161 1,413,546 1,618,499 895,352 Projected Depreciation 1,060,937 1,318,732 1,390,770 1,638,512 2,158,897 2,796,263 3,475,048 4,198,787 Cash to depreciation ratio 1.55 1.46 0.91 0.69 0.51 0.47 0.21 CASH FLOW ANALYSIS Ending Cash Balance CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION71CLOSED & NEW PROJECTS -TBD PROJECTS COMPLETED IN 2019 TBD ACTUAL BudgetTR0515Lauridsen Blvd overlay 966,604 1,030,800 TR1100 10th Street Reconstruction 1,857,086 2,000,000 TR1118 Revolving Street Improvements 14,482 30,000 TOTAL COMPLETED PROJECTS 3,448,647 3,735,800 NEW PROJECTS IN 2021-2026 CFP TBD PRIORITY ACTUALTR03202021 Pavement Preservation 5 400,000TR04202023 Pavement Preservation 24 400,000TR05202024 Pavement Preservation 27 400,000TR06202026 Pavement Preservation 30 400,000TR072018th Street Chip Seal 32 300,000 - ACTUAL Budget2019Revenue850,903 765,300 2019 Expenditures 459,482 480,000 TOTAL NET Change 1,310,384 1,245,300 TRANSPORTATION BENEFIT DISTRICT FUNDS CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION72ACTIVE PROJECTS -TBD Indicates the project is newIndicates 2019 comparison Number Title TR1118 Revolving Street Improvements R R 180,000 224,482 30,000 - - TR0414 Peabody Creek/Lincoln Street Culvert Repair 1 A 3,446,300 3,446,992 150,000 (296,300) Y TR1299 Park Avenue Chip Seal (Peabody to Race Streets)2 A 130,000 130,000 130,000 - - TR1516 Peabody Street Chip Seal Phase I (Lauridsen Blvd to 8th St)4 A 125,000 125,000 125,000 - - TR0215 Peabody Street Chip Seal Phase III (Ahlvers Rd to Park Ave)5 A 125,000 200,000 200,000 75,000 - TR0315 Peabody Street Chip Seal Phase II (Park Ave to Lauridsen Blvd) 6 A 200,000 225,000 225,000 25,000 - TR0218 Lincoln Street Safety 8 A 1,485,000 1,585,000 235,000 - Y 5,691,300 5,936,473 1,095,000 (196,300) GRANT FUNDING AMEND. REQUEST TRANSPORTATION CAPITAL PROJECTS (TBD)2020 PRIORITY 2019 PRIORITY 2019 PROJECT TOTAL 2020 PROPOSED BUDGET 2020 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION73PRIORITIZED PROJECTS -TBD Indicates the project is newIndicates 2019 comparison Number Title TR0615 Golf Course Road Chip Seal (1st St to Lindberg Rd) 7 1 200,000 300,000 - - - TR1416 Hamilton School Walking Routes 9 3 215,000 915,000 15,000 - Y TR0616 ADA - Francis Street 10 4 300,000 315,000 15,000 15,000 Y TR0320 2021 Pavement Preservation -5 - 400,000 - - - TR0618 Stevens Middle School Walking Routes 17 6 650,000 665,000 - - Y TR0115 N Street Chip Seal (5th to 15th Streets)18 9 300,000 300,000 - - - TR0518 I Street Chip Seal (5th to 16th Streets) 19 10 300,000 300,000 - - - TR0316 8th Street Chip Seal (A to I Streets) 20 11 300,000 300,000 - - - TR0219 5th Street Chip Seal (A to M Streets)21 12 300,000 350,000 - - - TR0417 Ennis Street Pavement Repair 23 13 70,000 100,000 - - - TR0117 Liberty Street Reconstruction 24 14 460,000 460,000 - - - TR1799 Truck Route at Hwy 101 Intersection UF 48 17 6,000,000 6,650,000 - - Y TR0420 2023 Pavement Preservation -24 - 400,000 - - - TR0716 ADA - Peabody Street 28 25 310,000 310,000 - - - TR0915 Park Avenue Paving Overlay (Race to Liberty Str 25 26 390,000 390,000 - - - TR0520 2024 Pavement Preservation -27 - 400,000 - - - TR0119 8th Street Paving (Lincoln to A Streets)29 29 900,000 1,115,000 - - Y TR0620 2026 Pavement Preservation -30 - 400,000 - - - TR0419 Lauridsen Blvd Reconstuction (L St to City Limits)UF 55 31 320,000 700,000 - - - TR0720 18th Street Chip Seal -32 - 300,000 - - - 11,015,000 15,070,000 30,000 15,000 GRANT FUNDING TRANSPORTATION CAPITAL PROJECTS (TBD)2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET AMEND. REQUEST TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION74UNFUNDED -TBD Indicates the project is newIndicates 2019 comparison Number Title TR0818 Railroad Ave Overlay UF 30 UF33 200,000 215,000 TR0499 Laurel St/Ahlvers Road Overlay UF 31 UF34 400,000 450,000 TR0816 ADA - Cherry Street UF 33 UF36 300,000 340,000 TR1015 Cherry Street Area Chip Seal UF 35 UF37 750,000 750,000 TR0916 ADA - Oak & Laurel Streets UF 37 UF 39 300,000 300,000 TR1899 Lincoln, Laurel and Lauridsen Blvd UF 40 UF 41 100,516 1,800,000 TR0104 2nd & Valley Streets Pavement UF 42 UF 43 550,000 550,000 TR0308 O Street Improvements UF 46 UF 48 1,500,000 1,500,000 TR0599 Hill Street Intersection UF 47 UF 49 485,000 485,000 TR0317 Chase Street Vicinity Chip Seal UF 53 UF 51 320,000 320,000 4,905,516 6,710,000 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS TRANSPORTATION CAPITAL PROJECTS (TBD)2019 PRIORITY 2020 PRIORITY CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION75CLOSED & NEW PROJECTS –TRANSPORTATION PROJECTS COMPLETED IN 2019 ACTUAL BudgetTR0111Marine Channel Bridge 610,474 675,000 TOTAL COMPLETED PROJECTS 610,474 675,000 NEW PROJECTS IN 2021-2026 CFP PRIORITY ACTUALTR0920Lauridsen Blvd Flashing Beacons 18 40,000TR1020N Street Solar Speed Display 19 30,000TR0220Traffic Circle Program 20 1,180,000TR0120Signal Controller Upgrades 1st/Front 21 1,585,000 2,835,000 CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION76ACTIVE PROJECTS -TRANSPORTATION Indicates the project is newIndicates 2019 comparison Number Title TR0405 Alley Paving Revolving Funding R R 875,000 985,090 200,000 (125,000) - TR0416 1St/2nd/Valley/Oak Green Alley 12 R 472,216 472,216 - - Y TR0111 Marine Drive Channel Bridge A C 644,727 620,474 10,000 (24,100) Y TR0114 Hill Street - Olympic Discovery Trail A A 1,648,165 3,941,613 19,000 (1,300) Y TR0209 Race Street Complete Design & Construction Phase I A A 3,564,954 3,404,382 115,000 (171,200) Y TR0909 Wayfinding & ODT Signage A A 212,013 312,000 - (198,200) - TR1216 5th & Liberty Streets Solar Speed Display A A 50,000 26,837 5,000 (23,100) - TR0519 Peabody Street Sidewalk Repair 3 A 95,000 95,000 94,910 10 - 7,562,074 9,857,612 443,910 (542,890) GRANT FUNDING 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET AMEND. REQUEST TOTALS TRANSPORTATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION77PRIORITIZED PROJECTS -TRANSPORTATION Indicates the project is newIndicates 2019 comparison Number Title TR0919 Traffic Safety Camera program -2 35,000 35,000 35,000 35,000 - TR0918 Downtown Tree/Sidewalk Replacement Phase II UF 51 7 200,000 300,000 - - - TR0101 Laurel Street Stairs Replacement 15 8 410,000 485,000 35,000 - - TR1215 City Hall East Parking Lot LID 13 15 602,000 602,000 102,000 - Y TR0715 16th Street LID (C to L Streets)11 16 1,060,000 1,060,000 160,000 - Y TR0920 Lauridsen Blvd Flashing Beacons -18 - 40,000 - - - TR1020 N Street Solar Speed Display -19 - 30,000 - - - TR0220 Traffic Circle Program -20 - 1,180,000 - - Y TR0120 Signal Controller Upgrades 1st/Front -21 - 1,585,000 - - Y TR1116 School Area Speed Signs (Near Franklin)26 22 50,000 50,000 - - - TR1399 Traffic Signal Interconnect/Preemption UF 38 23 725,000 600,000 - - - TR0318 8th/10th Street Bike Lanes 22 28 400,000 400,000 - - Y 3,482,000 6,367,000 332,000 35,000 GRANT FUNDING TRANSPORTATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL 2020 PROPOSED BUDGET AMEND. REQUEST TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 TRANSPORTATION78UNFUNDED -TRANSPORTATION Indicates the project is newIndicates 2019 comparison Number Title TR0113 Waterfront Redevelopment Phase III UF 32 UF 35 8,100,000 20,000,000 TR1016 18th Street Bike Accessibility UF 36 UF 38 700,000 800,000 TR1109 Marine Drive Bulkhead Repairs UF 39 UF 40 - - TR0212 Caroline Street Slide Repair UF 41 UF 42 375,000 375,000 TR1009 1st, Front & Race Street Nodes UF 43 UF 44 423,000 423,000 TR0516 Nancy Lane Pavement UF 44 UF 45 200,000 200,000 TR0506 Valley Creek Trail Loop UF 45 UF 46 100,000 100,000 TR0208 Alternate Cross-Town Route Study UF 49 UF 47 220,000 220,000 TR1316 Traffic Control UF 52 UF 50 200,000 300,000 TR1018 Zig Zag at Oak Street UF 54 UF 52 500,000 500,000 TR0619 Race Street Complete Construction Phase II UF 56 UF 53 6,000,000 6,000,000 TR0719 First & Front Street Decoupling UF 57 UF 54 - - TR0819 Sidewalks for Mt Angeles Rd & Porter St UF 58 UF 55 1,000,000 1,000,000 17,818,000 29,918,000 TRANSPORTATION CAPITAL PROJECTS 2019 PRIORITY 2020 PRIORITY 2019 PROJECT TOTAL 2020 PROJECT TOTAL TOTALS CITY COUNCIL WORKSESSION –MAY 26, 2020 CONCLUSION79ON-GOING REVIEW Revenue examination will continue remain stringent due to 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. CITY COUNCIL WORKSESSION –MAY 26, 2020 CONCLUSION80CLOSING 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 guidance was utilized in the form of: Financial Policies City Council The Strategic, Comprehensive and City Work Plans Port Angeles Citizens 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. CITY COUNCIL WORKSESSION –MAY 26, 2020 CONCLUSION81UPCOMING CFP EVENTS JUNE 16 JUNE 9 JULY 7 CFP/TIP Public Hearing & 1st Reading of Resolution UAC CFP Presentation, review and recommendation to Council CFP/TIP Public Hearing & 2nd Reading of Resolution CITY COUNCIL WORKSESSION –MAY 26, 2020 CONCLUSION82 QUESTIONS & DISCUSSION