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

Work centres explaining 80% of growth in produced quantity

For latest-year growth in produced quantity, identify the smallest set of work centres explaining at least 80% of positive growth. Exclude declines from the denominator, show their combined decline separately, and reconcile to net growth.
Expected
Sorted positive work-centre changes, cumulative positive share, cutoff set, decline total, net change · Variance bridge
Tables
FactProductionTransactions, DimWorkCentre, DimDate · columns
  • FactProductionTransactions
  • DimWorkCentre
  • DimDate
  • ProducedQty
  • 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.