User Account

All Pages

Create a simple ms excel spreadsheet to enter the data

Assignment Help Operation Management
Reference no: EM132137466

Assignment

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: EM132137466

Questions Cloud

Make staff cutbacks because of declining profits : A paper manufacturer is forced to make staff cutbacks because of declining profits. It decides to cut back each employee's hours and pay by one-half day per
Research the literature regarding issues : Research the literature regarding issues that involve the selected agency and public administration in general.
Evaluate microsoft product and marketing evolution : Evaluate Microsoft's product and marketing evolution over the years. What has the company done well, and where did it falter?
What is your competitive advantage : Provide the vision, mission, and values of the organization. How do organization values drive the culture? What is the culture you intend to build, or exists.
Create a simple ms excel spreadsheet to enter the data : Create a simple MS Excel spreadsheet to enter the relevant data and to calculate the composite score for each of the three suppliers.
Synthesizing the information to provide new perspectives : Share an insight from having read your colleagues' postings, synthesizing the information to provide new perspectives. Validate an idea with your own experience
Find the laplace transforms of the functions : Find the Laplace transforms of the functions - Find the Laplace transform - Find the Laplace transform of cosh at cos
Under which incoterm you would be interested in closing deal : You start your export activity and you have no experience. Under which INCOTERM you would be interested in closing deals? why?
Perceptions to match objective reality : Leaders who recognize perceptual distortions can adjust their perceptions to match objective reality?

Reviews

Write a Review

Operation Management Questions & Answers

  Common reason that companies fail

A common reason that companies fail is:

  Is advertising socially desirable of our economic system

Is busines meeting its responsibilities to consumers with regard to the safety, quality, pricing, and labeling and packaging of its products? if not, how might it do better?

  Difference in managing costs as opposed to managing prices

What is the difference between “managing costs” as opposed to “managing prices”?

  Pursuant to an oral agreement

Pursuant to an oral agreement, Andy and Jeff formed a partnership to do kitchen remodeling.

  Describe your findings and observations

Describes your findings and observations. Include additional resources that support, reinforce, or even challenge your findings and observations.

  Create strong relationships-customer value through marketing

How can a company create strong relationships and customer value through marketing?

  Rreverse discrimination case on the basis of unfair

A male scored three points lower than a female on a selection test. The female was hired. The male filed a reverse discrimination case on the basis of unfair use of test scores for selection. What evidence would he have to provide to support his clai..

  Discuss your power sources and your co-owners power sources

Discuss your power sources and your co-owner's power sources in this negotiation, and analyze how you can strengthen your power position.

  The managers changing work environment

You will learn about the general environment which can affect a company's success including economic forces, technological forces, socio cultural forces, demographics forces, political forces and international forces. Provide examples of three of the..

  If an organization fosters and values workforce diversity

If an organization fosters and values workforce diversity, it is most likely to:

  Random numbers are equally likely to occur

The arrival rate is the. Random numbers are equally likely to occur.

  Co-workers have been impacted by the free trade movement

Explain why or why not. Please include in your posting examples of how you, your family, neighbors, friends, and co-workers have been impacted by the free trade movement.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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