Inventory tracker

Job ID: 33939109

Budget: $750 – $1,500 USD

I need an excel and coding guru to analyze my current vision of tracking inventory in a very busy pharmacy. We only produce one product that needs tracking. I would like to automate excel sheets that are able to be exported from our pharmacy software that has the number of products dispensed, need barcodes for prescriptions that were made during a day to ADD to the inventory sheet easily, need to connect both sheets to perpetually track the number of products in stock. I also would like a way to predict what products should be made in order to anticipate the required stock to be able to fulfill the prescriptions for x amount of days.