How to find best possible selection through optimisation

[nudiekap]

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

 

[earthworm]

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

You cannot because since the points for 11 balls are random how do will you every be able to find the optimum point. there is no static points here.
If you are aware of points assign to each ball for each color only then there is a chance to find the solution . Its pure gamble here !