In: Statistics and Probability
The solution of a linear programming problem using Microsoft Excel typically involves the following three stages:
a. formulating the problem, graphing the problem, and sensitivity analysis
b. the changring cells, the target cells, and the constraints
c. the inputs, the changing cells, and the outputs
d. forumulating the problem, invoking Solver, and sensitivity analysis
The solution of a linear programming problem using Microsoft Excel typically involves the following three stages:
formulating the problem, invoking Solver, and sensitivity analysis.
Formulating the problem:Formulate algebraic models for linear programming problems.
Invoking Solver:Excel’s Solver Add-In to solve linear programming problems.
sensitivity analysis:Interpret the results of models and perform basic sensitivity analysis.