View Policies Current Attempt in Progress 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. Click here to view Excel data (b) Using Excel's CORREL formula, determine the correlation between each activity driver level and the inspections cost. (Round answers to 3 decimal places, e.g. 52.752. Enter negative amounts using either a negative sign preceding the number eg.-45 or parentheses eg. (45).) Correlation Units produced Machine hours Batches Direct lahor hours Type here to search ORA a W D E A Week G 1 Batches 57 2 3 4 5 6 7 98 84 123 148 75 166 161 56 120 131 8 9 10 11 12 13 14 15 16 B Quality Insepctions Cost 1 $ 1,626 2 $ 2,044 3 $ 1,736 4 $ 2,401 5 $ 2,280 6 $ 1,267 7 $ 2,391 8 $ 2,418 9 $ 774 10 $ 2,332 11 $ 2,572 12 $ -1,918 13 $ 1,819 14 $ 1,326 15 $ 1,648 16 $ 1,882 17 $ 2,129 18 $ 1,962 19 $ 1,751 20 $ 1,061 21 $ 762 22 $ 2,166 23 $ 1,571 24 $ 1,691 25 $ 2,647 C Units Produced 83,481 105,939 138,215 82,028 89,964 130,227 84,843 93,504 95,214 117,356 112,073 82,702 148,925 125,663 118,270 115,109 90,066 130,190 131,078 100,707 148,448 118,074 138,106 108,828 131,576 Machine Hours 16,353 25,598 25,416 27,485 27,776 19,183 21,745 22,909 26,631 21,225 21,317 27,087 26,939 17,269 27,161 18,017 27,124 12,683 17,705 19,261 18,166 25,257 19,470 17,036 19,045 139 86 58 117 143 112 150 99 64 54 104 112 107 Direct Labor Hours 10,518 13,136 17,125 10,528 11,299 16,180 10,746 11,748 11,685 14,621 13,986 10,490 18,323 15,574 14,573 14,447 11,307 16,184 16,107 12,374 18,092 14,553 17,068 13,649 16,498 17 18 19 20 21 22 23 24 25 26 134 Case Question 7.32 b-e Case Question 7.32 b-e Dataset Sheet3 READY 18 a Type here to search W 1 PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing F11 X ft 21225 A B D F G 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 25 $ 26 $ 27 $ 28 $ 29 $ 30 $ 31 $ 32 $ 33 $ 34 $ 35 $ 36 $ 37 $ 38 $ 39 $ 40 $ 41 $ 42 $ 43 $ 44 $ 45 $ 46 $ 47 $ 48 $ 49 $ 50 $ 2,647 1,631 1,215 1,027 644 1,958 1,554 1,401 740 2,860 2,224 1,371 920 1,395 2,474 2,268 2,013 2,356 2,257 2,422 1,932 2,590 1,701 2,040 1,908 2,152 131,576 123,399 89,104 106,660 87,025 133,661 128,015 143,200 128,785 142,728 96,737 94,023 82,081 149,748 100,344 101,425 89,539 117,345 86,370 98,056 83,271 107,880 114,017 141,278 131,427 87,576 134 60 61 63 51 93 120 86 51 165 132 67 72 101 169 131 119 156 168 143 109 159 117 122 102 159 E 19,045 20,018 16,209 18,393 18,437 10,925 17,937 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,632 26,212 23,126 11,435 16,498 15,375 11,106 13,085 10,821 16,552 15,828 17,726 15,893 17,733 12,100 11,717 10,257 18,412 12,713 12,854 11,135 14,494 10,961 12,276 10,502 13,586 14,023 17,597 16,291 11,155 41 42 45 44 45 46 47 48 49 50 51 Case Question 7.32 b-e Case Question 7.32 b-e Dataset Sheet3 READY IUS I PORIN VIEW Enable Editing E11 X for 21225 A B D E G 51 52 53 54 55 56 57 58 59 60 61 62 63 50 $ 51 $ 52 $ 53 $ 54 $ 55 $ 56 $ 57 $ 58 $ 59 $ 60 $ 61 $ 62 $ 63 $ 64 $ 65 $ 66 $ 67 $ 68 $ 69 $ 70 $ 71 $ 72 $ 73 $ 74 $ 75 $ 2,152 1,705 1,091 1,285 1,749 1,899 2,574 1,460 1,236 1,451 2,052 1,246 -1,546 2,338 1,178 1,664 1,042 1,667 1,085 1,690 2,148 1,724 2,002 2,903 2,258 1,496 87,576 105,897 137,863 105,966 113,491 135,404 118,977 108,169 139,303 141,178 135,222 117,651 90,802 145,299 143,988 139,198 138,232 149,345 97,291 100,025 92,106 144,295 126,032 83,548 95,736 100,358 159 72 52 101 68 93 155 67 76 55 108 55 118 156 62 109 66 79 58 116 114 92 116 155 148 72 11,435 14,396 20,149 27,544 18,207 18,511 13,952 12,894 14,862 14,084 22,784 15,647 11,623 12,498 26,536 25,516 20,416 15,158 15,769 10,179 27,464 23,986 14,026 27,859 26,346 13,726 11,155 13,084 17,051 13,152 14,036 16,630 14,758 13,451 17,082 17,372 16,865 14,409 11,485 18,081 17,798 17,157 17,061 18,490 12,127 12,600 11,484 17,806 15,580 10,735 12,087 12,564 64 65 66 67 68 69 70 71 72 73 74 75 76 Case Question 7.32 b-e Case Question 7.32 b-e Dataset Sheet3 READY o Type here to search a PROTECTED VIEW Be carefullies from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing E11 1 x f 21225 B D G 76 77 78 72 107 77 110 79 107 80 81 82 83 84 85 86 87 75 $ 76 $ 77 $ 78 $ 79 $ 80 $ 81 $ 82 $ 83 $ 84 $ 85 $ 86 $ 87 $ 88 $ 89 $ 90 $ 91 $ 92 $ 93 $ 94 S 95 $ 96 $ 97 $ 98 $ 99 $ 100 $ 88 89 90 1,496 1,940 1,626 2,129 1,749 1,810 2,003 2,213 1,453 1,311 1,037 1,134 -2,371 2,428 2,467 2,638 2,400 2,107 1,139 1,306 2,885 1,100 2,131 1,811 1,928 1,276 73 110 99 57 102 65 60 124 115 169 164 100,358 104,231 80,340 137,565 82,523 97,869 90,266 119,616 115,210 104,454 88,748 139,251 97,479 128,002 111,798 106,219 116,886 142,368 112,606 92,930 85,927 128,001 138,025 105,397 88,465 118,707 13,726 14,854 18,798 12,692 24,803 23,296 15,686 27,074 13,688 23,384 19,517 12,888 17,916 18,031 22,302 21,894 11,629 19,878 10,829 22,443 14,086 21,742 25,300 25,729 22,027 25,246 12,564 12,927 10,234 16,882 10,498 12,276 11,481 14,844 14,113 13,033 10,893 17,237 12,142 15,953 13,962 13,343 14,705 17,618 13,777 11,710 10,972 15,807 16,943 13,039 11,082 14,510 91 92 125 93 94 95 96 97 91 52 96 152 87 148 80 127 67 98 99 100 101 Sheet3 Case Question 7.32 b-e Dataset Case Question 7.32 b-e READY 0 V F107 A B D E 32 G H 83 84 85 86 87 88 81 s 82 $ 83 S 84 S 85 S 86 $ 87 $ 88 $ 89 $ 90 $ 91 $ 92 $ 93 $ 94 $ 95 $ 96 $ 97 $ 98 $ 99 $ 100 $ 101 $ 102 $ 103 $ 104 $ 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 1071 108 2,003 2,213 1,453 1,311 1,037 1,134 2,371 2,428 2,467 2,638 2,400 2,107 -1,139 1,306 2,885 1,100 2,131 1,811 1,928 1,276 1,527 2,176 1,564 2,142 90,266 119,616 115,210 104,454 88,748 139,251 97,479 128,002 111,798 106,219 116,886 142,368 112,606 92,930 85,927 128,001 138,025 105,397 88,465 118,707 129,211 144,143 80,889 94,066 110 99 57 102 65 60 124 115 169 164 125 91 52 15,686 27,074 13,688 23,384 19,517 12,888 17,916 18,031 22,302 21,894 11,629 19,878 10,829 22,443 14,086 21,742 25,300 25,729 22,027 25, 246 23,519 20,821 22,465 12,640 11,481 14,844 14,113 13,033 10,893 17,237 12,142 15,953 13,962 13,343 14,705 17,618 13,777 11,710 10,972 15,807 16,943 13,039 11,082 14,510 15,988 17,874 10,197 11,702 96 152 87 148 80 127 67 99 113 118 165 Case Question 7.32 b-e Case Question 7.32 b-e Dataset Sheet3 READY CO) w Type here to search