UC-432
Recall Traceability Drill & Mass Balance
Traces a named lot one step up and one step down, reconciles the mass balance, and produces the customer notification list.
TBDBuild Duration
XXXXIndicative ROI
XXXXBuild Cost
XXXXValue
The Challenge
A mock recall takes two days and still cannot account for every kilogram of the suspect lot. It persists because goods receipts, batch records and despatch notes sit in systems nobody joins under pressure.
How It Works
- Reads goods receipts, batch and blending records, despatch notes and customer delivery data.
- Links input lots to output lots both ways and reconciles quantity in against quantity out.
- Returns the affected lot list, the customer notification list and the gap report in minutes.
What It Removes
- Manual tracing through paper batch records
- Spreadsheet mass-balance reconciliation per lot
- Building the customer despatch list by hand
Input Data RequirementsGoods receipts, raw material lot numbers, batch and blending records, despatch notes, customer delivery records, stock and quarantine positions
Output FormatAffected lot list with its mass balance, a customer and depot notification list, and a drill report showing elapsed time and unaccounted quantity
“The standard says four hours and our last drill took two days and still lost three pallets”