SimpleSmartSheet
Home › Guides

How to Calculate COGS for Handmade Products

Cost of goods sold (COGS) for a handmade item is what it costs you to make one: the materials it uses, plus packaging, plus your labor if you pay yourself for it.

Start with unit costs

For each supply, divide what you paid by how many units you got. A 10 lb bag of wax at $40 is 160 oz, or $0.25 per ounce.

Unit cost = Price paid ÷ Units in the pack

Add up one item

Multiply each material's unit cost by how much one item uses, then add them up. An 8 oz soy candle:

MaterialUsedUnit costCost
Soy wax8 oz$0.25/oz$2.00
Jar and lid1$1.40$1.40
Fragrance oil0.5 oz$1.30/oz$0.65
Wick1$0.15$0.15
Total COGS$4.20

In a sheet, with quantity used in B and unit cost in C:

=SUMPRODUCT(B2:B5, C2:C5)

Include labor if you want a real margin

If a batch of 12 candles takes 1.5 hours and you value your time at $20 an hour, add $2.50 per candle. Leaving labor out makes your margin look better than it is.

Margin from COGS

Margin = (Price − COGS) ÷ Price

At a $16 price, the candle above has a margin of (16 − 4.20) ÷ 16 = 74% before labor and selling fees.

Skip the setup: Handmade Inventory & COGS Tracker

Track your materials, work out what each item costs and know your margin. Ready to use in Google Sheets and Excel, $6.99.

Get the templateGet every sheet with membership

More free guides