Export date 2026-11-16. Four weeks, Monday to Sunday. Past-due lines are in week 1. Sample data.
| Work center | Week 1 Nov 16 - Nov 22 | Week 2 Nov 23 - Nov 29 | Week 3 Nov 30 - Dec 06 | Week 4 Dec 07 - Dec 13 |
|---|---|---|---|---|
| LATHE | 83% 66.70 h of 80.00 h | 52% 41.50 h of 80.00 h | 57% 45.30 h of 80.00 h | 13% 10.00 h of 80.00 h |
| MILL | 86% 69.16 h of 80.00 h | 123% 98.31 h of 80.00 h | 56% 44.40 h of 80.00 h | 80% 64.32 h of 80.00 h |
| WELD | 93% 74.00 h of 80.00 h | 30% 24.00 h of 80.00 h | 24% 19.00 h of 80.00 h | 0% 0.00 h of 80.00 h |
| ASSY | 42% 33.50 h of 80.00 h | 69% 55.50 h of 80.00 h | 0% 0.00 h of 80.00 h | 56% 44.50 h of 80.00 h |
| Work center | Week 1 Nov 16 - Nov 22 | Week 2 Nov 23 - Nov 29 | Week 3 Nov 30 - Dec 06 | Week 4 Dec 07 - Dec 13 |
|---|---|---|---|---|
| LATHE | 83% 66.70 h of 80.00 h | 52% 41.50 h of 80.00 h | 57% 45.30 h of 80.00 h | 13% 10.00 h of 80.00 h |
| MILL | 86% 69.16 h of 80.00 h | 84% 67.12 h of 80.00 hCHANGED, was 123% | 94% 75.59 h of 80.00 hCHANGED, was 56% | 80% 64.32 h of 80.00 h |
| WELD | 93% 74.00 h of 80.00 h | 30% 24.00 h of 80.00 h | 24% 19.00 h of 80.00 h | 0% 0.00 h of 80.00 h |
| ASSY | 42% 33.50 h of 80.00 h | 69% 55.50 h of 80.00 h | 0% 0.00 h of 80.00 h | 56% 44.50 h of 80.00 h |
Red: over 100%. Amber: 90 to 100%. Color uses the rounded whole-number load %.
| Order | Line | Release | Item | Operation | Hours |
|---|---|---|---|---|---|
| 48195 | 1 | 2 | MR-1020 | 10 | 24.50 |
| 48210 | 1 | 0 | MR-1020 | 10 | 22.25 |
| 48207 | 1 | 0 | MR-1020 | 10 | 15.50 |
| 48209 | 1 | 0 | MR-1015 | 20 | 11.00 |
| 48195 | 1 | 2 | MR-1020 | 20 | 9.82 |
| 48210 | 1 | 0 | MR-1020 | 20 | 8.94 |
| 48207 | 1 | 0 | MR-1020 | 20 | 6.29 |
No red cells.
| Order | Line | Release | Item | Operation | WC | Hours not counted |
|---|---|---|---|---|---|---|
| 48205 | 1 | 0 | MR-1030 | 20 | OUT-PC | 0.00 |
| 48215 | 1 | 0 | MR-1030 | 20 | OUT-PC | 0.00 |
| Excel row | Order | Line | Release | Item | Open qty | Due |
|---|---|---|---|---|---|---|
| 16 | 48205 | 2 | 0 | MR-1002 | 150 | 2026-11-20 |
| Excel row | Order/Line/Release | Reason |
|---|---|---|
| 6 | 48182/1/0 | Status is Filled, not Ordered |
| 7 | 48185/1/0 | Status is Complete, not Ordered |
| 8 | 48195/1/1 | Status is Filled, not Ordered |
| 21 | 48210/1/0 | Duplicate of Excel row 20 |
| 23 | 48212/1/0 | No due date |
| 25 | 48214/1/0 | Status is Planned, not Ordered |
Rows in export 27 = lines counted 21 + lines not counted 6 (OK)