I need your help to automate a long manual activity which takes allot of time. Every week I have received stock transfer requests of 500 line items from Warehouse#2 and WH#3 to replenish the stock from WH#1 which is over central Warehouse to feed both locations. Below are certain conditions to make my decisions.
1-WH1 is our central warehouse which will feed to WH2 & WH3
2-If WH1 has current stock > its monthly sales average only than it can feed to WH2-3
3-If WH1 has current stock = 30 days of its monthly sales average and WH2-3 has < 7 days of stock then WH1 can feed them for the minimum to survive till the stock reflecting in Intransit stock reaches to WH1-2 which takes 20 days.
4-Max replenishment to WH2-3 is allowed upto avg.monthly sales of WH2-3 means up-to 1 month replenishment only
5-If WH2and3 is asking for > its monthly sales then comments "Enough stock" populated in column N and O
6-If WH1 can not full fill the request from WH2and3 and In transit stock = 0 then comments in column N and O "order required"
7-If WH1 has only limited stock which can fulfill either WH2 or WH3 then priority will be given to those who has more fewver days of stock to survive or split to both with minimum possibility
Image is attached to give you more understanding.
Thanks in advance
Aucun commentaire:
Enregistrer un commentaire