The solution of a linear programming problem using Excel^® typically involves the following three stages: A) formulating the problem, invoking Solver, and sensitivity analysis B) formulating the problem, graphing the problem, and sensitivity analysis C) designing the decision variable cells, the target cells, and the constraints D) designing the inputs, the decision variable cells, and the outputs

Question

Quizplus · Accepted Answer

The three stages involved in solving a linear programming problem using Excel and Solver are as follows: formulating the problem (which involves identifying the decision variables, objective function, and constraints), invoking Solver (which involves setting up Solver to solve the problem and finding the optimal solution), and sensitivity analysis (which involves changing parameters to analyze the effect on the optimal solution). Graphing the problem may be useful in understanding and visualizing the problem, but it is not a necessary stage in solving the problem using Excel and Solver. Designing decision variable cells, target cells, and constraints is part of formulating the problem, rather than a separate stage. Designing inputs, decision variables, and outputs may be part of the problem formulation, but it is not a three-stage process as described in the question.

The Solution of a Linear Programming Problem Using Excel® Typically

The Solution of a Linear Programming Problem Using Excel^® Typically