Práctica empresarial para la realización de un plan de mantenimiento preventivo y un sistema automatizado para su gestión en la empresa de los angeles investment s.a.s.

Abstract

This degree project aimed to design and implement a preventive maintenance plan and an automated management system for De Los Ángeles Investment S.A.S. to improve the control, scheduling, and monitoring of maintenance activities for the company's assets. The methodology followed an applied approach and consisted of four stages: identifying and inventorying the company's equipment, defining maintenance tasks and frequencies based on technical criteria, operating conditions, and manufacturers' recommendations, developing a computerized maintenance management tool, and training the personnel responsible for its use. The project resulted in the creation of a comprehensive asset inventory, the establishment of preventive maintenance schedules with defined frequencies, and the development of an automated Microsoft Excel system using VBA programming to record maintenance activities, store historical data, and manage maintenance operations. In addition, an automated notification system was implemented through the integration of Google Sheets, Power Automate, and Telegram, enabling timely alerts for upcoming and overdue maintenance tasks. The results demonstrate that the automated system improves maintenance planning, organization, and traceability while reducing reliance on manual records and supporting more effective decision-making. Furthermore, it contributes to minimizing unexpected equipment failures, increasing asset availability, and improving fleet maintenance management. It is concluded that the implementation of the preventive maintenance plan and the automated management system provides an effective solution for enhancing the company's operational efficiency and establishes a solid foundation for future improvements in comprehensive asset management.