Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2015, 08:58 AM
BusinessBuilder BusinessBuilder is offline Supplier Comparison Scorecard Questions Windows 8 Supplier Comparison Scorecard Questions Office 2010 32bit
Novice
Supplier Comparison Scorecard Questions
 
Join Date: Aug 2015
Posts: 8
BusinessBuilder is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-22-2015, 09:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Supplier Comparison Scorecard Questions Windows 7 64bit Supplier Comparison Scorecard Questions Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 08-22-2015, 09:17 AM
BusinessBuilder BusinessBuilder is offline Supplier Comparison Scorecard Questions Windows 8 Supplier Comparison Scorecard Questions Office 2010 32bit
Novice
Supplier Comparison Scorecard Questions
 
Join Date: Aug 2015
Posts: 8
BusinessBuilder is on a distinguished road
Default

Hi,

I don't have anything yet. I'm looking for guidance of where to start and how
to structure it.

Thanks,
Amro
Reply With Quote
Reply



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
Supplier Comparison Scorecard Questions 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft