Maximum | 29 | ||||
Min | Max | Value | Best Combination | Value | |
13 | 14 | 10 | 14-15 | 50 | |
14 | 15 | 50 | 14-15 | 50 | |
15 | 16 | 20 | Total | 100 | |
16 | 17 | 25 | |||
<tbody>
</tbody>
I have a problem that I think Excel Solver can help me with, but I'm not certain. What I want to do is determine the best combination given a maximum number. However in all the examples I've found, the product usually is a single item, rather than a range. In this case I need to know the best combination with the understanding that each product has a range, but an overall maximum acceptable value.
In this example I obviously just created the answer by hand to demonstrate that although the maximum was 29 because those two product fall within the range, that is the maximized value of 2 x 50 = 100.
Does anyone know how I can use excel to determine this solution?
Last edited: