a) Construct a time series plot. What type of pattern exists in the data? b) Develop a weighted moving average forecast with the folowing weights (First month =0.25; Second Month =0.35, and Third Month =0.40. Determine the forecast for Month 13 c) Use =0.30 to compute the exponential smoothing values for the time series. Assume that F1=A1. Determine the forecast for Month 13 d) Compute the MAD and MAPE for both forecasting methods e) Which of the two forecasting methods is better and why? 14. Sales Forecasts. The following time series shows the sales of a particular product over the past 12 months. DATAfile MonthlySales a) Construct a time series plot. What type of pattern exists in the data? b) Develop a weighted moving average forecast with the folowing weights (First month =0.25; Second Month =0.35, and Third Month =0.40. Determine the forecast for Month 13 c) Use =0.30 to compute the exponential smoothing values for the time series. Assume that F1=A1. Determine the forecast for Month 13 d) Compute the MAD and MAPE for both forecasting methods e) Which of the two forecasting methods is better and why? 14. Sales Forecasts. The following time series shows the sales of a particular product over the past 12 months. DATAfile MonthlySales