Question 1

In the "Solver Options" box of Excel Solver,what should be checked to ensure that all decision variables are ≥ 0?
A)Assume Linear Model
B)Use Automatic Scaling
C)Assume Positive
D)Assume Non-Negative
E)Assume Nonzero

Accepted Answer

Checking "Assume Non-Negative" ensures that all decision variables are ≥ 0, which is the requirement for a non-negative mathematical programming problem.

Question 2

In the Excel Solver "Add Constraint" box,what two additional choices are available under the relationship operator list besides ≤,≥,and =?
A)gin and bin
B)int and gin
C)big and int
D)inf and bin
E)int and bin

Accepted Answer

The two additional choices under the relationship operator list in the Excel Solver "Add Constraint" box are "int" (for integer) and "bin" (for binary). This means that the constraint can only be satisfied by integers or binary values, respectively. These additional choices are useful when dealing with integer or binary linear programming problems. Therefore, the best choice is E.

Question 3

Which of the following is not one of the steps in setting up the Solver optimization problem?
A)specify the target cell
B)specify the objective cell
C)specify the changing cell(s)
D)specify the constraints
E)specify the Solver options

Accepted Answer

The answer of Which of the following is not one...

Question 4

A constraint in Excel Solver consists of what three pieces of information?
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

Accepted Answer

A constraint in Excel Solver is defined by a Cell Reference (which cell or cells are being constrained), a relationship operator (such as <=, >=, =), and a Constraint value or reference (the specific condition or value that the referenced cell(s) must meet).

Question 5

For an optimization problem a(an)__________________ violates at least one of the constraints.
A)infeasible solution
B)inoptimal solution
C)suboptimal solution
D)unbounded solution
E)simplex solution

Accepted Answer

An infeasible solution violates at least one of the constraints, meaning it cannot be a valid solution to the optimization problem. In contrast, an inoptimal solution may meet all constraints but is not the best possible solution. A suboptimal solution meets all constraints but is not the globally optimal solution. An unbounded solution occurs when the objective function can be improved infinitely without violating any constraints. A simplex solution is a solution obtained using the Simplex algorithm, a method for solving linear programs.

Question 6

The two primary Excel tools for diagnosing problems in models are ___________________.
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

Accepted Answer

The two primary Excel tools for diagnosing problems in models are Error Checking and Formula Auditing. Error Checking identifies and highlights any errors in the formula, while Formula Auditing visually traces the precedent or dependent cells for the selected cell or formula to check if there are any errors. Therefore, the answer is C - Error Checking and Formula Auditing.

Question 7

Which of the following statements is not correct?
A)A function with multiple variables can be linear.
B)If a constraint is violated,then the problem is infeasible.
C)A Linear Program as described in Supplement B can have more than one objective function if it has only one constraint.
D)Non-negativity constraints should be added to Linear Programs when the decision variable represents units of production.
E)An unbounded solution to a mathematical program may occur if there is not a constraint stopping the objective function value from continuing towards -∞.

Accepted Answer

A linear program can have only one objective function, regardless of the number of constraints.

Question 8

Constraints that are not at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value not equal to the right-hand-side value,are called _________________________.
A)inequality constraints
B)non-binding constraints
C)binding constraints
D)limiting constraints
E)shadow constraints

Accepted Answer

Non-binding constraints are those that are not at their limits at the optimal solution, meaning they do not impact the solution outcome. The other choices are incorrect: 
- A) inequality constraints are a type of constraint, but not specifically relevant to this question 
- C) binding constraints are at their limit and do impact the solution outcome 
- D) limiting constraints is not a commonly used term in linear programming 
- E) shadow constraints refer to a different concept in linear programming, where a constraint is derived from the optimal solution and used to improve the solution in subsequent iterations.

Question 9

In the "Solver Parameters" box of Excel Solver,what is clicked to actually solve the problem?
A)"GO"
B)"OK"
C)"SOLVE"
D)"CLOSE"
E)"START"

Accepted Answer

Clicking "SOLVE" initiates the solving process in Excel Solver.

Question 10

When was the Simplex Method developed?
A)1927
B)1937
C)1947
D)1957
E)1967

Accepted Answer

The Simplex Method was developed by George Dantzig in 1947.

Question 11

What in Excel Solver corresponds to the decision variables in the algebraic model?
A)Optimization Cells
B)Target Cells
C)Changing Cells
D)Decision Cells
E)Parameter Cells

Accepted Answer

The Changing Cells in Excel Solver correspond to the decision variables in the algebraic model. These are the cells that Solver will adjust in order to optimize the objective function. The other options are not directly related to the decision variables in the model.

Question 12

To retain model flexibility while using Solver you must:
A)use appropriate color codes
B)enter specific values
C)ensure the inputs and outputs are separated
D)use only cell references
E)use Slack

Accepted Answer

Using only cell references allows for flexibility in the model, as the values in those cells can be easily changed without affecting the solver setup.

Question 13

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.
A)Complex Method
B)Multiplex Method
C)Simplex Method
D)Superplex Method
E)Perplex Method

