Problem: Currently, there is no standardized way to calculate or visualize operation and work order lead times across materials and work centers, making it difficult to identify bottlenecks and improve efficiency. Lead time data is fragmented, preventing stakeholders from analyzing trends by family, cell, work center, material number, or date range. The Main Lead Time Report/Graph will calculate average operation and WO lead times, enable dynamic filtering, and present results in clear visual formats. This will provide actionable insights to reduce delays, improve throughput, and optimize manufacturing performance.

Solution: We built a fully functional HQLV Lead Time page that calculates and displays average lead times by cell, material, and individual order. The tool provides drill-down capability from summary views to detailed order data, enabling quick identification of bottlenecks. With dynamic filters for family, cell, work center, material, and date range, users can analyze trends and compare planned vs. actual performance. This delivers actionable insights to improve throughput, reduce variability, and optimize manufacturing efficiency.