The advanced automation of inventory management for warehouse products at Tondguyan Petrochemical Company using VBA programming methods enhanced by Artificial Intelligence
The advanced automation of inventory management for warehouse products at Tondguyan Petrochemical Company using VBA programming methods enhanced by Artificial Intelligence
Moein Vatankhah1
1) Master s degree in chemical engineering, Amir Kabir University of Technology (Mahshahr Campus), Iran - Email:
IOI Code
:
XKBA-AZKKZG
Publication :
3rd International Conference on Recent Advances in Engineering, Innovation and Technology - Belgium(eitconf.com/3rd)
Abstract :
With the advent of automation technologies such as industrial robots and robotic process automation (RPA), warehouses have increasingly become automated, thereby reducing the need for manual operations. Under these circumstances, workers are freed up to focus more on strategic tasks. This not only reduces labor costs but also enhances workplace safety and minimizes the risk of accidents.
This article addresses process automation, data extraction, summarization, and presenting results in separate tables within Excel files using VBA (Visual Basic for Applications) programming methods enhanced by artificial intelligence. The proposed system automates calculations and compiles product inventory maps for the petrochemical warehouse. The warehouse maps, based on the registration of the physical inventory of products (categorized by their specifications and quantities every 24 hours), are part of the statistical documentation of the product warehouse and inspection units. These records are reviewed, summarized, and archived at the end of each day (24-hour period).
Implementing the proposed system results in a total reduction of approximately 3 hours in wasted time for relevant users per warehouse at Tondguyan Petrochemical Company. By automating these processes, tasks are performed without user intervention, with minimal errors, at maximum speed, and with significantly higher accuracy and comprehensiveness, including detailed reporting.
Studies show that implementing artificial intelligence systems in warehouses can double productivity. Consequently, automating the management of petrochemical warehouse inventory maps using VBA and artificial intelligence offers a comprehensive and practical solution for improving warehouse performance and reducing errors. This system not only simplifies and accelerates warehouse processes but also provides intelligent analytics that supports better decision-making within petrochemical companies.
Keywords : artificial intelligence programming automation warehousing petrochemical vba