Comprehensive Tools for Bill-of-Material Processing
The BOM procedure performs bill-of-material processing. It reads all product structure records from a product structure data file and all part "master" records from a part master file, and composes the combined information into indented bills of material.
The output of PROC BOM can be viewed in a variety of formats. The simplest format is the single-level bill of material. It consists of a list of all components that are directly used in a parent item. It shows only the relationships one level down. On the other hand, a multilevel bill of material provides a display of all components that are directly or indirectly used in a parent item. When an item is a subcomponent, blend, intermediate, etc., then all of its components are also exhibited, down to purchased parts and raw materials. In the multilevel option, one can choose the indented or the summarized version.
Input data
-
The Product Structure data set contains all product structure records.
- The Part Master data set contains all part master records for a product, product line, plant, or company.
Output data
PROC BOM generates single-level, Indented BOM or Summarized parts output data according to the option chosen. This data set is organized in such a manner that it can be easily retrieved and manipulated to generate reports, and can also be used by other SAS procedures to perform additional analysis.
Bill-of-Material Post-Processing Macros
In addition to PROC BOM, there is a collection of SAS macros that uses the Indented BOM data set as input data to create reports or perform specialized transactions for maintaining the bills of material. Based on their functionality they are broadly classified as "Reporting" macros and "Transactional" macros.
The reports generated by "Reporting" macros include
-
single-level bill of material
-
single-level where-used list
-
indented bill of material
-
indented where-used list
-
summarized bill of material
- summarized where-used list.
Some of the specialized transactions available through "Transactional" macros include
-
copy-and-paste
-
multiple-delete
-
multiple-replace
- same-as-except.
If used correctly these macros can go a long way in simplyfying the process of updating the bills of material for a product, product line, plant, or company.
Statistics and Operations Research Home Page | Operations Research