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.

Using a two$-$period moving average, use Excel$$s solver to determine optimal weights that

minimize the Mean Absolute Error. use Excel