Network Optimizer¶
Warning
Included in Factory Personal and Factory Enterprise licenses.
The Network Optimizer balances a workload distributed over a network.
A typical example is distributing stock in logistics problems such as an inventory assignment.
The output of the task is:
the amount of material moved.
the amount of material remaining in the source location.
the amount of material now in the target location.
The task is made of two tabs:
the Options tab, where you customize the available options to obtain the desired output.
the Results tab, where you can visualize the computation results.
The Options tab¶
The Options tab contains all the analysis characteristics you can customize. It is divided into three smaller tabs: the Basic tab, the Edges tab, the Nodes tab.
The Available attributes list, where the dataset’s attributes are displayed and ready for the analysis, is always displayed into the Options tab, no matter which tab you’re working on.
Basic tab
In the Basic tab, you can distinguish between three sections:
- the Attribute drop area, where you can drag the required attributes to start the analysis. The following settings are provided:
Source attributes: drag all the attributes defining the source. Instead of manually dragging them, they can be defined via a filtered list.
Destination attributes: drag all the attributes defining the destination. Instead of manually dragging them, they can be defined via a filtered list.
Source quantities (positive values): the attribute defining the initial quantity in the source. Its type must be numeral, and its values must be positive.
Destination quantities (negative values): the attribute defining the required quantity in the destination node. Its type must be numeral, and its values must be negative.
- a customization area, made of the following options:
Priority value: select the attribute defining the priority of the destinations to which the goods will be sent. Its type must be numeral.
Ascending values of the priority attributes refer to higher priorities: if selected, a higher value in the Priority value attribute indicates higher priority. (e.g.: if the Priority value ‘25’ has a higher priority than the Priority value 15)
Append results: if selected, the results of this computation are appended to the dataset, otherwise they replace the results of the previous computations.
Merge results with original data: if selected, results will be included in the original dataset.
Maximum number of iterations: the maximum number of iterations during computation.
Deployment policy: select the deployment policy which defines how source quantities will be distributed to the destination nodes. Possible values are: * Move quantities even if request is not fulfilled (default): all the available source material will be moved. * Move quantities only if request is fulfilled: material will be sent to a destination only if its requirements are met. Otherwise, nothing will be sent. * Fair share among destinations: all the available source material will be shared between destinations, according to the proportions defined in the Attribute specifying fair share weight to be applied to destinations option, in the Nodes tab. * Do not exceed request: the source material to be sent will be less or equal to the quantities specified in the Destination quantities parameter. The request won’t be exceeded in any case, even if an Attribute for rounding value has been specified in the Edges tab.
Note
If there are two rows in the Source parameter which have the same values, but the two corresponding values are different from each other in the attribute associated with the Destination parameter, the Network Optimizer task considers both quantities associated with the different destinations, as it considers the maximum value among them as a value of source availability. Consequently, the different availability quantities can be then considered for different destinations, but they will refer to a common reference quantity.
Edges tab
In the Edges tab, you can define the clustering edges. The following options are provided:
Attribute for transport cost: select the attribute defining the cost of moving a unit of material from the source to the destination.
Attribute for maximum quantity to move: select the attribute that defines the maximum total number of units that can be moved between the source and destination at a time.
Attribute for rounding value: select the attribute that defines the minimum number of units that can be moved at a time. For example, three items may be required, but the items may only be available in blocks of ten.
Transport cost is independent of moved quantity: if selected, the cost of transport does not change with the quantity sent.
Nodes tab
In the Nodes tab, you can define the clustering nodes. The following options are provided:
Fixed cost of shipping from a source: specify the inherent cost of shipping from a source as a mathematical weight to be applied in calculating the best solution.
Fixed cost associated to each unfulfilled destination: specify the inherent cost of not fulfilling the requirements of a destination as a weight to be applied in calculating the best solution.
Attribute specifying cost for item for unfulfilled destination: select the attribute that defines the cost per unit of not satisfying destination requirements.
Attribute specifying fair share weight to be applied for destinations: select the attribute that defines the proportional quantity of material that will be sent to the specific destination, if the Fair share among destinations option is selected.
The Results tab¶
The Results tab provides information on computation. It is divided into two sections:
- the General Info section, where you can find the following information:
the Task Label, which is the task’s name on the interface.
the Elapsed time, which indicates how long it took to complete the computation.
the Optimum value of the cost function, indicating the ideal cost.
Example¶
After having imported the dataset, right-click on the import task and select Take a look to check the dataset has been correctly imported.
The dataset contains 6 rows, where each row corresponds to a source - destination link.
Each source may have multiple destinations, and each destination may have multiple sources. There is a separate row for each possible combination. However, the quantities (Src_qty, and Dest_qty) must always be the same for each source and destination.
The Max Load value, on the other hand, can vary as it depends on the specific source - destination combination.
- The Data Manager task displays the available dataset for:
3 sources (SRC-AA, SRC-BB and SRC-CC) and
3 destinations (DEST-XX, DEST-YY and DEST-ZZ).
- In the Basic tab configure the following options:
Source attributes > Src
Destination attributes > Dest
Source nodes quantiles (positive values) > Src_qty
Destination nodes quantiles (negative values) > Dest_qty
Deploy policy > Move quantities only if request is fulfilled
Merge results with original data > selected
Leave the other options with their default values.
- In the Edges tab configure the following options:
Attribute for maximum quantity to move > Max Load
Attribute for rounding value > Rounding
Leave the other options with their default values.
In the Nodes tab leave the options with their default values.
Save and compute the task.
Right-click on the Network Optimizer task and select Take a Look to see the results. Alternatively, you can link a Data Manager to the task.
