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

Shipment forecast accuracy by depot

Measure shipment forecast accuracy by depot: for every depot-month with shipments, compute the absolute percentage error of the forecast against actual shipments, then the mean per depot. Identify the least accurate depot and the network mean, and explain why an error measured on shipments dispatched understates demand the fleet could not carry.
Expected
Depot-month forecast, actual, absolute percentage error; depot MAPE; network MAPE · Accuracy matrix
Tables
FactFleetTransactions, FactDemandForecast, DimDepot · columns
  • FactFleetTransactions
  • FactDemandForecast
  • DimDepot
  • OrderID
  • DepotID
  • ForecastShipments
  • 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.