Have you looked at the Stock Card report to answer some of these questions? Alternatively, you could dump the transactions for the item from History.