Planning:

» Budgeting

» S&OP

Metrics:

» Demand Metrics

» Inventory

» Customer Service

Collaboration:

» VMI & CMI

» ABF

Forecasting:

» Causal Modeling

» Market Modeling

» Ship to Share

For Students

MAPE stands for Mean Absolute Percent Error - Bias refers to persistent forecast error - Bias is a component of total calculated forecast error - Bias refers to consistent under-forecasting or over-forecasting - MAPE can be misinterpreted and miscalculated, so use caution in the interpretation.

Accurate and timely demand plans are a vital component of a manufacturing supply chain. Inaccurate demand forecasts typically would result in supply imbalances when it comes to meeting customer demand. Forecast accuracy at the SKU level is critical for proper allocation of resources.

When we talk about forecast accuracy in the supply chain, we typically have one measure in mind namely, the Mean Absolute Percent Error or MAPE. However, there is a lot of confusion between Academic Statisticians and corporate Supply Chain Planners in interpreting this metric. Most academics define MAPE as an average of percentage errors over a number of products. Whether it is erroneous is subject to debate. However, this interpretation of MAPE is useless from a manufacturing supply chain perspective. The following is a discussion of forecast error and an elegant method to calculate meaningful MAPE.

Forecast Error is the deviation of the Actual from the forecasted quantity.

- Error = absolute value of {(Actual – Forecast) = |(A - F)|
- Error (%) = |(A – F)|/A

We take absolute values 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.

- Error close to 0% => Increasing forecast accuracy
- Forecast Accuracy is the converse of Error
- Accuracy (%) = 1 – Error (%)

**What is the impact of Large Forecast Errors? Is Negative accuracy
meaningful?**

Regardless of huge errors, and errors much higher than 100% of the
Actuals or Forecast, we interpret accuracy a number between 0% and
100%. Either a forecast is perfect or relative accurate or inaccurate
or just plain incorrect. So we constrain Accuracy to be between
0 and 100%.

More formally, Forecast Accuracy is a measure of how close the actuals are to the forecasted quantity.

- If actual quantity is identical to Forecast => 100% Accuracy
- Error > 100% => 0% Accuracy
- More Rigorously, Accuracy = maximum of (1 – Error, 0)

Sku A | Sku B | Sku X | Sku Y | |

Forecast | 75 | 0 | 25 | 75 |

Actual | 25 | 50 | 75 | 74 |

Error | 50 | 50 | 50 | 1 |

Error (%) | 200% | 100% | 67% | 1% |

Accuracy (%) | 0% | 0% | 33% | 99% |

This is a simple but Intuitive Method to calculate MAPE.

- Add all the absolute errors across all items, call this A
- Add all the actual (or forecast) quantities across all items, call this B
- Divide A by B
- MAPE is the Sum of all Errors divided by the sum of Actual (or forecast)

Click to download Tracking and Measurement of Forecast Accuracy and Safety Stock PDF

©2004-2019. by Demand Planning, LLC. All rights reserved. Privacy
policy | Refund and Exchange policy
| Terms of Service | FAQ

Demand Planning, LLC is based in Boston, MA , USA| Phone: (781) 995-0685 | Email us!

Diagnostic | DP Design | Exception Management | S&OP | Solutions