Use a $3-$period moving average to forecast next week$$s demand for our product. Historical$$records $($oldest to newest$)$ show $5346,7812,6513,5783,5982,6519,6222,5577,6840,7300$for the past $10$ weeks.$$What effect $($smoothing or responsive$)$ would there be if we moved to a $5-$period moving$$average $($Hint: calculations are not necessary to answer this question$)?$Using a two$-$period moving average, use Excel$$s solver to determine optimal weights that$$minimize the Mean Absolute Error.$$Also within Excel, using regression, what will your forecast model be for next week$$s demand?