Supplier Scenario
On this page you can create scenarios for the supplier input data.
This page is divided into three sections:
Select Type: The left-hand part allows you to select the Supplier, the Location, and/or the Product (or a combination of these) which you want to modify.
Select Attribute: The middle part enables you to select the attribute of the data to be changed, for example, Available, Minimum Capacity, or Variable Cost. Also, you can define the change during each time period in the table underneath.
Changed Data: The right-hand side table displays the resulting data changes, color-coded along with tooltips for easy reference.
Next we discuss in turn each of these sections in more detail.
Select Type
On this page the “Type” refers to one of the options available in the drop-down list, which includes ‘Supplier’, ‘Location’, and ‘Product’. The input data related to suppliers is defined over these types. As you make selections resulting in a combination of types, the available data will appear in the table on the right-hand side. The valid combinations are the following: ‘Supplier’ and ‘Location’, ‘Supplier’ and ‘Location’ and ‘Product’.
The choices in the selection widget underneath the type selection will be updated based on the selected type. For instance, when you switch the type from ‘Supplier’ to ‘Location’, the selection widget underneath will also switch to the potential choices for ‘Location’.
The “(x/y)” stands for (the number of selected/the total number) in each type, which means x out of y are selected. Once you have made the selections for all three types, the data which are defined over the selected ‘Supplier’, ‘Location’, and ‘Product’ will be displayed in the table on the right-hand side.
- Groups:
- You can utilize groups of types ‘Location’ and ‘Product’. Choosing a group is equivalent to selecting all the corresponding individual elements within that group.
Select Attribute
The drop-down list presents all attributes which can be potentially included in the supplier input data. So, for instance, even if a particular input dataset does not include Minimum Capacity, this (potential) attribute is still shown in the list.
Below the attribute selection there is a table used for defining the values:
Selected attribute is binary.
Selected attribute is non-binary.
There are three ways to make the change:
% Change: change the value by a percentage; the range is from -100% to infinity.
Value Increment: increase or decrease by entering a positive or a negative number; there is no limit on this number.
Value Overwrite: override this value.
Navigate between different ways of data change:
For one time period only one way of change can be applied and it is not possible to apply different changes to the same period. However, you can apply different changes to different periods.Examples:
If % Change is made in period one, you can make an additional Value Increment in other period.If % Change is made in period one, editing Value Increment also in period one will empty % Change in period one.
- Period groups:
- You can utilize period groups. Choosing a period group is equivalent to selecting all the periods within that group. Entering a value in an individual period will empty the value in the corresponding period group, and vice versa.
Changed Data
The data displayed in this table depends on both the selection of each type and the selected attribute.
Selection of each type
If you have made selections in ‘Supplier’ and ‘Location’, then the data which are defined over ‘Supplier’ and ‘Location’ will be displayed.
If you have made selections in all three types, ‘Supplier’, ‘Location’, and ‘Product’, then the data which are defined over all three types will be displayed.
If you have made selections in ‘Supplier’ and ‘Product’, then no data will appear, because there are no supplier input data defined over only these types.
Selected attribute
By default, only the data corresponding to the selected attribute and the selection made in the types will be displayed. However, you can switch to displaying all available data by using the widget action located in the top right corner of the table.
You can use the page actions in order to save, create new, load, and apply the scenario data, see the section Scenario Page Actions for more details.
Examples
Scenario 1: One supplier has increased its Maximum Capacity with 10% in all locations and all periods.
Supplier ‘Des Moines_RM’ has increased its capacity in all locations and all periods.Select Type ‘Supplier’ and in the widget underneath, check ‘Des Moines_RM’.
Select Type ‘Location’ and in the widget underneath, click on SELECT ALL.
Select Attribute ‘Maximum Capacity’ from the drop-down list. In the table underneath, enter the value 10 in the cell at the intersect of the row ‘% Change’ and the column for period ‘2022’.
Scenario 2: The Suppliers in a group of locations decrease cost.
All suppliers in the US have reduced by 3% the Taxes Variable Cost for Acids in Q4.Select Type ‘Supplier’ and in the widget underneath, click on SELECT ALL.
Select Type ‘Location’ and in the widget underneath, click on US.
Select Type ‘Product’ and in the widget underneath, click on Acids.
Select Attribute ‘Taxes - Variable Cost’ from the drop-down list. In the table underneath, enter the value -3 in the cell at the intersect of the row ‘% Change’ and the column for period ‘2022-4’.