1.62 2.044 10.518 13.136 149 Plyler Plastics Company produces a variety of custom plastics products for a worldwide clientele. The company's cost accounting manager, Martha Johns, is beginning to implement an activity-based costing system and has gathered data on the quality inspections activity. She is unsure what the most appropriate driver is for this activity cost pool, but she is considering number of units produced, number of batches produced, machine hours, and direct labor hours. She has gathered weekly Information for the past two years and has asked you to help her determine which activity driver to select. DUN wwwwwww 1.267 2904 2418 105.839 138215 52628 99.004 130.227 54.849 93.504 95.214 117356 112.073 32.702 14R.25 10.52 11.299 16,180 10.746 11,745 11,585 14.821 13,886 774 123 131 Click here to view the data in Excel. 2.332 2.572 1.915 1,819 117 143 1.648 1.882 2,175 1.962 1.751 1.061 118.270 115,109 30.06E 130,00 131.078 100,707 148,448 153 18,323 15,574 14.573 14.447 11,907 16,184 16,107 12,374 18.092 14,553 17.GE 13.64 16.498 64 Using Excel's CORREL formula, determine the correlation between each activity driver level and the inspections cost. (Round answers to 3 decimal places, eg. 52.752. Enter negative amounts using either a negative sign preceding the number eg.-45 or parentheses e.s. (451) 2,166 1.891 2.647 112 107 134 Correlation 60 138,100 108,028 131,576 123,399 89,104 100,000 97.026 133,661 128,015 Units produced 1.027 63 61 16.353 25.598 25 416 27,485 27.776 19.183 21.745 22.905 26.631 21.226 21,317 27 087 26,939 17.269 27,161 18.017 27.124 12,683 17,705 19,261 18.166 25,957 19,470 17,038 19,045 20.018 16,205 18,393 18,437 10,925 17,337 18.559 10,099 20,995 22,561 23,730 17,493 16,047 10,768 26,647 14,015 18,850 14,751 19,805 11,061 26.449 16,832 26.212 23.126 11.415 14,396 20.14 27.544 18207 18511 13.952 12.194 Machine hours 1.958 1,554 123 Batches 32 $ 11,105 13,035 10,821 16,552 15,828 17,726 16,693 17.733 12,100 11,717 10,257 18,412 12,713 12,854 165 Direct labor hours 34 3 35 5 128.785 142.72e 26,737 14.023 82.041 149,740 100.344 101,425 2.880 2 224 1.371 920 1.395 2.474 2.268 38 3 39 3 40 5 101 169 Save for Later Attempts: 0 of 12 used Submit Answer 160 U U 168 143 109 150 117 122 102 w The parts of this question must be completed in order. This part will be available when you complete the part above. 117.345 2.257 86.370 2.422 28.05 1.532 33.274 2.590 10718 1,701 114,017 2.040 141.278 1 Soe 131.427 2,152 375TE 1,705 105.97 1.091 137.80 1.285 105.86 1.745 113.491 135,404 118.977 108,100 1.236 139,303 141 TE Analytics Problem 7-32 Dataset + 14,494 10.681 12.276 10.502 13,5.BE 14.023 17,597 16.291 11.155 13.084 17.051 13.152 14.63 16 630 14.750 13,451 17.082 101 65 03 155 (d) 79 The parts of this question must be completed in order. This part will be available when you complete the part above 1.62 2.044 10.518 13.136 149 Plyler Plastics Company produces a variety of custom plastics products for a worldwide clientele. The company's cost accounting manager, Martha Johns, is beginning to implement an activity-based costing system and has gathered data on the quality inspections activity. She is unsure what the most appropriate driver is for this activity cost pool, but she is considering number of units produced, number of batches produced, machine hours, and direct labor hours. She has gathered weekly Information for the past two years and has asked you to help her determine which activity driver to select. DUN wwwwwww 1.267 2904 2418 105.839 138215 52628 99.004 130.227 54.849 93.504 95.214 117356 112.073 32.702 14R.25 10.52 11.299 16,180 10.746 11,745 11,585 14.821 13,886 774 123 131 Click here to view the data in Excel. 2.332 2.572 1.915 1,819 117 143 1.648 1.882 2,175 1.962 1.751 1.061 118.270 115,109 30.06E 130,00 131.078 100,707 148,448 153 18,323 15,574 14.573 14.447 11,907 16,184 16,107 12,374 18.092 14,553 17.GE 13.64 16.498 64 Using Excel's CORREL formula, determine the correlation between each activity driver level and the inspections cost. (Round answers to 3 decimal places, eg. 52.752. Enter negative amounts using either a negative sign preceding the number eg.-45 or parentheses e.s. (451) 2,166 1.891 2.647 112 107 134 Correlation 60 138,100 108,028 131,576 123,399 89,104 100,000 97.026 133,661 128,015 Units produced 1.027 63 61 16.353 25.598 25 416 27,485 27.776 19.183 21.745 22.905 26.631 21.226 21,317 27 087 26,939 17.269 27,161 18.017 27.124 12,683 17,705 19,261 18.166 25,957 19,470 17,038 19,045 20.018 16,205 18,393 18,437 10,925 17,337 18.559 10,099 20,995 22,561 23,730 17,493 16,047 10,768 26,647 14,015 18,850 14,751 19,805 11,061 26.449 16,832 26.212 23.126 11.415 14,396 20.14 27.544 18207 18511 13.952 12.194 Machine hours 1.958 1,554 123 Batches 32 $ 11,105 13,035 10,821 16,552 15,828 17,726 16,693 17.733 12,100 11,717 10,257 18,412 12,713 12,854 165 Direct labor hours 34 3 35 5 128.785 142.72e 26,737 14.023 82.041 149,740 100.344 101,425 2.880 2 224 1.371 920 1.395 2.474 2.268 38 3 39 3 40 5 101 169 Save for Later Attempts: 0 of 12 used Submit Answer 160 U U 168 143 109 150 117 122 102 w The parts of this question must be completed in order. This part will be available when you complete the part above. 117.345 2.257 86.370 2.422 28.05 1.532 33.274 2.590 10718 1,701 114,017 2.040 141.278 1 Soe 131.427 2,152 375TE 1,705 105.97 1.091 137.80 1.285 105.86 1.745 113.491 135,404 118.977 108,100 1.236 139,303 141 TE Analytics Problem 7-32 Dataset + 14,494 10.681 12.276 10.502 13,5.BE 14.023 17,597 16.291 11.155 13.084 17.051 13.152 14.63 16 630 14.750 13,451 17.082 101 65 03 155 (d) 79 The parts of this question must be completed in order. This part will be available when you complete the part above