. PURPOSE: To learn how to apply linear programming to transshipment problems. What are transshipment problems? This homework teaches the intricacies of moving goods. Remember all those online orders and two-day delivery promises? This is the science behind making that happen, in a cost-effective manner. Logistics is a complicated business. This homework will be submitted in canvas. You must submit the excel file with the formulas in the appropriate cells and use the solver add-in to arrive at the optimal cost. I will open your excel file and run the solver add-in to verify your solution. TASK: Solve problem S11.36 . The problem MUST be solved using linear programming techniques, i.e. the Solver add-in. Use this template to solve the problem: Template for HWS11-36.xls a To view, the problem click on the link titled "Reading: Chapter 11 Supplement", scroll down the left-hand side to where it says "Problems". Click on that link and scroll down until you find the problems. This is what you will need to do: 1) Provide the summations for each ship from/to. (Highlighted in yellow) 2) Add the formulations for the transshipment flows. (Highlighted in yellow) 3) Establish the constraints. Remember that if supply (demand) is > demand (supply) use a demand then don't ship everything but do force solver to meet demand. NOTE 1: This is an assignment where I review, provide feedback, and allow you to revise and resubmit before the final due date which is extended through the following weekend. Resubmissions can earn up to 50% of missed points. NOTE 2: Any submissions that did not use linear programming, i.e. Solver, to find the solution will not be graded and you will not be allowed to resubmit. B mework #S11-36 Shipped Factory Mexico Puerto Rico Haiti Shipped Silk-Screen Companies Miami Atlanta Houston 0 18 11 0 0 23 0 0 Supply 18 15 23 Shipping Costs ($): Silk-Screen Companies Factory Miami Atlanta Houston Mexico 4 6 3 Puerto Rico 3 5 5 Haiti 2 4 4 Shipping Costs ($): Silk-Screen Companies Miami Atlanta Houston Demand Shipped Distribution Centers New York St. Louis Los Angeles Shipped 20 0 14 0 0 0 0 12 6 20 12 20 Silk-Screen Companies Miami Atlanta Houston Distribution Centers New York St. Louis Los Angeles 5 7 6 10 8 6 8 1 Transshipment flows: Miami Atlanta 23 Houston Cost 27 29