Forum Discussion

sbauer40's avatar
sbauer40
Copper Contributor
Mar 13, 2023

Excel Solver Question

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.

  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor

    sbauer40 

     

    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".

Resources