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, Cycle Stock and Spare Parts Stock calculated for the scenario, summed over all products. To be able to compare this calculated stock to your Actual Stock, the app calculates for each resource/location/product, which part of the Actual Stock is Safety Stock, which part is Cycle Stock, which part is Spare Parts Stock, and the remainder is Too Much Actual Stock. These values are displayed in the second stacked bar, summed over all products. By splitting up actual stock in these different components, you avoid 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, Spare Parts Stock and Too Much Actual Stock can be found here. Please note that Safety Stock and Cycle Stock are calculated for regular products only, while Spare Parts Stock is calculated for spare parts only.
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 (depending on your configuration):
Scenario Safety Stock
Scenario Cycle Stock
Scenario Work in Progress - This equals the average demand times the process time.
Scenario In-Transit - The amount of stock that is on its way to the resource/location.
Scenario Spare Parts Stock - The amount of stock that you need for spare parts to achieve the provided level of confidence.
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 Spare Parts Stock - The part of the Actual Stock that is assigned to be Spare Parts stock.
Actual Achievable Service Level - The service level percentage that can be achieved with the Actual Stock level.
UOM - The Unit of Measurement in which the numbers in a particular row are displayed.
The following additional columns are available but not shown by default (see View side panel to show them):
AVG Demand - The daily average demand of a product at a resource/location. This is the sum of all the customer and resource demand that a resource is (in)directly serving.
Variability - The variability of the demand for a product at a resource/location. This is also calculated based on the variability of the demand at the customers/resources that the resource is (in)directly serving.
Installed Base - The installed base for a product at a resource/location is the sum of the installed base of the customers that a resource is directly serving.
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 (Show Inventory Info). 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. At Show Additional Info, you can also turn on average demand, variability (for regular products) and installed base (for spare parts). This information can help you in understanding the calculated stock levels.
Read here about the working of the Product Filter.
Read here about the working of the Resource Filter.
When you’ve inspected the scenario results, you can also check the re-balancing opportunities for this scenario on the next page in phase 2: Re-balancing.
Read here about the Help panel.