Skip to content
Omnikalc

Forecast error calculator: how accurate is your forecast?

Enter actual values and forecasts for six periods to get MAE, MSE, RMSE, MAPE, WAPE, bias and the tracking signal.

Updated on
Your inputs

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Results

Mean absolute percentage error (MAPE)

4.07 %

A highly accurate forecast
Mean absolute error (MAE)
5.50
Root mean squared error (RMSE)
5.87
Mean squared error (MSE)
34.50
Bias (mean error, actual − forecast)
-0.83
Weighted absolute percentage error (WAPE)
4.06 %
Tracking signal
-0.91
Within the usual limit of ±4: no persistent bias

A forecast is only useful if you know how wrong it tends to be. The forecast error calculator takes the actual values and forecasts of six periods and gives the mean absolute percentage error (MAPE), the mean absolute error (MAE), the root mean squared error (RMSE), the mean squared error, the bias, the weighted absolute percentage error (WAPE) and the tracking signal.

How the calculation works

  • Enter the actual value and the forecast for each of the six periods, in the same units.
  • The error of a period is actual − forecast. A positive error means the forecast was too low.
  • MAE averages the absolute errors, RMSE gives more weight to large errors, and MAPE expresses the average error as a percentage of the actual value.
  • The bias is the mean signed error, and the tracking signal is the sum of errors ÷ MAE. A tracking signal outside ±4 points to a forecast that is consistently too high or too low.

Example

The errors of the default series are −5, +5, −4, +4, +5 and −10. The MAE is 33 ÷ 6 = 5.5, the MSE is 207 ÷ 6 = 34.5 and the RMSE is 5.87. The MAPE is 4.07 % and the WAPE is 4.06 % (33 ÷ 813). The bias is −0.83 and the tracking signal is −5 ÷ 5.5 = −0.91, well inside ±4, so the forecast is accurate and not persistently biased.

Why it matters

Each metric answers a different question: how big the typical miss is, how bad the worst misses are, how large the error is in relative terms and whether the forecast leans one way. Comparing them tells you whether to fix the model, the data or the inventory buffer.

Good to know

Six periods are a small sample, so treat the result as an indication and not a proof. MAPE is undefined when an actual value is zero, so enter a small number instead. The tracking signal here is computed over the whole window, while in practice it is updated every period.

The demand forecast calculator builds the forecast, the exponential moving average calculator smooths a series, and the percent error calculator handles a single measurement.

Frequently asked questions

What is the difference between MAE, RMSE and MAPE?

MAE is the average size of the errors in the original units. RMSE squares the errors before averaging, so large misses count more. MAPE divides each error by the actual value, so it is unit-free and easy to compare across products, but it blows up when actual values are near zero.

When should I use WAPE instead of MAPE?

WAPE divides the total absolute error by the total actual value. It is steadier than MAPE when some periods have small values, and it weights big periods more. Many supply chain teams prefer it for items with intermittent demand.

What does the tracking signal tell me?

It is the running sum of errors divided by the MAE. If forecasts were unbiased, the positive and negative errors would cancel and the signal would stay near zero. A value beyond about ±4 means that errors keep going the same way, which suggests that the model needs to be adjusted.

What is a good MAPE?

It depends on the product and the horizon. Under 10 % is often called highly accurate, 10 to 20 % good, 20 to 50 % reasonable and above 50 % poor. Always compare with a naive forecast, such as the last observed value, to see if your model adds value.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.