Excel File Edit View Insert Format Tools Data Window Help Thu Mar 17 10:16 PM ... AutoSave OFF NO2.0 UL Homework2-2-1 Home Insert Draw Page Layout Formulas Data Review View Shape Format Tell me e Share Comments X Calibri (Body) 14 VA APA Y 2. $Wrap Text Number 2-D Paste BTU ov == Marge & Center Insert $ v % 9 Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Y Rectangle X fix A D F G H TL M N 0 P Q A 5 TU V W X Weight the meet the more trebuie theksa the bette Facters Population |Pairy Wholesale Nternatives Surpisuppler ? Super3 0.2 560.0 $45.0 0.61 10 11 11 0.21 10 9 11 In this problem, we assume that a buyer is going to select a single supplier to mert its demand. The buyer uses three factors to evaluate the suppliers: wholesale price, quality and reputation. You can find the suppliers' information in the table. Assume that the relative impartance of the wholesale price is 0.2, the quality is 0.6, and the reputation is 0.2. You need to evaluate these suppliers by using factor rating technique to see what supplier is the best? To solve this problem, pay attention to the nature of the three factors: the last one is the less is the better" and the ather two are the more is the better". So, you need to convert the more is the better' to 'the less is the better" or vice versa. You need to figure out how to do it. Also, you to normalize the numbers because they have to have the same scale or unit. Overalco The rubric 10 11 12 13 14 1 16 17 18 Normalizing the numbers Converting "the more is the better" to "the less is the better" or vice versa Mentioning what supplier is the best 1 point 1 point 1 point 20 21 22 7) 24 27 29 33 31 35 37 39 O 23 04 Factor Rating-3 points Supplier Selection-3 points + Ready IT C UT 94% a 17 atv A