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 {}.

Note

Curly bracket grouping for Cost Per Distance and Cost Per Trip is only supported when used together with the Load Consolidation Related Attributes.

Input Template Sheet	Attribute	Period	Product	Resource	Customer	Location	Supplier	Transportation Mode	Bill Of Material
Location Product	Maximum # of Source Locations	x	x			x
Location Product	Maximum # of Destination Locations	x	x			x
Location Product	Minimum # of Open Locations	x	x			x
Location Product	Maximum # of Open Locations	x	x			x
Production Routing	Minimum Capacity	x		x		x			x
Production Routing	Maximum Capacity	x		x		x			x
Production Routing	Force Open	x		x		x			x
Production Routing	BOM Variable Cost	x		x		x			x
Production Routing	Open as Group	x
Production BOM	Minimum Capacity	x		x		x			x
Production BOM	Maximum Capacity	x		x		x			x
Production BOM	Force Open	x		x		x			x
Production BOM	BOM Variable Cost	x		x		x			x
Production BOM	Open as Group	x
Transport Cost	Cost Per Distance		x			x
Transport Cost	Cost Per Trip		x			x
Transport Cost	Minimum Load Size		x			x
Transport Cost	Maximum Load Size		x			x
Transport Cost	Minimum # of Trips		x			x
Transport Cost	Maximum # of Trips		x			x
Transport Cost	Minimum Capacity	x	x			x		x
Transport Cost	Maximum Capacity	x	x			x		x
Transport Cost	Base Case Volume	x	x			x		x
Transport Cost	Base Case Minimum Capacity	x	x			x		x
Transport Cost	Base Case Maximum Capacity	x	x			x		x
Transport Cost	Force Open	x	x			x		x
Transport Cost	Take Or Pay Volume	x	x			x		x
Transport Cost	Take Or Pay Fixed Cost		x
Supplier Product	Variable Cost	x	x			x	x
Supplier Product	Minimum Capacity	x	x			x	x
Supplier Product	Maximum Capacity	x	x			x	x
Supplier Product	Force Open	x	x			x	x
Supplier Product	Variable Cost is for all steps	x	x			x	x
Supplier Product	Open as Group	x
Warehouse Product	Variable Cost	x	x	x		x
Warehouse Product	Minimum Capacity	x	x	x		x
Warehouse Product	Maximum Capacity	x	x	x		x
Warehouse Product	Force Open	x	x	x		x
Warehouse Product	Variable Cost is for all steps	x	x	x		x
Warehouse Product	Open as Group	x
Warehouse Product	Maximum Inventory Cover		x	x		x
Warehouse Product	Minimum Inventory Cover		x	x		x
Inventory Product	Minimum Capacity (Inventory)	x	x	x		x
Inventory Product	Maximum Capacity (Inventory)	x	x	x		x
Inventory Product	Target (Inventory)	x	x	x		x
Inventory Product	Target Violation Cost (Inventory)	x	x	x		x
Inventory Product	Variable Cost (Inventory)		x
Stepwise Transport Cost	Cost Per UOM	x	x			x		x
Stepwise Transport Cost	Minimum Capacity	x	x			x		x
Stepwise Transport Cost	Maximum Capacity	x	x			x		x
Stepwise Transport Cost	Force Open	x	x			x		x
Stepwise Transport Cost	Variable Cost is for all steps	x	x			x		x
Supplier	Variable Cost	x				x	x
Supplier	Minimum Capacity	x				x	x
Supplier	Maximum Capacity	x				x	x
Supplier	Variable Cost is for all steps	x				x	x
Supplier	Open as Group	x
Supplier	Minimum # of Open Suppliers	x				x	x
Supplier	Maximum # of Open Suppliers	x				x	x
Supplier	Limit Openings	x
Supplier	Maximum Openings	x
Supplier	Limit Closings	x
Supplier	Maximum Closings	x
Production	Variable Cost	x		x		x
Production	Minimum Capacity	x		x		x
Production	Maximum Capacity	x		x		x
Production	Variable Cost is for all steps	x		x		x
Production	Open as Group	x
Production	Limit Openings	x				x
Production	Maximum Openings	x				x
Production	Limit Closings	x				x
Production	Maximum Closings	x				x
Production	Minimum # of Open Productions	x		x		x
Production	Maximum # of Open Productions	x		x		x
Warehouse	Variable Cost	x		x		x
Warehouse	Minimum Capacity	x		x		x
Warehouse	Maximum Capacity	x		x		x
Warehouse	Variable Cost is for all steps	x		x		x
Warehouse	Open as Group	x
Warehouse	Limit Openings	x				x
Warehouse	Maximum Openings	x				x
Warehouse	Limit Closings	x				x
Warehouse	Maximum Closings	x				x
Warehouse	Minimum # of Open Warehouses	x		x		x
Warehouse	Maximum # of Open Warehouses	x		x		x
Supplier Ratio	Minimum Ratio	x	x			x	x
Supplier Ratio	Maximum Ratio	x	x			x	x
Warehouse Ratio	Minimum Ratio	x	x	x		x
Warehouse Ratio	Maximum Ratio	x	x	x		x
Production Routing Ratio	Minimum Ratio	x		x		x			x
Production Routing Ratio	Maximum Ratio	x		x		x			x
Transport Ratio	Minimum Ratio	x	x			x		x
Transport Ratio	Maximum Ratio	x	x			x		x
Customer Product Data	Minimum Fulfillment Rate	x	x		x	x
Customer Product Data	Maximum # of Source Locations	x	x		x	x
Customer Product Data	Minimum Lead Time Adherence	x	x		x	x