Excel Solver Question

Copper Contributor

Hi Everyone, this question pertains specifically to the built in solver function.


I have built a linear program that, with one set of hard-coded inputs, yields an optimal answer and satisfied linearity. When I put in different inputs however, without changing the constraints or formulas, I do not meet the linearity requirements of the model. I've been combing through the model but have been unable to figure out what could be causing this.

1 Reply



To paraphrase Uncle Ben's advice to Spider-Man:  "With great details come great answers".


And "if a picture is worth a thousand words, an Excel file is worth a thousand pictures".