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:

Cory
1 days ago
I bet the person who wrote this question has a wicked sense of humor. This is like a math riddle!
upvoted 0 times
...
Verlene
2 days ago
All this data has my head spinning. I need a break and a cup of coffee before I attempt this.
upvoted 0 times
...
Thaddeus
9 days ago
I'm just going to blindly guess 'C' and hope for the best. Math was never my strong suit.
upvoted 0 times
...
Vernell
16 days ago
Wait, is that a trick question? I feel like the answer should be lower than the options provided.
upvoted 0 times
...
Jeniffer
21 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
Valentin
5 days ago
I think it's around 15% too.
upvoted 0 times
...
Skye
9 days ago
Yeah, 20% does seem high. 15% sounds more accurate based on the data provided.
upvoted 0 times
...
Tracey
10 days ago
I think 15% is a reasonable estimate for the Mean Annual Percent Error.
upvoted 0 times
...
Brett
17 days ago
I agree, 20% seems a bit high. I would also go with 15%.
upvoted 0 times
...
...
Werner
24 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
29 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
1 months 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
1 months ago
Hmm, this looks tricky. Time to break out the calculator and crunch some numbers!
upvoted 0 times
Candra
22 days ago
B) 15%
upvoted 0 times
...
Genevieve
24 days ago
A) 10%
upvoted 0 times
...
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77