How can we run FIFO Inventory in excel?

[NH]

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

How that can be solved in excel?

 

[Pecoflyer]

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

How that can be solved in excel?

Could you elaborate a bit more about what you want XL to achieve

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Gary Brown]

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.