Would Appreciate Some Experienced Eyes

I have been working on this database for several months now - in between all of the other jobs I am responsible for - using what I've learned from this forum, from the 'Access 2002 Bible', and lots of hit-and-miss, restarts and frustration. I may have OVER normalized . . .
I'm running into trouble creating the reports I want, and have now learned enough to think I may need to create a 'fresh' database with what I know now. Before I do, I would appreciate some experienced eyes that will see what mistakes I have made and how I can improve this database before copying mistakes and taking it further.

Background: I was asked to create a database to replace an outdated and undocumented dBase program to keep track of our cost of goods and recipe base. We manufacture waste water treatment chemicals, primarily for municipalities. Each of our products is a recipe containing various raw materials in differing amounts. One concern I have is that some of our end-product recipes are also raw materials used to create other products. I may be able to enter each one as both an ingredient and a finished product as each will be assigned a different primary key.

We need to be able to create reports that tell us how much a specific recipe costs to make in various quantities, a printed 'recipe' listing each ingredient, amount, product type, etc. as well report groups on each product type. I plan to change the raw materials cost every time a new shipment of raw materials comes in using an update query.

Thank you in advance for any direction you can give. I am an Access newbie, but I am willing to do the homework!

And if I am very lucky, maybe Doc will give it a look?!
Pam