Question: 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 freight destined for Ghana. An agricultural commodities dealer wants to transport the following products abroad this ship.

Paul can elect to load any and/or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions:

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 \%$ and $60 \%$ of the total weight on board.

1. Formulate and LP model for this problem.
2. Create a spreadsheet model for this problem, and solve it using Solver.
3. What is the optimal solution?

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document