Question 1

Figure  
-What is entered as the column input cell in the Solver Table dialogue box?

Accepted Answer

A) B2 
B) B8 
C) F5 
D) F8 
E) It is left blank. 
A) B2 
B) B8 
C) F5 
D) F8 
E) It is left blank. A

Question 2

Changing the objective function coefficients may or may not change the optimal solution,but it will always change the value of the objective function.

Accepted Answer

A) True 
 B)False  False

Question 3

Whenever proportional changes are made to all the unit profits in a problem,the optimal solution will remain the same.

Accepted Answer

A) True 
 B)False  True

Question 4

If the coefficient for Activity 3 in the objective function changes to $30,then the objective function value:

Accepted Answer

A) will increase by $70. 
B) is $0. 
C) will increase by $30. 
D) will remain the same. 
E) will increase by an unknown amount. 
A) will increase by $70. 
B) is $0. 
C) will increase by $30. 
D) will remain the same. 
E) will increase by an unknown amount.

Question 5

A shadow price indicates how much the optimal value of the objective function will increase per unit increase in the right-hand side of a constraint.

Accepted Answer

A) True 
 B)False

Question 6

If the coefficient for Activity 1 in the objective function changes to $40,then the objective function value:

Accepted Answer

A) will increase by $77.80. 
B) will increase by $23. 
C) will increase by $30. 
D) will remain the same. 
E) can only be discovered by resolving the problem. 
A) will increase by $77.80. 
B) will increase by $23. 
C) will increase by $30. 
D) will remain the same. 
E) can only be discovered by resolving the problem.

Question 7

The term "allowable range for the right-hand-side" refers to coefficients of the objective function.

Accepted Answer

A) True 
 B)False

Question 8

If the change to a right-hand side is within the allowable range,the solution will remain the same.

Accepted Answer

A) True 
 B)False

Question 9

A shadow price reflects which of the following in a maximization problem?

Accepted Answer

A) The marginal cost of adding additional resources. 
B) The marginal gain in the objective value realized by adding one unit of a resource. 
C) The marginal loss in the objective value realized by adding one unit of a resource. 
D) The marginal gain in the objective value realized by subtracting one unit of a resource. 
E) None of the above. 
A) The marginal cost of adding additional resources. 
B) The marginal gain in the objective value realized by adding one unit of a resource. 
C) The marginal loss in the objective value realized by adding one unit of a resource. 
D) The marginal gain in the objective value realized by subtracting one unit of a resource. 
E) None of the above.

Question 10

What-if analysis can:

Accepted Answer

A) be done graphically for problems with two decision variables. 
B) reduce a manager's confidence in the model that has been formulated. 
C) increase a manager's confidence in the model that has been formulated. 
D) All of the above. 
E) a.and c.only. 
A) be done graphically for problems with two decision variables. 
B) reduce a manager's confidence in the model that has been formulated. 
C) increase a manager's confidence in the model that has been formulated. 
D) All of the above. 
E) a.and c.only.

Question 11

In a problem with 4 decision variables,the 100% rule indicates that each objective coefficient can be safely increase by what amount without invalidating the current optimal solution?

Accepted Answer

A) 25%. 
B) 25% of the allowable increase of that coefficient. 
C) 100%. 
D) 25% of the range of optimality. 
E) It can't be determined from the information given. 
A) 25%. 
B) 25% of the allowable increase of that coefficient. 
C) 100%. 
D) 25% of the range of optimality. 
E) It can't be determined from the information given.

Question 12

An optimal solution is only optimal with respect to a particular mathematical model that provides only a representation of the actual problem.

Accepted Answer

A) True 
 B)False

Question 13

If the coefficient for Activity 2 in the objective function changes to $400,then the objective function value:

Accepted Answer

A) will increase by $7,500. 
B) will increase by $2,750. 
C) will increase by $100. 
D) will remain the same. 
E) can only be discovered by resolving the problem. 
A) will increase by $7,500. 
B) will increase by $2,750. 
C) will increase by $100. 
D) will remain the same. 
E) can only be discovered by resolving the problem.

Question 14

According to the 100% rule for simultaneous changes in objective function coefficients,if the sum of the percentage changes exceeds 100%,the optimal solution definitely will change.

