The solution of a linear programming problem using Microsoft 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) the changing cells,the target cells,and the constraints
D) the inputs,the changing cells,and the outputs

Question

Quizplus · Accepted Answer

The three stages in solving a linear programming problem using Microsoft Excel are: 
1) Formulating the problem (i.e., identifying the changing cells, target cells, and constraints), 
2) Invoking Solver (i.e., setting up the parameters, running Solver, and analyzing the output), and 
3) Sensitivity analysis (i.e., determining the impact of changes in the input values on the final solution). This process is typically done using Solver add-in tool in Microsoft Excel, making A the correct answer.

The Solution of a Linear Programming Problem Using Microsoft Excel