Chapter 9 - Solver

Question 1

What determines the optimal set of decision inputs to meet an objective?

Answer 1

The solver

Question 2

What is an excellent tool for determining the best way to apply resources to a particular problem?

Answer 2

The solver

Question 3

Is the solver more powerful than the goal seek?

Answer 3

Yes

Question 4

What is an analytical method that narrows available options so you can choose the best potential outcome?

Answer 4

Optimization

Question 5

List the 3 things that you should consider before using optimization

Answer 5

1. How many resources are there and how many are needed
2. How many resources does each decision variable consume
3. How much does each decision variable contribute to the objective

Question 6

True or False:

The goal seek doesn’t make calculation automatically

Answer 6

False

Question 7

What lets you specify the desired value in a cell and the cell that should be changed to reach that goal?

Answer 7

The goal seek

Question 8

What is goal seek limited to?

Answer 8

One input and one output

Question 9

True or False:

Goal seek finds single answers easily

Answer 9

True

Question 10

Whatis an optimization technique for a system oflinearconstraints and alinearobjective function?

Answer 10

Linear programming

Question 11

What defines the quantity to be optimized?

Answer 11

An objective function

Question 12

Fill in the Blank:

The goal of linear programming is to find ____________ that maximize or minimize the objective function

Answer 12

The values of the variables

Question 13

What is the cell that you want to maximize, minimize, or set to a specific value?

Answer 13

The objective cell

Question 14

What produces the desired results in the target cell?

Answer 14

Variable cells

Question 15

What limits how to solve the problem?

Answer 15

Constraints