Weighted Point Supplier Evaluation

Assignment Help Business Economics

Reference no: EM133184888

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.

Reference no: EM133184888

Questions Cloud

International trade and exchange rates : What is the impact of trade surplus (exporting more than importing) and trade deficit (importing more than exporting) on GDP, employment

The realco breadmaster and supply-chain challenges : What are the implications for master scheduling? Offer a recommendation and plan for the supply chain strategy for Toyota.

Used goods on ebay or other online sites like craigslist : Do you or your friends take advantage of low prices on used goods on eBay or other online sites like Craigslist?

Role of government in rapid industrialization of china : What was the role of government in rapid industrialization of China? What was the role of market developments in rapid industrialization of China?

Weighted Point Supplier Evaluation : Create a simple MS Excel spreadsheet to enter the relevant data and to calculate the composite score for each of the three suppliers.

Free Trade Versus Protectionism : Assess why the U.S. government should protect the U.S. steel and aluminum industries. Are you in favor of free trade or protectionism?

What substance will accomplish the goal : Whether you're writing or presenting an email, plan, pitch, or presentation, you must define your goal, figure out what substance will accomplish the goal

Areas of emphasis and details of training : Determine the areas of emphasis and the details of the training. Describe how the training will improve the expatriate experience for the new assignment.

Internship experience successes : In a paper based on your internship course experiences and the learning objectives achieved, review your internship experience successes

User Account

All Pages