Question: Where does the highlighted 5 come from in the 2nd table? The Excel calculation results are: H Criteria Strong Supports Urge 10% of sales from

Where does the highlighted 5 come from in the 2nd table?

Where does the highlighted 5 come from in the 2nd

Where does the highlighted 5 come from in the 2nd

The Excel calculation results are: H Criteria Strong Supports Urge 10% of sales from Comp|Fill market Total Sponsor business strategy ney new products ctition gap Weighted score 5 13 1 13 3 Weight 2 3 4 Project 19 5 Project 2 3 6 Project 36 7 Project 41 8 Project 3 3 5 7 8 10 10 20 2 0 2 3 5 10 10 1 | | | 68 57 99 85 107 19 10 Project 5 is the highest rated while project 2 is the lowest rated as per the project screening matrix calculation. Change the strong sponsor weight in the excel sheet and get the revised score as shown below: B D E F H Strong Supports Criteria |business 2 Sponsor strategy 3 Weight 5 5 4 Project 19 5 5 Project 23 17 6 Project 36 18 7 Project 41 10 8 Project 5 3 10 9 Total Urgen 10% of sales from Comp Fill market Weighted new products etition gap score 14 3 1 3 12 0 2 5 2 10 5 1 166 12 13 16 8 117 5 10 16 9 88 10 1 8 0 116 195 With the changed weight the project's total weighted score changes. The top three projects in descending order are projects 3,5 and 1. The Excel calculation results are: H Criteria Strong Supports Urge 10% of sales from Comp|Fill market Total Sponsor business strategy ney new products ctition gap Weighted score 5 13 1 13 3 Weight 2 3 4 Project 19 5 Project 2 3 6 Project 36 7 Project 41 8 Project 3 3 5 7 8 10 10 20 2 0 2 3 5 10 10 1 | | | 68 57 99 85 107 19 10 Project 5 is the highest rated while project 2 is the lowest rated as per the project screening matrix calculation. Change the strong sponsor weight in the excel sheet and get the revised score as shown below: B D E F H Strong Supports Criteria |business 2 Sponsor strategy 3 Weight 5 5 4 Project 19 5 5 Project 23 17 6 Project 36 18 7 Project 41 10 8 Project 5 3 10 9 Total Urgen 10% of sales from Comp Fill market Weighted new products etition gap score 14 3 1 3 12 0 2 5 2 10 5 1 166 12 13 16 8 117 5 10 16 9 88 10 1 8 0 116 195 With the changed weight the project's total weighted score changes. The top three projects in descending order are projects 3,5 and 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!