May 14 2020 12:40 PM - edited May 14 2020 12:46 PM
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