For background on this particular project, please visit The Goldilocks Strategy.
Situation ...
This multi-location structural steel fabricator needed to improve its estimating capabilities, which have historically been done using manual worksheets using highly experienced personnel, requiring thousands of calculations to estimate even moderately-sized jobs, such as an elementary school.
Problem ...
This process made job estimates time-consuming, labor-intensive, and subject to detailed review to ensure accuracy. Over the last several years, quickly producing accurate estimates became more critical to business success, because the drop in construction activity – both residential and commercial – has made this industry even more competitive.
No off-the-shelf package met the needs of our client – low-end packages lacked needed functionality or integration capabilities, and high-end packages were modules of full-blown industry-specific ERP (Enterprise Resource Planning) systems requiring other modules for proper functioning.
Solution ...
We met with our client's estimating personnel, thoroughly understanding not only how they currently performed their estimates, but especially how they wanted technology to improve the overall process. The biggest improvements:
- Drawing part information, including standards, weights, and most recent cost, from their business system.
- Automating estimation formulas, taking into account factors such as the type and complexity of operations, the number of repetitive techniques and processes, including non-linear adjustments based on material properties.
Furthermore, we helped client personnel clearly envision how the new process and technology would work, before creating detailed specifications to send to their software developer.
An estimator develops a quote from detailed drawings provided by the contractor – each sheet on the quote matches a page from the drawings, and each line item matches a piece on the page. The estimator uses picklists to select the appropriate inventory item, and enters the length and quantity of pieces required – the program calculates required pounds. Users can toggle how totals are displayed. Colors provide an audit trail:
-
- Green shading of a row number or action button – Detail notes exist at the row, sheet, or job level.
- Yellow shading of a Materials or Hours cell – A calculation or default value was overridden.
Each piece requires at least one fabrication operation. The system uses built-in formulas to apply company-wide standards, including a minimum number of hours to allow for setup.
The estimator can adjust the default cost per hundred-weight (CWT) by product type, allowing the job cost to be quickly revised for changed prices in the steel market. This high-level summary allows an effective "reasonableness review" of the entire job.
Results & Benefits ...
Our client can now:
- Apply a single estimation methodology to simplify and improve bid analysis, accuracy, and competitiveness.
- Ensure consistency and accuracy among job estimators by automating calculations and enforcing company-stipulated controls.
- Collaborate on project estimates, using experienced personnel providing oversight and guidance to newer personnel creating the detailed job estimates.
- Respond quickly to prospects in the highly competitive commercial construction environment.
- Know pricing calculations are accurate for many complex parts and processes.
- Pinpoint and sign-off on all overrides to the system-calculated estimates.
- Maintain tight control of pricing in an exacting industry.
More job estimates are being prepared, more quickly and accurately, than ever before.
Conclusion ...
In a competitive environment, we were able to help our client leverage their personnel and existing technology investments to deliver a mission-critical application for about the same investment as an estimating module for a full ERP system – without needing to invest in other modules necessary to implement a single application.
Identify if you need a customized application or system to better manage your business.
For More Information ...
To discuss how technology usage and business process improvements could be applied to the issues facing your business, call us at 336.297.4200 to schedule a no-obligation consultation, or click here to contact us online.
