Description of this paper

IT Black Belt Project

Description

solution


Question

Question;Objective:You recommend using a design of experiments approachto hopefully realize a breakthrough improvement.The team brainstorms a long list of possible reasons whythe average resolution times are so long. From that list, theteam has reduced it down to five factors they want to includein an experiment. They do not suspect anyinteractions, so they conclude a resolution III will be adequate.They refer to the resolution matrix (in Analyzing Fractional FactorialDesigns Lecture - see also your online textbook) and they find they can learnabout the effects of those five factors in as little as eight experiments.Instructions for you:Construct an main effects plot for all five of the factors. We will do the first one for you asan example:Take an average of the response time minutes (y) when "staff size" was at (-). Then, do the same thingfor when the results (y) when "staff size" was at (1).When at (-1)When at (+1)792825268628Average16.7517.50Data:The factors for the experiment were:ABCDE- level8FIFOIn personProduct ABHDStaff sizeOrder of respondingMethod of respondingTracking softwareOperating system+ level16By priorityVia webProduct BJK-7The design below was taken from Minitab. There are other software packages that provide thesame information. There can also be found in Design of Experiments textbooks.Trial12345678Staff sz1-11-1-111-1Order1-11-11-1-11Method-1-1111-11-1Software-1111-11-1-1Op sys Results (Y) (average resolution - in contiguous hours-1917Excel 2003 Tip-125-128Excel 2007 Tip12618-12816How to submit an AssignmentTARGET ASSIGNMENT DATE - Submit in Week 12 or earlierYOU DO NOT NEED TO SEND IN THE MAIN EFFECTS PLOTSProject:I.T. ProjectDeliverable:DOEStudent last name:Your last name hereREPORT ALL OF THE RESULTS TO AT LEAST 2 DECIMAL PLACES!Staff size -:::::Actual value hereStaff size +:::::Actual value hereOrder Actual value hereOrder +:::::Actual value hereMethod Actual value hereMethod +:::::Actual value hereSoftware Actual value hereSoftware +:::::Actual value hereOp sys Actual value hereOp sys +Actual value hereWhat would you do next?Type in what you would do based on the results of the DOE?What are the optimum level settings for each factor?Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. Click on the 'email' icon on your course home page2. Select 'new message'3. Click on your instructor's email envelope icon4. Type "the respective assignment name" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.CheckCheckCheckCheckCheckCheckCheckCheckCheckCheckObjective:The team is certain there is a correlation between the volume of help-desk requests anddissatisfied customers. If there really IS correlation with the set of data,the attention will be directed to determine how to improve the processconsidering the cause-effect relationship between the x's and y's. Ifthere is no correlation evident in the set of data, the team will have to goback to the drawing board.'Instructions for you:With the data provided, construct a scatter diagram to see if they are right.Data:Number ofdesk-siderequests perspecific week172132130206199223201169135200189110203189224197188125199194207Dissatisfiedcustomers462464875378658482687Scatter Diagrams in Excel 2003Scatter Diagrams in Excel 2007Correlation Coefficient - Excel 2003Correlation Coefficient - Excel 2007How to submit an AssignmentTARGET ASSIGNMENT DATE - Submit in Week 13 or earlierYOU DO NOT NEED TO SUBMIT THE ACTUAL SCATTER DIAGRAMProject:I.T. ProjectDeliverable:Scatter DiagramStudent last name:Your last name hereIs there a strong correlation?Y or N?Positive or negative?P or N?Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. Click on the 'email' icon on your course home page2. Select 'new message'3. Click on your instructor's email envelope icon4. Type "the respective assignment name" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.Objective:Earlier, you have made some progress as a result of the stem-and-leaf diagram. Howdid the team make the improvement? They saw that the diagram showed a bi-modalcondition so the team identified the source of this condition, eliminated one of the sourcesand optimized accordingly.The two sources were found to be: 1) Some of the customerswere first-time requesters and 2) Some of the customers were repeat requesters. The teamchanged 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 problemssubmitted by the more seasoned workers.The team also learned how to improve the resolution process through the use of designedexperiments. There were other improvements made through the use of other Six Sigmatools and techniques (aside from your project deliverables) and now the resolution times areacceptable. Now, you want to ensure that they are staying that way and you wantto practice "prevention" versus "detection." Part of your CONTROL strategy is to employthe 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, onemust make sure the process is in statistical control. This is good, because the teamdecided to use a control chart as part of the CONTROL phase anyhow, so this willwork 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 responsesin the peach-colored box below.Data:Average resolution times (in contiguous hours) in order of occurrence110217Control Chart in Excel 2003329439Control Chart Excel 2007555664Help72886"Don't I need special software?"9510311391246133514301561632173318111920201321922142312243025562662277328542910309Be sure to review the week 13 virtual class for more information on SPC and measurement discrimination beforeyou submit this assignment!How to submit an AssignmentTARGET ASSIGNMENT DATE - Submit in Week 14 or earlierYOU DO NOT HAVE TO SUBMIT THE CONTROL CHART. JUST ANSWER THE QUESTIONS.Project:I.T. ProjectDeliverable:XmR ChartStudent last name:Your last name hereREPORT ALL OF THE RESULTS TO AT LEAST 2 DECIMAL PLACES!Upper control limit for the range:::Enter the UCL-Range hereUpper control limit for the individuals:::Enter the UCL-X hereLower control limit for the individuals:::Enter LCL-X hereWhich 3 out-of-control rules were violated?1) Enter the three rules here(Refer to the Online Textbook)2)3)Is the measurement system discriminate?Is the measurement systemdiscriminate?What is causing the point to beout of control?Which tool(s) would you recommend toidentify the root cause?Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. Click on the 'email' icon on your course home page2. Select 'new message'3. Click on your instructor's email envelope icon4. Type "the respective assignment name" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.HelpHelpHelpHelpHelpCheckCheckCheckObjective:As mentioned in the last deliverable, one part of the CONTROL phase of DMAIC is toto use the control chart to control and monitor the process behavior. We use a capabilitystudy to determine how the process is performing in reference to the specifications, once we havea stable and predictable process as determined by the control chart.Your team decided to use a Pp Ppk study. Reflected in the data below is lastmonth's average resolution times. You need to use this data in your Pp Ppk study. Remember, youalso needed to address that out-of-control point on that XmR Chart (point #27) found inthe last deliverable. The team had an assignable-cause for that point, but since that adjustment,a subsequent control chart study determined that the process was now in control. And, youknow that the process needs to be in control PRIOR to using a Pp Ppk study.You also need to construct a histogram as a part of your capability study to ensurethat the process variation is still acting normal. By the way--finish this deliverableand you are finished with the project.Congratulations!!!!Instructions for you:1. Construct a histogram from the data below.2. Is the processes random, or normally distributed?3. Calculate Pp and Ppk. Note: The upper and lower specificationsare listed to the right of the data. You will need these to dothe calculations.4. Are the processes acceptable?Histograms in Excel 2003Histograms in Excel 2007More on Bin RangesPp, Ppk formulasUse Excel 2003 to find mean and Standard DeviationUse Excel 2007 to find mean and Standard DeviationData:Data:Average resolutiontimes (contiguoushours)Upper Spec Limit is 30 hours*Carefully note there is NOLower Spec Limit (unilateraltolerance) since it is a smaller isbetter quality characteristic!211986129981311771014481099159961097985Be sure to review the week 14 virtual class for more information on Process Capability before you submit thisassignment!How to submit an AssignmentTARGET ASSIGNMENT DATE - Submit in Week 15 or earlierYOU DO NOT NEED TO INCLUDE YOUR HISTOGRAM IN THIS ASSIGNMENTProject:I.T. ProjectDeliverable:Pp PpkStudent last name:Your last name hereREPORT THE RESULTS TO AT LEAST 2 DECIMAL PLACES!Pp:Ppk::::Random?:::Acceptable?:::CheckCheckCheckCheckRead this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. Click on the 'email' icon on your course home page2. Select 'new message'3. Click on your instructor's email envelope icon4. Type "the respective assignment name " in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.

 

Paper#36621 | Written in 18-Jul-2015

Price : $37
SiteLock