Challenge: The Cost of Manual Procurement
-
-
Invisible Revenue Leakage: ProPlumb, a major plumbing wholesaler, sources thousands of parts from up to eight different suppliers. Managing price fluctuations manually across these catalogues led to inconsistent purchasing decisions.
-
Bottom-Line Impact: Preliminary analysis indicated that failing to secure the lowest available price for the few hundred high-volume parts was costing the business approximately $30,000 per month.
-
Fragile Data Structures: Supplier catalogues frequently change formats—inserting columns or shifting data—which typically breaks traditional “hard-coded” import tools.
-
Governance Gaps: The client lacked an automated method to verify that supplier invoices matched agreed catalogue pricing or to identify unauthorised “blacklisted” purchases.
-
Solution: The ProPlumb Master Procurement Engine
Analytical Models engineered a comprehensive suite of tools centered on a dynamic Master Catalogue and an Invoice Auditing Module:
1. High-Velocity Price Analysis & Mapping
-
-
Universal Supplier Bridge: We created a flexible mapping table that allows ProPlumb to link disparate supplier part numbers to a single master SKU.
-
Dynamic Column Mapping: To mitigate the risk of changing file formats, we built a user-definable mapping interface. ProPlumb can reconfigure the tool to recognise new column orders without requiring any code changes.
-
Price Movement Analytics: The tool automatically identifies and summarises price changes in both absolute and percentage terms, empowering staff to negotiate directly with supplier reps.
-
2. Automated Invoice Auditing & Risk Management
The system generates a suite of six critical governance reports upon loading a supplier invoice:
-
-
Price Variance Report: Flags every item where the invoiced price differs from the current master catalogue.
-
Blacklist & Integrity Checks: Identifies unauthorised purchases of restricted items (e.g., tools instead of parts) and flags “Ordered By” data to track internal procurement habits.
-
Fraud Prevention: Includes a Branch Report to detect orders from unusual locations and a Purchase Order Report to flag PO numbers falling outside valid sequences.
-
Catalogue Integrity: Lists items found on invoices that do not exist in the master catalogue.
-
Outcome: Direct Bottom-Line Transformation
-
-
$360,000 Annual Savings: By ensuring the business consistently purchases from the cheapest supplier, the tool delivers an estimated $30,000 in monthly savings directly to the bottom line.
-
Audit-Ready Resilience: All catalogue builds and invoice audits are saved in time-stamped directories, providing a permanent, auditable record of all procurement decisions.
-
Enhanced Supplier Leverage: With instant access to price-change summaries, the client has shifted from reactive purchasing to proactive vendor management.
-
Operational Scalability: The flexible mapping architecture ensures that the system remains functional even as suppliers update their technology and file formats.
-