The file P16_04.xlsx contains monthly data on production levels and production costs during a 4-year period for a company that produces a single product. Use simple regression on all of the data to...

The file P16_04.xlsx contains monthly data on production levels and production costs during a 4-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced.


Use the resulting equation to predict total cost in month 49, given that the proposed production level for that month is 450 units. Do you see anything “wrong” with the analysis? How should you modify your analysis if your main task is to find an equation useful for predicting future costs, and you know that the company installed new machinery at the end of month 18? Write a concise memo to management that describes your findings.