Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in this document contain all of the deliverables expected of you. If you need help along the way, look for these special cells that have a red indicator in the corner. It looks like the "Read me" box to the right: Read me Simply slide your cursor over the red-cornered cell and you will get more information. The format for all of the deliverables is the same: The 'objective' is in black font. It describes what you are doing the particular deliverable. The next segment is in green font. These are your instructions. The blue font is the data (where applicable) that you will need to complete the deliverable. Software We are using Excel software for the projects. You may use other software to complete your projects, but please 'report' your answers in the Excel format described below. You may complete your assignments with any version of Excel software. All assignments can easily be completed with a basic copy of Excel. There is also an Add-In feature which is available for Excel that can be helpful, although it is not required. The Add-In feature comes free with each Excel package, although it may not be currently loaded into your copy of Excel. Following are the simple instruction for loading the Excel Add-ins for both Excel 2003 and Excel 2007. (Slide your cursor over the red-cornered cells to read) Excel 2003 Excel Novice - Please read Excel 2007 Project Assignment Submission Timeline (Suggested) Project charter (target week 3 or sooner) Baseline sigma (week 4 or sooner) SIPOC (week 5 or sooner) Pareto chart (week 6 or sooner) Expected Variation (week 7 or sooner) Stem & leaf (week 8 or sooner) Scatter diagram (week 10 or sooner) DOE (week 11 or sooner) Control chart (XmR) ( week 12 or sooner) Pp Ppk (week 13 or sooner) How to submit an Assignment In response to customers like you, we have added a peach-colored box for each deliverable. We have done this to make it clear (and consistent) the areas of the project that will be reviewed to your instructor. Project: Deliverable: Student last name: I.T. Project Improve phase - gen. sol. Johnson What is the control chart telling you? There is a point out of control at subgroup #15. I would try to figure out why that happened. We would also recalculate the control limits because there is evidence the process has changed. What is the average of subgroup 1? What is the average of subgroup 2? What is the average of subgroup 3? What is the average of subgroup 4? What is the average of subgroup 5? What is the average of subgroup 6? What is the average of subgroup 7? What is the average of subgroup 8? 22 34 23 22 25 23 29 27 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 - ASSIGNMENT NAME - PROJECT NAME" 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. VERY IMPORTANT!! Be sure to submit your assignments for grading as you complete each one and following the submission scheduled posted on the message board - DO NOT WAIT UNTIL THE END OF THE COURSE TO SEND THEM ALL IN. NOTE THAT THE ENTIRE PROJECT MUST BE 100% CORRECT BY ONE WEEK BEFORE THE END OF CLASS OR YOU WILL FAIL THE PROJECT AND THE COURSE. This means that you must submit ALL of your assignments far enough in advance of the project completion deadline to allow time for all necessary corrections to be made. Following the submission schedule is the best way to ensure that you have enough time to finish the project by the completion deadline - failure to meet the submission due dates can result in failing the course. Very few assignments are correct on the first submission and many require multiple rework attempts, so don't procrastinate! This spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your Excel software. If you see Data Analysis already listed under the Tools tab, you are set. If you do not see Data Analysis follow the instructions in the Green tab. Excel 2003 instructions Excel 2003 or earlier versions of Excel example This spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your 2007 Excel software. If you see Data Analysis already listed under the DATA tab, you are set. If you do not see Data Analysis follow the instructions in the Green tab. Excel 2007 instructions Excel 2007 example The I.T. Project Service Desk Department The Service Desk Department consists of four teams - the Telecom Team responsible for phone infrastructure, the Server /Network Team, a Help Desk that handles first-level assistance and bug tracking, and a Desk-Side Support Team (DSST). All four teams serve only internal customers people who work in the same company as the Service Desk. Telecom Team The Telecom Team handled 1,893 installations -- Private Branch Exchanges (PBX), Voicemail (VM), and Voice-Over Internet Protocol (VOIP), telephone sets, modems and fax machines. Of those who responded to the customer satisfaction survey: 45.5% strongly agreed that their needs were met 31.26% agreed that their needs were met 22.8% neutral that their needs were met 0.44 disagreed 0.00 strongly disagreed Service/Network Team The SNT had a quiet year. Bandwidth and latency levels were maintained within specification limits and unscheduled the cumulative downtime was held to an acceptable level. (16 minutes total for the year) Help Desk Team The HD received 9,687 requests last year. Of those who participated in the customer satisfaction survey: 36.78% strongly agreed that their needs were met 62.06% agreed that their needs were met 1.16% neutral that their needs were met 0.00 disagreed 0.00 strongly disagreed Desk-top Support Team (DSST) The DSST receives their marching orders from the HD to set up and configure computers for new users within the company -- dealing with software complaints, hardware issues, moving workstations, etc. Last year 3626 DSST received requests from other internal employees. Of those employees they served who participated in the customer satisfaction survey: 2.3% strongly agreed that their needs were met 25.6% agreed that their needs were met 65.8% neutral that their needs were met 3.6 disagreed 2.7 strongly disagreed The director of the service department says that any 'strongly disagree' or simply 'disagree' responses are considered to be defects. She was unhappy that ~66% were 'on the fence', but when she was pressed for an 'operational definition', she said the defect ratings do not include the 'neutral' ratings. Bottom Line: The director is not happy. When asked by the team sponsor about any 'pain points', she had no hesitation. She wants the DSST to improve the level of customer satisfaction. Objective: A problem statement needs to be developed. There needs to be a business case so that management will buy-in to having the team working on the project. The scope of the project also needs to be decided upon. This is important to ensure a likely successful completion. If the scope is too broad, a success may not be realized for years, or may not happen at all. Instructions for you: Create a project charter based "Create a charter?" upon the information in the introduction. (see "The project" tab) In reality, you would fill in a charter with team members' names, stake holders, etc. We are not interested in those details for this simulation, but we do want to see what you come up with for four (4) items: Problem statement, business case, goal and project scope. How to submit an Assignment Project: Deliverable: Student last name: MAM IT 2016 Project charter Your LAST name here What is the business case? (Use no more than 2 sentences.) "Business Case?" Type your business case here. Use no more than 2 sentences. What is the problem statement? (Use no more than 2 sentences.) "Problem Statement" Type your problem statement here. Use no more than 2 sentences. What is the project scope? (This is not your goal statement! Use one sentence.) What is the project scope? Be sure to express your scope in terms of the process being addressed. (See tip at right) "The project scope?" 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 - Charter" 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. Objective: We want you to determine the baseline sigma with the Motorola 1.5 sigma shift. Note: You will need to refer to the tab entitled "The Project" for this deliverable. Instructions for you: Calculate the PPM/DPMO for this process and determine the baseline sigma with the Motorola shift. How to submit an Assignment Project: MAM IT 2016 Deliverable: Baseline Sigma Student last name: Your last name here What is the baseline sigma? (Approximately) (Use 1 decimal place) 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 - Baseline Sigma" 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. Objective: We want to view the process from a high level in order to see the major process elements. SIPOC - Suppliers, Inputs, Process, Outputs, Customers Instructions for you: Create a SIPOC map of the process based upon the IT case study write-up (found at "The project" tab). Feel free to use your imagination in doing this piece of the project. Think about your own experience from submitting or responding to a help-desk request to come up with the 'suppliers', 'inputs', 'process', 'outputs', and 'customers.' Note: Normally the SIPOC map is constructed horizontally. When mailing this deliverable to your instructor, it formats better vertically. How to submit an Assignment Project: Deliverable: Student last name: Suppliers: (Name 3) Inputs: (Name 3) Process Step 1: Process Step 2: Process Step 3: Process Step 4: Process Step 5: MAM IT 2016 SIPOC Your LAST name here Type suppliers here Type suppliers here Type suppliers here Type inputs here Type inputs here Type inputs here Step 1 Step 2 Step 3 Step 4 Step 5 Outputs::::: (Name 3) Type outputs here Type outputs here Type outputs here Customers: (Name 3) Type customers here Type customers here Type customers here 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. 2. 3. 4. 5. 6. COURSE MENU CLASS ROSTER Click on your instructor's email envelope icon Type "Check My Work - SIPOC" in the SUBJECT box. Click once inside of the message box 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. Objective: You need to determine the 'biggest contributors to the problem.' One tool to accomplish this is the Pareto Chart. Instructions for you: Using the data (blue) below construct a Pareto chart (see the online textbook reading for more). We realize that you could simply pick the two or three process components without actually creating the Pareto Chart, but we want you to actually create the Pareto Chart because in reality management likes to see simple charts where they don't have to analyze the data to see the picture. That is why the Pareto Chart is used in the first place. Data: Reasons for customer dissatisfaction: Got tired of waiting Software add not necessary Waiting on hardware Treatment by rep Call-in staff impatient Resolution unsatisfactory System incompatible Rework/recalls needed Expensive No follow-up Total customers choosing this particular response 6 4 4 3 2 2 1 1 1 1 Cumulative % Create a Pareto chart in Excel 2003 Create a Pareto chart in Excel 2007 YOU DO NOT NEED TO SEND THE ACTUAL PARETO CHART. Project: MAM IT 2016 Deliverable: Pareto Chart Student last name: Your LAST name here Which ONE issue should your team focus on first based upon what the Pareto Chart is telling you, and why? Type your response here. How to submit an Assignment 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 - Pareto Analysis" 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. Objective: Your boss wants to know the limits of expected variation for the DSST resolution times. Assuming that the process is normally distributed, you know you can calculate/predict the limits of expected variation by calculating the mean and standard deviation for the data and then using the properties of the normal distribution to estimate the limits of the expected variation. Instructions for you: 1. Calculate the average for each. Use Excel 2003 to find mean and Standard Deviation 2. Calculate the standard deviation for each. Use Excel 2007 to find mean and Standard Deviation 3. From these calculations, determine the range of expected variation. Assume the data are normally distributed. Data: Average Resolution Times for last month (measured in contiguous hours) 24 27 18 31 22 27 17 23 17 22 17 28 24 17 14 21 26 23 17 31 18 27 22 27 17 40 22 18 17 18 28 YOU DO NOT NEED TO SUBMIT A HISTOGRAM FOR THIS DELIVERABLE Project: MAM IT 2016 Deliverable: Expected Variation How do I determine if it's Student last name: approximately normal? Your last name here Mean: Standard deviation: What is the lowest point of expected variation? What is the upper point of expected variation? ROUND ALL FINAL RESULTS TO 6 DECIMAL PLACES. 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 - Expected Variation" 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. Objective: The team wants to know if there is an obvious reason for resolution times being longer than what is acceptable. One of the team members suggested using a stem-and-leaf diagram to get a visualization of the variation in resolution times. Average resolution times were recorded for the past 70 days. By looking at the numbers below, can you tell if there is assignable cause variation? Unless you have a graphing function in your head, it is difficult to tell. So, that is the question. "Is there assignable-cause variation that can be realized from the 70 data values listed?" Your job is to answer that question. You could use a histogram or control chart to answer that question, but your sponsor wants to keep the actual raw data when reviewing the tool of choice. So, you will be using a stem-and-leaf diagram so that the raw data can be preserved. Construct a stem-and-leaf graph from the data. Is the process approximately normally distributed? If not, what is the stem-and-leaf telling you? What shape do you see? Instructions for you: 1. 2. 3. 4. Construct a stem-and-leaf diagram Answer the question: "Is there process approximately normally distributed?" What is the stem-and-leaf diagram telling you? What would you recommend? Data: I'm lost Average resolution times (last 10 weeks, measured in contiguous hours) 16 16 17 37 47 32 48 21 18 75 15 17 13 47 11 47 38 17 20 49 19 16 26 17 65 15 17 48 16 44 48 45 50 49 63 17 22 10 18 51 14 80 6 49 48 47 48 52 46 48 47 20 71 47 50 95 47 20 50 35 21 46 48 20 64 16 44 82 51 58 How to submit an Assignment Helpful tip - Sorting - Excel 2007 Helpful tip - Sorting - Excel 2003 Project: MAM IT 2016 Deliverable: Stem & Leaf Student last name: Your last name here 9::: 8::: 7::: 6::: 5::: 4::: 3::: 2::: 1::: 0::: Is it reasonably normally distributed? Yes or No If it is not normal, what shape is it? (Use the correct name for this shape, not a description.) Based on this analysis, what is the next thing you would do? Type here what you would recommend based on the pattern shown. "What's the purpose of the red line?" 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 - Stem and Leaf" 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. Objective: The team is certain there is a correlation between the number of DSST service requests received and the number of dissatisfied customers. If there really IS correlation with the set of data, the attention will be directed to determining how to improve the process considering the cause-effect relationship between the x's and y's. If there is no correlation evident in the set of data, the team will have to go 'back to the drawing board.' Instructions for you: With the data provided, construct a scatter diagrams to see if they are right. their hypothesis is correct. Data: Number of desk-side requests per specific week 172 132 130 206 199 223 201 169 135 200 189 110 203 189 224 197 188 125 199 194 Dissatisfied customers 4 6 2 4 6 4 8 7 5 3 7 8 6 5 8 4 8 2 6 8 Scatter Diagrams in Excel 2003 Scatter Diagrams in Excel 2007 Correlation Coefficient - Excel 2003 Correlation Coefficient - Excel 2007 207 7 How to submit an Assignment YOU DO NOT NEED TO SUBMIT THE ACTUAL SCATTER DIAGRAM Project: MAM IT 2016 Deliverable: Scatter Diagram Student last name: Your last name here What is the correlation coefficient? IF there is strong correlation, is it positive or negative? (to four decimals) Positive, Negative or N/A 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 - Scatter Diagram" 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. Objective: You recommend using a design of experiments approach to hopefully realize a breakthrough improvement. The team brainstorms a long list of possible reasons why the average resolution time is so long. From that list, the team has reduced it down to five factors they want to include in an experiment. They do not suspect any interactions, so they conclude a resolution III will be adequate. They refer to the resolution matrix (in Analyzing Fractional Factorial Designs lecture and the online textbook) and they find they can learn about the effects of those five factors in as little as eight experiments. Instructions for you: Estimate the main effects (the impact on the response from when going from the low level to the high level). Data: The factors for the experiment were: A B C D E - level 8 FIFO In person Product A BHD Staff size Order of responding Method of responding Tracking software Operating system + level 16 By priority Via web Product B JK-7 The design below was taken from Minitab. There are other software packages that provide the same information. There can also be found in Design of Experiments textbooks. Trial 1 2 3 4 5 6 7 8 Staff sz 1 -1 1 -1 -1 1 1 -1 Order 1 -1 1 -1 1 -1 -1 1 Method -1 -1 1 1 1 -1 1 -1 Software -1 1 1 1 -1 1 -1 -1 Op sys Results (Y) (average resolution - in contiguous hours -1 9 1 7 Excel 2003 Tip -1 25 -1 28 Excel 2007 Tip 1 26 1 8 -1 28 1 6 How to submit an Assignment YOU DO NOT NEED TO SEND IN THE MAIN EFFECTS PLOTS Project: MAM IT 2016 Deliverable: DOE Student last name: Your last name here Staff size Staff size + Order Order + Method Method + Software Software + Op sys Op sys + Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here ROUND YOUR FINAL RESULTS TO 2 DECIMAL PLACES. Which two factors are most significant and what are the optimum settings for these two factors? Check 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 - DOE" 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. Objective: Earlier, you have made some progress as a result of the stem-and-leaf diagram. The team changed the process so that first-time requesters were processed ahead of the otherwise (first-in-first-out) process. This dramatically decreased the overall average response times. Many of the problems submitted by newer users were easier to resolve than the problems submitted by the more seasoned workers. The team also learned how to improve the process through the use of designed experiments. There were other improvements made through the use of other Six Sigma tools and techniques (aside from your project deliverables) and now the wait times are acceptable. Now, you want to ensure that they are staying that way and you want to practice "prevention" versus "detection." Part of your CONTROL strategy is to employ the use of an on-going capability study to ensure 'the plates are still spinning'--so-to-speak. And, the next deliverable will do that, but prior to performing a capability study, one must make sure the process is in statistical control. This is good, because the team decided to use a control chart as part of the CONTROL phase anyhow, so this will work out fine. In fact, let's do one now...just to make sure we are in statistical control. Instructions for you: Answer the questions and type those responses in the peach colored box below. Data: Average resolution times (in contiguous hours) in order of occurrence 1 10 2 17 Control Chart in Excel 2003 3 29 4 39 Control Chart Excel 2007 5 55 6 64 Help 7 28 8 6 "Don't I need special software?" 9 5 10 3 11 39 12 46 13 35 14 30 15 6 16 32 17 33 18 11 19 20 20 13 21 9 22 14 23 12 24 30 25 56 YOU DO NOT HAVE TO SUBMIT THE CONTROL CHART. JUST ANSWER THE QUESTIONS. Project: MAM IT 2016 Deliverable: XmR Chart Student last name: Your last name here Upper control limit for the range: Upper control limit for the individuals: Lower control limit for the individuals: Type in UCL-R Type in UCL-x Type in LCL-x 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? ROUND ALL RESULTS TO 6 DECIMAL PLACES. Type your answer here. Include which chart you used, how many strata there are on that Help chart, and how many there should be for adequate discrimination. If the process is unstable, what process would you follow to determine what is causing the instability? HINT Type your answer here. How to submit an Assignment 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 Check 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. Objective: As mentioned in the last deliverable, one part of the CONTROL phase of DMAIC is to to use the control chart to control and monitor the process behavior. We use a capability study to determine how the process is performing in reference to the specifications, once we have a stable and predictable process as determined by the control chart. Assume that you addressed all of the assignable causes and the process is now stable. Your team decided to use a Pp/Ppk study. Reflected in the data below is last month's wait times under the new, stable process. You need to use this data in your Pp/Ppk study. You also need to construct a histogram as a part of your capability study to ensure that the process variation is still acting normal. By the way--finish this deliverable correctly and make all required corrections to the other assignments and you are finished with the project. Congratulations!!!! Instructions for you: Examine the capability of this process. Pp, Ppk formulas Use Excel 2003 to find mean and Standard Deviation Use Excel 2007 to find mean and Standard Deviation Data: Data: Average resolution times (contiguous hours) 2 11 9 8 6 12 9 9 8 13 11 7 7 10 14 4 8 10 9 9 15 9 9 6 10 Upper spec is 30 hours How to submit an Assignment YOU DO NOT NEED TO INCLUDE YOUR HISTOGRAM IN THIS ASSIGNMENT Project: MAM IT 2016 Deliverable: Pp Ppk Student last name: Your last name here Pp (round final result to 6 decimal places): Ppk (round final result to 6 decimal places): Is the process acceptable? What is the basis for your decision? Yes or No and Why How to submit an Assignment 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 - Pp, Ppk" in the SUBJECT box. 5. Click once inside of the message box HINT! 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. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 10 17 29 39 55 64 28 6 5 3 39 46 35 30 6 32 33 11 20 13 9 14 12 30 56