An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

تمرين 12

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 rime 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.