I need a spreadsheet Specialist

I am currently designing an inventory system for my business on Google Sheets. At the moment, I have a list of ingredients, a list of when each ingredient is received, and recipes. Each time something is produced, the ingredients are automatically removed from the current stock.

At the moment I need to add information on ingredient batches in such a way that, the current batch in use is registered for each ingredient, and whenever the business produces something, the information on current batches of each ingredient are saved