Skip to content
Free tool - no sign-up

BOM calculator: what a run needs, what to buy and what it costs.

Paste the bill of materials for one finished unit and enter how many you are making. The page works out the material the run needs with scrap, what is short against what you have on hand, and the material cost. Print the list or download it as a CSV. It runs in your browser: nothing is uploaded.

1. What you are making
How many finished units this run makes.
2. What goes into one unit
Order: Component, Part no., Qty per unit, Unit, Unit cost, Scrap %, On hand. The quantity is for ONE finished unit. Paste straight from a spreadsheet or type with commas. A blank scrap % or on hand counts as 0.
7 components
3. What the run needs
Material per unit
$140.59
Material for 12 units
$1,728.07
To buy for the run
$985.41
Lines short
4 of 7

To save a PDF, choose Save as PDF as the printer in the print dialog. Nothing is uploaded: the list and the file are made in this browser tab, and it keeps nothing when you close it.

Material list (this is what prints)

Swipe the list sideways to see every column.

Base cabinet 24 in
Run of 12 units
MATERIAL LIST
Scrap included, rounded up to whole units
#ComponentPer unitScrapNeededOn handTo buyUnit costCost of runCost to buy
1
Birch plywood 3/4 in 4x8
PLY-B34
1.5 sheet10%20812$68.50$1,370.00$822.00
2
Plywood 1/4 in 4x8 (back)
PLY-B14
0.25 sheet5%422$32.00$128.00$64.00
3
Edge banding 15/16 in
EB-1516W
14 ft15%1943000$0.12$23.28$0.00
4
Hinge soft-close 110 deg
HW-1102
2 ea0%24300$2.15$51.60$0.00
5
Drawer slide 18 in
HW-DS18
1 pair0%1248$11.80$141.60$94.40
6
Shelf pin 5 mm
HW-SP5
4 ea5%515000$0.08$4.08$0.00
7
Screw #8 x 1-1/4 in
FS-8114
24 ea10%317150167$0.03$9.51$5.01
Needed = quantity per unit x units to make x (1 + scrap %), rounded up to a whole unit. To buy = needed - on hand.
Material per unit$140.59
Material for the run$1,728.07
To buy for the run$985.41
Free BOM calculator - inventoryquick.com/tools/bom-calculator

What a bill of materials lists

A bill of materials (BOM) is the recipe for one finished unit. Each line is one component:

  1. Component. What it is, in words someone at the bench would recognise.
  2. Part number. Your part number or SKU, so the list matches your stock and your purchase orders.
  3. Quantity per unit. How much ONE finished unit uses, in the unit you buy it in: 1.5 sheets, 14 ft, 24 screws.
  4. Unit and unit cost. Sheet, ft, each, pair, and what you pay for one of it.
  5. Scrap %. Extra to allow for offcuts, saw kerf and mistakes. 10% on 1.5 sheets is 1.65 sheets a unit.
  6. On hand. What you have now, so the page can tell you what to buy. Leave it blank for none.

When a product has sub-assemblies, such as a drawer box that goes into a cabinet, work the sub-assembly out on its own first, then put it on the product's list as one component at its material cost.

How the run is worked out

  • needed = quantity per unit x units to make x (1 + scrap % / 100), rounded up to a whole unit when Round up is ticked
  • to buy = needed - on hand (never below 0)
  • material per finished unit = sum of quantity per unit x (1 + scrap % / 100) x unit cost
  • cost of the run = sum of needed x unit cost (each line rounded to the cent)
  • cost to buy = sum of to buy x unit cost (each line rounded to the cent)

Worked example, with the 24 in base cabinet the page loads, making 12. Each cabinet takes 1.5 sheets of 3/4 in birch plywood, so 12 take 18 sheets. With 10% scrap that is 19.8, rounded up to 20. There are 8 on hand, so 12 are short, and 12 sheets at 68.50 is 822.00. The 24 screws a cabinet come to 288, 316.8 with scrap, so 317; with 150 on hand, 167 are short at 0.03, which is 5.01. Add the 1/4 in back panels (2 short, 64.00) and the drawer slides (8 pairs short, 94.40), and the material to buy comes to 985.41. The hinges, shelf pins and edge banding are covered by what is on hand.

