# Template-Attributes¶

In this section you can read about the different attributes: what effects they have and how to use them. On the different sheets of the Excel you can find a lot of types of attributes, some of them are cost related or opening/closing decisions.

## 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

*Optimality Gap*¶

**Sheets on which it appears**: Settings

**Possible inputs**: 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.

*Maximum # of Source Locations*¶

**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.

*Maximum # of Destination Locations*¶

**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.

## Available¶

**Sheets on which it appears**: Supplier, Supplier Product, Production, Warehouse, Warehouse Product, Inventory, Inventory Product, Transport Cost, Stepwise Transport Cost

**Possible inputs**: Binary: 1 or 0 (empty)

**How it affects the model**: To indicate that the Supplier, Warehouse, Production...etc., can be used by the model. Only

*Avaiable*

**without**

*Force Open*does not necessarily mean that the minimum and maximum capacity will be considered, in other words the constraint will be conditional. If both

*Available*and

*Force Open*attributes are defined then the constraints must be met. For example, if the Warehouse has minimum capacity (10000) and it is only

*Availabe*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. Objects with {Curly Bracket} does not need

*Available*attribute if single elements of the group have

*Available*attribute.

## BOM and Production Routing¶

You can read more about how to use BOM and Production Routing in Bill of Material.

*Product Created*¶

**Sheets on which it appears**: Bill of Material

**Possible inputs**: any number greater than 0

**How it affects the model**:

*Product Created*attribute defines how many final products can be made from the given amount of raw materials.

*Product Needed*¶

**Sheets on which it appears**: Bill of Material

**Possible inputs**: any number greater than 0

**How it affects the model**:

*Product Needed*attribute defines how many raw materials are needed for the given amount of final product

*Capacity Consumed*¶

**Sheets on which it appears**: Production Routing

**Possible inputs**:any number greater than 0 (0 means unlimited)

**How it affects the model**: the amount of capacity consumed as the part of the process required to create the given amount of final products defined on the

*Bill of Material*sheet (

*Product Created*).

*BOM Variable*¶

**Sheets on which it appears**: Production Routing

**Possible inputs**: any number greater than 0 (0 means no cost)

**How it affects the model**: the cost of creating the given amount of final products defined on the

*Bill of Material*sheet (

*Product Created*)

## Count Constraint Attributes¶

*Minimum # of Open Locations*¶

**Sheets on which it appears**: Location Product

**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**: Location Product

**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}).