istorical demand for a product is
Month Demand
January 12
February 11
March 15
April 12
May 16
June 15
(a) Using a weighted moving average with weights of 0.6, 0.3, and 0.1. The weight of 0.6 is to be attached to the most recent demand and 0.3 to the second most recent demand. Compute the July forecast.
(b) Using a simple three-month moving average, compute the forecasts for April, May, and June. For each forecast, please provide at least one step of calculation and the correct value.
(c) Based on the forecasts from (b), compute the mean absolute deviation (MAD) for the simple 3-month moving average method. Provide the formula, at least one step of calculation, and the correct answer.
(d) Using exponential smoothing with α = 0.2 and a June forecast = 13, compute the forecast for July. Provide the formula, at least one step of calculation and the correct forecast.
(e) Using simple linear regression analysis, calculate the regression equation for the product. For both parameters a and b, please provide the formula, at least one step of calculation, and the correct value for full credit.
(f) Using the regression equation from (d), calculate the forecast for July. Please provide one step of calculation and the correct answer for full credit.