Fernando Garza’s firm wishes to use factor rating to help select an outsourcing provider of logistics services PLEASE US

[answerhappygod]

Fernando Garza’s firm wishes to use factor rating to help select
an outsourcing provider of logistics services
PLEASE USE EXCEL TO SOLVE PROBLEMS AND WRITE DOWN
FORMULAS/FUNCTIONS AS WELL
a) With weights from 1–5 (5 highest) and ratings 1–100 (100
high- est), use the following table to help Garza make his
decision:
95
b) Garza decides to increase the weights for quality, delivery,
and cost to 10, 6, and 4, respectively. How does this change your
conclusions? Why?
c) If Overnight Shipping’s ratings for each of the factors
increase by 10%, what are the new results?