Please Make an excel work sheet solving this question. Please make sure answers are in Excel formulas (and show said excel formulas)

Question Set 1. Using only the Boston sales data, generate the following sales forecasts: 1. Naiive forecasts (using the deseasonalized sales data) for January 5 th through January 30th. You will need to adjust the sales data to remove the seasonality effects. (6pts) 2. Four-day moving average forecasts for January 8th through January 30th using the original (seasonalized) sales data. (3pts) 3. Twelve-day moving average forecasts for January 16th through January 30th using the original (seasonalized) sales data. (3pts) Note that, for example, you will not be able to make a four-day moving average forecast for January 7th since four previous sales figures are required. Durhlinoton has tracked dailv sales of coats for the three locations below