When a city council member asks why the water main on Oak Street broke for the third time this year, the Utility Director sitting across the table has two choices: answer with data or answer with gut feel. The first earns budget. The second earns skepticism.
A utility capital improvement plan (CIP) is defined as a multi-year schedule, typically covering 5 to 10 years, that identifies, prioritizes, and funds the repair or replacement of aging infrastructure assets: water mains, meters, pumping stations, electrical distribution equipment, and gas distribution lines. A credible CIP links asset condition data to projected failure risk and replacement cost, giving a Utility Director a defensible basis for every capital dollar requested.
The EPA estimates the US needs $625 billion in drinking water infrastructure investment over the next 20 years to maintain safe service.(EPA, Drinking Water Infrastructure Needs Survey, 2023) For a small or mid-sized utility, that national picture lands locally, as main breaks, pressure failures, compliance notices, and city council meetings.
The question is not whether your utility needs a CIP. It does. The question is whether the data you have today is good enough to build one you can defend.
A capital improvement plan is only as credible as the data behind it. Utilities that present a CIP to their board or to a federal grant program without reliable supporting data rarely get funded and often face follow-up questions they cannot answer.
These are the five data inputs every CIP requires:
1. Asset inventory and condition ratings
A complete register of every major infrastructure asset, including age, material, installation date, and current condition score. Without this, prioritization is guesswork.
2. Work order and failure history
A record of every repair, maintenance event, and emergency response linked to each asset. Frequency of failure is one of the strongest predictors of near-term replacement need.
3. Useful life and remaining service life estimates
Industry-standard useful life benchmarks (cast iron pipe: 75–100 years; PVC: 50–70 years) applied to your actual asset ages to project when replacement will be required.
4. Replacement cost estimates
Current unit cost data for pipe replacement by diameter and material, pumping equipment, meters, and electrical infrastructure. Updated cost data prevents budget surprises at project approval.
5. Revenue and billing connection
Understanding which customers and revenue streams are served by at-risk infrastructure, so the financial impact of failure or the return on proactive replacement, can be quantified for the board.
Now: where does your utility actually store this data today? For most small and mid-sized utilities, the honest answer is: across three to five separate systems - a GIS file for the pipe inventory, a work order log in a separate platform or spreadsheet, billing data in a CIS, and cost estimates in a finance spreadsheet that gets updated once a year. None of these systems talk to each other.
Utility asset management software provides a single register for all five of these inputs. But for most utilities still running on legacy tools, the data gap between what they have and what a credible CIP requires is significant.
Spreadsheets are not the enemy. They are the appropriate tool for a utility that tracks 50 assets and has one person responsible for capital planning. But for any utility managing thousands of service connections, miles of distribution pipe, and hundreds of pumping and metering assets, spreadsheet-based CIP planning has predictable failure modes.
When a main breaks and a crew repairs it, that repair event should update the asset's condition record, failure count, and maintenance cost history. In a spreadsheet, it almost never does because the work order system and the asset spreadsheet are separate, and manual updates get skipped under operational pressure. The result: your CIP is built on condition data that may be 12 or 24 months out of date.
Without a live condition score and failure history for each asset, ranking capital projects comes down to institutional memory and the judgment of whoever built the spreadsheet. When that person retires, the logic goes with them. This is not a hypothetical risk— the AWWA reports that a significant portion of the utility workforce is within 5 years of retirement age, representing one of the largest knowledge transfer challenges the sector has faced.
The EPA's Water Infrastructure Finance and Innovation Act (WIFIA) program, USDA Rural Utilities Service (RUS) loan programs, and Infrastructure Investment and Jobs Act (IIJA) state revolving fund programs all require utilities to demonstrate documented asset condition assessments and replacement prioritization methodologies. A spreadsheet with no audit trail does not satisfy that requirement. Utilities that cannot produce structured, exportable condition data are at a systematic disadvantage in competitive grant rounds.
When a Utility Director presents a $4 million pipe replacement line item to the city council, the question that follows is: why this pipe, and why now? If the answer relies on memory rather than a documented condition score and failure history pulled from a live system, the conversation becomes difficult and capital requests get deferred.
A unified utility platform is the one that connects asset management, work order management, and billing data in a single system, changes the CIP data problem at its root.
When a crew completes a repair on an aging cast iron main, the work order closes in the same system that holds the asset record. The asset's failure count increments. The maintenance cost updates. The condition score adjusts. No manual update. No spreadsheet reconciliation at the end of the quarter. The data is current because the workflows are connected.
Spreadsheet-Based CIP vs. Unified Platform
This is the core of what SMART360does for capital planning. The platform's asset management module holds the complete infrastructure register - condition ratings, useful life tracking, GIS mapping, and capital improvement planning tools. The work order module feeds failure history directly into that asset record. Because billing and customer accounts are in the same system, a Director can see not just which assets are aging fastest, but which service areas and revenue streams they serve — giving every capital request a financial context the board can evaluate.
For utilities running between 3,000 and 100,000 meters, this is not a capability reserved for large enterprise deployments. SMART360 is built specifically for this scale. With 25+pre-built integrations covering AMI meter platforms (Sensus, Itron, Landis+Gyr)and GIS systems (Esri), it connects to the metering and mapping infrastructure most utilities already have in place, rather than replacing it. Explore work order management for utilities to see how the field operations and asset modules work together.
The operational result: utilities using a connected asset and work order platform can document the condition and failure history of every major asset — not just the ones that have already failed.
A defensible capital improvement plan has four components a board or city council needs to see before approving capital dollars:
1. The asset inventory - what you have, how old it is, and what condition it is in. Not a summary. A documented register, exportable on demand.
2. The prioritization logic - why these assets are ranked ahead of others. Condition score plus failure frequency plus consequence of failure: how many customers are served, what revenue is at risk, what is the regulatory exposure.
3. The cost estimate - unit replacement costs by asset type, escalated for projected construction inflation. Not a round number. A built-up estimate that survives scrutiny.
4. The funding path - which projects are funded from operating budget, reserves, rate increases, or federal programs.
EPA WIFIA, USDA RUS, and IIJA state revolving funds are all available — but competitive applications require documented condition assessments and prioritization methodologies.
Federal infrastructure funding available through the IIJA represents the largest investment in US water infrastructure in a generation. But competitive grant applications require documented, structured capital plans. Utilities that submit applications backed by exportable condition reports from a live asset management system have a meaningful advantage over utilities submitting spreadsheets.
When a Utility Director walks into a city council meeting with a five-year CIP backed by condition scores, workorder failure history, and a documented funding strategy, the conversation changes. Budget requests move from "we need to replace this pipe because it keeps breaking" to "our data shows 14 miles of cast iron main installed before 1955 with an average of 3.2 failures per mile over the past five years, and federal funding is available to offset 40% of replacement cost." One of those statements gets funded.
The utility management platform that makes this possible is not a multi-year enterprise implementation. Reaching this CIP data position is achievable in weeks, not months and it starts with unifying the asset, work order, and billing data your utility already has.
The role of the Utility Director is changing. Council members and ratepayer advocates increasingly expect the same level of data-backed accountability from utility capital planning that they expect from financial reporting.
A utility capital improvement plan (CIP) is a multi-year schedule, that identifies, prioritizes, and funds the repair or replacement of aging infrastructure assets. A credible CIP is built from documented asset condition ratings, workorder failure history, replacement cost estimates, and a defined funding strategy covering operating budget, reserves, and federal programs.
The five core inputs are:
(1) an asset inventory with condition ratings, (2) work order and failure history by asset, (3) useful life and remaining service life estimates, (4) current replacement cost data by asset type, and (5) billing and revenue data that shows the financial impact of at-risk infrastructure. Without all five, CIP prioritization relies on judgment rather than documented evidence.
Utility asset management software centralizes the data inputs a CIP requires, asset condition scores, maintenance history, GIS mapping, and cost tracking, in a single system. When the work order module and asset management module are connected, failure history updates automatically with each repair completion, keeping condition data current without manual reconciliation across separate systems.
Yes. Capital improvement planning is not exclusive to large utilities. Small and mid-sized utilities serving 3,000 to 100,000 customers face the same federal funding requirements and board accountability as larger systems. Modern utility platforms built for this scale make structured CIP accessible without enterprise-level IT infrastructure or multi-year implementation timelines.
Several federal programs require documented asset condition assessments and capital plans as part of the application: EPA's Water Infrastructure Finance and Innovation Act (WIFIA), USDA Rural Utilities Service(RUS) loan and grant programs, and Infrastructure Investment and Jobs Act(IIJA) state revolving fund programs. Utilities with a structured, data-backed CIP exportable from a live system are better positioned in competitive funding rounds than utilities submitting manually compiled spreadsheets.
