Objective: Lovell Levelers just reported that Specific Motors is a satisfied customer. The leveler plate quality is no longer an issue. In fact, they have not seen a single defect in six months! Phyllis Kendall made another surprise visit, but this time for a more pleasant reason. She presented each member of the team with a crisp, new $100 bill as a show of appreciation. But she also pointed out that we need to have a way to ensure that this problem will not crop up again. The team is one step ahead of her and explained that the thickness of the leveler plates is being monitored and controlled with an on-going XmR (Individuals and Moving Range) chart so that any assignable causes of variation will be detected and addressed quickly. The parameters affecting the product thickness are also being monitored with a capability study. Instructions for you: We want to make sure you can calculate control limits. You may construct the control chart by hand, or you may use a charting function in Excel. There are blank forms in the back of your notebook . Control Charts in Excel 2003 Control Charts in Excel 2007 1. 2. 3. 4. What is the upper control limit for the range? What is the upper control limit for the individuals? What is the lower control limit for the individuals? What would you do with the process? a. What would you recommend? b. Is the measurement system discriminate? c. Is thickness in statistical control? Help "I have no idea about this idea "I have no one" about this one" Data: Thickness data for XMR control chart Individual X Moving R 0.551 0.546 0.0050 1a. Calculate R-bar Calculating R-bar in Excel 2003 0.003471 0.547 0.0010 0.548 0.0010 Self check 0.003471 0.547 0.0010 0.547 0.0000 1b. Calculate the Calculating R-bar in Excel 2007 0.011338 0.538 0.0090 upper control limit 0.546 0.0080 for the range 0.542 0.0040 "How do I do that?" 0.543 0.0010 Self check 0.545 0.0020 0.547 0.0020 2 & 3. Calculate the UCL 0.555346 0.543 0.0040 control limits for the LCL 0.536883 0.548 0.0050 individuals 0.545 0.0030 "How do I do that?" 0.554 0.0090 Self check 0.549 0.0050 0.546 0.0030 0.545 0.0010 0.553 0.0080 0.549 0.0040 0.541 0.0080 0.542 0.0010 0.545 0.0030 0.546 0.0010 0.552 0.0060 0.546 0.0060 0.546 0.0000 0.545 0.0010 0.547 0.0020 0.548 0.0010 0.547 0.0010 0.545 0.0020 0.54 0.0050 0.545 0.0050 Average 0.5461142857 0.0034705882 Be sure to review the week 11 virtual class for more information on SPC and measurement discrimination before you submit this! Target Assignment Date - Submit in Week 13 or earlier YOU DO NOT NEED TO SUBMIT THE XmR CHART Project: Manufacturing 2015 Deliverable: XmR Chart Student last name: GUINYARD Calculated R-Bar: Upper control limit for the range: Upper control limit for the individuals: Lower control limit for the individuals: Is there adequate discrimination? Explain your answer: Which chart did you use and exactly how many strata are there on that chart? How many should there be? 0.003471 0.011338 0.555346 0.536883 ROUND YOUR FINAL RESULTS TO 6 DECIMAL PLACES. Yes there is adequate discrimination. I used the Range chart and there are 17 strata Check Check Check Check Help Based upon your analysis of the stability of this control chart, what would you do next? Help The process is in control; however it needs to be centered/tighten up the limits and reduced variation through continual monitoring Check How to submit an Assignment To send each assignment to your instructor: Click-and-hold the LEFT mouse button at the TOP-LEFT corner of the peach-colored box, then while holding down on that button, drag to the LOWER-RIGHT corner of the box. This will highlight the entire peach-colored box. Release the mouse button. Do a CTRL-C. This will copy what has been highlighted. Go to your Villanova website and follow this sequence: 1. COURSE MENU 2. CLASS ROSTER 3. Click on your instructor's email envelope icon 4. Type "Check My Work - XmR Chart" in the SUBJECT box. 5. Click once inside of the message box 6. Do a CTRL-V. This will paste your deliverable into this box. Don't be concerned if after you paste it, the appearance of the text is out of alignment. It will straighten out after you hit SEND. 7. SEND Check your SENT ITEMS folder afterward to see how it straightened out. Please 'hand-in' your assignments throughout the course. DO NOT SAVE THEM FOR THE END. Procrastinators: The deadline for having all project deliverables 100% correct is 7 days prior to the end of the course. Objective: So far, so good. The process has been in control for the past four months. Phyllis isn't as well versed in Six Sigma as the team is, and it is her nature to question everything. So she has asked for a capability study to be performed on two key process factors that affect leveler thickness and wants to see this for the past 35 days of production. You are on the spot, but confident. You pull up the past 35 day's worth of data and you calculate Pp and Ppk for each of these factors. Is Phyllis going to be happy or is she going to be more skeptical? That is the 'question of the day.' Crunch the numbers--and you will find out. By the way--finish this deliverable correctly AND MAKE ALL OF THE CORRECTIONS REQUIRED ON THE PREVIOUS ASSIGNMENTS and you are finished with the project! Congratulations!!! Instructions for you: "Is it possible for me to do a self-check?" Instructions for you: 1. Construct histograms for each of the parameters. Note: The first parameter 'thickness' is the product parameter. The second parameter is thought to affect thickness. 2. Are the processes approximately normally distributed? 3. Calculate Pp and Ppk for each. Note: The upper and lower specifications are listed at the bottom of each column. You will need these to do the calculations. 4. Are the processes acceptable? "I'm lost" "Can I do this with the Data Analysis Toolpak in Excel 2003?" "Can I do this with the Data Analysis Toolpak in Excel 2007?" Data: Data: Upper Specs Lower Specs Mean Sigma Pp Ppk Thickness 0.548 0.550 0.552 0.554 0.552 0.547 0.547 0.552 0.549 0.548 0.549 0.549 0.550 0.551 0.549 0.550 0.551 0.550 0.550 0.553 0.548 0.552 0.551 0.550 0.549 0.551 0.551 0.550 0.551 0.550 0.549 0.550 0.551 0.549 0.550 R.P.M. 4400 4400 4400 4400 4450 4450 4450 4450 4450 4450 4450 4450 4450 4500 4500 4500 4550 4600 4650 4650 4650 4700 4700 4700 4700 4700 4700 4700 4700 4700 4700 4750 4750 4750 4800 Thickness 0.5600 0.5400 0.5501 0.0016 2.1114 2.0933 R.P.M. 8000 2000 4580 132.4 7.5529 6.4955 0.0015787454 How to submit an Assignment Target Assignment Date - Submit in Week 14 or earlier YOU DO NOT NEED TO CREATE CONTROL CHARTS TO COMPLETE THIS ASSIGNMENT!! DO NOT SEND THE ACTUAL HISTOGRAMS UNLESS YOUR INSTRUCTOR ASKS YOU TO. Project: Manufacturing 2015 Deliverable: Pp Ppk Student last name: GUINYARD INSTRUCTIONS: (1) IF YOU SAY THE DISTRIBUTION IS NOT APPROXIMATELY NORMAL, GIVE THE CORRECT NAME FOR THE PATTERN YOU SEE IN YOUR HISTOGRAM. (2) BASE YOUR DECISION ON ACCEPTABILITY ON THE ASSUMPTIONS AND PATTERN YOU SEE IN YOUR HISTOGRAM. (2) BASE YOUR DECISION ON ACCEPTABILITY ON THE ASSUMPTIONS AND CRITERIA FOR Pp and Ppk DISCUSSED IN THE RECORDED LECTURES AND VIRTUAL CLASSES ON CAPABILITY. YOU DO NOT NEED TO CREATE CONTROL CHARTS FOR THIS ASSIGNMENT!! Thickness Pp (use 6 decimal places) Ppk (use 6 decimal places) Is this distribution approximately Normal? If it's not normal, what is the shape? Is this process acceptable? Explain your decision on acceptability. Round your Pp and Ppk results to 6 decimal places. R.P.M. Pp (use 6 decimal places) Ppk (use 6 decimal places) Is this distribution approximately Normal? If it's not normal, what is the shape? Is this process acceptable? Explain your decision on acceptability. 2.111381 2.093284 Yes Yes The process is acceptable because the distribution is almost normal 7.552945 6.495533 No Yes The process is acceptable because the distribution is almost normal To send each assignment to your instructor: Click-and-hold the LEFT mouse button at the TOP-LEFT corner of the peach-colored box, then while holding down on that button, drag to the LOWER-RIGHT corner of the box. This will highlight the entire peach-colored box. Release the mouse button. Do a CTRL-C. This will copy what has been highlighted. Go to your Villanova website and follow this sequence: 1. COURSE MENU 2. CLASS ROSTER 3. Click on your instructor's email envelope icon 4. Type "Check My Work - Pp, Ppk" in the SUBJECT box. 5. Click once inside of the message box 6. Do a CTRL-V. This will paste your deliverable into this box. Don't be concerned if after you paste it, the appearance of the text is out of alignment. It will straighten out after you hit SEND. 7. SEND Check your SENT ITEMS folder afterward to see how it straightened out. Please 'hand-in' your assignments throughout the course. DO NOT SAVE THEM FOR THE END. Procrastinators: The deadline for having all project deliverables 100% correct is 7 days prior to the end of the course. Check HINT! HINT! HINT! Check HINT! HINT! HINT