Question: question 13 demand data for thirty days have been provided...

Question 13:

Demand data for thirty days have been provided, along with computed weighted moving average forecasts for days six to thirty, using weights of 0.5, 0.3, 0.1, 0.05, and 0.05, with the largest weight on most recent demand. Please compute the Mean Suared Error (MSE) for the 25 forecasts, and then use SOLVER to find the five weights that will minimize the MSE. Note that your weights must sum to one, and it is OK for some of the weights to be zero.

Report your new (optimized) value for the MSE, to two decimals.