Hi,
Kindly help to create formula in excel which will allocate stock in column E based on Manufacturing date (Based on Manufacturing Rank) SKU wise (Table : Stock In Hand) to Orders SKU wise (Table : Order In Hand) based on each order booked date (Based on Booked Rank).
Quantity required to be subtracted from On hand Quantity, column L, each time stock is allocate to respective order.
For example :
For Chair with Booked Rank =1 (Row No. 7 - Order In Hand Table), Ordered quantity = 60
From Stock In Hand Table, stock of Chair with Manufacturing Rank = 1, Stock Quantity = 50,
needs to allocated, but 10 units are less to fulfilled the order,
so remaining 10 units can be taken from stock of Chair with Manufacturing Rank = 2 with 60 units,
and remaining 50 units of hair with Manufacturing Rank = 2 can be allocated to Chair with Booked Rank =2.
Kindly help to create formula in excel which will allocate stock in column E based on Manufacturing date (Based on Manufacturing Rank) SKU wise (Table : Stock In Hand) to Orders SKU wise (Table : Order In Hand) based on each order booked date (Based on Booked Rank).
Quantity required to be subtracted from On hand Quantity, column L, each time stock is allocate to respective order.
For example :
For Chair with Booked Rank =1 (Row No. 7 - Order In Hand Table), Ordered quantity = 60
From Stock In Hand Table, stock of Chair with Manufacturing Rank = 1, Stock Quantity = 50,
needs to allocated, but 10 units are less to fulfilled the order,
so remaining 10 units can be taken from stock of Chair with Manufacturing Rank = 2 with 60 units,
and remaining 50 units of hair with Manufacturing Rank = 2 can be allocated to Chair with Booked Rank =2.