Expression Constraint can be added to restrict flow between two nodes as per the customized expressions. It applies at period level and different expressions are created for each period in the period group.
To add Expression Constraint, click on the Expression constraint under constraint drop down in Data Dashboard. Then click on the add Expression constraint to add individual data or bulk data in respective tabs.
Table Description | |
Period Group | Period group from the period group table to be selected/added |
Origin Group | Select/Add an origin group from the supplier/plant/warehouse groups table. |
Destination Group | Select/Add a destination group from the supplier/plant/warehouse groups table. |
Product Group-1 | Select/Add a product group from the product group table. |
Product Group-2 | Select/Add a product group from the product group table. |
Coeficient-1 | Add the Coefficient value to be multiplied to the Product group-1 |
Coeficient-2 | Add the Coefficient value to be multiplied to the Product group-2 |
Min | Add the desired minimum value of the expression constraint |
Max | Add the desired maximum value of the expression constraint |
Outflow Flag | Add “0” to impose the constraint on inflow at the destination group and add “1” to impose the constraint on outflow at the source group. |
Status | 1 or 0 can be assigned for active or inactive status of constraint. |
Note | Any remarks/comments can be added in this column. |
The above constraint added will restrict the flow between Supplier_1 and plant_1 during period_1 as per the expression:
5<{(sum of quantities of all products from all_products group)*1 + (quantity of product_1)*2}<10
Since, min and max values in the constraint are 5 and 10 respectively.
If more than 2 product groups needs to be used in the expression then all the product groups can be entered in Product group-1 column separated by double colons (::) and their respective coefficients needs to be added in Coefficient-1 column separated by double colons. In product group-2, any product group can be selected (will not be used in expression formation) and in Coefficient-2 column any value less than zero needs to be entered as signal for using more than 2 product groups in the expression constraint.
This constraint operates at the period level, resulting in distinct equations for each period within the selected period group. Meanwhile, for the origin and destination group, it aggregates all origins and destinations within the origin and destination group.
