Improving On-Time Delivery Reporting Flow at Collins Aerospace

Abstract

On-time delivery (OTD) performance plays a critical role in aerospace manufacturing due to its impact on production schedules, customer commitments, and cost control. This project examined the absence of a standardized OTD reporting flow within a regulated aerospace manufacturing environment and evaluated alternatives for improving delivery visibility and reporting efficiency. Using the Define–Measure–Analyze–Improve–Control (DMAIC) methodology, existing reporting processes were assessed, stakeholder requirements were identified, and reporting solutions were evaluated. The analysis revealed that fragmented data sources and manual reporting practices increased managerial workload and limited proactive risk management. An internal SQL-based workflow reporting solution was selected based on integration capability, data security, and sustainability. The project demonstrated that standardized, system-integrated reporting improves data accuracy, reduces direct labor costs, and supports more effective managerial decision-making. Key Terms ⎯ DMAIC, SQL, utilization rate.