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
| Product | quantities | Warehouse | Size | Type |
| A | 1 | X | XL | T Shirt |
| A | 2 | X | M | T Shirt |
| A | 1 | Y | XL | T Shirt |
| A | 2 | Z | XL | T Shirt |
And a table with simple stats concerning sales.
| warehouse | type | Size | % of sales |
| X | T Shirt | XL | 45% |
| Y | T Shirt | XL | 25% |
| X | T Shirt | M | 100% |
| Z | T shirt | XL | 18% |
| W | T Shirt | XL | 12% |
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)
| product | quantity required in warehouse | warehouse | |
| A | 3 | X | |
| A | 2 | Y | |
| A | 1 | Z | |
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 !!
