Previous Topic Next Topic

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

1 response

Answer 1 / 1
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?

Similar discussions

How do I type the @ on a British keyboard?
Steve -
jonearthur -

7 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
Excel Formula
bicky@7 -
bicky@7 -

6 responses
Creating a payback calculator with rate change
jojosabadar -
jojosabadar -

7 responses
HP pen drive not recognized
air -
Ambucias -

17 responses