3 4 5 create an Excel equation to verify the first two best cases by fixing the location order in 12345. (I have done the first two cases in slides 55-57 by fixing the cell order in ABCDE and changing the location order correspondingly. This time, you must fix the location order in 12345, then change the cell order accordingly.) 1 2 3 4 5 1 28 33 22 20 2 27 40 25 d= 3 30 15 6 7 8 9 4 18 10 5 11 12 A B C E A 10 3 1 15 0 000 B 6 4 M= 10 D 3 E 2nd best 4th best 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Location 1 Optimal B 3rd best E B B 2 D D D A 3 E B 4 A D 5 E A A E TC($) 1,347 1,354 1,361 1,363 31 3 4 5 create an Excel equation to verify the first two best cases by fixing the location order in 12345. (I have done the first two cases in slides 55-57 by fixing the cell order in ABCDE and changing the location order correspondingly. This time, you must fix the location order in 12345, then change the cell order accordingly.) 1 2 3 4 5 1 28 33 22 20 2 27 40 25 d= 3 30 15 6 7 8 9 4 18 10 5 11 12 A B C E A 10 3 1 15 0 000 B 6 4 M= 10 D 3 E 2nd best 4th best 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Location 1 Optimal B 3rd best E B B 2 D D D A 3 E B 4 A D 5 E A A E TC($) 1,347 1,354 1,361 1,363 31