1 Inventory Planning Optimization-Plan View Navigation and Controls
This guide describes the use of Inventory Planning Optimization-Inventory Planning (IPO-IP). For details about the implementation of IPO-IO, see Oracle Retail AI Foundation Cloud Services Implementation Guide.
Launching the Application
-
Open Retail Home.
-
Click Application Navigator, located in the left menu.
-
Click Inventory Planning.
Figure 1-1 Launching Inventory Planning
Overview
The retailer's most significant investment is the retailer’s inventory. Inventory Planning Optimization Cloud Service (IPO) offers the retailer the ability to best predict how much demand there will be and to deploy the inventory to optimize the demand throughout the course of an item's life cycle. Throughout an item’s life cycle, the application reacts to changes in consumer behavior in order to right size inventory deployment and demand methodologies. The end result allows the retailer to manage the current and future inventory at scale to ensure the right products and quantiles are in the right place for the right customers at the right time, in an automated and intelligent way, via the user interface.
Inventory Planning allows the user to view a Forecast Plan, which displays a set of products that are stocked at a set of locations during a specific time frame. Any alerts that occur during this period are highlighted. The user can then make tactical policy overrides that can then affect any future stock forecasts.
Main Filter
Use the Main filter to restrict the scope of the Plan View to a subset of products and locations.
Figure 1-2 Filter Button
The Main Filter provides a launching area providing access to the Product and Locations filters and the sub-filter Purchase Orders.
Figure 1-3 Filter Panel Card 
Products Filter
The Products filter is used to select those products that must be included in the Plan View.
Selection can occur at the individual product level or by selecting a higher level in the tree that includes all products below it at lower levels. Higher level selections are retained so that when you re-enter Inventory Planning your view will refresh to include any newly introduced products. For example, if you select a subclass, then three new products are set up on replenishment. When the products are visible to Inventory Planning, the view can be refreshed to see the additional products with no further filter selection required.
You can enter text in the Filter field at the top of the Products filter to reduce the list to those that contain that text.
Buttons are provided above the data to Select/Deselect All, Collapse/Expand All, and Show Selected/All.
Figure 1-4 Products Filter
Locations Filter
Use the Locations filter to select those locations that must be included on the Plan View.
Selection can occur at the individual Store or Warehouse level or by selecting a higher level in the tree that includes all locations below it at lower levels. Higher level selections are retained so that when you re-enter Inventory Planning your view will refresh to include any newly introduced locations. For example, if you select a district, then three new stores are set up on replenishment. When the stores are visible to Inventory Planning, the view can be refreshed to see the additional stores with no further filter selection required.
You can enter text in the Filter field at the top of the Locations filter to reduce the list to those that contain that text.
Buttons are provided above the data to Select/Deselect All, Collapse/Expand All and Show Selected/All.
The Select All button selects all visible entries, so it is the most useful after entering search text.
Figure 1-5 Locations Filter
Purchase Orders
Use the Purchase Orders sub-filter to select purchase orders whose products and locations will be included on the Main filter.
Enter text in the Filter field at the top of the Purchase Orders filter to reduce the list to those that contain the specified text.
Buttons are provided above the data to Select/Deselect All and Show Selected/All.
Use Select All to select all visible entries. This is most useful after entering search text.
Use Apply a Purchase Order to automatically select the related products and locations on the Main Filter.
Figure 1-6 Purchase Orders
If a purchase order has been selected, and then additional products or locations are selected, then a Resync message will be displayed on the Main Filter.
If this is not what you intended, click Resync to Filters to reset both products and locations to those matching the purchase order selections.
Figure 1-7 Resync to Filters
Saving Your Filters
The entire set of filter selections can be stored for later retrieval. This is useful for creating watch lists of top items, bottom items, new locations, new product introductions, and so on.
To save a filter, enter a name into the Saved Filters field, then click the Save button.
Previously saved filter sets can be selected from the drop-down list. This will reload those saved filter selections in the Main Filter.
Figure 1-8 Saved Filters
Plan View
The Plan View displays information about a chosen product for a set of included locations over a time frame.
The scope of the Plan View can be adjusted using the Main Filter.
Figure 1-9 Plan View
Time Frame
The time frame of the Plan View can be set using the From and To date fields at the top.
Select Daily to display each individual day in the plan; select Weekly to show information for each week.
Figure 1-10 Time Frame
Cycle Area
The Plan View focuses on one product at any time. You can use the Cycle Area to traverse through the individual products that are included in the filter selection.
The product that is currently in focus is shown on the top left of the Plan View, along with how many of the included locations replenish it.
Figure 1-11 Current Product in Focus
Figure 1-12 Cycle Area
Click the Product Selection control (to the left of the arrow buttons) to display a list of products to select from. Use the search filter at the top to reduce the product list to those that contain the search term.
Figure 1-13 Product Selection
Chart
The chart area shows aggregate store information that is based upon the scope of the Plan View (Filter Selection and Time Frame).
The chart is unaffected by the Edit Metrics selection.
Figure 1-14 Plan Chart
Edit Metrics
Use the Edit Metrics button to control which metrics rows appear in the Plan View tables.
Figure 1-15 Edit Metrics
Click the Edit Metrics button to display the Edit Metrics panel where you can select metrics.
For each metric, the aggregation method is shown beneath the metric name. Some metrics do not have an aggregation method and will not appear in the aggregate area tables.
Figure 1-16 Metrics Selection
Metrics
-
The Promotions metric shows the number of promotions for that time period.
-
The Override metric shows a disc at the start of any period indicating that an override has been specified by any user in Inventory Planning.
-
Definitions of the other standard metrics are included in the Inventory Planning glossary.
All Locations Table
The All Locations table aggregates data from the individual locations to display a summarized, supply chain view. As with the rest of the Plan View, this area restricts information to those locations included in the filter that replenish the product currently in focus. Only metrics related to inventory, demand, and order quantities are shown in the aggregate table. Safety stock and other target stock level metrics are reviewed in the individual location tables.
-
Supplier
-
Warehouses
-
Store
Data for the selected metrics will be shown in the tables either for each day (if Daily is selected) or each business week (if Weekly is selected).
Figure 1-17 Aggregate Area
Suppliers
The Supplier tab displays information about those suppliers that provide the product into the supply chain.
Warehouses
The Warehouse tabs displays information about those warehouses that handle the product for all the included stores. If the product passes through multiple warehouses on the way to the store, then multiple warehouse tabs will be displayed.
As this is the aggregate area, information about all warehouses listed in any individual table is combined into this table. Not all metrics apply at the Warehouse level. These metrics will not be displayed in this area.
Click a cell or the column header to open the Advanced Options (AO) panel for all the locations listed in the table for that week.
Stores
The Stores tabs show information about those stores that replenish the product.
As this is an aggregate area, information about all stores listed in any individual table are combined into this table.
Click the table data to open the AO Panel for all the locations listed in the table for that week.
No Data to Display
Each metric is only relevant at specific supply chain levels. If a product is stocked at a supply chain level but no relevant metrics are selected, then the message No Data to Display will be shown.
Figure 1-18 No Data to Display
All Locations Table Alerts
-
An up arrow will be displayed for an Overstock Alert.
-
A down arrow will be displayed for a Low Stock or Out of Stock Alert.
-
A double ended arrow will be displayed if both up and down can be shown.
Figure 1-19 Table Alerts Icons
Individual Locations Table
A table is displayed for each of the lowest level replenished locations (typically a store) that fall within the filter criteria. The primary supply chain into that location is also shown so that you can review the order projections and inventory levels throughout. The tables share a common layout to the All Locations table, including access to the supply chain. See All Locations Table.
Click the table data to open the AO Panel for all the locations listed in the table for the week that was selected.
Figure 1-20 Individual Area
Promotion Details
When a promotion exists, then a Promotions disc is shown above that time slot in the chart.
To view information about promotions, click the Promotions disc.
Figure 1-21 Promotions Discs
Any promotions that overlap with that time will be shown in a panel on the right.
Each promotion will also display its offers and their details.
Click the Details button (located on the right of the header) to show or hide the Promotions panel.
Figure 1-22 Promotions Details
Advanced Options Panel
Use the Advanced Options (AO) panel to create and modify policy overrides and review alert details. The AO panel always displays data based on the entire week of the cell that you selected to launch it; as well as the locations from the table selected to launch it.
Figure 1-23 AO Panel
Policies Tab
The Policies tab displays all policies that are defined in the Strategies application for the product, selected week, and locations, as set by the Level and Location field.
Level and Location
The Level and Location fields permit navigation up and down the supply chain for the product and selected week.
The Level field provides selection of the supply chain tier, for example, Warehouses or Stores.
You can select an individual or all of the locations within the selected level in the Location field. The location selection field is used to not only view policies but also to define the locations to which a policy edit will apply.
Figure 1-24 Level and Location Fields
Policy Table
Each policy type (as defined in the Strategies application) will have a card on the Policies tab.
If policy types are defined or overridden, then they are displayed in a table. If none are defined, then an Override button is still available.
| Columns | Explanation |
|---|---|
| Stores/Warehouses | The locations that have defined policies. |
| Data Range | The dates for when the policy applies. Note that it is possible to not specify an end date if the policy is continual. |
| Policy Values | One column is provided for each field that is part of the policy (e.g., Presentation Stock). |
Policies from the Strategies Application
All data directly from the Strategies application are displayed within the white Default Strategy tables.
Override
Use the Override button to input new policy overrides for the locations selected in the Locations field.
Click the Override button to display an edit area.
Figure 1-27 Override Button
- Policy Fields: Fields that can each be altered.
- Start Date: The first date of the alteration.
- Specify End Date: A switch that allows no end date to be specified.
- End Date: The last date of the alteration (not displayed if the Specify End Date is toggled off).
All alterations must overlap with the AO Panel's Selected Week.
-
Before creating the override, refine the set of stores receiving the override by setting the Inventory Plan View filters to the desired stores.
-
Launch the AO panel from the All Stores table.
-
Select All Stores in the Location field.
-
On the policy type to be overridden, click Override.
-
Fill in the field level changes.
-
Click Apply. Once an override is created it must be published before it will be effective in the inventory plan calculation.
Figure 1-28 Edit Area
Alerts Tab
The Alerts tab provides the details of each location’s alert in terms of retail value, units, and duration. Use the detailed information to help determine where stock might be moved from and to in order to minimize stock issues.
Figure 1-29 Alerts Tab
AO Panel Main Buttons
The main set of buttons are positioned at the bottom of the AO Panel. These perform operations upon the entire AO Panel.
Figure 1-30 AO Panel Buttons
Clear
Click the Clear button at the bottom of the AO Panel to clear all data from the tables on the AO Panel.
Only data after today's date is cleared.
Note that all alterations will be lost unless either the Publish or Generate Preview buttons are used.
Publish
When you use the Publish button, all alterations on the AO Panel will be used to adjust the plan.
This sends all AO Panel alterations to the Science application for integration into the plan.
A notification is created when any Publish action is completed or fails.
Generate Preview
When you use the Generate Preview Publish button, all alterations on the AO Panel are used to create a preview. The preview displays what will happen to the plan if the alterations are made.
This sends all AO Panel alterations to the Science application for the calculation of the preview.
A notification is created when any preview creation completes or fails.
Preview
A Preview displays a what if scenario, based upon the application of a set of alterations from an AO Panel to the plan.
Use the Preview Success Notification to open a preview.
A preview is based upon a single product for a set of locations; it opens in a new tab within the IP application.
-
Aggregate chart
-
Aggregate area with supply chain navigation
-
Individual area with supply chain navigation
-
Promotions
-
Edit metrics
Figure 1-31 Preview
Preview Main Buttons
A set of buttons are positioned at the bottom of the Preview. These perform operations upon the entire Preview.
Figure 1-32 Preview Buttons
Publish
When you use the Publish button, all alterations from the original AO Panel are used to adjust the current plan.
All the alterations to the Science application for integration into the plan.
A notification is created when the action is complete.
Update Preview
Click the Update Preview button to resend the alterations that you used to make this preview in order to understand how this affects the current plan.
This is useful if changes have occurred since the preview was created and the information must be refreshed.
A new preview will be created to replace the existing one and can be opened using its Preview Ready notification.
Notifications
When the application performs an asynchronous operation that may take some time, it often creates a notification when it successfully completes or fails.
-
Publish Completed. A publish operation has successfully completed.
-
Review Ready. A preview has successfully completed its calculations and is ready to be viewed. The notification is informational. Use the Previews button to reveal a list of previews to select for viewing.
-
Failure. Failure notifications are created when something errors during the calculation process. These often include the functionality that when clicked they retry the failed operation again.
Notifications Table
When you display the list of notifications in the left navigator, you can click See All (located at the bottom of the Notifications panel) to see the Notifications table. This provides a full list of the current notifications as well as further details.
Figure 1-33 Notifications Table
Glossary of Inventory Planning Terms
| Term | Definition |
|---|---|
| Alert | Alerts are defined in the Strategies application. Each Alert has trigger conditions (e.g., stock level dropping below a threshold) that also includes the set of products and locations to which it applies. See Strategies User Guide for further details. |
| AO Panel | The abbreviation for the Advanced Options Panel. |
| Average Service Level | The average of the service levels during the selected week. |
| Backorder | Inventory that was already sold but could not be fulfilled due to there being no physical inventory at the time of sale. |
| Constrained Demand | Total constrained demand used by the Distribution Engine to calculate inventory positions (and order boundaries within lead time). For stores this is the forecast demand. For warehouses this is constrained demand from destinations. |
| Demand | The total amount of forecasted demand. |
| Demo Stock | Stock that cannot be sold. |
| Filter Selection | The Main filter allows the scope of the Plan View to be restricted to a subset of products and locations. This is also known as the Filter Selection. |
| Inventory (BOP) | Beginning of day inventory at a location. It is Stock on Hand, or yesterday's Inventory (BOP) + all inbounds yesterday - all demands yesterday. Inventory is never negative. |
| Lost Sales | day's inventory + inbound available - demand |
| Lost Sales % of Demand | Lost Sales / Total Demand |
| Order Forecast | Constrained demand on source (including supplier). Calculated based on the (constrained) Receipt Forecast, the Order Forecast shows when users can expect their transaction to be generated. |
| Order Point (OP) | Order Point. |
| Order Up To Level (OUTL) | Order up to level. |
| Plan View Scope | The filter selection and the time frame that restrict the results on the Plan View. |
| Presentation Stock | Input to Replenishment engine from strategies/RMS. |
| Receipts Expected | On-Order Inventory at the destination location shown on the day that it should arrive. |
| Receipts Forecast | Forecasted Inventory that is constrained by the Order and Distribution Plan. This inventory does not live on a transaction yet. The Forecasted Receipts are shown on the day that they should arrive at the destination location. |
| Safety Stock | Based on the identified need and the volatility in sales for this is additional units that are needed to ensure lost sales do not occur. |
| Safety Stock % of Demand | Safety stock units as a % of demand (total demand) over review time. |
| Selected Week | This is the week that the AO Panel is focused upon. The AO Panel always displays data based upon the entire week of the cell that was selected to launch it. |
| Time Frame | The period between the from and to dates. These are shown at the top of the Plan View. |
| Total Demand | Total or all unconstrained demand used by the Distribution Engine to calculate safety stock and order boundaries. |