How to rate a supplier and then grade him

[Closed]
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I want to rate my suppliers on thier delivery ( from purchase order date to receipt of material ) and then grade them.

Delivery within schedule date = 50 marks
3 - 6 days late beyond schedule = 35 marks
above 6 days = 15 marks

50 marks will be A grade
50-35 will be B grade
35 - 0 will be C grade

Kindly help me on this

Thank u

Prashanth

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
you could use conditional formatting
which version of excel are you using?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!