Fred Block Company has orders for 90 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 20 tons. Fred has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown as follows Delivery Cost Per Ton Northwood Westwood Eastwood Plant1 20 30 40 Plant 2 30 40 45 a. Develop a network representation of this distribution problem. b. Develop a linear program model that can be used to determine the plan that will minimize total distribution costs. c. Solve the problem to describe the distribution plan and show total distribution cost.(Submit Excel files).
Fred Block Company has orders for 90 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 20 tons. Fred has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown as follows
Delivery Cost Per Ton
Northwood Westwood Eastwood
Plant1 20 30 40 Plant 2 30 40 45
a. Develop a network representation of this distribution problem.
b. Develop a linear program model that can be used to determine the plan that will minimize total distribution costs.
c. Solve the problem to describe the distribution plan and show total distribution cost.(Submit Excel files).
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
