Manras Med Incorporated is a distributor of Personal Protective Equipement (PPEs) in North America. Personal protective equipment (PPEs) are protective clothing. helmets, goggles, or other garments or equipment designed to protect the wearer's body from injury or infection that have been mandatorily used during the pandemic of Covid 19. The company contracts manufacturers from all over the world and domestic suplliers like 3M, and these products are delivered to warehouses in three Europen ports Gdansk, Hamburg and Lisbon. The PPEs are loaded into container ships to the ports of Norfolk, Jacksonville, New Orleans and Galveston. From these seaports, the containers are typically coupled with trucks and hauled to inland ports of Front Royal, Kansas and Dallas. There are a fixed number of freight haulers available at each port each month. From these inland ports, the containers are transported to Manras distribution centers in Tuczon, Pittsburg and Denver, Nashville and Cleveland. Following are the handling and shipping costs ($/container) between each of the embarkation and destination points along this overseas supply chain and the available containers at each port. Inland Port 8. Dallas 9. Kansas City Distribution Centers 11. Tuscon 12. Denver 13. Pittsburgh 10. Front Royal Demand 85 60 105 14. Nashville 15. Cleveland 50 120 Formulate and solve a linear programming model using solver to determine the optimal transshipment from each of point of embarkation to each destination along this supply chain that will result in the minimum total shipping cost. + Shipping cost ($/container) U.S. Port 5. 6. New European Port 4. Norfolk Jacksonville Orleans 7. Galveston 1. Gdansk 1,725 1,800 2,345 2,700 2. Hamburg 1,825 1,750 1,945 2,320 3. Lisbon 2,060 2,175 2,050 2,475 Shipping cost($/container) Inland Port 9. Kansas 10. Front U.S. Port 8. Dallas City Royal 4. Norfolk 825 545 320 5. Jacksonville 750 675 450 6. New Orleans 325 605 690 7. Galveston 270 510 1,050 Shipping cost ($/container) Distribution Centers 14. 15. Inland Port 8. Dallas 11. Tuscon 12. Denver 13. Pittsburgh Nashville Cleveland 450 830 565 420 960 9. Kansas City 880 520 450 380 660 10. Front Royal 1,350 390 1,200 450 310 Port Capacity Available European Port Containers 1. Gdansk 125 2. Hamburg 210 3. Lisbon 160 Inland Port 9. Kansas Intermodal U.S. Port 8. Dallas City 10. Front Royal Capacity 4. Norfolk 85 5. Jacksonville 6. New Orleans 7. Galveston 110 100 130 Intermodal Capacity 170 240 140 425