5. Please make up 12 sale values of your choice (numbers between 100 and 200) and enter these values in the "Actual Sale" column. Complete the remaining columns table below using the indicated forecasting Method. Compute MADs, MSEs, and MAPEs. Question: Which smoothing method is the best? Why? With your own number, just duplicate what I did in the video lesson I provided to you... You can use Excel to do this. Pleaseit Adtual Naive forecast abs(forecast square period sales forecast error error) error error/actual Abs(error/actual) 1 2 W 5 6 10 11 12 MAD MSE MAPE3 period Actual | moving forecast | abs(forecast square period sales average error error) error error/actual | Abs(error/actual) 1 2 3 4 5 6 7 8 9 10 11 12 MAD MSE MAPE 3 period centered Actual | moving forecast | abs(forecast square period sales average error error) error error/actual | Abs(error/actual) 1 2 3 4 5 6 7 8 9 10 11 = N MAD MSE MAPE 3 period weighted Actual moving forecast abs(forecast square period (t) sales average error error) error error/actual |Abs(error/actual) 0.15(wieght for t-3) 0.35(weight 2 for t-2) 0.5(weight W for t-1) UP 6 00 10 11 12 MAD MSE MAPEexponential smoothing Actual | with alpha= | forecast | abs(forecast square period sales 3 error error) error error/actual | Abs(error/actual) 1 2 3 4 5 6 7 8 9 10 11 12 MAD MSE MAPE