Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4...

Transcribed Image Text:

Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4 5 6 7 8 9 10 a. Use Simple Moving Average method (with n = 3) to forecast sales in periods 6, 7, and 8, 9 and 10 (10pts) b. Use Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, 8, 9 and 10. (10 pts) c. Use Exponential Smoothing method (with a = 0.4) to forecast sales in periods 6, 7, and 8, 9 and 10 (Hint: Use the first 2 data sets to initialize the Exponential Smoothing forecasting model, then update the forecasts in periods 3, 4, and 5.) (10 pts) d. Show solutions Given the following actual sales, A(t) 8 4 9 11 10 t 1 2 3 4 5 6 7 8 9 10 a. Use Simple Moving Average method (with n = 3) to forecast sales in periods 6, 7, and 8, 9 and 10 (10pts) b. Use Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, 8, 9 and 10. (10 pts) c. Use Exponential Smoothing method (with a = 0.4) to forecast sales in periods 6, 7, and 8, 9 and 10 (Hint: Use the first 2 data sets to initialize the Exponential Smoothing forecasting model, then update the forecasts in periods 3, 4, and 5.) (10 pts) d. Show solutions

Answer rating: 100% (QA)

Sure lets tackle each part of the forecasting question based on the methods specified a Simple Moving Average method n 3 The Simple Moving Average SMA ... View the full answer