Computation

Mathematical Programming Linear/Integer Programming Example Problem Constructing the Worksheet Solving the Problem Sensitivity Analysis Jensen Solver Integer Variables Download

Using the Change Button, we have changed the Solver to the Jensen LP/IP Solver. To use this solver the LP/IP Solver add-in (lpip_solver.xla) must be installed. When it is installed the LP/IP Solver item appears on the OR_MM menu. The worksheet for appears almost identical for this solver except the model has been deleted from the range starting in cell A2. The Jensen Solver reads the data directly from the ranges on the worksheet. Of course, one should expect the same solution from both solvers, but they may be different if alternative optimums are present.

The sensitivity analysis given by the Jensen LP/IP Solver is shown below. Some columns have been widened from the original to show more decimal accuracy. In most cases Excel results have many decimals of accuracy that can be observed by widening the columns and choosing the General format to display numbers. The Jensen display differs from the Excel display in that lower and upper limits of ranges are shown rather than amounts of increase and decrease.