Calculate the composite score for each of the three supplier

Assignment Help Project Management
Reference no: EM131572928

Question: Weighted-Point Supplier Evaluation Tool using MS Excel

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.

Verified Expert

This assignment is about the Weighted-Point Supplier Evaluation Tool using MS Excel. It uses the concepts of the total given weighted for evaluation the weight of any object. In this given case study, we have the three quantities supplier A, B and C. We have to evaluate the best one and worst one on the basis of weighted.

Reference no: EM131572928

Questions Cloud

Describe the dividend discount model for stock valuation : Describe the dividend discount model (DDM) for stock valuation. Why is the DDM essentia l for a company to use?
Annual rate of return your folks would be earning : They? don't have slightest idea what return they would be making on investment of $8,434.22. The annual rate of return your folks would be earning on investment
Find the number of permutations of a set with n elements : Find a recurrence relation for the number of permutations of a set with n elements.
Determine the true cash balance as of june : The unadjusted balance per the bank statement on June 30 was $58,200.2. Required: Determine the true cash balance as of June 30
Calculate the composite score for each of the three supplier : Your manager has decided to reduce the number of suppliers for a critical subassembly from three to two-  Weighted-Point Supplier Evaluation Tool
Designed to boost attendance in the dl classroom : Write a brochure/pamphlet designed to boost attendance in the DL Classroom
Why does the value of a share of stock depend on dividends : Financial ratio averages and analysis benefits me in understanding stock performance and valuation. Why does the value of a share of stock depend on dividends?
Discuss the goals of the tower of hanoi puzzle : The Tower of Hanoi A popular puzzle of the late nineteenth century invented by the French mathematician Édouard Lucas, called the Tower of Hanoi.
What is present value of this liability : If the relevant discount rate is 9 percent, what is the present value of this liability?

Reviews

Write a Review

Project Management Questions & Answers

  Discuss the primary reasons why linton records may benefit

Discuss the primary reasons why Linton Records may benefit from its international business.- How will Linton Records be affected if the dollar weakens further?

  Develop a wbs and project schedule in a gantt format

Develop a Work Breakdown Structure (WBS) and project schedule in a Gantt format for the E-Mail Upgrade Project described in the scenario.

  Discuss the product development process at kodak

What kind of new product was EasyShare 1?  -  Discuss the product development process at Kodak. -  Place Kodak's digital cameras in the product life cycle.

  Briefly summarize the literature and prior art

Briefly summarize the literature and prior art (patents related to your product). If applicable, indicate how your product is different than others currently on the market.

  What is the period of waves

A water wave has a frequency of 6 Hz and a wavelength of 3 m. (a) What is the period of these waves?

  Making short-term pricing decision

What additional costs must be taken into account when making a short-term pricing decision where surplus capacity is not available, and overtime, additional shifts, or other means must be used to expand capacity?

  Marketing research is extremely important

As a business owner, marketing research is extremely important, yet many small business owners do not have the time to conduct their own research. If they also cannot afford to hire a marketing firm to conduct this research for them, what would you r..

  Virtual teamsassume that you had to complete a class

virtual teamsassume that you had to complete a class project as a member of virtual team that could meet face to face

  Prepare a recommendation report

Prepare a justification/recommendation report that studies the several ordering options and proposes the most appropriate one for Mr. Vanilli's business.

  How does product differentiation relax price competition

How does product differentiation relax price competition? Illustrate with examples.- How does the number of firms in the industry affect the equilibrium of quantity competition?

  Closing out a project

Closing Out a Project - how can one incorporate the information gleaned from this session into the future project plans and tools

  Project managementcompany a works in a business environment

project managementcompany a works in a business environment of rapid and drastic change together with strong

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