Excel Solver using binary. How can I use binary to solve this question on excel? What are
Fantastic news! We've Found the answer you've been seeking!
Question:
Excel Solver using binary. How can I use binary to solve this question on excel? What are the step and what should i put in my solver?
The following problem is adapted from 6-20 in the Balakrishnan, Render, and Stair textbook.
A truck with the capacity to load 2,200 cubic feet of cargo is available to transport items selected from the following table.
Item | Value | Volume (cu. ft.) |
A | $1,800 | 700 |
B | $1,400 | 600 |
C | $1,100 | 450 |
D | $900 | 400 |
E | $1,600 | 650 |
F | $1,100 | 350 |
G | $1,200 | 600 |
If selected, an item must be shipped in its entirety (i.e., partial shipments are not allowed). There is only one of each item (multiples not allowed). Of items B, C, and D, at least two items must be selected. If item B is selected, then item G cannot be selected.
- Which items should be selected to maximize the value of the shipment? What is the maximal value? (NOTE: You must find these answers using the "Simplex LP" solver setting.)
Related Book For
Posted Date: