Question 1

With Excel Solver, the Target Cell can contain either a formula or a value.

Accepted Answer

A) True 
 B)False

Question 2

In Excel Solver, the Target Cell corresponds to the objective function in the algebraic model.

Accepted Answer

A) True 
 B)False

Question 3

Testing of the LP model should include __________ and _____________.

Accepted Answer

A) extreme case, base case 
B) extreme case, test values 
C) base case, minimum value 
D) base case, test values 
E) test value, maximum value 
A) extreme case, base case 
B) extreme case, test values 
C) base case, minimum value 
D) base case, test values 
E) test value, maximum value

Question 4

Once you've written the algebraic formulation of the problem, the next setup involved in Solving Optimization Problems is:

Accepted Answer

A) develop test cases 
B) examine the results and make corrections 
C) analyze and interpret the results 
D) set up the Solver settings 
E) write the problem formulation 
A) develop test cases 
B) examine the results and make corrections 
C) analyze and interpret the results 
D) set up the Solver settings 
E) write the problem formulation

Question 5

George Dantzig developed the Simplex Method in 1947.

Accepted Answer

A) True 
 B)False

Question 6

Constraints at their limits at the optimal solution of a Linear Program, that is, with the left-hand-side value equal to the right-hand-side value, are called _________________________.

Accepted Answer

A) equality constraints 
B) non-binding constraints 
C) binding constraints 
D) limiting constraints 
E) synergistic constraints 
A) equality constraints 
B) non-binding constraints 
C) binding constraints 
D) limiting constraints 
E) synergistic constraints

Question 7

_________ are limitations or requirements that must be satisfied.

Accepted Answer

The answer of _________ are limitations or requirements that must...

Question 8

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

Accepted Answer

A) objective model 
B) constrained model 
C) constrained optimization problem 
D) decision model 
E) excel model 
A) objective model 
B) constrained model 
C) constrained optimization problem 
D) decision model 
E) excel model

Question 9

After running a Linear Program in Excel Solver, what message do you hope to see in the "Solver Results" box?

Accepted Answer

"Solver found a solu

Question 10

Three reports are available when Solver has successfully found an optimal solution. These are _______.

Accepted Answer

A) Answer Report, Sensitivity Report, and Limits Report 
B) Answer Report, Sensitivity Report, and Constraints Report 
C) Answer Report, Limits Report, and Constraints Report 
D) Solution Report, Sensitivity Report, and Limits Report 
E) Solution Report, Sensitivity Report, and Constraints Report 
A) Answer Report, Sensitivity Report, and Limits Report 
B) Answer Report, Sensitivity Report, and Constraints Report 
C) Answer Report, Limits Report, and Constraints Report 
D) Solution Report, Sensitivity Report, and Limits Report 
E) Solution Report, Sensitivity Report, and Constraints Report

Question 11

Consider the following two functions: 
g(x, y)=4x - 3y + 21
H(x, y)= 13xy
Which of the following is true regarding the linearity of the functions?

Accepted Answer

A) neither of the functions is linear 
B) both functions are linear 
C) g(x, y)is linear, but h(x, y)is not linear 
D) h(x, y)is linear, but g(x, y)is not linear 
E) h(x, y)is not linear, and g(x, y)is only linear when y ? 0 
A) neither of the functions is linear 
B) both functions are linear 
C) g(x, y)is linear, but h(x, y)is not linear 
D) h(x, y)is linear, but g(x, y)is not linear 
E) h(x, y)is not linear, and g(x, y)is only linear when y ? 0

Question 12

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

Accepted Answer

The answer of A specific combination of values of the...

Question 13

Which Excel tool provides solutions to Linear Programs?

Accepted Answer

A) Solver 
B) Answer 
C) Simplexer 
D) Computer 
E) Goal Seek 
A) Solver 
B) Answer 
C) Simplexer 
D) Computer 
E) Goal Seek

With Excel Solver, the Target Cell can contain either a formula or a value.

In Excel Solver, the Target Cell corresponds to the objective function in the algebraic model.

Testing of the LP model should include and ___.

Once you've written the algebraic formulation of the problem, the next setup involved in Solving Optimization Problems is:

George Dantzig developed the Simplex Method in 1947.

Constraints at their limits at the optimal solution of a Linear Program, that is, with the left-hand-side value equal to the right-hand-side value, are called _________________________.

_________ are limitations or requirements that must be satisfied.

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

After running a Linear Program in Excel Solver, what message do you hope to see in the "Solver Results" box?

Three reports are available when Solver has successfully found an optimal solution. These are _______.

Consider the following two functions: g(x, y)=4x - 3y + 21 H(x, y)= 13xy Which of the following is true regarding the linearity of the functions?

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

Which Excel tool provides solutions to Linear Programs?

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Exam 17: Spreadsheet Modeling: an Introduction

With Excel Solver, the Target Cell can contain either a formula or a value.

In Excel Solver, the Target Cell corresponds to the objective function in the algebraic model.

Testing of the LP model should include __________ and _____________.

Once you've written the algebraic formulation of the problem, the next setup involved in Solving Optimization Problems is:

George Dantzig developed the Simplex Method in 1947.

Constraints at their limits at the optimal solution of a Linear Program, that is, with the left-hand-side value equal to the right-hand-side value, are called _________________________.

_________ are limitations or requirements that must be satisfied.

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

After running a Linear Program in Excel Solver, what message do you hope to see in the "Solver Results" box?

Three reports are available when Solver has successfully found an optimal solution. These are _______.

Consider the following two functions: g(x, y)=4x - 3y + 21 H(x, y)= 13xy Which of the following is true regarding the linearity of the functions?

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

Which Excel tool provides solutions to Linear Programs?

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Testing of the LP model should include and ___.