Glossary of IPO-IO Terms

This table provides definitions for many of the terms that are used in the IPO-IO tables in the UI.

Table 1-2 IPO-IO 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.

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.

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.

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.

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.

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.

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.

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.