Construction Estimator and Management System
Tool scheduling. Inventory management. Multiple vendor cost estimates. Multiple bidders per job for materials. Accounts payable and receivable. Contact management. Internal fax and bid receive portal. Material tracking and scheduling.
Visual Basic 6, Microsoft Access (backend database).
Under 50 employees, over 250 vendors.
Construction / small business.
❓ What problem did this project solve?
A housing construction subcontractor managing multiple active builds at once was running its entire operation without a system that connected the pieces. Material bids went out to more than 250 vendors. Those bids came back by fax, were read manually, and had to be manually entered into whatever tracking the company was using at the time. Each property had its own unique material requirements, including custom and made-to-order pieces that could not be swapped between jobs. Keeping track of which materials had been ordered for which property, at what price, from which vendor, was a significant administrative load that grew with each active project.
The contact management challenge added another layer. Vendors had multiple contacts at multiple companies, and getting the right person for a specific supply category required institutional knowledge that lived in people's heads rather than a system. When a staff member was unavailable, that knowledge gap slowed the bidding process.
🛠️ What PCG built
PCG built the Construction Estimator and Management System in Visual Basic 6 with Microsoft Access as the backend, creating a single application that managed the company's complete building process from first estimate through project completion. The most operationally significant component was the fax integration. Bids returned by fax were captured electronically, the text was converted, and the raw data was imported directly into the active bid record for that job. A process that had required manual transcription from paper became a single review and approval step.
Each property in the system maintained its own complete bid process with unique products and custom-order pieces tracked separately from standard materials. Multiple vendors could submit competing bids for the same material category on the same job, with the system tracking each bid through the selection process. That bid management layer gave the company visibility into where every material decision stood across all active projects simultaneously.
The contact management component handled multiple contacts at multiple companies and multiple positions, structured so that the right vendor contact for any supply category was findable without relying on any individual's memory. Inventory, scheduling, accounts payable, and accounts receivable were integrated into the same system so that material status, project timeline, and financial position were visible from a single interface.
🔍 Technology used
PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.
Frequently Asked Questions