Sales for the past 12 months at Computer Success are given here. Month Sales ($) Month Sales ($) January February March April May June 3000 3400 3700 4100 4700 5700 July August September October November December 6300 7200 6400 4600 4200 3900 a. Use a three-month moving average to forecast the sales for the months May through December.b. Use a four-month moving average to forecast the sales for the months May through December.c. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Sales for the past 12 months at Computer Success are given here.
Month | Sales ($) | Month | Sales ($) |
January February March April May June |
3000 3400 3700 4100 4700 5700 |
July August September October November December |
6300 7200 6400 4600 4200 3900 |
a. Use a three-month moving average to forecast the sales for the months May through December.
b. Use a four-month moving average to forecast the sales for the months May through December.
c. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?
d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?
e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images