Hi experts,
I am trying to identify the optimal solution on the below problem. Have tried using solver but without luck given the amount of variables. Thus, I hope someone can guide me on how to solve this with VBA or another solution.
Situation: I have
- 200 balls in 6 different colours
- The balls have been randomly assigned points between 1-1,000
- The balls have been randomly assigned a cost between 100-10,000
Problem: I need to purchase 11 balls that give the highest possible total number of aggregated points within the following constraints
Constraints:
- I need to purchase at least one ball of each colour
- I can maximum buy three balls of one colour
- I only have 15,000 of credits worth to purchase balls
How do I find the optimal selection of the 11 balls?
Thanks
I am trying to identify the optimal solution on the below problem. Have tried using solver but without luck given the amount of variables. Thus, I hope someone can guide me on how to solve this with VBA or another solution.
Situation: I have
- 200 balls in 6 different colours
- The balls have been randomly assigned points between 1-1,000
- The balls have been randomly assigned a cost between 100-10,000
Problem: I need to purchase 11 balls that give the highest possible total number of aggregated points within the following constraints
Constraints:
- I need to purchase at least one ball of each colour
- I can maximum buy three balls of one colour
- I only have 15,000 of credits worth to purchase balls
How do I find the optimal selection of the 11 balls?
Thanks
