Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise

Miñan Olivos Guillermo Segundo; Pulido Joo Luis Alexander; Castillo Martínez Williams Esteward; Pacheco Carranza Elizabeth Mariella; Cardoza Sernaque Manuel Antonio

Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise

Miñan Olivos Guillermo Segundo
, Pulido Joo Luis Alexander
, Castillo Martínez Williams Esteward
, Pacheco Carranza Elizabeth Mariella
, Cardoza Sernaque Manuel Antonio

Producción científica: Capítulo del libro/informe/acta de congreso › Contribución a la conferencia › revisión exhaustiva

Resumen

The objective of this research was to design an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. Therefore, the research had a qualitative approach and a descriptive scope. Likewise, the research can be considered as applied research while the study design was cross-sectional. The study population was structured considering all the company's processes. The sample was represented by the company's critical processes; accordingly, the production and sales processes were selected by applying a non-probabilistic convenience sampling. As part of the results, a tool was designed in Microsoft Excel based on the use of tables, macros, Microsoft Visual Basic for Applications and dynamic tables. This tool makes it possible for the company to control its daily operations by counting liters produced and sold in their different presentations (drums, plastic bottles and glass bottles). Likewise, a quality control of the batches produced could be carried out by measuring parameters such as PH, chlorine, T.D.S. (Total Dissolved Solids) and attributes such as appearance and flavor. Finally, it was concluded that an office automation tool would allow the application of business intelligence in a Peruvian water bottling microenterprise.

Idioma original	Inglés
Título de la publicación alojada	Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology
Subtítulo de la publicación alojada	Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023
Editores	Maria M. Larrondo Petrie, Jose Texier, Rodolfo Andres Rivas Matta
Editorial	Latin American and Caribbean Consortium of Engineering Institutions
ISBN (versión digital)	9786289520743
Estado	Publicada - 1 ene. 2023
Publicado de forma externa	Sí
Evento	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 - Buenos Aires, Argentina Duración: 19 jul. 2023 → 21 jul. 2023

Serie de la publicación

Nombre	Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology
Volumen	2023-July
ISSN (versión digital)	2414-6390

Conferencia

Conferencia	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023
País/Territorio	Argentina
Ciudad	Buenos Aires
Período	19/07/23 → 21/07/23

ODS de las Naciones Unidas

Este resultado contribuye a los siguientes Objetivos de Desarrollo Sostenible

ODS 8: Trabajo decente y crecimiento económico
ODS 9: Industria, innovación e infraestructura

Otros archivos y enlaces

Enlace a la publicación en Scopus

Citar esto

Segundo, M. O. G., Alexander, P. J. L., Esteward, C. M. W., Mariella, P. C. E., & Antonio, C. S. M. (2023). Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. En M. M. Larrondo Petrie, J. Texier, & R. A. R. Matta (Eds.), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023 (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July). Latin American and Caribbean Consortium of Engineering Institutions.

Segundo, Miñan Olivos Guillermo ; Alexander, Pulido Joo Luis ; Esteward, Castillo Martínez Williams et al. / Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. editor / Maria M. Larrondo Petrie ; Jose Texier ; Rodolfo Andres Rivas Matta. Latin American and Caribbean Consortium of Engineering Institutions, 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

@inproceedings{ca1e7cc40e5b4d91855322871d4e25f6,

title = "Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise",

abstract = "The objective of this research was to design an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. Therefore, the research had a qualitative approach and a descriptive scope. Likewise, the research can be considered as applied research while the study design was cross-sectional. The study population was structured considering all the company's processes. The sample was represented by the company's critical processes; accordingly, the production and sales processes were selected by applying a non-probabilistic convenience sampling. As part of the results, a tool was designed in Microsoft Excel based on the use of tables, macros, Microsoft Visual Basic for Applications and dynamic tables. This tool makes it possible for the company to control its daily operations by counting liters produced and sold in their different presentations (drums, plastic bottles and glass bottles). Likewise, a quality control of the batches produced could be carried out by measuring parameters such as PH, chlorine, T.D.S. (Total Dissolved Solids) and attributes such as appearance and flavor. Finally, it was concluded that an office automation tool would allow the application of business intelligence in a Peruvian water bottling microenterprise.",

keywords = "Macros, Microsoft Excel, Visual Basic, business intelligence, microenterprise",

author = "Segundo, \{Mi{\~n}an Olivos Guillermo\} and Alexander, \{Pulido Joo Luis\} and Esteward, \{Castillo Mart{\'i}nez Williams\} and Mariella, \{Pacheco Carranza Elizabeth\} and Antonio, \{Cardoza Sernaque Manuel\}",

note = "Publisher Copyright: {\textcopyright} 2023 Latin American and Caribbean Consortium of Engineering Institutions. All rights reserved.; 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 ; Conference date: 19-07-2023 Through 21-07-2023",

year = "2023",

month = jan,

day = "1",

language = "English",

series = "Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology",

publisher = "Latin American and Caribbean Consortium of Engineering Institutions",

editor = "\{Larrondo Petrie\}, \{Maria M.\} and Jose Texier and Matta, \{Rodolfo Andres Rivas\}",

booktitle = "Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology",

}

