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

Authors

  • Aurélio Paulo Leandro
  • Simone da Silva
  • Manoel Henrique Reis do Nascimento

Keywords:

risk analysis, risk management, VBA, programming language

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.

Downloads

Published

2021-11-08

How to Cite

Leandro, A. P., Silva, S. da, & do Nascimento, M. H. R. (2021). Methodology for inventory risk analysis and management using excel and visual basic modeling. International Journal of Advanced Engineering Research and Science, 8(10). https://journal-repository.com/index.php/ijaers/article/view/4248