Ratio Constraint Attributes

Ratio Constraints are only available in the Network Design Advanced and in the Sustainability and Risk Modules. You can read more about the concept behind ratio constraints in Ratio Constraints.

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.