Start with the reports the operation already uses
You do not need a new ERP to begin. The minimum useful comparison uses yesterday’s active production schedule and today’s updated schedule. A completed-operations report adds the evidence needed to explain which work center reported throughput.
- Yesterday’s schedule: production order, current work center, operation, status, and plan or remainder start date.
- Today’s schedule: the same fields from the refreshed report.
- Completed operations: production order, completed WC, operation, completion date, and event status.
Use authorized reports only. A public demonstration should contain fictional orders, parts, quantities, and locations. Keep employer and customer production data private.
Use one clean production-order key
The production order must match exactly across files. Before comparing reports, confirm that both columns use the same format and do not contain hidden spaces. Also decide whether duplicate rows represent separate operations or accidental duplication.
For an order-level view, count distinct production orders. For a work-center throughput view, preserve the underlying completed-operation rows but also show the number of distinct orders.
Use an exact VLOOKUP for the first comparison
Place the formula beside each production order on yesterday’s schedule and search today’s production-order column. If the production order is in column E on both files, a basic exact-match formula is:
=VLOOKUP(E2,'[Today Production Schedule.xlsx]WTD'!$E:$E,1,FALSE)- If Excel returns the production-order number, the order is still present on today’s active schedule.
- If Excel returns #N/A, the order is missing from today’s schedule and needs classification.
An order can disappear because it completed, was canceled, was removed, or no longer meets the report criteria. Treat it as a completion candidate until another report confirms the disposition.
Compare the work center and operation to see movement
Finding the order in both schedules only proves it remains active. Compare the prior and current work center and operation to understand what happened next.
| Yesterday | Today | Classification | Meaning |
|---|---|---|---|
| CNC-10 · OP 10 | ASSY-20 · OP 20 | Moved WC | The prior WC finished and the order moved forward. |
| CNC-10 · OP 10 | CNC-10 · OP 20 | Advanced in WC | The order advanced to another operation inside the same WC. |
| CNC-10 · OP 10 | CNC-10 · OP 10 | Still at WC | The order remains at the same operation and may need aging review. |
| CNC-10 · OP 10 | Not found | Left schedule | Confirm completion, cancellation, removal, or changed criteria. |
Separate completed WC work from completed production orders
A completed operation is throughput for the work center. It does not necessarily mean the entire production order is finished. The order may continue through several work centers before final completion.
A useful dashboard therefore reports these numbers separately:
- Completed-operation event rows.
- Distinct production orders with completed WC activity.
- Orders that moved to another WC.
- Orders that advanced within the same WC.
- Orders still awaiting movement.
- Orders that left the active schedule.
Flag WIP that stays at the same work center too long
Keep a daily snapshot or the earliest observed date for each order, WC, and operation. If the combination does not change, calculate the number of days it has remained there and compare that age with an agreed threshold.
The threshold should match the operation. A two-day limit may be reasonable for one work center and completely wrong for another. Begin with a simple company-wide rule only if the team agrees, then refine the limits using actual cycle time and operational expectations.
What the daily dashboard should show
- Every unique active production order and its current WC.
- Current operation, status, item, and physical location when available.
- Days at the current WC and a clear aging warning.
- Completed WC throughput without confusing it with final order completion.
- Movement to another WC, advancement within the same WC, awaiting movement, possible stuck WIP, and orders that left the schedule.
This creates one operating view for the morning meeting while preserving the report-level evidence behind every number.