SKU & BOM Builder by CompCode

SKUs & BOMs

New product

Download the BOM workbook

One tab per ticked SKU plus "All materials": total purchase requirement at each SKU's planned quantity.

CCRCM0003
Resin cover, matte
Planned 500 · 3 materials · share by mass
.xlsx Copy BOM
Material Used per unit Scrap % Buy per unit Share % (mass)
Epoxy resin 50 ml+10% scrap 10 0.055 L
Hardener 30 g – 0.03 kg
Glass fibre mat 20 g+5% scrap 5 0.021 kg
CCRCG0002
Resin cover, gloss
Planned 300 · 3 materials · share by mass · copied from CCRCM0003
.xlsx Copy BOM
Material Used per unit Scrap % Buy per unit Share % (mass)
Epoxy resin 50 ml+10% scrap 10 0.055 L
Hardener 30 g – 0.03 kg
Glass fibre mat 20 g+5% scrap 5 0.021 kg
CCMBM0005
Steel bracket
Planned 1000 · 2 materials · share by mass
.xlsx Copy BOM
Material Used per unit Scrap % Buy per unit Share % (mass)
MS sheet 2mm 180 g+8% scrap 8 0.1944 kg
Powder coat 12 g+15% scrap 15 0.0138 kg