Question 1

Consider the following three functions:
F(x) = 6x2
G(x, y) =4x - 3y + 19
H(x, y) = 3xy
Which of the following is true regarding the linearity of the functions?

Accepted Answer

A)  none of the functions is linear 
B)  all three functions are linear 
C)  g(x, y) is linear, but f(x) and h(x, y) are not linear 
D)  g(x, y) and h(x, y) are linear, but f(x) is not linear 
E)  h(x, y) is linear, but f(x) and g(x, y) are not linear 
A)  none of the functions is linear 
B)  all three functions are linear 
C)  g(x, y) is linear, but f(x) and h(x, y) are not linear 
D)  g(x, y) and h(x, y) are linear, but f(x) is not linear 
E)  h(x, y) is linear, but f(x) and g(x, y) are not linear C

Question 2

How can the following Linear Program be characterized?
Min X + 2Y
Subject to
X ≤ 20
X, Y ≥ -40

Accepted Answer

A)  bounded and feasible 
B)  unbounded and feasible 
C)  bounded and infeasible 
D)  unbounded and infeasible 
E)  this is not a Linear Program 
A)  bounded and feasible 
B)  unbounded and feasible 
C)  bounded and infeasible 
D)  unbounded and infeasible 
E)  this is not a Linear Program B

Question 3

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 C

Question 4

When was the Simplex Method developed?

Accepted Answer

A)  1927 
B)  1937 
C)  1947 
D)  1957 
E)  1967 
A)  1927 
B)  1937 
C)  1947 
D)  1957 
E)  1967

Question 5

The constraints in an optimization model must all be of one type, for example, all ≤, all ≥, or all =.

Accepted Answer

A) True 
 B)False

Question 6

In the "Solver Parameters" box of Excel Solver, what is clicked to actually solve the problem?

Accepted Answer

A)  "GO" 
B)  "OK" 
C)  "SOLVE" 
D)  "CLOSE" 
E)  "START" 
A)  "GO" 
B)  "OK" 
C)  "SOLVE" 
D)  "CLOSE" 
E)  "START"

Question 7

Excel's Solver Add-In solves _____________ problems.

Accepted Answer

The answer of Excel's Solver Add-In solves _____________ problems....

Question 8

The two primary Excel tools for diagnosing problems in models are ___________________.

Accepted Answer

A)  Error Auditing and Formula Checking 
B)  Error Auditing and Formula Auditing 
C)  Error Checking and Formula Auditing 
D)  Error Checking and Formula Checking 
E)  Error Diagnosing and Formula Debugging 
A)  Error Auditing and Formula Checking 
B)  Error Auditing and Formula Auditing 
C)  Error Checking and Formula Auditing 
D)  Error Checking and Formula Checking 
E)  Error Diagnosing and Formula Debugging

Question 9

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 10

What is the optimal solution to the following linear program?
Max 2X + Y
Subject to
2X + 2Y ≥ 40
X + Y ≤ 10
X ≥ 0
Y ≥ 0

Accepted Answer

A)  the solution is unbounded 
B)  (0, 20) 
C)  (10, 0) 
D)  (20, 0) 
E)  the program is infeasible 
A)  the solution is unbounded 
B)  (0, 20) 
C)  (10, 0) 
D)  (20, 0) 
E)  the program is infeasible

Question 11

Riker Co. is considering which of four different projects to undertake in order to maximize its net present value (NPV). Define Xi as a binary (0-1) variable that equals 1 if project i is undertaken and 0 otherwise, for i = 1,2,3,4. The NPV and required capital (in millions) for each project are listed below.
Project Net Present Value Capital Required
1 60 7
2 50 10
3 40 6
4 20 3
Which of the following represents the constraint(s) stating that project 1 must be undertaken and at least one of the other projects must be undertaken?

Accepted Answer

