Historical demand for a product is DEMAND January February 12 11 March 15 April 12 May...

Transcribed Image Text:

Historical demand for a product is DEMAND January February 12 11 March 15 April 12 May 16 June 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 a = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish. %3D 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. Regression equation for Reference: S = A + B (M) + B,(H) + B(I) + B(T) where S= Gross sales for year A = Base sales, a starting point from which other factors have influence M = Marriages during the year H = Housing starts during the year 1 = Annual disposable personal income T = Time trend (first year = 1, second = 2, third = 3, and so forth) Historical demand for a product is DEMAND January February 12 11 March 15 April 12 May 16 June 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 a = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish. %3D 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. Regression equation for Reference: S = A + B (M) + B,(H) + B(I) + B(T) where S= Gross sales for year A = Base sales, a starting point from which other factors have influence M = Marriages during the year H = Housing starts during the year 1 = Annual disposable personal income T = Time trend (first year = 1, second = 2, third = 3, and so forth)

Answer rating: 100% (QA)

a Weighted moving average forecast Weights are060030010 WMAFjuly 060150301601012 15 b 3period mo... View the full answer