GIFSQ ID: CAL-0550
GIFSQ Tools : Food Safety : Version v1 : Technical review date: 2026-11-15
Completion of the live Batch Genealogy Explorer and Meat and Seafood Batch Traceability tools (explorers, not drill generators): generates a traceability exercise or mock-recall drill from a lot, with the book checklist and a trace score.
Educational calculator: this is a calculation aid for learning and planning. It is not a validated food safety process and must not be presented as one. Confirm any value against your accredited method and your own process validation before using it in production.
Inputs
Formula
Trace score % = units traced / units produced x 100. Lot score % = lots fully traced / lots in scope x 100. Exercise steps and checklist are from Food Quality Assurance, Ch. 4.14: identification records (product name, recipe, product code, production date, day code, lot and batch number), forward traceability (raw materials and ingredients) and backward traceability (finished products), covering inventory, shipped foods, foods delivered to customers and foods sold to consumers.
Variable definitions and units
Units produced and traced: count. Lots in scope and lots fully traced: count. Trace score and lot score: %.
Assumptions
Identification records exist for every lot in scope. Traced means the full history, application and location can be shown from records.
Input validation
Units produced greater than 0. Units traced 0 to units produced. Lots in scope greater than 0. Lots fully traced 0 to lots in scope.
Worked example
Live Batch Genealogy Explorer worked test: produced 10000, traced 9800, 4 lots. Trace score = 9800 / 10000 x 100 = 98.00%. With all 4 lots fully traced, lot score = 100%. Exercise generated: backward trace of one finished lot to its raw materials, then forward trace of one raw material lot to all finished products.
Expected output
Trace score %, lot score %, and a generated exercise: scenario, direction (forward or backward), lots to trace, and the book checklist to complete.
Calculation limitations
A drill score measures record completeness, not record truth: it cannot detect a wrong lot code entered at packing. The book gives no drill timing target; time is recorded by the user, not scored here.
Source
Food Quality Assurance: Principles and Practices, Ch. 4.14.1 to 4.14.2 and glossary (Traceability). Completes live Batch Genealogy Explorer and Meat and Seafood Batch Traceability.