Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. Use a weighted score model to choose between three projects (A, B, C) for updating an important internal process. The relative weights for each
6. Use a weighted score model to choose between three projects (A, B, C) for updating an important internal process. The relative weights for each criterion are shown in the following table as are the scores for each project on each criterion. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable. Project Criterion Weight A B C Cost 20 1 2 3 Risk 20 2 3 1 Opportunity 10 2 1 3 Profitability 10 3 3 2 Sustainability 10 2 1 1 Safety 25 1 2 3 Competitiveness 10 2 2 2 7. Develop a spreadsheet for Exercise 6 a. What would your recommendation be if the weight for the safety went down to 10 and the weight of profitability went up to 25? b. Suppose instead that method A received a score of 3 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 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started