Hello
I am working on a case file which has to (in theory) automatically decide the amount of items it allocates to each store.
In the case, there are 50+ stores and every year 1 to 3 new stores open.
When there is a product that's at the end of it's life cycle, the stock in the warehouse needs to be distributed between stores and the webstore.
On average, the webstore sells between 2 and 5 times the amount of items a store does.
Every store has a limited surface.
Depending on the surface of the stores and the demand of the webstore (*2 till *5) i need to find a formula which should allocate stock to each store but the catch is, every store needs to get stock.
The shelf space needs to be 100% or 50% occupied, no inbetweens. (bonus points if able to be switched manually)
You can't always send the best selling stores all the stock and the least selling store no stock.
Is there anyone who knows how to do this? (mock-up data example below)
Kind regards
I am working on a case file which has to (in theory) automatically decide the amount of items it allocates to each store.
In the case, there are 50+ stores and every year 1 to 3 new stores open.
When there is a product that's at the end of it's life cycle, the stock in the warehouse needs to be distributed between stores and the webstore.
On average, the webstore sells between 2 and 5 times the amount of items a store does.
Every store has a limited surface.
Depending on the surface of the stores and the demand of the webstore (*2 till *5) i need to find a formula which should allocate stock to each store but the catch is, every store needs to get stock.
The shelf space needs to be 100% or 50% occupied, no inbetweens. (bonus points if able to be switched manually)
You can't always send the best selling stores all the stock and the least selling store no stock.
Is there anyone who knows how to do this? (mock-up data example below)
Kind regards
95 | 94 | 68 | 88 | 16 | 81 | 71 | 83 | 70 | 55 | 63 | 70 | 57 | 83 | 80 | 87 | 55 | 91 | 54 | 67 | <- surface | ||||
| articlenumber | stock | shelf space | store 1 | store 2 | store 3 | store 4 | store 5 | store 6 | store 7 | store 8 | store 9 | store 10 | store 11 | store 12 | store 13 | store 14 | store 15 | store 16 | store 17 | store 18 | store 19 | store 20 | webstore | <- name |
81154063 | 800 | 12 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
91520397 | 900 | 6 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
89627777 | 12 | 4 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
88863788 | 63 | 12 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
44484128 | 5 | 1 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
51456571 | 900 | 1 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
16464437 | 87 | 8 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
20575980 | 54 | 32 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
87709586 | 100 | 1 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | |
49754093 | 92 | 5 | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount | amount |
