Wholesale Pricing Calculator for Handmade Sellers, with a Line Sheet

A shop wants to stock your work. What do you charge them, what should it sell for, what do you get on consignment, and how many must they order? This kit works it out from what each item really costs you, and turns the answers into a line sheet you can send to boutiques.

Buy it — $4.99

How the prices are worked out

Every markup, your hourly rate, your overhead and your consignment share are yours to change. Any product whose wholesale or consignment price would lose you money is flagged.

Example: an 8 oz soy candle

LineAmount
Materials (wax, fragrance, jar, wick, label)$4.20
Labor: 12 minutes at $25 an hour$5.00
Overhead: $300 a month over 150 items$2.00
Cost to make$11.20
Wholesale ($22.40, rounded)$22.50
Retail (MSRP)$45.00
Consignment payout at 60/40$27.00
Case of 6, wholesale$135.00

What you get

1. The pricing workbook

2. The Line Sheet Maker

Fill in a form in your browser and print your line sheet, or save it to send. It holds your logo, business name and season, then a table of products with SKU, description, wholesale price, MSRP, case pack, case price and minimum units, followed by your opening and reorder minimums, payment terms, lead time, shipping, consignment terms and contact details. Open your workbook in it and picking a product fills in its SKU, prices, case pack and minimum; each line sheet you make for a named shop is added to your pitch log. What you type stays in your browser.

3. The printable guide and worksheets

Questions

Who is it for?
Makers of candles, soap, jewelry, ceramics, prints, textiles and other handmade goods who sell, or want to sell, to boutiques and gift shops, wholesale or on consignment.
Do I have to use a markup of 2?
No. 2 for wholesale and 2 for retail is the usual starting point; change either in Settings and every product updates.
Does it handle consignment?
Yes. Set your share of the retail price (60% is common) and each product shows your payout and your profit on consignment next to wholesale.
Does the line sheet include product photos?
No. It carries your logo, products, prices, case packs, minimums and terms. Send photos alongside it, or link to them from your site.
Which spreadsheet programs does the workbook work in?
It is built for Excel and Google Sheets, and uses only common formulas (IF, ROUND, VLOOKUP).
Is it a subscription?
No. You pay $4.99 once and keep everything.

Buy it — $4.99

The prices it suggests are a starting point worked out from your own costs. Check them against similar work in the shops you pitch before you publish them.