G 1 Problem 1. Here are the data for the past 21 months for actual sales of a particular product: K M N 0 400 Last Year This Year January 300 225 February 400 375 March 425 350 April 450 425 May 400 Yure 460 350 10 July 400 350 11 Aucu 300 275 12 September 375 350 13 October 500 30 November 550 15 December 500 26 Develop aforecast for the fourth quarter using three quarter, weighted moving average Weight the most recent quarter S, the second most recent 25, and the third 25. Do the problem using 27 quarters, as opposed to forecasting parte months 18 Insert your formula in these cells. Remember that all formulas 29 begin with a 20 Sales amounts of the third most recent quarter 21 Sales amounts of the second most recent quarter 22 Sales amounts of the most recent quarters K23 25 The weight of the most recent quarter The weight of the second most recent quarters The weight of the third most recent quarter 0.25 Weighted Moving Average (WMA) D L M N 1 Problem 1. Here are the data for the past 21 months for actual sales of a particular product 0 HUSBBWN 500 Last Year This Year January 300 275 February 400 375 March 425 350 April 450 425 May 400 400 9 June 460 350 20 July 400 350 11 August 300 275 12 September 375 350 13 October 14 November 550 15 December 500 16 Develop a forecast for the fourth quarter using a three quarter, weighted moving average. Weight the most recent que 5, the second most recent 25, and the third 25. Do the problem using 17 quarters, as opposed to forecasting separate months. IB Insert your formula in these cells. Remember that all formulas 19 begin with a 20 Sales amounts of the third most recent quarters 0 21 Sales amounts of the second most recent quarter 22 Sales amounts of the most recent quarter 23 24 The weight of the most recent quarter 25 The weight of the second most recent quartere 26 The weight of the third most recent quarter 0.25 27 + Weighted Moving Average /WMA) 29