Assume today's date is Dec 31, 2021. To answer the following questions, use data provided in sheet 'Rail Freight Carloads' 1 point Obtain the seasonal indexes for Jan to Dec based on the past SIX years (2016-2021) in yellow cells below. 1 point Obtain the Seasonally Adjusted Actual for Jan '21 to Dec '21 in orange cells below. 1 point Using only 2021 data and Exponential Smoothing with Trend (a=0.2, B=0.7), forecast Carloads for Jan '22 in light blue cell below. 1 point Obtain MSE for 2021 in gray cell below. 1 point Using Excel's Solver, obtain the optimal parameters (a and B) that minimize MSE for 2021. GENERATE SOLVER'S ANSWER REPORT Seasonal Seasonally Actual Actual Actual Actual Actual Actual Index Adj Actual 5 2016 2017 2018 2019 2020 2021 2021 16 Jan 17 Feb 18 Mar 19 Apr 20 May 21 Jun 22 Jul 23 Aug 24 Sep 25 Oct 26 Nov 27 Dec 28 AnnualAssume there is a 40% chance of recession next year. Considering the following investment alternatives and their projected returns for 2023 under recession and no recession if you invest $100 today. Assume you have to invest your $100 in one investment alternative only. Use the Expected Value (Bayes) method to determine the optimal investment decision