Template-Attributes

In this section you can read about the different attributes: what effects they have and how to use them. On the different sheets of the Excel you can find a lot of types of attributes, some of them are cost related or opening/closing decisions.

Optimization Parameters and Constraints

Time Limit

Sheets on which it appears: Settings
Possible inputs: any number greater than 0 (in hours)
How it affects the model: The time limit of the optimization run measured in hours. If not specified, the model uses 1 hour

Optimality Gap

Sheets on which it appears: Settings
Possible inputs: number between 0 and 100 (in percentage), the smaller the optimality gap, the better the solution
How it affects the model: The optimization engine stops when a solution is found which is within this percentage of the best possible solution. The default is 0.01(%) when using Single Source and 0.001(%) otherwise.

Maximum # of Source Locations

Sheets on which it appears: Location Product, Customer Product Data
Possible inputs: Positive integers
How it affects the model: On Location Product sheet for locations where there is a Warehouse or a Production facility: The maximum number of source location per product and period that can serve a warehouse/production facility. For example if the maximum number of source locations is 10 for a warehouse location, then the inbound volume can only come from 10 different locations, which can be supplier, warehouse or production facility.
On Customer Product data sheet for customer locations: The maximum number of source locations per product and period that can serve the Customer. For example if the maximum number of source locations is 10 for a customer location, then the inbound volume can only come from 10 different locations, which can be supplier, warehouse or production facility.

Maximum # of Destination Locations

Sheets on which it appears: Location Product
Possible inputs: Positive integers
How it affects the model: The maximum number of destination location per product and period that the supplier/warehouse/production facility can serve. For example if the maximum number of destination locations is 10 for a warehouse location, then only 10 different location (Warehouse/Production/Customer) can receive product from that location.

Available

Sheets on which it appears: Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Transport Cost, Stepwise Transport Cost
Possible inputs: Binary: 1 or 0 (empty)
How it affects the model: To indicate that the Supplier, Warehouse, Production…etc., can be used by the model. Only Available without Force Open does not necessarily mean that the minimum and maximum capacity will be considered, in other words the constraint will be conditional. If both Available and Force Open attributes are defined then the constraints must be met.
For example, if the Warehouse has minimum capacity (10000) and it is only Available and not Force Open, the inbound/outbound of the warehouse can be less than the minimum capacity (e.g.:5000) and the model will be feasible. But if the Warehouse is available and force open the inbound/outbound of the warehouse can not be less than the minimum capacity or the model is infeasible.
Objects with {Curly Bracket} does not need Available attribute if single elements of the group have Available attribute.

Product Related Attributes:

IsSKU

If there is a demand for the product, you must enter a 1 in the IsSKU column, otherwise the application will not treat it as a product.

IsUnion

In the InUnion column we identify the product groups to create the groups.

IsIntersection

The IsIntersection column is currently not in use. It is worth leaving empty.

SubProduct

In the SubProduct column can be used to specify element of a product group.

UOM

In the UOM column you can specify the unit with which a product is measured. The default/base UOM is used in all sheets that do not contain a UOM column.

UOM Equivalent

In the UOM Equivalent column, you can specify how many base units will fit into the new unit.

If the base unit is kg.

Product	UOM	UOM Equivalent
Product 1	tons	1000

If the base unit is tons.

Product	UOM	UOM Equivalent
Product 1	kg	0.001

Cost Related Attributes

Fixed Cost

Sheets on which it appears: Location Period, Supplier, Supplier Product, Production, Warehouse, Warehouse Product
Possible inputs: any number equal or greater than 0
How it affects the model: Fixed Cost is independent of the inbound or outbound volume. Fixed Cost remains the same no matter how much the volume is.

Variable Cost

Sheets on which it appears: Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Customer Product Data
Possible inputs: any number equal or greater than 0
How it affects the model: Variable Cost depends on the volume of Supplier/Warehouse/Production. For example if the variable cost of a supplier is 10 and volume is 200, the total variable cost for the supplier will be 200*10=2000.
There are 2 models for variable cost: Incremental and All Steps (see below). In the incremental model each capacity steps has its own variable cost:

Step	Minimum Capacity	Maximum Capacity	Variable Cost
1	0	100	10
2	100	500	20
3	500	1000	30

