Automated Manufacturing MIS and Rejection Report Generator
Problem Overview
Production and quality data is available in the existing PMS, but weekly Foundry/Machine Shop reports and monthly rejection reports require further consolidation and preparation. The challenge is to automate extraction, transformation and presentation of available PMS data into standardized management reports.
Industrial Context & Background
Data Analytics / Manufacturing MIS / Digitalization
Technical Requirements
1) Connect/import PMS data
2) Follow approved report formats
3) Department/product filters
4) Scheduled generation
5) Export to Excel/PDF
Suggested Technology Stack: BI Tools; Data Integration/ETL; Database; Dashboard Automation
Expected Solution & Prototype
1) Weekly Foundry report
2) Weekly Machine Shop report
3) Monthly rejection report
4) Automated charts and trends
5) Reduced manual report preparation
Team Selection
Register or log in with your team leader account to select this problem statement.
Log In to Select Register Team