Please answer both questions and their multiple parts. Please show all your work and explain your work to the best of your abilities. Thank you so much!

The file Case-1-Monthly-Sales data contains monthly data from January 2017 to December 2020 for an 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 the following questions (20 points) a. What is the forecast for January of the year 2021 using the 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) c. What is the forecast for January of the year 2021 using the 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) Question 2: Use the Sales 2 data to answer the following questions (20 points). a. Decide which forecasting method best fits the given data and explain why. (8 points). b. What is the forecast for January of the year 2021? (6 points) What is the forecast for June of the year 2021 (6 points) c. Please write your answers using the given below answer form. Q1 A B D E Q2 A 1 Monthly sales data 2 3 Month Sales 1 Sales 2 4 5 Jan-17 2568 3824 6 Feb-17 2580 3728 7 Mar-17 2606 4242 8 2639 4171 9 Apr-17 May-17 Jun-17 2674 4336 10 2699 4804 11 Jul-17 2728 4654 12 2741 4751 13 Aug-17 Sep-17 Oct-17 2770 4316 14 2808 4442 15 Nov-17 2832 3966 16 Dec-17 2861 3906 17 Jan-18 2901 3989 18 Feb-18 2932 4009 19 Mar-18 2958 4554 20 2974 4643 21 Apr-18 May-18 Jun-18 3008 4569 22 3027 5007 23 Jul-18 3044 5271 24 3071 5088 Aug-18 Sep-18 25 3098 4667 26 Oct-18 3108 4780 27 Nov-18 3134 4218 28 Dec-18 3168 4133 29 Jan-19 3186 4133 30 Feb-19 3221 4170 31 Mar-19 3256 4942 32 3295 4938 33 Apr-19 May-19 Jun-19 3322 4878 34 3343 5760 35 Jul-19 3368 5416 36 3407 5661 37 Aug-19 Sep-19 Oct-19 3426 5037 38 3455 5025 39 Nov-19 3483 4390 40 Dec-19 3509 4459 41 Jan-20 3538 4413 42 Feb-20 3582 4405 43 Mar-20 3600 5149 44 3652 5268 45 Apr-20 May-20 Jun-20 3686 5332 46 3722 5927 47 Jul-20 3747 6088 48 3770 6085 Aug-20 Sep-20 49 3811 5285 50 Oct-20 3828 5523 51 Nov-20 3862 4635 52 Dec-20 3896 4694 53 Jan-21 54 Feb-21 55 Mar-21 56 57 Apr-21 May-21 Jun-21 58 59 Jul-21 60 61 Aug-21 Sep-21 Oct-21 62 63 Nov-21 64 Dec-21 65