Upgrade to remove ads
Only $35.99/year

Module 7

Terms in this set (19)

Linear programming is not a tool that aids management in making decisions (like how to allocate resources).

True
False
False
Linear programming is applicable for what three things
profit making
non profit making
governmental agencies
Linear programming means the planning ____ that is represented by a _____
of activities, linear mathematical model
What are the three key questions to be addressed in formulating any spreadsheet model?
a. What are the decisions to be made?
b. What are the constraints on these decisions?
c. What is the overall measure of performance for these decisions?
In excel the data is goes in
data cells
In excel the decisions go in
changing cells
In excel the constraints go in
output cells
In excel the measure of performance goes in
Objective cells
What are the four kinds of cells used in linear programming spreadsheet models?
a. The data (data cells):
b. The decisions (changing cells):
c. The constraints (output cells):
d. The measure of performance (objective cells):
Find the values of x1 and x2 where the following two constraints intersect.
(1) 9x1 + 7x2 ≥ 57
(2) 4x1 + 6x2 ≥ 13
x1= 9.654
x2= (4.269)
Which of the following components of a linear programming model sets limits on the set of potential solutions?

Multiple Choice
Constraints
Decision variables
Parameters
Objective
Solution
Constraints
Which of the following components of a linear programming model is the overall performance measure?

Multiple Choice
Constraints
Decision variables
Parameters
Objective
Solution
Objective
Which of the following components of a linear programming model represents the level of each activity?

Multiple Choice
Constraints
Decision variables
Parameters
Objective
Solution
Decision variables
Which of the following statements about feasible solutions to a linear programming problem is TRUE?

Multiple Choice
There will be at most one feasible solution to any linear programming problem.
All linear programming problems have at least one feasible solution.
A feasible solution will also be an optimal solution.
The optimal solution will also be a feasible solution.
All of the answer choices are true.
The optimal solution will also be a feasible solution.
Which of the following statements about feasible solutions to a linear programming problem is FALSE?

Multiple Choice
There will always be at least one feasible solution to any linear programming problem.
Some linear programming problems have no feasible solution.
A feasible solution does not violate any of the problem constraints.
The optimal solution will also be a feasible solution.
All of the answer choices are false.
There will always be at least one feasible solution to any linear programming problem.
In an excel function the objective function is located?
where the total profit cell in
In an excel function the is the decision variables located?
Where the units produced is or YELLOW CELLS
Given the following 2 constraints, which solution is a feasible solution for a minimization problem?
(1) 10x1 + 5x2 ≥ 50
(2) x1 + 2x2 ≥ 12

(x1, x2 ) = (5, 0)
(x1, x2) = (3, 5)
(x1, x2) = (5, 3)
(x1, x2) = (0, 5)
(x1, x2) = (3, 5)
Find the values of x1 and x2 where the following two constraints intersect.

(1) 10x1 + 5x2 ≥ 50
(2) 1x1 + 2x2 ≥ 12
x1= 2.667
x2= 4.667
Students also viewed