Skip to main content
DD-MFG-004 Manufacturing Network Performance and Capacity Planning Get the data →
DD-MFG-004-Q027 Hard Time series

Work centres driving change in cost variance

Which three work centres contributed most to the year-over-year change in cost variance in the latest year? Reconcile all work-centre changes to the plant total, using absolute changes rather than averaging growth rates.
Expected
WorkCentreID, prior, latest, absolute change; descending change then ID; reconciliation total · Variance bridge
Tables
FactProductionTransactions, DimWorkCentre, DimDate · columns
  • FactProductionTransactions
  • DimWorkCentre
  • DimDate
  • StandardCostSAR
  • ActualMaterialCostSAR
  • ActualLabourCostSAR
  • ActualOverheadCostSAR
  • WorkCentreID
  • StartDateKey
  • YearMonth

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in