Pete's Plastics manufactures plastic at plants in Miami, St. Louis and Cleveland. Pete needs to ship plastic
Question:
Pete's Plastics manufactures plastic at plants in Miami, St. Louis and Cleveland. Pete needs to ship plastic to customers in Pittsburgh, Atlanta and Chicago. He wants to minimize the cost of shipping the plastic from his plants to his customers. The data for the problem is summarized in the following table.
Distance From Plants to Customers | ||||
Plant | Pittsburgh | Atlanta | Chicago | Supply |
Miami | 1200 | 700 | 1300 | 30 |
St. Louis | 700 | 550 | 300 | 40 |
Cleveland | 125 | 675 | 350 | 50 |
Demand | 40 | 60 | 20 |
1. Formulate the LP for this problem.
2. Create a spreadsheet model for this problem and solve it using solver.
3. What is the optimal solution?
Let | Xij = tons shipped from plant i to customer j (i and j = 1, 2, 3) | |
MIN: | 1200X11 + 700X12 + 1300X13 + 700X21 + 550X22 + 300X23 | |
+ 125X31 + 675X32 + 350X33 | ||
Subject to: | X11 + X12 + X13 = 30 | |
X21 + X22 + X23 = 40 | ||
X31 + X32 + X33 = 50 | ||
X11 + X21 + X31 ³ 40 | ||
X12 + X22 + X32 ³ 60 | ||
X13 + X23 + X33 ³ 20 | ||
Xij ³ 0 |
Operations Management Processes and Supply Chains
ISBN: 978-0133872132
11th edition
Authors: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman