A. (3 points) Use 3 and 4-month moving average on all the data and plot the averages B. (3 points) Use 3 and 4-month weighted moving average on all the data and plot the the prices. (0.5,0.3,0.2 for 3 month; and 0.4,0.2,0.2, and 0.2 for 4 month) C. (3 points) Compute the forecasts for each month using exponential smoothing, with forecast for January of $2.30. Use a=.1, then a=.3, and finally a=.5. D. (3 points) Compute the forecasts for each month using trend adjusting exponential s an initial forecast for January of $2.30 and trend $0.25. Use =.3, and =.4. E. (3 points) Develop a regression relationship. F. (5 points) Compare forecasting methods using MAD, MSE, and MAPE. HINT: ExcelOM calculates all formulas for you if you just plug in the numbers! Question 1 Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the pas. months were as follows