Question: 8. Solve this Distributions problem using Excel. Distribution Minimum Cost Problem Ship From F1 F1 DC To W1 DC W1 W2 DC W2 Capacity Unit

8. Solve this Distributions problem using Excel.

8. Solve this Distributions problem using Excel. Distribution Minimum Cost Problem Ship From F1 F1 DC To W1 DC W1 W2 DC W2 Capacity Unit Cost 0 $1,700 100 $450 100 $300 100 $400 100 $550 0 $1,900 A A A A Nodes Net Flow Supply/Demand F1 300 F2 0 250 DC 0 W1 = -225 W2 -325 DC F2 F2 Total Cost $0 $1,700 300 Factory 1 225 Wharehouse 1 100 100 $450 $300 Distribution Center 100 $550 $400 250 Factory 2 100 Wharehouse 2 325 $1,900

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!