Problem:
Historical demand for a product is
Month Demand
Jan 12
Feb 11
Mar 15
Apr 12
May 16
Jun 15
Required:
Question 1) Using a weighted moving average with weights 0.60, 0.30, and 0.10, find the July forecast.
Question 2) Using a simple three-months moving average, find July forecast.
Question 3) Using single exponential smoothing with Alpha = 0.2 and June forecast = 13, find the July forecast. Assume whatever you want to wish.
Question 4) Using simple linear regression (least square or trend analysis), calculate the regression equation and using this equation forecast for July. Provide correct solution of the given problem with step by step calculations.