Eastern Insurance Company has a main processing Centre in Ottawa Ontario that is responsible for all Canadian claims. On average they process over a thousand claims per month for eight major insurance clients. Claims are for a range of services including dental, medical, vision and professional services. Agents work online processing claims as well as answering queries by telephone. Recently it has been brought to the Managements 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 responsibility of Jada Follett, Operations Manager.

In a four week period in July 2022, each day, a group of claims were removed from the system and given a thorough evaluation. Results are recorded in the chart below.

In August, 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 which clients they worked for. Eastern Insurance spent over $90,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 Eastern for less than one year, so this seemed like a good time to refresh the training that was originally given. Also, in the past year there has been several new major customers for Eastern which resulted in new forms/ documents and processes, as well as a much higher workload and new hires.

In September 2022, Jada Follett 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 of randomly selected claim forms were removed from the system each day. Each form was carefully evaluated to look for errors.

The information below is from the July (original data) and from September (after the training). As a new hire from the Business Program at Seneca College, you have been asked to 1) complete a basic evaluation of the data, 2) report on the success of the training program and 3) to recommend next steps.

Assignment:

Create a Professional style Pareto Table and Graph for the Pre-training data (July). (4)

Using the July data, draw a Run Chart (Line Chart) for each of the top 2 errors indicated on your Pareto Chart. (4)

Create a Professional style Pareto table and graph for the Post-training data (Sept). (4)

Using the Sept data, draw a Run Chart (Line Chart) for each of the top 2 errors indicated on your Pareto Chart. (4)

Below these two sets of data, create a text box and in 1-2 paragraphs discuss the results in each area using % change as well as the overall % change. Was the training successful in your opinion? Why or why not? (4)

6. Include a text box that comments on whether you would recommend that Eastern should consider ISO Certification. What do you advise and why? (1 paragraph) (2)

7. From the information you have discovered in your Pareto Charts and Run Charts, give your top two recommendations for Eastern Insurance Processing Centre to improve their overall Quality performance going forward. (4)

Each Pareto Analysis must include the Pareto table and the Pareto chart.

No part of this report should be written in the first person. Do not use I, we, you, me, my etc.

This is an individual assignment, no part of this assignment may be shared with any other student. Save your file as YourFirstname.lastnameAss2

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

July
Date	Information Incomplete	Authorization lacking	Documents missing	Procedure Error	Data Entry Mistake	Unnecessary Delay	Customer data Incorrect	Outdated Policy
4	0	3	2	3	1	2	0	1
5	0	5	1	4	3	1	0	1
6	1	2	2	6	2	0	1	0
7	2	3	1	0	0	2	0	0
8	0	4	0	5	1	4	2	0
11	0	5	0	3	2	3	0	2
12	0	3	2	6	0	0	0	0
13	2	4	0	0	3	0	0	4
14	0	3	1	5	0	2	2	2
15	0	2	3	4	1	2	0	0
18	1	4	2	3	2	0	1	1
19	0	2	1	6	0	0	0	1
20	1	5	2	5	1	0	0	0
21	1	2	1	2	1	1	1	0
22	3	0	0	3	0	2	2	2
25	0	3	2	2	1	0	0	0
26	2	2	0	4	0	0	0	2
27	1	4	1	6	0	1	0	0
28	0	3	0	6	0	2	0	1
29	1	4	0	2	1	0	1	0
Sep
Date	Information Incomplete	Authorization lacking	Documents missing	Procedure Error	Data Entry Mistake	Unnecessary Delay	Customer data Incorrect	Outdated Policy
5	0	2	1	1	0	2	0	1
6	0	4	0	2	1	1	0	0
7	1	2	2	1	0	0	0	0
8	1	3	1	3	0	2	0	1
9	0	3	0	3	1	1	0	0
12	0	5	1	4	1	2	0	0
13	0	2	1	2	0	0	0	0
14	0	4	0	0	0	0	0	2
15	0	3	1	3	0	1	1	2
16	0	2	0	2	1	2	0	0
19	1	1	1	1	0	0	1	0
20	0	2	0	4	0	0	0	1
21	1	0	2	3	1	0	0	0
22	1	2	1	1	0	1	1	0
23	2	0	0	2	0	1	0	1
26	0	3	1	1	1	0	0	0
27	1	2	0	3	0	0	0	1
28	1	4	2	3	0	1	0	0
29	0	3	0	1	0	0	0	1
30	0	4	0	2	1	0	1	0