MGT 300 Ashford University Point Supplier Evaluation Tool using MS Excel Paper 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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.