Stock Control made simple

Hi, I have a busy practice and have found stock control an issue, what would be useful is a XL spread sheet where I can list all my products and suppliers and load my stock purchase - then as others use these items the live stock held is shown and new orders can be made prior to running out - a number could be added in live stock to alert when it reaches that number ie. email / text etc. - then once new stocks are available the supply to others will be zero - this way I can achieve a better control of the many items we hold and the ability for me to view and act at anytime. Our other members would be encouraged to update as products are used but only admin will be able to update the stock. This will save so much time and keep a better control of stock .