Question: Problem #12: Please resolve this problem using solver in Excel (part c). Step by step screen shoots would be very helpful. Thank you. b. Determine

Problem #12: Please resolve this problem using solver in Excel (part c). Step by step screen shoots would be very helpful. Thank you.

Problem #12: Please resolve this problem using

b. Determine the optimal assignment of 11. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit in S) from each plant to each warehouse are as follows: Warehouse 2 1 Plant 1 2 3 Capacity 450 600 380 7 5 6 4 8 5 Customer demand and shipping costs per unit in $) from each warehouse to each customer are as follows: Customer 2 Warehouse 1 3 7 + 1 2 6 3 4 6 8 7 7 Demand 300 300 300 400 a. Develop a network representation of this problem. b. Formulate a linear programming model of the problem. c. Solve the linear program to determine the optimal shipping plan. 12. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted at $2 per unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of $7 per unit a. Develop a network representation of this problem. b. Formulate a linear programming model of this problem. Solve the linear program to determine the optimal shipping plan. C

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!