creating an inventory control in excel

I work for mercedez benz in production. We are facing one problem in production and we are trying to build up barcode scanned system in excel. we will have the data of the quantity of the parts scanned using barcode scanner. we want a excel system which will show the daily targets will get achieved or not. For example-Part A is scanned 43 times it means that 43 parts are machined. but the target is 50 so we are lagging by 7 more parts. such kind of system we want which will show the details. I will be very thankful to you if you guide me regardig this

                                                                   thanking you.         

By: Kaustubh samant

Leave a Reply

Your email address will not be published. Required fields are marked *