Fernando Garza's firm wishes to use factor rating to help select an outsourcing provider of logistics services. Part 2 a) With weights from 1 − 5 (5 being the highest) and ratings from 1 − 100 (100 being the highest), use the following table to help Garza 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) Overnight Shipping Worldwide Delivery United Freight Quality 5 86 80 75 Delivery 3 74 90 68 Cost 2 66 81 92 Weighted average score: 78.478.4 83.283.2 76.376.3 Part 3 The best outsource provider is Worldwide DeliveryWorldwide Delivery . Part 4 b) Garza decides to increase the weights for quality, delivery, and cost to 10, 6, and 4, respectively. If each weight is doubled, the best outsource provider is

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Part 2

a) With weights from 1

−

5 (5 being the highest) and ratings from 1

−

100 (100 being the highest), use the following table to help Garza 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)	Overnight Shipping	Worldwide Delivery	United Freight
Quality	5	86	80	75
Delivery	3	74	90	68
Cost	2	66	81	92
Weighted average score:		78.478.4	83.283.2	76.376.3

Part 3

The best outsource provider is

Worldwide DeliveryWorldwide Delivery

Part 4

b) Garza decides to increase the weights for quality, delivery, and cost to 10, 6, and 4, respectively.

If each weight is doubled,

the

best outsource provider is

▼

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

c) If Overnight Shipping's ratings for each of the factors increase by 10%, what are the new results?

If Overnight Shipping's ratings for each of the factors increase by 10%,

the

best outsource provider is

▼

Worldwide DeliveryWorldwide Delivery

United FreightUnited Freight

Overnight ShippingOvernight Shipping

with a weighted average score of

enter your response here

(enter your response rounded to one decimal place).

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions