For the following data are the sales of mattress during the last 3 years Period 1...

 

Transcribed Image Text:

For the following data are the sales of mattress during the last 3 years Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Sales 3500 4000 3000 3850 6000 5750 7000 6000 10000 12000 14000 9000 3010 4000 3000 5000 6000 9000 3000 8000 10000 14000 14000 10000 1. Use simple moving with N= 2,3 to forecast the demand, which is the best according to MAD & MSE? 2. Use exponential weighted moving average with (with a = 0.1) to forecast the demand for previous 3 years given that F(1) is 3200, What is the sales at Period 25 3. Use regression analysis tool to fit a line to your data and write the line equation, what is the forecast for sales for at Period 25. For the following data are the sales of mattress during the last 3 years Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Sales 3500 4000 3000 3850 6000 5750 7000 6000 10000 12000 14000 9000 3010 4000 3000 5000 6000 9000 3000 8000 10000 14000 14000 10000 1. Use simple moving with N= 2,3 to forecast the demand, which is the best according to MAD & MSE? 2. Use exponential weighted moving average with (with a = 0.1) to forecast the demand for previous 3 years given that F(1) is 3200, What is the sales at Period 25 3. Use regression analysis tool to fit a line to your data and write the line equation, what is the forecast for sales for at Period 25.

Answer rating: 100% (QA)

1 The best forecasts according to MAD and MSE are as follows Simple moving ... View the full answer