Explain the steps necessary to solve a linear programming problem using Microsoft Excel's Solver.

The first step is to construct a spreadsheet model for the problem. To solve the problem, select the Solver option from the Tools menu in the Excel control panel. The Solver dialog box will appear. The target cell is the one that contains the objective function value. Changing cells are those that hold the decision variables. Constraints are constructed in the constraint box or edited by using the Add, Change, or Delete buttons. Excel does not assume nonnegativity. Thus, nonnegativity must be added to the model by checking the Assume nonnegative box in the Options dialog.. The Assume Linear Model in the Options dialog should also be checked. Then, click Solve in the dialog box.