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.
Cost to make = materials + labor + a share of overhead
Wholesale = cost to make × your wholesale markup (2 to start)
Retail (MSRP) = wholesale × the shop's markup (2 to start)
Consignment payout = retail × your share (60% on a 60/40 split)
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
Line
Amount
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
Settings: your hourly rate, monthly overhead, items made per month, wholesale and retail markups, consignment share, opening and reorder minimums.
Products: one row per product. Type the materials cost and minutes of work; it fills in labor, overhead, cost to make, wholesale, retail, profit on wholesale, consignment payout, profit on consignment and case price. Room for 60 products.
Order check: type what a shop wants, in cases, and see the order total to compare with your minimum.
Pitch log: every boutique you send a line sheet to, with follow-up dates and status.
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
Pricing step by step: materials, labor, overhead, wholesale, retail and consignment, with the worked candle example
A one-product pricing worksheet and a price list for your whole line, to fill in by hand
Setting terms: opening minimums, case packs, per-product minimums, payment, lead time, shipping
Wholesale or consignment, side by side, a consignment agreement checklist and a consignment inventory log
What goes on a line sheet, a checklist before you send it, a pitch email outline and a follow-up tracker
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).
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.