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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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