This assignment is based on problems 6 and 7 (a, b, c) in Chapter 2 of your textbook, but the assignment uses new problems to test your knowledge. Please refer back to those problems if you need to review how to best complete this assignment, and then provide your answers to the problems below.

Use Microsoft Excel (or a similar program) and work on a spreadsheet for each question.

Problem 1 (10 points): Use a weighted score model to choose between four projects (A, B, C, D) for updating an important internal process. The relative weights and different project scores for each category are shown in the following table. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable.

On the spreadsheet, add up the total scores for each project and select only one project based on the total scores. Explain your reasoning for your selection.

		Project
Category	Weight	A	B	C	D
Cost	20	1	2	3	1
Risk	15	2	3	1	2
Strategic opportunity	10	2	1	3	3
Profitability	10	3	3	2	1
Sustainability	10	2	3	3	2
Safety	25	1	2	3	3
Competitiveness	10	2	2	2	2

Problem 2 (10 points): What would your recommendation be if the weight for the safety went down to 10 and the weight of profitability went up to 25?

Make a new copy of the first spreadsheet. This can be a new tab. On the second spreadsheet, make changes and compute new total scores for each project. Explain your recommendation based on the changes in the weights of the two criteria.

Problem 3 (10 points): If Project A received a score of 3 for safety, how would your recommendation change under these circumstances?

Make a new copy of the second spreadsheet. This can be a new tab. On the third spreadsheet, make the changes and add up the new total scores for each project. Explain your recommendation based on the change.

Problem 4 (20 points):

• 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 projects on tax considerations as follows: Project A: 3, Project B: 2, Project C: 1, Project D: 3.
• You decided to reduce other weights to make the sum of weight 100%. You reduced cost to 15, profitability to 20, and risk to 10.
• How would this additional information affect your recommendation?
• If you need to select only one project among these four, which one would you select taking into account the importance of strategic opportunity between projects having equal scores?

Make a new copy of the third spreadsheet. This can be a new tab. On the fourth spreadsheet, make changes and add up the new total scores for each project. Answer the questions in the last two bullets above.