Please help in solving a review problem for a final exam. I am having trouble setting up the problem in Excel. The goal of the problem is to find the minimum transportation cost associated with the network.
I have attached a diagram (see the attachment).
The following diagram shows a transshipment network. Nodes 1, 2, and 3 are supply nodes. The supply values are to the left of these nodes. Nodes 6, 7, and 8 are demand (sink) nodes, and the demand values are to the right of these nodes. Transshipment routes between nodes are labeled with the transportation cost per unit.© BrainMass Inc. brainmass.com March 4, 2021, 8:18 pm ad1c9bdddf
Excel file contains optimal solution of Transshipment problem.