Avoid preventable shortages
Reliable balances and reorder points give you time to buy normally instead of paying rush costs or missing orders.
Inventory and traceability
Know what you have, where it came from, and where it went.
A stock count tells you how much is on the shelf. Traceability explains how it arrived, which batch used it, and which customers received the finished product.
The short version
In plain English: give items and batches clear names, record every important movement, and practice finding affected products before there is a real problem.
What you will be able to do: By the end, you should be able to trust the available-stock number, know when to reorder, and trace a finished lot back to its inputs and forward to the people who received it.
This guide is useful when you are:
- Reducing surprise stockouts
- Tracking ingredients or materials by lot
- Preparing for a complaint, withdrawal, or recall
Why this is worth learning
The business value behind the work
Use cash more wisely
Clear stock history shows what moves, what expires, and where money is sitting on the shelf.
Limit the size of a problem
Good lot links help you hold or recall only affected product instead of everything you have made.
A simple path
- 01
Give every item and lot a clear identity
- 02
Record receipts, use, moves, and sales
- 03
Set a practical reorder point
- 04
Practice tracing one lot backward and forward
Lesson 01
Name items consistently
What this means
Use one clear record for each material, package, and finished product. Add the unit you count, storage location, suppliers, shelf-life details, and lot-number rule. Keep supplier prices attached to the item instead of creating a new item every time the supplier changes.
Why it matters
Consistent item names and units create the foundation for every later count. If one person records flour by bag, another by pound, and a third creates a new item for each supplier, the total cannot be trusted without manual cleanup.
How to approach it
- 1Create one internal identity for each distinct material, package, and finished product.
- 2Choose a base counting unit and define conversions for cases, bags, or other purchase units.
- 3Attach supplier offers, lot rules, shelf life, and storage locations to that identity.
Worked example
Example: “Vanilla extract, fl oz” remains one inventory item even when you switch suppliers. Each receipt still records its supplier, price, amount, and supplier lot.
Common mistake
Creating “Flour—Supplier A” and “Flour—Supplier B” when the materials are truly interchangeable. This splits history and makes demand harder to see.
What good looks like
A team member can search one item and see its total quantity, locations, current lots, suppliers, and unit conversions without combining spreadsheets.
Choose one name and one counting unit for each item before entering opening stock.
Lesson 02
Record each movement
What this means
Stock changes when you receive, make, use, transfer, sell, waste, return, or correct something. Record the reason each time. Keep stock that is on hold, expired, or rejected separate from stock that is ready to use or sell.
Why it matters
A physical count is a snapshot; movements explain how the number changed. That explanation is what lets you fix errors, trace lots, understand waste, and separate usable stock from stock that is merely present.
How to approach it
- 1Use named movement types for receipts, production use, output, transfers, sales, returns, waste, and corrections.
- 2Require a source such as a receipt, batch, order, or adjustment reason.
- 3Track status separately so held, expired, rejected, or reserved stock is not promised to normal work.
Worked example
Example: You have 40 jars in the building, but 8 are on hold after a damaged shipment. Your team should see 32 available—not 40 available.
Common mistake
Overwriting the balance to match a shelf count without recording the difference. The number improves, but the cause—and possibly a theft, unit, or process problem—disappears.
What good looks like
Starting balance plus recorded increases minus recorded decreases equals the current balance, and available stock excludes anything not cleared for use.
If a count changes, make sure the history shows why, when, and who made the change.
Lesson 03
Reorder before it becomes urgent
What this means
A reorder point should consider how quickly you use the item and how long the supplier takes to deliver it. Then allow some extra stock for normal uncertainty. Also consider minimum orders, shelf life, storage space, and seasonal demand.
Why it matters
Reordering too late causes shortages; reordering too early ties up cash and storage. A useful reorder point covers normal use during delivery time and adds a buffer for the uncertainty you actually experience.
How to approach it
- 1Measure average use in the same unit and time period used for supplier lead time.
- 2Multiply normal use by realistic lead time, including order processing and receiving.
- 3Add safety stock based on demand swings, supplier delays, shelf life, storage, minimums, and the cost of running out.
Worked example
Example: You use 10 boxes a day and delivery normally takes 7 days. You need at least 70 boxes during lead time, plus a sensible buffer based on past delays and demand changes.
Common mistake
Using the supplier’s best delivery promise as the normal lead time, or adding a large “just in case” buffer without considering expiration and cash.
What good looks like
Most orders arrive before stockout without leaving repeated excess or expired material, and the rule is adjusted from actual history.
Start with your normal use and delivery time; improve the buffer after you have real history.
Lesson 04
Practice a mock recall
What this means
Pick one finished lot. Trace backward to its recipe version, production record, ingredient and packaging lots, suppliers, and receipts. Then trace forward to stock still on hand, customer orders, shipments, samples, and rework. Note what was missing and how long the exercise took.
Why it matters
A mock recall tests whether the records work under pressure. Backward tracing identifies possible causes and other affected products; forward tracing identifies stock and recipients that may need action.
How to approach it
- 1Choose a real finished lot without warning the person doing the trace.
- 2Trace backward through production to every input lot and supplier receipt.
- 3Trace forward to remaining stock, rework, samples, orders, and shipments; record time, missing links, quantity accounted for, and corrective actions.
Worked example
Example: For lot COOKIE-260814-A, identify every flour and chocolate lot used, all 18 customer orders that received it, and the 12 bags still in storage.
Common mistake
Calling the exercise complete after finding the ingredient supplier. A useful test also finds every destination and reconciles how much product was made, remains, and was distributed.
What good looks like
The team can produce a clear lot history and recipient list within its target time, account for the quantity, and close every gap found during the exercise.
Run a timed practice at least once a year, and more often when products or processes are high risk.
Questions people ask
Frequently asked questions
What is the difference between a lot number and a SKU?
A SKU identifies the type of product, such as an 8-ounce vanilla candle. A lot number identifies a particular group made or received together, such as the units produced in one run.
Does available stock equal stock on hand?
Not always. Stock on hand may include items on quality hold, reserved for orders, expired, damaged, or rejected. Available stock is the portion cleared and uncommitted for normal use or sale.
How often should we run a mock recall?
At least annually is a common starting practice, but product risk, customer requirements, regulations, and major process changes may justify more frequent exercises.
Quick definitions
Terms worth knowing
- Lot
- A defined group of material or product made or received together.
- Available stock
- Stock that is present and cleared for normal use or sale.
- Traceability
- The records that connect incoming materials, production, and outgoing products.
Try it with your numbers
Free tools for this workflow
These tools help with the math and organization. Save your inputs and assumptions, and use qualified advice where safety, tax, or legal requirements are involved.
Lot and batch codes
Create examples for a simple, consistent coding system.
Open tool →Reorder point and safety stock
Estimate when to reorder from use and delivery time.
Open tool →Inventory investment
See how much cash is tied up in stock.
Open tool →Cash conversion cycle
Estimate how long operating cash stays tied up.
Open tool →Production quantity
Use demand and available stock to plan what to make.
Open tool →Best-by date planning
Coordinate study, production, pull, and customer-facing dates.
Open tool →Keep going in Batch Scale
Helpful pages and next steps
Build better batch records
Connect each finished lot to the recipe and materials actually used.
Visit page →Plan food safety checks
Connect holds, checks, and corrective action to affected lots.
Visit page →Browse inventory planning tools
Use calculators for reorder points, production quantity, dates, and cash.
Visit page →Go deeper
Related practical guides
Inventory & Traceability
The SKU Naming System That Saves Hours Every Month
Build stable internal product identifiers that remain unique, readable, scannable, and useful across purchasing, production, sales, and retirement.
Read guide → Inventory & TraceabilityHow to Set a Reorder Point When Demand Is Messy
Use baseline consumption, demand scenarios, observed supplier lead time, open supply, and a review trigger instead of searching for one magical number.
Read guide → Inventory & TraceabilityYour Supplier Went Silent: A 48-Hour Continuity Plan
Stabilize open orders, calculate stock coverage, qualify alternatives, control substitutions, and communicate before silence becomes a customer crisis.
Read guide → Inventory & TraceabilityYour Inventory Is Lying to You: Available, Committed, Damaged, and Work in Progress
Replace one misleading on-hand number with inventory states that support real purchasing, production, and customer promises.
Read guide → Inventory & TraceabilityHow to Negotiate Supplier MOQs Without Losing Trust
Approach minimum-order negotiation with demand evidence, workable tradeoffs, clear payment, and a path to becoming a better customer.
Read guide → Inventory & TraceabilityRecall Quantity Reconciliation: Account for Every Unit in a Lot
Reconcile produced, held, sampled, wasted, reworked, sold, returned, and remaining quantities during a mock recall.
Read guide →Check the source
Trusted places to learn more
Rules and guidance can change. Open the current source and get qualified help for your exact product, process, location, and claims.
-
FDA: Traceability lot code explained ↗
A clear explanation of lot codes, when they are assigned under the Food Traceability Rule, and how records can link to them.
-
FDA: Food Traceability Final Rule ↗
Check whether the rule and its additional recordkeeping requirements apply to your foods and activities.
-
FDA: Food recalls and industry resources ↗
Official recall information and links for food businesses preparing to respond.
Ready to organize the work?
Keep the recipe, cost, inventory, orders, and records connected.
Batch Scale turns one-time calculations into a repeatable workflow your team can follow.