due Jan 25
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:
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.
Place an order in 3 easy steps. Takes less than 5 mins.