Stock Transaction Statistics calculated measures and KPIs

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

The expressions are based on sum aggregation. Global Stock Turnover and Local Stock Turnover measures use max aggregation in the expressions.

Measure	Description
Global Stock Turnover Qty	Sold quantity divided by the average on-hand balance multiplied by the number of manufacturing periods per year
Global Stock Turnover Value	Sold value divided by the average on-hand balance value multiplied by the number of manufacturing periods per year
Global Stock Turnover Weight	Sold weight divided by the average on-hand balance weight multiplied by the number of manufacturing periods per year
Local Stock Turnover Qty	Sold and used quantities divided by the average on-hand balance 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
Local Stock Turnover Weight	Sold and used weight divided by the average on-hand balance weight multiplied by the number of manufacturing periods per year
Mfd and Purch vs Plan Qty Pct
Mfd and Purch vs Plan Qty Var	Manufactured and purchased quantity minus the planned quantity
Mfd and Purch vs Plan Value Pct	Manufactured and purchased value divided by the planned value Manufactured and purchased quantity divided by the planned quantity
Mfd and Purch vs Plan Weight Pct	Manufactured and purchased weight divided by the planned weight
Mfd and Purch vs Plan Weight Var	Manufactured and purchased weight minus the planned weight
Neg Phys Inv vs OHB Qty Pct	Negative physical inventory variance quantity divided by the average on-hand balance
Neg Phys Inv vs OHB Value Pct	Negative physical inventory variance value divided by the average on-hand balance value
Neg Phys Inv vs OHB Weight Pct	Negative physical inventory variance weight divided by the average on-hand balance weight
Pos Phys Inv vs OHB Qty Pct	Positive physical inventory variance quantity divided by the average on-hand balance
Pos Phys Inv vs OHB Value Pct	Positive physical inventory variance value divided by the average on-hand balance value
Pos Phys Inv vs OHB Weight Pct	Positive physical inventory variance weight divided by the average on-hand balance weight
Scrap vs OHB Qty Pct	Scrapped quantity divided by the average on-hand balance
Scrap vs OHB Value Pct	Scrapped value divided by the average on-hand balance value
Scrap vs OHB Weight Pct	Scrapped weight divided by the average on-hand balance weight
Sold vs For Qty Pct	Sold quantity divided by the forecasted quantity
Sold vs For Qty Var	Sold quantity minus the forecasted quantity
Sold vs For Value Pct	Sold value divided by the forecasted value
Sold vs For Weight Pct	Sold weight divided by the forecasted weight
Sold vs For Weight Var	Sold weight minus the forecasted weight
Yearly Turnover Qty	Manufactured and purchased quantity divided by the Annual usage quantity divided by the average on-hand balance
Yearly Turnover Value	Annual usage value divided by the average on-hand balance value
Yearly Turnover Weight	Annual usage weight divided by the average on-hand balance weight