How to find best possible selection through optimisation

nudiekap

New Member
Joined
Dec 9, 2013
Messages
2
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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 !
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top