answer question 3 and must include work from excell

3. Right now Fred's company uses two suppliers for its injection-molded pager cases: Casey's Cases and Krank Cases Managers at his company want to consol- idate all the business for that part with one of the two suppliers, but before doing so they need to certify which supplier will be more likely to deliver a steady flow of reliable parts. As Fred's boss put it once, "Don't put all your eggs in one basket, that is, unless you know it's a darn good basket." The managers agree that the weight of the casing has a lot to do with how well it fits together: too light and the mold must not have filled properly; too heavy and excess "flash" or plastic may have overflowed the mold. As a comparison, purchas- ing agents from Fred's company weighed random sam- ples of incoming cases and tracked them by supplier. Samples of five cases each were taken from 20 daily shipments sent by each supplier. The data the agents collected is provided below. The target spec is between .9 and 1.4 ounces per case. a) What would be the UCL and LCL for each sup- plier's X and R-charts? b) Do the charts from part (a) indicate any lack of control? c) Assess the accuracy and precision of Casey's Cases and Krank Cases. d) How comfortable would you feel consolidating the supply of this part with either Casey's or Krank Cases? Which company would you choose? Why? 1.3 Casey's Cases Sample Case #1 Case #2 Case #3 Case #4 Case 15 1 1.1 1.2 1.1 1.2 1.1 2 1.1 1.27 1 1.1 1 3 1.2 1.1 1.1 1.1 1.1 4 1.2 1.3 1.2 1.1 1.1 5 1.1 1.3 1.1 1.2 1.2 6 1.2 1.1 1.1 1.2 7 1.2 1.1 1.1 1.2 1 8 1.1 1.1 1.3 1.2 1.3 9 1.2 1.2 1.2 1.3 1.3 10 1.3 1.1 1.1 1.2 1.1 11 1.1 1.2 1.1 1.2 12 1.1 1.2 1.2 1.1 1.2 13 1.2 1.1 1.1 1 1.2 14 1.2 1.1 1.2 1.3 15 1.2 1.1 1.1 1 1.2 16 1.2 1.1 1.1 1.2 1.2 17 1.1 1.2 1 1.2 1.2 18 1.1 1.3 1.2 1.2 19 1.2 1 1.2 1.2 20 1.1 1.2 1 1.2 1.1 Krank Cases 1.2 1.1 1.2 1.2 Sample Case #1 Case #2 Case #3 Case #4 Case 5 1.4 0.9 1.1 1 2 3 4 5 6 7 8 9 1.1 1.1 1 1.2 1.1 0.9 1.3 0.9 1 1.2 1.4 1.1 1.3 1.2 0.9 1.4 1.1 1.3 1.1 1.4 1.4 1.4 1.1 1.2 0.9 0.9 1.4 1.4 1.1 1.2 1.3 1.2 1.2 0.8 0.9 1 1.1 0.9 1 1.1 1.1 1.2 1.3 0.9 1.5 1.5 1.1 1.2 1.3 1.4 0.9 0.9 11 12 13 14 15 16 17 18 19 20 1.2 1.1 1.1 1.3 1.4 1.4 1.3 1.2 0.9 1.1 0.9 1.1 1.1 1.5 1.2 0.9 1 1.2 1.4 1.4 1.2 1 1.4 1.1 1 1 1.3 1.2 0.8 0.9 1 1.4 1.2 1.2 1.2 1.3 0.9 1.4 1.2 1.2 1.2 1.2 1.2