Answer using Excel***

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: Month Price Per Chip ($) January 1.80 February 1.67 March 1.75 April 1.85 May 1.90 June 1.87 July 1.90 August 1.83 September 1.70 October 1.65 August 1.83 September 1.70 October 1.65 November 1.70 December 1.75 A. (3 points) Naive method and a 3-month moving average. B. (4 points) A 6-month weighted average using .1,.1,.1, 2, .2, and .3, with the heaviest weights applied to the most recent months. C. (4 points) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use a = .1, then a = .2, and finally a = = .4. D. (4 points) A trend projection. E. (5 points) Comparing MAD, MSE, and MAPE results, which forecasting method is the best