Hello,
I work for a manufacturing company who make rowing and sail boats.

I need to create an excel spreadsheet that allows us to enter all the inventory parts for a product, keep a count of those inventory parts, alert us when the inventory parts need to be reordered (we need to have enough in stock to fulfill orders) - also taking into account the time it takes for different inventory parts to arrive, and finally when a product is shipped we need to update the inventory count so that it's up to date.

So for example, when one product is bought the excel sheet subtracts all the parts from the inventory that were used to make the product, and when the number of parts reaches a certain level it alerts you to order more, so that there are always parts in stock to make up a product.

If anyone knows of a template or spreadsheet I can download which would do this for us I'd be very grateful. Thank you.