UC-361
Lot Traceability & Product Hold Scoping
Rebuilds lot genealogy from raw material to shipped drum, finds which lots share a suspect input, and scopes how far a hold must reach.
TBDBuild Duration
XXXXIndicative ROI
XXXXBuild Cost
XXXXValue
The Challenge
One suspect input lot sends the plant into a manual trace that takes days, so product is held wider than the evidence needs. Batch records, goods-in certificates and despatch notes share no lot identifier.
How It Works
- Reads goods-in certificates, batch records, weigh-up logs and despatch and shipping notes.
- Links every raw, intermediate and finished lot into one genealogy and sizes the hold boundary.
- Hands the quality manager the affected lot list and hold boundary within the shift.
What It Removes
- Manual tracing of lot numbers through paper records
- Rebuilding despatch history to find shipped lots
- Over-wide product holds while the trace runs
Input Data RequirementsGoods-in and supplier certificates of analysis, electronic batch records, weigh-up and dispensing logs, despatch notes, customer shipment records
Output FormatAffected lot list per suspect input with the hold boundary, a shipped-and-gone list by customer, and a genealogy tree behind every lot link
“When one raw material is in doubt we hold three times the product we need to, because the trace takes four days”