Hi,
IS THERE A FORMULA THAT CAN HELP!!!
I am stuck in this allocation problem where in I need to allocate the stock as per the Base % and the supply is less than the requirement.
I want to optimize the allocation Qty in such a way that the qty does not exceed 550 and the percentage remaining after allocation remain same like in the case shown below. (currently for example view I have manually calculated the allocation qty)
Article Name Location Standard Qty Available Stock Transit Qty Order Qty To be sent to serve Orders To be sent to serve Standard Stock % remaining Allocation Stock % Remaining After Allocation
Glass 1 X1 500 200 0 250 50 500 0% 240 48%
Glass 1 X2 400 150 30 200 20 400 0% 190 48%
Glass 1 X3 250 50 20 150 80 250 0% 120 48%
Glass 1 X4 750 650 50 100 0 150 80% 0 80%
Glass 1 X5 500 490 0 0 0 10 98% 0 98%
150 1310 550
No issues with getting this information
Particulars Explanation Qty
Total Available Qty is Information at the Supply Location 700
To be sent to serve Orders Sumation of Col H 150
Available for Standard Total - to be send against order 550
Req to serve standard 1310
IS THERE A FORMULA THAT CAN HELP!!!
I am stuck in this allocation problem where in I need to allocate the stock as per the Base % and the supply is less than the requirement.
I want to optimize the allocation Qty in such a way that the qty does not exceed 550 and the percentage remaining after allocation remain same like in the case shown below. (currently for example view I have manually calculated the allocation qty)
Article Name Location Standard Qty Available Stock Transit Qty Order Qty To be sent to serve Orders To be sent to serve Standard Stock % remaining Allocation Stock % Remaining After Allocation
Glass 1 X1 500 200 0 250 50 500 0% 240 48%
Glass 1 X2 400 150 30 200 20 400 0% 190 48%
Glass 1 X3 250 50 20 150 80 250 0% 120 48%
Glass 1 X4 750 650 50 100 0 150 80% 0 80%
Glass 1 X5 500 490 0 0 0 10 98% 0 98%
150 1310 550
No issues with getting this information
Particulars Explanation Qty
Total Available Qty is Information at the Supply Location 700
To be sent to serve Orders Sumation of Col H 150
Available for Standard Total - to be send against order 550
Req to serve standard 1310