Several years ago, Roberson Robotics outsourced component BF-365, a key component of many of its products. At the time, CFO Sam Summers concluded that outsourcing was the correct decision, but she decided to revisit that decision after overhearing some conversations on the factory floor and in the cafeteria. Based on these conversations, she has gathered information about the materials quantity variance for the part, as well as on time delivery information of the part from the supplier and on-time delivery of the finished products to customers. Roberson Robotics uses ajust-in-time inventory system, so it receives multiple shipments of BF 365 each day. Summers has asked you to examine the data and provide insights about the continued desirability of outsourcing component BF-365. Click here to view the Excel data files for answering this problem. (b) Calculate the percentage of late deliveries from the supplier and the percentage of missed customer delivery dates. (Round answers to 1 decimal place, eg. 52.5.) 96 Percentage of late deliveries from suppliers Percentage of missed customer delivery dates BF-365 Quantity Yeek Yariance 1 $ 1,704 F 2 $ 1188 U 3 $ 1,999 F 4 $1,814 F 5 $ 1,743 F 6 $ 1,153 F 7 $ 1,101 U 8 $ 1,162 U 9 $ 208 F 10 $ 647 U 11 $ 1.511 F 12 $ 812 F 13 $ 1,090 F 14 $ 545 U 15 $ 793 F 16 $ 555 F 17 $ 1,253 U 18 $ 1,641 F 3 19 $ 1157 F 20 $ 1688 U 21 $ 933 F 3 22 $ 64 F 23 $ 1075 U 5 24 $492 F 6 25 $ 497 E 7 26 $ 1058 U 8 27 $ 1502 U 3 28 $ 443 U 0 29 $1216 F 1 30 $ 325 2 31 $ 1,801 F 3 32 $ 1035 F 4 33 $ 653 F 5 34 $ 301U -6 35$ 320F 36 $ 1,834 F 37 $ 610 F 38 $ 567 U 39 $ 198 F 40 $ 1,909 F 756 U 42 $ 774 F 43 $ 1,272 U 44 $ 847 F 45 $ 626 U 46 $ 1,921 U 47 $ 1,229 F 48 $ 354 U 49 $ 413 F 50 $ 59 F 51 $ 183 F 52 $ 1,305 F 53 $ 898 U 54 $ 1,066 U 55 $ 627 F 56 $ 963 F 57 $ 602 F 58 $ 1.949 U 59 $ 826 F 60 $ 328 U 61 $ 1,074 U 62 $ 1827 F 63 $ 1,379 U 64 $ 201 F 65 $ 444 U 66 $1.474 U 67 $ 1.127 U 68 $ 993 F 69 $ 1960 70 $ 1,158 F 71 $ 82 F 72 $ 1.296 U 73 $1,800 F 70 $ 1,158 F 71 $ 92 F 72 $ 1,296 U 73 $ 1.800 F 74 $ 649 F 75 $ 388 F 76 340 F 77 $1,858 U 78 $ 668 U 79 $ 270 F 80 $1,602 U 81 $1,092 U 82 $1,533 F 83 $ 1.996 F 84 $1,453 U 85 $ 452 U 86 $ 1,966 F 87 $1622U 88 $ 1.803 U 89 $ 1,930 U 90 $ 691 U 91 $ 366 U 92 $ 1,479F 93 $ 1,076 U 94 $1,286 U 95 $ 1,176 U 96 $ 464 F 97 $ 935. U 98 $ 1,993 U 99 $ 61 U 100$ 725 U 101 $ 1,154 U 102 $ 334 U 103 $ 1.303 U 104 $ 1010U A E Number of missed customer Veel 00 NN 1 2 7 2 8 1 4 5 3 5 2 - 149 2 3 4 5 6. 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Total number of Number of Total number BF-365 late BF-365 of customer shipments shipments shipments 34 138 15 6 169 22 3 183 10 4 108 23 5 60 30 2 132 10 4 25 35 3 47 33 0 118 37 6 109 32 32 19 2 24 6 125 23 0 29 23 2 169 21 6 98 33 188 38 152 25 6 161 32 4 135 17 5 106 37 163 11 3 64 22 2 167 38 5 183 11 37 16 28 17 5 172 16 5 152 26 5 139 23 1 164 18 2 114 33 0 146 31 6 166 ho ON 0 1 1 NOIN US 01 09 00 N O NOUS NU 5 5 7 0 4 3 5 0 0 6 5 1 3 5 3 6 0 4 3 hoc 8 B106 x to CI C D 36 37 38 39 40 ON 0 7 3 42 43 44 45 46 47 18 19 5 5 3 2 5 0 6 3 3 4 4 3 2 1 7 6 8 5 6 3 1 18 8 3 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 51 52 53 54 55 56 57 58 59 50 51 52 53 54 55 56 57 58 59 26 15 11 19 12 10 28 13 32 36 30 17 28 16 14 26 16 15 34 39 19 14 13 25 30 36 22 18 32 30 10 36 13 40 18 37 36 38 4 3 170 168 81 171 25 48 115 90 138 151 53 86 132 146 25 200 167 190 100 91 83 171 46 46 153 108 116 92 135 141 70 54 169 80 110 178 146 132 8 7 5 6 2 0 1 0 4 3 1 4 5 5 0 2 6 4 5 0 0 4 2 3 3 2 9 8 % 898989881 010 N 8 6 5 3 2 8 70 11 12 73 ONUN No - 73 38 19 10 30 36 ung br 75 76 9 3 6 5 9 12 12 8 8 4 11 9 7 1 0 3 3 0 3 2 0 7 79 81 81 82 83 84 85 86 20 18 17 35 10 39 27 21 33 34 12 17 10 34 24 15 34 25 23 17 34 26 25 32 5 3 6 4 12 8 4 11 4. 9 - a gp fry + 5 W T -- 87 88 89 90 91 92 93 34. 95 96 37 98 99 100 11 102 103 104 46 132 112 111 132 70 109 20 100 129 68 157 31 117 83 162 113 161 148 55 28 112 1] 85 36 34 186 196 148 102 29 63 30 133 - - - - N O - * 26 20 8. 10 10 12 10 12 12 14 35 24 19 30 20