Excel Online Structured Activity: Supplier Scorecard for KLM Company

Consider the following KLM Company classification based on it's overall performance scores:

Unacceptable $($less than $50)-$ supplier dropped from further business

Conditional $($between $50$ and $70*)-$ supplier needs development work to improve performance but may be dropped if performance continues to lag Certified $($between $70$ and $90*)-$ supplier meets intended purpose or performance

Preferred $($between $90$ and $100)-$ supplier will be considered for involvement in new product development and opportunities for more business

$*$The upper boundary is not included.

The data related to the weights to each of the performance dimensions and ratings 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 score. Do not round intermediate calculations. Round your answer to two decimal places.

Classify vendor based on it's overall score.