Weighted Totals and Winner

Weighted Totals

Weighted totals add the criterion contributions exactly.

highlighted = computed this step

Totals

The exact totals are 15/2, 43/6, and 22/3.

total=∑weighted contributions\text{total}=\sum \text{weighted contributions}
Weighted totalsThe total for each supplier is the sum of weighted contributions.weighted totalstotalA15/2B43/6C22/3

Close Scores

The totals are close, so exact fractions matter.

compare exact fractions\text{compare exact fractions}
Weighted supplier scorecardThe chart displays the exact base winner and what-if tie.weighted supplier scorecardbase winner Asuppliercostqualitylead-timetotalwinnerA86915/2yesB78643/6noC69822/3noweights: cost 1/2; quality 1/3; lead-time 1/6supplier AA 15/2supplier BB 43/6supplier CC 22/3what-if: A 23/3; B 7; C 23/3what-if winner tie A/C