How do I solve this problem in excel? I started working on it, but I'm a bit stuck. Please show me how to do it, your help is greatly appreciated. Thumbs up guaranteed for best answer :)

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. In agricultural commodities dealer wants to transport four products aboard the ship. Paul can elect to load any or all of the available commodities. However, the ship has three cargo holds with the capacity restrictions indicated. 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 hold must be between 40% to 60% of the total weight on board. Paul wishes to maximize his total profit. Volume Tons to ship Volume perton Profit perton Weight Capacity Product Capacity Cargo Hold Forward $70 $50 Center 4,800 2,500 1,200 1,700 40 25 60 55 3,000 6,000 4,000 145,000 180,000 155,000 $60 Rear $80 tons cubic feet tons cubic feet Cargo Hold Forward Center Rear Wt Cap Vol Cap 3,000 145,000 6,000 180,000 4,000 155,000 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. In agricultural commodities dealer wants to transport four products aboard the ship. Paul can elect to load any or all of the available commodities. However, the ship has three cargo holds with the capacity restrictions indicated. 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 hold must be between 40% to 60% of the total weight on board. Paul wishes to maximize his total profit. Volume Tons to ship Volume perton Profit perton Weight Capacity Product Capacity Cargo Hold Forward $70 $50 Center 4,800 2,500 1,200 1,700 40 25 60 55 3,000 6,000 4,000 145,000 180,000 155,000 $60 Rear $80 tons cubic feet tons cubic feet Cargo Hold Forward Center Rear Wt Cap Vol Cap 3,000 145,000 6,000 180,000 4,000 155,000