I just need help with part B as I have figured out A already. If able to, I would like an explanation or equation to use for that problem to get a better understanding. Thank you.

The file Case-1-Monthly-Sales data contains monthly data from January 2017 to December 2020 for a ABC company. The first variable is Time. The second variable, Sales 1, has data on sales of a product 1. The third variable, Sales 2, has data on sales of a product 2. Question 1: Use the Sales 1 data to answer following questions (20 points) a. What is the forecast for January of the year 2021 using Exponential Smoothing method with a = 0.2 ? (4 points) b. Use Solver to estimate the optimal value of smoothing constants (a) that minimize MSE and evaluate the MSE based on the optimal value of a. MSE = (6 points) What is the forecast for January of the year 2021 using Exponential Smoothing method based on the optimal value of a ? (4 points) d. Comment on the appropriateness of this forecasting method, why. (3 points) e. Can you apply this forecasting method to the sales 2 data, why? (3 points) Monthly sales data Month Sales 1 Sales 2 a Jan-17 2568 3824 Feb-17 2580 3728 2606 4242 Mar-17 Apr-17 May-17 4171 2639 202 2674 4336 2000 Jun-17 4804 2699 24 2728 Jul-17 4654 24 2741 4751 2770 4316 222 Aug-17 Sep-17 Oct-17 M. Nov-17 - Dec-17 4442 2808 20 2832 3966 2861 3906 Jan-18 2901 3989 Feb-18 2932 4009 Mar-18 4554 2958 204 2974 Apr-18 May-18 Jun-18 3008 4643 are 4569 ro 5007 3027 5271 Jul-18 Aug-18 Sep-18 3044 04 3071 FOOD 5088 3098 2400 3108 4667 470 4780 Oct-18 M40 3134 4218 Nov-18 Der 10 Dec-18 3168 4133 Jan-19 3186 4133 Feb-19 3221 4170 Mar-19 3256 4942 3295 4938 Apr-19 May-19 way Jun-19 3322 4878 3343 5760 Jul-19 3368 5416 3407 5661 Aug-19 2012 Sep-19 3426 5037 Oct-19 3455 5025 Nov-19 4390 3483 3509 3538 Dec-19 Jan-20 airco Feb-20 4459 4413 3582 4405 Mar-20 3600 5149 3652 5268 3686 5332 5927 3722 * 3747 6088 Apr-20 May-20 Jun-20 Jul-20 re Aug-20 SU Sep-20 Oct-20 . Nov-20 6085 5285 3770 3811 3828 3862 5523 4635 Dec-20 3896 4694 Jan-21 care Feb-21 Mar-21 . Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 The file Case-1-Monthly-Sales data contains monthly data from January 2017 to December 2020 for a ABC company. The first variable is Time. The second variable, Sales 1, has data on sales of a product 1. The third variable, Sales 2, has data on sales of a product 2. Question 1: Use the Sales 1 data to answer following questions (20 points) a. What is the forecast for January of the year 2021 using Exponential Smoothing method with a = 0.2 ? (4 points) b. Use Solver to estimate the optimal value of smoothing constants (a) that minimize MSE and evaluate the MSE based on the optimal value of a. MSE = (6 points) What is the forecast for January of the year 2021 using Exponential Smoothing method based on the optimal value of a ? (4 points) d. Comment on the appropriateness of this forecasting method, why. (3 points) e. Can you apply this forecasting method to the sales 2 data, why? (3 points) Monthly sales data Month Sales 1 Sales 2 a Jan-17 2568 3824 Feb-17 2580 3728 2606 4242 Mar-17 Apr-17 May-17 4171 2639 202 2674 4336 2000 Jun-17 4804 2699 24 2728 Jul-17 4654 24 2741 4751 2770 4316 222 Aug-17 Sep-17 Oct-17 M. Nov-17 - Dec-17 4442 2808 20 2832 3966 2861 3906 Jan-18 2901 3989 Feb-18 2932 4009 Mar-18 4554 2958 204 2974 Apr-18 May-18 Jun-18 3008 4643 are 4569 ro 5007 3027 5271 Jul-18 Aug-18 Sep-18 3044 04 3071 FOOD 5088 3098 2400 3108 4667 470 4780 Oct-18 M40 3134 4218 Nov-18 Der 10 Dec-18 3168 4133 Jan-19 3186 4133 Feb-19 3221 4170 Mar-19 3256 4942 3295 4938 Apr-19 May-19 way Jun-19 3322 4878 3343 5760 Jul-19 3368 5416 3407 5661 Aug-19 2012 Sep-19 3426 5037 Oct-19 3455 5025 Nov-19 4390 3483 3509 3538 Dec-19 Jan-20 airco Feb-20 4459 4413 3582 4405 Mar-20 3600 5149 3652 5268 3686 5332 5927 3722 * 3747 6088 Apr-20 May-20 Jun-20 Jul-20 re Aug-20 SU Sep-20 Oct-20 . Nov-20 6085 5285 3770 3811 3828 3862 5523 4635 Dec-20 3896 4694 Jan-21 care Feb-21 Mar-21 . Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21