ecrease their costs to $18 per liter. Should they Explain your logic. (Hint: There is no single right T to this problem.) scores to 3. Your new value indices for Supplier 1 plier 2 should be 72 and 63, respectively.) F G A B C D Calculating the Value Index for Two Alternative Suppliers 2 3 Performance: 1 = "poor" to 5 = "excellent" Importance: 1 = "completely unimportant" to 5 = "critical" 4 5 6 Value Index Supplier 1 Supplier 2 20 15 20 16 8 Performance Importance Supplier 1 Supplier 2 5 4 4 5 4 2 5 4 3 1 2 3 5 2 2 3 4 1 Totals: 7 8 Performance quality 9 Conformance quality 10 Delivery reliability 11 Delivery speed 12 Cost 13 Mix flexibility 14 Volume flexibility 15 10 3 6 9 10 2 3 63 12 75 be 4. (***) (Microsoft Excel problem) The following figure shows an Excel spreadsheet that calculates the value index for each of two alternative suppliers. Re-create this spreadsheet in Excel. You should develop the spreadsheet so that the results will be recalculated if any of the values in the high- lighted cells are changed. Your formatting does not have to be exactly the same, but the numbers should be. (As a test, see what happens if you change all of the importance scores to 3. Your new value indices for Supplier 1 and Sup- plier 2 should be 72 and 63, respectively.)