Snasui Excel Forum

Hi Dear,

I got an issue how to write excel formula to calculate cost of sale using FIFO method.
Example; 10 sales were made for the E5. According to FiFo, first 5 of the purchases will be calculated from 10 in C2... the remaining 5 will be calculated from 30 in C3... so selling cost for E5 (5*10)+(5*30)= 200....

Thanks

Please fill the correct value in target cell for another member easy to understand.

...

Hi Guy,

looks like your question does not match the example data information in sheet1 that you provided.


To further clarify about your question referring to "10 sales were made for cell E5".


A) What is the criteria or how could we know the first 5 of purchases will be calculated from 10 in C2…?

B) And then why the remaining 5 will be calculated from 30 in C3…?

Norkaz

Thanks for your all reply.In FiFo, the basic logic is always the product that is purchased first is sold. When the first purchase is finished, the other product is sold. .the negative amount is sale amount and positive amount is purchase one.
the results should be in column E.the narratives are in grey cells of how to get amount in column E.
What formula should I go?


Thanks in advance


Best wishes,

Please see the example in this link https://www.snasui.com/viewtopic.php?st ... 82#p109448.

Thank you