G
Gerry
Sorry, put this in wrong newsgroup originally.
I'm trying to set up a workbook that shows the cost of fuel sold each
day. This has to be taken from the inventorly levels and use the
correct price, using FIFO.
Column A is the running total of purchases(litres). Column B is Daily
purchases(litres), Column C is cost per litre and Column D is litres
sold daily. In column E, I would like to show the actual cost per litre
for the litres sold daily.
Running Total Purchases Cost Litres Sold Cost
of Litres Sold
6000(on hand) 0.895 4000
0.895
9000 3000 0.925 4000
0.910(this would be a combination of the 2 costs)
12500 3500 0.950 1000
0.925
12500
2000 0.950
TIA
Gerry
Reply
I'm trying to set up a workbook that shows the cost of fuel sold each
day. This has to be taken from the inventorly levels and use the
correct price, using FIFO.
Column A is the running total of purchases(litres). Column B is Daily
purchases(litres), Column C is cost per litre and Column D is litres
sold daily. In column E, I would like to show the actual cost per litre
for the litres sold daily.
Running Total Purchases Cost Litres Sold Cost
of Litres Sold
6000(on hand) 0.895 4000
0.895
9000 3000 0.925 4000
0.910(this would be a combination of the 2 costs)
12500 3500 0.950 1000
0.925
12500
2000 0.950
TIA
Gerry
Reply