How to "Solve" Solver Optimization Mix Problem Errors

Hello all,

I'm a little new to solver, so i'm probably missing something very simple, but here's my problem.

I have a list of technologies with associated capabilities (score of 1-5). I have a set of requirements for said capabilities (score of 1-5). I have costs associated with each technology.

I would like to run solver to find the most optimal combination of capabilities such to maximize the total score, given a cost constraint.

However, when I run Solver in the attached, I keep getting either a linearity error or a "solver cant find solution". I know there's at least a feasible solution (I've done it myself).

Please help!

Best,
Chris

Try this:

D24 =SUMIF(Table1[Selected? 0 or 1],1,Table1[Cost])

Then run the solver.

I get B7 = 6.9166

Hi falcondude,

Thanks for the quick reply. I tried your suggestion and got 2.6, Then I changed the constraint to 43k and got a linearity error. See attached.

Hmm. I'm not sure why you would have gotten 2.6.

I did have to recreate the formulas in D26:M26 using MAX and IF since I don't have the MAXIFS function.

See attached.

As far as the linearity error is concerned, I am getting that on my end as well when I lower the constraint to anything less than 318,473.

I'm not too familiar with the different types of solving methods. I'll see if someone knows more about them.

It seems to work when I change the solving method to Evolutionary but it takes a couple of minutes.

That's interesting - works for me as well.

I'll have to do a bit of reading to see what the difference is. Thank you for taking the time to help out!

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.