Question 1

What in Excel Solver corresponds to the decision variables in the algebraic model?

Accepted Answer

A) Optimization Cells 
B) Target Cells 
C) Changing Cells 
D) Decision Cells 
E) Parameter Cells 
A) Optimization Cells 
B) Target Cells 
C) Changing Cells 
D) Decision Cells 
E) Parameter Cells

Question 2

A feasible solution to an optimization problem is a particular combination of decision variables that satisfies some of the constraints.

Accepted Answer

A) True 
 B)False

Question 3

Large-scale optimization software can handle how many decision variables and constraints?

Accepted Answer

A) dozens 
B) hundreds 
C) thousands 
D) millions 
E) all of these answer choices are correct 
A) dozens 
B) hundreds 
C) thousands 
D) millions 
E) all of these answer choices are correct

Question 4

The basic idea for optimization of problems is to find the values of __________ variables that ____________ (minimize)the objective function value,while staying within the _________ .

Accepted Answer

decision,m

Question 5

Sensitivity reports show what will happen if certain problem parameters are changed from their current values.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

What are the steps involved in solving optimization problems?

Accepted Answer

(1)Understand the problem,perhaps by dra

Question 8

Sausage and Cheese Ltd.prepares three gift packages containing sausages and cheeses.The "Tasters," "Succulent," and "Gourmet" gift packages contain 3 sausages and 6 cheeses,5 sausages and 4 cheeses,and 6 sausages and 5 cheeses,respectively.There are 2500 sausages and 3000 cheeses available for packing,and demand is unlimited.Profits are $2.50,$3.50,and $4.00 for the "Tasters," "Succulent," and "Gourmet" gift packages,respectively.The goal is to maximize profits.Let T,S,and G represent the number of gift packages produced of type "Tasters," "Succulent," and "Gourmet," respectively.What is the constraint describing the sausage capacity?

Accepted Answer

A) 2.5T + 3.5S + 4G ≤ 2500 
B) 3T + 5S + 6G ≥ 2500 
C) 9T + 9S + 11G ≤ 2500 
D) 0.8333T + 1.9444S + 2.1818G ≤ 2500 
E) 3T + 5S + 6G ≤ 2500 
A) 2.5T + 3.5S + 4G ≤ 2500 
B) 3T + 5S + 6G ≥ 2500 
C) 9T + 9S + 11G ≤ 2500 
D) 0.8333T + 1.9444S + 2.1818G ≤ 2500 
E) 3T + 5S + 6G ≤ 2500

Question 9

The algebraic formulation of an optimization problem must state what three things?

Accepted Answer

A) decision variables,random variables,and parameters 
B) decision variables,random variables,and constraints 
C) decision variables,random variables,and objective function 
D) random variables,parameters,and objective function 
E) decision variables,objective function,and constraints 
A) decision variables,random variables,and parameters 
B) decision variables,random variables,and constraints 
C) decision variables,random variables,and objective function 
D) random variables,parameters,and objective function 
E) decision variables,objective function,and constraints

Question 10

A constraint in Excel Solver consists of what three pieces of information?

Accepted Answer

A) Target Cell,relationship operator,and Constraint 
B) Target Cell,Changing Cells,and Constraint 
C) Cell Reference,relationship operator,and Constraint 
D) Cell Reference,Changing Cells,and Constraint 
E) Target Cell,Changing Cells,and Cell Reference 
A) Target Cell,relationship operator,and Constraint 
B) Target Cell,Changing Cells,and Constraint 
C) Cell Reference,relationship operator,and Constraint 
D) Cell Reference,Changing Cells,and Constraint 
E) Target Cell,Changing Cells,and Cell Reference

Question 11

When is a Linear Program unbounded?

Accepted Answer

Being unbounded means that the

Question 12

The ________________________ for a constraint is the amount the optimal objective value will change if the right-hand-side of the constraint is increased by one unit.

Accepted Answer

A) Changing Price 
B) Opportunity Cost 
C) Shadow Price 
D) Opportunity Price 
E) Shadow Cost 
A) Changing Price 
B) Opportunity Cost 
C) Shadow Price 
D) Opportunity Price 
E) Shadow Cost

Question 13

George Dantzig developed the Simplex Method in 1947.

Accepted Answer

A) True 
 B)False

Question 14

When formulating optimization problems,which of the following represent the typical sequence?

Accepted Answer

