Traceability, Serialization & Lot Genealogy worked example

Lot Record Completeness at 21% lot files found incomplete: a worked example

This scenario runs the lot record completeness calculation on the strong side: 21% lot files found incomplete, with every other input held at its documented default. A quality lead budgeting the effort to bring a backlog of lot records up to a complete, traceable standard ahead of a customer or regulatory audit.

The inputs for this scenario

  • Lot records to reconcile: 1,200 lots (unchanged)
  • Labor to close out one lot file: 6.5 $/lot (unchanged)
  • Lot files found incomplete: 21 % (raised for this scenario; the documented default is 18)
  • Audit and traceability system fees: 3,200 $ (unchanged)

Working through the calculation

  • Applying the documented formula (Completeness remediation cost = lots to reconcile x labor per lot x incomplete% + audit fees) to the inputs above produces each figure below.
  • At this operating point the engine returns 4,838 $ for total lot record completeness cost, the number this scenario is built around.
  • At this operating point the engine returns 4.03 $ / piece for lot record completeness cost per unit.
  • At this operating point the engine returns 1,638 $ for variable lot record completeness cost.
  • At this operating point the engine returns 3,200 $ for fixed lot record completeness adder.

How this compares with the baseline

  • Against the tool's baseline example, where lot files found incomplete sits at 18% and the headline result is 4,604 $, this scenario comes in 5.08% above the baseline at 4,838 $.
  • Use it before an audit cycle, during a recall readiness assessment, or when building the ROI case for an electronic batch record or traceability system. Treat this as a target state: the delta against the baseline quantifies what the improvement is worth before you commit to chasing it.

Results at a glance

  • Total lot record completeness cost: 4,838 $ (headline result)
  • Lot record completeness cost per unit: 4.03 $ / piece
  • Variable lot record completeness cost: 1,638 $
  • Fixed lot record completeness adder: 3,200 $

Run it with your numbers

  • Every input above is editable in the live Lot Record Completeness calculator, which recalculates instantly and can be shared with the inputs intact.

Last reviewed 2026-05-12.