Otimização de processos e indicadores através de VBA e SAP Script, orientados a Agile e Lean

Abstract

This work presents as mainly purpose to provide a detailed vision of the automation strategies and management tools development using VBA language, applied in the case study of various process from the quality sector of an agricultural vehicle manufacturing industry which employs the SAP system. More specifically, it broaches the set composed by task automatization, quality management indicators creation, VBA-SAP communication and user interface, responsible for productivity gains in the different addressed steps. Finally, the project development was consolidated with Agile and Lean principles and guidelines, resulting in the gain of value maximization and consistency in the development and planning decision taking. Therefore, the project was structured with incremental and frequent releases, combined to necessity prioritization through factors as context and impact. At the end of the five releases of the main project and the two releases of the parallel opportunities, it was possible to reduce time invested in the activities estimated annually in 50 hours in Laboratory’s reports generation, 792 hours in Non-Conformance Bench task and 196 hours in the management of the Non-Conformance Items Warehouse, as well as quality improvement on management decisions through developed indicators and available data augment.