A Bar Stocktake spreadsheet can help you be more effective with your stocks. There are several other tools that you can use but you will not really get the whole picture in most cases, unless you use a very good spreadsheet. So, how do you do this?
db-excel.com
Excel Spreadsheet Template