1 - C10 9 % fo Conditional Format CH Formatting as Table St 36 TO B D 31 E G H 32 Your tasks are to formulate the problem so that it can be solved by Solver. Thus, you need to: 33 1. Specify and formulate the Changing Calls (use yellow color to indicate the changing cells) 34 2. Specify and formulate the Target Cell (use a light blue color to indicate the target cell) 35 3. Specify and formulate the Constraints. 4. Solve this problem with the Solver and determine what is the minimum cost and how many 37 units will be shipped from factories to distribution centers, and from distribution centers to warehouses. 38 39 Hint 40 Think of this problem as consisting of two stages. Staget: from factories to distribution centers. Stage2: from distribution centers to warehouse. 41 Calculate the cost for each stage then the total cost for all stages 42 The total units shipped to each distribution center should be equal to the total units shipped out from each distribution center 43 44 45 Stage 1 46 C2 42 Capacity $ 1.36 $ 1.28 2400 48 FROM B $ 1.28 $ 1.35 49 1.68 $ 1.55 2500 50 51 52 Stage2 FROM 53 C1 C2 Demand 54 W1 $ 0.60 $ 0.80 1250 55 W2 $ 0.36 $ 0.56 1000 56 TO W3 $ 0:32 S 0.42 1600 57 W4 $ 0.44 $ 0.40 1750 58 WS $ 0.72 $ 0.55 1500 59 60 61 You can start writing your answer below this row. Sheet1 C1 2750 $ +