Standardize the terms used in the Bill of Materials (BOM) to make it clearer how many items are required for the build and the quantity that needs to be purchased. Ideally want to use standard terms that people are already familiar with or will match whatever supplier they are trying to order from.
Quantities
QTY / Device -> Items per Unit - Number of items required to build one finished unit
- From design (e.g., how many screws per device)
QTY / PKG -> Items per Package - Number of items contained in one purchased package
- From particular supplier (e.g., how may screws per box)
PKGs -> Packages Required - Number of packages needed to satisfy the required quantity (rounded up)
- Calculated based on Items per Unit and Items per Package (e.g., how many boxes of screws)
=CEILING(Qty per Unit / Items per Package)
Costs
$ / PKG -> Cost per Package - Purchase cost for one package
- From particular supplier (e.g., cost per box of screws)
-> Item Cost - Cost of individual item
- Calculated based on Items per Package and Cost Per Package
= Cost per Package / Items per Package
$ / device -> Cost per Unit (Consumed) - Cost of the actual quantity used in one device (based on per-item cost, not package rounding)
- Calculated from Cost per package and Items per Unit
= Items per Unit x Unit Cost
Total Estimated Cost -> Extended Purchase Cost - Total cost based on packages purchased
- Calculated based on Packages Required and Cost per Package
= Packages Required x Cost per Package
Unit of Measure
e.g., each, pack, meter, kg
Should also make it clearer which of these are design dependent and which are supplier dependent to make it easier to adjust and update when suppliers change.
Standardize the terms used in the Bill of Materials (BOM) to make it clearer how many items are required for the build and the quantity that needs to be purchased. Ideally want to use standard terms that people are already familiar with or will match whatever supplier they are trying to order from.
Quantities
QTY / Device -> Items per Unit - Number of items required to build one finished unit
QTY / PKG -> Items per Package - Number of items contained in one purchased package
PKGs -> Packages Required - Number of packages needed to satisfy the required quantity (rounded up)
Costs
$ / PKG -> Cost per Package - Purchase cost for one package
-> Item Cost - Cost of individual item
$ / device -> Cost per Unit (Consumed) - Cost of the actual quantity used in one device (based on per-item cost, not package rounding)
Total Estimated Cost -> Extended Purchase Cost - Total cost based on packages purchased
Unit of Measure
e.g., each, pack, meter, kg
Should also make it clearer which of these are design dependent and which are supplier dependent to make it easier to adjust and update when suppliers change.