For the following data are the sales of mattress during the last 3 years Period Sales 1 3500 2 4000 3 3000 4 3850 5 6000
Posted: Sun May 29, 2022 8:49 pm
For the following data are the sales of mattress during the last 3 years Period Sales 1 3500 2 4000 3 3000 4 3850 5 6000 6 5750 7 7000 8 6000 9 10000 10 12000 11 14000 12 9000 13 3010 14 4000 15 3000 16 5000 17 6000 18 9000 19 3000 20 8000 21 10000 22 14000 23 14000 24 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.