Across four lessons, this course has built one skill at a time: naming a KPI by the decision it supports, telling a leading indicator apart from a lagging one, checking the data behind a dashboard number, and turning a report finding into an action with an owner and a date. None of those skills is useful on its own if it lives in a different file, a different meeting, or a different person's head each time.
This final lesson mainly teaches the decision flow of assembly: one workbook, used by Cedar & Co. as the buyer managing its own domestic stock program alongside Order A's export figures already used throughout this course, so a KPI's full life, from definition to closed action, is visible on one screen.
You need: all four earlier lessons in this course. This lesson does not introduce a new KPI rule; it combines the rules from Lessons 4.1 to 4.4 into one working tool.
By the end of this lesson you can:
Not covered here: dashboard software or automation; this course stays vendor-neutral, and the workbook is built to be used with any spreadsheet tool.
| Term | Meaning |
|---|---|
| KPI catalogue | A single list of every KPI a business tracks, with its decision, owner and trigger value recorded together. |
| Review cycle | The regular interval, such as monthly, at which a business checks its KPIs and closes or updates its actions. |
| Data-check history | A record of when a KPI's inputs were last checked and what correction, if any, was found. |
| Action tracker | A single record of every action, its owner, its follow-up date, and whether it was closed on time. |
| Closed action | An action confirmed as completed at or before its follow-up date. |
| Recap | Bringing together tools built separately across earlier lessons into one combined resource. |
A spreadsheet that only lists KPI values is a dashboard, not a management workbook. The workbook this course builds toward does four things together: it defines each KPI by its decision (Lesson 4.1), separates its leading and lagging pair (Lesson 4.2), logs when its data was last checked (Lesson 4.3), and tracks the actions it has triggered through to closure (Lesson 4.4). A tool missing any one of these stages leaves a gap the same size as the lesson it skipped.
| What can differ | The shapes you will meet | Why it matters to you |
|---|---|---|
| Export, made-to-order review | The KPI catalogue entry for Order A's cumulative-sewing KPI names Karim as owner and the port-cut-off margin as the trigger. | The same catalogue row format works whether the decision is about overtime, air freight, or a shipping method. |
| Domestic, made-to-stock review | Cedar & Co.'s stock-cover KPI catalogue entry names Omar as owner and the reorder lead time as the trigger. | The workbook does not need a separate structure for a domestic order; only the content in each row changes. |
| Buyer or brand-side review | A buyer's leading-KPI row records that its trigger opens a conversation, not a factory instruction. | The action tracker still applies the same owner-and-date discipline even when the action is a conversation, not a production step. |
| Mixed export and domestic portfolio | One action tracker holds both Order A's export action and Cedar & Co.'s domestic action from the same monthly review. | Comparing follow-up dates across both rows is what lets a reviewer prioritise by urgency, not by order type. |
| Different product families | A hosiery KPI catalogue row and a bedding-set KPI catalogue row use the same four columns, only the KPI name and figures differ. | The workbook's structure is genuinely reusable across every product family this course has already covered. |
Cedar & Co. buys its own domestic stock from Delta Garments, reordering a lot sized at Order A's own equivalent quantity of 15,000 pieces. This month, Cedar & Co.'s buyer, acting as the owner of its own supply decisions, opens one workbook to run the full review: the KPI catalogue shows the stock-cover KPI, its decision (whether to place a reorder), and its owner (Omar). The leading/lagging sheet confirms stock cover is the leading indicator, watched weeks before an actual stock-out, the lagging result it exists to prevent. The data-check log shows the in-transit correction found in Lesson 4.3, so the same 2,000-piece error is not rediscovered as if it were new. The action tracker shows the reorder decision raised, its 3-day follow-up date, and whether it was closed on time.
Alongside this domestic KPI, the same workbook carries Order A's export KPI from Lessons 4.1 and 4.2, so the reviewer compares both orders' urgency side by side in one sitting, exactly as Lesson 4.4 described.
The worked numberThis course has already fixed both fallback costs a missed KPI can lead to on Order A:
And Cedar & Co.'s domestic reorder lot carries its own delivered cost:
The workbook itself has no cost beyond the time spent maintaining it each month; its whole value is the difference between catching these findings within their own margin and missing them. A single missed trigger on either order can cost between USD 2,250 and USD 36,750 depending on which decision is missed; a workbook that reliably tracks the KPI, its check, and its action is what keeps that difference from becoming a recurring cost every month.
A common mistake is treating the workbook as a one-time project: filled in carefully for the first review, then left unopened until a problem forces someone to rebuild it from scratch. A stale workbook is worse than no workbook, because it gives a false sense that KPIs are being tracked when the data-check dates and open items inside it are months old.
The better habit is to open the same workbook at every review, update it live during the meeting, and treat an unresolved open item as a standing agenda item until it closes.
Everything this course has taught only works if it lives in one place a business actually returns to. A KPI needs a decision behind it, a leading version that warns early, a record of when its data was last checked, and a tracked action with an owner and a date. Put all four in the same workbook, used by the same review, every time. A tool that is rebuilt from memory each month will always be weaker than one that simply gets reopened and updated.
Cedar & Co.'s reviewer opens the workbook for this month's review. The action tracker shows last month's domestic reorder action, with a 3-day follow-up date, is still marked open two weeks later; no one confirmed whether the reorder was actually placed. This month's new findings, including Order A's fabric-receipt check, are ready to be added.
Should the reviewer add this month's new findings first, or resolve the overdue open item before anything else? Decide before opening the answer.
The reviewer should resolve the overdue open item first, before adding any of this month's new findings to the tracker.
1. An open item two weeks past its 3-day follow-up date is not a minor delay; it means the reorder decision may never have actually been confirmed, which is exactly the risk the follow-up date existed to catch. 2. Adding new findings on top of an unresolved item lets the workbook accumulate exactly the kind of stale, unchecked history Lesson 4.5 warns against. 3. Checking the open item first costs little time: a direct question to Omar about whether the reorder was placed either closes the item or reveals a real, still-unmanaged stock-out risk. 4. Only once the open item is closed or reassigned with a new follow-up date should this month's new findings be added, keeping the tracker's history reliable rather than a growing pile of unconfirmed actions.
The lesson from the whole course meets here: a workbook is only as good as the discipline of actually using it every cycle, not just filling it in once.
If Cedar & Co.'s overdue reorder action from the scenario above was in fact never completed, the business may already be facing the same stock-out risk Lesson 4.3 first identified, with its own cost in lost sales during any week the shops have no stock to sell. If Order A's fabric-receipt finding from Lesson 4.2 had been left similarly unresolved, the order would already be running the same overtime-or-air-freight choice: USD 2,250 if caught in time, or USD 27,000 if not.
The workbook itself never removes risk; it only gives a business the chance to catch it while catching it is still affordable. A workbook filled in once and never reopened returns almost none of that value.
Use the T17-C04 KPI and decision-data workbook exactly as assembled in this lesson: a KPI catalogue, a leading/lagging pairing sheet, a data-check log, and an action tracker. Populate it first with Order A's export KPI and Cedar & Co.'s domestic KPI from this course, then bring your own next review's KPIs, findings and actions into the same four sheets.
[Download the KPI and decision-data workbook](../../templates/T17-C04-kpi-and-decision-data-workbook.xlsx)
1. What makes a spreadsheet a complete KPI and decision-data workbook rather than just a dashboard?
2. Why should the overdue domestic reorder action be resolved before this month's new findings are added?
3. A terry-towel factory's workbook has a KPI catalogue entry with no leading/lagging pairing and no data-check log, only a single displayed weekly output figure. What is missing?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| KPI catalogue | فهرس المؤشرات | Catalogue de KPI | KPI kataloğu | A single list of every KPI a business tracks, with its decision, owner and trigger value recorded together. |
| Review cycle | دورة المراجعة | Cycle de revue | İnceleme döngüsü | The regular interval, such as monthly, at which a business checks its KPIs and closes or updates its actions. |
| Data-check history | سجل فحص البيانات | Historique de vérification | Veri kontrol geçmişi | A record of when a KPI's inputs were last checked and what correction, if any, was found. |
| Action tracker | متتبع الإجراءات | Suivi des actions | Eylem izleyici | A single record of every action, its owner, its follow-up date, and whether it was closed on time. |
| Closed action | إجراء مغلق | Action clôturée | Kapatılmış eylem | An action confirmed as completed at or before its follow-up date. |
| Recap | تجميع مسبق | Récapitulatif | Özet toplama | Bringing together tools built separately across earlier lessons into one combined resource. |
This is the last lesson of Course 4. Course 5 builds on the reporting and decision-data habits you have practised here, applying them to who may change data, who may see it, and when a business should move beyond spreadsheets altogether. Back to the course map