The Scenario Results page in phase 2 allows you to compare your current (scenario) data with your actual stock data in more detail. This will give you more insight in how your actual stock is doing compared to the scenario that you’re creating.
Stock - Bar Chart¶
The first bar chart displays two stacked bars for each resource/location. The first stacked bar equals Safety Stock and Cycle Stock calculated for the scenario, summed over all products. To be able to compare your Actual Stock with the calculated stock, the app calculates for each resource/location/product, which part of the Actual Stock is Safety Stock, which part is Cycle Stock and the remainder is Too Much Actual Stock. The second stacked bar displays this data summed over all products. This avoids the case where too much inventory for one product outweighs too little inventory for another product.
A more detailed explanation on Safety Stock, Cycle Stock and Too Much Actual Stock can be found here.
The header of the bar chart starts with “Stock”. After that, you see whether the data is in units or values. This can be changed on the View panel. It also shows whether all resources/locations/products are visible (or summed over) or whether a filter is applied (which can be changed on the Product Filter and Resource Filter panels).
Actual Stock Percentage¶
The second bar chart displays for each resource/location the percentage of products that have Actual Stock within one of the four categories: Too Much, Within Target, Service Risk, Too Little. The colors and meanings of these categories are explained here. This bar chart helps you to see quickly at which resource/location there are a lot of products that fall within a certain category. Please note that this chart is only visible when you have Actual Stock data.
Stock - Table¶
The table displays the detailed calculated and actual stock data per resource/location/product. The first X columns display the data for the current (scenario) data. After that, the columns for the actual data are displayed. The last column displays the Unit of Measurement (UOM) for that line in the table.
The data that is shown is:
- Scenario Safety Stock
- Scenario Cycle Stock
- Scenario Work in Progress - (if considered in your configuration) This equals the average demand times the process time.
- Scenario In-Transit - (if considered in your configuration) The amount of stock that is on its way to the resource/location.
- Scenario Max
- Scenario AVG
- Actual Total - This equals the Actual Stock input data, loaded from the dataset.
- Actual Safety Stock - The part of the Actual Stock that is assigned to be Safety Stock.
- Actual Cycle Stock - The part of the Actual Stock that is assigned to be Cycle Stock.
- Actual Delta
The header of the table starts with “Stock”. After that, you see whether the data is in units or values. This can be changed on the View panel. It also shows whether all resources/locations/products are displayed or whether a filter is applied (which can be changed on the Product Filter and Resource Filter panels).
In the View panel on the right, you can select in what unit of measurement (UOM) you want the data to be displayed. You can see the data either in the currency specified in your configuration or in units. In case you have multiple units of measurement provided in your dataset, you can see the data in either the base unit (specified in your configuration) or the product UOM when that data is displayed on a product level.
In the View panel you can also select which types of stock are displayed. Turning off some of them, might be convenient when you want to compare two columns. An explanation of these stock types can be found above and at Scenario Stock - Table.
When you’re done with modifying the data on the other pages in phase 2, you can save your scenario (if you haven’t done so). After that, you can either create another scenario, or go to phase 3: Compare Scenarios, to compare the created scenarios with each other, or with your actual stock levels.