What's inside
- Products: price, shipping, minutes to make and packaging give you materials cost, labor cost, total cost per item, Etsy fees, profit per sale and margin
- Recipes: what goes into one item (e.g. 4 g silver wire + 1 gift box), so cost updates when material prices change
- Materials: weighted average cost per unit across all purchases, used, on hand, and a Reorder flag below your level
- Made (production log) and Purchases: materials on hand update automatically as you make batches and buy supplies
- Settings: your hourly rate and Etsy's fee rates in one place
- Sample: a jewelry and candle maker with 8 materials, 3 products and real batches
Checked, not just designed: 1,540 formulas, zero errors; every material's average cost, used and on-hand amount and every product's costs, fees and profit in the sample match an independent calculation.
Works in Excel and Google Sheets. Not affiliated with Etsy.