The earlier version of Beersmith "bit me" when I tried to "remove from inventory" when an ingredient was missing. Therefore, I gave up on beersmith for inventory. I created a spreadsheet seen here: http://i52.tinypic.com/2cgbos1.jpg
Apparently the new version of beersmith handles inventory better.
As for ordering, I always order 5 lbs of specialty malts, and I order them when my normal amount used is not in stock anymore. I'm going to update that spreadsheet to figure out avg use, max/min use and may be do color formatting.
Let me know if you want that spreadsheet.