In this video I explain FIFO, LIFO and average cost methods to value the stocks stored by a company, to estimate the cost of goods sold and to determine the commercial result (profit or loss) of the firm: ruclips.net/video/mOM1Lqqydos/видео.html.
Hello @CostViewer, Do you have a template for one product (LIFO)? In your LIFO (LIFO MODEL NO VBA version 21) file there is the same sheet for one product that you use in FIFO file.
Sir, could you please help it by using multiple products i have seen a video on multiple products but it has no dates in it kindly help it so that i just enter the sale and it automatically minus the first date and gives the result
Hi, well... so far I've managed to compress the model so we can do without technical columns G and H and today I've started working on multiple items. Certainly this challenge is not an easy one! :-)
I have some great news! I have built a model which handles multiple SKUs!!! It also calculates inventory with split by SKU's different price. I plan to upload the file this week! 😀
In this video I explain FIFO, LIFO and average cost methods to value the stocks stored by a company, to estimate the cost of goods sold and to determine the commercial result (profit or loss) of the firm: ruclips.net/video/mOM1Lqqydos/видео.html.
Thanks - this is very helpful! I'm looking forward to the updated one with multiple products! :)
look out for such model, to be uploaded this weekend! 😀
Aural Angst
such model will be available this weekend!!! and there is some bonus coming up with it!
Thank you so much! This was exactly what I needed.
Thank you very much. It was very useful.
Very impressive formula. Could you explain the formula for the "Usage Value" (column J)? Thank you.
Thanks 👍 really helpful and simple sheet
Thanks sir, how can I download the file? I can find it in your website.
Thank you sir . This is very generous of you !
Thank you very much ! Very helpful
Thank you very much, this was very helpful for me.
Can you please share the FIFO for multiple products. thank you😊
follow the link above :-)
This is the best FIFO on excel, What exactly the Technical Columns about? what is the basic concept.
Hello @CostViewer,
Do you have a template for one product (LIFO)? In your LIFO (LIFO MODEL NO VBA version 21) file there is the same sheet for one product that you use in FIFO file.
Thanks , that's what I was looking for it , but what is the problem with the 9 number , and is there any number else like 9 num
is there some way to use this method for different variety of goods.
gaurav agarwal
look out for such model, will be uploaded this weekend
Sir, could you please help it by using multiple products i have seen a video on multiple products but it has no dates in it kindly help it so that i just enter the sale and it automatically minus the first date and gives the result
Hello Baloch, I'm sorry but I am not sure if I understand the request.
Sir, could you show the formula in the Row 9 & 10 please.
You can download the file from:
costviewer.com/en/do-pobrania
this need to be enhanced by storability as a criteria for the goods. :)
please show about Different items.. I'm working with 300 different items manually
Hi, well... so far I've managed to compress the model so we can do without technical columns G and H and today I've started working on multiple items. Certainly this challenge is not an easy one! :-)
Pawel Rozkrut please also share with me
I have some great news! I have built a model which handles multiple SKUs!!! It also calculates inventory with split by SKU's different price. I plan to upload the file this week! 😀
Pawel Rozkrut u can u do it earlier plx? I need that very badly.... please do share with me I can test for u as well
I will try to upload manual tomorrow. Will try but cannot guarantee.