Measures for Inventory Rebalancing

This topic provides information about the measures that are used in inventory rebalancing for replenishment plans.

This table describes the predefined measures for inventory rebalancing:

Measure

Description

Supports Cluster Dimension?

Supports Product Dimension?

Supports Organization Dimension?

Supports Time Dimension?

Supports Source Dimension?

Planned Inbound Shipments

Total quantity of planned orders to be received at the destination location for an item after inventory rebalancing.

Yes

Yes

Yes

Yes

No

Planned Outbound Shipments

Total quantity of planned orders to be shipped from the source location for an item after inventory rebalancing.

Yes

Yes

Yes

Yes

No

Excess Before Rebalancing

Excess quantity before inventory rebalancing for an item-location combination. The measure may differ from the Initial Excess for Rebalancing measure if the item-location combination belongs to more than one cluster, and inventory rebalancing has previously been performed for the item-location combination in another cluster.

Yes

Yes

Yes

No

No

Excess After Rebalancing

Excess quantity after inventory rebalancing for an item-location combination.

Yes

Yes

Yes

No

No

Shortage Before Rebalancing

Shortage quantity before inventory rebalancing for an item-location combination. The measure may differ from the Initial Shortage for Rebalancing measure if the item-location combination belongs to more than one cluster, and inventory rebalancing has previously been performed for the item-location combination in another cluster.

Yes

Yes

Yes

No

No

Shortage After Rebalancing

Shortage quantity after inventory rebalancing for an item-location combination.

Yes

Yes

Yes

No

No

Initial Excess for Rebalancing

Excess quantity that's initially available for inventory rebalancing for an item-location combination.

The calculation of the measure is based on the Projected Inventory measure.

No

Yes

Yes

Yes

No

Initial Shortage for Rebalancing

Shortage quantity that's initially available for inventory rebalancing for an item-location combination.

The calculation of the measure is based on the Projected Inventory measure.

No

Yes

Yes

Yes

No

Total Rebalancing Recommendations

Number of planned orders recommended after inventory rebalancing for an item-location combination.

Yes

Yes

Yes

No

No

Rebalanced Inventory Value

Total value of planned orders recommended after inventory rebalancing. The measure is calculated for an item-location combination through multiplication of the quantity of planned orders by the standard cost of the item.

Yes

Yes

Yes

No

No

Projected Inventory

Inventory quantity projected in the future for an item-location combination on the basis of the selected supply types and demand types.

No

Yes

Yes

Yes

No

Excess Computation Window

Time window in days for calculation of the excess inventory for an item-location combination.

This measure is calculated by multiplying the lead time by the value in the Lead Time Multiplier for Excess Window field for a cluster on the Manage Planning Clusters page.

The lead time is the total of the preprocessing, processing, and postprocessing lead times that are specified for the item-location combination in the Items table.

Yes

Yes

Yes

No

No

Shortage Computation Window

Time window in days for calculation of the inventory shortage for an item-location combination.

This measure is calculated by multiplying the lead time by the value in the Lead Time Multiplier for Shortage Window field for a cluster on the Manage Planning Clusters page.

The lead time is the total of the preprocessing, processing, and postprocessing lead times that are specified for the item-location combination in the Items table.

Yes

Yes

Yes

No

No

Reserved Safety Stock

Portion of the safety stock that's reserved at the location for an item during the computation of the excess inventory.

No

Yes

Yes

Yes

No

Item Locations with Excess Before Rebalancing

Number of item-location combinations in a cluster with excess inventory before inventory rebalancing.

Yes

Yes

Yes

No

No

Item Locations with Excess After Rebalancing

Number of item-location combinations in a cluster with excess inventory after inventory rebalancing.

Yes

Yes

Yes

No

No

Item Locations with Shortage Before Rebalancing

Number of item-location combinations in a cluster with inventory shortage before inventory rebalancing.

Yes

Yes

Yes

No

No

Item Locations with Shortage After Rebalancing

Number of item-location combinations in a cluster with inventory shortage after inventory rebalancing.

Yes

Yes

Yes

No

No

Percentage of Item Locations with Excess Before Rebalancing

Percentage of item-location combinations in a cluster with excess inventory before inventory rebalancing.

Yes

Yes

Yes

No

No

Percentage of Item Locations with Excess After Rebalancing

Percentage of item-location combinations in a cluster with excess inventory after inventory rebalancing.

Yes

Yes

Yes

No

No

Percentage of Item Locations with Shortage Before Rebalancing

Percentage of item-location combinations in a cluster with inventory shortage before inventory rebalancing.

Yes

Yes

Yes

No

No

Percentage of Item Locations with Shortage After Rebalancing

Percentage of item-location combinations in a cluster with inventory shortage after inventory rebalancing.

Yes

Yes

Yes

No

No

Total Item Locations for Rebalancing

Number of item-location combinations in a cluster for inventory rebalancing.

Yes

Yes

Yes

No

No

Planned Shipments Quantity

Total quantity of planned orders to be shipped from the location for an item after inventory rebalancing.

The measure is functionally similar to the Planned Outbound Shipments measure, but has the Cluster, Organization, Product, and Source dimensions.

Yes

Yes

Yes

No

Yes

Planned Shipments Value

Total value of planned orders to be shipped from the location for an item after inventory rebalancing. The measure is calculated through multiplication of the Planned Shipments Quantity measure with the standard cost of the item.

The measure is functionally similar to the Rebalanced Inventory Value measure, but has the Cluster, Organization, Product, and Source dimensions.

Yes

Yes

Yes

No

Yes

All these measures are in the Inventory Analysis measure group.

You must add the Cluster and Source dimensions to the dimension catalog of the replenishment plan for which you've selected the Rebalance inventory check box on the Plan Options page.