I need help on this last portion. Please show work in excel. Assuming the past two years represent the expected level of costs and activity for the coming year, what activity cost rate for quality inspections should be used to assign costs to products in the coming year?

Much appreciated!

B. =Correlation C. = RSQ Quality Inspections Cost Units Produced $ 1,626 Batches $ 2,044 83,481 105, 939 achine Hours $ 1,736 57 Direct Labor Hours 16,353 138,215 25,598 10,518 $ 2,401 82 , 028 Correlations 84 $ 2,280 89,964 Cost of units produced 13,136 $ 1 267 Rounded 12167 17,125 -0.12 25 LDBL MACH Batch 130 727 148 Rounded 1.83678273 27,485 Cost with Machine Hours 10 ,528 $ 2,391 84 843 R5Q. 0.014851 0.84 27,776 Rounded 0.13 11, 299 28 Cost with Direct Labor Hours Rounded D.09632 $2,418 0. 700205337 19,183 R50. 93,504 RSQ - Rounded 156 RSQ - Rounded .017875 BD RSO. -0.10 D09278 $ 774 95 ,214 161 RS 0.70 21,745 RSQ - Rounded 10,746 RSQ - Rounded $ 2,332 117 , 356 56 27 ano 120 26 ,631 11, 748 $ 2,572 $ 1,918 112 ,073 21,225 11,685 82, 702 14,621 $ 1,819 $1, 326 148, 925 139 27,087 13,986 $ 1,648 26,939 10,490 $ 1,882 118 , 270 18 , 323 115, 109 $ 2,125 27, 161 90, 066 18, 017 14,573 $ 1, 75 130, 190 $ 1,061 131 , 078 11, 307 100 , 707 12,683 148, 448 17.705 15 , 184 $2, 16 118, 074 18, 166 12,374 $1,57 $ 1,69 138 106 108 , 828 25 ,257 18, 092 131,576 17,036 89 , 104 106 , 560 87, 025 1.5 54 128, 015 143, 200 128 , 785 $ 2,22 142, 728 $1,371 35,737 82,081 149 , 748 $ 2,268 100 , 344 101,425 89,539 117,345 98 , 056 83, 271 $ 2,04 114,017 141, 278 131, 427 205, 897 105 , 366 2,574 135 ,404 118 ,37 7 108 , 169 EDIE GET 117, 651 145, 299 86T'GET 138 , 232 149 , 345 100 , 025 192,206 2,02 126 , 032 83 , 548 95 ,736 100,358 80 340 137 ,565 30 : 286 119 , 616 115 , 210 104, 454 37 ,479 ISZ' GET $2,45 128, 002 $ 2, 638 111 , 798 106 , 219 $2,207 116 , 886 $1, 135 112, 606 $1,305 92, 930 $1, 100 85, 927 $2,131 128,DO1 138 , 025 $ 1,928 105 ,397 $1,276 38, 465 $ 1,527 118, 707 $ 2,176 144, 143 $ 1,564 80, 889 94 , 066 D. Based on your analysis, which activity driver do you recommend? Why? Based on the analysis that I have done above, I would choose to recommend Batches as the activity driver. Reason being is that Batches are the only one that are nearest to 1.Which provides me with the truest data with its coordination and RSQ. that is not negative as is the case with several other cases listed here. Assuming the past two years represent the expected level of costs and activity for the coming year, what activity cost rate for quality inspections should be used to assign costs to products in the coming year