2. PPE Inc. produces toys for kids from 1 to 3 years old. The toy sales data is shown as follows: (Take a screenshot of your Excel spreadsheet and paste it to the answer section) (30 points) Period Demand 2017 September 9299 October 10619 November 7304 December 5976 2018 January 9700 February 9226 March 9717 April 11226 May 9718 June 9135 July 10702 August 11289 September 10210 October 10703 November 12179 December 11683

a. What is the forecasted demand of April 2018, using the four-period moving average technique? (

b. What is the forecasted demand of April 2018, using the weighted four-period moving average technique? Use weights of 0.5, 0.3, 0.1, and 0.1 for the most recent period, the second most recent period, the third most recent period, and the fourth most recent period, respectively. c. What is the forecasted demand of April 2018, using the exponential smoothing method? Assume the forecast for period 1 (January 2018) is 9500 and alpha = 0.5. (10 points) (Note: the period 1 is Jan 2018, not Sep 2017)