EXAMPLE · SYNTHETIC DATA
Sample production exception report
A fictional shop with 13 open jobs, as of Nov 16, 2026. Every number below comes from the example file, so you can check it yourself.
Production exception report
As of Nov 16, 2026 · open-orders export, 13 rows
Check first
- 01WO-1029 is past its promised date (Nov 13) and still open at Inspection. Verify its status and confirm a new ship date with the customer.
- 02CNC-2 has 88 h due by Nov 23 against 80 h available (110%). Verify whether WO-1061 or WO-1049 can run on CNC-1, which is at 30%.
- 03WO-1061 looks safe on its own (18 h left, 5 working days to ship) but sits behind 70 h of earlier-due work at CNC-2.
- 04WO-1068 ships Nov 24 but cannot be checked: remaining hours missing. Add the missing data or confirm its status by hand.
Jobs at risk of shipping late
| Job | Ships | Work center | Slack* |
|---|---|---|---|
| WO-106188 h queued ÷ 16 h/day = 5.5 d needed, 5 d left | Nov 23 | CNC-2 | −0.5 d |
| WO-104970 h queued ÷ 16 h/day = 4.4 d needed, 4 d left | Nov 20 | CNC-2 | −0.4 d |
| WO-1066100 h queued ÷ 16 h/day = 6.3 d needed, 6 d left | Nov 24 | CNC-2 | −0.3 d |
| WO-107440 h queued ÷ 8 h/day = 5.0 d needed, 5 d left | Nov 23 | Deburr | 0.0 d |
| WO-104242 h queued ÷ 16 h/day = 2.6 d needed, 3 d left | Nov 19 | CNC-2 | 0.4 d |
Insufficient data: WO-1068 (remaining hours missing)
Already overdue: WO-1029 (promised Nov 13)
Load · jobs shipping by Nov 23 vs. next 5 working days
- CNC-288/80 h · 110%
- Deburr40/40 h · 100%
- CNC-124/80 h · 30%
- Saw6/40 h · 15%
- Inspection0/40 h · 0%
Line = 100% of available hours. *Current-operation slack: queue and hours at the next work center only; excludes downstream operations, material and shipping time. Under 0.5 d is flagged as at risk.
How each flag is calculated
- Overdue: the promised ship date is before the report date and the job is still open.
- Queue: jobs waiting at the same work center are worked in due-date order, earliest first.
- Days needed: remaining hours of this job and every earlier-due job at that work center, divided by the hours available per day.
- Current-operation slack: working days left before the ship date minus days needed at the next work center. Under 0.5 d is flagged as at risk. Downstream operations, material and shipping time are not included.
- Insufficient data: jobs with missing remaining hours or a work center without known capacity are listed separately, never guessed.
- Load: hours of jobs that must be finished in the next 5 working days, divided by the hours available in those days.
Inputs in the example
Columns: job_id, part, customer, promised_ship_date, status, next_work_center, remaining_hours
Hours available per day:
- CNC-1: 16 h
- CNC-2: 16 h
- Deburr: 8 h
- Saw: 8 h
- Inspection: 8 h
Limits
The report only knows what the export contains. It does not see machine breakdowns, material shortages or priorities agreed by phone. That is why every recommendation is written as something to verify.
Want this for your shop?
$129 pilot · Up to four reports in 30 days · one shop · one agreed export format · one-time payment. We confirm your file fits before you pay.
Start a pilot