Logistics Performance Monitoring through Dashboard Implementation: A Case Study from CAREL Industries

This thesis investigates the analysis and visualization of transport costs within the different plants of CAREL S.p.A., with the aim of developing a structured and data-driven approach to logistics performance monitoring. The work focuses on the design and implementation of three interconnected dashboards that support decision-making processes related to transport expenses. The first dashboard focuses on import costs from China to the main manufacturing plant (CID). The second extends the analysis to import costs from China for additional plants (CRO, CSZ, CBR/CSA, CUS). The third dashboard provides a comprehensive overview of all plants, including import, export, other logistics costs, and turnover. The analyses were conducted using internal documentation, which was processed and modeled through advanced Excel-based procedures to generate dynamic and interpretable dashboards. These visual tools allow the identification of trends, anomalies, and variations in transport costs across different modes and periods, providing a detailed understanding of the factors driving cost increases or reductions. They also enable the assessment of logistics performance, support data-driven decision-making, and guide strategic initiatives aimed at optimizing transport operations and reducing overall costs.