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. + Shipping cost ($/container) European Port 1. Gdansk 2. Hamburg 3. Lisbon 4. Norfolk 1,725 1,825 2,060 U.S. Port 5. 6. New Jacksonville Orleans 1.800 2,345 1,750 1,945 2,175 2,050 7. Galveston 2,700 2,320 2,475 Shipping cost($lcontainer) U.S. Port 4. Norfolk 5. Jacksonville 6. New Orleans 7. Galveston 8. Dallas 825 750 325 270 Inland Port 9. Kansas City 545 675 605 510 10. Front Royal 320 450 690 1,050 Shipping cost ($/container) 15. Cleveland Inland Port 8. Dallas 9. Kansas City 10. Front Royal 960 Distribution Centers 14. 12. Denver 13. Pittsburgh Nashville 830 565 420 520 450 380 390 1,200 450 11. Tuscon 450 880 1,350 660 310 Port Capacity European Port 1. Gdansk 2. Hamburg 3. Lisbon Available Containers 125 210 160 Intermodal Inland Port 9. Kansas City 8. Dallas 10. Front Royal U.S. Port 4. Norfolk 5. Jacksonville 6. New Orleans 7. Galveston Intermodal Capacity Capacity 85 110 100 130 425 170 240 140 Distribution Centers 13. Pittsburgh 14. Nashville 11. Tuscon 12. Denver 15. Cleveland Inland Port 8. Dallas 9. Kansas City 10. Front Royal Demand 85 60 105 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. 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. + Shipping cost ($/container) European Port 1. Gdansk 2. Hamburg 3. Lisbon 4. Norfolk 1,725 1,825 2,060 U.S. Port 5. 6. New Jacksonville Orleans 1.800 2,345 1,750 1,945 2,175 2,050 7. Galveston 2,700 2,320 2,475 Shipping cost($lcontainer) U.S. Port 4. Norfolk 5. Jacksonville 6. New Orleans 7. Galveston 8. Dallas 825 750 325 270 Inland Port 9. Kansas City 545 675 605 510 10. Front Royal 320 450 690 1,050 Shipping cost ($/container) 15. Cleveland Inland Port 8. Dallas 9. Kansas City 10. Front Royal 960 Distribution Centers 14. 12. Denver 13. Pittsburgh Nashville 830 565 420 520 450 380 390 1,200 450 11. Tuscon 450 880 1,350 660 310 Port Capacity European Port 1. Gdansk 2. Hamburg 3. Lisbon Available Containers 125 210 160 Intermodal Inland Port 9. Kansas City 8. Dallas 10. Front Royal U.S. Port 4. Norfolk 5. Jacksonville 6. New Orleans 7. Galveston Intermodal Capacity Capacity 85 110 100 130 425 170 240 140 Distribution Centers 13. Pittsburgh 14. Nashville 11. Tuscon 12. Denver 15. Cleveland Inland Port 8. Dallas 9. Kansas City 10. Front Royal Demand 85 60 105 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