The following worksheet uses a weighted-point evaluation system to calculate weighted performance scores along four dimensions for up to four potential sources. Re-create this spreadsheet in Microsoft Excel. Code your spreadsheet so that any change in the highlighted cells will result in recalculated performance scores. Your formatting does not have to be exactly the same, but your numbers should be.

Transcribed Image Text:

Weighted-Point Evalulation System A B D E 1 Weighted-Point Evaluation System 2 Potential Sources 4 Dimension Importance X1 X2 X3 Х4 A 0.20 3 6. B 0.30 2 4 3 C 0.30 4 3. 8 0.20 3 1 9 Total: 1.00 10 Scores: 2.2 3.6 2.6 2.2 422 24 /7