Exporting prescriptions

Once your prescriptions are ready, you should export them to Supply Chain Modeler. You can also export your prescriptions to Microsoft Excel.

If you are using Supply Chain Guru X, you need to download the updated model from Modeler to SCGX after you export your prescriptions to Modeler. Additional information can be found in the Supply Chain Guru X "File transfers" topic.

Cost prescriptions

The Node Skipping, Mode Switching, Volume Consolidation, and All Prescriptions pages all have a grid of available prescriptions. These grids display prescriptions from the currently selected scenario. The prescriptions are initially ordered by Potential Savings - highest to lowest. Each grid can be sorted and filtered by column to find the prescriptions you need.

Rejected prescriptions are not exported to Modeler.

When you export prescriptions, a mapping occurs between the prescription and the Supply Chain model input tables. Typically, for every prescription:

  • An entry is added in the Transportation Policies table
  • An entry is added in the Sourcing Policies table
  • A scenario item is added in the Site Sourcing Policy: If the value in the 'site' field matches the destination of a Node Skipping prescription, then change that row's Sourcing Policy to "Multiple Sources(Most Inventory)"
  • A scenario item is added in the Customer Sourcing Policy: If the value in the 'customer' field matches the destination of a Node Skipping prescription, then change that row's Sourcing Policy to "Multiple Sources(Most Inventory)"
  • Flow constraints on some lanes are relaxed (especially for node skipping)
  • A new scenario is created in Modeler, with the Supply Chain Prescriptions items appended to the items copied from the source scenario in Modeler

You have three options for exporting:

Network Risk prescriptions

When you accept a Network Risk prescription it is automatically exported to your model. If needed, you can export your Risk prescriptions to Excel.

Last modified: Friday May 12, 2023

Is this useful?