Inventory Software

I've been resarching and comparing various inventory software packages and wonder if anyone has any they can recommend.

Here is what I'm finding - lots of options that if I enter our initial quantity of a finished product, track the sales, will give me the current quantity, most with the option to print bar codes which wil reduce my bookkeeping time.  That's all that I originally thought I wanted in my inventory program, but my no, that's not enough, my husband has other ideas and that's where I'm stuck.

What I'm missing?  If I decide to create a production list, something that will tell me what quantity of raw materials I need.

For example, if there is a certain style of bracelet my husband makes that takes 30 grams of 16 guage sterling, 15 grams of 18 gauge, I want 3 of those in stock before our first show in March, I can't find a program that will give me the needed raw materials after we input our current quantity.

Now, I've previously built the production side of this into my spreadsheet but I don't have the first part of the inventory (beginning inventory, current inventory, etc) all built into that.

So, before I go through the effort of massively rebuilding my spreadsheet and testing my somewhat rusty Excel skills (especially with the Excel 2007 version), I was wondering if anyone had suggestions on a package they use?