Modernizing the City of Baltimore Public Works
The Department of Public Works transitioned from manual spreadsheets to a unified cloud platform to manage an annual capital budget exceeding $500 million dollars. By deploying CIPAce™, the City successfully implemented the EPA mandated Integrated Planning Framework in just three months.
Strategic Objectives for the City of Baltimore Department of Public Works
Digitalize the Planning Process
The City needed to move the Integrated Planning Framework into a fully electronic and weighted scoring system. This transition removes manual processes and establishes a modern framework capable of managing hundreds of complex project submissions.
Ensure Financial Accuracy
A major priority was automating the calculation of funding splits and spending curves. By removing manual spreadsheet calculations, this automation eliminates human error and provides the Fiscal Department with total assurance of accurate data.
Meet Strict Deadlines
The Department of Public Works was required to complete the entire digital overhaul within 90 days. Achieving this rapid three month implementation was critical to meet the budget presentation schedule mandated by the City Council.
The Solution: CIPAce™ Enterprise Platform
A unified digital framework engineered to ensure financial accuracy and streamline the entire capital planning lifecycle.
Automated Fund Management
The system automatically projects funding needs and splits across a six year planning cycle. This automation eliminates human error in spending curves and gives the Fiscal Department total assurance of accurate financial data.
Visual Planning Tools
Project managers now use a graphical interface for project phase durations. This entirely replaces fragmented individual Excel forms and significantly improves the overall project schedule.
Dynamic Workflow Engine
Approval processes are generated automatically based on the current organizational hierarchy. This dynamic routing easily scales to handle the complexity of evaluating hundreds of project submissions annually.
Enterprise Grade Security
This cloud solution completely passed the strict internal IT security standards required by the City. It provides a highly reliable digital environment that replaces vulnerable and siloed legacy systems.
Rapid Implementation
The solution moved from project kick off to go live operations in just three months. Achieving this aggressive timeline was critical to successfully meet the budget presentation schedule for the City Council.
Enhanced Transparency
Stakeholders now have a shared view of project rankings and optimization based on financial constraints. Implementing the 15 qualitative matrices digitally ensures strict accuracy across all project selections.
Download the Full Case Study
Get a detailed look at how the City of Baltimore Department of Public Works transitioned from manual spreadsheets to a modern data driven framework. Discover the strategic roadmap they used to manage an annual capital budget exceeding $500 million dollars and implement the EPA mandated Integrated Planning Framework.