Question: *** please show how to complete on excel**** Problem #2 Bob Garmanss firm wishes to use factor rating to help select an outsourcing provider of

*** please show how to complete on excel**** Problem #2 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
Weighted avgs.

a.) The weighted averages are Fedex __________ Worldwide Delivery ______________ UPS ____________

b.) 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).

*** please show how to complete on excel****

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Problem #2 Bob Garmans's 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...

Q:

Problem #2 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...

Q:

PLEASE COMPLETE IN EXCEL AND SHOW PROCESS 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)...

Q:

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...

Q:

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...

Q:

Bob Garmans s 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 1 0 0 ( 1 0 0...

Q:

Chapter 2 Fernando Garza's firm wishes to use factor rating to help select an outsourcing provider of logistics services. a . With weights from 1 - 5 ( 5 highest ) and ratings 1 - 1 0 0 ( 1 0 0...

Q:

22 PART 1 INTRODUCTION TO OPERATIONS MANAGEMENT other measures of tions were benefici of his organization. He would like to know if his organization is maintaining the manufacturing average of 3%...

Q:

Please do 2.9 2.10 2.11 All you have to do is zoom in the image to see it bigger. .. 2.9 Ranga Ramasesh is the operations manager for a firm that is trying to decide which one of four countries it...

Q:

Fernando Garca's frm wishes to use factor rating to hep select on ourong provar of logis We wts from 1-55 being the highest) and ratings tomt 100 (100 being the highest use the following table to...

Q:

If the total of the schedule of accounts payable does not agree with the Accounts Payable balance, what procedures should be used to search for the error?

Q:

Describe a situation in which what was initially stated, or stated "on the surface," was not the real issue. How did the real issue come to the surface? What techniques have you found most useful to...

Q:

John owns two machines. Machine A was purchased five years ago for $30,000 and has $5,000 of remaining basis. John sells machine A in the current year for $3,000. Machine B was purchased two years...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...