Forum Discussion
Solved
Finding the best combination of values using solver
Question: How do I use Excel built in solver to get the correct combination? Objective: To purchase parts at lowest cost. Constraints: Divvy up among 3 suppliers/out of 5 suppliers ; a total of 19 ...
Lost_inExcel I'm not entirely sure, without seeing what went wrong. If you could save and attach the file (or provide a screenshot), I could possibly offer something more concrete. What version of Excel are you using? The formulas I used will only work with Excel for MS365. This is what it looks like when I input $1 for all parts for Sup1:
Min Cost via Data Table
As long as you input any Row_ID with the lowest cost (1 thru 6) in cell F13, it should assign all 19 parts to Sup1.
Since the original question specified Solver, the correct combination of suppliers may be determined using an evolutionary search.