Selecting Cost run options

The Supply Chain Prescriptions Cost algorithm has a variety of options available to help you generate the prescriptions that you need.

You need to have the Business User role to be able to run prescriptions. Contact your administrator if you need this role.

Before you run the Supply Chain Prescriptions algorithm, be sure you have run the Network Optimization and Cost to Serve Analysis problem types on your scenarios in Modeler.

Supply Chain Prescriptions Cost Algorithm options

Option Description
Prescription Options
Period Name In a multi-period model, you can select the period for which the prescriptions are run. If a period is not selected the prescriptions are run for the model horizon.
Business Objective

Select whether you want to minimize "Transportation Cost" or "Transportation + In-Transit Inventory Cost".

The default objective is "Transportation + In-Transit Inventory Cost".

Business Objective Basis

Select what basis you want to minimize:

  • Distance

  • Quantity

  • Weight

  • Quantity-Distance

  • Distance-Weight

The units of measure used are those used in your model.

Exclude Customer Facing Sites from Node Skipping and Volume Consolidation

Select this option to exclude customer facing sites in paths from both Node Skipping and Volume Consolidation. This means the customer facing sites are not skipped with Node Skipping when the option is selected.

Exclude Customer Facing Lanes from Mode Switching Select this option to exclude customer facing lanes from Mode Switching prescriptions. This means prescriptions are not generated for customer facing lanes with Mode Switching when the option is selected.
Select Sites to Exclude from Node Skipping

Use this option to select the sites or site groups to be excluded from Node Skipping. Prescriptions will not be generated for lanes with these sites. When you select a group name, all group members are also selected in the list.

Select on the Site Name heading to sort the column values by ascending or descending order.

You can search the Site Name column by clicking in the Search header and entering your search criteria.

Import From Excel

Use this button to import the data from an Excel file that defines the site codes to exclude from Node Switching. You can use Export To Excel to download an initial file, then populate it and import back to your Prescription Options.

Select Import From Excel, then select the Excel file you want to import. Site names defined in the Excel file are selected.

Export To Excel Use this button to download an Excel file that includes the site codes to exclude from Node Switching. You must select at least one site name to export the file. The default file name is Excluded-site-codes.xlsx.
Mode Options
Mode Mapping

Use this option to map the Mode names as defined in your model to the AI Mode Types. Each Mode can be applied to one Mode Type.

To assign Modes to Mode Types, select Select Modes for Mode Type, select the Mode(s) you want to map, and then select OK.

Mode Switch Constraints

Define one or more mode switch constraints that are used to prevent mode switching. This restricts the mode selection process in prescription generation from selecting certain modes based on the original mode of the path or lane being analyzed.

For each constraint, select Add a row, then select:

  • Source Name - Select a Site Name, Site Group, or select "All" if the constraint applies to all source sites. When you select a group name, all group members are also selected in the list.

  • Destination Name - Select a Site Name, Site Group, Customer Group, or select "All" if the constraint applies to all destination sites. When you select a group name, all group members are also selected in the list.

  • Product Name - Select a Product Name, Product Group, or select "All" if the constraint applies to all products. When you select a group name, all group members are also selected in the list.

  • Current Mode - Select a Mode Type (if you have set up Mode Mapping) or a Model Mode Name.

  • Invalid Mode - Select a Mode Type (if you have set up Mode Mapping) or a Model Mode Name.

For example, if you want to prevent Air from switching to Ocean between certain sites, you can specify the Source Name, Destination Name, "All" for Product Name, "Air" as the Current Mode and "Ocean" as the Invalid Mode.

Select on the column headings to sort the data by the column values. You can use the Shift key to select multiple columns for the sort order.

To delete constraints you don't need, select one or more constraints, then select Delete Selected Records.

Import From Excel

Use this button to import the data from an Excel file that defines the mode switch constraints. You can use Export To Excel to download an initial file, then populate it and import back to your Prescription Options.

Select Import From Excel, then select the Excel file you want to import.

Export To Excel Use this button to download an Excel file that includes the mode switch constraints. You must select at least one constraint to export the file.
Shipment Frequency Options
Shipment Frequency Options table

Define one or more constraints on mode selection based on the shipment frequency, where shipment frequency is calculated by total flow quantity (over the lane or estimated for the path segment) / shipment size (from transportation policies).

Constraints are specified by a lower bound and/or upper bound. Bounds can be relative and/or absolute. The tighter of the relative and absolute bounds are used for the minimum and maximum. The constraint must have at least one bound to be in effect.

For each constraint, select Add a row, then select:

  • Source Name - Select a Site Name, Site Group, or select "All" if the constraint applies to all source sites. When you select a group name, all group members are also selected in the list.

  • Destination Name - Select a Site Name, Site Group, Customer Group, or select "All" if the constraint applies to all destination sites. When you select a group name, all group members are also selected in the list.

  • Product Name - Select a Product Name, Product Group, or select "All" if the constraint applies to all products. When you select a group name, all group members are also selected in the list.

  • Current Mode - Select a Mode Type (if you have set up Mode Mapping) or a Model Mode Name.

  • Minimum Frequency Threshold - Enter the minimum frequency as an absolute number.

  • Maximum Frequency Threshold - Enter the maximum frequency as an absolute number.

  • Percent Change Down - Enter the relative percentage change down from the current frequency. The value must be between 0 and 100.

  • Percent Change Up - Enter the relative percentage change up from the current frequency . The value must be between 0 and 100.

For example, assume a lane with a frequency of 35 shipments over the horizon/period with the following bounds:

  • Minimum Frequency Threshold = 25

  • Maximum Frequency Threshold = 36

  • Percent Change Down = 20

  • Percent Change Up = 10

The lower bound is 28 shipments and the upper bound is 36 shipments.

Select on the column headings to sort the data by the column values. You can use the Shift key to select multiple columns for the sort order.

To delete constraints you don't need, select one or more constraints, then select Delete Selected Records.

Import From Excel

Use this button to import the data from an Excel file that defines the shipment frequency constraints. You can use Export To Excel to download an initial file, then populate it and import back to your Prescription Options.

Select Import From Excel, then select the Excel file you want to import.

Export To Excel Use this button to download an Excel file that includes the shipment frequency constraints. You must select at least one constraint to export the file.
Advanced Options
Correlation Threshold

Use this value to set the threshold for correlation between features (site, lane and path level features) and the response variable (such as per mile or per pound). Features with an absolute correlation less than this threshold are removed from building the machine learning (ML) model. The value must be between +1 and -1, where 1 is a total positive linear correlation, 0 is no linear correlation, and -1 is a total negative linear correlation.

The default value is 0.005.

 

Last modified: Friday May 12, 2023

Is this useful?