Auction Management System
Record, track and calculate sales, interest accrual, profit margins, and auction details. Geo-location for equipment. Accounting report integration. Schedule equipment movements and deliveries.
Microsoft Access, Visual Basic for Applications (VBA).
Small business.
Transportation / heavy equipment.
❓ What problem did this project solve?
An equipment auction broker operating across the United States had no unified system for the transaction lifecycle that defines their business. Equipment was bought at auction, moved to staging, sold again through online or in-person events, and delivered to buyers across multiple states. At each step, the business needed to know where every piece of equipment was, what it cost, what it sold for, and how delivery was progressing.
Without a central system, that information lived in separate places and required manual reconciliation. For a broker handling millions of dollars in equipment transactions, the gap between what the records showed and what was actually happening in the field was a direct financial risk. The system also needed to integrate with existing legacy systems and be deployable across a central California office and satellite locations throughout the Western United States and Canada, with a minimal learning curve for staff at every location.
🛠️ What PCG built
PCG developed and deployed the Auction Management System in a few weeks. The system tracked every piece of equipment through the full auction lifecycle: acquisition, staging, sale, and delivery. Sales calculations, interest accrual, and profit margin tracking were built directly into the database, eliminating the manual spreadsheet work that had been running alongside the operation.
The geo-location tracking layer gave the broker real-time visibility into where equipment was physically located between auction events and during delivery. For a company moving heavy construction equipment across multiple states, knowing the location of every asset at any given moment is the difference between a manageable logistics operation and a reactive one.
PCG distributed the application from the central California location to satellite offices across the Western United States and Canada, integrating communications and tracking across all locations. The final deployment required minimal training because the system was built around how the company's staff already worked, not around the constraints of a generic platform.
🔍 Technology used
PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.
Frequently Asked Questions
