Methodology for inventory risk analysis and management using excel and visual basic modeling

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 aims 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 responses, according to the concepts established within the organization. To achieve this objective, a field research was carried out with small and medium-sized companies in the city of Manaus, Amazonas. The research is classified as experimental, allowing the achievement of qualitative type results. The use of the proposed tools will be available to academic circles and the result of the study will be used to improve the quality of information and data speed, whenever necessary, for management decision-making. It is also expected that this research will contribute to foster discussion about the proposed theme and serve as a technical-theoretical framework for practical application for users and programmers in Solver and VBA tools.