A) (1)text-based formulation,(2)diagram,(3)algebraic formulation 
B) (1)text-based formulation,(2)algebraic formulation,(3)diagram 
C) (1)diagram,(2)algebraic formulation,(3)text-based formulation 
D) (1)diagram,(2)text-based formulation,(3)algebraic formulation 
E) (1)algebraic formulation,(2)diagram,(3)text-based formulation 
A) (1)text-based formulation,(2)diagram,(3)algebraic formulation 
B) (1)text-based formulation,(2)algebraic formulation,(3)diagram 
C) (1)diagram,(2)algebraic formulation,(3)text-based formulation 
D) (1)diagram,(2)text-based formulation,(3)algebraic formulation 
E) (1)algebraic formulation,(2)diagram,(3)text-based formulation

Question 15

One step in solving optimization problems is to write a problem _______________ in words.

Accepted Answer

The answer of One step in solving optimization problems is...

Question 16

The text-based formulation of an optimization problem should state what three things?

Accepted Answer

A) decision variables,random variables,and parameters 
B) decision variables,objective function,and constraints 
C) decision variables,random variables,and constraints 
D) decision variables,random variables,and objective function 
E) random variables,parameters,and objective function 
A) decision variables,random variables,and parameters 
B) decision variables,objective function,and constraints 
C) decision variables,random variables,and constraints 
D) decision variables,random variables,and objective function 
E) random variables,parameters,and objective function

Question 17

A ____________________ contains explicit definitions of the decision variables,an algebraic expression of the objective function,and algebraic statements of the constraints.

Accepted Answer

A) composition 
B) derivation 
C) manipulation 
D) formulation 
E) regurgitation 
A) composition 
B) derivation 
C) manipulation 
D) formulation 
E) regurgitation

Question 18

If all constraints are not fully consumed,the final result is not an optimal solution.

Accepted Answer

A) True 
 B)False

Question 19

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.

Accepted Answer

A) Complex Method 
B) Multiplex Method 
C) Simplex Method 
D) Superplex Method 
E) Perplex Method 
A) Complex Method 
B) Multiplex Method 
C) Simplex Method 
D) Superplex Method 
E) Perplex Method

Question 20

Explain what differentiates a Linear Program from a Nonlinear Program.

Accepted Answer

All of the relationships among the decis

What in Excel Solver corresponds to the decision variables in the algebraic model?

A feasible solution to an optimization problem is a particular combination of decision variables that satisfies some of the constraints.

Large-scale optimization software can handle how many decision variables and constraints?

The basic idea for optimization of problems is to find the values of __ variables that (minimize)the objective function value,while staying within the _ .

Sensitivity reports show what will happen if certain problem parameters are changed from their current values.

Which Excel tool provides solutions to Linear Programs?

What are the steps involved in solving optimization problems?

The algebraic formulation of an optimization problem must state what three things?

A constraint in Excel Solver consists of what three pieces of information?

When is a Linear Program unbounded?

The ________________________ for a constraint is the amount the optimal objective value will change if the right-hand-side of the constraint is increased by one unit.

George Dantzig developed the Simplex Method in 1947.

When formulating optimization problems,which of the following represent the typical sequence?

One step in solving optimization problems is to write a problem _______________ in words.

The text-based formulation of an optimization problem should state what three things?

A ____________________ contains explicit definitions of the decision variables,an algebraic expression of the objective function,and algebraic statements of the constraints.

If all constraints are not fully consumed,the final result is not an optimal solution.

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.

Explain what differentiates a Linear Program from a Nonlinear Program.

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

What in Excel Solver corresponds to the decision variables in the algebraic model?

A feasible solution to an optimization problem is a particular combination of decision variables that satisfies some of the constraints.

Large-scale optimization software can handle how many decision variables and constraints?

The basic idea for optimization of problems is to find the values of __________ variables that ____________ (minimize)the objective function value,while staying within the _________ .

Sensitivity reports show what will happen if certain problem parameters are changed from their current values.

Which Excel tool provides solutions to Linear Programs?

What are the steps involved in solving optimization problems?

The algebraic formulation of an optimization problem must state what three things?

A constraint in Excel Solver consists of what three pieces of information?

When is a Linear Program unbounded?

The ________________________ for a constraint is the amount the optimal objective value will change if the right-hand-side of the constraint is increased by one unit.

George Dantzig developed the Simplex Method in 1947.

When formulating optimization problems,which of the following represent the typical sequence?

One step in solving optimization problems is to write a problem _______________ in words.

The text-based formulation of an optimization problem should state what three things?

A ____________________ contains explicit definitions of the decision variables,an algebraic expression of the objective function,and algebraic statements of the constraints.

If all constraints are not fully consumed,the final result is not an optimal solution.

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.

Explain what differentiates a Linear Program from a Nonlinear Program.

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

The basic idea for optimization of problems is to find the values of __ variables that (minimize)the objective function value,while staying within the _ .