The Limits Report

The Limits Report was designed by Microsoft to provide a different kind of "sensitivity analysis" information. It is created by re-running the optimization model with each decision variable (changing cell) 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. An example of the Limits Report for EXAMPLE1.XLS is shown below.

Copyright © 1996 Frontline Systems Inc.
Last modified: December 01, 1996