Excel Solver: Can This Problem Be Solved with a Linear Model?

  • Hi there,

    I have a general understanding of Solver, but have hit a wall with this project.

    In the attached I have "loads" 1-10, and their corresponding weights in Columns A:B.

    What I am asking solver to do is find me the optimal combination of loads that can be built by combining into "consolidated loads" that do not exceed 60,000 lbs.

    The target that I have to determine optimality is to minimize the size of the last "consolidated load" that can be built (this is due to rate structure specific to the business).

    I have been able to get solver to work under the Evolutionary model, but as we all know, this doesn't guarantee optimality. Hence I have been trying to figure out if this problem can be presented in a linear form to Solver to allow it to converge on an optimal result. My Solver/mathematic skills haven't allowed me to get any further than this.

    Any and all help would be greatly appreciated.


  • Re: Excel Solver: Can This Problem Be Solved with a Linear Model?

    Any guru's out there had any luck with this?

    Even if the answer is simply "this cannot be done", I'd really appreciate some insight.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!