Mean Absolute Percentage Error (MAPE) Calculator

Mean Absolute Percentage Error (MAPE) is MAD's percentage-based cousin — instead of "off by 3.5 units," it tells you "off by 3.1%." That small shift matters more than it sounds: percentages are comparable across products no matter how big or small their volumes are, which raw-unit error isn't.

This is the metric most planners actually report up the chain, precisely because it lets you say "our forecast accuracy across the whole category is 92%" as a single, meaningful number, rather than a pile of MAD values in different units for every SKU. It's also the benchmark most industry accuracy targets are expressed in.

Each period's absolute error gets divided by that period's actual demand before averaging — turning a raw unit miss into a percentage miss. Average those percentages across all periods and multiply by 100. Because it divides by actual demand, MAPE is undefined when actual demand is zero, which is the one hard constraint on using it.

Actual demand: 100, 120, 110, 130
Forecast: 105, 115, 108, 128

A MAPE around 3% falls solidly in the "excellent" range.

Now compare the same rougher forecast used in the MAD example (80, 140, 90, 150) against the same actual demand:

A MAPE of roughly 18% lands in "reasonable, but room to improve" — not disastrous, but noticeably worse than the 3% forecast. This is the same relative gap MAD showed (3.5 versus 20), just expressed on a scale that's directly comparable to a different product's forecast accuracy, which raw MAD numbers wouldn't be.

MAPE breaks down completely when actual demand is zero or very close to it — dividing by a tiny number inflates the percentage error enormously even for a small absolute miss. It's also asymmetric: an under-forecast can produce a percentage error larger than 100%, while an over-forecast is mathematically capped, which can make MAPE look worse for under-forecasting than for over-forecasting even when the raw miss is the same size.

For intermittent or lumpy demand (lots of zero-demand periods), MAPE often isn't the right tool at all — other accuracy metrics designed for intermittent demand tend to work better.

Applying it to demand that includes zeros. A single zero-demand period makes MAPE undefined or wildly misleading. Filter those periods out or use a different metric for intermittent demand.

Expecting sub-2% accuracy without advanced methods.That level of precision is rare outside of very stable, high-volume products with sophisticated forecasting behind them. A realistic target for most businesses is well above that.

Not accounting for its asymmetry. MAPE can make under-forecasting look disproportionately worse than over-forecasting of the same absolute size — worth knowing before drawing conclusions from a single number.

Averaging MAPE across wildly different products without weighting. A blended MAPE across the whole catalog can hide the fact that your highest-volume, highest-value items are forecast poorly while low-value items pull the average down.

Treating one good MAPE reading as a solved problem.Forecast accuracy drifts as demand patterns change — recheck periodically instead of assuming a good score stays good.

The table above is a widely-used rule of thumb: under 5% is excellent, under 10% is good, 10-25% is workable but improvable, and above 25% suggests the forecasting method itself needs rethinking. High-volume, stable products (grocery staples, for instance) often achieve MAPE well under 10%; new products, fashion items, and anything demand-volatile routinely run 20-40% even with a well-run forecasting process — the benchmark should account for how inherently predictable the product actually is.

Once you know your forecast accuracy:

1. Compare across forecasting methods — run the same actual demand through Moving Average, Weighted Moving Average, and Exponential Smoothing, and see which produces the lowest MAPE.
2. Prioritize accuracy work by value — a high MAPE on an A-item matters more than the same MAPE on a C-item.

• Mean Absolute DeviationMeasure the same accuracy in raw units instead of percentage.
• Exponential SmoothingTune alpha by checking which value produces the lowest MAPE.
• ABC AnalysisTrack MAPE separately for A-items — accuracy matters most there.

Books:

• Forecasting: Principles and Practice by Rob J Hyndman and George Athanasopoulos (free online)

Standards & curricula:

• APICS (ASCM) CSCP certification curriculum (demand planning module)

General references for further study, not endorsements — verify course availability and content directly with the provider.