Composite scores for 3 Suppliers

Your manager has decided to reduce the number of suppliers for a critical subassembly from three to two. She has asked you to review the three current suppliers (A, B, and C) and to recommend which one to eliminate from the approved suppliers list. You confer on the ground rules and agree that a multiplier of three will be assigned for best performance in a category, two for second place, and one for last place.

You have been provided the following data:

  • Quality is the leading attribute to be considered and has been assigned a 45% weighting. The best record for quality has been achieved by Supplier C, followed by Supplier A, and Supplier B in last place.
  • Warranty length is the second most important attribute with a 30% weight. Warranties are three years for Supplier A, five years for Supplier B, and two years for Supplier C.
  • Cost is the last consideration with a relative weight of 25%. Subassemblies from Suppliers A and C each cost $7500 while those from Supplier B cost $6500. All values include shipping and delivery charges.

Create a simple MS Excel spreadsheet to enter the relevant data and to calculate the composite score for each of the three suppliers. Post your spreadsheet for the class and state your recommendation for which supplier to drop from the list.

You can leave a response, or trackback from your own site.


8 Responses to “Composite scores for 3 Suppliers”

  1. 918547 734354Thank you for your info and respond to you. bad credit auto loans hawaii 441616

  2. 99464 438535Hi. Thank you for producing this website . I m working on betting online niche and have located this web site utilizing search on bing . Is going to be sure to look much more of your content . Gracias , see ya. :S 280823

  3. 61645 277569you may have a wonderful weblog here! would you wish to make some invite posts on my weblog? 344807

  4. 809875 825245How a lot of an distinctive write-up, maintain on posting much better half 22980

  5. FUL says:

    91886 331325I dont leave a lot of comments on lots of blogs each week but i felt i had to here. Do you need numerous drafts to make a post? 703366

  6. euroclub says:

    113931 706851Its onerous to search out knowledgeable individuals on this topic, even so you sound like you already know what youre talking about! Thanks 688554

  7. Ron Boblak says:

    I want to destroy the price.

  8. 1965. 516. At the beginning. The company has entered the company and moved to the common procedure.

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes