Develop a spreadsheet for Problem 7
(a) What would your recommendation be if the weight for the implementation risks went down to 10 and the weight of cultural differences went up to 25?
(b) Suppose instead that method A received a score of 3 for implementation risks. Would your recommendation change under these circumstances?
(c) The vice president of finance has looked at your original scoring model and feels that tax considerations should be included in the model with a weight of 15. In addition, the VP has scored the methods on tax considerations 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?
Problem 7
Use a weighted score model to choose between three methods (A, B, C) of financing the acquisition of a major competitor. The relative weights for each criterion are shown in the following table as are the scores for each location on each criterion. A score of 1 represents unfavorable, 2 satisfactory and 3 favorable
