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

Machine capacity utilisation by plant

Compare machine run hours with available machine hours by plant and month. Identify the highest utilisation, calculate unused hours, and explain why availability is a planning ceiling rather than hours worked. Resolve ties by earliest month then lowest PlantID.
Expected
Plant-month run hours, available hours, utilisation, unused hours · Variance matrix
Tables
FactProductionTransactions, FactCapacityDaily, DimPlant, DimDate · columns
  • FactProductionTransactions
  • FactCapacityDaily
  • DimPlant
  • DimDate
  • RunMinutes
  • PlantID
  • AvailableMachineHours
  • CapacityDateKey
  • 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.