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. The objective fun"

Answer 1

Parameters are called data cells, decision variables are called changing cells and the objective function is usually placed in a separate cell when formulating a linear programming problem on a spreadsheet.

Step-by-step explanation:

When formulating a linear programming problem on a spreadsheet, the following statements are true:

1. Parameters, which represent the known values, are called data cells.
2. Decision variables are the unknowns and are represented by changing cells.
3. The objective function defines the goal of the problem and is usually placed in a separate cell.

For example, in a production problem, the production quantities of different products can be decision variables, and the profit or cost objective can be the objective function.