Stock Statistics calculated measures and KPIs

This table shows the Stock Statistics measures that are calculated and defined as saved expressions.

The saved expressions use the Statistics Period Date and Sum aggregation.

Quantity

Measure Description
Pos Phys Inv Qty vs OHB Qty Pct Positive physical inventory variance quantity divided by the average on-hand balance quantity
Neg Phys Inv vs OHB Qty Pct Negative physical inventory variance quantity divided by the average on-hand balance quantity
Scrap vs OHB Qty Pct Scrapped quantity divided by the average on-hand balance quantity
Mfd and Purch vs Plan Qty Pct Manufactured and purchased quantity divided by the planned quantity
Sold vs FC Qty Pct Sold quantity divided by the forecasted quantity
Global Stock Turnover Qty Sold quantity divided by the average on-hand balance quantity multiplied by the number of manufacturing periods per year
Local Stock Turnover Qty Sold and used quantity divided by the average on-hand balance quantity multiplied by the number of manufacturing periods per year
Stock Change Qty Pct Closing balance quantity minus the opening balance quantity divided by absolute value of opening balance quantity

Net Weight

Measure Description
Pos Phys Inv Net Weight vs OHB Qty Pct Positive physical inventory variance net weight divided by the average on-hand balance net weight
Neg Phys Inv Net Weight vs OHB Qty Pct Negative physical inventory variance net weight divided by the average on-hand balance net weight
Scrap vs OHB Net Weight Pct Scrapped net weight divided by the average on-hand balance net weight
Mfd and Purch vs Plan Net Weight Pct Manufactured and purchased net weight divided by the planned net weight
Sold vs FC Net Weight Pct Sold net weight divided by the forecasted net weight
Global Stock Turnover Net Weight Sold net weight divided by the average on-hand balance net weight multiplied by the number of manufacturing periods per year
Local Stock Turnover Net Weight Sold and used net weight divided by the average on-hand balance net weight multiplied by the number of manufacturing periods per year
Stock Change Net Weight Pct Closing balance net weight minus the opening balance net weight divided by absolute value of opening balance net weight

Gross Weight

Measure Description
Pos Phys Inv Gross Weight vs OHB Qty Pct Positive physical inventory variance gross weight divided by the average on-hand balance gross weight
Neg Phys Inv Gross Weight vs OHB Qty Pct Negative physical inventory variance gross weight divided by the average on-hand balance gross weight
Scrap vs OHB Gross Weight Pct Scrapped gross weight divided by the average on-hand balance gross weight
Mfd and Purch vs Plan Gross Weight Pct Manufactured and purchased gross weight divided by the planned gross weight
Sold vs FC Gross Weight Pct Sold gross weight divided by the forecasted gross weight
Global Stock Turnover Gross Weight Sold gross weight divided by the average on-hand balance gross weight multiplied by the number of manufacturing periods per year
Local Stock Turnover Gross Weight Sold and used gross weight divided by the average on-hand balance gross weight multiplied by the number of manufacturing periods per year
Stock Change Gross Weight Pct Closing balance gross weight minus the opening balance gross weight divided by absolute value of opening balance gross weight

Volume

Measure Description
Pos Phys Inv Volume vs OHB Qty Pct Positive physical inventory variance volume divided by the average on-hand balance volume
Neg Phys Inv Volume vs OHB Qty Pct Negative physical inventory variance volume divided by the average on-hand balance volume
Scrap vs OHB Volume Pct Scrapped volume divided by the average on-hand balance volume
Mfd and Purch vs Plan Volume Pct Manufactured and purchased volume divided by the planned volume
Sold vs FC Volume Pct Sold volume divided by the forcasted volume
Global Stock Turnover Volume Sold volume divided by the average on-hand balance volume multiplied by the number of manufacturing periods per year
Local Stock Turnover Volume Sold and used volume divided by the average on-hand balance volume multiplied by the number of manufacturing periods per year
Stock Change Volume Pct Closing balance volume minus the opening balance volume divided by absolute value of opening balance volume

Value

Measure Description
Pos Phys Inv vs OHB Value Pct Positive physical inventory variance value divided by the average on-hand balance value
Neg Phys Inv vs OHB Value Pct Negative physical inventory variance value divided by the average on-hand balance value
Scrap vs OHB Value Pct Scrapped value divided by the average on-hand balance value
Mfd and Purch vs Plan Value Pct Manufactured and purchased value divided by the planned value
Sold vs FC Value Pct Sold value divided by the forecasted value
Global Stock Turnover Value Sold value divided by the average on-hand balance value multiplied by the number of manufacturing periods per year
Local Stock Turnover Value Sold and used values divided by the average on-hand balance value multiplied by the number of manufacturing periods per year