Summarized Bills of Material Data Set

The BOM Procedure

Summarized Bills of Material Data Set

If the SUMMARYOUT= option in the PROC BOM statement is specified, the BOM procedure creates a Summarized BOM data set. The summarized bill of material data set lists all the parts and their quantities required and currently on hand. Unlike the indented bill of material data set, it does not list the parent-part relationships and the levels of manufacture, and it lists a part only once for the total quantity used.

The Part, QtyOnHand, and all ID variables in the Single-level BOM data set are carried to this output data set. The name of the Part variable is changed to _Part_. If the item identified by the Part variable is a master schedule item, the value of the Requirement variable (the independent demand) is also carried to this data set. The value of the Requirement variable (dependent demand) for those items that are not master schedule items is determined by the dependent demand process as

$\parbox{1.2in}{{\rm gross requirement of the current item}}=\parbox{1.2in... ...m}} x \parbox{1.2in}{{\rm quantity needed to make 1 unit of parent item}}$

The new variable, Net_Req, denotes the net requirement of the item identified by the Part variable. The value of the Net_Req variable is determined as

Net_Req = Requirement - QtyOnHand

The Low_Code variable denotes the low-level code of the item identified by the Part variable, that is, the lowest level in any bill of material at which the item appears. The low-level codes are necessary to make sure the net requirement of any item is not calculated until all the gross requirements have been calculated down to that level.

Table 1.4 lists all of the variables in the Summarized BOM data set. It also lists the type and a brief description of these variables.

Table 1.4: Summarized BOM Data Set and Associated Variables

Variable	Type	Interpretation
ID	character or numeric	Additional information about the
		part
Low_Code	numeric	Low-level code of the part
Net_Req	numeric	Net requirement of the part
Part	character or numeric	Part name or number
QtyOnHand	numeric	Quantity of the part that is
		currently on hand
Requirement	numeric	Gross requirement of the part

Chapter Contents
Previous
Next
Top