Solve problem show equations and solver constraints

TH DS go B E F G H u K L M N O Problem 3 (based on textbook Problem 3.38) Ton (S) 1 Problem 3 Amount Volume per Ton Profit per 2 Commodity Available (tons) (cubic feet) 3 1 4.800 40 70 4 2 2,500 25 50 5 3 1.200 60 60 6 4 1.700 55 80 2 B Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia, Paul is preparing a loading plan for an ICC freighter destined for Ghana. An agricultural commodities dealer wants to transport four products aboard the ship. The first table in the spreadsheet shows the weight volume, and profitability of each product Paul can elect to load any and/or all of the available commodities. However, the ship has three cargo holds with the capacity restrictions given in the second table. 10 11 12 13 14 15 10 17 18 19 20 21 22 23 24 25 20 More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10% of the weight in the rear cargo hold, and the center cargo must be between 40% and 60% of the total weight on board. Create an LP spreasheet model for this problem and find the optimal solution using Solver Check figure: Max Profit 5669,000 Hints & Comments: This problem has alternate optimal solutions