I am trying to create a FIFO schedule in Excel. I am trying to determine the
best formula to remove inventory based on FIFO. So, for instance, I have 5
layers of inventory all with different costs. On the sales side, I want to
chew into the first layer first, however if the sales is greater than the
inventory in the first layer, I need to go to the second layer and so forth.
Anyone have any good formulas for setting up a schedule like this? Or point
me in the right direction....Thanks!