Open/Close Attributes

Force Open

Sheets on which it appears: Location Period, Supplier, Supplier Product, Production, Production Routing, 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, Production Routing, 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.

Open as Group

Sheets on which it appears: Supplier, Supplier Product, Production, Production Routing, Warehouse, Warehouse Product
Possible inputs: Binary, 0 (empty) or 1
How it affects the model: This attribute is always declared over a curly bracket period group, like {2025}. This means that the model will either open or close this Supplier, Warehouse, Production for all the periods in the group. This prevents the model from opening a supplier, warehouse, production for only a couple of the periods, and be closed for the rest of the periods. Furthermore, inside a Supplier or Warehouse, a product can also be declared as a group for some periods, preventing it from being open for only a few periods. Similarly, in Production Routing, BOMs can be defined to either be open or closed within a specific period group.

Limit Openings

Sheets on which it appears: Supplier, Production, Warehouse
Possible inputs: Binary, 0 (empty) 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 (empty) 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, Production Routing, Warehouse Product

Possible inputs

Binary, 0 (empty) or 1, it should be set for the first period and first step.

How it affects the model

Indicates whether supplier/warehouse 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 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. Similarly, in Production Routing, it is possible to specify whether each BOM was closed before the first period. Furthermore, for Production, the initial status closed can also be defined for the entire location.