Your task to use simple exponential smoothing to generate forecast for a time series data. The dataset of the sales worksheet is shown here: Please go to the Sales worksheet of the file: Sales.xlsx The screen shot of the data is shown below: F G H 1 1 EXPONENTIAL SMOOTHING FORECAST LEVEL SHIFT EXAMPLE 2 3 alpha 0.2 4 error smooth 0.1 5 Day Sales Forecast Error Absolute Error Absolute Percentage Error Average MAE MAPE Error (smoothed) (smoothed) (smoothed) Tracking signal 6 7 0 500.00 1 2 3 13.02 506.72 554.52 $72.92 2.67% - 13.02 13.02 100.00% 38.96 62.39 100.00% 90.51 111.60 100.00% 138.75 157.73 Sales and Forecasts 2.67% 12.41% 21.17% 29.05% 4 5 487 507 555 573 497 495 442 486 534 552 542 560 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 8 9 -13.02 506.72 554.52 572.92 496.7 495.3 442.4 485.6 533.5 552.1 541.8 560.3 457.2 473.0 509.0 539.0 424.3 508.2 1100 1000 900 800 700 10 11 12 -1.00 0.62 0.81 0.88 0.91 0.93 0.94 0.95 0.96 0.97 0.97 0.98 0.98 0.98 0.98 0.99 0.99 0.99 w walkable 3600 sales 13 457 forecase 14 15 16 17 18 473 509 539 424 508 500 400 300 200 100 so Day What should be the excel formula at Cell C9 if we use a simple exponential smoothing with level shift? For alpha=0.2, what is the mean absolute percentage error (i.e., the value in Cell H3)(keep 2-digit number)? Your task to use simple exponential smoothing to generate forecast for a time series data. The dataset of the sales worksheet is shown here: Please go to the Sales worksheet of the file: Sales.xlsx The screen shot of the data is shown below: F G H 1 1 EXPONENTIAL SMOOTHING FORECAST LEVEL SHIFT EXAMPLE 2 3 alpha 0.2 4 error smooth 0.1 5 Day Sales Forecast Error Absolute Error Absolute Percentage Error Average MAE MAPE Error (smoothed) (smoothed) (smoothed) Tracking signal 6 7 0 500.00 1 2 3 13.02 506.72 554.52 $72.92 2.67% - 13.02 13.02 100.00% 38.96 62.39 100.00% 90.51 111.60 100.00% 138.75 157.73 Sales and Forecasts 2.67% 12.41% 21.17% 29.05% 4 5 487 507 555 573 497 495 442 486 534 552 542 560 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 8 9 -13.02 506.72 554.52 572.92 496.7 495.3 442.4 485.6 533.5 552.1 541.8 560.3 457.2 473.0 509.0 539.0 424.3 508.2 1100 1000 900 800 700 10 11 12 -1.00 0.62 0.81 0.88 0.91 0.93 0.94 0.95 0.96 0.97 0.97 0.98 0.98 0.98 0.98 0.99 0.99 0.99 w walkable 3600 sales 13 457 forecase 14 15 16 17 18 473 509 539 424 508 500 400 300 200 100 so Day What should be the excel formula at Cell C9 if we use a simple exponential smoothing with level shift? For alpha=0.2, what is the mean absolute percentage error (i.e., the value in Cell H3)(keep 2-digit number)