Inventories, bills of materials, supplier risk.
The questions
- Which assemblies stop if this supplier fails?
- What is the real stock of this component across sites?
Why a model alone gets it wrong
A bill of materials is recursive, and plain SQL makes any-depth traversal hard to get right. The ERP underneath is often old, and its column names explain nothing.
What the harness changes
- Recursion as a base case and a recursive case: a component required at any level, in a few lines.
- Legacy tables used as they are, with their real names. No migration, no copy.
- One definition of “available stock”, shared by planning, purchasing and the agents that assist them.
A definition it holds SupplierExposure: the assemblies that stop if a supplier fails, through every level of the bill of materials