If the actual flow is 1000 the total variable cost with the Incremental model: 100*10+(500-100)*20+(1000-500)*30=100*10+400*20+500*30=1000+8000+15000=24000.

Variable Cost for all steps

Sheets on which it appears: Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Stepwise Transport Cost
Possible inputs: binary (0 or 1), it should be 1 for all steps if you want to use this model.
How it affects the model: Variable Cost depends on the volume of Supplier/Warehouse/Production. There are 2 models for variable cost: Incremental (see above) and All Steps. This attribute indicates if the variable cost of the last step in use is applied for all units in all steps. It should be 1 for all steps (except the first) if you want to use the All Steps model.
In the “All Steps” costing model all capacity step has a common variable cost, that is the cost of the last used step. On the Stepwise Transport Cost sheet the attribute works with the same logic for Cost Per UOM.

Step	Minimum Capacity	Maximum Capacity	Variable Cost	Variable Cost for all steps
1	0	100	10	1
2	100	500	20	1
3	500	1000	30	1

If the actual flow is 1000 the total variable cost with the All Steps model: 1000*30=30000

Closing Cost

Sheets on which it appears: Supplier, Supplier Product, Production,Warehouse, Warehouse Product
Possible inputs: any number equal or greater than 0
How it affects the model: The cost of closing the Supplier/Warehouse/Production. If the Supplier/Warehouse/Production has closing cost in the given period and for the given period it is true that the Supplier/Warehouse/Production is opened in the previous period but in the given period is closed, then the closing cost will be added to the total cost of the Supplier/Warehouse/Production.
For example if the supplier has closing cost (10) in period 2 and in “period 1” the supplier is opened but in “period 2” the supplier is closed, then the closing cost for the supplier will be 10.

Opening Cost

Sheets on which it appears: Supplier, Supplier Product, Production, Warehouse, Warehouse Product
Possible inputs:any number equal or greater than 0
How it affects the model: The cost of opening the Supplier/Warehouse/Production. If the Supplier/Warehouse/Production has opening cost in the given period and for the given period it is true that the Supplier/Warehouse/Production is closed in the previous period but in the given period is open, then the opening cost will be added to the total cost of the Supplier/Warehouse/Production.
For example if the supplier has opening cost (10) in period 2 and in “period 1” the supplier is closed but in “period 2” the supplier is opened, then the opening cost for the supplier will be 10.

Open/Close Related Attributes

Force Open

Sheets on which it appears: Location Period, Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Transport Cost, Stepwise Transport Cost
Possible inputs: binary (0 (empty) or 1)
How it affects the model: Indicates if the Supplier, Warehouse, Production, Inventory…etc. must be opened. The minimum and maximum constraints depend on the Force Open attribute. If the Force Open attribute is 1 then the constraints must be met but if the attribute is 0 then the constraints are just conditional.
For example, if the Warehouse has minimum capacity (10000) and it is only Available and not Force Open, the inbound/outbound of the warehouse can be less than the minimum capacity (e.g.:5000) and the model will be feasible. But if the Warehouse is available and force open the inbound/outbound of the warehouse can not be less than the minimum capacity or the model is infeasible.

Force Close

Sheets on which it appears: Location Period, Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Transport Cost, Stepwise Transport Cost
Possible inputs:binary (0 (empty) or 1)
How it affects the model: Indicates if the Supplier, Warehouse, Production, Inventory…etc. must be closed.

Limit Openings

Sheets on which it appears: Supplier, Production, Warehouse
Possible inputs: binary (0 or 1), it should be defined for a period group
How it affects the model: Indicates whether the supplier/warehouse/production can be set to open at a location in a given period group. It should be defined for a period group.

Maximum Openings

Sheets on which it appears: Supplier, Production, Warehouse
Possible inputs:any number equal or greater than 0, it should be defined for a period group
How it affects the model: Limit how many times the model can open a supplier/warehouse/production in a certain period group, it is considered only if the Limit Openings attribute is set to 1.
It should be defined for a period group.
For example if the supplier’s Limit Openings attribute is set to 1 and the Maximum Openings attribute is 1 for a period group then the supplier can be closed and then opened once in the period group.

Limit Closings

