• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula for FIFO cost application


New Member
Dear , can anyone suggest me a formula that can help to apply the cost on FIFO basis, in the scenario the units are in liters, where the sales liters to apply the unit cost relevant on the FIFO basis, however there could be an instance where one sales could include two different unit cost applicable, as as the current stock alone wont be sufficient to complete the sales, thus there could be an application of two different unit cost as a proposition to the use of inventory, in this case an average cost become the unit cost.


Excel Ninja
Please ... reread Forum Rules that You could get replies.


Excel Ninja
Did You reread Forum Rules?
Especially How to get the Best Results at Chandoo.org

If You did - then You should know ... How to get the Best Results at Chandoo.org

If You did not - then You'll have two choices
a) reread that again
b) try to read You written long sentence and try to find out from that: what? how?

Peter Bartholomew

Well-Known Member
In general terms, FIFO calculations can be performed by accumulating the required flows, capping the balances, and differencing to recover the flows within the cap. Knowing the volume at each price point gives the result.

If you need a more specific reply, I suggest you follow @vletm 's advice.