ASSUMING you have data with the following elements...
Date Item Received
Item #
Price/Unit
Quantity Received
Quantity Relieved
Balance

You can create a pivot table on Item #/Balance.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"NH" wrote:

To calculate exact work in progress, I need to run FIFO issuances from my
purchases.

How that can be solved in excel?