Sheets on which it appears: Supplier, Production, Warehouse
Possible inputs: binary (0 or 1), it should be defined for a period group
How it affects the model: Indicates whether the supplier/warehouse/production can be set to close at a location in a given period group. It should be defined for a period group.

Maximum Closings

Sheets on which it appears: Supplier, Production, Warehouse
Possible inputs: any number equal or greater than 0, it should be defined for a period group
How it affects the model:Limit how many times the model can close a supplier/warehouse/production in a certain period group, it is considered only if the Limit Closing attribute is set to 1.
It should be defined for a period group.
For example if the supplier’s Limit Closing attribute is set to 1 and the Maximum Closings attribute is 1 for a period group then the supplier can be opened and then closed once in the period group.

Initial Status Closed

Sheets on which it appears: Supplier Product, Production, Warehouse Product
Possible inputs: binary (0 or 1), it should be set for the first period and first step
How it affects the model: Indicates whether supplier/warehouse/production was closed for the given product before first period of the model. Set for the first step and the first single period.
If this attribute is 1 then the supplier/warehouse/production is closed for the product in the first period. A supplier initial status is closed when all supplier single product combination has Initial Status Closed.
For example, a supplier is available for only one product, and has initial closed attribute for that product and also an Opening Cost attribute:

Product	Supplier	Period	Available	Opening Cost	Initial Status Closed
Carrot	Supplier_1	Period_1	1	10	1

In that case if the model uses Supplier_1 in period_1 the supplier should be opened, so the supplier will have Opening Cost for the first period.

Inventory Related Attributes

Minimum Inventory Cover and Maximum Inventory Cover

Sheets on which it appears: Warehouse Product
Possible inputs: any number greater than or equal to 0
How it affects the model: The number of next periods that throughput (outbound) covers. The attributes “Minimum Inventory Cover” and “Maximum Inventory Cover” describe the fraction of the next periods throughput (outbound) that must be or can be held as inventory.
Minimum Inventory Cover is handled as a minimum capacity constraint but it is not replacing minimum capacity for inventory or the target inventory, it is just an addition.
For example, if a warehouse has Inventory Cover (2) in period_1 and in period_2 that means that period_1 inventory should cover period_2’s and period_3’s outbound volume. If the outbound of period_2 and period_3 is 2, then the inventory should be greater than 2+2=4.
If the planning horizon ends at period_3, then the inventory of period_2 will be twice the outbound of period_3. (Assuming that the next periods are behaving similarly to the last one.)
We can distinguish four different cases in the calculation:

We can distinguish four different cases in the calculation, described with Minimum Inventory Cover:

Multi period model and the inventory cover is greater than 1:

Inventory coverage coefficients:

Product

Warehouse

Period

Minimum Inventory Cover

April

May

June

Carrot

Warehouse_1

March

2

1

1

0

Carrot

Warehouse_1

April

1.5

1

0.5

Carrot

Warehouse_1

May

3

3

Carrot

Warehouse_1

June

2

2

With these inventory volumes will look the following:

Product

Warehouse

Period

Minimum Inventory Cover

Volume

Closing Inventory

Carrot

Warehouse_1

March

2

10

(1*20)+(1*30)=50

Carrot

Warehouse_1

April

1.5

20

(1*30)+(0.5*40)=50

Carrot

Warehouse_1

May

3

30

(3*40)=80

Carrot

Warehouse_1

June

2

40

(2*40)=80

When there is Inventory Cover specified for the last period (June) or the inventory coverage of previous periods’ number goes beyond the horizon (May) the closing inventory is calculated based on the last period’s outbound (40).

Multi period model and the inventory cover is less than 1:

Inventory coverage coefficient will apply only to the next period and will have the same value as the Inventory coverage.

Inventory volumes will look the following:

Product

Warehouse

Period

Minimum Inventory Cover

Volume

Closing Inventory

Carrot

Warehouse_1

March

0.5

10

0.5*20=10

Carrot

Warehouse_1

April

0.5

20

0.5*30=15

Carrot

Warehouse_1

May

0.5

30

0.5*30=15

When there is Minimum Inventory Cover specified for the last period (May) the closing inventory is calculated based on the last period’s outbound (30).

Single period model and the inventory cover is greater than 1:

Inventory coverage coefficient will apply only to the single period and will have the same value as the Inventory coverage.

