Last updated: April 2026
A housing construction subcontractor with fewer than 50 employees and more than 250 vendors needed a complete system to manage the entire building process from material bidding through project completion. The system had to handle scheduling, inventory, multi-vendor cost estimates, bid management with fax integration, accounts payable and receivable, contact management, and per-property material tracking for custom-order pieces. PCG built it in Visual Basic 6 with Microsoft Access, creating a single entry point that eliminated redundant data input across the bidding and receiving process.
Project requirements

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.

Languages and database

Visual Basic 6, Microsoft Access (backend database).

Company size

Under 50 employees, over 250 vendors.

Industry

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

Visual Basic 6 Microsoft Access Fax integration and text conversion Multi-vendor bid management Per-property material tracking Inventory management Accounts payable and receivable Contact management
Running a construction or subcontracting operation where estimating, material tracking, and vendor management are still handled across disconnected systems? PCG has built custom construction management systems since 1995. The $2,500 diagnostic engagement scopes the work before any development begins.
Talk to PCG

PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.

Frequently Asked Questions

The system PCG built for this housing subcontractor consolidated all vendor bid activity into a single entry point. Each property had its own bid process with its own material specifications, and the contact management component tracked multiple contacts at multiple positions within each vendor company. When a bid request went out via the integrated fax portal, the response came back electronically, was captured and converted from the fax transmission, and the raw data fed directly into the active bid for that property. No one was manually re-entering numbers from a fax sheet into a spreadsheet. With more than 250 vendors and multiple simultaneous builds, that single-entry architecture was what kept the process from collapsing under its own volume.
Yes, and this was one of the specific requirements on this project. Each housing development property required a unique bid process with particular products and made-to-order custom pieces that could not be treated as standard inventory items with fixed prices and standard lead times. The system PCG built tracked those custom items per property, kept their specifications tied to the correct bid, and flagged them in the scheduling module with the lead times relevant to custom fabrication rather than stock delivery. Standard items and custom items followed different workflows inside the same system, which is something generic construction software typically cannot accommodate without significant workarounds.
The cost depends on the scope of what the system needs to cover. A construction estimating system that handles vendor bid management, material tracking, project scheduling, accounts payable and receivable, and contact management for 250-plus vendors is a substantive build. The right starting point is a scoping conversation to map your actual workflow before any development estimate is meaningful. PCG has built systems of this type for subcontractors under 50 employees where the volume of vendor relationships and the complexity of the bid process had outgrown whatever they were previously using. Contact PCG to schedule a free consultation.
When the financial side and the scheduling side live in separate systems, the connection between a payment status and a material delivery status has to be maintained manually. Someone has to check whether a vendor was paid before confirming a delivery date, and that check is often skipped under time pressure. PCG built this system with the accounts payable and receivable module tied directly to the material tracking and scheduling components. A vendor payment status was visible from the same interface that managed delivery scheduling for that vendor's materials. For a housing subcontractor managing multiple active builds with more than 250 vendor relationships, that visibility is what prevents the kind of scheduling gap that delays a project close date and triggers penalty clauses.
The inflection point is usually visible before it becomes a crisis. When a bid has to be assembled by pulling numbers from multiple spreadsheets that are not synchronized with each other, and when a change to one material price has to be updated in three different places manually, the system is already failing. For a subcontractor managing multiple simultaneous builds, each with unique material specifications and a separate vendor bid process, the manual reconciliation work accumulates fast. The client on this project was at that point when PCG was engaged. The gaps PCG identified during the requirements analysis showed exactly where time was being lost and where pricing errors were entering the bid process. Those gaps are what the system was built to close. If your current process has similar gaps, contact PCG to discuss what a scoping assessment would cover.