FIFO calculation with Excel Data Table

FIFO calculation with Excel Data Table(Inventory ID is selectable in this sample) Table C6:E15 keeps inventory inward data for all inventory id ordered by its occurrance.Cell H2 is total unit sold of inventory id that selected in cell H3.Table F6:F15 calculates number of unit sol

FIFOmixed.xlsx
 
 
 
 
 
(5)
4,979 times
Add to favorites
Office
9/15/2012
E-mail Twitter del.icio.us Digg Facebook