I need to create a

**scorecard**where I can compare and contrast 3 different managers on

**one single**measures/metric. The problem I'm having is to come up with a defend-able and fair scorecard logic/concept on comparing these 3 managers based on missed deadlines on their respective tasks. Few things I have to mention: These managers don't have equal amount of workload meaning:

- Manager #1 has

**100**tasks of which

**20**of them missed their deadline

- Manager #2 has

**50**tasks of which

**10**of them missed their deadline

- Manager #3 has

**25**tasks of which

**5**of them missed their deadline

At first look, mgr#3 has the least amount of missed deadlines, so he should have the highest rating/score compared to others, but that's obviously not the case as he only had 25 task on his desk compared to mgr#1's 100 tasks. I've tried using weighted average method but couldn't come up w/ something.

I was wondering whether any of you can suggest me a logic that can enable me to rate these three managers based on above-mentioned data. The scorecard can be a

**5-star rating**,

**RAG status**or a

**100 points scale.**I am not much concerned about the cosmetic of the scorecard at this point.

To make the problem less complicated, it will be assumed that

**all**tasks regardless of manager have the

**same**degree of difficulty.

Any help/guidance will be greatly appreciated.

P.S. My apologies for posting this thread for the second time to a different sub-forum this time. I haven't received any response from General Discussions, so trying my luck here this time.