Free Forecast Accuracy Calculator (WAPE, MAPE and Bias)
Most accuracy reports show one number and hide where the error comes from. Paste your actuals and forecasts below to see WAPE, MAPE and bias side by side, and which rows are doing the damage.
Forecast accuracy calculator
Paste actuals and forecasts straight from Excel. You get WAPE, MAPE, bias and the rows doing the most damage. Nothing is uploaded: the numbers stay in your browser.
Error = Forecast minus Actual, so a positive number means you forecast too high. WAPE = total absolute error divided by total actual. Bias = total error divided by total actual. MAPE = average of each row's absolute error as a % of its actual (rows with zero actual are left out). The green and amber thresholds (WAPE 25%, bias plus or minus 5%) are starting points, not industry standards.
Related
- How to Measure Forecast Accuracy: MAPE, WAPE and Bias Explained
- Free 13 week demand planning template (tracks WAPE and bias for you)
- All free Nerd Tools
Want someone to look at the whole picture? The Planning Health Check from Forward Cover reviews your forecasting, inventory and supply planning and tells you where the money is leaking.