Question 1

Figure  
-Which cells in the following spreadsheet must be selected before choosing Solver Table from the Tools menu?

Accepted Answer

A) A15:D19 
B) A14:D19 
C) A12:D19 
D) B2 
E) B8:C8 and F8 
A) A15:D19 
B) A14:D19 
C) A12:D19 
D) B2 
E) B8:C8 and F8

Question 2

Figure  
-What is the allowable range for changes in the right-hand-side for Resource C?

Accepted Answer

A) 18 $\le$ RHSc $\le$ $\infty$. 
B) $\infty$ $\le$ RHSc $\le$ 62. 
C) -2 $\le$ RHSc $\le$ $\infty$. 
D) -$\infty$ $\le$ RHSc $\le$ 40. 
E) 0 $\le$ RHSc $\le$ 22. 
A) 18 $\le$ RHSc $\le$ $\infty$. 
B) $\infty$ $\le$ RHSc $\le$ 62. 
C) -2 $\le$ RHSc $\le$ $\infty$. 
D) -$\infty$ $\le$ RHSc $\le$ 40. 
E) 0 $\le$ RHSc $\le$ 22.

Question 3

Which of the following are benefits of what-if analysis?

Accepted Answer

A) It pinpoints the sensitive parameters of the model. 
B) It gives the new optimal solution if conditions change. 
C) It tells management what policy decisions to make. 
D) All of the above. 
E) None of the above. 
A) It pinpoints the sensitive parameters of the model. 
B) It gives the new optimal solution if conditions change. 
C) It tells management what policy decisions to make. 
D) All of the above. 
E) None of the above.

Question 4

Figure  
-What is the allowable range for changes in the objective coefficient for Activity 2?

Accepted Answer

A) -10 $\le$ A2 $\le$ 50. 
B) -44 $\le$ A2 $\le$ 16. 
C) -4 $\le$ A2 $\le$ 56. 
D) 30 $\le$ A2 $\le$ 90. 
E) 20 $\le$ A2 $\le$ 80. 
A) -10 $\le$ A2 $\le$ 50. 
B) -44 $\le$ A2 $\le$ 16. 
C) -4 $\le$ A2 $\le$ 56. 
D) 30 $\le$ A2 $\le$ 90. 
E) 20 $\le$ A2 $\le$ 80.

Question 5

Figure  
-What is the allowable range for the objective function coefficient for Activity 3?

Accepted Answer

A) 150 $\le$ A3 $\le$ $\infty$. 
B) 0 $\le$ A3 $\le$ 650. 
C) 0 $\le$ A3 $\le$ 250. 
D) 400 $\le$ A3 $\le$ $\infty$. 
E) 300 $\le$ A3 $\le$ 500. 
A) 150 $\le$ A3 $\le$ $\infty$. 
B) 0 $\le$ A3 $\le$ 650. 
C) 0 $\le$ A3 $\le$ 250. 
D) 400 $\le$ A3 $\le$ $\infty$. 
E) 300 $\le$ A3 $\le$ 500.

Question 6

The allowable range gives ranges of values for the objective function coefficients within which the values of the decision variables are optimal.

Accepted Answer

A) True 
 B)False

Question 7

Solver Table can be used to easily investigate the changes in any number of data cells.
Multiple Choice Questions

Accepted Answer

A) True 
 B)False

Question 8

If the right-hand side of Resource C changes to 130,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 9

If the right-hand side of Resource A changes to 10,then the objective function value:

Accepted Answer

A) will decrease by $12.50. 
B) will decrease by $125. 
C) will decrease by $77.80. 
D) will remain the same. 
E) can only be discovered by resolving the problem. 
A) will decrease by $12.50. 
B) will decrease by $125. 
C) will decrease by $77.80. 
D) will remain the same. 
E) can only be discovered by resolving the problem.

Question 10

When even a small change in the value of a coefficient in the objective function can change the optimal solution,the coefficient is called:

Accepted Answer

A) optimal. 
B) sensitive. 
C) out of the range. 
D) within the range. 
E) None of the above. 
A) optimal. 
B) sensitive. 
C) out of the range. 
D) within the range. 
E) None of the above.

Question 11

If the optimal solution will remain the same over a wide range of values for a particular coefficient in the objective function,then management will want to take special care to narrow this estimate down.

Accepted Answer

A) True 
 B)False

Question 12

It is usually quite easy to find the needed data for a linear programming study.

Accepted Answer

A) True 
 B)False

Question 13

Figure  
-What is the optimal objective function value for this problem?

Accepted Answer

A) It cannot be determined from the given information. 
B) $7.78. 
C) $240. 
D) $90. 
E) $330. 
A) It cannot be determined from the given information. 
B) $7.78. 
C) $240. 
D) $90. 
E) $330.

Question 14

In linear programming,what-if analysis is associated with determining the effect of changing: I.objective function coefficients.
II)right-hand side values of constraints.
III)decision variable values.

Accepted Answer

A) I and II 
B) II and III 
C) I,II,and III 
D) I and III 
E) None of the above. 
A) I and II 
B) II and III 
C) I,II,and III 
D) I and III 
E) None of the above.

Question 15

What-if analysis:

Accepted Answer

A) may involve changes in the objective function coefficients. 
B) requires that only one parameter change while the rest are held fixed. 
C) may involve changes in the right-hand side values. 
D) All of the above. 
E) None of the above. 
A) may involve changes in the objective function coefficients. 
B) requires that only one parameter change while the rest are held fixed. 
C) may involve changes in the right-hand side values. 
D) All of the above. 
E) None of the above.

Question 16

When certain parameters of a model represent managerial policy decisions,what-if analysis provides information about what the impact would be of altering these policy decisions.

Accepted Answer

A) True 
 B)False

Question 17

Shadow price analysis is widely used to help management find the best trade-off between costs and benefits for a problem.

Accepted Answer

A) True 
 B)False

Question 18

If the coefficient of Activity 1 in the objective function changes to $10,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 19

If the right-hand side of Resource B changes to 10,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 20

If the right-hand side of Resource B changes to 80,then the objective function value:

Accepted Answer

A) will decrease by $75. 
B) will decrease by $150. 
C) will decrease by $225. 
D) will remain the same. 
E) can only be discovered by resolving the problem. 
A) will decrease by $75. 
B) will decrease by $150. 
C) will decrease by $225. 
D) will remain the same. 
E) can only be discovered by resolving the problem.

Exam 5: What-If Analysis for Linear Programming

Figure -Which cells in the following spreadsheet must be selected before choosing Solver Table from the Tools menu?

Figure -What is the allowable range for changes in the right-hand-side for Resource C?

Which of the following are benefits of what-if analysis?

Figure -What is the allowable range for changes in the objective coefficient for Activity 2?

Figure -What is the allowable range for the objective function coefficient for Activity 3?

The allowable range gives ranges of values for the objective function coefficients within which the values of the decision variables are optimal.

Solver Table can be used to easily investigate the changes in any number of data cells. Multiple Choice Questions

If the right-hand side of Resource C changes to 130,then:

If the right-hand side of Resource A changes to 10,then the objective function value:

When even a small change in the value of a coefficient in the objective function can change the optimal solution,the coefficient is called:

If the optimal solution will remain the same over a wide range of values for a particular coefficient in the objective function,then management will want to take special care to narrow this estimate down.

It is usually quite easy to find the needed data for a linear programming study.

Figure -What is the optimal objective function value for this problem?

In linear programming,what-if analysis is associated with determining the effect of changing: I.objective function coefficients. II)right-hand side values of constraints. III)decision variable values.

What-if analysis:

When certain parameters of a model represent managerial policy decisions,what-if analysis provides information about what the impact would be of altering these policy decisions.

Shadow price analysis is widely used to help management find the best trade-off between costs and benefits for a problem.

If the coefficient of Activity 1 in the objective function changes to $10,then:

If the right-hand side of Resource B changes to 10,then:

If the right-hand side of Resource B changes to 80,then the objective function value:

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