Modeling bills of material
A bill of material (BOM) is a list of raw materials (components), byproducts, and end products that can be used when producing a product. The BOM effectively converts one or more components into an end product and optional byproducts. You define the BOM in the Bills Of Material table.
When defining a bill of material, you create a record in the Bills Of Material table for each component, byproduct and end product that makes up the BOM. For each product within the BOM, you specify the Type and the Quantity. The set of records is linked together based on a common Name value. All rows with the same BOM Name are collected and generated as a single bill of material. Therefore, you must use the same Name for all records that make up a single BOM.
Before creating the BOM, you must define all products (components, byproducts and end products) in the Products table.
You set up period - site - product - BOM relationships in the Bill Of Material Assignments table. Bills of material are selected based on the Assignment Policy and associated Policy Parameter.
BOM example
In the following example, a series of components are assembled to make a cell phone using a bill of material. As part of the process, there is scrap produced as a byproduct. The phone is assembled at the MFG site, the components are provided from the SUPPLIER. Therefore, you will define Products, Bills Of Material records, Bill Of Material Assignments records, Production Policies, Site Sourcing Policies and Transportation Policies to create the complete structure:
Products table
Name |
Phone |
Chassis |
Memory |
Processor |
Screen |
Scrap |
Bills Of Material table
Name | Product | Quantity | Type |
Assemble Phone | Chassis | 1 | Component |
Assemble Phone | Memory | 2 | Component |
Assemble Phone | Processor | 1 | Component |
Assemble Phone | Screen | 1 | Component |
Assemble Phone | Scrap | 0.2 | Byproduct |
Note that all records for the BOM have the same Name. Also note that the Quantity does not have to be an integer.
Bill Of Material Assignments table
Period Name | Site | Product | BOM |
(ALL_Periods) | MFG | Phone | Assemble Phone |
Production Policies table
Site Name | Product | Production Policy |
MFG | Phone | Make |
Supplier | Chassis | Make |
Supplier | Memory | Make |
Supplier | Processor | Make |
Supplier | Screen | Make |
Site Sourcing Policies table
Source Name | Site Name | Product | Sourcing Policy |
SUPPLIER | MFG | Chassis | Single Source |
SUPPLIER | MFG | Memory | Single Source |
SUPPLIER | MFG | Processor | Single Source |
SUPPLIER | MFG | Screen | Single Source |
Transportation Policies table
Source Site | Destination Site | Product Name |
SUPPLIER | MFG | Chassis |
SUPPLIER | MFG | Memory |
SUPPLIER | MFG | Processor |
SUPPLIER | MFG | Screen |
Last modified: Friday May 12, 2023