Q$3$: Chapter $6,$ Problem $30(7$th edition$)$Please download the Excel file for your work and submit your Excel file.Paul Bergey is in charge of loading cargo ships in International Cargo Company $($ICC$)$ at the portof Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined forGhana. And agricultural commodities dealer would like to transport the following products aboardthis ship.Commodity Amount Available$($Tons$)$Volume per Ton$($Cubic feet$)$Profit per Ton$($$$)14,800407022,500255031,200606041,7005580$Paul can elect to load any and$/$or all of the available commodities. However, the ship has threecargo holds with the following capacity restrictions:Cargo Hold Weight Capacity$($Tons$)$Volume Capacity$($Cubic Feet$)$Forward $3,000145,000$Center $6,000180,000$Rear $4,000155,000$Only one type of commodity can be placed into any cargo hold. However, because of balanceconsiderations, the weight in the forward cargo hold must be within $10\%$ of the weight in the rearcargo hold, and the center cargo hold must be between $40\%$ and $60\%$ of the total weight on board.a$.$ Formulate an ILP model for this problem.b$.$ Implement your model in Excel and solve it$.$c$.$ What is the optimal solution?