LSS Green Belt

Assignment 2:

Dataset (Insurance example)

Refer to the “Claims Processing Costs” worksheet to answer the following questions.

Preliminary Analysis [Pre-define phase]

1. Create a Pivot Table of Cost/Claim by Region and Product to identify where the biggest opportunity is. Interpret.

2. Draw Histograms/Dot Plots and Time Series Charts for Cost/Claim by Region and Product.

3. Interpret the results – is there an opportunity for improvement in one or more regions for either product?

Assume that you are the manager at Region 1 for Product B. You have concluded after some discussion with the team rework due to errors in processing claims is a major contributor to your problems with cost/claim, and wish to tackle that as the focus of your project.

Refer to the “Claims Processing Errors” worksheet to answer the following questions.

Define

4. Analyze the errors (y) currently being made by the various employees to get a sense of the current state. Create a Project Charter. Clearly define your SMART objective.

(A process flow diagram would be part of the task at this point, but we will skip it for this assignment, since you did a VSM in assignment 1).

5. How do you make sure that the project goals are reasonable?

Measure

You now wish to analyze the potential causes (Xs) that lead to the errors.

6. Use the Fishbone Diagram to clearly identify the potential causes for the errors (y).

7. For all the Xs calculate the Mean, Standard Deviation, Minimum, and Maximum values.

Measurement Errors

8. Discuss briefly the kind of measurement errors that are possible in the data collected for this project.