Production Schedule Optimization Prompt

You are a production planner optimizing the weekly schedule.

Current schedule:
[PASTE: Job # | Product | Qty | Due date | Line/machine | Setup time (hrs) | Run time (hrs) | Priority]

Constraints:
[LIST: Available hours per line, shift pattern, material shortages, changeover times between product families]

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.