#1
|
|||
|
|||
Supplier Comparison Scorecard Questions
Hi,
I want to create a supplier comparison scorecard. It should compare pricing, service quality and responsiveness for the different (7) suppliers per assignment. I should be able to give up a % weight per item. And also a percentage weight per subitem. Items: -Pricing (40% weight) --Price (price height) (50% weight) --Payment Terms (numbers of days before I need to pay) (25% weight) --Direct Payment Discount (how much discount do I get before I pay) (25% weight) -Service Quality (30% weight) --Ontime shipment delivery (50% weight) --Ontime document delivery (25% weight) --Document accuracy (25% weight) -Responsiveness (30% weight) --Quotation speed (how fast do I get the quotes) (50% weight) --Email reply speed (how fast do we get answers) (25% weight) --Phonecall reply speed (how fast do we get called back in case we called) (25% weight) I also want a grand total overview over all assignments so that I can see who outperforms a competitor but also out performs over more assignments. Is there someone who can help me? I found it quit tough. Thanks, Amro |
#2
|
||||
|
||||
Hi
please post a sample sheet showing what goes wrong
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi,
I don't have anything yet. I'm looking for guidance of where to start and how to structure it. Thanks, Amro |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatic supplier contact detection at Outlook and Lync | LordLA | Outlook | 0 | 07-30-2015 02:40 AM |
Inputting 339 supplier names into individual Word documents | Aron19 | Mail Merge | 3 | 04-29-2014 04:41 PM |
How to transpose the datas of part code and supplier into row and column | PRADEEPB270 | Excel | 3 | 10-26-2012 07:22 PM |
Saving & reopening comparison | MarshallAbrams | Word | 0 | 03-29-2012 06:19 AM |
Comparison jumps to end | MarshallAbrams | Word | 2 | 03-21-2012 04:04 AM |