Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT
window (see Figure 9-9). If you added
constraints for January and the other months,
delete the constraints from the Solver Parameters window. However, production must be greater than or
equal to the forecast for each month, so leave in those constraints.
less than or equal to
Selecting the GRG Nonlinear solving method in the Solver Parameters window
Run Solver again. This time you should get a solution that satisfies all your constraints. Click Keep Solver
Solution and then create an Answer Report by clicking Answer in the Reports pane of the Solver Results
window (see Figure 9-10). Click OK to close the Solver Results window.
Creating an Answer Report