Hi!

I want to calculate the optimal combination of product lengths that can run of a master roll of raw material.

The machine can handle a roll with a minimum of 20.5" and a maximum roll of 45.25"
The products that needs to be produced have the following lengths:

A: 11.75
B: 14.75
C: 12.25
D: 15.25

I want to know the possible combinations for these variables, for instance: 2 A's + 1 B = total width 38.25 , 2D's +1C = total width of 39.75 etc etc

Is there a function in Excell where you just supply these different variables, given the minimum total of 20.5 and the maximum total of 45.25, and it gives you all combinations of products possible within these range?

It would really help me, thank you in advance!

Robbert