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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!