Maker Inventory and Pricing Excel Template

Candles, soap, jewelry or anything else you make in small batches: this inventory and pricing spreadsheet shows what each product really costs you and what to charge for it. Record your materials and a recipe for each product one time, and it works out unit cost, retail and wholesale prices, margins and stock for you.

Unit cost covers materials, packaging, your labor at your own hourly rate and a share of overhead, so the price pays you too. Log a production batch and the materials come out of stock while the finished pieces go in; the reorder list and a Make More flag for products below your target stock keep up on their own. Each sales channel, from craft markets to wholesale and consignment, can carry its own fee percentage, and every product shows its margin after fees.

It works in any currency and any unit, from grams to ounces to pieces. You get a blank workbook, a sample with a year of data for a fictional candle and soap studio, and a quick-start guide, for Microsoft Excel 2010 or newer on Windows and Mac.