A dog treat bakery has three kinds of stock, and its inventory spreadsheet keeps all three on one sheet: ingredients, packaging, and finished bags. The finished bags are the part that needs most care. Every batch gets a lot code and a best-by date, both printed on the bag, and the sheet's second tab lists each batch with how many bags are left and how many days they have. That's what lets you ship the oldest first, see a soft biscuit running out of time, and answer a shop that asks which bags came from which bake. One ingredient gets a check of its own at the door: peanut butter, for xylitol. Below is a sheet for a made-up bakery in November, the lots tab, and the file.
The short version
- Ingredients, packaging and finished bags, each with a reorder level.
- A lot code and best-by date on every bag.
- Ship the oldest lot first.
- Soft treats have short dates. Bake them to order or in small batches.
- Check every peanut butter delivery's label for xylitol.
- TaroStack gives each batch its code and takes the ingredients off stock. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Oat flour | lb | 42 | 40 | $1.10 | $46.20 | OK |
| Peanut butter, no xylitol | lb | 18 | 15 | $2.40 | $43.20 | OK |
| Pumpkin puree, #10 can | can | 5 | 6 | $7.80 | $39.00 | REORDER |
| Eggs, large | dozen | 6 | 5 | $4.20 | $25.20 | OK |
| Sweet potato, dried slices | lb | 9 | 6 | $5.50 | $49.50 | OK |
| Resealable pouch, 6 oz | each | 260 | 300 | $0.24 | $62.40 | REORDER |
Ten rows in all, $712.40 of stock, with three to reorder: pumpkin puree, pouches, and the pumpkin biscuits themselves. For a finished product, "reorder" means bake.
Three kinds of stock
| Kind | Counted in | Reorder level means |
|---|---|---|
| Ingredients | Pounds, cans, dozens | Order from the supplier |
| Packaging | Eaches | Order, and mind the lead time: printed pouches and labels take weeks |
| Finished bags | Bags, by lot | Bake a batch |
Packaging is the one that catches people. Flour comes in two days. Printed pouches can take three weeks, and a bakery with ingredients and no bags can't sell anything. The pouch row is at 260 against a level of 300, set high for that reason.
Lots on the bag
| Baked | Product | Lot | Bags made | Left | Best by | Note |
|---|---|---|---|---|---|---|
| Nov 4 | Peanut butter biscuits | PB-1104 | 120 | 36 | May 4 | Ship these first |
| Nov 18 | Peanut butter biscuits | PB-1118 | 60 | 60 | May 18 | |
| Sep 2 | Pumpkin biscuits | PK-0902 | 90 | 38 | Dec 2 | 11 days left |
The lot code here is two letters for the product and the bake date. Any scheme works if every batch has its own and it's on every bag: see how to create lot numbers.
Oldest first. There are 96 bags of peanut butter biscuits: 36 from November 4 and 60 from November 18. The next order ships from PB-1104. Keep the older lot at the front of the shelf.
Short dates. The pumpkin biscuit is softer and this bakery gives it three months, against six for the crunchy ones. Thirty-eight bags have eleven days left. They're the bags to put in this week's market basket at a discount, and the reason to bake that product in batches of 45, not 90. How long each kind keeps is in dog treats shelf life.
The complaint. A shop calls about a bag. With the code, you know the bake, what went into it and which other shops got bags from it. Without the code, every bag of that product in every shop is in question.
The xylitol check
Xylitol is a sweetener used in some peanut butters and other sugar-free foods, and it's dangerous to dogs. A brand can change its recipe without changing its jar. So every delivery of peanut butter is checked at the door: read the ingredient list, write the supplier's lot number on the sheet, and note that it was checked. The same goes for any ingredient that's a blend made by someone else.
Dog treats sold in stores are animal feed under state law, with their own label and registration rules: see dog treat business license. Packaging is covered in how to package dog treats for sale, and pricing in how to price homemade dog treats.
Get the spreadsheet
Download the dog treat inventory spreadsheet. Four sheets: inventory with value and REORDER, lots with days left, a count sheet that works out each difference and what it's worth, 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
A batch of 120 bags changes eight rows: flour, peanut butter, eggs, pouches and labels go down, finished bags go up, and a new lot goes on the second tab. Then every order takes bags off, from one lot or two. The sheet is right if all of that is typed in every time. And it never records the link that matters in a complaint: which peanut butter delivery went into which bake.
How TaroStack does it
TaroStack makes the batch do the bookkeeping.
Each treat is a recipe. Record a batch and the flour, peanut butter, pouches and labels come off stock.
Every batch gets a lot code and a best-by date, and lot labels print with both.
The batch notes which ingredient lots it used, automatically: the peanut butter delivery is on the record of every bake it went into.
Oldest first. Bags ship first-expired-first-out by default, with an alert before a date arrives.
One report for a recall: which shops got a lot, how many bags, and what's still on your shelf.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take ingredients off after a bake | Eight rows by hand | Recorded with the batch |
| Which lot to ship | Read the second tab | Oldest first, by default |
| Bags near their date | Look for the flag | The expiry alert |
| Which bakes used that peanut butter | Not recorded | The lots on each batch |
Stock, lots, recipes and recalls are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
