Project management assignment
joshna
weightedscoringmodel.xlsSheet1
| Weighted Scoring Model for Project Name | |||||
| Created by: | Date: | ||||
| Note: Enter your criteria, weights, and scores in the template below. | |||||
| Insert or clear rows and columns as needed. Double check formulas and results. | |||||
| Criteria | Weight | Project 1 | Project 2 | Project 3 | Project 4 |
| A | 25% | 90 | 90 | 50 | 20 |
| B | 15% | 70 | 90 | 50 | 20 |
| C | 15% | 50 | 90 | 50 | 20 |
| D | 10% | 25 | 90 | 50 | 70 |
| E | 5% | 20 | 20 | 50 | 90 |
| F | 20% | 50 | 70 | 50 | 50 |
| G | 10% | 20 | 50 | 50 | 90 |
| Weighted Project Scores | 100% | 56 | 78.5 | 50 | 41.5 |
Sheet1
Weighted Score by Project
