Perform a pareto analysis for the original data

Assignment Help Operation Management
Reference no: EM131446368

CanadianInsurance Processing Centre Assignment

Provincial Insurance Company has a main processing centre in Winnipeg, Manitoba that is responsible for all Canadian claims. On average they process over three thousand claims per month. Claims are for a range of services including dental, medical, and professional services. Recently it has been brought to the Management's attention that errors are becoming an increasing problem. The Company does not have a Quality Control Department, but the Operations performance does fall under the responsibilityof Nancy Chin, Operations Manager. Although she has no formal training in quality, she has taken a drastic measure of implementing a Quality improvement project.

In a four week period in January 2016, several hundredcompleted customer claims were randomly removed from the system and given a thorough evaluation. Results are recorded in the chart below.

In February, extra training took place for all employees. All associates in the Claims department attended either a six hour session, or two four-hour sessions depending on factors such as their position, length of service, and their area of responsibility. Canadian spent over $100,000 to complete this training, convinced that the reduction in number of errors would save the company money in the long run.

Approximately 20% of the employees in the Claims Department have been working for Provincial for less than one year, so this seemed like a good time to refresh the training that was given. Also, in the past year there has been two new major customers for Canadian which resulted in new forms/ documents and processes, as well as a much higher workload.

In March 2016, Nancy Chin felt it was important to determine whether the training that she implemented resulted in a reduction in the number of errors in customer claims. Once again, the same number ofrandomly selected claim forms were removed from the system prior to mailing to customers. Each form was carefully evaluated to look for errors.

The information below is from the January (original data) and from March (after the training). As a new hire from the Business Program at Seneca College, you have been asked to do an evaluationof the data and to put together a report on the success of the training program at Canadian Insurance Company, and to recommend next steps.

Assignment:

Compile a report that includes the following

1. Cover page and Table of Contents. Ensure each section has a proper titleand that each graph is properly labeled. Double space all pages. Compile the report in the order of the numbers given below. Ensure that your Table of Contents is compiled using the Microsoft WORD tool.

2. Executive Summary. You should write this part after you have covered all the issues of this assignment, but it should appear at the beginning of your report. In that way it will allow Nancy Chin to have immediate, short and clear understanding of the main findings and conclusions of the report. She will then decide what parts of your detailed report he wishes to read and understand. Give your specific results here, including the percent improvement in errors. ( Twopagraphs)

3. Summarize for Ms. Chin the four costs of quality, giving examples of each from Canadian Insurance. (Maximum four paragraphs)

4. Draw a Fish-Bone (Cause and Effect) chart, which indicates some possible reasons for the defects listed in the case.

5. Using the data from the Fish-Bone Diagram, and your knowledge of Operations Management, give two other suggestions, (in addition to training) that Canadian Insurance Company should use to reduce errors.

6. Perform a Pareto Analysis for the original data. (Pre-training) Comment on the performance in the Claims Department.

7. Using the original data, draw a Run Chart (Line Chart) for each of the top 2 errors indicated on your Pareto Chart. Can any conclusions be drawn from this line chart?

8. Perform a Pareto Analysis on the data obtained after the training took place. Discuss the improvements and next steps.

9. It has been discussed that there is some pressure in this industry to obtain ISO Certification. Briefly explain to Nancy Chin what work is involved in obtaining this certification. Is this something you would recommend, and why, or why not?

10. From the information you have discovered, prepare your conclusions and recommendations, with justifications. ( maximum 3 paragraphs)

The charts and graphs must be computer generated. Each Pareto Analysis must include the Pareto Chart and the Pareto Graph. Ensure that you import your EXCEL document into WORD using so that your formulas are visible.No part of this report should be hand written or written in the first person. Do not use I, we, you, me, my etc. Ensure that the rubric is the final page of your assignment.

This is an individual assignment, no part of this assignment may be shared with any other student. Save your file as Firstname.lastnameAss2 Assignments must be submitted into MySeneca and not by Email.

Please remember to identify your charts/graphs- Main Titles, X-Axis and Y-Axis Titles and Scale, other names of data. Be sure to cite any external references.

January Data (Original Data)

Date

Procedure Mistake

Authorization Error

Documents missing

Information Incomplete

Routing Error

2

0

2

0

3

1

3

0

2

1

4

3

4

1

1

2

4

0

5

2

0

1

0

0

6

0

1

0

5

1

9

0

2

0

2

2

10

3

3

0

6

0

11

2

2

0

0

1

12

0

0

1

2

0

13

0

2

0

4

0

16

2

3

1

2

2

17

0

2

1

6

0

18

1

0

1

5

1

19

1

2

1

4

1

20

5

0

0

3

0

23

0

4

2

2

2

24

2

2

0

4

0

25

1

1

1

6

0

26

0

1

0

3

2

27

1

1

0

2

1

March Data ( After Improvement)

Date

Procedure Mistake

Authorization Error

