This page is for a merchandiser, production manager, or agent who has already worked through this course's first three lessons separately and now needs them working together on one real hybrid line, rather than as three disconnected habits. At work, a factory that names one real question in one place, calculates efficiency in another, and tests predictive metrics in a third, without connecting the three, ends up with good individual habits but no single worksheet anyone actually uses each week. This lesson mainly teaches the decision flow: it shows how the three earlier lessons' own methods combine into one working tool.
Delta Garments runs one hybrid line carrying Cedar & Co.'s own domestic reorder alongside an export style at the same time. Karim already knows, from lesson T26-C03-L01, that the line's dashboard needs one real question per style rather than one blended figure; from lesson T26-C03-L02, that efficiency must be calculated from real output, not assumed; and from lesson T26-C03-L03, that the bottleneck stage's own backlog, not a line-wide average, gives the earliest useful warning. Mona now needs all three brought together into a single worksheet Delta Garments can actually run every week.
You need: lessons T26-C03-L01, T26-C03-L02, and T26-C03-L03, since this lesson combines their own methods rather than introducing new ones.
By the end of this lesson you can:
Not covered here: the individual methods themselves, covered separately in lessons T26-C03-L01, L02, and L03.
| Term | Meaning |
|---|---|
| Combined worksheet | A single tool that brings a dashboard's one real question, a line's own efficiency calculation, and a predictive-metric test together for one line or order. |
| Per-style tracking | Keeping a hybrid line's own dashboard, efficiency, and predictive figures separate for each style it runs, rather than blended into one line-wide figure. |
| Weekly production review | The regular meeting at which a factory checks its own dashboard figures, efficiency, and leading indicators against that week's own real output. |
| Risk flag | A worksheet's own marker showing that a specific style's own figures have crossed a threshold worth acting on. |
| Shared line capacity | The total run time a hybrid line has available, divided between the styles it carries in a given period. |
| Worksheet owner | The person responsible for keeping a combined worksheet's own figures current and acting on any risk flag it raises. |
The general rule for a hybrid line is to run all three of this course's own methods for each style it carries, rather than blending two styles' own figures into one. A worksheet that combines a dashboard's one real question, a real efficiency calculation, and a tested predictive metric, tracked per style, gives a factory the same early warning this course has built lesson by lesson, applied consistently every week rather than only when someone remembers to check.
| What can differ | The shapes you will meet | Why it matters |
|---|---|---|
| Domestic reorder and export style sharing one line | Cedar & Co.'s own reorder and an export style both run on Delta Garments' hybrid line, each with its own deadline, target output, and bottleneck. | A single blended figure for the line hides which specific style is actually at risk behind the one that is running well. |
| Export order with a fixed shipment date under time pressure | An export style with a near port cut-off needs its own worksheet figures checked more frequently than a domestic reorder with a more flexible timeline. | The one real question, efficiency, and predictive metric all still apply, but the review frequency should match how urgent each style's own deadline actually is. |
| Agent-managed order sharing capacity with a factory-managed reorder | Meridian Sourcing needs visibility into the worksheet's own export-style rows without needing the domestic reorder rows, which are Delta Garments' own internal concern. | A shared worksheet still needs each audience to see only the rows relevant to its own decision, not every row on the line. |
| A style whose bottleneck shifts between periods | A style's own bottleneck stage can move, from cutting to sewing to washing, as conditions change, so the predictive metric being tracked needs periodic rechecking, not a one-time choice. | A predictive metric proven correct once is not guaranteed to stay the correct one forever if the underlying bottleneck itself moves. |
Mona sets up the worksheet with two full rows, one for Cedar & Co.'s own reorder and one for the export style, each carrying its own real question, its own calculated efficiency, and its own tracked predictive metric, rather than a single row averaging the two styles together.
The export style's own 83% efficiency looks acceptable on its own, but the bottleneck backlog has been rising for 3 consecutive days, and the predictive test already proved this specific metric gives a 9-day warning window. With only 11 days left before the port cut-off, the worksheet's own combined view flags this style as needing action now, a risk that efficiency alone would have missed.
A common mistake is a factory keeping this course's own three methods in three separate places, a dashboard here, an efficiency spreadsheet there, a predictive-metric note somewhere else entirely, so that no single view ever shows all three for the same style at the same time, on the same day, in the same room. What this costs is real: on Delta Garments' own hybrid line, the export style's rising backlog, proven predictive, sat in one file while its efficiency figure sat in another, and neither alone would have prompted action as clearly as the two seen together against the style's own 11-day cut-off, the exact combination a complete worksheet is built to show at a glance.
Three separate habits, naming one real question, calculating real efficiency, and testing which metric actually predicts trouble, are each useful on their own, but a factory only gets the full benefit once they are combined into one worksheet that tracks every style on a shared line separately rather than blended together. A hybrid line running two styles needs two full sets of these figures, not one averaged set, because averaging can make a genuinely at-risk style look fine behind a healthy one. Bringing all three methods together, reviewed on a fixed weekly schedule by a named owner, is what turns three good separate habits into one early-warning system a factory can actually rely on.
With the export style's own row showing 83% efficiency, a 3-day rising backlog, and an 11-day port cut-off against a proven 9-day warning window, Mona has to decide today whether to escalate to Northline Apparel now or wait for tomorrow's own figures first.
Should Mona escalate to the buyer today, based on this combined worksheet reading? Decide before opening the answer.
Yes, escalate today rather than waiting for tomorrow's figures. The proven predictive metric's own 9-day warning window is already shorter than the style's own 11 days remaining, meaning the worksheet's own action zone has already been entered, not merely approached.
First, efficiency at 83% alone would not have triggered escalation, since it looks acceptable in isolation; the combined view is what reveals the real risk.
Second, waiting even one more day for confirmation shortens the buyer's own remaining options further, since the warning window this metric has already proven predictive is measured in days, not weeks.
Mona should escalate today, citing the specific combined figures, efficiency, rising backlog, and the proven warning window against the remaining days, rather than waiting for a fourth day of rising backlog to remove any doubt, since the worksheet's own purpose is to act on a proven leading indicator before that certainty arrives.
With only 2 days of buffer left between the proven 9-day warning window and the style's own 11 remaining days, waiting even one more day to escalate would cut that buffer in half, leaving Northline Apparel and Delta Garments far less room to arrange a contingency, an airfreight upgrade or a revised delivery date, than acting on today's own combined worksheet reading. This is the last lesson in Course 3; the combined worksheet built here is the tool Delta Garments now runs every week across its own hybrid lines.
Open the course workbook's "Complete worksheet" sheet. Enter each style sharing a line, its own real question, its own calculated efficiency, its own tracked predictive metric and warning window, and its own days remaining before deadline; the sheet flags any style whose warning window is shorter than its own days remaining with a live formula.
[Download the Dashboards and shop-floor analytics worksheet](../../templates/T26-C03-dashboards-and-shop-floor-analytics-worksheet.xlsx)
Download the Dashboards and shop-floor analytics worksheet (Excel)
1. A hybrid line's export style shows 83% efficiency, a 9-day proven warning window, and 11 days remaining before its port cut-off. What does the combined worksheet indicate?
2. A factory keeps its dashboard, efficiency spreadsheet, and predictive-metric notes in three separate files that nobody reviews together. What is the most likely consequence?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Combined worksheet | ورقة العمل المجمَّعة | Fiche combinée | Birleşik çalışma sayfası | A single tool that brings a dashboard's one real question, a line's own efficiency calculation, and a predictive-metric test together for one line or order. |
| Per-style tracking | التتبع حسب الطراز | Suivi par style | Stile göre izleme | Keeping a hybrid line's own dashboard, efficiency, and predictive figures separate for each style it runs, rather than blended into one line-wide figure. |
| Weekly production review | مراجعة الإنتاج الأسبوعية | Revue de production hebdomadaire | Haftalık üretim değerlendirmesi | The regular meeting at which a factory checks its own dashboard figures, efficiency, and leading indicators against that week's own real output. |
| Risk flag | إشارة خطر | Signal de risque | Risk işareti | A worksheet's own marker showing that a specific style's own figures have crossed a threshold worth acting on. |
| Shared line capacity | سعة الخط المشتركة | Capacité de ligne partagée | Paylaşılan hat kapasitesi | The total run time a hybrid line has available, divided between the styles it carries in a given period. |
| Worksheet owner | مالك ورقة العمل | Propriétaire de la fiche | Çalışma sayfası sahibi | The person responsible for keeping a combined worksheet's own figures current and acting on any risk flag it raises. |
This is the last lesson of Course 3. You now know how to combine one real question, a line's own real efficiency, and a proven predictive metric into a single working worksheet. Back to the course map