Automatización de reportes de productividad operativa de bookings en DSV air & Sea Colombia

Abstract

This improvement plan proposes implementing the Bookings Automated Productivity System (SAP-Bookings) at DSV Air & Sea Colombia, using Microsoft Power Automate, Excel, SharePoint, and Power BI. The solution aims to reduce the time spent on manual report consolidation by more than 90%, eliminate transcription errors, and provide real-time visibility into operational productivity. The solution is projected to reduce consolidation time by more than 90% (from 45 to less than 5 minutes per day) and provide visibility into operational productivity every 2 hours, facilitating proactive rather than reactive decision-making. Quantifiable benefits include freeing up approximately 16 hours per month for higher-value strategic activities, improved accuracy and timeliness of information for billing processes, thereby reducing customer disputes, scalability to handle projected volume growth of 15–20% annually without hiring additional staff, and the creation of documented organizational knowledge assets that can be replicated at other DSV offices in Latin America.