Glossary of IPO Terms
This table provides definitions for many of the terms that are used in the IPO tables in the UI.
Table 1-2 IPO Term Definitions
| Term | Definition |
|---|---|
|
Activate Date |
For seasonal items and items with a short life cycle, the activate date indicates the date that a given item/location should be considered for replenishment. |
|
Actual Sales Units W-1 |
Actual sales unit for a given item/location during the last calendar week prior to the date that the inventory optimization ran. |
|
Actual Sales Units W-2 |
Actual sales unit for a given item/location during the last two calendar weeks prior to the date that the inventory optimization ran. |
|
Actual Sales Units W-3 |
Actual sales unit for a given item/location during the last three calendar weeks prior to the date that the inventory optimization ran. |
|
Actual Sales Units W-4 |
Actual sales unit for a given item/location during the last four calendar week prior to the date that the inventory optimization ran. |
| Allocation Name |
A user-defined name given to a manual allocation for easy identification and tracking within the system. |
|
Back-order Qty at Dest. |
The back-order quantity at the destination location for a given item. |
|
Back-order Qty at Origin |
The back-order quantity at the origin location for a given item. This field will be blank for a PO because the origin is a supplier. |
| Calculation Status |
A system-generated status that indicates the current state of the allocation's quantity calculation. Common statuses include 'Not Calculated', 'Calculating', 'Calculated', and 'Calculation Error'. |
| Coverage Per. End DT | Coverage period end date, that is lead time plus review time after recommendation date. |
| Coverage Per. Start DT | Coverage period start date, that is lead time after recommendation date. |
|
Deactivate Date |
For seasonal items and items with a short life cycle, the deactivate date indicates the date that a given item/location should be stopped being considered for replenishment. |
| Demand Source |
A policy setting within a manual allocation that defines the source of demand data (for example, Forecast, Sales Plan) used to calculate the gross need at each destination. |
| Fcst. Coverage Per. | Forecast sales units for the coverage period. |
| Fcst. LT | Forecast sales unit for the period of lead time. |
|
Fcst. Sales Units W+0 |
Forecast sales unit for the current week. |
|
Fcst. Sales Units W+1 |
Forecast sales unit for the next week. |
| Gross Need |
The total, unconstrained demand for an item at a destination location, calculated based on the selected Demand Source and date range, before considering any existing inventory. |
| Holdback Stock |
A specific quantity of inventory at a warehouse that is intentionally withheld from the general inventory pool to support strategic initiatives. |
| Holdback Stock at Dest |
The Holdback Stock quantity of the destination for a specific SKU. |
| Holdback Stock at Origin |
The Holdback Stock quantity of the source warehouse for a specific destination and SKU. |
|
In-transit Qty at Dest. |
The in-transit inventory for the destination location for a given item. |
|
In-transit Qty at Origin |
The in-transit inventory for the origin location for a given item. This field will be blank for a PO because the origin is a supplier. |
|
Lead Time |
The expected number of days required to move the item from the primary source to the destination location. |
|
Loc. Type |
Location type can be Store or Warehouse. |
| Manual Qty |
A user-entered value in the allocation results screen that overrides the system-calculated quantity. This allows the allocator to make final adjustments to the distribution plan based on business knowledge. |
| Net Need |
The calculated inventory required at a destination after accounting for existing and in-transit stock. It is typically calculated as 'Gross Need' minus the relevant on-hand inventory positions. |
|
Next Review Date |
For a given item/location, the next review date is the date that the item is going to be reviewed for replenishment based on its review schedule. |
|
OH Qty at Dest. |
The on-hand inventory at the destination location for a given item. |
|
OH Qty at Origin |
The on-hand inventory at the origin location for a given item. This field will be blank for a PO because the origin is a supplier. |
|
On-order Qty at Dest. |
The on-order inventory at the destination location for a given item. |
|
On-order Qty at Origin |
The on-order inventory at the origin location for a given item. This field will be blank for a PO because the origin is a supplier. |
|
Pack Allocation Tuning Objective |
A setting for Multi-Size Packs that guides how the system assigns packs when a perfect match to the size-level need is not possible. Options include: 'Balance over and under-allocation', 'Over-allocate is preferred', and 'Under-allocate is preferred'. |
| Pack Fill Rate % |
The percentage of a pack's total component quantity that is consumed by a store's unfulfilled need. This metric is used to find the best-fitting packs, with 100% being an ideal match. |
| Preferred Pack |
An optional parameter that instructs the system to prioritize a specific Pack ID when calculating the unconstrained need for a Multi-Size Pack. |
|
Primary Source |
The primary source of replenishment for a given item/location. If the item/location has a stock category of warehouse-stocked (or cross-docked), the primary source will indicate the warehouse from which (through which) the item will be sourced. If the item has a stock category of direct to store/warehouse, the primary source will indicate the supplier. |
|
Replenishment Method |
The method that was used in calculating the RP/RUTL. |
| Worksheet |
The status of a manual allocation that has been saved as a draft but not yet approved. Allocations in a 'Worksheet' status can be opened and edited at any time. |
|
Review Time |
Number of days between the day that the inventory optimization runs and the next time that a given item/location is scheduled for review. For example, if an item/location has a daily review schedule, the review time will be one day. |
|
RP (Re-order Point) |
Level of inventory that is used as a threshold to recommend an order. |
|
RUTL (Receive Up-to Level) |
When the inventory level falls below the re-order point, an order is recommended to raise inventory to this level. |
|
System Order Qty |
The recommended order quantity for a PO/Transfer. The system order quantity is calculated by the optimization algorithm and is the quantity that takes into account all constraints such as RP, RUTL, space capacity, and available supply at the origin. |
|
Target Service Level |
This is the value of the service level that is used in the safety stock calculation. Service Level is defined as the percentage of unit demand that should be met by inventory. Valid values are between 0 and 1. For example, a service level of 0.9 indicates that RP and RUTL should be optimized such that on average 90% of the demand is met. |
|
Unconst. Need |
The unconstrained need is the quantity that is required to bring the inventory up to the RUTL. It does not take into account the shelf space capacity and the potential shortage of supply at the origin. |
|
User Order Qty |
This is the user override for the quantity of the recommended PO or transfer order. |