First-In, First-Out Inventory Database

forgive my ignorance, but what are you looking for in your breakdown? can you post using Colo's HTML maker (link on bottom of page)

hi!
Just a question.
What would be the unit price in this line
where in 21 units has been delivired 10+5+6
and 6 has been consumed?
It is obvious that this has mixed price per unit. thus
I think requires another row to fully show the how much this
cost for this month.
Thus averaving the price will do for this situation where the
overall price for one month will still be eqaul?

Thank you for your replies. Sorry if I was a little bit unclear about my case. Also there'san error when i try to install the add in from COLO HTML maker. I'll try to elaborate it further.

First In, First Out
Date Type Tanks Unit Price Amount
01/01/04 Delivery 10 1,210.00 12,100.00
01/05/04 Delivery 5 1,220.00 6,100.00
01/06/04 Consumed -6 -
01/10/04 Delivery 6 1,210.00 7,260.00
01/12/04 Consumped -8 -
01/15/04 Delivery 20 1,240.00 24,800.00
01/17/04 Consumped -12 -
01/20/04 Delivery 5 1,250.00 6,250.00

Balance 20


Let's say my boss ask me, "From what delivery batches did you get the consumption (8 tanks) last 01/12/04?
Give me the delivery batches, unit cost, and the total amount."

My manual method would be:
01/01/04 delivery 10 1,210.00 12,100.00
less 01/06/04 consumed -6 1,210.00 (7,260.00)
Bal 01/01/04 delivery 4 1,210.00 4,840.00
add 01/05/04 delivery 4 1,220.00 4,880.00
8

Then, he also asked me, "What is the breakdown for the inventory balance?"

I have to manually trace the deliveries first to come up with the answers:
Balance Breakdown of the 20 tanks:
01/20/04 delivery 5 1,250.00 6,250.00
01/15/04 delivery 15 1,240.00 18,600.00
20

Is there a way to manage the database so I can come up with the answer quickly without doing much analyzing of my data?
ray:

Your totals of your breakdowns don't jive with your data????

01/20/04 delivery 5 1,250.00 6,250.00
01/15/04 delivery 15 1,240.00 18,600.00

Data above that reads:

01/15/04 Delivery 20 1,240.00 24,800.00
01/20/04 Delivery 5 1,250.00 6,250.00

I am unclear how you can compare units when the unit prices are different each delivery also. Can you elaborate some more on this???
Ken

Sorry to got you confused.

The breakdown of 20 tanks came from the latest delivery batches. Using the first in first out method of inventory the 20 tanks came from:


delivery batch dated 01/20/04 5 tanks @1,250.00/tank total=6,250.00

and

delivery batch dated 01/15/04 15 tanks (out of the 20 tanks delivered) @1,240.00/tank total = 24,800.00


Hope i made it clear this time.

Hi Rommelq!
Is this the breakdown you want?
The computation of the cost of the consumtion can be automated thru a UDF.
See Fifo row if the above procces is the rigth computation proccess you want.

Hi!

Is this a correct balance sheet? I tried my fifo UDF here if this
is the corect computation you want!

Sixth Sense,

You are correct! You got the balance of the inventory using the FIFO method. And only the automated presentation of the breakdown that is left. You mentioned a UDF? What is it?

Hi!
UDF means USER DEFINED FUNCTION . this is a code in VB that
that is tailored for your need. In other words this is a costumized function. I just forgot to post it. Ill look for it and post later.