How to rate a supplier and then grade him

Question

How to rate a supplier and then grade him

[Closed]

Report

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

How to rate a supplier and then grade him
What is the rate of wi-fi - Articles
How to write at the rate in laptop - How-To - Internet
Grade kaise nikale - How-To - Excel
External hard drive slow transfer rate ✓ - Forum - Hard Drive/SSD
How to convert interest rate percentage to paisa - Forum - Office Software

1 reply

Ask a question

sharpman · Answer 1 · 2009-11-16T16:35:40-0500

Answer 1 / 1

sharpman

Posts: 1021
Registration date: Saturday May 23, 2009
Status: Contributor
Last seen: October 20, 2010

182
Nov 16, 2009 at 04:35 PM

you could use conditional formatting
which version of excel are you using?

How to rate a supplier and then grade him

1 reply

Your reply

Subscribe To Our Newsletter!