Refer to Figure $1.$ What cell reference designates the Target Cell in "Solver"?

A$)$ E$4$

B$)$ B$3$

C$)C3$

D$)$ D$8$:D$10$

E$)$ E$8$:E$10$

Answer:

Page Ref: $42$

Topic: Setting Up and Solving Linear Programming Problems Using Excel's Solver Difficulty: Easy

The constraint for a given resource is given by the following equation:

$2x1+3x220$

If $x1=5$ and $x2=3,$ how many units of this resource are unused?

A$)20$

B$)19$

C$)1$

D$)0$

E$)17$

Answer:

Page Ref: $49$

Topic: Setting Up and Solving Linear Programming Problems Using Excel's Solver

Difficulty: Easy

The constraint for a given resource is given by the following equation:

$2x1+3x220$

If $x1=5$ and $x2=4$ how many units of this resource are unused?

A$)20$

B$)2$

C$)22$

D$)0$

E$)9$