Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Kentucky Equipment Company is in the process of ranking its suppliers for one of its key components. Each performance category is scored on a
The Kentucky Equipment Company is in the process of ranking its suppliers for one of its key components.
Each performance category is scored on a scale from unsatisfactory to excellent and assigned a weight based on its relative importance. Suppliers are considered "preferred" if they score between and Preferred suppliers are those that the Kentucky Equipment Company will work with on new product development, approve for new business, and assist in maintaining a competitive position. An "acceptable" supplier rating is between and In this category, the supplier is required to provide a plan to Michelle Equipment on how to achieve preferred status. A score of to means that the supplier has a "developmental" supplier rating.
The data related to the weights to each of the performance dimensions and ratings for three companies has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
Questions
Calculate the total scores for four vendors. Do not round intermediate calculations. Round your answers to two decimal places.
Toros: fill in the blank
Sun Devils: fill in the blank
Gamecocks: fill in the blank
Buckeyes: fill in the blank
Classify vendors based on their overall scores.
The Toros Company is considered aan
acceptable
supplier.
The Sun Devils Company is considered aan
acceptable
supplier.
The Gamecocks Company is considered aan
acceptable
supplier.
The Buckeyes Company is considered aan
acceptable
supplier.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started