Question

1. Bob is a photographer who sells prints on consignment. Each week during the​ summer, Bob checks the inventory so that he can replenish the prints that have been sold. The following data show the number of prints sold each week during the last eight weeks.

Week   Sold
1   15
2   11
3   8
4   15
5   18
6   17
7   9
8   10

​a) Forecast the demand for Week 9 using a​ two-period simple moving average. (Type an integer or a decimal. Do not​ round.)

​b) Calculate the MAD for the forecast in part a. ​(Round to two decimal places as​ needed.

​c) Forecast the demand for Week 9 using a​ three-period simple moving average. ​(Round to two decimal places as​ needed.

d) Calculate the MAD for the forecast in part c. ​(Round to two decimal places as​ needed.

Answer 1

a) ans 9.5

b) ans 4.83

MAD = sum of absolute error/n =4.83

c) ans 12

d) ans 5.2

MAD = sum of absolute error/n =5.2