A circuit board manufacturer is trying to determine the appropriate cost driver for estimating the cost of circuit board assembly support. The list of potential cost drivers has been narrowed to three: direct labor hours, number of circuit boards completed, and average cycle time. In preparation for a simple linear regression analysis, a data collection activity has been completed. The results of the data collection are shown in the table below. Use this data to complete the following:

a. Determine a regression line for each of the three possible cost drivers. For each possible driver:

(i) plot a graph of the cost driver versus the support cost;

(ii) determine and clearly state the regression equation; and

(iii) determine and clearly state the associated \(\mathrm{r}^{2}\).

b. Which driver do you recommend?

c. What percentage of the data does your driver and regression equation explain?

Transcribed Image Text:

Week Circuit Board Assembly Support Cost Direct Number of Labor Hours Boards Completed Average Cycle Time 1 $66,402 7,619 2,983 186.44 2 $56,943 7,678 2,830 139.14 3 $60,337 7,816 2,413 151.13 4 $50,096 7,659 2,221 138.30 5 $64,241 7,646 2,701 158.63 6 $60,846 7,765 2,656 148.71 7 $43,119 7,685 2,495 105.85 8 $63,412 7,962 2,128 174.02 9 $59,283 7,793 2,127 155.30 10 $60,070 7,732 2,127 162.20