This page enables you to determine areas where a product is surplus in one place and deficient in another, which can serve as a starting point for potential inventory transfers.
Before you start
Use the context selectors at the top-right to select a scenario and product combination. Additionally, you can manually enter the required values using the search function.
Use the Product Filter field to filter on a specific product.
Inventory Status
In this section, you can filter statuses of inventory that are either in excess or falling short as per the demand forecast.
The parameters are shown in the Effective Parameters card. You can configure the parameters in the Edit Parameters card. When you update parameters, the new values are shown in the Effective Parameters card, and are applied globally.
| Parameter | Value |
| Excess Inventory Calculation Method | Select the excess inventory calculation method:
|
| Periods for Max/Min Inventory | Enter time periods to be considered for maximum/minimum inventory. |
| Excess check periods prior to shortfall | Enter a value for considering excess check periods prior to shortfall. |
The Shortfall by DC (U) table displays the insufficient inventory levels by week at each distribution center (DC).
| Parameter | Value |
| Shortfall (U) | Displays the total number of insufficient inventory in units at a distribution center. |
| Locations with Excess prior to shortfall | Count of locations that had excess of the inventory before reporting insufficiency. |
The Excess Inventory by DC (U) table displays the surplus stock quantities at distribution centers by week.
| Parameter | Value |
| In Period Excess (U) | Displays the total number of surplus stock in units at a location. |
Select a Time View Settings to focus on a specific timeframe.
| Parameter | Value |
| View Years History | This is the number of years history to view. If you enter more than the maximum history available, only the maximum available is shown. |
| View Period Type | View Period Type: This provides options to view planning periods as either:
|
Select a distribution center location in Select DC for Excess Inventory. The graph displays values for closing inventory, shortfall, and closing excess for the selected distribution center. Additionally, you can select a distribution center from the context selector at the bottom of the chart.
Steps
The card below Effective Parameters lists the count of changes that are pending to be processed for a product and location combination.
Select Process Supply Changes to synchronize all changes across the inventory planning app.
