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

Rate and mix decomposition of run minutes

Decompose the change in run minutes per order between the latest two years into within-work-centre rate and work-centre-mix effects. Retain work centres with orders in both years. Use prior-year shares for the rate effect and latest-year rates for the mix effect; reconcile both effects to the overall rate change.
Expected
Work-centre rates and order shares for both years, rate effect, mix effect, reconciliation · Forecast comparison
Tables
FactProductionTransactions, DimWorkCentre, DimDate · columns
  • FactProductionTransactions
  • DimWorkCentre
  • DimDate
  • RunMinutes
  • WorkCentreID
  • OrderID
  • 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.