Excel Solver: Constraint priority RRS feed

  • Question

  • Hi, there.

    I'm trying to a LP Model using Excel Solver and VBA

    I have decision variables(percentage) and some(about 30?) constraints which are Integer and double.

    The problem I have is one of the constraints is sum of decision variable equals to zero because decision variables are percentage.

    I'd like to the constraint considers first, I mean, make it strong(?) constraint

    When some of the constraints are not satisfied, I think, the percentage constraints should be satisfied. 

    However, the percentage constraints  are not satisified sometimes(e.g. sum of decision variable >= 100%)

    Are there any solution to satisfy the percentage constraints always?

    Thank you.

    Jinhwan Lee

    Tuesday, August 13, 2019 4:12 AM