Use the following information to forecast a) Graph the following data and answer the following: al) Do you see a trend? Yes or No? a2) Do you see seasonality? Yes or No? b) Forecast Q1 for 2021 in cell B40 b1) What is the most appropriate forecasting technique from Chapter 6 to use? b2) Add your forecast line to the graph from Part a. b**) You may add any columns you deem necessary. ? ? WMT Date Revenue 4/30/2014 114,960 7/31/2014 120,125 10/31/2014 119,001 1/31/2015 131,565 4/30/2015 114,826 7/31/2015 120,229 10/31/2015 117,408 1/31/2016 129,667 4/30/2016 115,904 7/31/2016 120,854 10/31/2016 118,179 1/31/2017 130,936 4/30/2017 117,542 7/31/2017 123,355 10/31/2017 123,179 1/31/2018 136,267 4/30/2018 122,690 7/31/2018 128,028 10/31/2018 124,894 1/31/2019 138,793 4/30/2019 123,925 7/31/2019 130,377 10/31/2019 127,991 1/31/2020 141,671 4/30/2020 134,622 7/31/2020 137,742 10/31/2020 134,708 1/31/2021 152,079 Use the following information to forecast a) Graph the following data and answer the following: al) Do you see a trend? Yes or No? a2) Do you see seasonality? Yes or No? b) Forecast Q1 for 2021 in cell B40 b1) What is the most appropriate forecasting technique from Chapter 6 to use? b2) Add your forecast line to the graph from Part a. b**) You may add any columns you deem necessary. ? ? WMT Date Revenue 4/30/2014 114,960 7/31/2014 120,125 10/31/2014 119,001 1/31/2015 131,565 4/30/2015 114,826 7/31/2015 120,229 10/31/2015 117,408 1/31/2016 129,667 4/30/2016 115,904 7/31/2016 120,854 10/31/2016 118,179 1/31/2017 130,936 4/30/2017 117,542 7/31/2017 123,355 10/31/2017 123,179 1/31/2018 136,267 4/30/2018 122,690 7/31/2018 128,028 10/31/2018 124,894 1/31/2019 138,793 4/30/2019 123,925 7/31/2019 130,377 10/31/2019 127,991 1/31/2020 141,671 4/30/2020 134,622 7/31/2020 137,742 10/31/2020 134,708 1/31/2021 152,079