Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1: (25) Given: Massachusetts Block Company (MBC) has orders for 80 tons of concrete masonry blocks at three locations as follows: Lowell = 25 tons,
1: (25) Given: Massachusetts Block Company (MBC) has orders for 80 tons of concrete masonry blocks at three locations as follows: Lowell = 25 tons, Salem = 45 tons, and Worchester = 10 tons. MBC has two plants; Plant 2 can produce up to 50 tons per week while Plant 1 can only produce a maximum of 40 tons per week. The deliveries must be shipped through two warehouses before reaching their final destination. Delivery costs per ton between each location and capacity at each location are provided below: Find: a) Formulate the LP problem with Network Diagram and mathematical expression for decision variables, objective function, and constraints (10) b) Solve for the minimum cost shipping plan using Excel Solver. Illustrate the optimal shipping plan in a network diagram. (15)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started