Objective: You have learned a lot about your process though the use of the tools and techniques of Six Sigma. Now you want to be determine whether or not your new process is behaving predictably. So in this deliverable, you need to create an XmR (Individual and Moving Range) chart to answer the question, "Is there any assignable-cause variation in the process?" You are given total deposit cycle time (in hours) by period. Instructions We want to make sure you can calculate control limits. You will need to actually construct a control chart by hand. 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 deposit cycle time in statistical control? "I'm lost" "Do I actually need to do this by hand?" "I have no idea about this one" "How can I do this without software?" Optional help using Excel 2003 Optional help using Excel 2007 Data: Data: Hours Period Cycle Time |Xi - X i-1| 1 45 2 33 3 44 4 30 5 51 6 47 7 39 8 34 9 69 10 43 11 29 12 38 13 45 14 49 15 73 16 38 17 50 18 40 19 57 20 36 21 31 22 46 23 40 24 51 25 48 26 37 27 42 28 50 12 11 14 21 4 8 5 35 26 14 9 7 4 24 35 12 10 17 21 5 15 6 11 3 11 5 8 How to submit an Assignment 1a. Calculate R-bar "How do I do that?" Check 1b. Calculate the upper control limit for the range "How do I do that?" Check 2 & 3. Calculate the control limits for the individuals "How do I do that?" Check Target Assignment Date - Submit in Week 14 or earlier Project: Deliverable: Student last name: Finance 2016 Control Chart Do not submit your control chart for this deliverable! Calculated R-Bar: 13,07 Upper control limit for the range: 42.750000 Upper control limit for the individuals: 78.880000 Lower control limit for the individuals: 9.330000 Check Check Check Check Based upon your analysis of the tests for stability, what would you do next with this process? Help Since both the charts are stable, and all the sample points fall in between the control limits in the XmR charts indicates that the thickness process is under control. Is there adequate discrimination? Explain your answer by indicating which chart you used, exactly how many strata there are on that chart, and how many strata there should be for adequate discrimination. Help Yes, there is adequate discrimination. XmR chart need to be used here. There should be exactly 6 strata on the chart. Read this! 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 - Control 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. The deadline for having all project deliverables 100% correct is 7 days prior to the end of the course. ts in Excel 2003 ts in Excel 2007