A leading international metal facade manufacturer faced a critical business continuity challenge: their estimating system—the backbone of their sales and project quoting process—was built on obsolete VB6 technology by an internal developer nearing retirement. With no documentation, fragmented versions across German and US offices, and increasing limitations in vendor pricing integration and multi-currency support, the company risked losing their ability to generate competitive estimates. We partnered with them to analyze their current state, quantify the business impact, and build a compelling investment case for a modern, web-based estimator that would not only preserve decades of institutional knowledge but transform their entire estimation workflow into a strategic competitive advantage.
The primary objective was to evaluate the business case for replacing a business-critical legacy estimator before knowledge loss made it unsupportable, while simultaneously addressing operational inefficiencies that hindered the company's ability to compete in fast-moving architectural and construction markets. Our engagement focused on:
The modernization needed to deliver measurable financial returns while enhancing credibility with architectural firms and construction partners who increasingly expected rapid, accurate responses.
Imminent Knowledge Loss and System Failure
The legacy VB6/MS Access estimator was built and maintained by a single internal resource, who is preparing for retirement. Without documentation or knowledge-transfer mechanisms, the company faced inevitable system failure—a scenario that would paralyze their ability to bid on projects and generate revenue.
Geographic Fragmentation
The German headquarters and US offices operated separate versions of the estimator, each customized to local requirements. This created maintenance nightmares, prevented cross-office collaboration, and made it impossible to leverage global vendor relationships or standardize pricing strategies.
Vendor Integration Limitations
Estimators could not dynamically pull pricing from vendors for critical services such as painting or metal finishing. Instead, they relied on outdated assumptions or time-consuming phone calls, introducing delays and accuracy issues into every estimate. The system couldn't compare multiple vendors, forcing the company to leave money on the table or miss competitive opportunities.
Technology Constraints
Built on VB6 with MS Access database limitations, the legacy system lacked:
Competitive Pressure
In an industry where architectural firms and general contractors demand rapid responses and precise pricing, the company's slow, error-prone estimation process was becoming a competitive liability, threatening relationships and market position.
Lack of Investment Justification Data
While leadership recognized these problems intuitively, they lacked the quantitative analysis needed to justify a significant technology investment to stakeholders and secure budget approval.
We conducted a comprehensive analysis of their current estimation workflow and built a detailed business case for modernization, centered on a custom web-based estimator designed not as a simple replacement but as a strategic business transformation platform.
We collaborated with the client to gather critical operational metrics:
This data formed the foundation for calculating realistic time savings and quantifying the dollar value of efficiency gains.
The solution we designed leverages contemporary web technologies to deliver a responsive, intuitive interface accessible from any device, anywhere. Unlike the locked-down desktop application it would replace, the web-based platform would enable globally distributed teams to collaborate in real-time while maintaining enterprise-grade security and access controls.
A single application instance would serve all international offices with built-in multi-language and multi-currency capabilities. German and US teams would work in the same system, speaking their preferred language and viewing prices in their local currency, while executives would gain unprecedented visibility across the entire operation.
The proposed platform would connect directly to vendor pricing APIs, automatically pulling current rates for painting, finishing, and other outsourced services. Estimators would be able to compare multiple vendor options side-by-side in seconds, selecting the best combination of price, quality, and delivery time—capabilities that are simply impossible in the legacy system.
We outlined an approach to extract critical institutional knowledge embedded in macros and undocumented business rules, rationalize them, and rebuild them into the new platform's logic. Rather than simply preserving the old ways, we proposed collaborating with subject matter experts to identify inefficiencies and encode best practices into automated workflows.
The proposed solution includes:
Rather than positioning this as a cost reduction initiative, we framed the modernization as a strategic investment in competitive advantage—a platform that would enable new capabilities, new markets, and new ways of working that aren't possible with the current system.
Our investment analysis demonstrated exceptional projected financial returns that far exceeded typical software modernization benchmarks, providing leadership with the confidence to approve the initiative. Implementation is scheduled to begin in early 2026.
These projections were built on conservative assumptions derived from the client's actual operational data. We calculated percentage time savings across different estimate types, applied them to documented annual volumes, and converted efficiency gains to dollar values using actual estimator compensation rates. The analysis accounted for both direct labor savings and avoided costs from system maintenance and workarounds.
The compelling financial case, combined with the qualitative assessment of business continuity risks and competitive advantages, secured stakeholder buy-in and budget approval. Leadership recognized that the combination of 11-month payback and 110% IRR represented one of the highest-return investments available to the business.
Beyond the positive ROI projections, we helped leadership understand the cost of inaction: the imminent risk of complete system failure, the inability to compete in fast-moving markets, and the permanent loss of institutional knowledge. These unquantifiable risks made the decision even more urgent.
While implementation is planned for early 2026, the approved investment will deliver transformational impact across multiple dimensions:
The investment decision ensures the company won't face catastrophic business disruption when their legacy system becomes unsupportable. This risk mitigation alone justifies significant investment, but the financial returns make it a strategic win rather than a defensive necessity.
Once implemented, the company will transform from a laggard in estimation turnaround to a market leader. Architectural firms and construction partners will receive detailed, accurate estimates in a fraction of the current time, strengthening relationships and winning more competitive bids.
The ability to deliver polished, professional estimates through secure digital sharing will elevate the company's brand perception. Clients will increasingly view them as a technologically sophisticated partner rather than a traditional manufacturer.
Built on modern, widely-supported technologies, the platform will provide a foundation for expansion into new markets, product lines, or business models. The company will no longer be constrained by technology limitations when pursuing growth opportunities.
Breaking down the barriers between international offices will create new synergies. Teams will share insights, pricing strategies, and lessons learned across borders, creating a truly global operating model rather than disconnected regional operations.
The new estimator will evolve from a maintenance liability into a strategic business asset. Rather than working around system limitations, the company will be positioned to ask "how can we leverage our estimating platform to serve clients better?" This shift from defensive preservation to offensive innovation represents the true transformation this modernization will deliver.
By building a rigorous, data-driven investment case, we demonstrated that technology modernization can and should be evaluated with the same financial discipline as any other capital investment. The transparent methodology and exceptional projected returns gave leadership confidence that this isn't just an IT expense—it's a strategic business investment with measurable returns.
