The person in charge of a freighter is working on a loading plan for shipment of four
Fantastic news! We've Found the answer you've been seeking!
Question:
The person in charge of a freighter is working on a loading plan for shipment of four commodities. The amount available (in tons), volume per ton (cubic feet), and profit per ton for the four commodities are provided in the data file. He can elect to load any of the available commodities. However, the freighter has three cargo holds with the following capacity restrictions:
Commodity | |||||||
1 | 2 | 3 | 4 | Max Weight | Max Volume | ||
Available | 4800 | 2500 | 1200 | 1700 | 3000 | 145000 | |
Volume / ton | 40 | 25 | 60 | 55 | 6000 | 180000 | |
Profit / ton | $70.0 | $50.0 | $60.0 | $80.0 | 4000 | 155000 | |
Also, only one type of commodity can be placed into any cargo hold. He is trying to find a loading plan that maximizes the profit for this shipment.
Solve the problem in Excel and report the optimal objective value here.
Related Book For
Organizational behavior
ISBN: 9780077379438
5th edition
Authors: Steven L. McShane, Mary Ann Von Glinow
Posted Date: