Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

ISM Exam INTE Topic 5 Question 15 Discussion

Actual exam question for ISM's Supply Management Integration exam
Question #: 15
Topic #: 5
[All Supply Management Integration Questions]

Consider the following data comparing actual demand versus forecast demand:

Month Actual Demand Forecast Demand

January 100,000 80,000

February 105,000 90,000

March 110,000 100,000

April 70,000 100,000

May 90,000 110,000

June 100,000 90,000

What is the Mean Annual Percent Error (MAPE) for the six months of data?

Show Suggested Answer Hide Answer
Suggested Answer: C

To calculate the Mean Absolute Percentage Error (MAPE), we follow these steps:

1. Find the absolute error for each month.

2. Convert the absolute error to a percentage of the actual demand for each month.

3. Find the average of these percentage errors over the six-month period.

Here's the calculation:

* January: 100,00080,000100,000100=20%\left| \frac{100,000 - 80,000}{100,000} \right| \times 100 = 20\%100,000100,00080,000100=20%

* February: 105,00090,000105,000100=14.29%\left| \frac{105,000 - 90,000}{105,000} \right| \times 100 = 14.29\%105,000105,00090,000100=14.29%

* March: 110,000100,000110,000100=9.09%\left| \frac{110,000 - 100,000}{110,000} \right| \times 100 = 9.09\%110,000110,000100,000100=9.09%

* April: 70,000100,00070,000100=42.86%\left| \frac{70,000 - 100,000}{70,000} \right| \times 100 = 42.86\%70,00070,000100,000100=42.86%

* May: 90,000110,00090,000100=22.22%\left| \frac{90,000 - 110,000}{90,000} \right| \times 100 = 22.22\%90,00090,000110,000100=22.22%

* June: 100,00090,000100,000100=10%\left| \frac{100,000 - 90,000}{100,000} \right| \times 100 = 10\%100,000100,00090,000100=10%

MAPE=(20+14.29+9.09+42.86+22.22+10)6=19.41%20%MAPE = \frac{(20 + 14.29 + 9.09 + 42.86 + 22.22 + 10)}{6} = 19.41\% \approx 20\%MAPE=6(20+14.29+9.09+42.86+22.22+10)=19.41%20%

Thus, the MAPE for the six months of data is approximately 20%. Reference:

* Chase, R. B., Jacobs, F. R., & Aquilano, N. J. (2006). Operations Management for Compet-itive Advantage. McGraw-Hill/Irwin.

* Hyndman, R. J., & Athanasopoulos, G. (2018). Forecasting: principles and practice. OTexts.


Contribute your Thoughts:

Vernell
6 days ago
Wait, is that a trick question? I feel like the answer should be lower than the options provided.
upvoted 0 times
...
Jeniffer
11 days ago
20% MAPE? That's a bit too high for my liking. I'm thinking it's gotta be around 15%.
upvoted 0 times
Tracey
1 hours ago
I think 15% is a reasonable estimate for the Mean Annual Percent Error.
upvoted 0 times
...
Brett
7 days ago
I agree, 20% seems a bit high. I would also go with 15%.
upvoted 0 times
...
...
Werner
14 days ago
Based on that calculation, the MAPE would be 15%, which corresponds to option B. So, I would go with option B as the answer.
upvoted 0 times
...
Matthew
19 days ago
I agree with Tony. So, the MAPE would be (|100,000-80,000|/100,000 + |105,000-90,000|/105,000 + |110,000-100,000|/110,000 + |70,000-100,000|/70,000 + |90,000-110,000|/90,000 + |100,000-90,000|/100,000) / 6.
upvoted 0 times
...
Tony
23 days ago
I think the MAPE is calculated by taking the absolute difference between actual and forecast demand, dividing by actual demand, and then averaging over all months.
upvoted 0 times
...
Eladia
27 days ago
Hmm, this looks tricky. Time to break out the calculator and crunch some numbers!
upvoted 0 times
Candra
12 days ago
B) 15%
upvoted 0 times
...
Genevieve
14 days ago
A) 10%
upvoted 0 times
...
...

Save Cancel