Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a
Question:
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:
You can elect to load any 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 percent of the weight in the rear cargo hold, and the center cargo hold must be between 40 percent and 60 percent of the total weight on board.
a. Determine a profit-maximizing loading plan for the commodities. What is the maximum profit and the loading plan that achieves it?
b. Suppose each one of the cargo holds could be expanded.
Which holds and which forms of expansion (weight or volume) would allow ICC to increase its profits on this trip, and what is the marginal value of each form of expansion?
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker