Material Variances sourced measures and KPIs

This table shows the Material Variances measures that are sourced directly in Data Warehouse.

These measures can be analyzed by different time series. These time series are available:

  • Month Ago
  • Quarter Ago
  • Quarter-To-date
  • Trailing 12 Months
  • Trailing 3 Months
  • Year Ago
  • Year-To-date

Available aggregations for the measures are Avg, Max, Min, and Sum.

Measure Description
Actual Cost The actual cost of the material component in the division currency
Actual Qty Actual issued quantity for the material component in basic unit of measure
Actual vs Standard Cost Var Actual cost minus the standard cost
Actual vs Standard Qty Var Actual quantity minus the standard quantity
Scrap Value Value of the total scrapped quantity for the material component
Standard Cost The total standard cost of the material component in the division currency
Standard Qty Standard issued quantity for the material component in basic unit of measure
Total Cost Var Sum of the variance cost from internal accounting entries and variance between standard and actual costs
Total Qty Var Sum of the variance quantity from internal accounting entries and variance between standard and actual issued quantities
Variance Cost – Internal Acctg Recorded amount of internal accounting entries with event MM10, MM20, and MM30 of type 910
Variance Qty – Internal Acctg Recorded quantity of internal accounting entries with event MM10, MM20, and MM30 of type 910