Accepted Answer

A) True 
 B)False

Question 15

If the coefficient of Activity 2 in the objective function changes to $100,then:

Accepted Answer

A) the original solution remains optimal. 
B) the problem must be resolved to find the optimal solution. 
C) the shadow price is valid. 
D) the shadow price is not valid. 
E) None of the above. 
A) the original solution remains optimal. 
B) the problem must be resolved to find the optimal solution. 
C) the shadow price is valid. 
D) the shadow price is not valid. 
E) None of the above.

Question 16

Solver Table re-solves the problem for a whole range of values of a data cell.

Accepted Answer

A) True 
 B)False

Question 17

Figure  
-What is the formula contained in cell B14?

Accepted Answer

A) = B2 
B) = B8 
C) = C2 
D) = C8 
E) None of the above. 
A) = B2 
B) = B8 
C) = C2 
D) = C8 
E) None of the above.

Question 18

When a change occurs in the right-hand side values of one of the constraints,a proportional change will occur in one of the coefficients of the objective function.

Accepted Answer

A) True 
 B)False

Question 19

Solver Table can only be used to investigate changes in a single data cell at a time.

Accepted Answer

A) True 
 B)False

Question 20

If the right-hand side of Resource C is increased by 40,and the right-hand side of Resource B is decreased by 20,then:

Accepted Answer

A) the optimal solution remains the same. 
B) the optimal solution will change. 
C) the shadow price is valid. 
D) the shadow price may or may not be not valid. 
E) None of the above. 
A) the optimal solution remains the same. 
B) the optimal solution will change. 
C) the shadow price is valid. 
D) the shadow price may or may not be not valid. 
E) None of the above.

Exam 5: What-If Analysis for Linear Programming

Figure -What is entered as the column input cell in the Solver Table dialogue box?

Changing the objective function coefficients may or may not change the optimal solution,but it will always change the value of the objective function.

Whenever proportional changes are made to all the unit profits in a problem,the optimal solution will remain the same.

If the coefficient for Activity 3 in the objective function changes to $30,then the objective function value:

A shadow price indicates how much the optimal value of the objective function will increase per unit increase in the right-hand side of a constraint.

If the coefficient for Activity 1 in the objective function changes to $40,then the objective function value:

The term "allowable range for the right-hand-side" refers to coefficients of the objective function.

If the change to a right-hand side is within the allowable range,the solution will remain the same.

A shadow price reflects which of the following in a maximization problem?

What-if analysis can:

In a problem with 4 decision variables,the 100% rule indicates that each objective coefficient can be safely increase by what amount without invalidating the current optimal solution?

An optimal solution is only optimal with respect to a particular mathematical model that provides only a representation of the actual problem.

If the coefficient for Activity 2 in the objective function changes to $400,then the objective function value:

According to the 100% rule for simultaneous changes in objective function coefficients,if the sum of the percentage changes exceeds 100%,the optimal solution definitely will change.

If the coefficient of Activity 2 in the objective function changes to $100,then:

Solver Table re-solves the problem for a whole range of values of a data cell.

Figure -What is the formula contained in cell B14?

When a change occurs in the right-hand side values of one of the constraints,a proportional change will occur in one of the coefficients of the objective function.

Solver Table can only be used to investigate changes in a single data cell at a time.

If the right-hand side of Resource C is increased by 40,and the right-hand side of Resource B is decreased by 20,then:

Introduction

Linear Programming: Basic Concepts

Linear Programming: Formulation and Applications

The Art of Modeling With Spreadsheets

Network Optimization Problems

Using Binary Integer Programming to Deal With Yes-Or-No Decisions

Nonlinear Programming

Decision Analysis

Cd Supplement - Decision Analysis

Forecasting

Queueing Models

CD Supplement - Additional Queueing Models

Computer Simulation: Basic Concepts

CD Supplement - the Inverse Transformation Method for Generating Random Observations

Computer Simulation With Crystal Ball

CD - Solution Concepts for Linear Programming

CD - Transportation and Assignment Problems

CD - Pertcpm Models for Project Management

CD - Goal Programming

CD - Inventory Management With Known Demand

CD - Inventory Management With Uncertain Demand

Filters