Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 15

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 a 5 0.2. Which provides the better forecasts using MSE as the measure of model accuracy
c. What is the forecast for next month