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. Profit Volume Tons to ship Product per ton Cargo Hold Capacity $70 Forward Volume per ton 40 25 60 55 4,800 2,500 1,200 1,700 Weight Capacity 3,000 6,000 4,000 Center $50 $60 $80 145,000 180,000 155,000 Rear tons cubic feet tons cubic feet Cargo Hold Wt Cap Vol Cap Forward 3,000 145,000 Center 6,000 180,000 Rear 4,000 155,000