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 or = 0.2? (4 points) b. Use Solver to estimate the optimal value of smoothing constants (or) that minimize MSE and evaluate the MSE based on the optimal value of or. 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 or ? (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 ts the given data and explain why. (8 points). b. What is the forecast for January of the year 2021? (6 points) c. What is the forecast for June of the year 2021 (6 points) Please write your answers using the given below answer form. I I I A B Monthly sales data W N - Month Sales 1 Sales 2 Jan-17 2568 3824 Feb-17 2580 3728 Mar-17 2606 4242 Apr-17 2639 4171 May-17 2674 4336 10 Jun-17 2699 4804 11 Jul-17 2728 4654 12 Aug-17 2741 4751 13 Sep-17 2770 4316 14 Oct-17 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 Apr-18 2974 4643 21 May-18 3008 4569 22 Jun-18 3027 5007 23 Jul-18 3044 5271 24 Aug-18 3071 5088 25 Sep-18 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 Apr-19 3295 4938 33 May-19 3322 4878 34 Jun-19 3343 5760 35 Jul-19 3368 5416 36 Aug-19 3407 5661 37 Sep-19 3426 5037 38 Oct-19 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 Apr-20 3652 5268 45 May-20 3686 5332 46 Jun-20 3722 5927 47 Jul-20 3747 6088 48 Aug-20 3770 6085 49 Sep-20 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 Apr-21 57 May-21 58 Jun-21 59 Jul-21 60 Aug-21 61 Sep-21 62 Oct-21 63 Nov-21 64 Dec-21