Excel Solver - Interpreting the Limits Report

The Limits Report provides a specialized kind of “sensitivity analysis” information. It is created by re-running the Solver model with each decision variable in turn as the objective (both maximizing and minimizing), and all other variables held fixed. Hence, it shows a “lower limit” for each variable, which is the smallest value that a variable can take while satisfying the constraints and holding all of the other variables constant, and an “upper limit,” which is the largest value the variable can take under these circumstances.