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.