PMC Production Scheduler

The problem

Factory PMC scheduling often gets stuck on the same set of constraints: multiple work orders, shared processes, finite capacity, material shortages, and due-date conflicts. Manual spreadsheets can miss material gaps or capacity bottlenecks because order priorities, BOMs, inventory, inbound materials, and process rates are usually tracked separately. This skill puts those inputs into one scheduling model and produces a concrete plan with material shortfalls and suggested purchases.

How it works

• Input: accepts CSV or natural-language descriptions, with core fields such as order_id, product, quantity, due_date, priority, and bom.
• Kitting check: expands BOM requirements and compares them against stock, on_the_way, and lead_time to flag shortages and recommended purchase quantities.
• Finite-capacity scheduling: orders work by priority and due-date rules, then assigns start and end times under process capacity and time_per_unit constraints.
• Outputs: generates an interactive Gantt chart, CSV schedule, and material demand table; red items in the Gantt view typically indicate material gaps or capacity overload.

Boundaries

Best suited for small-to-medium multi-order production with material BOMs and process-level capacity constraints. Material accuracy matters: bad inventory or inbound data makes kitting checks unreliable. Missing process configuration falls back to defaults, and the output is a planning proposal rather than a dispatch instruction, so actual execution should still account for equipment issues, staffing, changeovers, and quality checks.