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.

Sheets on which it appears: Settings
Possible inputs: Any 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.

Sheets on which it appears: Settings
Possible inputs: Binary, 0 (empty) or 1
How it affects the model: When this attribute is set to ‘1’, the Allow Base Case Volume Mismatch option on the Control Panel will automatically be enabled.

Sheets on which it appears: Settings
Possible inputs: Any number greater than 0
How it affects the model: Use this attribute when Retrieve High-level Cost Data is enabled and the default currency is not USD, so transport costs defined in USD can be converted correctly. For more details on Retrieve High-level Cost data, see the Transport Cost page.

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.

Sheets on which it appears: Locations
Possible inputs: Non-negative
How it affects the model: When the Maximum # of Source Locations constraint is defined, this attribute specifies how a source location contributes to that limit. For each destination location, the model sums the Source Location Weight of all source locations supplying volume in a given product and period. The summed value must not exceed the specified maximum number of source locations. The default value is 1. For example, if the maximum number of source locations is 1 for a location, then it can be supplied either by one source location with weight 1, or by two source locations with weight 0.5 each.

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.