• 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

    Hui...

  • 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

Y

yoosuf)_(2020

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.
 
yoosuf)_(2020
Please ... reread Forum Rules that You could get replies.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
 
yoosuf)_(2020
Did You reread Forum Rules?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
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?
 
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.
 
You must log in or register to reply here.
Back
Top