Need help in Evenly Distribution of work

[akshaysaxena]

Hello Everyone, I need to evenly (or as much as evenly as possible) distribute invoices to my Team members (A, B, C). There are several conditions as well while distributing the data. Some invoices have "Critical Vendors" and some are High Dollar invoices. Only "A" is allowed to work on "Critical" vendor invoices. On "Non-Critical" and "High Dollar" invoices, "A" , "B" are allowed to work on them. For other "Non-Critical" and "Normal" invoices, "A","B" & "C" can work. Also, They have limit of 8 invoices per day including previous day's balance that they already have. I can do distribution for each scenario individually but it is not giving overall evenly distribution that I desire. Please advise. I have attached the data and my half-baked workflow as well.

[Szymon_Czuszek]

Attached the result in a zipped package. The difference between the solutions, comes out of the fact that one invoice can be assigned to both A & B workers, which is why it got duplicated. In the case of more invoices, solution 1 is much more feasible, as solution 2 requires manual adjustments of residual invoices, which can be allocated to multiple workers. Solution 2 shines, when you want more qualified workers to do more invoices than unqualified ones. In my humble opinion, dropping as much work as possible on non experienced workers will lead them to gain experience more quickly, and the solution 1 favors this, while disabling the possibility of assigning an invoice to unqualified worker.