1. The following table shows the number of Blu-ray DVD players that Electronic Depot has sold during the past 12 weeks:
|
Week
|
Sales
|
Week
|
Sales
|
|
1
|
22
|
7
|
24
|
|
2
|
27
|
8
|
25
|
|
3
|
30
|
9
|
22
|
|
4
|
21
|
10
|
30
|
|
5
|
33
|
11
|
38
|
|
6
|
28
|
12
|
37
|
Develop 2-week, 3-week, and 4-week moving averages to forecast the sales for each week. What is the forecast for week 13 in each case?
2. Consider the data given in Problem 17 for Bluray DVD player sales at Electronic Depot.
(a) If Electronic Depot decides to forecast sales by using a three-period weighted moving average, what are the optimal weights that minimize MAPE? What would be the week 13 forecast using these weights?
(b) If Electronic Depot decides to forecast sales by using exponential smoothing, what is the optimal value of a that minimizes MAPE? What would be the week 13 forecast using this procedure?
(c) Which of the methods analyzed here and in would you use? Explain your answer.