Quote Management System – A National Construction Firm
AMC is a leading design/build construction firm with offices in 11 major markets and partnerships with 20 subcontractors nationwide. The company, founded over 25 years ago, has successfully completed the design and construction of over 2,500 projects in the U.S. and Canada. AMC offers personalized attention and complete, turnkey solutions for its clients’ construction needs.
AMC’s legacy system was built on Microsoft Excel. AMC created multiple regional templates for its subcontractors, as well as a national template for companies with multiple locations. Each project consisted of two spreadsheets, which were sent out for approval via email. These sheets were used to calculate cost estimates for approval via email.
As the company expanded, the employees found it was increasingly tedious to maintain a consistent system.
- As changes were made and new spreadsheets were emailed out, it became difficult for employees to track and approve the latest draft.
- Each subcontractor used unique Construction Specifications Institutes (CSI) codes for materials, which made it difficult for AMC to cross-reference job costs.
- There was no way to cross-reference previous jobs with similar project scopes, so each project was estimated from scratch.
Due to variations in prices, process and templates, it became time consuming for project managers to track project status and obtain accurate estimates. These issues stretched the estimate approval process to multiple days.
alligatortek designed and delivered a custom web-based quote management solution to alleviate employee frustration and reduce the chaos. The system houses only one upload of each spreadsheet, making it easy to identify the latest version.
Generated reports are more accurate with standardized CSI codes. This allows AMC employees to compare current project estimates with historical data from similar projects. For improved reporting and analysis, data filters are retro fitted with multiple dimensions and metrics.
Start With a Plan: 3 Reasons To Begin Any Development Project With a Discovery Session
Ninety percent of alligatortek clients that begin development with a discovery session will continue to the second part of the process. Want to know why? Here are three reasons why a planning stage will produce better results for you
File-Snapshot Backups to Microsoft Azure Blob Storage
Azure’s SQL Server data files allow us to create a database in an on-premises SQL Server or an available server in the Azure Virtual Machine. This database is tied to our application using a specific location in Azure blob storage. The File-Snapshot backup, introduced in SQL Server 2016, is capable of quickly performing a backup and restore.