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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started