Solver

[Guest]

I am using the solver in Excel but when ~I ask for a
senstivity report it only gives half of the langrange
multipleirs
I only use 15 variables and about 50 contraints so excel
should be able to handle it.
Does anyone know how I can get the langrange multipliers
to be displayed.

 

[Tushar Mehta]

From what I remember, the Lagrange Multiplier will be non-zero for only
binding constraints.

--
Regards,

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

 

[Harlan Grove]

From what I remember, the Lagrange Multiplier will be non-zero for only
binding constraints.

...

Constraints as meant when working with Lagrange Multipliers are equality
constraints. Equality constraints would always be binding. If there were
inequality constraints, then if strict inequality applied, it'd be as if that
constraint didn't exist rather than its multiplier would be zero.