In using Excel to solve linear programming problems, the changing cells represent the:
A)value of the objective function
B)constraints
C)decision variables
D)total cost of the model

Question

Quizplus · Accepted Answer

The changing cells in Excel represent the decision variables in a linear programming model. These are the variables that we are solving for in order to optimize the objective function, subject to the constraints. The value of the objective function itself is not a changing cell, but rather a calculated result based on the values of the decision variables. The constraints are represented by fixed values or formulas in other cells of the Excel spreadsheet. The total cost of the model may be related to the objective function, but it is not a changing cell in and of itself.

In Using Excel to Solve Linear Programming Problems, the Changing