Metodologia para Análise e Gerenciamento de Riscos de Estoque em Mercados de Pequeno Porte

Abstract

Visual Basic for Application (VBA) programming, when used in an Excel programming environment, is an important tool in determining inventory classification risks, as well as an excellent option in view of the current situation of scarcity of classification optimization assessment. inventory risks. This work has as objective to contribute to the development of programming for an application in VBA - Excel, with the ability to classify inventory risks, capable of delivering data and assertive answers, according to the concepts established within the organization. To achieve this objective, bibliographic research was developed in conjunction with a case study carried out with small and medium-sized companies in the city of Manaus, AM. The theoretical framework of the work is being developed in chapters, which addressed issues relevant to the theme and proposed objectives, such as: Inventory Management, Inventories, IT application in inventory management and VBA programming. In methodological terms, the research is classified as experimentalist, allowing the achievement of qualitative type results. The research results have been shown to be satisfactory in terms of achieving the objectives of developing a schedule for inventory risk classification, modeling and data compilation. It is hoped that this research can contribute to foster discussion about the proposed theme and serve as a technical-theoretical framework for practical application for users and programmers in the solver and VBA tools.