16. 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 r2.

b. Which driver do you recommend?

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

Transcribed Image Text:

Circuit Board Week Assembly Support Cost Direct Labor Hours Number of Average Boards Completed Cycle Time 11 123456TBRONNERO72222222 $66,402 7,619 2,983 186.44 $56,943 7,678 2,830 139.14 $60,337 7,816 2,413 151.13 $50,096 7,659 2,221 138.30 $64,241 7,646 2,701 158.63 $60,846 7,765 2,656 148.71 $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 $53,345 7,771 2,338 142.97 $65,027 7,842 2,685 176.08 $58,220 7,940 2,602 150.19 $65,406 7,750 2,029 194.06 $35,268 7,954 2,136 100.51 $46,394 7,768 2,046 137.47 $71,877 7,764 2,786 197.44 18 $61,903 7,635 2,822 164.69 19 $50,009 7,849 2,178 141.95 20 $49,327 7,869 2,244 123.37 $44,703 7,576 2,195 128.25 $45,582 7,557 2,370 106.16 $43,818 7,569 2,016 131.41 $62,122 7,672 2,515 154.88 $52,403 7,653 2,942 140.07