Loop and aggregate values until a certain condition is met

[ajit555]

I was facing a similar allocation problem and posted here

Allocate projects to suppliers subject to overall threshold project aggregate value per supplier

Hello, Need your help in solving the below problem: A company has 50 projects. Each project has a project amount. Company has a list of suppliers. For any given supplier, the company has a threshold limit on the overall project amount that the supplier can handle called ‘Threshold’. The total amount of projects that a supplier is associated should be less than the threshold value. The goal is to allocate the projects to suppliers. The number of projects can increase or decrease as well as the…

Please let me know if it is similar to yours?