A snack maker's inventory is three kinds of stock on one list: ingredients bought by the case, packaging bought by the thousand, and finished pouches counted one by one. Each row has a unit, an amount on hand, a level to reorder at, and a cost. That covers "what do we have". It doesn't cover the question a maker actually asks on Monday, which is how many batches can the shelf make, so the page adds that sum. And because a snack mix puts one supplier's almonds into hundreds of pouches, a second sheet keeps each delivery's lot and each batch's best-by date. The example is a made-up maker of snack mixes.
The short version
- One list: ingredients, packaging, finished goods, each in the unit you buy or sell it in.
- A reorder level for every row, and a status that says when you're at or under it.
- Work out how many batches each ingredient covers. The smallest number is what you can make.
- Write the lot of every delivery, and a batch code and best-by date for every batch.
- Count finished pouches weekly and ingredients monthly.
- TaroStack takes ingredients off the shelf as you record a batch. More below.
An example list
Counted in the third week of November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Almonds, roasted, 25 lb case | case | 6 | 4 | $118.00 | $708.00 | OK |
| Cashews, roasted, 25 lb case | case | 2 | 3 | $142.00 | $284.00 | REORDER |
| Pretzel twists, 12 lb case | case | 9 | 6 | $21.50 | $193.50 | OK |
| Sesame sticks, 15 lb case | case | 4 | 4 | $38.00 | $152.00 | REORDER |
| Dried cranberries, 25 lb case | case | 3 | 2 | $64.00 | $192.00 | OK |
| Seasoning blend, 5 lb tub | tub | 5 | 3 | $27.00 | $135.00 | OK |
Ten rows in all, $4,586.70 at cost, with four to reorder: cashews, sesame sticks, printed pouches and the cranberry almond mix. The other four rows are the pouches, the shipping cases, and the two finished mixes: 860 pouches of nut and pretzel mix and 340 of cranberry almond.
Nearly half the value, $2,176.20, is finished pouches. That's normal the week after a big batch, and it's the stock with a date on it.
How many batches is that?
One batch of nut and pretzel mix is 480 pouches of 6 oz: 180 lb.
| Ingredient | In a batch | On hand | Batches covered | Status on the list |
|---|---|---|---|---|
| Almonds | 45 lb | 150 lb | 3.3 | OK |
| Cashews | 27 lb | 50 lb | 1.9 | REORDER |
| Pretzel twists | 60 lb | 108 lb | 1.8 | OK |
| Sesame sticks | 36 lb | 60 lb | 1.7 | REORDER |
| Seasoning blend | 12 lb | 25 lb | 2.1 | OK |
| Printed pouches | 480 | 2,000 | 4.2 | REORDER |
The shelf makes one batch. The second stops at sesame sticks, then pretzels, then cashews.
The list and the sum disagree twice. Pretzels read OK, nine cases against a level of six, and cover fewer than two batches, because a batch takes five cases. Pouches read REORDER and cover more than four. A reorder level in cases says nothing about batches unless it was set from the recipe.
Set the level from the recipe. If this maker mixes twice a week and pretzels take a week to arrive, the pretzels used while waiting are two batches, ten cases, and the level should be above that, not six. The sum is in reorder point example, and the cushion on top in safety stock formula. Pouches are different: a printed pouch can take weeks, so its level is high for a reason.
Deliveries and batches, with their lots
| Received or made | Item | Lot or batch | Quantity | Best by | Note |
|---|---|---|---|---|---|
| Nov 9 | Almonds, roasted, 25 lb case | Lot AL-26-3310 | 6 | May 9, 2027 | Tree nut. Certificate with the delivery |
| Nov 12 | Sesame sticks, 15 lb case | Lot SS-48812 | 4 | Feb 12, 2027 | Wheat, sesame, soy on the supplier's label |
| Nov 17 | Nut and pretzel mix, 6 oz pouch | Batch NP-1117 | 480 | Mar 17, 2027 | Best by four months from mixing |
A snack mix is the case where lots matter most. If the nut importer phones about almond lot AL-26-3310, the question is which batches it went into and which shops got them. A maker who wrote the almond lot on each batch's sheet can answer in minutes. One who didn't recalls everything made since November 9.
Two more things on this sheet:
The shortest date sets the batch's date. This maker gives a mix four months, from its own shelf-life checks. The sesame sticks in batch NP-1117 are best by February 12, a month before the pouch's date. Either the pouch's date comes forward or older sesame sticks don't go into a mix. Decide which, and write it down. What a test involves is in shelf life testing.
Allergens come in with ingredients. The sesame sticks' label lists wheat, sesame and soy. Every time a supplier or a product changes, read the new label against your own: see allergen matrix template and food allergen labeling requirements.
Counting
Count finished pouches every week, by batch, oldest first, and ship the oldest first. Count ingredients and packaging once a month, with opened cases as a fraction: half a case of almonds is 0.5. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A plan for what to count when is in cycle count form. If the business is still on paper, the plan it grows from is in snack business plan.
Get the template
Download the snack inventory template. The list with values and a status for each row, a sheet for deliveries and batches with lots and best-by dates, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Every batch changes eight rows, and nobody types eight rows after mixing 180 lb of snack mix. So by Thursday the list is Monday's count. The batches-covered table has to be redone by hand for each mix. And the link between an almond lot and the pouches it went into is only as good as a handwritten line on a batch sheet.
How TaroStack does it
In TaroStack the recipe does the typing.
Recording a batch takes its ingredients off the shelf and puts the finished pouches on, from the recipe, with unit conversion: buy by the case, mix by the pound.
"What could I make right now" is the batches-covered table, for every recipe, from what's actually on hand.
The batch notes which lots it used, automatically, and the lot it makes carries your code and best-by date.
First-expired-first-out by default when picking, with lots close to their date flagged.
One recall report: which supplier lots went into which batches, which customers got them, and what's still on your shelf.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Stock after a batch | Retype eight rows | Recorded with the batch |
| How many batches the shelf covers | A table for each mix | What could I make right now |
| Which pouches hold almond lot AL-26-3310 | Read the batch sheets | The recall report |
| Which pouches ship first | Check dates by hand | First-expired-first-out |
Lots, dates, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). Allergen tracking is on Growth. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
