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

Demand forecast accuracy by plant

Measure demand forecast accuracy by plant: for every plant-month with output, compute the absolute percentage error of the forecast against produced quantity, then the mean per plant. Identify the least accurate plant and the network mean, and explain why an error measured on produced quantity understates unmet demand.
Expected
Plant-month forecast, actual, absolute percentage error; plant MAPE; network MAPE · Accuracy matrix
Tables
FactProductionTransactions, FactDemandForecast, DimPlant · columns
  • FactProductionTransactions
  • FactDemandForecast
  • DimPlant
  • ProducedQty
  • PlantID
  • ForecastQty
  • ForecastDateKey

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.