This article may require copy editing for grammar, style, cohesion, tone, or spelling. (January 2008) |
Supply Chain forecasting
Understanding and predicting customer demand is vital to manufacturers and distributors to avoid stock-outs and maintain adequate inventory levels. While forecasts are never perfect, they are necessary to prepare for actual demand. In order to maintain an optimized inventory and effective supply chain, accurate demand forecasts are imperative.
Calculating the accuracy of supply chain forecasts
Forecast accuracy in the supply chain is typically measured using the Mean Absolute Percent Error or MAPE. However, there are confusions between the statistical definition of MAPE and its application among Supply Chain Planners. Statistically MAPE is defined as the average of percentage errors. Most practitioners however define and use the MAPE as the Mean Absolute Deviation divided by Average Sales. You can think of this as a volume weighted MAPE. In some references, this is also referred to as the MAD/Mean ratio.
Definition of forecast error
Demand Forecast Error is the deviation of the actual realized demand quantity from the Forecasted quantity. The denominator for the Error calculation has been debated in the literature as whether to use the acutal demand or the forecasted quantity.
We take absolute values of the error because the magnitude of the error is more important than the direction of the error. The Forecast Error can be bigger than Actual or Forecast but NOT both. Error above 100% implies a zero forecast accuracy or a very inaccurate forecast..
How do you define Forecast Accuracy?
The forecast error needs to be calculated on Actual as base. There are other alternate forms of forecast errors used namely Mean Percent Error, Root Mean Squared Error, Tracking Signal and Forecast Bias.
Simple methodology for MAPE
An alternate methodology to calculate forecast error is to add the sum of the absolute errors and divide by either the forecast or the realized quantity.