Maximum Profit=(B*.35)+(G*.12)
Subject to:
(B*.20)+(G*.40)<=70,000 (total cubic feet)
(B*1)+(G*1)<=160,000 (total weight)
B <= 85,000 (lb)
G <= 100,000 (lb)
After entering all this data in the spreadsheet and using the solver add-in I found that the ship owner can accept 85,000 (or all) pounds of beef and 75,000 pounds of grain in order to maximize his profit. He was successful in maximizing the weight of the ship so that 0 slack was left. However, this left more room in the ship. If the weight limit could have been increased he could have maximized profits even more. Nonetheless, his total profits are $38,750 for hauling the beef and grain.
http://spreadsheets.google.com/pub?key=poFqwfTkDdIdpa4QUWepdGw
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment