Replace the example rows with your own materials, quantities, and costs.
finished units
MaterialQty / batch ?I paid ($)I boughtCost / unit made
Labour
Packaging goes in the materials list above, as its own line - it's a material too. Labour is the one cost that isn't, so it gets worked out from your time and rate instead of a number you'd have to already know. Uses the batch size set above to split the cost across each unit.
Labour cost per unit: $0.00
True cost per unit
$0.00
Materials (including packaging) + labour, for one finished unit
Get the Excel template
The same BOM structure as this calculator, as an Excel file with formulas built in. One sheet per product.