awnser 3 a - c and 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 damn 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 HOOLS FOR THE IMPROVEMENT OF CUSTOMER SATISFACTION ting the -Krank Thy? 25 you, and you tell the service manager about them when you take the car in for adjustments. The manager assures you that the assembly plant is always seeking to improve its performance, but there are an infinite number of minor nonconformities on a new car, and the dealer always takes care of them. Curious to test your newly certified capability for critical thinking, you press further and find that on occasion, the service manager does decide that nonconformities are getting out of hand and calls the factory to find out what the problem is. You suggest you can help. so he provides you with the following data, recorded over the last few months. Assume that the dealer sells the same number and mix of cars each week, and that all come from the same factory Week 1 2 3 4 5 6 7 8 No. of Adjustments 34 22 1827 44 156 34 a) Will statistical process control help to solve this problem? What type of chart should you use? b) is the system under control now? c) What set of rules would you suggest the service manager use? Can you reconcile this answer with the material in Chapters 5 and 67 which aner mill measures nerfor