I'd agree with Bill. I sense that the underlying issue probably goes much deeper than just entering a few numbers into a spreadsheet.
Throwing caution to the wind though, I did just that...
It seems like a relatively basica accounting issue. I.e. keep track of how much you buy at what cost from what supplier so you can figure out an average cost per unit.
This example is probably far too simple, but there you go...
Programmer - An organism that turns coffee into software.
If all your friends are exactly like you, What an un-interesting life it must be.
"A door is what a dog is perpetually on the wrong side of" Ogden Nash