Isn't that an accounting issue. There are software packages designed to
handle inventory that will do the job. It becomes complicated to take each
sales and match it against the first In. It can be done.

I had a similar problem where a person owned a gas station and was trying to
figure the value of his gas inventory on a daily bases.

If you have a column in your spreadsheet for the remaining quantity and the
purchase price then the problem is simply a worksheet probelm. You multiply
the quantity times the price to get the total. Then have a grand total the
sums all the individual totals.

"Kelvin" wrote:

I have different lot of products imported with different unit costs, how can
I calculate the unit cost of inventory held based on First in First out
basis. Please help!