How can we run FIFO Inventory in excel?

's Computer Specifications

To calculate exact work in progress, I need to run FIFO issuances from my
purchases.

How that can be solved in excel?

's Computer Specifications

ASSUMING you have data with the following elements...
Date Item Received
Item #
Price/Unit
Quantity Received
Quantity Relieved
Balance

You can create a pivot table on Item #/Balance.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

"NH" wrote:

> To calculate exact work in progress, I need to run FIFO issuances from my
> purchases.
>
> How that can be solved in excel?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to program FIFO inventory in excel ?	galih.chandra@gmail.com	Microsoft Excel Programming	5	22nd Sep 2006 07:20 PM
FIFO from inventory	gknapp	Microsoft Excel Misc	0	2nd Oct 2004 04:19 AM
FIFO from inventory	gknapp	Microsoft Excel Misc	0	30th Sep 2004 07:01 PM
FIFO from inventory	gknapp	Microsoft Excel Misc	1	30th Sep 2004 05:20 AM
INVENTORY FIFO	=?Utf-8?B?TkVORQ==?=	Microsoft Access	1	24th Sep 2004 07:32 PM