How to rate a supplier and then grade him

Closed
Prashanth - Nov 16, 2009 at 12:21 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 16, 2009 at 04:35 PM
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

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Nov 16, 2009 at 04:35 PM
you could use conditional formatting
which version of excel are you using?
0