WIP / Outsourcing WIP by station, open-batch age alerts, vendor turnaround days, 2F pool level
WIP Funnel by Station (real-time)
Part 1 Open-Batch Age Analysis(prod date: Molding to Deflash to FRAME FQC to FRAME Inventory; Open = not yet into 2F)
| Prod date | Open qty | Batch age (days) |
|---|
| 2026-07-12 |
2 |
32 ⚠ |
| 2026-07-02 |
3 |
42 ⚠ |
| 2026-07-01 |
36 |
43 ⚠ |
2F Pool Level Trend（current pool qty：10）
Lot Tracking + Vendor Turnaround Days(lot stage: ship to OM return to NPG FQC to stock-in)
| Lot | Ship date | Return date | Turnaround (days) |
Ship qty | Return qty | FQC Pass | FQC Fail |
FG in | FG out | Not yet stocked (Open) |
|---|
| OM26071101 |
2026-07-11 |
2026-07-11 |
0 |
15 |
15 |
10 |
0 |
10 |
0 |
5 |
| OM26070202 |
2026-07-02 |
2026-07-02 |
0 |
4 |
4 |
4 |
0 |
3 |
0 |
1 |
| OM26070201 |
2026-07-01 |
2026-07-01 |
0 |
15 |
15 |
13 |
12 |
12 |
0 |
-9 |
WIP / 2F pool are real-time; the age analysis covers all still-open prod dates (not just the latest 10). "Not yet stocked (Open)" = ship qty - FG in - loss/FAIL within the stage; same basis as the dashboard reconciliation.