The CSV below is a pricing sheet for your 8 oz soy candle and beaded earrings. It covers settings, materials, packaging, labor, overhead, suggested wholesale and retail prices, Etsy fees, profit, break-even and your competitor price ranges. To open it, copy everything in the block into a text file saved as pricing.csv, or paste it into Google Sheets with File > Import.
Product,Section,Item,Purchase Price,Purchase Quantity,Purchase Unit,Amount Used Per Item,Cost Per Item,Notes
ALL,Settings,Currency,,,,,,USD
ALL,Settings,Hourly Labor Rate,,,,,20.00,Your stated rate of $20/hr
ALL,Settings,Monthly Overhead Total,,,,,164.00,Studio share 100.00 + Shopify plan 39.00 + tools and misc 25.00
ALL,Settings,Items Made Per Month,,,,,160,Your estimate
ALL,Settings,Overhead Per Item,,,,,1.03,164.00 / 160 = 1.025 rounded to 1.03
ALL,Settings,Wholesale Multiplier,,,,,2,Wholesale = Cost of Goods x 2 (standard handmade formula)
ALL,Settings,Retail Multiplier,,,,,2,Retail = Wholesale x 2. Suggested prices rounded UP to the next whole dollar
ALL,Settings,Etsy Listing Fee,,,,,0.20,Per item sold. Etsy standard fees as of 2026 (verify current fees)
ALL,Settings,Etsy Transaction Fee (%),,,,,6.5,6.5% of sale price plus any shipping charged to the buyer. Etsy 2026 (verify current fees)
ALL,Settings,Etsy Payment Processing,,,,,0.25,US rate 3% of sale + 0.25 per order. Etsy 2026 (verify current fees). Optional Offsite Ads fees are not included
8 oz Soy Candle,Materials,Soy wax,32.00,160,oz,7,1.40,10 lb bag converted to oz (10 x 16 = 160 oz). 32.00 / 160 = 0.20 per oz x 7 oz
8 oz Soy Candle,Materials,Fragrance oil,28.00,16,oz,0.6,1.05,28.00 / 16 = 1.75 per oz x 0.6 oz
8 oz Soy Candle,Materials,Cotton wick,9.00,100,wicks,1,0.09,9.00 / 100 = 0.09 each
8 oz Soy Candle,Materials,8 oz tin,30.00,24,tins,1,1.25,30.00 / 24 = 1.25 each
8 oz Soy Candle,Packaging,Printed label,6.00,30,labels,1,0.20,"ASSUMPTION: read ""30 per sheet pack $6"" as 30 labels for 6.00. If the pack has several sheets, your cost is lower"
8 oz Soy Candle,Packaging,Shipping box and padding,1.10,1,order,1,1.10,ASSUMPTION: one candle per order. Postage is not included. Skip this cost for fair and wholesale sales
8 oz Soy Candle,Labor,Pouring and cleanup,,,,,5.00,Batch of 12 takes 180 min. 180 / 12 = 15 min per candle. 15 / 60 x 20.00 = 5.00
8 oz Soy Candle,Overhead,Overhead share,,,,,1.03,From Settings
8 oz Soy Candle,Summary,Total Materials,,,,,3.79,1.40 + 1.05 + 0.09 + 1.25
8 oz Soy Candle,Summary,Total Packaging,,,,,1.30,0.20 + 1.10
8 oz Soy Candle,Summary,Total Labor,,,,,5.00,
8 oz Soy Candle,Summary,Total Overhead,,,,,1.03,
8 oz Soy Candle,Summary,Cost of Goods (all of the above),,,,,11.12,3.79 + 1.30 + 5.00 + 1.03
8 oz Soy Candle,Summary,Suggested Wholesale Price,,,,,23.00,Unrounded 22.24 (11.12 x 2). This is the price to quote gift shops
8 oz Soy Candle,Summary,Suggested Retail Price,,,,,45.00,"Unrounded 44.48 (22.24 x 2). This is far above the 18-24 competitor range. A realistic option is to sell on Etsy at about 24.00, which still pays your labor (see below)"
8 oz Soy Candle,Summary,Est. Platform/Payment Fees at Retail,,,,,4.73,Etsy fees on 45.00: 0.20 + 2.93 (6.5%) + 1.35 (3%) + 0.25
8 oz Soy Candle,Summary,Net Profit per Retail Sale,,,,,29.15,45.00 - 11.12 - 4.73. This is profit after your 5.00 labor pay
8 oz Soy Candle,Summary,Profit Margin at Retail (%),,,,,64.78,29.15 / 45.00
8 oz Soy Candle,Summary,Break-even Price,,,,,12.78,(11.12 + 0.45 fixed fees) / (1 - 0.095). Covers labor but leaves no extra profit
8 oz Soy Candle,Summary,Competitor/Current Price,,,,,21.00,Midpoint of your 18-24 Etsy range
8 oz Soy Candle,Summary,Net Profit at Competitor/Current Price,,,,,7.43,21.00 - 11.12 - 2.45 fees. At 18.00 the profit is 4.72 and at 24.00 it is 10.15
Beaded Earrings,Materials,Glass seed beads,4.50,1,tube,0.125,0.56,4.50 x 1/8 tube = 0.5625 rounded to 0.56
Beaded Earrings,Materials,Sterling ear wires,16.00,20,pairs,1,0.80,16.00 / 20 = 0.80 per pair
Beaded Earrings,Materials,Jump rings,5.00,200,rings,4,0.10,5.00 / 200 = 0.025 each x 4
Beaded Earrings,Packaging,Earring card,7.00,50,cards,1,0.14,7.00 / 50 = 0.14 each
Beaded Earrings,Packaging,Shipping box and padding,1.10,1,order,1,1.10,ASSUMPTION: one pair per order. Postage is not included. Skip this cost for fair and wholesale sales
Beaded Earrings,Labor,Beading and assembly,,,,,8.33,25 min per pair. 25 / 60 x 20.00 = 8.333 rounded to 8.33
Beaded Earrings,Overhead,Overhead share,,,,,1.03,From Settings
Beaded Earrings,Summary,Total Materials,,,,,1.46,0.56 + 0.80 + 0.10
Beaded Earrings,Summary,Total Packaging,,,,,1.24,0.14 + 1.10
Beaded Earrings,Summary,Total Labor,,,,,8.33,
Beaded Earrings,Summary,Total Overhead,,,,,1.03,
Beaded Earrings,Summary,Cost of Goods (all of the above),,,,,12.06,1.46 + 1.24 + 8.33 + 1.03
Beaded Earrings,Summary,Suggested Wholesale Price,,,,,25.00,Unrounded 24.12 (12.06 x 2). This is the price to quote gift shops
Beaded Earrings,Summary,Suggested Retail Price,,,,,49.00,"Unrounded 48.24 (24.12 x 2). This is above the 22-30 competitor range. A realistic option is about 30.00 on Etsy, or cut your time per pair by working in batches"
Beaded Earrings,Summary,Est. Platform/Payment Fees at Retail,,,,,5.11,Etsy fees on 49.00: 0.20 + 3.19 (6.5%) + 1.47 (3%) + 0.25
Beaded Earrings,Summary,Net Profit per Retail Sale,,,,,31.83,49.00 - 12.06 - 5.11. This is profit after your 8.33 labor pay
Beaded Earrings,Summary,Profit Margin at Retail (%),,,,,64.96,31.83 / 49.00
Beaded Earrings,Summary,Break-even Price,,,,,13.82,(12.06 + 0.45 fixed fees) / (1 - 0.095). Covers labor but leaves no extra profit
Beaded Earrings,Summary,Competitor/Current Price,,,,,26.00,Midpoint of your 22-30 Etsy range
Beaded Earrings,Summary,Net Profit at Competitor/Current Price,,,,,11.02,26.00 - 12.06 - 2.92 fees. At 22.00 the profit is 7.40 and at 30.00 it is 14.64
ALL,Notes,Fees on shipping,,,,,,"Etsy also takes 6.5% + 3% of any shipping you charge buyers. Postage is not in this sheet, so add it if you offe