A)  X1 + X2 ≤ 1, and X1 + X3 ≤ 1, and X1 + X4 ≤ 1 
B)  X1 ≥ 1, and X2 + X3 + X4 ≥ 1 
C)  X1 + X2 ≥ 1, and X1 + X3 ≥ 1, and X1 + X4 ≥ 1 
D)  X1 ≥ 1, and X2 + X3 + X4 ≤ 3 
E)  X1 + X2 + X3 + X4 ≥ 2 
A)  X1 + X2 ≤ 1, and X1 + X3 ≤ 1, and X1 + X4 ≤ 1 
B)  X1 ≥ 1, and X2 + X3 + X4 ≥ 1 
C)  X1 + X2 ≥ 1, and X1 + X3 ≥ 1, and X1 + X4 ≥ 1 
D)  X1 ≥ 1, and X2 + X3 + X4 ≤ 3 
E)  X1 + X2 + X3 + X4 ≥ 2

Question 12

Describe what steps one should use if the Solver Results box says, "The conditions for Assume Linear Model are not satisfied"?

Accepted Answer

You should verify that the pro

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

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 17

In Linear Programming models, over what quantities do you have control?

Accepted Answer

A)  decision variables 
B)  parameters 
C)  constraints 
D)  objective variables 
E)  coefficients 
A)  decision variables 
B)  parameters 
C)  constraints 
D)  objective variables 
E)  coefficients

Question 18

Solver's Changing Cells corresponds to the ________ in the algebraic model.

Accepted Answer

The answer of Solver's Changing Cells corresponds to the ________...

Question 19

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

Question 20

Define feasible solution, infeasible solution, and optimal solution.

Accepted Answer

A feasible solution is a particular comb

Consider the following three functions: F(x) = 6x² G(x, y) =4x - 3y + 19 H(x, y) = 3xy Which of the following is true regarding the linearity of the functions?

How can the following Linear Program be characterized? Min X + 2Y Subject to X ≤ 20 X, Y ≥ -40

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

When was the Simplex Method developed?

The constraints in an optimization model must all be of one type, for example, all ≤, all ≥, or all =.

In the "Solver Parameters" box of Excel Solver, what is clicked to actually solve the problem?

Excel's Solver Add-In solves _____________ problems.

The two primary Excel tools for diagnosing problems in models are ___________________.

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

What is the optimal solution to the following linear program? Max 2X + Y Subject to 2X + 2Y ≥ 40 X + Y ≤ 10 X ≥ 0 Y ≥ 0

Describe what steps one should use if the Solver Results box says, "The conditions for Assume Linear Model are not satisfied"?

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

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 ___________________ in 1947 to solve Linear Programs.

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

In Linear Programming models, over what quantities do you have control?

Solver's Changing Cells corresponds to the ________ in the algebraic model.

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.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

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

Consider the following three functions: F(x) = 6x2 G(x, y) =4x - 3y + 19 H(x, y) = 3xy Which of the following is true regarding the linearity of the functions?

How can the following Linear Program be characterized? Min X + 2Y Subject to X ≤ 20 X, Y ≥ -40

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

When was the Simplex Method developed?

The constraints in an optimization model must all be of one type, for example, all ≤, all ≥, or all =.

In the "Solver Parameters" box of Excel Solver, what is clicked to actually solve the problem?

Excel's Solver Add-In solves _____________ problems.

The two primary Excel tools for diagnosing problems in models are ___________________.

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

What is the optimal solution to the following linear program? Max 2X + Y Subject to 2X + 2Y ≥ 40 X + Y ≤ 10 X ≥ 0 Y ≥ 0

Describe what steps one should use if the Solver Results box says, "The conditions for Assume Linear Model are not satisfied"?

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

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 ___________________ in 1947 to solve Linear Programs.

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

In Linear Programming models, over what quantities do you have control?

Solver's Changing Cells corresponds to the ________ in the algebraic model.

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.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

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

Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: An Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Consider the following three functions: F(x) = 6x² G(x, y) =4x - 3y + 19 H(x, y) = 3xy Which of the following is true regarding the linearity of the functions?