Number of suppliers for a critical subassembly

Assignment Help Supply Chain Management
Reference no: EM131881419

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

Questions Cloud

Prepare an income statement using absorption costing : On January 1 of the current year, Townsend Co. Prepare an income statement using absorption costing. Prepare an income statement using variable costing.
Prepare net cash provided by operating activities section : Prepare the Net Cash Provided by Operating Activities section, using the above information, using the direct method
Compute current value for the dow jones industrial average : Compute the current value for the Dow Jones Industrial Average (DJIA). To do this, you need to find its 30 component companies,
Briefly describe the effect on financial statements : Carlson Corporation applies overhead based upon Machine-hours. The amount of overhead applied to production is $274,320. Actual factory overhead was $287,920.
Number of suppliers for a critical subassembly : 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
Calculate the net cash flows for each year : Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV, IRR, and payback?
Difference between thick-big data according to tricia wang : What is the difference between thick and big data according to Tricia Wang?
Record the payment of income tax during the year : Provide the journal entry made by Sara Lee to record the payment of income tax during the year 2009. Provide the journal entry(ies) made by Sara Lee
How many barrels should it order in one shipment : The order processing cost is $10, and inventory holding cost is $25 per item per year. How many barrels should it order in one shipment?

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Supply chain network design for cwc

This assignment explain the supply chain management process of cwc. What is the current annual supply chain cost?

  Criteria when making new location decisions

Identify a number of the typical criteria used when making new location decisions

  Draw the project network

Determine the mean critical path for Brent's job search process. What is the variance of the project duration?

  Compare and contrast economic - market, and relevancy

Please compare and contrast economic, market, and relevancy value.

  Brushing up on inventory control

Health system in Pennsylvania

  Supply chain strategy

Supply chain strategy

  What is the economic order quantity for fans in units

Nittany Fans of Lewistown, Pennsylvania, is a distributor of industrial fans used in plants, warehouses, and other industrial facilities.

  What factors reduce the capacity of the organization

What factors reduce the capacity of the organization to get its objectives?

  What is the total annual cost

What is the total annual cost

  Supply chain management questions

Briefly define the following two supply chain metrics: (i) inventory turnover ratio and (ii) supply chain velocity.

  Explain the supply chain management concept

Explain the supply chain management concept, Differentiate between public and private sector organisations in terms of their supply chain objectives and strategies

  How warehouses can add value in the supply chain

How warehouses can add value in the supply chain

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