Total 48 marks, each carry 24 marks 1. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare a three-month moving average forecast with an exponential smoothing forecast for alpha 0.2. Which provides the better forecasts using MSE, MAE & MAPE as the measure of model accuracy? c. What is the forecast for next month? 2. Corporate triple A bond interest rates for 12 consecutive months follow. 9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6 a. Construct a time series plot. What type of pattern exists in the data? b. Develop three-month and four-month moving averages for this time series. Does the three-month or four-month moving average provide the better forecasts based on MSE, MAE & MAPE? Explain. c. What is the moving average forecast for the next month