Inventory volumes will look the following:

Product

Warehouse

Period

Minimum Inventory Cover

Volume

Closing Inventory

Carrot

Warehouse_1

2023

2

10

2*10=20

When there is Minimum Inventory Cover specified in a single period model the closing inventory is calculated based on the current period’s (2023) outbound (10).

Single period model and the inventory cover is less than 1:

Inventory coverage coefficient will apply only to the single period and will have the same value as the Inventory coverage.

Inventory volumes will look the following:

Product

Warehouse

Period

Minimum Inventory Cover

Volume

Closing Inventory

Carrot

Warehouse_1

2023

0.5

10

0.5*10=5

When there is Minimum Inventory Cover specified in a single period model the closing inventory is calculated based on the current period’s (2023) outbound (10).

Maximum Inventory Cover is calculated in the same way as Minimum Inventory Cover in each case, but acts as a maximum capacity constraint for Warehouse Inventory.

Product	Warehouse	Period	Maximum Inventory Cover	Outbound volume	Max Capacity	Closing Inventory
Carrot	Warehouse_1	March	2	10	30	20 (Max. Capacity > Maximum Inventory Cover)
Carrot	Warehouse_1	April	2	10	10	10 (Max. Capacity < Maximum Inventory Cover)
Carrot	Warehouse_1	May	0.5	20	10	10 (Max. Capacity = Maximum Inventory Cover)

In every case the Minimum Inventory Cover acts in addition to minimum constraints. So, if there is also a Minimum Capacity specified, both Minimum Inventory Cover and Minimum Capacity will apply . The value for Closing Inventory depends on which of these two is higher.

Product	Warehouse	Minimum Inventory Cover	Outbound volume	Min Capacity	Closing Inventory
Carrot	Warehouse_1	2	10	30	30 (Min. Capacity > Minimum Inventory Cover)
Carrot	Warehouse_1	2	10	10	20 (Min. Capacity < Minimum Inventory Cover)
Carrot	Warehouse_1	0.5	20	10	10 (Min. Capacity = Minimum Inventory Cover)

In every case the Maximum Inventory Cover acts in addition to maximum constraints. So, if there is also a Maximum Capacity specified, both Maximum Inventory Cover and Maximum Capacity will apply . The value for Closing Inventory depends on which of these two is lower.

Product	Warehouse	Maximum Inventory Cover	Outbound volume	Max Capacity	Closing Inventory
Carrot	Warehouse_1	2	10	30	20 (Max. Capacity > Maximum Inventory Cover)
Carrot	Warehouse_1	2	10	10	10 (Max. Capacity < Maximum Inventory Cover)
Carrot	Warehouse_1	0.5	20	10	10 (Max. Capacity = Maximum Inventory Cover)

Minimum Inventory Cover and Maximum Inventory Cover are defined stepwise, and the Warehouse (Product) steps and the Inventory (Product) steps are independent.

Product	Warehouse	Step	Maximum Inventory Cover	Outbound volume
Carrot	Warehouse_1	1	2	10
Carrot	Warehouse_1	2	0.5	5

In this case the Closing Inventory will be 2*10 + 0.5*5 = 22.5, and this volume is allocated to Warehouse (Product) capacities according to the steps applied there.

Target (Inventory)

Sheets on which it appears: Inventory, Inventory Product
Possible inputs: any number greater than or equal to 0
How it affects the model: The target value of the inventory in a period. If the inventory is below or above the target inventory, the target is violated, and Target Violation cost should be taken into account.
The total target violation cost depends on how much of the inventory is under or over the target (see below). The target inventory does not replace the minimum or maximum capacity constraints, but target inventory should be greater than the minimum capacity and should be less than the maximum capacity.

Target Violation Cost (Inventory)

Sheets on which it appears: Inventory, Inventory Product
Possible inputs: any number greater than or equal to 0
How it affects the model: The cost of inventory target violation for a warehouse during a period. If the inventory is below or above the target inventory, the target is violated, and Target Violation cost should be taken into account.
The total target violation cost depends on how much of the inventory is under or over the target:

Warehouse	Period	Target Inventory	Target Violation Cost	Closing Inventory	Total target violation cost
Warehouse_1	Period_1	12	2	10	(12-10)*2=4
Warehouse_1	Period_1	12	2	12	(12-12)*2=0
Warehouse_1	Period_1	12	2	16	(16-12)*2=8

