Please just answer the questions and Pareto charts. I will be sure to give you a great review.

Workshop 4: Cause-and-Effect Diagrams & Pareto Charts The tools practiced in this workshop are: . 5 whys/why-why analysis . Cause-and-effect diagrams Pareto charts Situation: The director of an insurance company received a number of irate emails, complaining of slow service, unanswered telephone calls and calls that were not returned. Rather surprised, she asked her support and marketing managers to look into it. With a team, they first defined the problem as "lack of responsiveness to customers" and then met to talk about what might be the root cause of the problem. In the Analyze phase of the Lean Six Sigma project, you are on the team that decides to investigate potential causes for "lack of responsiveness to customers." To do this, you plan to use 5 whys/why-why analysis in conjunction with a cause-and-effect diagram. Then, you will collect data about the most significant potential causes of your problem and create a Pareto chart to determine the leading cause of this problem. Instructions: Use information from your training manual in Analyze Phase - Lessons 7-10 to assist you with the activities that follow. Be sure to follow the "best practices" for each tool you use in this workshop. 1. Go through the 5 whys/why-why analysis for every potential cause of the problem. Use this to build out the Cause and Effect diagram. Do not list the questions and answers from the 5 whys analysis as you will use this to create the Cause and Effect diagram. 2. After completing your cause-and-effect diagram, reflect on all the items listed and select what you believe are the top five potential causes for the company's lack of response to customers (Include causes, sub-causes, and/or sub-sub-causes. Do not include the categories of causes.). Label these on the Cause and effect diagram with the numbers 1-5, where "1" represents what you believe is the leading cause of the problem, "2" represents what you believe is the 2nd major cause of the problem, etc. 3. Then, obtain the file Pareto Chart Workshop Data.xls from Blackboard. This file is meant to simulate the process of you collecting data about the top 5 causes of your problem. Pretend the data in this file was collected from your observations and records. The data in this file are already "coded" for you, so all you need to do is fill-in the "key" each number represents. You can then create your Pareto chart using this data in Microsoft Excel. Use the data in the worksheet tab that corresponds to your last name on the following (for this Workshop only):\fTitle Category Category Category 7 Effect Category Category CategoryReasons for Lack of Responsiveness to Customers Key 1 = 2 = 3 = 4 = 10 5 = 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36Category 1 Category 2 Sub-cause Sub-cause Cause Sub-sub-cause Cause Cause Sub-sub-cause Sub-cause Sub-cause Sub-cause Sub-cause Problem (i.e., effect) Sub-cause Cause Cause Sub-sub-cause Sub-cause Sub-sub-cause Sub-cause Cause Cause Category 3 Category 4Category 1 Category 2 Problem (i.e., effect) Category 3 Category 4