Trans-shipment problem can be solved in Excel Solver by setting up a linear programming model.

• Define decision variables for the amount of goods to be shipped between each pair of locations.

• Set up cons...read more

Define the decision variables

Formulate the objective functions

Set up constraints

Open excel solver

Configure solver parameters

Run solver

Review the resulta