Count Constraint Attributes
Count Constraints are only available in the Network Design Advanced and in the Sustainability and Risk Modules. You can read more about the concept behind count constraints in Count and Ratio Constraints.
Minimum # of Open Locations
- Sheets on which it appears
- 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
- 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
- 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
- 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
- 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
- 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 Open
- Sheets on which it appears
- Possible inputs
Positive integers
- How it affects the model
This attribute enforces a constraint on the minimum number of open production routing instances within a group. Each unique combination of Bill of Material, Production Facility, Location, and Period is counted as a separate instance. When curly bracket groups are used, all four dimensions are expanded independently: for example, if {BOM Group} contains 2 BOMs and {Period Group} contains 3 periods, and all combinations are open, this contributes 2 × 3 = 6 to the count. Curly bracket notation must be used to denote period, production facility, location, and bill of material groups (e.g. {Period Group}, {Production Facility Group}, {Location Group}, {BOM Group}).
Maximum Open
- Sheets on which it appears
- Possible inputs
Positive integers
- How it affects the model
This attribute enforces a constraint on the maximum number of open production routing instances within a group. Each unique combination of Bill of Material, Production Facility, Location, and Period is counted as a separate instance. When curly bracket groups are used, all four dimensions are expanded independently: for example, if {BOM Group} contains 2 BOMs and {Period Group} contains 3 periods, and all combinations are open, this contributes 2 × 3 = 6 to the count. Curly bracket notation must be used to denote period, production facility, location, and bill of material groups (e.g. {Period Group}, {Production Facility Group}, {Location Group}, {BOM Group}).
Minimum # of Open Warehouses
- Sheets on which it appears
- 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
- 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}).