All combinations to a certain goal URGENT GRADUATION ISSUE

Occasional Visitor

Dear friends,

 

I have an urgent excel question. For my graduation I want to calculate al combinations of certain variables to a revenue goal. So for example:

 

The goal is a revenue of 10.000 and I sell 5 products with the following margins:

 

Product 1 = 500,-

Product 2 = 800,-

Product 3 = 700,-

Product 4 = 400,-

Product 5 = 200,-

 

I want to know all combinations of the above products to get to my target of 10.000, so for example

1 * product 1 + 10 * product 2 + 3 * product 7

3 * product 4 + 6 * product 5 + 1 * product 1 + 11 * product 3

13 * product 2

And so on, just all different combinations there are to get to the revenue of 10.000. I need this for my graduation project! Is there a way to do this by giving the variables. 

 

I hope someone can help me! My gratitude will be great!

 

Kind regards, Jacob

0 Replies