Hi all,
I need help on code for performing the following function
1. I have multiple warehouses and requirement from each warehouse in terms of tonnage (by different stocking units / SKU)
2. I have the supplying source plant and stock available (in tonnage) at the source plant
3. I have ranked the warehouses basis the stock penetration (i.e how far the current stock has fallen below required norm)
4. Basis the ranking, I need to allocate the stock available at plant to the warehouses with higher stock penetration % being the first warehouse to be served.
5. The allocation has to continue till all warehouses are served or till all stock at the plant is exhausted (the code has to stop once either of these happens)
I am attaching the input sheet and the output sheet (the way I envisage the output).
Thanks in advance for the help.