in cell D5 and copy it into cells D6:D9.
All the elements of the LP model are now ready to be linked with Solver. From
Excel'sTools menu,select Solver4
to open the Solver Parameters dialogue box shown
in the middle ofFigure 2.12. First, you define the objective function,z, and the sense of
optimization by entering the following data: