5. Unweighted Moving average (please be kindly advised that you need to develop an excel spread sheet for your solution).: F-1 = X, +X-1+ Xc.n+1 The shoes sales of K-footwear for the periods of 1 through 7 show as the following units (in thousands): periods sales, units, 000 omitted n 1 2 3 4 5 6 7 8 9 10 120 134 138 141 146 157 159 152 146 143 a. Forecast the sales for Period 11, using a four most recent period unweighted moving average method: F1 = b. Assuming that actual sales for Period 11 were 152,000 units. Forecast the sales for Period 12, using a four most recent period unweighted moving average method: F12 = c. Using a four most recent period unweighted moving average method and weighted moving average to forecast sales in Period 5 through 10 (please be kindly advised that you need to develop an excel spread sheet for your solution): unweighted moving weighted moving average, sales, units, average, using 4 most using 4 most recent Periods 0000 omitted recent periods periods 1 2 3 4 120 134 138 141 5 6 7 146 157 159 152 146 143 8 9 10