The target inventory does not replace the minimum or maximum capacity constraints, but target inventory should be greater than the minimum capacity and should be less than the maximum capacity.

Opening Inventory

Sheets on which it appears: Inventory Product
Possible inputs: any number greater than or equal to 0 (it sholud be defined for the first period and for the firt step)
How it affects the model: The inventory level at the start of the first period.

BOM and Production Routing

You can read more about how to use BOM and Production Routing in Bill of Material.

Product Created

Sheets on which it appears: Bill of Material
Possible inputs: any number greater than 0
How it affects the model: Product Created attribute defines how many final products can be made from the given amount of raw materials.

Product Needed

Sheets on which it appears: Bill of Material
Possible inputs: any number greater than 0
How it affects the model: Product Needed attribute defines how many raw materials are needed for the given amount of final product

Capacity Consumed

Sheets on which it appears: Production Routing
Possible inputs:any number greater than 0 (0 means unlimited)
How it affects the model: the amount of capacity consumed as the part of the process required to create the given amount of final products defined on the Bill of Material sheet (Product Created).

BOM Variable

Sheets on which it appears: Production Routing
Possible inputs: any number greater than 0 (0 means no cost)
How it affects the model: the cost of creating the given amount of final products defined on the Bill of Material sheet (Product Created)

Transport Related Attributes

Speed

Sheets on which it appears: Mode of Transport
Possible inputs: any number greater than 0 (0 means no speed defined)
How it affects the model: The average speed (distance/hour) of the give transportation type. It is used to calculate duration data if it is not given in the template.

Wiggle Factor

Sheets on which it appears: Mode of Transport
Possible inputs: any number greater than 0 (0 means not defined) in percentage
How it affects the model: Wiggle factor is used when the model calculates the straight distance between two locations.

Maximum Road Distance To Retrieve

Sheets on which it appears: Mode of Transport
Possible inputs: any positive number in unit of distance
How it affects the model: When a lane is using a mode of transport for which maximum road distance to retrieve has been specified and the straight line distance between two points for the lane is greater than the maximum road distance to retrieve, then the ‘Retrieve Distance’ flag will automatically be set to 0 for those lanes, and straight line distances will be used instead.

Retrieve Distance

Sheets on which it appears: Transport Cost
Possible inputs: binary (1-active, 0 (empty)-not active)
How it affects the model: Indicate that the distance and duration needs to be retrieved from Location IQ (if this attribute is 1). If this attribute is active, then the Distance Data page will be visible and the distance can be calculated. Note that the distance and duration by road will be retrieved when this attribute is active. This attribute should be left inactive if road distances and durations are not desired, or the path between two locations cannot be calculated by road.

Average Load Size

Sheets on which it appears: Transport Cost
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The average load size that can fit in a Mode of Transport at a lane and a product during a period. The Average Load size is used as a divisor to calculate the lane’s variable cost.

Transport	From Location	To Location	Distance	Cost Per	Cost Per Trip	Average Load Size	Minimum Cost	Cost
Mode				Distance			Per Trip
Truck	location_1	Location_2	10	0	3	2	0	(10*3)/2=15
Truck	location_1	Location_2	10	0	20	2	0	20/2=10
Truck	location_1	Location_2	10	0	0	2	10	10/2=5

Cost Per UOM

Sheets on which it appears: Transport Cost, Rate Cards, Stepwise Transport Cost
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The cost per unit of measurement for a Mode of Transport at a lane and a product during a period. It is independent of the distance, the total value only depends on the volume. It works with the same logic as Variable Cost. It can be defined for each step for a lane on the Stepwise Transportation Cost sheet.

Cost Per Distance

Sheets on which it appears: Transport Cost, Rate Cards
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The cost per unit of distance for a Mode of Transport at a lane and a product during a period.

Cost Per Trip

Sheets on which it appears: Transport Cost, Rate Cards
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The cost per trip of this Mode of Transport at a lane and a product during a period.

Minimum Cost Per Trip

Sheets on which it appears: Transport Cost, Rate Cards
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The minimum transportation cost of this lane.

Calculate the lane basic cost

