The demand and forecast of an item for five months are given in the table.
| Month | Demand |
Forecast |
| April |
225 |
200 |
| May |
220 | 240 |
| June | 285 | 300 |
| July | 290 | 270 |
| August | 250 | 230 |
The Mean Absolute Percent Error (MAPE) in the forecast is ___________ % (round off to two decimal places)
Month Demand Forecast April 225 200 May 220 240 June 285 300 July 290 270 August 250 230
Correct Answer :
Correct answer is : 8.07
|
Period |
Actual Demand (Di) |
Forecasted Demand (Fi) |
Absolute Percentage Error Ei = (Di - Fi) |
|
April |
225 |
200 |
25 |
|
May |
220 |
240 |
-20 |
|
June |
285 |
300 |
-15 |
|
July |
290 |
270 |
20 |
|
August |
250 |
230 |
20 |
Mean Absolute Percentage Error (MAPE) :
Solution :
The correct answer is 8.07.
Step-by-Step Explanation:
Mean Absolute Percentage Error (MAPE) is a measure of prediction accuracy of a forecasting method in statistics. It is calculated using the following formula:
where:
- is the actual demand for period i,
- is the forecasted demand for period i, and
- is the total number of periods ( months).
Let's calculate the absolute percentage error for each month:
1. April:
Actual Demand () = 225, Forecast () = 200
Absolute Percentage Error =
2. May:
Actual Demand () = 220, Forecast () = 240
Absolute Percentage Error =
3. June:
Actual Demand () = 285, Forecast () = 300
Absolute Percentage Error =
4. July:
Actual Demand () = 290, Forecast () = 270
Absolute Percentage Error =
5. August:
Actual Demand () = 250, Forecast () = 230
Absolute Percentage Error =
Now, we compute the average of these absolute errors and multiply by 100 to get the percentage value:
Rounding to two decimal places, we get 8.07 %.
Access expert-curated educational resources and study materials—completely free.
Create, conduct, and manage professional online assessments with Mindyard. Perfect for teachers and institutes.
Copyright © 2026 Mindyard. All Rights Reserved.