Scatter plots, cost function using regression, two potential cost drivers Suppose we need to predict the cost of maintenance for Brush Va
Scatter plots, cost function using regression, two potential cost drivers
Suppose we need to predict the cost of maintenance for Brush Valley High School for the upcoming school year. From the school district records we gather weekly data about costs and volumes for two potential cost drivers: labour hours used in the maintenance department and number of enrolled students.
Required
(a) Identify and explain two potential cost drivers for total maintenance cost, in addition to number of students and maintenance hours worked.
(b) Create a scatter plot, first for maintenance cost against hours worked and then maintenance cost against students.
(c) Would you eliminate either cost driver based on the plots? Explain.
(d) Perform regression analysis using each cost driver. Use your judgement to determine the most appropriate cost driver and write out the cost function for maintenance cost.
(e) Can we know for certain that the cost driver chosen in part (d) is the best cost driver? Why?