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

Exercise 4

The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm's leading product over the past eight years:

a. Construct a time series plot. What type of pattern exists in the data
b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.
c. What is the average cost increase that the firm has been realizing per year
d. Compute an estimate of the cost/unit for next year.