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

Input Template Sheet	Attribute	Mode of Transport	Product	Bill of Material	Supplier	Production	Warehouse	Customer	Location	Period
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
Supplier	Minimum Capacity				x				x	x
Supplier	Maximum Capacity				x				x	x
Supplier	Variable Cost				x				x	x
Supplier	Variable Cost is for all steps				x				x	x
Supplier	Open as Group									x
Supplier	Limit Openings									x
Supplier	Maximum Openings									x
Supplier	Limit Closings									x
Supplier	Maximum Closings									x
Supplier	Minimum # of Open Suppliers				x				x	x
Supplier	Maximum # of Open Suppliers				x				x	x
Supplier Product	Minimum Capacity		x		x				x	x
Supplier Product	Maximum Capacity		x		x				x	x
Supplier Product	Variable Cost		x		x				x	x
Supplier Product	Variable Cost is for all steps		x		x				x	x
Supplier Product	Force Open		x		x				x	x
Supplier Product	Open as Group									x
Supplier Ratio	Minimum Ratio		x		x				x	x
Supplier Ratio	Maximum Ratio		x		x				x	x
Production	Minimum Capacity					x			x	x
Production	Maximum Capacity					x			x	x
Production	Variable Cost					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
Production Routing	Minimum Capacity			x		x			x	x
Production Routing	Maximum Capacity			x		x			x	x
Production Routing	BOM Variable Cost			x		x			x	x
Production Routing	Force Open			x		x			x	x
Production Routing	Open as Group									x
Production Routing Ratio	Minimum Ratio			x		x			x	x
Production Routing Ratio	Maximum Ratio			x		x			x	x
Warehouse	Minimum Capacity						x		x	x
Warehouse	Maximum Capacity						x		x	x
Warehouse	Variable Cost						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
Warehouse Product	Minimum Capacity		x				x		x	x
Warehouse Product	Maximum Capacity		x				x		x	x
Warehouse Product	Variable Cost		x				x		x	x
Warehouse Product	Variable Cost is for all steps		x				x		x	x
Warehouse Product	Force Open		x				x		x	x
Warehouse Product	Open as Group									x
Warehouse Ratio	Minimum Ratio		x				x		x	x
Warehouse Ratio	Maximum Ratio		x				x		x	x
Inventory Product	Minimum Capacity (Inventory)		x
Inventory Product	Maximum Capacity (Inventory)		x
Inventory Product	Variable Cost (Inventory)		x
Inventory Product	Target (Inventory)		x
Transport Cost	Take Or Pay Volume	x	x						x	x
Transport Cost	Take Or Pay Fixed Cost		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	Minimum Capacity	x	x						x	x
Transport Cost	Maximum Capacity	x	x						x	x
Transport Cost	Force Open	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	Cost Per UOM	x	x						x	x
Stepwise Transport Cost	Variable Cost is for all steps	x	x						x	x
Stepwise Transport Cost	Force Open	x	x						x	x
Transport Ratio	Minimum Ratio	x	x						x	x
Transport Ratio	Maximum Ratio	x	x						x	x
Customer Product Data	Minimum Lead Time Adherence		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