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 above

Question

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 above

Quizplus · Accepted Answer

All of the statements (A, B, C, and D) are true when formulating a linear programming problem on a spreadsheet, so the best choice is E. Parameters or coefficients are considered as data cells. Decision variables, as the name suggests, are the ones that the users have control over and are usually assigned as changing cells. Nonnegativity constraints are necessary in linear programming models to stop negative values from being chosen for decision variables, and the objective function is considered the objective cell.

When Formulating a Linear Programming Problem on a Spreadsheet,which of the Following