Calculate composite score for each of the three suppliers

Assignment Help HR Management
Reference no: EM132178811

Question: 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.

Reference no: EM132178811

Questions Cloud

Identify one dimension of organizational culture : Next, think about an organization's culture and how it influences managers and their decision making. Identify one (1) dimension of organizational culture.
The unemployment program of the government of guava land : The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten (10) to be specific.
Different stakeholders in the staffing process : As we have seen, there are many different stakeholders in the staffing process. From the perspective of firm profitability
What is the cost of goods sold : Beginning of year finished goods inventory is $120,000 and end of year finished goods inventory is $160,000. What is the cost of goods sold
Calculate composite score for each of the three suppliers : Create a simple MS Excel spreadsheet to enter the relevant data and to calculate the composite score for each of the three suppliers.
What is the equation of the line through : Using points, straight lines, and possibly the curve of a parabola, construct a piecewise function whose graph looks like a smiling face
Prepare the entry to record amortization at december : During 2017, Carla Vista Enterprises Ltd., a private entity, incurred $4.6 million in costs to develop a new software product called Dover
How many units did the manufacturer sell during the month : During the month the company produced 27,000 finished units. How many units did the manufacturer sell during the month
What are the alternatives-what are your recommendations : What are the alternatives? What are your recommendations? Why do you recommend this course of action?

Reviews

Write a Review

HR Management Questions & Answers

  Improve problem solving capabilities within organization

Types of teams as to their effectiveness that will improve problem solving capabilities within organizations.

  Influence tactics help in reducing organizations politics

Explain the different types of influence tactics that will be of a help “if adopted” in reducing the organizational politics.

  Report on citigroup''s hr service level agreement

Human Resources or Human Resource Management deals with HR Service Level Agreement. HR Service Level Agreement is an agreement made between the employer and the employee, which states that the employee would work under any client and sometimes any ti..

  A project report on hrm

Human Resource Management as the name suggests, it is a management discipline which deals with the human i.e. the workforce aspect of organizations. Need and practices of HRM are inevitable in present scenario of extreme competition where "Talent War..

  Hrp: recruitment and selection

Recruitment and Selection is the initial ladder of any Human Resource Planning process and contains an immense significance for any organisation.

  A project report on study of statutory complainces

Statutory compliance and its immense knowledge are crucial to be understood in an organization. It contains all the forms, procedures and acts applicable in a company.

  Operant conditioning and Reinforcement

Operant conditioning is a learning process where behaviour is controlled by its consequences. In this process an individual's behaviour can be modified through the use of positive or negative reinforcement.

  Effectiveness of training programs in achieving customers an

The main motive for conducting this research is to provide broad range of research of the literature and their reviews related to training and development and assisting the employees in providing customers satisfaction.

  A critical analysis of hr processes and practices in fedex c

FedEx is illustrious for its novel HR processes and practices that have greatly accounted for its success.

  Integrating culture and diversity in decision making

People in the organization are known as Google where they share common goals and have common vision.

  Impact of employee attrition on people management in organis

Talent management implies recognizing a person's inherent skills, traits, personality and offering him a matching job.

  Labour dissonance at maruti suzuki india limited: a case stu

This Case Study focuses on various issues related to Labour Unrest at Maruti Suzuki India Limited.

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