Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to complete the Solver dialogue box for LP model?

April 26, 2017Box COMPLETE Dialogue Lp model solver

0

Posted

How to complete the Solver dialogue box for LP model?

1 Answer

0

Posted

• Set target cell by clicking on the cell where you have the objective function • Set changing cells by dragging through cells holding the decision variables. If you have the decision variables in cell ranges that are not adjacent, press the Ctrl key and select the multiple ranges • Add constraints by clicking through all the cells that you keep the LHS and RHS of your constraints. • Press the Options button and check Assume Linear Model and Assume Nonnegative options • Leave all the other options at default • Click solve.