Material per finished cabinet is 140.59, and the material for the run is 1,728.07. Untick Round up to whole units and the run comes to 1,687.01: the 41.06 between them is mostly the part of a sheet you buy but do not use on this run, and it is left over for the next one.

A line with no quantity per unit, or a scrap % or on-hand figure that is not a number, is listed but not worked out, and the page tells you how many there are. A line with no unit cost is counted in the quantities but not in the costs. To decide when to reorder what you use on every run, use the reorder point calculator.

Scrap and yield are not the same number

Scrap is added on top of what the product uses. Yield is the share of what you buy that ends up in the product. 10% scrap on 18 sheets is 19.8 sheets, but a 90% yield on 18 sheets is 18 / 0.9 = 20 sheets. If you know your yield, turn it into scrap before you enter it: scrap % = (100 / yield % - 1) x 100, so a 90% yield is 11.1% scrap.

The scrap figure that matters is your own. Compare what the last few jobs actually used with what the list said, line by line. Sheet goods and anything cut to length usually lose more than hardware that is counted out one at a time.

Bills of materials and work orders in InventoryQuick

There is no saved or multi-level bill of materials in InventoryQuick. What the Enterprise plan has is the work order: one per job, carrying its own list of items and quantities.

  • Enterprise only: work orders, and importing a cutlist into one, are on the Enterprise plan. Starter, Pro and Business do not have them.
  • One list per job: each line is an item already in InventoryQuick and a whole-number quantity. Add the lines by hand, or import a cutlist from an Excel or CSV file as one work order.
  • Stock set aside: adding a line reserves that stock against the job, and open work orders count as committed demand in the forecast.
  • Using it up: logging what the job used takes that stock off the item. InventoryQuick refuses to use more than is on hand.
  • Short before you start: when your open and in-progress work orders together still need more of an item than you have, each one that still needs it shows as blocked by stock on the alerts page, with how much they need between them, how much you have and how many you are short.

Enterprise is $349/mo, with every user included. Every plan starts with a 7-day free trial, and you won't be charged for 7 days. On the web you pick a plan and enter a card.

Frequently asked questions

Is the BOM calculator free?

Yes. There is no sign-up and no email is asked for. The material list and the CSV are made in your browser. What you paste is not sent to InventoryQuick and it is not stored.

What is a bill of materials?

A list of everything that goes into one finished product: each component, how much one unit uses and the unit it is bought in, usually with a part number, a unit cost and an allowance for scrap. Multiply it by the number of units in a run and you have the material the run needs.

What is the difference between scrap and yield?

Scrap is extra added on top of what the product uses: 10% scrap on 18 sheets is 19.8 sheets. Yield is the share of the material that ends up in the product: at a 90% yield, 18 sheets of product take 18 / 0.9 = 20 sheets. To enter a yield here, turn it into scrap with (100 / yield - 1) x 100. A 90% yield is 11.1% scrap.

How do I handle sub-assemblies?

Work the sub-assembly out on its own first: paste its list, enter how many you need, and note the material cost per unit. Then put it on the finished product’s list as one component at that cost. The calculator works one level at a time.

Why round up to whole units?

You buy plywood by the sheet and drawer slides by the pair, so 19.8 sheets is 20 sheets at the supplier. In the example, rounding up takes the material for the run from $1,687.01 to $1,728.07. The difference is material you buy but do not use on this run, so it is left over for the next one. Untick Round up to whole units to see the exact amounts.

What is the difference between the cost per unit and the cost of the run?

Material per finished unit is what one product uses, scrap included, at your unit costs. The cost of the run is what the material for the whole run costs once each amount is rounded up to what you can buy, so it is usually a little more than the cost per unit times the number of units. Neither includes labour or overhead.

Can I keep bills of materials in InventoryQuick?

No. There is no saved or multi-level bill of materials. On the Enterprise plan, each work order carries its own list of items and whole-number quantities for that job, added by hand or imported from a cutlist. If you need reusable or nested BOMs, Katana, MRPeasy and Fishbowl are built for that.

More free tools: reorder point calculator, safety stock calculator, EOQ calculator, item label maker.