Task A.(30 points) Address the problem described below. 1. Globalnet Foods, Inc., imports food products such as meats, cheese, and pastries to the US from warehouses at ports in Hamburg, Marseilles, and Liverpool. Ships from these ports deliver the products to Norfolk, New York, and Savannah, where they are stored in company warehouses before being shipped to distribution centers in Dallas, St. Louis, and Chicago. The products are then distributed to specialty food stores and sold through catalogs. The shipping costs (\(\$ /1000\mathrm{lb}\)) from the European ports to the US cities and the available supply (1000 lb ) at the European ports are provided in the file. Transportation costs from each US warehouse to the three distribution centers and the demand at the distribution centers are also provided. 2. Ignore the capacity restrictions for the US Warehouses and the shipping capacity constraints as noted in the worksheet, Row 10 Columns B through D and column G .3. Determine the optimal shipments between the European ports and the warehouses and the distribution centers that will minimize total transportation costs. B.(10 pts) This next step is a challenging one. See if you can determine how to control for capacity constraints by setting up the correct constraint in solver. Consider the fact that the US Warehouses have capacity constraints. Also, due to government restrictions, freight capacity for shipments has limitations in some areas. How does this impact your answer in part A? Create a new worksheet by copying your current worksheet and include the capacity and shipping constraints provided in the worksheet. These capacity restrictions are handled in solver with an additional constraint. Shipping Costs (\$):Shipping Costs (\$):