Implementación de una herramienta digital en App Sheet Aplicando la metodología Lean Six Sigma para la gestión de cotizaciones en Incontech S.A.S Ubicada en Villavicencio en el año 2026

Abstract

The objective of this project was to implement a digital tool in AppSheet, applying the Lean Six Sigma methodology, to optimize the management of the quotation process in the commercial area of Incontech S.A.S., a service-sector company located in Villavicencio. The identified problem revealed significant delays in the preparation and follow-up of quotations, as well as an increase in the percentage of rejected quotations, which rose from 6.32% to 65.99% over the past three years, affecting competitiveness and customer satisfaction. The research was conducted under a mixed-method approach, with an applied and descriptive design, using the DMAIC cycle (Define, Measure, Analyze, Improve, and Control). Throughout the different phases, Lean Six Sigma tools such as SIPOC, Pareto diagram, cause-and-effect diagram (Ishikawa), 5S methodology, and the A3 analysis sheet were used to identify and prioritize the root causes of the problem, mainly associated with rework, unproductive time, and lack of standardization in the commercial process. As a result, an AppSheet application was implemented to digitalize and automate the quotation management process, integrating intelligent forms, a centralized database, traceability, and real-time tracking. The proposal significantly reduced response times, facilitated access to information, standardized the workflow, and improved internal communication among the involved areas. Quantitatively, a 91.11% reduction in the average cycle time and a 76.92% decrease in errors were achieved, along with the complete elimination of pricing-related issues and full automation of process activities. It is concluded that technological integration based on Lean Six Sigma principles enhances operational efficiency and promotes continuous improvement in administrative processes within service companies.