a. What would your recommendation be if the weights for Safety went down to 10 a

Question

a. What would your recommendation be if the weights for Safety went down to 10 and Profitability went up to 25?

b. Suppose instead that method A received a score of 3 for Safety and method C received a score of 1 for Safety. Would your recommendation change under these circumstances?  

c. The vice president of finance has looked at your original scoring model and feels that Tax Consideration should be included in the model with a weight of 15. In addition, the VP has scored the methods on Tax Consideration as follows: method A received a score of 3, method B received a score of 2, and method C received a score of 1. How would this additional information affect your recommendation?

NOTE: When answering the questions a-c in Exercise 7, keep the changes as you progress in the problem. For example, when you change the weights for questions "a," keep the new weights when moving on to question "b."

MAKE SURE YOU USE EXCEL TO DO THE CALCULATION TO SOLVE THE PROBLEMS.

Weights 4 Category 5 Cost 6 Risk 7 Opportunity 8 Profitability 9 Sustainability 10 Safe 11 Competitiveness 12 weight % 2 10 10 10 10% 10% 10% 24% 10% 2 2 2 2 2 1.666667 2.095238 2.238095 10 2 2 Total Weighted Score

Explanation / Answer

a) Changing Safety tp 10 and Profitability to 25

Now B is the best option

b) Changing Safety score of A & C

No, recommendation will not change as B is still the best

c) Tax consideration added:

No, recommendation will not change and still be B

Category Weight Weight % A B C Cost 20 19% 1 2 3 Risk 20 19% 2 3 1 Opportunity 10 10% 2 1 3 Profitability 25 24% 3 3 2 Sustainability 10 10% 2 1 1 Safety 10 10% 1 2 3 Competitiveness 10 10% 2 2 2 105 1.952381 2.238095 2.095238

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.