Penny wants you to conduct time-series analyses in Excel, for Fast Flow’s unit sales. She is aware that seasonal fluctuations are present in the historical quarterly sales data and you must allow for this in your derived model. Furthermore, she wants you to produce appropriate charts of the historical and fitted data and also wants you to calculate the MAPE values for your model. Finally, you are to forecast the unit sales for the final two quarters of 2020 and all of 2021. Data is in the FastFlowSales.xlsx file.
Forecast the unit sales for the final two quarters of 2020 and all of 2021.