PLEASE USE EXCEL TO SOLVE AND SHOW FUNCTIONS.

Question Set $1.$ Using only the Baltimore sales data, generate the following sales forecasts:

$1.$ Na$$ve forecasts $($using the deseasonalized sales data$)$ for January $5$th through January $30$th$.$ You will need to adjust the sales data to remove the seasonality effects. $(6$pts$)$

$2.$ Four$-$day moving average forecasts for January $8$th through January $30$th using the original $($seasonalized$)$ sales data. $(3$pts$)$

$3.$ Twelve$-$day moving average forecasts for January $16$th through January $30$th using the original $($seasonalized$)$ sales data. $(3$pts$)$

Note that, for example, you will not be able to make a four$-$day moving average forecast for January $7$th since four previous sales figures are required.