METHODOLOGY FOR INVENTORY RISK ANALYSIS AND MANAGEMENT USING EXCEL AND VISUAL BASIC MODELING
Item
-
Tipo do ITEM
-
Artigo Ciêntifico
-
Título do Artigo
-
METHODOLOGY FOR INVENTORY RISK ANALYSIS AND MANAGEMENT USING EXCEL AND VISUAL BASIC MODELING
-
Descrição
-
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 technicaltheoretical
framework for practical application for users and
programmers in Solver and VBA tools.
-
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 technicaltheoretical
framework for practical application for users and
programmers in Solver and VBA tools.
-
Língua do arquivo
-
inglês
-
Data da Publicação
-
Ano 2021
-
Palavra-chave
-
risk analysis
-
risk management
-
VBA
-
programming language
-
Autores
-
Aurélio Paulo Leandro
-
Simone da Silva
-
Manoel Henrique Reis Nascimento
-
Local
-
ITEGAM - Manaus, 2021
-
Áreas de Conhecimento
-
Energia e Meio Ambiente
-
Turma
-
Turma 01
