Calculating Forecast Accuracy & Forecast Error

Calculating Forecast Accuracy & Forecast Error

Mark Chapman

3 min read


The Importance of Demand Forecasting Accuracy

In supply chain management it’s important to be able to measure the accuracy of your demand forecasts. Inaccurate demand forecasting can lead to the accumulation of excess stock or the reverse: issues with product availability. Both are unwelcome problems for inventory planners!

Ensuring demand forecasting accuracy should be a key responsibility for any conscientious inventory planner. In sum, accurate demand forecasting helps you:

  • Improve customer satisfaction – Customers have zero tolerance for out of stock scenarios. Ensuring product availability keeps positive reviews flowing.
  • Optimize inventory levels – Setting safety stock levels based on accurate forecasts will prevent stock-outs without holding excess stock.
  • Manage supplier lead times – By giving suppliers a forecast of your annual inventory needs, they can plan to meet your delivery deadlines.
  • Prevent lost revenue – Stock-out scenarios lead to lost sales, not only for that product, but for companion items too.

What is Forecast Error?

One way to check the quality of your demand forecast is to calculate its forecast error. Forecast error is the deviation of the actual demand from the forecasted demand. If you can calculate the level of error in your previous demand forecasts, you can factor this into future ones and make the relevant adjustments to your planning.

Calculating forecast error

In this post we show you how to measure the accuracy of your forecasts by calculating forecast error and then discuss why it’s important to make this a habit.

 

Forecast Accuracy/Forecast Error Calculations

There are a number of formulas that inventory planners can use to calculate forecast accuracy/forecast error, from the fairly simple to the quite complex. Two of the most common forecast accuracy/error calculations include MAPE – the Mean Absolute Percent Error and MAD – the Mean Absolute Deviation.

Let’s take a closer look at both:

A fairly simple way to calculate forecast error is to find the Mean Absolute Percent Error (MAPE) of your forecast. Statistically MAPE is defined as the average of percentage errors.

1. MAPE formula

The MAPE formula consists of two parts: M and APE. The formula for APE is:

 

APE calculation

You then calculate the mean of all percentage errors over a given time period.

 

MAPE forecast error calculation

 

Since MAPE is a measure of error, high numbers are bad and low numbers are good.

2. MAD formula

Another common way to work out forecast error is to calculate the Mean Absolute Deviation (MAD). This shows the deviation of forecasted demand from actual demand in units. It takes the absolute value of forecast errors and averages them over the forecasted time periods.

 

MAD forecast accuracy calculation

 

There’s a wealth of further forecast accuracy calculations that can be used to work out forecast error. Make sure you find the most appropriate method for your needs, as it’s important to understand how accurate your forecasting is for a number of reasons, which we’ll get into now.

The Role of Improving Forecasting Accuracy

Once you have your forecast error calculations, you need to ensure you act on the data. Smart inventory planners will use their forecast error stats to refine their inventory purchasing and planning processes.

Here are a number of ways this can be done:

1. Mitigate the risk of future forecasting accuracy: The forecast error calculation provides a quantitative estimate of the quality of your past forecasts. If you can calculate the level of error in your previous demand forecasts, you can factor this risk into future forecasts. If you can determine how uncertain a forecast is for a given future business period, you can make the necessary adjustments to your inventory management rules, such as increasing safety stock levels and adjusting reorder points to cover the uncertain periods of demand.

2. Prioritize questionable forecasts: Identifying and prioritizing products with a high forecast error allows to you give them dedicated attention. You can closely monitor their future demand and adjust stock levels accordingly.

3. Refine and improve forecast accuracy: If you consistently see high forecasting error rates this is an indication that the demand forecasting technique you’re using needs to be reviewed and improved.

 

Have the Hard Work Done for You

Some Enterprise Resource Planning (ERP) and Warehouse Management Systems (WMS) will have the functionality to automatically calculate demand forecasting errors. But beware; every system will have a different level of complexity, so be sure to understand yours and account for its limitations. For example, is your system interrogating every SKU? What calculation is it using to forecast error? Is it adjusting stock parameters based on the results?

If you’re finding that your current inventory management system has limitations, consider investing in an inventory optimization plug-in. Inventory optimization software will work in collaboration with an ERP, WMS or inventory management tool to provide additional demand forecasting functionality. You can then save time you would spend carrying out complex calculations and instead make informed inventory management decisions based on accurate data.

If you find inventory forecasting a challenge, contact the EazyStock team today. Our demand forecasting software gives you advanced inventory management capabilities that you can use to improve the day-to-day running of your business – fast.

Whitepaper - How to Improve Demand Forecasting Accuracy

Share

Mark Chapman

3 min read

Sign up for the EazyStock Newsletter

Stay on Top of the Latest News, Trends, Tips, and Best Practices for Supply Chain Management, Inventory Optimization, Replenishment & Purchasing, and Demand Forecasting with Our EazyStock Newsletter.