End-to-End Lot & Roll Traceability Depth and Recall Exposure

The formula

This is the expression the tool evaluates. Every term is named underneath, with the unit it must be supplied in.

How the result is derived

Step by step, from the values you type to the figure on screen.

1. The 11 inputs are read from the form on every keystroke: Mass of the Affected Upstream Lot, Cumulative Yield to Finished Goods, Bales per Laydown Mix, Yarn Lots per Fabric Lot, Fabric Lots per Dye Batch, Dye Lots per Cut Lay, Links of Record Intact (0 to 4), Finished Unit Mass, Daily Output, Exposure Window and Units per Carton.
2. Each value is checked against the accepted range in the input table below. A value outside its range stops the calculation rather than producing a misleading figure — the results blank out and a message appears.
3. The validated values are substituted into the expression above, which resolves Units to Quarantine together with every supporting figure in one pass — no value is carried over from a previous entry.
4. The supporting outputs — Finished Units Actually Implicated, Dispersion Factor Across the Chain, Implicated Mass at Finished Goods, Share of the Original Lot in Each Unit, Lots Resolvable from the Records, Unresolved Fan-In, Implicated Share of the Exposure Window and Cartons to Pull — come from the same pass, so they always describe the same case as the headline figure.
5. Results are rounded for display only. The full-precision value is used throughout the chain, so reading a rounded intermediate figure back into the tool by hand can shift the last digit.

What each input means

Where to read each value on the floor, the unit it must be in, and the range the tool accepts.

What the tool returns

The headline figure and every supporting value it is built from.

Worked example

Substituting

Now break the chain. Set the records to 2 links - the dyehouse and the cutting room kept lot identity, the spinning mill did not - and every figure above stays exactly the same except the ones that matter. The same 18,102.86 shirts are still affected; you simply cannot say which. Resolvable lots fall from 48 to 2, unresolved fan-in rises to 24, and the pull jumps from 754.29 cartons to 5,250 - the entire 21 day window. The contamination did not change. Seven times the recall did, and the difference is a spinning mill lot number.

How to use it

1. Work through the input groups in order — The Implicated Lot, Chain Fan-In and Records & Recall Window. The defaults are a realistic case, so you can change one value at a time and watch what moves.
2. There is no calculate button. Every figure recalculates as you type or drag, which is what makes this usable for a what-if sweep rather than a single answer.
3. Read Units to Quarantine in the dark results panel — that is the headline figure, expressed in units.
4. Check the supporting rows underneath (Finished Units Actually Implicated, Dispersion Factor Across the Chain, Implicated Mass at Finished Goods, Share of the Original Lot in Each Unit, Lots Resolvable from the Records, Unresolved Fan-In, Implicated Share of the Exposure Window and Cartons to Pull) before acting on the headline — they are where an implausible input usually shows itself first.
5. Reset to defaults returns every field to the reference case, which is the quickest way to check whether a surprising result came from the tool or from an input you had changed earlier.

Where this is used

• Process planning — establishing Units to Quarantine before a trial is booked, so machine time and material in Quality Systems, Traceability, Utilities & Factory Decisions are committed against a calculated figure rather than an estimate.
• Costing and quotation — Units to Quarantine is an input to the cost sheet, and quoting from a worked number rather than a remembered one is what keeps a margin intact.
• Troubleshooting — when the floor result drifts from plan, entering the measured values (starting with Mass of the Affected Upstream Lot) shows how much of the gap in Units to Quarantine each variable explains.
• Teaching and study — the accepted ranges bracket normal Quality Systems, Traceability, Utilities & Factory Decisions practice, so moving one variable at a time shows the shape of the relationship rather than a single answer.

Reading the result

Typical bands and what each one is telling you.

Assumptions and limits

• The model assumes each affected lot is fully consumed by the next stage and that blending is complete, which is the conservative reading and the one auditors apply. Where a lot is only partly consumed the true implicated mass is smaller, but you need consumption records at lot level to claim that, and if you had those you would probably not be estimating. Fan-in values should be the maximum the process permits, not the average, because a recall is decided by the worst case in the window rather than the typical one. The chain is treated as a simple sequence: a genuine bill of materials with parallel warp and weft supply, re-dyed seconds re-entering the stream, or leftover fabric returned to stock forms a graph rather than a chain, and each of those paths adds fan-in this calculation will not see. Yield is applied as a single cumulative figure and assumes waste is representative - if the affected material is preferentially removed, by a metal detector or a contamination sorter, the real exposure is lower, and if it is preferentially retained the figure here is optimistic. The quarantine result sizes containment only; it is not a recall decision, which also turns on where the product has already shipped, what the specification actually requires, and the regulatory regime of the destination market. Finally, the window cap means a broken chain and a complete one can return the same quarantine figure when dispersion already exceeds the window - that is not the records working, it is the exposure being larger than the period you asked about.
• Every input is bounded to the range normal practice occupies (Mass of the Affected Upstream Lot 0.1 to 200000 kg, Cumulative Yield to Finished Goods 1 to 100 % and Bales per Laydown Mix 1 to 200 lots, and so on for the rest). Those bounds are guard rails against typing errors, not a claim that the formula fails one unit outside them.
• The calculation is deterministic: the same inputs always give the same result. It carries no allowance for machine condition, operator skill, ambient conditions or lot-to-lot material variation unless an input above explicitly represents one.
• Nothing is sent anywhere. The maths runs in your browser, so the numbers you type never leave the page.

Standards and further reading

• ISO 22095 - Chain of custody, General terminology and models, which defines identity preservation, segregation, mass balance and controlled blending as distinct models with different traceability guarantees.
• GS1 General Specifications and the GS1 Global Traceability Standard, for lot and batch identification through GTIN plus batch or lot number and the one-up one-down record requirement.
• ISO 9001 clause 8.5.2 - Identification and traceability, which requires identification of outputs and control of unique identification where traceability is a requirement.
• ISO 9001 clause 8.7 - Control of nonconforming outputs, for the containment obligation the quarantine figure is sizing.

Questions people ask