Answered step by step
Verified Expert Solution
Link Copied!

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 0(unsatisfactory) to 100(excellent) and assigned a weight based on its relative importance. Suppliers are considered "preferred" if they score between 90 and 100. 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 70 and 89. In this category, the supplier is required to provide a plan to Michelle Equipment on how to achieve preferred status. A score of 0 to 69 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
1. Calculate the total scores for four vendors. Do not round intermediate calculations. Round your answers to two decimal places.
Toros: fill in the blank 2
105
Sun Devils: fill in the blank 3
82
Gamecocks: fill in the blank 4
95
Buckeyes: fill in the blank 5
88
2. Classify vendors based on their overall scores.
The Toros Company is considered a(an)
acceptable
supplier.
The Sun Devils Company is considered a(an)
acceptable
supplier.
The Gamecocks Company is considered a(an)
acceptable
supplier.
The Buckeyes Company is considered a(an)
acceptable
supplier.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management

Authors: R. Dan Reid, Nada R. Sanders

4th edition

9780470556702, 470325046, 470556706, 978-0470325049

More Books

Students also viewed these General Management questions