The transportation basic cost calculated by the following the volume of the lane * tranportation unit cost. There is two case when calculate the Transportation unit cost, in the first case, there is no Minimum Cost Per Trip defined (first row in the table below) and the second case is when Minimum Cost Per Trip defined. In the second case the transportation unit cost is the maximum of the Minimum Cost Per Trip and Variable+Fixed costs.

Transport	From	To	Average Load	Cost Per	Cost Per	Cost Per	Minimum Cost	Distance	Transportation
Mode	Location	Location	Size	UOM	Distance	Trip	Per Trip		Unit cost
Truck	location_1	Location_2	2	10	4	20	0	15	10+((4*15)/2)+(20/2)=50
Truck	location_1	Location_2	2	10	4	20	60	15	50 (Fixed and Variable) > 30 (Minimum Cost Per Trip (60/2))
Truck	location_1	Location_2	2	10	4	20	120	15	60 (Minimum Cost Per Trip (120/2)) > 50 (Fixed and Variable)

Take Or Pay Volume

Sheets on which it appears: Transport Cost
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The volume of take or pay contract.
The “Take or Pay” cost is used when a customer/warehouse/production has a type of contract through which the customer/warehouse/production is forced to “take” a certain volume from a supplier/warehouse/production at a given cost or to “pay” the supplier if the agreed volume is not taken.
Take or pay unit is calculated as the round up of the ratio of the Volume of the Lane and the Take or Pay Volume.

Take Or Pay Fixed Cost

Sheets on which it appears: Transport Cost
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The cost of take or pay contract. Take or pay works by the following:

Transport Mode	From Location	To Location	Take or Pay Volume	Take or Pay Cost	Volume of the Lane	Take or pay unit	Take or Pay cost
Truck	location_1	Location_2	2	5	5	round up: 5/2=2.5 (3)	3*5=15

Base Case Lane

Sheets on which it appears: Transport Cost
Possible inputs: binary (0 or 1)
How it affects the model: This transportation lane is active in base case. When you want to use the base case lanes, the Enforce Base Case Constraints on Control Panel option should be selected.

Base Case Volume

Sheets on which it appears: Transport Cost
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The volume of this transportation lane in base case. When you want to use the base case lanes, the Enforce Base Case Constraints on Control Panel option should be selected.

Distance

Sheets on which it appears: Transport Trip Data
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The travel distance (miles or km depending on the input) for this lane.

Duration

Sheets on which it appears: Transport Trip Data
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: The travel duration (in hours) for this lane.

Customer Related Attributes

Demand

Sheets on which it appears: Customer Product Data
Possible inputs: any number greater than 0 (0 means there is no demand)
How it affects the model: The amount of demand for each customer, location, product and period combination. This amount should be fulfilled at least in the given Minimum Fulfillment Rate.

Lead Time

Sheets on which it appears: Customer Product Data
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: Lead time is maximal amount of driving time between your last resource and your customer.
It is basically the time taken to complete your last mile and it does not consider the times in the rest of your network.

Selling Price

Sheets on which it appears: Customer Product Data
Possible inputs: any number greater than 0 (0 means not defined)
How it affects the model: Selling Price for a customer, location, product, period combination. It is considered as a revenue.

Customer	Product	Demand	Selling Price	Inbound Volume	Revenue
Customer	product_1	3	5	3	3*5=15

Minimum Fulfillment Rate

Sheets on which it appears: Customer Product Data
Possible inputs: any number between 0 and 1 (0.5 means 50%)
How it affects the model: This amount should be fulfilled at least in the given Minimum Fulfillment Rate. When you want the model to take into account, the Allow Unfulfilled deamand on Control Panel.

Count Constraint Attributes

Minimum # of Open Locations

Sheets on which it appears: Location Product
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the minimum number of locations (from the given location group) where at least one product (or product from the given product group) is present. Curly bracket notation must be used to denote location groups, products can be denoted in curly bracket groups or individually (for instance {Location Group}, Product or {Product Group}). Note that imposing a minimum number of open locations does not force associated resources to open, i.e. a location may be opened without any active resources.

Maximum # of Open Locations

Sheets on which it appears: Location Product
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the maximum number of locations (from the given location group) where at least one product (or product from the given product group) is present. Curly bracket notation must be used to denote location groups, products can be denoted in curly bracket groups or individually (for instance {Location Group}, Product or {Product Group}).

