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.