Please select 12 sale values of your choice and enter these values in the Actual Sale values column. Complete the remaining columns table below using given forecasting Method. Compute MADs, MSEs, and MAPEs

Which smoothing method is the best? Why? You can use Excel to work this out

3 period moving average Actua I sales forecast abs(forecast error) square error period error error/actual Abs(error/actual) 1 2 3 4 5 6 7 8 9 10 11 12 MAD MSE MAPE