Minimum # of Open Suppliers

Sheets on which it appears: Supplier
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the minimum number of locations (within a location group) where at least one supplier (from the given supplier group) is present. Curly bracket notation must be used to denote location and supplier groups (e.g. {Location Group}, {Supplier Group}).

Maximum # of Open Suppliers

Sheets on which it appears: Supplier
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the maximum number of locations (within a location group) where at least one supplier (from the given supplier group) is present. Curly bracket notation must be used to denote location and supplier groups (e.g. {Location Group}, {Supplier Group}).

Minimum # of Open Productions

Sheets on which it appears: Production
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the minimum number of locations (within a location group) where at least one production (from the given production group) is present. Curly bracket notation must be used to denote location and production groups (e.g. {Location Group}, {Production Group}).

Maximum # of Open Productions

Sheets on which it appears: Production
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the maximum number of locations (within a location group) where at least one production (from the given production group) is present. Curly bracket notation must be used to denote location and production groups (e.g. {Location Group}, {Production Group}).

Minimum # of Open Warehouses

Sheets on which it appears: Warehouse
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the minimum number of locations (within a location group) where at least one warehouse (from the given warehouse group) is present. Curly bracket notation must be used to denote location and warehouse groups (e.g. {Location Group}, {Warehouse Group}).

Maximum # of Open Warehouses

Sheets on which it appears: Warehouse
Possible inputs: Positive integers
How it affects the model: This attribute enforces a constraint for the maximum number of locations (within a location group) where at least one warehouse (from the given warehouse group) is present. Curly bracket notation must be used to denote location and warehouse groups (e.g. {Location Group}, {Warehouse Group}).

Ratio Constraint Attributes

Minimum Ratio

Sheets on which it appears: Supplier Ratio, Production Routing Ratio, Warehouse Ratio, Transport Ratio
Possible inputs: Positive real number
How it affects the model: This attribute can be used to enforce a constraint on the minimum ratio between the volume at an entity (or group of entities) and a comparison group of entities.
Curly bracket notation must be used when denoting groups. The minimum ratio constraint is conditional on whether the entity, the location, and the period are single, otherwise the constraint is imposed in absolute sense.
All constraints can be modeled as absolute if the respective entities are set to Force Open. The table below shows some examples of ratio constraints which can be modeled using this attribute:

Product	Warehouse	Location	Period	Product 2	Warehouse 2	Location 2	Period 2	Minimum Ratio
{All Products}	Location_2	Location_2	2024	{All Products}	{LDC}	{LDC}	2024	0.25
Thin-Film	Location_3	Location_3	2024	{All Products}	Location_3	Location_3	2024	0.35
Thin-Film	Location_4	Location_4	2024	Thin-Film	{LDC}	{LDC}	2024	0.65
{All Products}	{US LDC}	{US LDC}	2024	{All Products}	{Global LDC}	{Global LDC}	2024	0.75
{All Products}	{US LDC}	{US LDC}	{2024-2030}	{All Products}	{Global LDC}	{Global LDC}	{2024-2030}	0.45

Row-by-row explanation of the table above:

Location_2 must account for a minimum of 25% of the total throughput for All Products across all LDCs. (Conditional constraint)
The Thin-Film product must account for a minimum of 35% of All Products throughput at Location_3. (Conditional constraint)
Thin-Film throughput at Location_4 must account for a minimum of 65% of the total Thin-Film throughput across all LDCs. (Conditional constraint)
US LDCs must account for a minimum of 75% of All Products throughput across all Global LDCs. (Absolute constraint)
US LDCs must account for a minimum of 45% of All Products throughput across all Global LDCs over the period group 2024-2030. (Absolute constraint)

Maximum Ratio

Sheets on which it appears: Supplier Ratio, Production Routing Ratio, Warehouse Ratio, Transport Ratio
Possible inputs: Positive real number
How it affects the model: This attribute can be used to enforce a constraint on the maximum ratio between the volume at an entity (or group of entities) and a comparison group of entities.
Curly bracket notation must be used when denoting groups. This attribute can be applied in the same was as the Minimum Ratio, please refer to the explanatory table above for more details.