vlookup, match/index ????

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: OT More change
    ... First sold out by the government. ... corporate greed.phasing out incandescent bulbs is the right thing to ... what makes you think it would only cost 50 cents more? ... I'd rather buy from the most efficient producer and help fund a program to make your neighbor an efficient producer of something. ...
    (rec.outdoors.rv-travel)
  • Re: OT More change
    ... First sold out by the government. ... corporate greed.phasing out incandescent bulbs is the right thing to ... are not producing any products at all? ... what makes you think it would only cost 50 cents more? ...
    (rec.outdoors.rv-travel)
  • Re: HA
    ... charge, the e.m.u. ... I can switch it to litres per km but then the display gives km per hour ... those goods were customarily sold in Imperial units, ...
    (uk.rec.waterways)
  • Re: Nu Wave oven
    ... the "goods sold". ... Cost of Goods Sold is an accepted accounting term. ... Direct marketing via tv ... You just trashed your own dumbass theory that products sold through direct marketing on TV are just junk being dumped at little profit via the most expensive means. ...
    (alt.food.barbecue)
  • Re: Cleaning basement concrete
    ... later once the home is sold the pine odor will fade. ... point can cost you BIG BUCKS. ... getting rid of stink:( ... about 10 grand, which hap[ppened to be over 10% of homes value, it was ...
    (alt.home.repair)