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.
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:
- Export all your prescriptions (Bulk Export To Model)
- Export only some of your prescriptions (Export Selected To Model)
- Export your prescriptions to Excel (Export To Excel)
For Cost prescriptions, Export to Excel is available from the grid pages for Node Skipping, Mode Switching, and Volume Consolidation, and from the All Prescriptions page.
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