Finance 3.0 - Social Network for Finance

Smart financial thinking

hendry yonathan

FIFO in Excel (without User Defined Formulas)

Hi Guys... Lately i just figured out how to calculate FIFO in excel WITHOUT ANY UDF (user defined formula)!!! I came up with this discussion since when i searched how to make FIFO calculation in Excel and www.mrexcel.com answered that i should use UDF (i didnt master UDF), so i want to share here.....

The logic is very simple, just make a table, put the sales in the first row and the purchase in the first column.... then, using IF formula in between.... finally i used SUMPRODUCT to generate the COGS....

i will upload the excel soon...

Tags: code, cost, excel, fifo, in, inventory, lifo, mixed, no, udf.

Attachments:

Reply to This

Replies to This Discussion

Hi Hendry

Thanks! good spreadsheet. Will test and get back you if needed.

Aman

Reply to This

Great work Hendry,

Special recognition on your neat and compact design.

Thanks for sharing.

Olivier

Reply to This

Hi Can you send the fifo excel seet which i feel can be of help for me because I am alos making a new excel for a small organization for inventory in excel sheet,my e mail id is pjk1322006@gmail.com

Reply to This

Hi, the spread sheet is really very nice, but i want to ask you if you can help me. I work in a restaurant and i want to use FIFO or weighted average model for the purchasing in the restaurant. i am not sure how exactly to creaste a spread sheet because i have so many items /tomatoes, fish , meat, coffe ........./and during the month i have purchase for them at different prices. So at the end of the month i have used some quantity of them but how to know the price for this quantity? I am really very confused

Reply to This

hi Violeta! well, i'm afraid you have to make a table for each item you valuate...

Reply to This

thank you

Reply to This

RSS

© 2010   Created by Finance 3.0.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!