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

8. Solve this Distributions problem using Excel.

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