Hi Team,

I am the quality control analysts for a small BPO. I am trying account errors to the team. Errors should be based on their contribution to the project.

Total number of employees: 10
Total number of records processed: 45801
Total errors: 1250

Here are individual counts:

Employee Number Employee production

5065 3649
5754 4938
5857 3977
5989 5253
6067 5738
7700 4661
8294 5439
3642 4933
4563 5307
4568 1906

Total Production 45801
Total errors 1250

I want to charge 1250 errors to 10 members based on their contribution to the toal production.

Highest contributor should get lowest errors and lowest contribution should get highest errors.

Kindly help me out if there is any formula or Idea.

Thanks,
Ravi