Production Planning & Reporting Tool
- Developing Excel-based tool to reduce business process lead times:
- Shortage reporting based on customer demand & stock data from ERP.
- Prioritization of builds based on customer demand, and generation of production plan across all machining & heat treatment processes.
- Tracking & reporting actual production data.
- Tool speeds up all planning work currently done outside ERP system.
- Tool automatically loads input data from ERP – no additional data duplication.
- Planning lead time reduction from ~1 day to 30 minutes.