Operations
Batch Manufacturing Inventory Tracking: Lots, FIFO, and Traceability
In batch manufacturing, a single number for 'how much do we have' is not enough. You need to know which lots you hold, which ones a batch consumed, what that batch cost, and which customers received it. This guide covers the mechanics of lot-level inventory tracking that holds up in an audit and in a recall.
Published August 8, 2026 by Recipe To Quote Pro
Track lots, not just quantities
A material balance of "18.4 kg on hand" tells you nothing about expiry, supplier, cost basis, or CoA status. Lot-level tracking records each receipt separately:
- Lot number and supplier
- Received date and quantity, in the purchase unit
- Cost per unit for that specific receipt
- Expiry or retest date
- Linked CoA and specification documents
- Remaining quantity as batches consume it
FIFO consumption, done correctly
When a batch runs, the required quantity should drain the oldest open lots first, moving to the next lot when one is exhausted. Three details matter:
- Unit conversion. Formulas are often written in mg per unit while stock is held in kg. Convert through a common base before deducting, or the deduction is wrong by orders of magnitude.
- Yield scaling. Multiply the per-unit requirement by the batch size, adjusted for expected loss. Never deduct a per-unit quantity as if it were a batch quantity.
- Shortfalls. If available lots cannot cover the requirement, the system should flag the gap rather than allow negative stock — negative stock is how phantom inventory starts.
Deductions should also be reversible. If a batch is cancelled or a quote reverts from accepted to draft, the consumed quantities go back to the lots they came from, in the same order.
Separate packaging from ingredients
Bottles, lids, labels, shrink bands, and cartons behave differently from actives and excipients: they are counted rather than weighed, they have longer lead times, and label changes obsolete stock. Tracking them in the same undifferentiated list makes both costing and reordering harder. Keep them as distinct material types that still roll into the same formula cost.
Reorder points that account for incoming stock
Available stock is on-hand plus quantities on open purchase orders, minus quantities committed to scheduled batches. Comparing only on-hand against the reorder point causes duplicate purchase orders; ignoring committed quantities causes stockouts mid-run. Both are visible problems once incoming and committed quantities are shown on the material record.
Traceability in both directions
- Backward: from a finished batch, list every raw material lot consumed, with quantities and CoA status.
- Forward: from a raw material lot, list every batch that consumed it and every customer shipment those batches fed.
If either direction requires reconstructing history from emails and spreadsheets, your effective recall window is measured in days rather than minutes.
A weekly discipline that keeps records honest
- Cycle count a rotating subset of materials and reconcile against system quantities.
- Compare estimated vs. actual consumption for each completed batch.
- Review lots approaching expiry or retest.
- Clear any material missing a CoA before it is scheduled into a batch.
- Confirm every open purchase order still has a realistic arrival date.
How Recipe To Quote Pro handles it
Recipe To Quote Pro tracks ingredients and packaging as separate material types with lot-level records, consumes stock FIFO with automatic mg/g/kg conversion and yield scaling, restores quantities when a status is reversed, flags shortfalls instead of allowing negative stock, and shows incoming quantities from open purchase orders on each material. Batch records carry QC checkpoints and ingredient lot traceability with CoA status on every line.
Ready to put this into practice? Start a 14-day free trial of Recipe To Quote Pro and turn your formulas into accurate, profitable quotes.
Frequently Asked Questions
- What is batch manufacturing inventory tracking?
- It is tracking raw materials, packaging, and finished goods at the lot level through each production batch, so you know exactly which incoming lots were consumed by which batch and where that batch was shipped.
- Why use FIFO for raw material consumption?
- FIFO consumes the oldest lots first, which matches how perishable and dated materials should be used, keeps cost basis consistent with purchase order history, and reduces write-offs from expired stock.
- How does batch yield affect inventory deductions?
- Requirements must be scaled by the batch size and expected yield. Deducting per-unit quantities without scaling to the actual batch produces either large over-deductions or phantom stock, and both corrupt reorder decisions.
- What is the difference between forward and backward traceability?
- Backward traceability answers 'what went into this finished lot?' Forward traceability answers 'if this raw material lot is recalled, which finished lots and customers are affected?' A recall requires both, quickly.
- How do reorder points work in batch manufacturing?
- Set a reorder point per material based on lead time and typical consumption, then compare on-hand plus incoming purchase order quantities against it. When available stock falls below the point, a purchase order should be triggered before the next scheduled batch.