Please include the formulas used to answer the question. Thank you.
45 2019-08-01 59318 46 2019-09-01 53944 47 2019-10-01 55762 48 2019-11-01 54039 49 2019-12-01 57086A A | 8 Retail Sales: Restaurants and Other Eating Places, Millions of Dollars, Monthly, Not _1_ Month .Seasonally Adjusted . __2_ 2016-01-01 44115 3_ 2016-02-01 45139 4_ 2016-03-01 49100 5_ 2016-04-01 48893 6_ 2016-05-01 49634 ?_ 2016-06-01 4?822_ 8_ 2016-0?-01 49313 9_ 2016-08-01 4839? 19 2016-09-01 46129 11_ 2016-10-01 4??10_ 12_ 2016-11-01 46022 13 2016-12-01. 50012. E 2017-01-01 46310 E 201702-01 4576? \"E 2017-03-01 52336 E 2017-04-01 50?38_ 18 201?05-01 523?6_ 19 2017-06-01 51553 20 2017-07-01 51746 21_ 201?-0801_ 51505 22 201?09-01_ 48963 23 2017-10-01 _ 49932 a 201?11-01 48090 25_ 2017-12-01 53549 23 2018-01-01 4??9? 2? 2018-02-01 4?540_ 28 2018-03-01 55328 29 2018-04-01 522?1_ 33 2018-05-01 55993 3i 2018-06-01 56191 32_ 2018-0?-01 564?? 31 2018-08-01 56692 3i 2018-09-01 515?1_ 33 2018-10-01 52993 _36_ 2018-11-01 51060 3? 2018-12-01. 551?8. 31 201901-01 49940 3i 201902-01 49623 40 2019-03-01 5??93_ 1 2019-04-01 55206 g 2019-05-01 59164 _ 2019-06-01 58310 2019-07-01 586?9 Import Sales and Seasonal Indexes from sheet 2 Actual Actual Actual Actual Seasonal ndex Forecast 2016 2017 2018 2019 2020 Total Using Year and Annual Safes. obtain the LINEAR equation to estimate trend from the Excet's Scatter Diagram 1 point Paste Scatter Diagram 1 point Using the linear trend equation, what is your forecast for year 2020? (enter answer in orange cell below) Enter Forecast for Year 2020 > _ 1 point Using the seasonal indexes obtained and your forecast for Year 2020, forecast monthly Sales for Year 2020 (enter values in agpro riate oran e cells above) Assume today's date is Dec 31, 2019 (pre-COVID!). To answer the following questions, use data provided in sheet 'Restaurant Sales Data'. 1 point Obtain the seasonal indexes for Jan to Dec based on the past FOUR years (2016-2019) in yellow cells below. 1 point Obtain the Seasonally Adjusted Actual for Jan '19 to Dec '19 in orange cells below. 1 point Using only 2019 data and Exponential Smoothing with Trend (a=0.3, B=0.6), forecast Sales for Jan '20 in light blue cell below. 1 point Obtain MSE for 2019 in gray cell below. 1 point Using Excel's Solver, obtain the optimal parameters (a and B) that minimize MSE for 2019. GENERATE SOLVER'S ANSWER REPORT Seasonall Seasonal y Adj Actual Actual Actual Actual Index Actual Forecast 2016 2017 2018 2019 2019 2020 Jan