The BOM Procedure |
This example uses a single input data set for invoking the BOM procedure. It also demonstrates the use of PROC NETDRAW to draw a tree diagram for the indented bill of material contained in the Indented BOM output data set. The input data set, SlBOM1, is depicted in Output 3.1.1. Each observation of this data set contains up to 3 product structure records. It also contains part master data, namely, the part description denoted by the Desc variable and the unit of measure denoted by the Unit variable, for the item identified by the value of the Parent variable. Note that the parent item 'B100' has 4 components, causing the specification to require two observations. The values of the Parent, Desc, and Unit variables for the second observation are missing because they have the same values as the previous observation.
ABC Lamp Company |
PROC BOM Input Data Set |
Parent | Desc | Unit | Comp1 | Comp2 | Comp3 | Qty1 | Qty2 | Qty3 |
---|---|---|---|---|---|---|---|---|
LA01 | Lamp LA | Each | B100 | S100 | A100 | 1 | 1 | 1 |
B100 | Base assembly | Each | 1100 | 1200 | 1300 | 1 | 1 | 1 |
1400 | 4 | . | . | |||||
S100 | Black shade | Each | . | . | . | |||
A100 | Socket assembly | Each | 1500 | 1600 | 1700 | 1 | 1 | 1 |
1100 | Finished shaft | Each | 2100 | 26 | . | . | ||
1200 | 6-Diameter steel plate | Each | . | . | . | |||
1300 | Hub | Each | . | . | . | |||
1400 | 1/4-20 Screw | Each | . | . | . | |||
1500 | Steel holder | Each | 1400 | 2 | . | . | ||
1600 | One-way socket | Each | . | . | . | |||
1700 | Wiring assembly | Each | 2200 | 2300 | 12 | 1 | . | |
2100 | 3/8 Steel tubing | Inches | . | . | . | |||
2200 | 16-Gauge lamp cord | Feet | . | . | . | |||
2300 | Standard plug terminal | Each | . | . | . |
The following code invokes PROC BOM to produce the indented bill of material and the summarized parts list. The indented bill of material is displayed in Output 3.1.2, and the summarized parts list, which has been sorted by the _Part_ variable, is displayed in Output 3.1.3. These are exactly the same as the indented bill of material shown in Figure 3.3 and the summarized parts list shown in Figure 3.5.
/* Create the indented BOM and the summarized parts list */ proc bom data=SlBOM1 out=IndBOM1 summaryout=SumBOM1; structure / part=Parent parent=Parent component=(Comp1-Comp3) quantity=(Qty1-Qty3) id=(Desc Unit); run;
ABC Lamp Company |
Indented Bill of Material, Part LA01 |
_Level_ | _Parent_ | _Part_ | Desc | Qty_Per | Qty_Prod | Unit | Paren_ID | Part_ID | _Prod_ |
---|---|---|---|---|---|---|---|---|---|
0 | LA01 | Lamp LA | . | 1 | Each | . | 0 | LA01 | |
1 | LA01 | B100 | Base assembly | 1 | 1 | Each | 0 | 1 | LA01 |
2 | B100 | 1100 | Finished shaft | 1 | 1 | Each | 1 | 2 | LA01 |
3 | 1100 | 2100 | 3/8 Steel tubing | 26 | 26 | Inches | 2 | 3 | LA01 |
2 | B100 | 1200 | 6-Diameter steel plate | 1 | 1 | Each | 1 | 4 | LA01 |
2 | B100 | 1300 | Hub | 1 | 1 | Each | 1 | 5 | LA01 |
2 | B100 | 1400 | 1/4-20 Screw | 4 | 4 | Each | 1 | 6 | LA01 |
1 | LA01 | S100 | Black shade | 1 | 1 | Each | 0 | 7 | LA01 |
1 | LA01 | A100 | Socket assembly | 1 | 1 | Each | 0 | 8 | LA01 |
2 | A100 | 1500 | Steel holder | 1 | 1 | Each | 8 | 9 | LA01 |
3 | 1500 | 1400 | 1/4-20 Screw | 2 | 2 | Each | 9 | 10 | LA01 |
2 | A100 | 1600 | One-way socket | 1 | 1 | Each | 8 | 11 | LA01 |
2 | A100 | 1700 | Wiring assembly | 1 | 1 | Each | 8 | 12 | LA01 |
3 | 1700 | 2200 | 16-Gauge lamp cord | 12 | 12 | Feet | 12 | 13 | LA01 |
3 | 1700 | 2300 | Standard plug terminal | 1 | 1 | Each | 12 | 14 | LA01 |
ABC Lamp Company |
Summarized Parts List, Period 1 |
_Part_ | Low_Code | Gros_Req | On_Hand | Net_Req | Desc | Unit |
---|---|---|---|---|---|---|
1100 | 2 | 1 | 0 | 1 | Finished shaft | Each |
1200 | 2 | 1 | 0 | 1 | 6-Diameter steel plate | Each |
1300 | 2 | 1 | 0 | 1 | Hub | Each |
1400 | 3 | 6 | 0 | 6 | 1/4-20 Screw | Each |
1500 | 2 | 1 | 0 | 1 | Steel holder | Each |
1600 | 2 | 1 | 0 | 1 | One-way socket | Each |
1700 | 2 | 1 | 0 | 1 | Wiring assembly | Each |
2100 | 3 | 26 | 0 | 26 | 3/8 Steel tubing | Inches |
2200 | 3 | 12 | 0 | 12 | 16-Gauge lamp cord | Feet |
2300 | 3 | 1 | 0 | 1 | Standard plug terminal | Each |
A100 | 1 | 1 | 0 | 1 | Socket assembly | Each |
B100 | 1 | 1 | 0 | 1 | Base assembly | Each |
LA01 | 0 | 1 | 0 | 1 | Lamp LA | Each |
S100 | 1 | 1 | 0 | 1 | Black shade | Each |
As discussed in the section Summarized Parts Data Set, since item 'LA01' is the only master schedule item in this example, and both the quantity on hand and the scrap factor are zero for all items, the summarized parts list displayed in Output 3.1.3 is also the summarized bill of material for item 'LA01'.
The following SAS code uses PROC NETDRAW to draw a family tree diagram displaying the indented bill of material for item 'LA01'. The NETDRAW procedure requires the descriptive information for each node to be associated with the parent node in each observation. However, the Indented BOM data set contains the descriptive (part master) information for the component identified by the _Part_ variable. Thus, the following code prepares the data for PROC NETDRAW. This code first creates two data sets from the Indented BOM data set, IndBOM1. The IndBOM1a data set contains all variables in the Indented BOM data set, except for the Part_ID variable. The Part_ID variable is dropped and its value is copied to the Paren_ID variable. Each record in this data set is represented by a tree node in the diagram, which is uniquely identified by the value of the Paren_ID variable. The other data set, IndBOM1b, contains all parent-component relationships, in which each relationship is identified by the Paren_ID and Part_ID variables. Each observation in this data set is represented by a link in the diagram. These two data sets are concatenated to form the input data set for PROC NETDRAW. The tree diagram for the indented bill of material for item 'LA01' is displayed in Output 3.1.4. For further details about the NETDRAW procedure, refer to Chapter 7, The NETDRAW Procedure (SAS/OR 9.22 User's Guide: Project Management).
/* Draw a tree diagram for illustrating the product structure */ /* Each record denotes a node in the tree */ data IndBOM1a(drop=Part_ID); set IndBOM1; Paren_ID=Part_ID; run; /* Extract the Parent - Part information */ data IndBOM1b; set IndBOM1(keep=Paren_ID Part_ID); run; /* Prepare the data set for running NETDRAW */ data TreBOM1; set IndBOM1a IndBOM1b; run; /* Specify graphics options */ goptions hpos=32 vpos=80 border; pattern1 v=s c=blue; title h=5 j=c 'Multilevel Bill of Material Diagram'; footnote h=2 j=l 'Node shows ID Number, Part Number, and Quantity Required';
/* Invoke PROC NETDRAW to display BOM tree */ proc netdraw data=TreBOM1( where=(Paren_ID NE .) ) out=NetOUT; actnet / act=Paren_ID succ=Part_ID id=(Paren_ID _Part_ Qty_Per) ctext=white font=swiss htext=3 carcs=black ybetween=3 xbetween=8 centerid tree pcompress rotatetext rotate arrowhead=0 rectilinear nodefid nolabel; run;
Copyright © SAS Institute, Inc. All Rights Reserved.