N NH Mar 4, 2009 #1 To calculate exact work in progress, I need to run FIFO issuances from my purchases. How that can be solved in excel?
To calculate exact work in progress, I need to run FIFO issuances from my purchases. How that can be solved in excel?
G Gary Brown Mar 4, 2009 #2 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.
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.