Question: Create a weighted scoring model to determine which project to select. Assume the criteria are cost, strategic value, risk, and nancials, with weights of 10%,
Create a weighted scoring model to determine which project to select. Assume the criteria are cost, strategic value, risk, and nancials, with weights of 10%, 40%, 20%, and 30%, respectively. Enter values for Project I as 90, 70, 85, and 50; Project 2 as 75, 80, 90, and 70; and Project 3 as 80 for each criterion. Use the weighted scoring model discussed in lecture material, create the model, calculate the weighted score, and graph the results. Which project would you select? Why?
Submit both exercises in one file (Excel or Word file) that contains both answers.
Document must be professionally generated. Include your name, course name, assignment number and date at the top of the spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
