Makerkeep

Supplies and inventory

How to keep track of craft supplies and inventory

A simple system for knowing what’s on your shelf, what each product uses, and when to reorder, whether you use a notebook, a spreadsheet or an app.

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

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

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?

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.

Let Makerkeep do the arithmetic.

Makerkeep keeps your supplies, recipes, prices and sales in one place, made for small shops that make what they sell. Sketchbook is free for up to 5 products, for as long as you like.