Assume today's date is Dec 31, 2020. To answer the following questions, use data provided in sheet Four Price Data Obtain the seasonal indexes for Jan to Dec based on the past FOUR years (2017-2020) in yellow cells below Obtain the Seasonally Adjusted Actual for Jan 20 to Dec 20 in orange cells below Using only 2020 data and Exponential Smoothing with Trend (a 0.4, B-0.6), forecast Price for Jan 21 in light blue cell below Obtain MSE for 2020 in gray cell below Using Excel's Solver, obtain the optimal parameters (a and B) that minimize MSE for 2020 GENERATE SOLVER'S ANSWER REPO Actual 2017 Actual 2018 Actual 2019 Actual 2020 Seasonal Seasonally Index Adi Actual 2020 Jan Feb Mar Apr May Jun Jul Qua Actual 2017 Actual 2018 Actual 2019 Actual 2020 Seasonal Seasonally Index Adj Actual 2020 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Sum of Prices C29 x E 22.0 A B D Obccrystion Wheat Flour, $22.1975 1b bog 12/01/2020 Not Seasonally. Adjusted 3 2017-01-01 214 3 2017-02-01 214 2017-03-01 20.9 2017-04-01 20.5 2017-05-01 21.2 2017-06-01 2017-07-01 24.4 2017-08-01 22.4 2017-09-01 21.9 e 2017-10-01 218 3 2017-11-01 22.3 2017-12-01 21.8 5 2018-01-01 22.0 B 2018-02-01 21.8 2018-03-01 22.2 8 2018-04-01 22,2 9 2018-05-01 22.3 0 2018-06-01 22.4 1 2018-07-01 21.9 2 2018-08-01 22.2 3 2018-09-01 21.7 34 2018-10-01 21.8 5 2018-11-01 21.9 6 2018-12-01 21.3 7 2019-01-01 21.8 28 2019-02-01 21.9 E3 2013-03-01 21,1 0 2013-04-01 21.5 51 2018-05-01 21.3 52 2013-06-01 22.0 33 2013-07-01 21.8 34 2013-08-01 20.3 55 2019-09-01 20.7 6 2019-10-01 216 7 2019-11-01 217 58 2013-12-01 21.7 53 2020-01-01 22.1 50 2020-02-01 21.9 11 2020-03-01 218 12 2020-04-01 21.9 13 2020-05-01 21.6 14 2020-06-01 21.8 15 2020-07-01 217 16 2020-08-01 21.4 37 2020-03-01 21.7 18 2020-10-01 21.3 19 2020-11-01 22.3 -0 2020-12-01 22.2 -1 Flour Price Data 23 Assume today's date is Dec 31, 2020. To answer the following questions, use data provided in sheet Four Price Data Obtain the seasonal indexes for Jan to Dec based on the past FOUR years (2017-2020) in yellow cells below Obtain the Seasonally Adjusted Actual for Jan 20 to Dec 20 in orange cells below Using only 2020 data and Exponential Smoothing with Trend (a 0.4, B-0.6), forecast Price for Jan 21 in light blue cell below Obtain MSE for 2020 in gray cell below Using Excel's Solver, obtain the optimal parameters (a and B) that minimize MSE for 2020 GENERATE SOLVER'S ANSWER REPO Actual 2017 Actual 2018 Actual 2019 Actual 2020 Seasonal Seasonally Index Adi Actual 2020 Jan Feb Mar Apr May Jun Jul Qua Actual 2017 Actual 2018 Actual 2019 Actual 2020 Seasonal Seasonally Index Adj Actual 2020 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Sum of Prices C29 x E 22.0 A B D Obccrystion Wheat Flour, $22.1975 1b bog 12/01/2020 Not Seasonally. Adjusted 3 2017-01-01 214 3 2017-02-01 214 2017-03-01 20.9 2017-04-01 20.5 2017-05-01 21.2 2017-06-01 2017-07-01 24.4 2017-08-01 22.4 2017-09-01 21.9 e 2017-10-01 218 3 2017-11-01 22.3 2017-12-01 21.8 5 2018-01-01 22.0 B 2018-02-01 21.8 2018-03-01 22.2 8 2018-04-01 22,2 9 2018-05-01 22.3 0 2018-06-01 22.4 1 2018-07-01 21.9 2 2018-08-01 22.2 3 2018-09-01 21.7 34 2018-10-01 21.8 5 2018-11-01 21.9 6 2018-12-01 21.3 7 2019-01-01 21.8 28 2019-02-01 21.9 E3 2013-03-01 21,1 0 2013-04-01 21.5 51 2018-05-01 21.3 52 2013-06-01 22.0 33 2013-07-01 21.8 34 2013-08-01 20.3 55 2019-09-01 20.7 6 2019-10-01 216 7 2019-11-01 217 58 2013-12-01 21.7 53 2020-01-01 22.1 50 2020-02-01 21.9 11 2020-03-01 218 12 2020-04-01 21.9 13 2020-05-01 21.6 14 2020-06-01 21.8 15 2020-07-01 217 16 2020-08-01 21.4 37 2020-03-01 21.7 18 2020-10-01 21.3 19 2020-11-01 22.3 -0 2020-12-01 22.2 -1 Flour Price Data 23
