When solving please use excel formulas (and please show said formulas) also not really much but if you want a like then I ask that you show all excel formulas and respond by the end of the day.

Durhlinoton has tracked dailv sales of coats for the three locations below 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