To solve the problem by using the solver, we need to input s…
To solve the problem by using the solver, we need to input some numbers, cells, and formulas. Answer the following questions. Note: Cells B2:C4 are the designated cells for the optimal values of the decision variables, respectively, while cell F5 is the designated cell for the objective function value. This is an example of how to answer the following questions. Complete the following cells, which are related to the transportation cost (F2:G4) and Netflow (D7:D11). F2: 5 D7: =B7-C7 F3: 8 D8: =B8-C8 F4: 9 D9: =B9-C9 G2: 4 D10: =B10-C10 G3: 10 D11: =B11-C11 G4: 11