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.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |