Please answer to below questions. Thank you!

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 1 through 3, use the following time series data: PERIOD DEMAND 10 248 11 370 12 424 13 286 14 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 119 February 72 March 113 April 82 May 82 June 131 July 111 August 116 September 89 October 95 November 88 December 904. (**) 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 MFE, MAD, values 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