Cost function using regression; scatter plots; three potential cost drivers Laura Mills is the controller of Peer Jets International, a manufacturer
Cost function using regression; scatter plots; three potential cost drivers
Laura Mills is the controller of Peer Jets International, a manufacturer of small corporate jets. She has undertaken a project to study the behaviour of overhead cost. She has assembled factory overhead data for the last 30 months from the company’s manufacturing facility. Laura has asked you to develop a model to predict the level of manufacturing overhead.
Required
(a) Create a scatter plot of manufacturing overhead for each of the potential cost drivers.
(b) Would you eliminate any of the potential cost drivers based on the scatter plots? Why?
(c) Explain why you create a scatter plot of the data before you perform regression analysis.
(d) To practice your regression analysis skills, perform a simple regression analysis of manufacturing overhead for each of the three potential cost drivers. Write the cost function from each regression.
(e) Based on the simple regression results, which cost driver does the best job of explaining manufacturing overhead costs? Explain.
(f) Do your regression results support your answer to part (b)? Explain.