Using Excel Solver to Maximize Profit for a Cargo Ship
Not what you're looking for?
The load master for a freighter wants to determine the mix of cargo to be carried on the next trip.
The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to select and wishes to maximize the value of the selected shipment. However, to make sure that none of his customers are ignored, the load master would like to make sure that at least 20% of each cargo's available weight is selected. The specifications for the five cargos are shown in the following table.
Cargo TONS VALUE VOLUME
Type AVAIL. PER TON PER TON (CU. M)
A 970 $1,350 26
B 850 $1,675 54
C 1,900 $1,145 28
D 2,300 $850 45
E 3,600 $1,340 37
Purchase this Solution
Solution Summary
This solution uses excel solver to maximize profit for a cargo ship with step-by-step workings and all formulas used are included in an excel spreadsheet.
Education
- MBA, Merage School of Business, Univ of Cal, Irvine
- BA, Univ of Cal, Irvine
Recent Feedback
- "Thank you so much for your help, it was very helpful to see how you did it in excel. Thanks again!"
- "Awesome review. Thank you!!!!!"
- "Wow - Amazing - Thanks"
- "Thanks"
- "Thanks for your help. Your solution helps me understand the problem and its solution."
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Probability Quiz
Some questions on probability
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts