Composite score for each of the suppliers

Assignment Help HR Management
Reference no: EM133045643

A 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: EM133045643

Questions Cloud

Issues in the social media industry : Normative theory and its components based on ethical issues in the social media industry?
Five characteristics of useful money : Name three finance functions important to the firm's overall operations and performance.
Project on job recruiting : This is a general 6 sigma question. Can I create a control chart if I was doing a 6sigma project on job recruiting?
CSOR 4231 Analysis of Algorithms Assignment : CSOR 4231 Analysis of Algorithms Assignment Help and Solution, Columbia University - Assessment Writing Service
Composite score for each of the suppliers : A 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
Business and marketing strategies : Companies can use competitive intelligence to direct their business and marketing strategies and gain a competitive edge
Internal versus external secondary data sources : Differentiate between Internal versus External Secondary Data sources with its advantages and disadvantages.
Universal declaration of human rights : Identify three articles of the human rights declaration that correlate with constitutional principles in the US.
Intimacy and closeness of the relations : Life is a train that we ride and move us from the first station to our final destination.

Reviews

Write a Review

HR Management Questions & Answers

  Discuss how the function of planning is synchronised

Discuss how the function of planning is synchronised in the procurement of Human Resource

  What skills might juanita have to develop to better fulfill

Effective management of human resources contributes to mission accomplishment and vision achievement. Given that a vision is the future preferred status.

  Summarize the process for learner analysis

Course Textbook Noe, R. A. (2010). Employee training and development. (5th ed.). New York, NY: McGraw-Hill/Irwin. Using your own words, summarize the process for learner analysis.

  Leadership is not something you can practice in isolation

Leadership is not something you can practice in isolation. You have to practice in front of the very people you are trying to influence

  What are the political factors of the spotify industry

What are the political factors of the Spotify industry? (Case 9, Spotify in 2020: can the company remain competitive?)

  Explore concepts of capitalism and corporations

Capitalism is an economic system based on private ownership and the use of capital. Growth of towns and cities and the expansion of trade in the late Middle Ages sparked this economic development. Capital belongs to individuals who are free to do ..

  Challenge of recruiting to replace an existing leader

Consider the challenge of recruiting to replace an existing leader. Discuss what challenges in the process are present and how they can be addressed by Human Resources.

  What were the objectives of the training program

1. What were the objectives of the training program? Write a training object tive for the program described in the case that contains the key elements and compo

  What sort of questions would you have for a vendor

What are the strengths or weaknesses of each with regard to providing HR with data to support evidence-based decision making? What sort of questions would you.

  Strategies for addressing employee turnover

Describe 3 strategies for addressing employee turnover.

  Explain deadly combination of psychologisation

Kaufman, B. E. (2019). The real problem: The deadly combination of psychologisation, scientism, and normative promotionalism takes strategic human resource mana

  Explain strategic planning process

How can the ability to deal with ambiguity be helpful in the strategic planning process?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd