Question 1

To retain model flexibility while using Solver you must:

Accepted Answer

A) use appropriate color codes 
B) enter specific values 
C) ensure the inputs and outputs are separated 
D) use only cell references 
E) use Slack 
A) use appropriate color codes 
B) enter specific values 
C) ensure the inputs and outputs are separated 
D) use only cell references 
E) use Slack D

Question 2

In the "Solver Options" box of Excel Solver,what should be checked to ensure that all decision variables are ≥ 0?

Accepted Answer

A) Assume Linear Model 
B) Use Automatic Scaling 
C) Assume Positive 
D) Assume Non-Negative 
E) Assume Nonzero 
A) Assume Linear Model 
B) Use Automatic Scaling 
C) Assume Positive 
D) Assume Non-Negative 
E) Assume Nonzero D

Question 3

Define feasible solution,infeasible solution,and optimal solution.

Accepted Answer

A feasible solution is a particular combination of decision variables that satisfies all of the constraints.An infeasible solution violates at least one of the constraints.The optimal solution is the feasible solution with the largest (for a "max" problem)or smallest (for a "min" function)objective function value.

Question 4

What are the four steps to setting up an optimization problem with Excel Solver?

Accepted Answer

(1)Specify the Target Cell (corresponds

Question 5

In Linear Programming (LP)problems,all of the relationships among the variables are linear.

Accepted Answer

A) True 
 B)False

Question 6

Formulate the following as a linear programming problem.
The Ski Company makes skis and snowboards.They are currently planning their operations for October-December,and have just an exclusive signed contracts to sell up to 4,000 pairs of skis and as many snowboards as they can make,to a company that owns several sporting goods stores.The profit that Ski will make is $53 for each pair of skis and $67 for each snowboard.Every pair of skis will require 7 hours from Department A and 12 hours from Department B.Every snowboard will require 5 hours from Department A and 19 hours from Department B.The total hours planned for October-December is 44,535 hours in Department A and 93,217 hours in Department B.

Accepted Answer

Let x1 = number of pairs of sk

Question 7

Not-equals-to constraints (≠)are allowable in optimization problems.

Accepted Answer

A) True 
 B)False

Question 8

At the optimal solution of a Linear Program,the difference between the right-hand-side value and the left-hand-side value of a constraint is the ____________________.

Accepted Answer

A) shadow 
B) difference 
C) shortfall 
D) slack 
E) cushion 
A) shadow 
B) difference 
C) shortfall 
D) slack 
E) cushion

Question 9

All mathematical programs should include non-negativity constraints.

Accepted Answer

A) True 
 B)False

Question 10

Which type of constraint does not allow the solution for a decision variable of an optimization problem to be less than zero?

Accepted Answer

A) negativity 
B) positivity 
C) anti-negativity 
D) feasibility 
E) non-negativity 
A) negativity 
B) positivity 
C) anti-negativity 
D) feasibility 
E) non-negativity

Question 11

With Excel Solver,the range for the Changing Cells box must be entered with absolute references ($ signs).

Accepted Answer

A) True 
 B)False

Question 12

The process of thinking about a problem in a structured way often leads to ________ to making a better decision.

Accepted Answer

The answer of The process of thinking about a problem...

Question 13

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 14

_________ are limitations or requirements that must be satisfied.

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A diagram of the situation can help _______ the problem as well as be a(n)______ _______ tool.

Accepted Answer

A) structure,valuable communication 
B) define,algebraic development 
C) bound,formulation development 
D) unbound,formulation development 
E) structure,unbounded formulation 
A) structure,valuable communication 
B) define,algebraic development 
C) bound,formulation development 
D) unbound,formulation development 
E) structure,unbounded formulation

Question 17

What does LP stand for?

Accepted Answer

A) Linear Partition 
B) Linear Program 
C) Large-Scale Program 
D) Linear Parameter 
E) Linear Parallelism 
A) Linear Partition 
B) Linear Program 
C) Large-Scale Program 
D) Linear Parameter 
E) Linear Parallelism

Question 18

The advantage of formal optimization modeling is that it can simultaneously consider the effects of alternate decisions to produce the best overall decision according to the objective.

Accepted Answer

A) True 
 B)False

Question 19

It is good practice to ____________ the units and the __________ represented by objective function.

Accepted Answer

The answer of It is good practice to ____________ the...

Question 20

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

To retain model flexibility while using Solver you must:

In the "Solver Options" box of Excel Solver,what should be checked to ensure that all decision variables are ≥ 0?

Define feasible solution,infeasible solution,and optimal solution.

What are the four steps to setting up an optimization problem with Excel Solver?

In Linear Programming (LP)problems,all of the relationships among the variables are linear.

Not-equals-to constraints (≠)are allowable in optimization problems.

At the optimal solution of a Linear Program,the difference between the right-hand-side value and the left-hand-side value of a constraint is the ____________________.

All mathematical programs should include non-negativity constraints.

Which type of constraint does not allow the solution for a decision variable of an optimization problem to be less than zero?

With Excel Solver,the range for the Changing Cells box must be entered with absolute references ($ signs).

The process of thinking about a problem in a structured way often leads to ________ to making a better decision.

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

_________ are limitations or requirements that must be satisfied.

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

A diagram of the situation can help _ the problem as well as be a(n) ___ tool.

What does LP stand for?

The advantage of formal optimization modeling is that it can simultaneously consider the effects of alternate decisions to produce the best overall decision according to the objective.

It is good practice to __ the units and the represented by objective function.

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 _________________________.

Introduction to Operations

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 18: Introduction to Optimization

To retain model flexibility while using Solver you must:

In the "Solver Options" box of Excel Solver,what should be checked to ensure that all decision variables are ≥ 0?

Define feasible solution,infeasible solution,and optimal solution.

What are the four steps to setting up an optimization problem with Excel Solver?

In Linear Programming (LP)problems,all of the relationships among the variables are linear.

Not-equals-to constraints (≠)are allowable in optimization problems.

At the optimal solution of a Linear Program,the difference between the right-hand-side value and the left-hand-side value of a constraint is the ____________________.

All mathematical programs should include non-negativity constraints.

Which type of constraint does not allow the solution for a decision variable of an optimization problem to be less than zero?

With Excel Solver,the range for the Changing Cells box must be entered with absolute references ($ signs).

The process of thinking about a problem in a structured way often leads to ________ to making a better decision.

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

_________ are limitations or requirements that must be satisfied.

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

A diagram of the situation can help _______ the problem as well as be a(n)______ _______ tool.

What does LP stand for?

The advantage of formal optimization modeling is that it can simultaneously consider the effects of alternate decisions to produce the best overall decision according to the objective.

It is good practice to ____________ the units and the __________ represented by objective function.

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 _________________________.

Introduction to Operations

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

A diagram of the situation can help _ the problem as well as be a(n) ___ tool.

It is good practice to __ the units and the represented by objective function.