A company using a weighted$-$criteria evaluation system has established these $4$ categories and the appropriate weight in parentheses: Reputation $(0\mathrm{.}20),$ Quality $(0\mathrm{.}35),$ Environmental $(0\mathrm{.}15),$ Cost $(0\mathrm{.}30).$ The scores for each category are shown below.xcel Online Structured Activity: Supplier Scorecard for XYZ Company

Consider the following XYZ 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.