Missing one component in your costing — a screw, a box, a bag of packaging — is enough to quietly wipe out a product’s margin, which is exactly the gap this free Notion Bill of Materials template closes by building products as “assemblies” instead of flat, disconnected line items.
What’s inside:
- An assembly builder where you define exactly which components (legs, screws, boxes, etc.) make up one finished unit, and in what quantity
- Automatic cost rollups that total material cost per product based on its linked components
- A margin analysis view comparing sales price against material cost to surface true gross profit per item
- Supplier tagging on each component so you know at a glance who supplies the wood versus who supplies the hardware
Who it’s for: Small manufacturers and makers who price products by hand and need their component costs to roll up automatically instead of re-adding a spreadsheet every time a supplier price changes.
Why we picked it: Most costing templates are just a list of line items with a manual sum at the bottom. This one models real assembly structure — quantity-per-unit logic that recalculates the whole product cost the moment one component’s price shifts — which is a meaningfully different (and more durable) approach than a static spreadsheet.
Creator credit: Built by Pika, and we’ve linked back to their original template page so you can duplicate it directly from the source.