Additional homework problems are available at www. pearsonhighered.com/bozarth. These problems use Excel to generate customized problems for different class sections or even different students. (*=easy, moderate: *** advanced) For problems through 3, use the following time series data: PERIOD 10 11 12 13 14 DEMAND 248 370 424 266 444 1. (*) Develop a three-period moving average forecast for periods 13-15. 2. (*) Develop a two-period weighted moving average fore. cast for periods 12 through 15. Use weights of 0.7 and 0.3, with the most recent observation weighted higher. 3. (*) Develop an exponential smoothing forecast (a = 0.25) for periods 11 through 15. Assume that your forecast for period 10 was 252. For problems 4 through 6, use the following time series data: MONTH DEMAND January 2012 February March April May June 119 72 113 82 82 131 111 116 89 95 8B 90 July August September October November December 4. (**) Develop a three-period moving average forecast for April 2012 through January 2013. Calculate the MFE, MAD. values for April through December 2012 5. (**) Develop a two-period weighted moving average fore- cast for March 2012 through January 2013. Use weights of 0.6 and 0.4, with the most recent observation weighted higher. Calculate the MPE, MAD, alues for March through December 6. (**) Develop an exponential smoothing forecast (a = 0.3) for February 2012 through January 2013. Assume that your forecast for January 2012 was 100. Calculate the MFE, MAD, values for February through December 2013