Free tool
Custom blend price calculator
Enter what one batch actually consumed and see the loaded cost per finished bottle, a working shelf price, and what the whole batch contributes.
Free tool, no sign up
Ingredient lot trace exposure calculator
See how far one questionable herb lot reaches into your production and what it would cost you in hours to reconstruct the trail by hand.
Traceability feels abstract until a supplier emails about a lot of valerian root, or a client reports a reaction, and you have to work out which batches that lot touched. The answer depends on three things: how many lots you take in, how many batches you run, and how many different herb lots go into a typical formula.
The defaults describe a small shop taking in about fourteen supplier lots a month, running nine batches, with six distinct herb lots in a typical blend. Change them to your own and look at the hours figure. That is the number that decides whether your intake numbering is a habit or a hope.
Your result
Batches one suspect lot touches
23.1
How many batch records a single questionable herb lot is likely to appear in.
Finished units involved
555
Bottles and jars you would have to account for if that lot were pulled.
Hours to trace it by hand
17.4
Time spent reconstructing the trail from paper batch sheets and invoices.
Lot to batch links per month
54
The number of herb lot connections your records have to carry every month.
These figures assume your open lots get used at a roughly even rate; a house favorite like tulsi or elderberry will appear in far more batches than the average and is worth checking on its own.
Why the links pile up faster than the lots
A shop taking in fourteen supplier lots a month does not have fourteen things to track. It has fourteen lots multiplied by every batch each one lands in, and a multi herb formula creates six or more of those connections in a single afternoon at the bench. That is the number that makes a paper system slow, not the count of jars on the shelf.
Once the links per month figure passes about fifty, hand tracing stops being realistic. Not because it cannot be done, but because it will be done at the worst possible moment, under pressure, from a binder that somebody else filed.
Cutting the hours before you need them
Every hour in the trace figure is bought back at intake. Writing an intake lot code on the bag the day it arrives, and copying that code onto the batch sheet as you weigh, turns a two day reconstruction into a lookup. It is five seconds of pen work per jar and it is the single highest return habit at a small apothecary bench.
The other lever is the retain sample. A labeled retain from each batch means that when a question arrives you have physical material to inspect, not just paperwork, which changes what you are able to tell a client, a supplier or a buyer.
Questions about this calculator
What if one herb appears in almost every blend I make?
Then the average this tool gives you understates that herb badly. Run the numbers again with lots per batch set to one and batches per month set to how often that specific herb appears. A staple like elderberry, tulsi or oat straw usually deserves its own exposure figure and tighter intake discipline.
How long should I keep records for a lot that is long gone?
Keep them past the shelf life of the finished product, not just past the point where the herb is used up. A salve made in March can sit on a shelf or in a customer cabinet for a year or more, so the batch record and the intake log need to outlive the jar itself. Many shops keep production records for several years as a matter of practice.
Does a supplier certificate of analysis reduce this exposure?
It reduces the chance that a lot turns out to be a problem, and it gives you something to hand over when someone asks. It does not shorten the trace itself. You still need to know which of your batches used that lot, which is the link this calculator sizes.
More free tools and working documents
Working document
The traceable batch record sheet
One page you can print, clip to the bench and fill in as you work, built so any finished bottle traces back to the jars it came out of.
Now put that number on a live batch
The figure above came from estimates you typed once. In HerbalCounter it comes from the batch you closed on Tuesday, with the grams weighed, the bottles counted after filtration and the herb lot codes already on the record. Ask for a demo and we will load one of your own formulas so the per bottle cost and the trace both fall out of the same sheet.