World Library  
Flag as Inappropriate
Email this Article

Calculating Demand Forecast Accuracy

Article Id: WHEBN0004303969
Reproduction Date:

Title: Calculating Demand Forecast Accuracy  
Author: World Heritage Encyclopedia
Language: English
Subject: Supply chain management, Statistical forecasting, Tracking signal, Forecast error, Demand forecasting
Collection:
Publisher: World Heritage Encyclopedia
Publication
Date:
 

Calculating Demand Forecast Accuracy

Calculating demand forecast accuracy is the process of determining the accuracy of forecasts made regarding customer demand for a product.

Importance of forecasts

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. 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. This is in effect a volume weighted MAPE. This is also referred to as the MAD/Mean ratio.

A simpler and more elegant method to calculate MAPE across all the products forecasted is to divide the sum of the absolute deviations by the total sales of all products.

This calculation \sum{(|A - F|)}\over\sum{A}, where A is the actual value and F the forecast, is also known as WAPE, Weighted Absolute Percent Error. Another interesting option is the weighted MAPE = \frac{\sum(w\cdot|A-F|)}{\sum(w\cdot A)}. The advantage of this measure is that could weight errors, so you can define how to weight for your relevant business, ex gross profit or ABC. The only problem is that for seasonal products you will create and undefined result when sales = 0 and that is not symmetrical, that means that you can be much more unacurate if sales are higher than if they are lower than the forecast. So sMAPE is also used to correct this, it is known as symmetric Mean Absolute Percentage Error.

Last but not least, for intermittent demand patterns none of the above are really useful. So you can consider MASE (Mean Absolute Scaled Error) as a good KPI to use in those situations, the problem is that is not as intuitive as the ones mentioned before. You can find an interesting discussion here: http://datascienceassn.orgs/default/files/Another%20Look%20at%20Measures%20of%20Forecast%20Accuracy.pdf

Calculating forecast error

The forecast error needs to be calculated using actual sales as a base. There are several forms of forecast error calculation methods used, namely Mean Percent Error, Root Mean Squared Error, Tracking Signal and Forecast Bias..

See also

References

  • Hyndman, R.J., Koehler, A.B (2005) " Another look at measures of forecast accuracy", Monash University.
  • Hoover, Jim (2009) "How to Track Forecast Accuracy to Guide Process Improvement", Foresight: The International Journal of Applied Forecasting.

External links

  • Forecast Accuracy Calculations
This article was sourced from Creative Commons Attribution-ShareAlike License; additional terms may apply. World Heritage Encyclopedia content is assembled from numerous content providers, Open Access Publishing, and in compliance with The Fair Access to Science and Technology Research Act (FASTR), Wikimedia Foundation, Inc., Public Library of Science, The Encyclopedia of Life, Open Book Publishers (OBP), PubMed, U.S. National Library of Medicine, National Center for Biotechnology Information, U.S. National Library of Medicine, National Institutes of Health (NIH), U.S. Department of Health & Human Services, and USA.gov, which sources content from all federal, state, local, tribal, and territorial government publication portals (.gov, .mil, .edu). Funding for USA.gov and content contributors is made possible from the U.S. Congress, E-Government Act of 2002.
 
Crowd sourced content that is contributed to World Heritage Encyclopedia is peer reviewed and edited by our editorial staff to ensure quality scholarly research articles.
 
By using this site, you agree to the Terms of Use and Privacy Policy. World Heritage Encyclopedia™ is a registered trademark of the World Public Library Association, a non-profit organization.
 


Copyright © World Library Foundation. All rights reserved. eBooks from Project Gutenberg are sponsored by the World Library Foundation,
a 501c(4) Member's Support Non-Profit Organization, and is NOT affiliated with any governmental agency or department.