Problem 3. Cargo Loading (25 pt.) Andrew Karminsky is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Andrew is developing a cargo loading plan for an ICC freighter destined for Ghana. A mineral commodities trader wants to transport the following products aboard this ship. Commodity 1 2 3 4 Amount Available (tons) 4.800 2,500 1.200 1.700 Volume per Ton (cubic feet) 40 25 60 55 Profit per Ton ($) 70 50 60 80 Andrew can choose to load any and/or all of the available mineral commodities. But, the three cargo holds of the ship are subject to the following capacity restrictions: Cargo Hold Front Middle Back Weight Capacity (tons) 3,000 6.000 4.000 Volume Capacity (cubit feet) 145.000 180.000 155,000 The ship can place one or more than one type of mineral commodity in the same cargo hold. However, considering stability, the weight of mineral commodities loaded in the front cargo hold must be no more than 10% of the weight in the back cargo hold, and the weight of mineral commodities loaded in the middle cargo hold must range between 40% and 60% of the total weight on board a. Formulate an optimization model for this problem algebraically. b. Formulate and solve an optimization model for this problem on a spreadsheet