When formulating a linear programming problem on a spreadsheet, which of the following is true?
A) Parameters are called data cells.
B) Decision variables are called changing cells.
C) Nonnegativity constraints must be included.
D) The objective function is called the objective cell.
E) All of the answer choices are correct.

Question

Quizplus · Accepted Answer

All of the options listed are correct when formulating a linear programming problem on a spreadsheet. Parameters are typically referred to as data cells, decision variables are typically referred to as changing cells. Nonnegativity constraints are often included in linear programming problems to ensure that the solution is non-negative. Finally, the objective function is the function that is being optimized and is referred to as the objective cell in a spreadsheet implementation.

When Formulating a Linear Programming Problem on a Spreadsheet, Which