solve the problem. Project Criterion Weight B Cost 20 C 3 1 2 20 2 3 1 10 Risk Opportunity Profitability Sustainability Safety Competitiveness 2 3 3 10 1 3 2 10 2 1 1 1 25 10 2 3 2 2 Part 2: Use the spreadsheet from Part 1. 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. -2 X fx A B D F C criterion wight project A E project B cost Risk oppurtunity profitability sustainabilty safety competitive Total 20 20 10 10 10 25 10 175 1 2 2 3 2 1 2 220 2 3 3 1 3 3 1 2 2 235 3 1 3 2 1 3 2