If the SUMMARYOUT=
option in the PROC BOM
statement is specified, the BOM procedure creates a Summarized Parts data set. This data set lists all the items with their
quantities required (needed to be made or ordered) in order to fill the production plan specified in the Part Master
data set, taking into account the quantities of these items on hand in the planning period. This data set lists each item
once for the total quantity needed. Each observation in this data set represents one record, which is uniquely identified
by the part number in the _Part_
variable. Each record contains all part master data (from the Part Master
data set) for the item identified by the _Part_
variable. Each record also contains fields for net requirement and low-level code.
The _Part_
variable contains the part number or identification information of the item. The data set has the same LeadTime
, QtyOnHand
, Requirement
, and all ID
variables as in the Part Master
data set. If you do not specify the QTYONHAND=
option, the default name, On_Hand
, is used to name the variable that contains the quantity of the item identified by the _Part_
variable that is currently on hand in the planning period. The default value of this variable is 0, since the procedure assumes
there are no items on hand if the QTYONHAND=
option is not specified. Similarly, if the REQUIREMENT=
option is not specified, the default name Gros_Req
is used to name the variable that contains the value of the gross requirement for the item identified by the _Part_
variable. The values for these variables, except for the variable that contains the gross requirement, are carried from the
Part Master
data set. The gross requirements for all items, except for master schedule items, are determined by the dependent demand
process, which is described later.
The Net_Req
variable contains the value of the net requirement and the Low_Code
variable contains the value of the low-level code for the item identified by the _Part_
variable. The low-level code of an item is the lowest indenture level in any bill of material containing the item. The low-level codes are necessary to make sure that the net requirement of any item is not calculated until all the gross
requirements have been calculated down to that level.
The gross and net requirements for all items are determined in the order of increasing low-level codes. Start at an item with the smallest low-level code (usually 0). If an item c is a master schedule item, the gross requirement for this item is carried from the Part Master data set. Otherwise, it is given by
and the net requirement is determined as
where
This computational process continues for items with larger low-level codes until the values of the gross and net requirements for all components in the Indented BOM data set have been determined. This computational process is known as the dependent demand process.
A summarized parts list should not be confused with a summarized bill of material. As discussed previously, a summarized parts list shows all the items and their quantities required to fill a pre-specified production plan. The gross and net requirements in this list are calculated taking into account the quantity of each item that is available in the planning period. On the other hand, a summarized bill of material for a pre-specified item lists all the components and their total quantities used in making one batch of that item, without any regard for quantities of items on hand. In a special case when the input data do not contain any requirement, quantity on hand, or scrap factor information, and the Indented BOM data set contains only one end item, then the summarized parts list in this data set happens to be the same as the summarized bill of material for the end item.
Table 3.5 lists all the variables in the Summarized Parts data set. It also lists the type and a brief description of these variables.
Table 3.5: Summarized Parts Data Set and Associated Variables
Variable |
Type |
Interpretation |
---|---|---|
|
Character or numeric |
Additional master data for the item |
|
Numeric |
Lead time for the item |
|
Numeric |
Low-level code for the item |
|
Numeric |
Net requirement for the item |
|
Character or numeric |
Part number for the item |
|
Numeric |
Quantity of the item that is currently on hand |
|
Numeric |
Gross requirement for the item |