Inventory sounds like something for warehouses. For a maker it’s simpler and more personal: it’s knowing you have enough cord for the 12 bracelets someone just ordered, and knowing what those bracelets cost you now that cord went up again.
Two kinds of inventory
- Supplies: the raw materials. Wax, yarn, blanks, beads, glaze, jars, boxes.
- Finished products: the things you sell, made and ready to ship.
Most makers track one and guess the other. Tracking both, and the link between them, is what makes the numbers useful.
Step 1: List your supplies with a unit and a cost per unit
Pick the unit you actually use: ounces of wax, yards of fabric, each for jars. Then work out the cost per unit. A 10 lb bag of wax for $32 is $3.20 a pound, or $0.20 an ounce. Use the price you paid, including shipping on the supply order.
Step 2: Write a recipe for each product
A recipe is the list of supplies in one finished item and how much of each: 8 oz wax, 1 wick, 0.5 oz fragrance, 1 jar, 1 label. Once every product has a recipe, two things become easy: you know what each product costs, and you know how many you can make with what’s on the shelf.
Step 3: Count what you have
Do one honest count of everything. It’s tedious once and then it’s done. From now on you only record changes.
Step 4: Record the three changes
- When you buy, add to supplies, and update the cost per unit if the price changed.
- When you make, take the recipe’s supplies off the shelf and add the finished items.
- When you sell, take the finished items off.
Step 5: Set a reorder point
For each supply, decide the level where you reorder: enough to cover the time it takes to arrive, plus a little. If wicks take two weeks to arrive and you use 50 a week, reorder at about 120.
Step 6: Recount every month or two
Things get spilled, sampled, miscounted and given to your sister. A quick recount keeps the numbers honest. Fix the count and move on; nobody’s grading this.
Sizes, colors and other variants
If you sell a tee in five sizes and three colors, that’s 15 things to count, not one. Track stock for each combination, and write recipes that know which blank goes with which size. This is usually where a notebook gives up.
Notebook, spreadsheet or app?
- A notebook is perfect for your first handful of products and one place you sell.
- A spreadsheet works well until recipes share supplies, prices change, or you have variants. Then every change means updating several tabs by hand, and the formulas quietly break.
- An app made for makers links supplies, recipes, stock and sales, so making ten candles updates the wax count, and a price change updates what every product costs.
Whatever you use, the habit matters more than the tool. Record the three changes and recount now and then, and you’ll always know what’s on the shelf.