2. Historical demand for a product is

Demand

Months

January

12

February 11

March

15

April

12

May

June

16

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 single exponential smoothing with Alpha=0.2 and a June forecast = 13, find the July

forecast. Make whatever assumptions 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.