Statistical analysis of work order stage durations — distribution, variation, and process capability
Box = P25–P75 (IQR) | Line = median | ◯ = mean | Whiskers = min–max (capped at 1.5×IQR)
| Rank | Stage | Mean (μ) | Std Dev (σ) | CV% | Variation | P25 | P50 | P75 | P90 | Outliers |
|---|---|---|---|---|---|---|---|---|---|---|
| #1 | Dispatch Deep Dive → | 0.5d | 6.2d | 1,155% | 0.0d | 0.0d | 0.0d | 0.4d | 20833 (19.4%) | |
| ↳ Logistics (214 WOs) | 8.7d | 12.6d | 144% | 3.8d | 12.6d | 22.0d | ||||
| ↳ Production (155 WOs) | 4.7d | 4.9d | 106% | 4.0d | 5.4d | 7.0d | ||||
| ↳ L2 Screening (16,176 WOs) | 0.5d | 2.4d | 495% | 0.0d | 0.2d | 1.1d | ||||
| ↳ Entered (84,403 WOs) | 0.3d | 5.4d | 1,551% | 0.0d | 0.0d | 0.1d | ||||
| #2 | Holding Deep Dive → | 0.6d | 5.8d | 949% | 0.0d | 0.0d | 0.0d | 0.0d | 3107 (2.9%) | |
| ↳ Ready for Release (2,464 WOs) | 23.6d | 28.8d | 122% | 14.0d | 33.5d | 58.0d | ||||
| ↳ On Hold (728 WOs) | 10.1d | 13.8d | 137% | 4.4d | 12.9d | 28.0d | ||||
| #3 | Material Management Deep Dive → | 1.1d | 5.4d | 471% | 0.0d | 0.0d | 0.0d | 1.9d | 18953 (17.6%) | |
| ↳ Awaiting Parts - Backorder (16 WOs) | 10.8d | 8.9d | 83% | 12.0d | 12.1d | 24.8d | ||||
| ↳ Awaiting Parts (13,936 WOs) | 7.0d | 11.7d | 166% | 2.7d | 7.8d | 18.5d | ||||
| ↳ Awaiting Parts - Customer (2,523 WOs) | 3.5d | 6.5d | 186% | 1.9d | 3.4d | 7.0d | ||||
| #4 | Billing Deep Dive → | 2.6d | 11.8d | 446% | 0.0d | 0.2d | 2.1d | 5.2d | 10802 (10.0%) | |
| ↳ Billing Correction Needed (735 WOs) | 6.2d | 10.5d | 169% | 2.1d | 7.2d | 16.4d | ||||
| ↳ Billing Review (14,558 WOs) | 3.6d | 9.5d | 265% | 1.0d | 1.8d | 8.8d | ||||
| ↳ WO Correction Needed (4,348 WOs) | 1.9d | 4.0d | 208% | 1.0d | 2.0d | 4.0d | ||||
| ↳ Ready to Bill (89,750 WOs) | 1.2d | 3.8d | 317% | 0.1d | 1.2d | 2.0d | ||||
| ↳ Invoiced (89,753 WOs) | 0.5d | 10.5d | 2,082% | 0.0d | 0.0d | 0.0d | ||||
| ↳ Invoice Pending (78,340 WOs) | 0.2d | 1.6d | 657% | 0.0d | 0.0d | 0.1d | ||||
| #5 | Field Work Deep Dive → | 0.7d | 3.0d | 414% | 0.0d | 0.0d | 0.7d | 1.7d | 10839 (10.1%) | |
| ↳ Tech - Parts On Order (41 WOs) | 2.0d | 4.7d | 238% | 0.0d | 3.8d | 5.8d | ||||
| ↳ Tech On Site (34,952 WOs) | 0.9d | 2.0d | 226% | 0.4d | 1.0d | 2.0d | ||||
| ↳ Tech Off Site (8,172 WOs) | 0.8d | 2.0d | 256% | 0.0d | 1.0d | 2.1d | ||||
| ↳ Completed (84,006 WOs) | 0.2d | 1.5d | 660% | 0.0d | 0.0d | 0.4d | ||||
| #6 | Coordinators Deep Dive → | 17.0d | 31.6d | 186% | 1.5d | 5.9d | 18.4d | 44.4d | 11038 (10.3%) | |
| ↳ Scheduled (61,726 WOs) | 9.1d | 13.3d | 146% | 4.6d | 10.2d | 22.6d | ||||
| ↳ Ready for Scheduling (57,546 WOs) | 5.9d | 18.8d | 317% | 0.6d | 3.0d | 13.0d | ||||
| ↳ Reschedule (9,274 WOs) | 5.7d | 12.1d | 214% | 2.0d | 5.3d | 13.5d | ||||
| ↳ Assigned (67,701 WOs) | 4.9d | 11.8d | 241% | 0.5d | 4.5d | 14.0d | ||||
| Total | 22.1d | 34.7d | 157% | 3.9d | 9.9d | 26.2d | 53.0d | 8764 (8.1%) |
The 75th percentile represents what your process can realistically deliver. 75% of work orders complete each stage within this time.
Total duration by priority level — P# = business day SLA target
| Priority | WOs | SLA Target | Mean | P50 | P75 | P90 | Distribution | Over SLA |
|---|---|---|---|---|---|---|---|---|
| P0 | 45 | 0d (immediate) | 4.3d | 2.7d | 4.9d | 9.5d |
|
100% |
| P1 | 583 | 1 biz day | 3.8d | 2.4d | 3.5d | 7.4d |
|
92% |
| P2 | 2,161 | 2 biz days | 3.9d | 3.1d | 4.1d | 6.5d |
|
81% |
| P3 | 6,256 | 3 biz days | 14.1d | 7.9d | 17.7d | 32.3d |
|
84% |
| P4 | 15,983 | 4 biz days | 9.1d | 6.8d | 11.0d | 19.3d |
|
70% |
| P5 | 5,733 | 5 biz days | 11.8d | 5.1d | 10.6d | 27.0d |
|
51% |
| P7 | 5,889 | 7 biz days | 15.1d | 9.5d | 19.3d | 35.1d |
|
60% |
| PSM | 34,959 | End of month | 25.4d | 18.4d | 37.3d | 55.0d |
|
— |
| PC | 35,969 | Per client | 30.3d | 11.4d | 31.9d | 82.2d |
|
— |
Black tick on bar = SLA target. Mean color: green = within 1.5x SLA, amber = 1.5–3x, red = >3x SLA.
How each stage's duration is trending month-over-month — are we getting better or worse?
| Stage | Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 | May 2024 | Jun 2024 | Jul 2024 | Aug 2024 | Sep 2024 | Oct 2024 | Nov 2024 | Dec 2024 | Jan 2025 | Feb 2025 | Mar 2025 | Apr 2025 | May 2025 | Jun 2025 | Jul 2025 | Aug 2025 | Sep 2025 | Oct 2025 | Nov 2025 | Dec 2025 | Jan 2026 | Feb 2026 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dispatch | 0.0d (4,612) | 0.0d (4,455) | 0.0d (4,638) | 0.0d (4,524) | 0.0d (4,768) | 0.0d (4,283) | 0.0d (4,612) | 0.0d (4,913) | 0.0d (4,192) | 0.0d (5,370) | 0.0d (4,217) | 0.0d (4,257) | 0.0d (5,285) | 0.0d (4,087) | 0.0d (4,346) | 0.0d (4,354) | 0.0d (4,103) | 0.0d (3,762) | 0.0d (4,537) | 0.0d (3,945) | 0.0d (4,444) | 0.0d (4,089) | 0.0d (3,225) | 0.0d (2,988) | 0.0d (2,660) | 0.0d (925) |
| Material Management | 0.0d (4,612) | 0.0d (4,455) | 0.0d (4,638) | 0.0d (4,524) | 0.0d (4,768) | 0.0d (4,283) | 0.0d (4,612) | 0.0d (4,913) | 0.0d (4,192) | 0.0d (5,370) | 0.0d (4,217) | 0.0d (4,257) | 0.0d (5,285) | 0.0d (4,087) | 0.0d (4,346) | 0.0d (4,354) | 0.0d (4,103) | 0.0d (3,762) | 0.0d (4,537) | 0.0d (3,945) | 0.0d (4,444) | 0.0d (4,089) | 0.0d (3,225) | 0.0d (2,988) | 0.0d (2,660) | 0.0d (925) |
| Holding | 0.0d (4,612) | 0.0d (4,455) | 0.0d (4,638) | 0.0d (4,524) | 0.0d (4,768) | 0.0d (4,283) | 0.0d (4,612) | 0.0d (4,913) | 0.0d (4,192) | 0.0d (5,370) | 0.0d (4,217) | 0.0d (4,257) | 0.0d (5,285) | 0.0d (4,087) | 0.0d (4,346) | 0.0d (4,354) | 0.0d (4,103) | 0.0d (3,762) | 0.0d (4,537) | 0.0d (3,945) | 0.0d (4,444) | 0.0d (4,089) | 0.0d (3,225) | 0.0d (2,988) | 0.0d (2,660) | 0.0d (925) |
| Coordinators | 5.9d (4,612) | 5.1d (4,455) | 5.9d (4,638) | 5.7d (4,524) | 6.4d (4,768) | 6.0d (4,283) | 5.8d (4,612) | 5.7d (4,913) | 6.0d (4,192) | 7.6d (5,370) | 8.0d (4,217) | 5.8d (4,257) | 7.6d (5,285) | 6.9d (4,087) | 6.1d (4,346) | 5.3d (4,354) | 6.2d (4,103) | 5.7d (3,762) | 6.7d (4,537) | 5.9d (3,945) | 6.0d (4,444) | 4.7d (4,089) | 5.5d (3,225) | 4.9d (2,988) | 3.9d (2,660) | 1.0d (925) |
| Field Work | 0.0d (4,612) | 0.0d (4,455) | 0.0d (4,638) | 0.0d (4,524) | 0.0d (4,768) | 0.0d (4,283) | 0.0d (4,612) | 0.0d (4,913) | 0.0d (4,192) | 0.0d (5,370) | 0.0d (4,217) | 0.0d (4,257) | 0.0d (5,285) | 0.0d (4,087) | 0.0d (4,346) | 0.0d (4,354) | 0.1d (4,103) | 0.1d (3,762) | 0.0d (4,537) | 0.0d (3,945) | 0.0d (4,444) | 0.0d (4,089) | 0.0d (3,225) | 0.0d (2,988) | 0.0d (2,660) | 0.0d (925) |
| Billing | 0.2d (4,612) | 0.2d (4,455) | 0.1d (4,638) | 0.2d (4,524) | 0.4d (4,768) | 0.1d (4,283) | 0.1d (4,612) | 0.3d (4,913) | 0.2d (4,192) | 0.4d (5,370) | 0.2d (4,217) | 0.2d (4,257) | 0.4d (5,285) | 0.3d (4,087) | 0.1d (4,346) | 0.1d (4,354) | 0.4d (4,103) | 0.3d (3,762) | 0.1d (4,537) | 0.3d (3,945) | 0.3d (4,444) | 0.2d (4,089) | 0.1d (3,225) | 0.2d (2,988) | 0.2d (2,660) | 0.1d (925) |
| Total | 9.4d (4,612) | 9.6d (4,455) | 9.0d (4,638) | 9.4d (4,524) | 10.4d (4,768) | 9.1d (4,283) | 9.5d (4,612) | 9.4d (4,913) | 9.1d (4,192) | 11.8d (5,370) | 13.1d (4,217) | 9.2d (4,257) | 15.4d (5,285) | 11.4d (4,087) | 10.1d (4,346) | 9.5d (4,354) | 11.1d (4,103) | 9.8d (3,762) | 10.9d (4,537) | 10.8d (3,945) | 11.2d (4,444) | 8.8d (4,089) | 9.8d (3,225) | 9.6d (2,988) | 6.2d (2,660) | 2.4d (925) |