answer letters a-e please.

B. [20 points) FTW Engineering is an aftermarket automobile parts manufacturer. One popular component they manufacture is a Cold Air Intake (CAI). The summary of sales from 2018 October to 2019 December for the CAls is given in the table below. You are hired to determine the best technique for forecasting the CAI demand based on the given data. Jan Month Oct Sales 797 Nov 1134 Dec 987 Feb 786 Mar 1254 Apr 691 May 1256 Jun 200 724 Jul Aug Sep Oct Nov 1192 751 724 699 1193 Dec 1130 a. Calculate a forecast for 2020 using simple three month moving average. b. Calculate a forecast for 2020 using three-period weighted moving average. Use weights of 0,6, 0.3, and 0.1 for the most recent period, the second most recent period, and the third most recent period, respectively. C. Calculate a forecast for 2020 using the exponential smoothing method. Assume the forecast for period 1 is the average demand for all the data. Use alpha=0.3. d. The actual sales for 2020 is given in the table below. Determine the forecast error for each of the above three methods using cumulative forecast error and mean square error methods. Jul Month Jan Sales 696 Feb 665 Mar 1179 Apr 760 May Jun 1150 771 Aug Sep Oct 826 696 750 Nov Dec 1212980 1175 e. Which method produced the best forecast? Why? What forecast error did you use to arrive at above conclusion? How could you improve upon this forecast