Using the data in Solved Problem 10-3, develop a spreadsheet for a two-period weighted moving average forecast with weights of 0.6 1w12 for the most recent period and 0.4 1w22 for the other period. Note these weights sum to 1, so the forecast is simply Forecast for next period = w11Value in current period2 + w21Value in last period2 Find the weights for this two-period weighted moving average that would minimize the MAD. (Hint:

The weights must sum to 1.)