(Solution Download) The president of a small manufacturing firm is concerned about

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 Excel Solver or LINGO to find the parameters for the line that minimizes MSE 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 nextyear.

 

About this question: