Question 1

Figure  
-Where are the changing cells located?

Accepted Answer

A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10. 
A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10. C

Question 2

When formulating a transportation problem on a spreadsheet,which of the following are necessary?

Accepted Answer

A) A table of data. 
B) A network representation. 
C) A table for the solution. 
D) a and c only. 
E) All of the above. 
A) A table of data. 
B) A network representation. 
C) A table for the solution. 
D) a and c only. 
E) All of the above. D

Question 3

When formulating a linear programming model on a spreadsheet,the decisions to be made are located in the data cells.

Accepted Answer

A) True 
 B)False  False

Question 4

Strict inequalities (i.e.,)are not permitted in linear programming formulations.

Accepted Answer

A) True 
 B)False

Question 5

The capacity row in a distribution-network formulation shows the maximum number of units than can be shipped through the network.

Accepted Answer

A) True 
 B)False

Question 6

The transportation model method for evaluating location alternatives minimizes:

Accepted Answer

A) the number of sources. 
B) the number of destinations. 
C) total supply. 
D) total demand. 
E) total shipping cost 
A) the number of sources. 
B) the number of destinations. 
C) total supply. 
D) total demand. 
E) total shipping cost

Question 7

When formulating a linear programming problem on a spreadsheet,data cells will show the levels of activities for the decisions being made.

Accepted Answer

A) True 
 B)False

Question 8

In linear programming formulations,it is possible to have the following types of constraints:

Accepted Answer

A) $\le$. 
B) >. 
C) =. 
D) a and c only. 
E) All of the above. 
A) $\le$. 
B) >. 
C) =. 
D) a and c only. 
E) All of the above.

Question 9

A mixed linear programming problem will always contain some of each of the three types of constraints in it.

Accepted Answer

A) True 
 B)False

Question 10

Linear programming does not permit fractional solutions.

Accepted Answer

A) True 
 B)False

Question 11

Transportation problems have the following type of constraints:

Accepted Answer

A) $\ge$. 
B) $\le$. 
C) =. 
D) <. 
E) None of the above. 
A) $\ge$. 
B) $\le$. 
C) =. 
D) <. 
E) None of the above.

Question 12

The requirements assumption states that each source has a fixed supply of units,where the entire supply must be distributed to the destinations and that each destination has a fixed demand for units,where the entire demand must be received from the sources.

Accepted Answer

A) True 
 B)False

Question 13

It is fairly common to have both resource constraints and benefit constraints in the same formulation.

Accepted Answer

A) True 
 B)False

Question 14

Approximations and simplifying assumptions generally are required to have a workable model.

Accepted Answer

A) True 
 B)False

Question 15

In most cases,the minimum acceptable level for a cost-benefit-tradeoff problem is set by how much money is available.

Accepted Answer

A) True 
 B)False

Question 16

Figure  
-Where are data cells located?

Accepted Answer

A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10. 
A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10.

Question 17

Generally,assignment problems match people to an equal number of tasks at a minimum cost.
Multiple Choice Questions

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not information needed to use the transportation model?

Accepted Answer

A) Capacity of the sources. 
B) Demand of the destinations. 
C) Unit shipping costs. 
D) Unit shipping distances. 
E) All of the above. 
A) Capacity of the sources. 
B) Demand of the destinations. 
C) Unit shipping costs. 
D) Unit shipping distances. 
E) All of the above.

Question 19

Figure  
-Where is the target cell located?

Accepted Answer

A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10. 
A) B2:D2. 
B) B2:D2,B4:D7,and G5:G7. 
C) B10:D10. 
D) E5:E7. 
E) G10.

Question 20

A key assumption of linear programming is that the equation for each of the output cells,including the target cell,can be expressed as a SUMPRODUCT (or SUM)function.

Accepted Answer

A) True 
 B)False

Exam 3: Linear Programming: Formulation and Applications

Figure -Where are the changing cells located?

When formulating a transportation problem on a spreadsheet,which of the following are necessary?

When formulating a linear programming model on a spreadsheet,the decisions to be made are located in the data cells.

Strict inequalities (i.e.,< or >)are not permitted in linear programming formulations.

The capacity row in a distribution-network formulation shows the maximum number of units than can be shipped through the network.

The transportation model method for evaluating location alternatives minimizes:

When formulating a linear programming problem on a spreadsheet,data cells will show the levels of activities for the decisions being made.

In linear programming formulations,it is possible to have the following types of constraints:

A mixed linear programming problem will always contain some of each of the three types of constraints in it.

Linear programming does not permit fractional solutions.

Transportation problems have the following type of constraints:

The requirements assumption states that each source has a fixed supply of units,where the entire supply must be distributed to the destinations and that each destination has a fixed demand for units,where the entire demand must be received from the sources.

It is fairly common to have both resource constraints and benefit constraints in the same formulation.

Approximations and simplifying assumptions generally are required to have a workable model.

In most cases,the minimum acceptable level for a cost-benefit-tradeoff problem is set by how much money is available.

Figure -Where are data cells located?

Generally,assignment problems match people to an equal number of tasks at a minimum cost. Multiple Choice Questions

Which of the following is not information needed to use the transportation model?

Figure -Where is the target cell located?

A key assumption of linear programming is that the equation for each of the output cells,including the target cell,can be expressed as a SUMPRODUCT (or SUM)function.

Introduction

Linear Programming: Basic Concepts

The Art of Modeling With Spreadsheets

What-If Analysis for Linear Programming

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