$2\mathrm{.}10$: Please put data on an excel spreadsheet.

Fernando Garza's firm wishes to use factor rating to help select an outsourcing provider of logistics services.

a$)$ With weights from I$-5(5$ highest$)$ and ratings $1-100(100$ highest$),$ use the following table to help Gara make his decision:

$\backslash$table$[[,,],[$crimerion$,$watcti,overincht Streving,wontryites betwers,unires REACMT$],[$Quaity$,5,90,80,75],[$Deluery$,3,70,85,70],[$Cost$,2,70,80,95]]$

b$)$ Garya decides to increase the weights for quality, delivery, and cost to $10,6,$ thd $4,$ respectively. IIow docs this change your coaclusions? Why?

c$)$ Tr Owernight Shipping's ratinges for each of the factors increase by $100\%,$ what are the new results?