Sensitivity Reports

[jwo1985]

Wondering if anyone could help because I'm very very confused.

I've solved a linear programming problem using Excel and in particular Solver. The problem is solved and it looks like the solution takes into account ALL of the constraints that I entered.

However, some of the constraints are not listed on the sensitivity report. Like I say I've checked the constraints that were entered into Solver and they're definitely there, and the solution has taken into account the constraints that I have entered.

I appreciate that this is particularly vague but is there any reason why a constraint would not appear on the sensitivity report??

[scottnoddin77]

I have never had that happen to me. Sorry I can't help but good luck finding a solution. Did you try running it again?

[jwo1985]

Tried again and the same constraints were missing.

In a way its a good job I had this problem as I realised I had set the wrong target cell. I got a sensitivity report after correcting the error but alas the same constraints were missing.

Back to the drawing board... I find crayons a lot easier to handle than formulae entered into Excel :P