Documents missing

Information Incomplete

Routing Error

1

1

1

0

1

0

2

1

0

1

2

2

5

0

0

0

0

0

6

1

0

1

1

0

7

2

0

0

2

0

8

0

0

0

1

1

9

1

0

1

0

0

12

1

0

0

2

1

13

0

0

1

2

0

14

0

0

0

0

0

15

2

0

0

0

1

16

0

0

1

1

0

19

2

0

2

2

0

20

0

0

1

2

1

21

2

1

0

1

0

22

1

0

1

2

0

23

0

1

0

1

0

26

2

0

0

2

1

27

0

0

1

1

1

28

0

0

0

0

0

Reference no: EM131446368

Questions Cloud

Analyze the role that setting and character play : Analyze the ways in which setting is essential to the plot of the story. For example, in an adventure story the plot events might hinge on severe weather conditions, high altitude, or heavy snowfall.
How can programming benefit you in your chosen career field : What are the general benefits to learning how to program? (Hint - look at music and arts education.)How can programming benefit you in your chosen career field? What types of coding skills are being required by employers?
Specific needs and requirements for users : Over the years, different port connection types have been developed in response to specific needs and requirements for users. While it appears the trend is leaning towards an approach favoring USB connections, why do you suppose it is important fo..
Describes major depressive disorder and its symptoms : Imagine you work for a small clinic that offers counseling. Recently, a large number of people have come in wanting to seek treatment for their depression. In order to address this need, you have been asked to create a brochure that explains major..
Perform a pareto analysis for the original data : OPM400- Perform a Pareto Analysis for the original data. (Pre-training) Comment on the performance in the Claims Department. Perform a Pareto Analysis on the data obtained after the training took place. Discuss improvements and next steps.
Write an algorithm that given a directed graph : Write an algorithm that given a directed graph G, nds a sink or returns that one does not exist in only O(|V|) time. The graph is given by adjacency matrix A. Notice that a running time of O(|V|) is remarkable given that the input can have potentia..
Describe the piagets theory of cognitive development : What are the strengths and weaknesses of Piaget's theory of cognitive development? Using the text and peer-reviewed sources, provide empirical support that either supports or refutes Piaget's perspective.
Calculate difference between j2ee versus dot net : The box "J2EE Versus .NET" introduced the differences between these two competing frameworks for developing Web applications. Explore J2EE and .NET in more detail by discussing the two frameworks with programmers you know and by conducting researc..
Reflection as growth - effective communication skills : Identify the two (2) most valuable lessons you learned about communication principles from this course. Provide at least two (2) examples to support your rationale.

Reviews

Write a Review

Operation Management Questions & Answers

  County general might implement to decrease nurse turnover

County General Hospital is a 200-bed facility located approximately 150 miles outside Chicago. It is a regional hospital that draws patients from surrounding farm communities. Like most hospitals, County General faces the difficult task of providing ..

  What is the current state of the russian economy

Write a one page memo. Moscow is teaming with new construction sites high-end cars and new restaurants. I am the CEO of a growing international restaurant chain. What is the 'current' state of the Russian economy and should you look to as a potential..

  Regarding OD practitioners

Which of the following is NOT true regarding OD practitioners?

  Attention to corporate responsibility

As consumers, do you pay much attention to corporate responsibility? In particular, are you more likely to purchase more products from a company specifically because it has a great reputation for being socially responsible? At what point would that n..

  Project without changing the network diagram

Project crashing expedites the project without changing the network diagram. Another approach to expediting the project is called fast tracking, which means converting some sequential activities to parallel activities.

  What form of agency is bubba operating under

Bubba is a sales representative for Shrimp Boats R Us Company, which is a prospective seller of shrimp boats for your project. Bubba has offered you a great end-of-the year deal that is substantially below the current prices for the desired boats. In..

  Illustrate what would you suggest

Your boss would like you to suggest changes that could be made to the project that would significantly shorten it. Illustrate what would you suggest.

  Wholemark is an internet order business

Wholemark is an internet order business that sells the popular New York greeting cardonce a year. The cost of paper on which the card printed is $0.05 per card, and the cost of printing is $0.15 per card.

  A company division in a country

Assume you are managing a company division in a country where bribes and kickbacks are "customary." If your company has a code of conduct that prohibits this, how would you deal with locals who "expect" it. Note that not following custom puts your co..

  What is the probilty that gac will sell all units it orders

What is the probilty that GAC will sell all units it orders?

  What changes could be made to make process more efficient

Customers purchasing appliances from Sears may purchase a three-year service contract that provides free repair service and parts. When a customer needs appliance repair service, they contact Sears Service to make an appointment for a repair technici..

  What are advantages-disadvantages of her leadership style

What leadership concept best describes Swan’s leadership style? What are the advantages and disadvantages of her leadership style? What are Swan’s bases of power? Which are strongest; which are weakest? Identify AND describe two influence tactics tha..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd