HomeMy WebLinkAbout12-10-18 City Commission Packet Materials - C7. Adopt the Public Works Admin Internal Service Fund CIP for FY 2020-2024
Commission Memorandum
REPORT TO: Honorable Mayor and City Commission
FROM: Kristin Donald, Finance Director
SUBJECT: Adopt the Public Works Administration Internal Service Fund
Capital Improvement Plan (CIP) for Fiscal Years 2020-2024.
AGENDA ITEM TYPE: Consent
MEETING DATE: December 10, 2018
RECOMMENDATION: Adopt the Public Works Administration Internal Service Fund
Capital Improvement Plan (CIP) for Fiscal Years 2020-2024.
BACKGROUND: Each year, the City Manager is required to prepare a 5 Year Capital
Improvements Plan and submit it to the Commission by December 15th. Similar to recent years
past, we are bringing the various parts of the plan forward as items on the Consent agenda. We
will be prepared to address questions, if they arise, at the public meeting.
The Public Works, City Manager, and other city staff met in October and November to develop
the attached Capital Plan for the equipment and capital needs of Public Works from an
administrative level. This includes Administration, Engineering and GIS, which are then
charged to the public works fund based on needed activity from these functions.
Relationship to the Strategic Plan:
• Software investment in this fund works towards 4.1 c GIS Land Use & Infrastructure
Development Tracking. Specifically, Asset Management software, aerial photography
and performance management and civic engagement system investment.
69
• This year we worked towards item 7.1 b -Create a Culture of Innovation by changing
our CIP database system for project tracking and plan development. We are now using
our city-wide budgeting system’s project module for all CIP items. This will make it
easier to merge approved projects into the recommended budget, begin tracking projects
in their initial stages, and give us increased project cost reporting. The change has
resulted in a different report “look-and-feel,” and we are working to evolve and refine
how the CIP reports appear.
• We are also recommending that we continue to innovate the plan for next year by
increasing the CIP threshold from its current level of $10,000 to a new minimum level of
$25,000. Currently, the $10,000 threshold causes many maintenance and other
operational budget items to be included in the capital plan. For the FY21 to FY25 CIP we
recommend using a $25,000 threshold. This will align us with best practices and allow us
to make better capital decisions by focusing on true capital items and less maintenance
and operational expenses.
UNRESOLVED ISSUES: None.
ALTERNATIVES: As suggested by the City Commission. If the Commission does not
wish to adopt this schedule tonight, it can be scheduled for approval on a later agenda.
FISCAL EFFECTS: This step in the process has no fiscal effect. Once adopted, the
Capital Improvements Plan becomes the basis of the City Manager’s Recommended Budget for
FY20.
Report compiled on: November 27, 2018
Attached: Public Works Admin CIP Section
70
PUBLIC WORKS ADMINISTRATION INTERNAL SERVICE FUND FINANCIAL SUMMARY Financial Summary Current YearFY19 FY20 FY21 FY22 FY23 FY24UnscheduledProjected Beginning Reserve Balance Dedicated to CIP ‐$ 71,444$ 19,316$ 2,976$ 2,976$ 80,309$ ‐$ Plus: 71,444$ 72,873$ 148,660$ ‐$ 77,333$ ‐$ ‐$ Less: Scheduled CIP Project Costs ‐$ (125,000)$ (165,000)$ ‐$ ‐$ (65,000)$ ‐$ Projected Year‐End Cash Dedicated to CIP 71,444$ 19,316$ 2,976$ 2,976$ 80,309$ 15,309$ Assumptions Made for Revenue Estimates Current YearFY19 FY20 FY21 FY22 FY23 FY24Estimated Annual Public Works allocation 2,381,457$ 2,381,457$ 2,429,086$ 2,477,668$ 2,527,221$ 2,577,766$ Estimated Annual Increase 0.0% 2% 2% 2% 2% 2%Total Estimated Revenues 2,381,457$ 2,429,086$ 2,477,668$ 2,527,221$ 2,577,766$ 2,629,321$ Current Revenues Dedicated to CIP % 3.0% 3.0% 6.0% 3.0% 3.0% 3.0% Plus: Increase Dedicated to Water Capacity Expansion CIP 0.0%0.0% 0.0% 0.0% 0.0% 0.0% Total % Dedicated to CIP 3.0% 3.0% 6.0% 3.0% 3.0% 3.0%Total Estimated Revenues Dedicated to CIP 71,444$ 72,873$ 148,660$ 75,817$ 77,333$ 78,880$ Note: The Public Works Administration Fund is an internal service fundthat operates entirely from cost recovery paid by City Departments, specifically Public Works Departments. Capital items are funded as needed, withoutthe accumulation of any reserve.ProjectedProjectedCURRENT$(125,000)$(165,000)$‐$‐$(65,000)FY19 FY20 FY21 FY22 FY23 FY24PUBLIC WORKS INTERNAL SERVICE PROJECTS 71
PUBLIC WORKS ADMINISTRATION INTERNAL SERVICE FUND PROJECT SUMMARY Project # Project Name FY2020 FY2021 FY2022 FY2023 FY2024GIS03 ASSET MANAGEMENT SOFTWARE 75,000 ‐ ‐ ‐ ‐ GIS04AERIAL PHOTOGRAPHY ‐ 65,000 ‐ ‐ 65,000 GIS16 PERFORMANCE MANAGEMENT AND CIVIC ENGAGEMENT SYSTEM INVESTMENTS‐ 100,000 ‐ ‐ ‐ Fiscal Year totals 75,000 165,000 ‐ ‐ 65,000 72
PUBLIC WORKS ADMINISTRATION INTERNAL SERVICE FUND DETAIL BACKGROUND Public Works Administration internal service fund was created in FY19 to allocate the Public Works Administration, GIS, and Engineering to the enterprise funds based on the use of these functions. The charges to the other funds provides the funding for the three divisions. CAPITAL PLAN SUMMARY The plan contains requests for GIS. This includes Asset Management software, aerial photography and performance management and civic engagement system investment, which all work towards the Strategic Plan 4.1 c GIS Land Use & Infrastructure Development Tracking. 73
Project Name YearDescription AmountTotal Project #DESCRIPTION OF PROJECT: 50,000 MANAGING THE LIFE‐CYCLE COST OF INFRASTRUCTURE ‐ INVESTMENTS IS RECOGNIZED IN THE STRATEGIC PLAN ‐ UNDER THE VISION OF A WELL‐PLANNED CITY (4.3). ‐ THIS PROJECT WILL INCLUDE THE PURCHASE AND ‐ IMPLEMENTATION OF SPECIALIZED ASSET MANAGEMENT ‐ SOFTWARE TO LEVERAGE EXISTING DATA TO ASSIST IN ‐ DELIVERING THE DESIRED LEVEL OF SERVICE FOR THE ‐ LOWEST LIFE‐CYCLE COST. DETAILED CONDITION ‐ INFORMATION ALONG WITH PREDICTIVE BUDGET ‐ ANALYSIS WILL PROVIDE FOR A RISK BASED APPROACH ‐ TO PRIORITIZING INFRASTRUCTURE NEEDS. ‐ ALTERNATIVES CONSIDERED: ‐ CONTINUE MANAGING DATA AND EXISTING WORKFLOW ‐ USING A MANUAL PROCESS WITH LIMITED POTENTIAL ‐ FOR EFFECTIVE LONG‐RANGE ANALYSIS. ‐ ADVANTAGES OF APPROVAL: ‐ THIS PROJECT WILL RESULT IN THE LOWEST POSSIBLE ‐ LIFE‐CYCLE COST FOR MAJOR INFRASTRUCTURE ‐ IMPROVEMENTS BY INCLUDING THE LIKELIHOOD AND ‐ CONSEQUENCE OF FAILURE TO ENSURE A SUSTAINTABLE ‐ APPROACH TO REHABILITATION, REPAIR, AND ‐ REPLACEMENT. ‐ ADDITIONAL OPERATING COSTS: ‐ REQUIRED ANNUAL MAINTENANCE WILL BE DEPENDENT ‐ UPON THE CHOSEN SOFTWARE APPLICATION. ‐ NOTE: ‐ ADDITIONAL FUNDING BEYOND THE PREVIOUS 25,000 RECOMMENDATION IS NECESSARY TO FULLY ‐ IMPLEMENT A SOLUTION FOR BOTH DETAILED RISK ‐ ASSESSMENT AND PREDICTIVE BUDGET ANALYSIS. ‐ ASSET MANAGEMENT SOFTWARE202075,000 GIS03 74
Project Name YearDescription AmountTotal Project #PROJECT DESCRIPTION: 65,000 AERIAL PHOTOGRAPHY IS USED ON A DAILY BASIS TO ‐ SUPPORT A WIDE VARIETY OF CITY OPERATIONS, ‐ INCLUDING PUBLIC ACCESS TO HISTORICAL ARCHIVES. ‐ CURRENT AERIAL PHOTOGRAPHY ENABLES TIMELY ‐ DECISIONS BASED ON ACCURATE INFORMATION AND ‐ CONTINUES TO EXPERIENCE UNPRECEDENTED DEMAND. ‐ ALTERNATIVES CONSIDERED: ‐ LOWER RESOLUTION SATELLITE IMAGERY ALONG WITH ‐ EXTERNAL PARTNERSHIPS MAY RESULT IN A LESS ‐ DESIRABLE OUTCOME. ‐ ADVANTAGES OF APPROVAL: ‐ THIS PROJECT BENEFITS BOTH THE ORGANIZATION AND ‐ THE COMMUNITY BY PROVIDING A CLEAR AND ACCURATE ‐ REPRESENTATION OF CURRENT CONDITIONS IN ADDITION ‐ TO SERVING AS AN IMPORTANT HISTORICAL RECORD ‐ DURING TIMES OF HIGH GROWTH. MEASURESMENTS AND ‐ LAND USE DETERMINATIONS CAN BE MADE WITHOUT ‐ REQUIRING EXTENSIVE TIME IN THE FIELD. ‐ ADDITIONAL OPERATING COSTS: ‐ THERE ARE NO RECURRING COSTS OR ANNUAL OPERATING ‐ EXPENSES ASSOCIATED WITH THIS PROJECT. ‐ AERIAL PHOTOGRAPHY 202165,000 GIS04 (FY21)75
Project Name YearDescription AmountTotal Project #PROJECT DESCRIPTION: 65,000 AERIAL PHOTOGRAPHY IS USED ON A DAILY BASIS TO ‐ SUPPORT A WIDE VARIETY OF CITY OPERATIONS, ‐ INCLUDING PUBLIC ACCESS TO HISTORICAL ARCHIVES. ‐ CURRENT AERIAL PHOTOGRAPHY ENABLES TIMELY ‐ DECISIONS BASED ON ACCURATE INFORMATION AND ‐ CONTINUES TO EXPERIENCE UNPRECEDENTED DEMAND. ‐ ALTERNATIVES CONSIDERED: ‐ LOWER RESOLUTION SATELLITE IMAGERY ALONG WITH ‐ EXTERNAL PARTNERSHIPS MAY RESULT IN A LESS ‐ DESIRABLE OUTCOME. ‐ ADVANTAGES OF APPROVAL: ‐ THIS PROJECT BENEFITS BOTH THE ORGANIZATION AND ‐ THE COMMUNITY BY PROVIDING A CLEAR AND ACCURATE ‐ REPRESENTATION OF CURRENT CONDITIONS IN ADDITION ‐ TO SERVING AS AN IMPORTANT HISTORICAL RECORD ‐ DURING TIMES OF HIGH GROWTH. MEASUREMENTS AND ‐ LAND USE DETERMINTATIONS CAN BE MADE WITHOUT ‐ REQUIRING EXTENSIVE TIME IN THE FIELD. ‐ ADDITIONAL OPERATING COSTS: ‐ THERE ARE NO RECURRING COSTS OR ANNUAL OPERATING ‐ EXPENSES ASSOCIATED WITH THIS PROJECT. ‐ AERIAL PHOTOGRAPHY 202465,000 GIS04 (FY24)76
Project Name YearDescription AmountTotal Project #PROJECT DESCRIPTION: 100,000 PERFORMANCE MANAGEMENT AND CIVIC ENGAGEMENT ARE ‐ LISTED AS HIGH PRIORITIES WITHIN THE STRATEGIC ‐ PLAN (7.4 & 1.1, RESPECTIVELY). THIS PROJECT ‐ WILL LEVERAGE EXISTING INVESTMENTS IN CITYWORKS, ‐ GIS AND OTHER ENTEPRISE SYSTEMS TO IMPROVE THE ‐ WAY WE MEASURE AND REPORT PROGRESS. A MODERN ‐ SOFTWARE PLATFORM ALONG WITH IMPLEMENTATION ‐ SERVICES ARE NECESSARY TO PROVIDE A CITYWIDE ‐ APPROACH. ‐ ALTERNATIVES CONSIDERED: ‐ CUSTOM SOLUTIONS DEVELOPED USING BASIC ‐ TECHNOLOGY WILL LIMIT THE CITY'S ABILITY TO ‐ MEET STAFF AND CITIZEN EXPECTATIONS. ‐ ADVANTAGES OF APPROVAL: ‐ THE USE OF KEY PERFORMANCE INDICATORS WILL HELP ‐ IDENTIFY OPPORTUNITIES FOR INCREASED EFFICENCY ‐ THROUGHOUT THE ORGANZIATION WHILE PROVIDING A ‐ PERFORMANCE MANAGEMENT AND CIVIC ENGAGEMENT SYSTEM INVESTMENTS2021100,000 GIS16 77