Inventory Process Assignments

Internal Table Name: InventoryProcessAssignments

Use the Inventory Process Assignments table to create rules for selecting which Inventory Process to use when multiple processes are available. You can also link a process to another process. In addition, this table enables you to determine which processes can be used in which periods.

Simulation: Available only in Classic Simulation.

Period

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: PeriodName

Type: Short Text (50)

Select one of:

  • the specific Period to which the Inventory Process Assignment applies,
  • (ALL_Periods) to apply the assignment to the complete model horizon,
  • the Period group to which the Inventory Process Assignment applies in a multi-period model.

Period assignments work as follows:

  • (ALL_Periods) only assignment – The process is assigned to the entire horizon of the model. In a multi-period model, the assignment is for all periods.
  • (ALL_Periods) with additional period assignments – The horizon-level record (ALL_Periods) sets the basis for the assignment policy and costs. Period-specific assignments override the horizon assignment for the period specified.
  • Period-Specific Assignments Only – The process is assigned to the periods specified and unavailable in other periods. If there is no process assignment defined in a period, the model can still produce and hold the product in inventory; it does so without using a process. For example, if you define an Inventory Process Assignment for Period 1 only, the product will still be produced and potentially held in inventory in the other periods, but without the specific Inventory Process.

Site

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: FacilityName

Type: Short Text (100)

Select the site or site group for which the Inventory Process Assignment applies.

Product

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: ProductName

Type: Short Text (100)

Select the product or product group for which the Inventory Process Assignment applies.

Process

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: ProcessName

Type: Short Text (100)

Select the process for which the Inventory Process Assignment applies.

Assignment Policy

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: SelectionRule

Type: Short Text (255)

Select the Assignment Policy that determines how the Inventory Process Assignments will be used. Each site-product pair must have the same Assignment Policy for all process options. Some Assignment Policies are affected by the value of Policy Parameter:

Assignment Policy Description
None No specific assignment policy is applied.
Single Process Network Optimization only: Use this assignment policy if there is only one Inventory Process Assignment that can be used for production, based on the Site-Product combination. If insufficient capacity exists to serve all throughput with a single process, the model may be infeasible. This rule introduces a binary constraint which can lead to increased model run time.
Split by Ratio

The Policy Parameter value is used to establish a ratio between the records to be used. This then drives the percentage used for each:

  • If the value is non-zero, use the exact value to establish the ratio. For example, if you enter 6 for one record and 2 for the other, then 75% uses the first record and 25% uses the second.
  • If the value is 0 or null, this record is not considered (similar to setting Status = “Exclude”).

This rule adds a constraint to the model, to force the process selection to use the split defined.

You can express the Policy Parameter as 0 to 100, or 0 to 1. For example, values of 25 and 75 are evaluated the same as values of .25 and .75.

Split by Probability

Inventory Process Assignments are divided according to the percentages specified in the Policy Parameter field:

  • If the value is non-zero, use the exact value. For example, if you enter 50, then 50% uses this record. The Parameter values should add up to 100, which represents 100%, however if the inputs do not add up to 100, the values will be scaled to 100 automatically.
  • If the value is 0, this is treated as 0% and this record is not considered (similar to setting Status = “Exclude”).
  • If the value is null, this record is considered “free”. In the case that all records with non-zero parameter values add up to less than 100%, the solver can determine the percentage for any free records. In the case that the non-zero parameter records add up to 100%, the free records are not considered (similar to Status = “Exclude”).

You can express the Policy Parameter as 0 to 100, or 0 to 1. For example, values of 25 and 75 are evaluated the same as values of .25 and .75.

Link to Process

Optimization only: This rule forces the process to link to another process, removing the independent selection of a process. The process assignment Policy will, in turn, dictate the rule for process selection. This rule is used only when multiple processes are present.

Only Inventory Processes are available when linking from an Inventory Process Assignment.

First Available Simulation only: The Inventory Process which becomes available first is used.

Policy Parameter

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: SelectionParameter

Type: Short Text (255)

This field is used in conjunction with the "Split by Ratio", “Split by Probability”, and “Link to Process” Assignment Policies.

  • Split by Ratio – Define the ratio between multiple processes on the same Site-Product combination. These are then used to generate the proportional split. For example, if you have two processes that can be used with a “Split by Ratio”, you could define the Policy Parameters as 6 for one record and 2 for the other. Based on the ratio between these two values, the Inventory Process Assignment would be 75% for the first record and 25% for the second.
    You can express the Policy Parameter as 0 to 100, or 0 to 1. For example, values of 25 and 75 are evaluated the same as values of .25 and .75.
  • Split by Probability – the assignment is chosen based on the percentages set in the Policy Parameter field:
    • If the value is non-zero, use the exact value. For example, if you enter 50, then 50% uses this record. The Policy Parameter values should add up to 100, which represents 100%, however if the inputs do not add up to 100, the values will be scaled to 100 automatically.
    • If the value is 0, this is treated as 0% and this record is not considered (similar to setting Status = “Exclude”).
    • If the value is null, this record is considered “free”. In the case that all records with non-zero parameter values add up to less than 100%, the solver can determine the percentage for any free records. In the case that the non-zero parameter records add up to 100%, the free records are not considered (similar to Status = “Exclude”).
    You can express the Policy Parameter as 0 to 100, or 0 to 1. For example, values of 25 and 75 are evaluated the same as values of .25 and .75.
  • Link to Process – Enter the name of the process to which the current process is linked. Only Inventory Processes are available when linking from an Inventory Process Assignment.

Default: 1

Status

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Choose the Inventory Process Assignment status:

  • Include - This Inventory Process Assignment is to be included in a simulation or optimization run.
  • Exclude - This Inventory Process Assignment is to be excluded from a simulation or optimization run.

Default: Include

Notes

Technology: NO S

Table: InventoryProcessAssignments

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the Inventory Process Assignment.

Last modified: Wednesday May 15, 2024

Is this useful?