How can we run FIFO Inventory in excel?

  • Thread starter Thread starter NH
  • Start date Start date
N

NH

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

How that can be solved in excel?
 
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.
 
Back
Top