What it means
When running a business, you constantly need to predict future outcomes, such as next month sales, quarterly cash flow, or annual staffing needs. Once the actual period passes, you want to know how close your guess was.
Mean Absolute Percentage Error, often called MAPE, makes this easy to calculate and understand because it translates forecasting errors into percentages rather than confusing dollar amounts or units. To find this metric, you look at the gap between your forecast and the actual result for several items, turn those gaps into percentages of the actual numbers, and then find the average.
For instance, if you predicted selling 100 units and sold 110, the error is 10 percent. By doing this across all your products or months, you get a single score that shows your overall forecasting reliability.
This matters because bad forecasts lead to wasted money, either by holding too much stock or running out of critical items. Business leaders use this metric to track whether their forecasting methods are improving over time.
A finance team might set a target, such as keeping the error rate below 10 percent, to ensure budgets and purchasing plans remain dependable and realistic.
In practice
Real-world examples.
Example
A boutique coffee shop owner forecasts selling 1,000 lattes in June, but actually sells 1,200. The error is 20 percent. If July has an error of 10 percent, the average error rate helps measure overall forecasting accuracy.
Example
A regional courier firm predicts it will deliver 5,000 packages on Tuesday, but handles 4,500 due to bad weather. That is a 10 percent error. Tracking this helps managers schedule the right number of drivers for future shifts.
Example
An online clothing retailer forecasts 2,000 winter coat sales in November, but sells 2,500 following a sudden cold snap. This creates a 25 percent error, showing purchasing managers where seasonal demand spikes catch them off guard.
Think of it
“Imagine throwing darts at a board. If you miss the bullseye by two inches every time, you are consistently off. This metric measures the average size of those misses as a percentage of the total distance to the target, showing how good your aim is overall.
Formula
Calculation
To calculate MAPE, take the absolute difference between the actual value and the forecast, divide that by the actual value, and turn it into a percentage. Do this for all periods, add them up, and divide by the total number of periods.
Example:
Actual sales = 200 units
Forecast sales = 180 units
Difference = 20 units
Percentage error = 20 / 200 = 0.10 or 10 percent
If you have two months with errors of 10 percent and 20 percent, the MAPE is (10 + 20) / 2 = 15 percent.Case study
Seen in the real world.
Oakwood Furniture, a growing manufacturer of dining tables, struggled with inventory costs because their sales forecasts were unreliable. The management team decided to track their forecasting accuracy using Mean Absolute Percentage Error to improve their production planning.
Over the past four quarters, Oakwood predicted sales of 500, 600, 550, and 700 tables. The actual sales figures turned out to be 400, 650, 500, and 630 tables. The absolute percentage errors for each quarter were calculated at 25 percent, 7.7 percent, 9.1 percent, and 11.1 percent respectively.
Averaging these figures gave Oakwood a baseline MAPE of 13.2 percent. The finance director shared this data with the sales and operations teams, setting a goal to bring the error rate below 10 percent by the end of the year. By factoring in recent market trends and historical seasonality, the team refined their approach. In the following year, their error rate dropped to 8.5 percent, which significantly reduced excess timber storage costs and improved cash flow.
Watch out
Common mistakes.
- Using this metric when actual sales figures can be zero, which breaks the math because you cannot divide by zero.
- Treating a high percentage error on a very small product line the same as a high error on your core revenue generator.
- Failing to look at whether you consistently overforecast or underforecast, since the absolute values hide the direction of the error.
Questions
People also ask.
What is considered a good MAPE score?
Generally, an error rate under 10 percent is considered very good, while anything under 20 percent is acceptable for most business planning purposes.
Why use percentages instead of actual numbers?
Percentages let you compare accuracy across different products, departments, or time periods on an equal footing, regardless of their scale.
Can this metric be used for financial budgeting?
Yes, it is widely used to test how accurately financial teams predict revenues, expenses, and cash flow against actual results.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related