Four separate skills mean little if a factory or brand still tracks them in four separate places. Omar, the owner of Cedar & Co., wants one workbook that records output entries as they happen, shows a dashboard across his hybrid batch's confirmed and forecast lines, and compares each operation's real-time output against its own target pace, all in the same place. This lesson teaches how to bring the whole course together into that one tool.
Without a single combined tracker, a factory or brand ends up checking one spreadsheet for output entries, another for the dashboard view, and a third for target pace, losing the very reaction-time advantage real-time tracking is supposed to provide. A hybrid order like Cedar & Co.'s, mixing a confirmed line with a forecast repeat line, needs this combination even more, since both lines share operations but carry different urgency.
You need: lessons 26.1.1 through 26.1.4 (what real-time tracking adds, recording output entries, reading a multi-line dashboard, and comparing against target pace) are useful background but not required to complete this lesson.
By the end of this lesson you can:
Not covered here: the individual skills in depth, each taught in lessons 26.1.1 through 26.1.4; this lesson focuses on combining them into one tool.
| Term | Meaning |
|---|---|
| Real-time tracking | Recording production output at the moment it happens, rather than totalling it once at a fixed point such as the end of a shift. |
| Output entry | A single record of the quantity completed at one operation at one specific moment, the smallest building block a real-time tracking system is made of. |
| Production dashboard | A live screen or report that shows real-time output across a line's operations, or across several lines at once, updated as output entries arrive. |
| Pace gap | The difference between an operation's actual real-time output and its own target pace over the same period. |
| Hybrid order | One style produced under two business models at once, usually one confirmed order line and one forecast order line. |
The three skills this course taught are not separate tools; they are three views of the same underlying data. Every output entry logged feeds both the dashboard's output curves and the target pace comparison's pace gaps. Building them as three connected sheets in one workbook, rather than three separate files, means a single habit of logging entries correctly keeps every other view current automatically.
| What can differ | The shapes you meet | Why it matters to you |
|---|---|---|
| Order mix on the tracker | A tracker covering one export Make to Order batch, or one covering a hybrid order like Cedar & Co.'s confirmed-plus-forecast lines. | A hybrid order's tracker needs both lines' entries kept separate enough to compare, while still sharing the same operations' target pace figures. |
| Number of lines and operations tracked | A short T-shirt sequence on one line, or several lines each with several operations, as a larger factory runs. | More lines and operations mean the dashboard sheet must clearly separate each line's own curve, and the target pace sheet must list each operation's own SMV separately. |
| Who reads the tracker | A factory supervisor checking output entries hourly, or a brand owner like Omar checking the dashboard and pace gaps from outside the factory. | Different readers need different sheets front and center; the tracker should let each reader reach their own relevant view quickly. |
| Business model urgency | An export confirmed line with one fixed shipment date, or a domestic forecast line with more schedule flexibility. | The same tracker structure serves both, but the urgency attached to acting on a flagged pace gap or stalled line differs by which line it appears on. |
| How often the tracker is checked | Checked continuously through a shift, or checked at set intervals like every hour. | A tracker built for continuous checking benefits from clear visual flags (a flat stretch, a large pace gap); one checked at intervals needs a clear summary view for each check-in. |
Cedar & Co.'s hybrid batch has a confirmed line of 3,000 pieces and a forecast repeat line of 1,500 pieces, both running the same basic T-shirt style on separate lines at Delta Garments. Omar sets up one tracker with three connected sheets: an output entry log recording each bundle's completion time per line, a multi-line dashboard plotting both lines' cumulative output curves together, and a target pace comparison showing each operation's pace gap on both lines side by side.
Because both lines share the same operations and the same target pace figures, Omar can immediately see whether a pace gap on the confirmed line's waistband attach also shows up on the forecast line's waistband attach, which would suggest a shared cause like a machine issue rather than something specific to one line.
The worked numberBoth lines show some pace gap on sleeve attach this hour, but the confirmed line's gap is five times larger than the forecast line's. Because both figures sit in the same combined tracker, Omar can see this comparison in one glance rather than checking two separate files; the figures themselves are Cedar & Co.'s own illustrative example, but the comparison method is what the combined tracker is built to support.
A common mistake is building the three skills this course taught as three unconnected files, each requiring its own manual update. This defeats the purpose of a combined tracker: an entry logged in one file does not automatically appear in another, reintroducing exactly the kind of lag and inconsistency real-time tracking is meant to remove, and doubling or tripling the manual work needed to keep every view current.
A tracker built from three separate files forces someone to update the same information three times, which is slower and more error-prone than logging it once. Building one workbook where an entry logged in one place automatically appears in the dashboard and the target pace comparison keeps everything current from a single habit. A hybrid order with a confirmed line and a forecast line benefits especially from this, since seeing both lines' figures together, in the same tool, is what makes a fair comparison between them possible.
Cedar & Co.'s current hybrid batch is small enough that Omar has been updating the dashboard and target pace sheets by hand from the entry log, a few minutes' work each check. Delta Garments has offered to link the sheets with formulas so entries update everything automatically, at a one-time setup cost.
Should Omar keep manually updating for this small batch and only consider linking formulas later, or invest in the setup now even though the current batch is nearly finished? Decide before opening the answer.
Omar should invest in the setup now, not wait until a future batch, since the same linked tracker will serve every batch Cedar & Co. runs afterward, not just this one.
1. The one-time setup cost is paid once but used repeatedly, across this batch's remaining days and every future hybrid batch Cedar & Co. plans to run. 2. Manual updating's cost compounds with batch size; a few minutes per check on a small batch becomes a larger burden on the larger batches Cedar & Co. expects in future seasons. 3. Setting it up now, while the stakes are low, lets Omar and Delta Garments fix any linking mistakes on a small batch rather than discovering them for the first time on a larger, more urgent one.
Omar does not need to wait for a larger batch to justify the investment; the setup cost is the same regardless of when it happens, while the benefit only grows with every batch that follows.
Order A's timeline framework (docs/02 section 7) shows how a 15,000-piece order needs steady, current tracking across its own 2-week sewing window; a hybrid batch scaling toward similar volumes would face the same pressure on tracking accuracy.
The recurring nature of manual updating, compared with a one-time linking cost, is Cedar & Co.'s own illustrative reasoning for why the investment is worth making early; the exact minutes are not a fixed master figure, but the principle of a recurring cost against a one-time fix applies regardless of the batch's exact size.
Open the real-time production tracking tracker. It contains four sheets built across this course: "Shift output comparison" (lesson 26.1.1), "Output entry log" (lesson 26.1.2), "Multi-line dashboard" (lesson 26.1.3) and "Target pace comparison" (lesson 26.1.4), designed to work together as one tool. Start with Cedar & Co.'s hybrid batch figures above, then set up your own order's full tracker.
[Download the real-time production tracking tracker workbook](../../templates/T26-C01-real-time-production-tracking-tracker.xlsx)
1. Why does a complete tracker combine output entries, a dashboard and target pace comparison into one tool rather than three separate files?
2. Why did comparing the confirmed and forecast lines' pace gaps on sleeve attach matter to Omar?
3. Should Omar link the tracker's sheets now, while Cedar & Co.'s batch is small, or wait until a larger batch justifies it?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Real-time tracking | التتبع الفوري | Suivi en temps réel | Gerçek zamanlı takip | Recording production output at the moment it happens, rather than totalling it once at a fixed point such as the end of a shift. |
| Output entry | إدخال الناتج | Saisie de production | Çıktı kaydı | A single record of the quantity completed at one operation at one specific moment, the smallest building block a real-time tracking system is made of. |
| Production dashboard | لوحة الإنتاج | Tableau de bord de production | Üretim gösterge paneli | A live screen or report that shows real-time output across a line's operations, or across several lines at once, updated as output entries arrive. |
| Pace gap | فجوة الوتيرة | Écart de cadence | Tempo farkı | The difference between an operation's actual real-time output and its own target pace over the same period. |
| Hybrid order | طلبية مختلطة | Commande hybride | Hibrit sipariş | One style produced under two business models at once, usually one confirmed order line and one forecast order line. |
This is the final lesson of Course 1: Real-Time Production Tracking. You have covered end-of-shift versus real-time tracking, recording output entries, reading a multi-line dashboard, comparing output against target pace, and combining every skill into one complete tracker for both export and domestic, confirmed and forecast lines. Back to the course map