Accepted Answer

The method developed by George Dantzig to solve linear programs is called the Simplex Method.

Question 14

What in Excel Solver corresponds to the objective function in the algebraic model?
A)Optimization Cell
B)Target Cell
C)Changing Cell
D)Constraint Cell
E)Parameter Cell

Accepted Answer

The objective function in the algebraic model represents the target value that needs to be optimized. In Excel Solver, the cell that corresponds to this target value is known as the Target Cell. Therefore, the correct answer is B) Target Cell.

Question 15

Solver provides many options for the solution process.For LPs,the two most commonly used are:
A)assume linear model,assume negative
B)assume non-linear model,assume negative
C)assume non-linear model,assume non-negative
D)assume linear model,assume non-negative
E)assume non-linear model,assume non-negative.

Accepted Answer

Assuming a linear model is appropriate for LPs, and assuming non-negativity is a reasonable constraint as negative values often do not have practical meaning in the context of the problem being solved.

Question 16

Constraints at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value equal to the right-hand-side value,are called _________________________.
A)equality constraints
B)non-binding constraints
C)binding constraints
D)limiting constraints
E)synergistic constraints

Accepted Answer

Constraints which are at their limits at the optimal solution are called binding constraints because they "bind" or limit the optimal solution. Equality constraints have left-hand-side value equal to the right-hand-side value, which is the characteristic of the constraints at their limits. Non-binding constraints are not at their limits at the optimal solution and do not affect the optimal solution, while limiting constraints and synergistic constraints are not common terminologies used in linear programming.

Question 17

If the solution to an optimization problem violates two constraints but satisfies three,it is a(an)________.
A)suboptimal solution
B)infeasible solution
C)inoptimal solution
D)unbounded solution
E)simplex solution

Accepted Answer

An infeasible solution violates one or more of the constraints and therefore cannot be a valid solution to the optimization problem. In this case, the solution violates two constraints, so it is infeasible. A suboptimal solution is a feasible solution that is not the best or optimal solution. An inoptimal solution is not a commonly used term in optimization. An unbounded solution occurs when the objective function can be improved indefinitely, without violating any constraints. A simplex solution refers to a specific algorithm for solving linear programming problems.

Question 18

In the "Solver Options" box of Excel Solver,what should be checked to ensure that the Simplex Method is used to solve the model?
A)Assume Non-Negative
B)Use Automatic Scaling
C)Newton
D)Dantzig
E)Assume Linear Model

Accepted Answer

The answer of In the "Solver Options" box of Excel...

Question 19

Which Excel tool provides solutions to Linear Programs?
A)Solver
B)Answer
C)Simplexer
D)Computer
E)Goal Seek

Accepted Answer

Solver is the Excel tool specifically designed to solve Linear Programs. The other options (Answer, Simplexer, Computer, and Goal Seek) are not specifically designed for solving Linear Programs.

Question 20

Dane's aircraft muffler manufacturers have 1500 linear feet of steel on hand to manufacture the three top selling muffler sets.Super mufflers (S)provide $285 profit and common (C)mufflers' profit margin is $310,while the deluxe (D)muffler set provides a $400 profit margin.It costs Dane $310,$295,and $400 to build each muffler set,respectively.What is the objective function of Dane's aircraft muffler manufacturing?
A)Min S,C and D
B)MAX S,C,and D
C)Max 285S + 310C + 400D
D)Min 285S + 310C + 400D
E)Max 310S + 295C + 400D

Accepted Answer

The objective of the manufacturing process is to maximize the profit. The profit earned through each type of muffler set is known, and the manufacturing cost for each set is also given. Therefore, the objective function can be calculated by multiplying the profit margin with the number of sets produced and then subtracting the manufacturing cost. Thus, the objective function is Maximize 285S + 310C + 400D. As the question asks for the objective function, the answer is C.

Quiz 18: Introduction to Optimization

In the "Solver Options" box of Excel Solver,what should be checked to ensure that all decision variables are ≥ 0?

In the Excel Solver "Add Constraint" box,what two additional choices are available under the relationship operator list besides ≤,≥,and =?

Which of the following is not one of the steps in setting up the Solver optimization problem?

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

For an optimization problem a(an) __________________ violates at least one of the constraints.

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

Which of the following statements is not correct?

Constraints that are not at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value not equal to the right-hand-side value,are called _________________________.

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

When was the Simplex Method developed?

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

To retain model flexibility while using Solver you must:

George Dantzig developed the ___________________ in 1947 to solve Linear Programs.

What in Excel Solver corresponds to the objective function in the algebraic model?

Solver provides many options for the solution process.For LPs,the two most commonly used are:

Constraints at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value equal to the right-hand-side value,are called _________________________.

If the solution to an optimization problem violates two constraints but satisfies three,it is a(an) ________.

In the "Solver Options" box of Excel Solver,what should be checked to ensure that the Simplex Method is used to solve the model?

Which Excel tool provides solutions to Linear Programs?