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

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.

  1. 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.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!