Modelo de análisis de riesgo térmico en el transporte de mercancía química para Hilti

Abstract

During the internship conducted in the logistics department of Hilti Colombia, it was observed that, despite having a temperature control file for chemical shipments, this system does not allow for the automatic detection or evaluation of potential thermal risk situations or the examination of trends. For this reason, the development of a thermal risk analysis model, created in Excel, is suggested, which converts manual recording into an analytical tool. This model is capable of automatically identifying whether there has been exposure to extreme temperatures (whether hot, cold, or variable temperatures), identifying the cities and periods with the highest risk frequency, and classifying the risk level by shipment. Implementing the model will enable preventive decisions, improve regulatory compliance, and reduce the likelihood of damage to products sensitive to temperature variations. The proposal adapts to the company's available resources and can be integrated with the current archive, offering not only a functional, visual, and easy-to-understand system, but also an innovative, practical improvement consistent with the principles of continuous improvement and logistics quality.