Supply Chain Analytics

6 TO 40 points Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it is considering new plants in San Diego, Houston, Tulsa, St. Louis, and Portland. Finished control panels are to be shipped to Seattle, Denver, and Kansas City. Pertinent information is given in the table. Fixed Cost Sources San Diego Houston Tulsa St. Louis Portland 260,000 320,000 350,000 200,000 480,000 Demand Shipping Cost to Destination: Kansas Seattle Denver City 5 7 8 10 8 6 9 4 3 12 6 2 4 10 11 6,000 15,000 15,000 Capacity 12,500 12,500 10,000 10,000 10,000 Management must come up with a plan to decide which facilities are going to be open and how to manage the whole supply chain. Formulate this problem as a Linear Programming Problem 1. What is the objective function? 2. What are the constraints? 3. Which manufacturing facilities are open? List any unused capacities at the plants. 4. What is the total cost of this supply chain? Drag n' Drop here or Browse 6 TO 40 points Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it is considering new plants in San Diego, Houston, Tulsa, St. Louis, and Portland. Finished control panels are to be shipped to Seattle, Denver, and Kansas City. Pertinent information is given in the table. Fixed Cost Sources San Diego Houston Tulsa St. Louis Portland 260,000 320,000 350,000 200,000 480,000 Demand Shipping Cost to Destination: Kansas Seattle Denver City 5 7 8 10 8 6 9 4 3 12 6 2 4 10 11 6,000 15,000 15,000 Capacity 12,500 12,500 10,000 10,000 10,000 Management must come up with a plan to decide which facilities are going to be open and how to manage the whole supply chain. Formulate this problem as a Linear Programming Problem 1. What is the objective function? 2. What are the constraints? 3. Which manufacturing facilities are open? List any unused capacities at the plants. 4. What is the total cost of this supply chain? Drag n' Drop here or Browse