Question: Please show work either in Excel with formulas or handwritten so I can understand what's going on! I promise to upvote if correct!! Nestle is
Please show work either in Excel with formulas or handwritten so I can understand what's going on! I promise to upvote if correct!!

Nestle is selecting one of two suppliers for sourcing its hazelnuts. They developed the following supplier scorecard and evaluated each supplier on a score of 0-100 for each of the performance criteria in the scorecard with 0 as worst and 100 as best. - Calculate the overall weighted total score for each supplier. - Express this score as number between 0 and 100 by dividing the weighted total for each supplier by the sum of the weights. Which supplier does Nestle prefer? Enter the score for the better of the two suppliers - Express the score as an average number between 0 and 100. Carry all calculations to at least 3 decimal places. Enter your final answer to 1 decimal place, i.e. the nearest tenth
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
