Historical demand for a product is:January DEMAND 12 / February DEMAND 11/Marc

Historical demand for a product is:January DEMAND 12 / February DEMAND 11/March DEMAND15/ April DEMAND 12/ May DEMAND 16 /June DEMAND 15

a. Using a weighted moving average with weights of 0.60 0.30 and 0.10 find the July forecast.

b. Using a simple three-month moving average find the July forecast.

c. Using a single exponential smoothing with a= 0.2 and a June forecast = 13 find the July forecast. Make whatever assumption you wish.

d. Using simple linear regression analysis calculate the regression equation for the preceding demand data

e. Using the regression equation in d calculate the forecast for July.