AI Production Planning System

projects.detailHeading

AI Production Planning System is a production planning workspace designed to turn incoming customer Excel files into actionable internal production plans without the usual manual spreadsheet preparation. Project Scope: - Built a centralized web application for uploading customer demand files, internal process plans, and BOM reference files. - Automated the parsing of variable Excel structures into typed planning data for lines, models, tools, due dates, and daily quantities. - Combined dashboard analytics, planning review, master-data maintenance, and AI-assisted exception handling into one responsive interface. System Workflow: 1. Upload Layer: Planners upload customer demand files and internal planning files directly through the web interface. 2. Parsing Layer: The application auto-detects key headers, maps daily quantity columns, and normalizes spreadsheet data into structured planning records. 3. Planning Layer: Users filter by line, tool, color, and status to review schedule quantities, demand IDs, and process matching in one place. 4. Master Data Layer: BOM mappings, capacities, inventory data, and working calendars are maintained directly in the application. 5. Decision Layer: The AI planning copilot summarizes overload risks, BOM gaps, unmapped demand, and recommended next actions for faster daily planning decisions. Key Features: - Auto Column Detection: Identifies relevant fields from changing customer Excel layouts without requiring repetitive manual remapping. - Daily Schedule Parsing: Converts date-based spreadsheet columns into structured daily production quantities for analysis and review. - BOM and Process Linking: Connects customer model demand with internal part mapping and process planning logic across Top, Outer, Plan LID, and Vibration stages. - AI Planning Copilot: Generates planning summaries, shortage warnings, capacity imbalance alerts, and recommended next checks for planners. - Master Data Management: Supports maintenance of part mappings, capacities, inventory, and working calendars in one system. - Multi-Language Access: Provides a localized interface for English, Korean, and Thai users. - Persistent Planning Workspace: Keeps uploaded data and planning state available for continued review across sessions. Business Impact: - Reduced the planning team's daily preparation work from several hours to just a few minutes. - Lowered the risk of spreadsheet copy/paste errors during demand-to-plan translation. - Improved visibility between customer demand, internal process planning, and BOM readiness in one operational screen. - Added earlier warning signals for overload, shortage, and mapping exceptions before daily planning meetings.