Finance 3.0 - Social Network for Finance
Smart financial thinking
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:
-
-
FIFO (without UDF).xls, 58 KB
-
Replies to This Discussion
-
Permalink Reply by Sachidanand (Sacha) Singh on -
Great job; thanks for sharing it.
-
Permalink Reply by ANS Rao on -
The spreadsheet is very nice:
Thanks
This is the google-translation of the comment in cell b10
already in the mix just the price of the stock purchase price beginning with the newly purchased, in accordance with the use of the stock portion of the goods last month with new-bought goods. Tp can not count stock purchased 3 months ago, only 1 or 2 months ago
-
Permalink Reply by hendry yonathan on -
ah this one... this comment should have been deleted by me. its no longer valid... sorry for the inconvenience....
-
Permalink Reply by Kamran Ahmed on
-
well i dont understand it
-
Permalink Reply by Carel Venter on -
Thanks. Great spreadsheet.
To enhance ease of use:
I updated your 1st line (Beginning Inventory) with a formula
Highlighted cells where info needs to be submitted by user
Protected the rest of the sheet (to eliminate risk of overwriting formulas). There is no password for the sheet protection - just unprotect if you want to edit. - Attachments:
-
-
FIFOwithoutUDF.xls, 65 KB
-
-
Permalink Reply by Oladipupo Oluwasanmi on
-
Henry,
Great Job. i will navigate the sheet and let you have my inputs if need be.
-
Permalink Reply by Sunder R Chava on -
Great Job. I am going to share it with my friends. Very innovotive.
-
Permalink Reply by hendry yonathan on
-
Hai there everyone! thanks for the comments... well let's forget about the comment in cell b10 because it was made before i could make this FIFO calculation.... hehe... i should have deleted the comment...
-
Permalink Reply by hendry yonathan on
-
okay.. no more comment in cell b10. i deleted it. hehe..
-
Permalink Reply by Khair Muhammad on -
Thanks for it. waiting for others
-
Permalink Reply by Muhammad Jawad Azam on -
Hi,
You all, this is really a very informative Spread sheet for excel user it'll provide lote of information regarding Inventory control system.
Dear All.
I am requesting to you all that if you have Cost Analysis on Spread Sheet plz do let me know because i am doing a Job in Cost Management & i need these material, Please if any one have this material forward me.
Your usual corporation will highly appriciated.
My personal mail ID is jawad_pk39@yahoo.com
Looking Forward
Muhammad Jawad Azam
Cupola Pakistan Limited
Cell # +92 0321 8810446
-
Permalink Reply by KEFA W. KIOGE on -
I love the worksheet!
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
