Implementation of Inventory and Sales Control In a Gift Shop
page thumbnail
PDF (Portuguese (Brazil))
HTML (Portuguese (Brazil))

Keywords

Inventory control
Microenterprises
Sales
Excel

Categories

How to Cite

DA SILVA, Matheus Felipe Ribeiro; MARTINELLI, Murilo Bordignon; TORRES, Vitor de Melo Alves; LENHARO, Marcelo Eduardo. Implementation of Inventory and Sales Control In a Gift Shop. Atena-FGP Scientific Journal, Pederneiras-SP, Brasil, v. 1, n. 1, p. 32, 2025. DOI: 10.29327/2800502.1.1-2. Disponível em: https://revista.fgp.edu.br/pkp/index.php/ATENAFGP/article/view/4. Acesso em: 17 nov. 2026.

Abstract

In the search for greater work efficiency, companies must pay attention to important details to reduce costs and increase market competitiveness. The management and control of inventory and sales aim to organize and keep the products available, as they constitute a large part of a company's financial assets and carelessness can generate losses. The objective of this work, therefore, is to analyze the current situation of stock control and sales at the Cia dos Presentes Store and propose a stock and sales management system through Excel spreadsheets, to solve the day-to-day difficulties of the company. Through bibliographical research, this article is exploratory and theoretically grounded. In the case study, it was pointed out that when you do not have a well-structured plan to control the needs of the company, it can lead to several problems, shortages of products due to lack of control of inputs and outputs, loss of products due to lack of organization, among others. Thinking about it, the solution was to switch to a computerized system, concluding that with simple actions, with low investment, important tools are created that can produce satisfactory results to remain competitive in the market and achieve significant economic results.

PDF (Portuguese (Brazil))
HTML (Portuguese (Brazil))

References

BALLOU, R. H. Gerenciamento da cadeia de suprimentos: logística empresarial. 5ª. ed. Porto Alegre: Bookman, 2006. Disponível em: https://redeprocursos.com.br/docs/T%C3%89CNICO%20EM%20LOG%C3%8DSTICA/Logistica%20Ballou.pdf. Acesso em: 12 set. 2022

DIAS, M. A. P. Administração de materiais: uma abordagem logística. 4ª. ed. São Paulo: Atlas, 1993.

MACHADO, J.F. Baia do conhecimento. Página inicial. Como surgiu o controle de estoque. Disponível em: https://baiadoconhecimento.com/biblioteca/conhecimento/read/334538-como-surgiu-o-controle-de-estoque Acesso em: 17 set. 2022.

PESSOA, S. F.; LOOS, M. J. O uso de planilhas para controle de estoques em uma empresa do ramo de alimentos. Espacios, Caracas, ed. 38, ano 2017, n. 18, p. 30-45, Anual. Disponível em: https://www.revistaespacios.com/a17v38n18/a17v38n18p30.pdf. Acesso em: 22 set. 2022.

POZO, H. Administração de recursos materiais e patrimoniais: uma abordagem logística. 2ª ed. São Paulo: Atlas, 2002.

VIANA, J. J. Administração de materiais: um enfoque prático. São Paulo: Atlas, 2006.

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright (c) 2025 Atena-FGP Scientific Journal