PLEASE COMPLETE IN EXCEL USING SUMPRODUCT FUNCTION

Bob Garmanss firm wishes to use factor rating to help select an outsourcing provider of logistics services.

With weights from 1 minus 5 (5 being the highest) and ratings from 1 minus

100 (100 being the highest), use the following table to help Bob make his decision.

In the following table, compute the weighted average score for each of the three companies (enter your responses rounded to one decimal place).

Criterion	Weight (W)	Fedex	Worldwide Delivery	UPS
Quality	5	88	81	72
Delivery	3	71	82	68
Cost	2	68	79	100

1. The weighted averages are

Fedex __________

Worldwide Delivery ______________

UPS ____________

1. Garza decides to increase the weights for quality, delivery, and cost to 15, 9, and 6 respectively.

If each weight is tripled, the best outsource provider is ________________________________

c. ) If Fedexs ratings for each of the factors increase by 10%, what are the new results?

If Fedexs Shipping's ratings for each of the factors increase by 10%, the best outsource provider is

______________________ with a weighted average score of _______________________

(enter your response rounded to one decimal place).