The handmade pricing formula
Add your materials, your labor (hours x an hourly wage you would accept) and a share of overhead like tools and packaging. That is your cost to make. Add a profit markup to get a wholesale price, then multiply it, usually by 2, for retail.
The 2x retail rule is a common rule of thumb, not a law. It leaves room for shop fees, discounts and selling to stores later.
Your lowest safe price
The lowest safe price covers every cost and the selling fees, with zero profit. Never go below it. If the market will not pay your retail price, look at your time and materials before you cut the price.
The formulas behind it
Every result cell is a plain spreadsheet formula, so you can check the math or rebuild it yourself.
| Cell | Result | Formula |
|---|---|---|
| B11 | Labor cost | =B3*B4 |
| B12 | Total cost to make | =B2+B11+B5 |
| B13 | Wholesale price | =B12*(1+B6%) |
| B14 | Retail price | =B13*B7 |
| B15 | Lowest safe price | =B12/(1-B8%) |
| B16 | You keep at retail | =B14*(1-B8%)-B12 |
