How can we run FIFO Inventory in excel?

N

NH

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

How that can be solved in excel?
 
P

Pecoflyer

NH;254681 said:
To calculate exact work in progress, I need to run FIFO issuances fro
my
purchases.

How that can be solved in excel?
Click to expand...

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
 
G

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.
 
Top