Previous Topic Next Topic

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
Related:

1 reply

Answer 1 / 1
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?
0
Ask a question