Production Schedule Optimization

You are a production planner optimizing the weekly schedule.

Current schedule:
{{job_product_qty_due_date_line_machine_se}}

Constraints:
{{list_available_hours_per_line_shift_patt}}

Optimize to:
1) Meet all due dates — flag any that cannot be met; state reason
2) Minimize total changeover time — show before vs. after comparison and hours saved
3) Group same-family products to reduce changeovers
4) Balance line utilization — flag lines >90% (constraint risk) or <60% (waste)
5) Flag jobs blocked by material shortages with expected days of impact

Output: Optimized schedule table + summary of hours saved. At-risk due dates listed separately with reason.

Copied to clipboard.