Equlibrate quantites between shops

Hi guys,

i have a quesion concerning quantities to equilibrate between shops with criterias.

I have a table with quantity of each product in each shop like this

And a table with simple stats concerning sales.

I would liek to equilibrate quantities according to stats

==> where new warehouses are maybe containing goods for the first time.

==> where stok levels must be 1 at least if possible according to stats.

==> Not have twice quantities of same size in warehouse.

What i did is first group by product to know the total quantities on each product, watever size

Divide quantity by number of warehouse.

If number is integer then set quantity to 1 everywhere

ex with non integer repartition (product A ==>  4/3 = 1,33333

So set 1 everywhere ok i have my min stock in each shop)

then substract min  (1 ) to total of items ==> 4-3 = 1 

if (like this example)  6/3 = 2 Then Set 1 also

6-5 = 1 

Create a rank according to Sales. 

Then if the quantity is < or equal to rank then set value to 1

Like this everything is distibuted with min stock and according to stats

(i resume in mode easy since then i divide result by stats values  5 / %Sales of size in shop X    by example) and do some other operations but here is to facilitate understanding.

However if I continue and says, according to my results. (without warehouse W since this item is not authorized there anymore but this has been take into account at previous step)

i must then know which size i send where.

For this i follow my table ( which have a bit more informations in real, but i need the logic behind) and check stats.

I must send 3 quantities of Product A to Warehouse X  However i don't want the same sizes to be shipped at the same place.

How could i do this?

since Item A needs to be shipped in three different sizes size in warehouse X for a total of 3 

                     A needs to be shipped in two different sizes in Warehouse Y for a total of 2

                       A needs to be shipped in one quantity in wareHouse Z for a total of 1 item.

These sizes must follow Statistics but first been represented at most places as possible.

Isn't it feasible using List.Accumulate? 

I do not really understand that function and any help would be appreciated even using another method 🙂

Thanks guys !!