Question: please help me use excel and step by step give me more pictures and formula, thanks alot! Consider the transshipment network of Figure 1. Nodes

please help me use excel and step by step give me more pictures and formula, thanks alot!
Consider the transshipment network of Figure 1. Nodes (1) and (5) are the plant sites. The plants produce 200 and 150 truckloads respectively. Nodes (3),(6), and (9) are the outlet sites. The outlets demand 50,250 , and 50 truckloads, respectively. The number on arc (i,j) indicates the costs of transporting one truckload from i to j. Assume the cost from i to j is the same as the cost from j to i. - Find the least costs of moving one truckload from (1) to (3), (6), and (9). - Find the least costs of moving one truckload from (5) to (3), (6), and (9). - Formulate and solve the transportation model. What is the minimum total cost? Figure 1: Network Diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
