Product Storages

This table is used within the Network Optimization experiment only. It allows you to define the inventory stock parameters.

Column

Description

Label

Specify the name of the storage constraint.

It must be a meaningful name since you will refer to it in the Custom constraints tables.

Facility

Defines the site that the constraints will be defined for (DC, Factory, Supplier and groups containing them).

Double-click the cell and select the required facility from the drop-down list.

Expand Facilities

Defines if the specified stock level (columns from Initial stock, units to Fixed Value) is applied to each defined facility (Enabled) or to the aggregated number of facilities (Disabled). By default the aggregated number of facilities is considered.

e.g. We specify a group of 4 DCs. The Min Stock value is set to 55 items. If the  Expand Facilities is enabled,  the specified amount of products is considered to be stored at each DC, totaling 55 * 4= 220 items, otherwise it  will refer to the sum of products stored at all DCs.

Product

Defines the product or a group of products.

Expand Products

Defines if the specified stock level (columns from Initial stock, units to Fixed Value) is applied to each defined product (Enabled) or to the aggregated number of products (Disabled). By default the aggregated number of products is considered.

e.g. A site offers 2 types of products. The Min Stock value is set to 55 items. If the Expand Products is enabled, the 55 items will refer to each type of a product, totaling 110 items, otherwise it  will refer to the sum of all products.

Initial Stock, units

Defines the initial stock of the specified facility/group of facilities.

Min Stock

Defines the lowest stock level of the specified facility/group of facilities.

Safety Stock

Defines the safety stock level of the specified facility/group of facilities.

Max Stock

Defines the highest stock level of the specified facility/group of facilities.

Fixed

If enabled, the Fixed Value column is considered.

Fixed Value

allows you to explicitly specify the stock level of the facility/group of facilities.

Stock Down Penalty

Defines the penalty to be paid per product item (or per cubic meter) for dropping the stock level below the specified Min Stock level.

The penalty is calculated as: specified penalty - summarized cost of the lacking products.

Stock Safety Penalty

Defines the penalty to be paid per product item (or per cubic meter) for dropping the stock level below the specified Safety Stock level.

The penalty is calculated as: specified penalty - summarized cost of the lacking products.

Stock Up Penalty

Defines the penalty to be paid per product item (or per cubic meter) for exceeding the stock level specified Max Stock level. 

The penalty is calculated as: specified penalty - summarized cost of the excessive products.

Product Unit

Specify the unit (of weight or volume) the product is measured in. The list of available units contains all the units that are currently used within the project as well as the units defined in the Units table that can be used in the current scenario only.

Time Period

The time period during which the constraints are valid.

Double-click the corresponding row cell to choose among the available periods (previously defined in the Periods table).

Inclusion Type

Defines the status of the current facility constraint. 

  • Include - if this status is set, the facility constraint will be included into the supply chain configuration.
  • Exclude - if set, the facility constraint will be excluded from the supply chain configuration. If selected, the table record will be grayed out to denote the current inclusion type. The table record stays editable.
    Note: If you feel that your scenario contains too many objects marked as "Excluded" and you know that you no longer use them, you can instantly remove all such objects.

Defining inventory stock parameters

You can define the following:
The table allows you to consider the stock parameters for:

You may alter these combinations by clicking the toggle buttons in the Expand Facilities, Expand Products columns.

By default the stock is measured in items but when the following condition are met, the units automatically switch to cubic meters:

Note: The data in the columns will not be converted to the new measurement units. The same numbers will be expressed in cubic meters now.

 

Related topics


Expanding table records.