Different Solver sensitivity output tables

[Ken W]

I have Excel 2003, Small Business Edition on my home computer (a 1 year old
Dell).

The sensitivity output tables that Solver produces are a different version
of those that I see in other references, such as in textbook examples
(Operations Research class in grad school), and on my office computer.

Briefly, instead of getting an output table with the columns "Cell", "Name",
"Final Value", "Reduced Cost", "Objective Coefficient", "Allowable Increase",
"Allowable Decrease" - my home version produces a much reduced table with
only "Cell", "Name", "Final Value" and "Reduced Gradient". Also, in the
Constraints table, instead of getting "Shadow Price", "Constraint RH Side",
"Allowable Increase" and "Allowable Decrease", all I get is "Lagrange
Multiplier".

I did not buy a stripped down version of Excel, so why am I getting a
stripped down version of the output tables? And more importantly, how can I
quickly obtain the full version of the sensitivity tables that I need? And
thought I paid for...

 

[Tushar Mehta]

You must have forgotten some of what you learnt in the Ops Research class
{grin}

What you want is available only for a "linear" model. In Solver, select the
Options button. In that dialog box, check 'Assume Linear Model'. Assuming
you really do have a linear model you will get the additional information
you want.

Also, and while not directly relevant to your current problem, you may not
have bought a stripped down version of Excel but the default version of
Solver is a basic version. The company that makes that product (and, no, it
is not Microsoft) sells several other enhanced versions at www.solver.com.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions