Group Elements in the Data

There are two ways to specify group data in the Excel file with input data, which are handled differently in the model. Assume that we have a product group Cold Storage Products, then you can use this in the Excel file as follows:

1. Cold Storage Products

2. {Cold Storage Products}

If you specify the group element in the first way, then the model will apply the data to all the elements in that group. For instance, if you specify $15 for the attribute Variable Cost and Cold Storage Products, then the model interprets this as the Variable cost is $15 for each product in the group Cold Storage Products.

If you specify the group element in the first way, the model will interpret this in the same way unless that group and attribute are mentioned in the table below.

If a group is specified as {Group} and the group type and attribute are mentioned in the table below, then this value is interpreted as the total for all products in that group. For instance, if you specify the value 150,000 for the attribute Maximum Capacity and {Cold Storage Products}, then the model interprets this as the Maximum Capacity is 150,000 for all products combined in that group.

The following combinations allow for {group} elements. If you specify the brackets {}, but that attribute is not in this table, then SC Navigator will handle this in the same way as without the brackets {}.

Database Table	Attribute	Period	Product	Resource	Customer	Location	Supplier	Transportation Mode	Bill Of Material
ProductLocation	Maximum # of Source Locations	x	x			x
ProductLocation	Maximum # of Destination Locations	x	x			x
ProductLocation	Minimum # of Open Locations	x	x			x
ProductLocation	Maximum # of Open Locations	x	x			x
BillOfResource	Minimum Capacity	x		x		x			x
BillOfResource	Maximum Capacity	x		x		x			x
BillOfResource	Force Open	x		x		x			x
BillOfResource	BOM Variable Cost	x		x		x			x
BillOfResource	Open as Group	x
TransportationTypeProduct	Minimum Capacity	x	x			x		x
TransportationTypeProduct	Maximum Capacity	x	x			x		x
TransportationTypeProduct	Base Case Volume	x	x			x		x
TransportationTypeProduct	Force Open	x	x			x		x
TransportationTypeProduct	Take Or Pay Volume	x	x			x		x
TransportationTypeProduct	Take Or Pay Fixed Cost		x
SupplierProductStep	Variable Cost	x	x			x	x
SupplierProductStep	Minimum Capacity	x	x			x	x
SupplierProductStep	Maximum Capacity	x	x			x	x
SupplierProductStep	Force Open	x	x			x	x
SupplierProductStep	Variable Cost is for all steps	x	x			x	x
SupplierProductStep	Open as Group	x
ResourceProductStep	Variable Cost	x	x	x		x
ResourceProductStep	Minimum Capacity	x	x	x		x
ResourceProductStep	Maximum Capacity	x	x	x		x
ResourceProductStep	Force Open	x	x	x		x
ResourceProductStep	Variable Cost is for all steps	x	x	x		x
ResourceProductStep	Open as Group	x
ResourceProductStep	Minimum Capacity (Inventory)		x
ResourceProductStep	Maximum Capacity (Inventory)		x
ResourceProductStep	Target (Inventory)		x
ResourceProductStep	Variable Cost (Inventory)		x
TransportationTypeProductStep	Cost Per UOM	x	x			x		x
TransportationTypeProductStep	Minimum Capacity	x	x			x		x
TransportationTypeProductStep	Maximum Capacity	x	x			x		x
TransportationTypeProductStep	Force Open	x	x			x		x
TransportationTypeProductStep	Variable Cost is for all steps	x	x			x		x
SupplierStep	Variable Cost	x				x	x
SupplierStep	Minimum Capacity	x				x	x
SupplierStep	Maximum Capacity	x				x	x
SupplierStep	Variable Cost is for all steps	x				x	x
SupplierStep	Open as Group	x
SupplierStep	Minimum # of Open Suppliers	x				x	x
SupplierStep	Maximum # of Open Suppliers	x				x	x
SupplierStep	Limit Openings	x
SupplierStep	Maximum Openings	x
SupplierStep	Limit Closings	x
SupplierStep	Maximum Closings	x
ResourceStep	Variable Cost	x		x		x
ResourceStep	Minimum Capacity	x		x		x
ResourceStep	Maximum Capacity	x		x		x
ResourceStep	Variable Cost is for all steps	x		x		x
ResourceStep	Open as Group	x
ResourceStep	Limit Openings	x				x
ResourceStep	Maximum Openings	x				x
ResourceStep	Limit Closings	x				x
ResourceStep	Maximum Closings	x				x
ResourceStep	Minimum # of Open Productions	x		x		x
ResourceStep	Maximum # of Open Productions	x		x		x
ResourceStep	Minimum # of Open Warehouses	x		x		x
ResourceStep	Maximum # of Open Warehouses	x		x		x
SupplierProductRatio	Minimum Ratio	x	x			x	x
SupplierProductRatio	Maximum Ratio	x	x			x	x
ResourceProductRatio	Minimum Ratio	x	x	x		x
ResourceProductRatio	Maximum Ratio	x	x	x		x
BillOfResourceRatio	Minimum Ratio	x		x		x			x
BillOfResourceRatio	Maximum Ratio	x		x		x			x
TransProductRatio	Minimum Ratio	x	x			x		x
TransProductRatio	Maximum Ratio	x	x			x		x
CustomerProduct	Minimum Fulfillment Rate	x	x		x	x
CustomerProduct	Maximum # of Source Locations	x	x		x	x
CustomerProduct	Minimum Lead Time Adherence	x	x		x	x