Segundo, MOG, Alexander, PJL, Esteward, CMW, Mariella, PCE & Antonio, CSM 2023, Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. En MM Larrondo Petrie, J Texier & RAR Matta (eds.), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology, vol. 2023-July, Latin American and Caribbean Consortium of Engineering Institutions, 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023, Buenos Aires, Argentina, 19/07/23.

Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. / Segundo, Miñan Olivos Guillermo; Alexander, Pulido Joo Luis; Esteward, Castillo Martínez Williams et al.
Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. ed. / Maria M. Larrondo Petrie; Jose Texier; Rodolfo Andres Rivas Matta. Latin American and Caribbean Consortium of Engineering Institutions, 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July).

Producción científica: Capítulo del libro/informe/acta de congreso › Contribución a la conferencia › revisión exhaustiva

TY - GEN

T1 - Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise

AU - Segundo, Miñan Olivos Guillermo

AU - Alexander, Pulido Joo Luis

AU - Esteward, Castillo Martínez Williams

AU - Mariella, Pacheco Carranza Elizabeth

AU - Antonio, Cardoza Sernaque Manuel

PY - 2023/1/1

Y1 - 2023/1/1

N2 - The objective of this research was to design an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. Therefore, the research had a qualitative approach and a descriptive scope. Likewise, the research can be considered as applied research while the study design was cross-sectional. The study population was structured considering all the company's processes. The sample was represented by the company's critical processes; accordingly, the production and sales processes were selected by applying a non-probabilistic convenience sampling. As part of the results, a tool was designed in Microsoft Excel based on the use of tables, macros, Microsoft Visual Basic for Applications and dynamic tables. This tool makes it possible for the company to control its daily operations by counting liters produced and sold in their different presentations (drums, plastic bottles and glass bottles). Likewise, a quality control of the batches produced could be carried out by measuring parameters such as PH, chlorine, T.D.S. (Total Dissolved Solids) and attributes such as appearance and flavor. Finally, it was concluded that an office automation tool would allow the application of business intelligence in a Peruvian water bottling microenterprise.

AB - The objective of this research was to design an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. Therefore, the research had a qualitative approach and a descriptive scope. Likewise, the research can be considered as applied research while the study design was cross-sectional. The study population was structured considering all the company's processes. The sample was represented by the company's critical processes; accordingly, the production and sales processes were selected by applying a non-probabilistic convenience sampling. As part of the results, a tool was designed in Microsoft Excel based on the use of tables, macros, Microsoft Visual Basic for Applications and dynamic tables. This tool makes it possible for the company to control its daily operations by counting liters produced and sold in their different presentations (drums, plastic bottles and glass bottles). Likewise, a quality control of the batches produced could be carried out by measuring parameters such as PH, chlorine, T.D.S. (Total Dissolved Solids) and attributes such as appearance and flavor. Finally, it was concluded that an office automation tool would allow the application of business intelligence in a Peruvian water bottling microenterprise.

KW - Macros

KW - Microsoft Excel

KW - Visual Basic

KW - business intelligence

KW - microenterprise

UR - https://www.scopus.com/pages/publications/85172337071

M3 - Conference contribution

AN - SCOPUS:85172337071

T3 - Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology

BT - Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology

A2 - Larrondo Petrie, Maria M.

A2 - Texier, Jose

A2 - Matta, Rodolfo Andres Rivas

PB - Latin American and Caribbean Consortium of Engineering Institutions

T2 - 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023

Y2 - 19 July 2023 through 21 July 2023

ER -

Segundo MOG, Alexander PJL, Esteward CMW, Mariella PCE, Antonio CSM. Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise. En Larrondo Petrie MM, Texier J, Matta RAR, editores, Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. Latin American and Caribbean Consortium of Engineering Institutions. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

Design of an office automation tool to apply business intelligence in a Peruvian water bottling microenterprise

Resumen

Serie de la publicación

Conferencia

ODS de las Naciones Unidas

Otros archivos y enlaces

Huella

Citar esto