Owner dashboard: 10 indicators and a traffic light
Compares key business indicators with plan, colors the deviation as a traffic light with your tolerance and points to where to work out the cause. The set of indicators is a platform suggestion, replace it with your own.
At a glance
- What question does it answer?
- Which ten indicators to watch at what rhythm and where they have departed from plan.
- What data is needed?
- The actual for each indicator for its own period: week, month, quarter.
- How to read the result?
- Take the red indicators first: the “where to find the cause” column leads to the right calculation. The tolerance is illustrative, set your own. The set of indicators is a platform suggestion, replace it with your own. Example on the default values: Indicators included — 10; On track — 3; Attention — 4; Red — 3.
Why and how to reason
An owner needs not a 40-page report but ten indicators that show in time where something goes wrong. So each indicator is compared with its plan and colored: a favorable deviation gives on track, a small adverse one within tolerance gives attention, beyond tolerance red. Direction matters: sales growth is good, overdue receivables growth is bad, so an indicator carries a sign. Example: sales 3.1 million against a plan of 3.4 million is −8.8% with a 5% tolerance: red. Cash 9.2 million against 8.0 is +15%: on track. Overdue receivables 1.05 against 1.0 million are 5% worse than plan with a 10% tolerance: attention. In total 3 on track, 4 attention, 3 red, the worst −18%. The traffic light does not explain the cause, it says where to look, so each row has a hint on which calculation to open.
When to use it
It is useful for a weekly and monthly meeting: 10 indicators, the same rhythm, a plan for each. The set of indicators is the platform’s proposal, replace it with your own and keep those you can actually influence. It does not replace management accounting and does not fit a company without a plan: the traffic light compares with plan, so a bad plan makes the light meaningless. Set tolerances by the volatility of an indicator: 5% for sales, 10% for stock.
How to read the result
Start with reds, then attention items that risk turning red. Check for groups: red sales and red cash together is a signal of a different scale than a single red row. The worst deviation hints where to start but is not always the most important: compare in roubles. For each red, name a cause and an owner before the next meeting. If everything is green for months, tolerance is too wide or the plan too soft. Assign an owner to each red indicator and a date by which he brings the cause and action, and start the next meeting with them, not with the general picture.
Common mistakes
The usual mistakes: not setting direction (growing overdue would turn green); taking a plan with no basis; too narrow a tolerance, so everything is red and the signal is lost; looking at the color without causes. Do not add indicators that lead to no decision. Do not change the plan after the fact just to turn an indicator green.
What data is needed?
- The actual for each indicator for its own period: week, month, quarter.
- The plan or limit and the tolerance you are ready to accept.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Common tolerance for deviation from plan | % | 5 | Optional. A rule of thumb; a row can have its own tolerance. Within tolerance: attention, beyond: red. |
How it is calculated
| Step | Formula |
|---|---|
| Deviation | (Actual − plan) ÷ |plan|, allowing for the indicator’s direction |
| Traffic light | Not worse than plan: on track; worse but within tolerance: attention; beyond: red |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Indicators included
- 10
- On track
- 3
- Attention
- 4
- Red
- 3
- Worst against plan
- −18.2 % · EBITDA, % of revenue
Traffic light by indicator
| Indicator | Rhythm | Actual | Plan | Vs plan | Status | Where to find the cause |
|---|---|---|---|---|---|---|
| Weekly sales, RUB | Week | 3,100,000 | 3,400,000 | −8.8 % | red | Sales plan, forecast |
| Cash on accounts against payments for 4 weeks, RUB | Week | 9,200,000 | 8,000,000 | 15 % | on track | Cash flow by month |
| Overdue receivables, RUB | Week | 1,050,000 | 1,000,000 | 5 % | attention | Cost of payment terms |
| Season sell-through, % | Week | 53 | 55 | −3.6 % | attention | Sell-through and season pace |
| Gross margin, % | Month | 56.4 | 56 | 0.7 % | on track | Channel margin |
| Stock, days of sales | Month | 128 | 120 | 6.7 % | attention | Days of inventory and excess |
| Advertising to revenue, % | Month | 14.6 | 15 | −2.7 % | on track | Advertising: ROAS, ad share and ROMI |
| Repeat customer share, % | Month | 24 | 28 | −14.3 % | red | Repeat purchases |
| EBITDA, % of revenue | Quarter | 9 | 11 | −18.2 % | red | Fixed and variable costs |
| Cash conversion cycle, days | Quarter | 96 | 90 | 6.7 % | attention | Cash conversion cycle |
Meeting rhythm (a platform suggestion): weekly 30 minutes on cash and sales; monthly on margin, stock and marketing; quarterly on strategy, budget and goals. A red indicator is a reason to find the cause, not excuses.
Nuances and limits
- Too many indicators and no owner for each.
- Indicators used to fit rather than to measure.
- A tolerance without a reason: one percent for everything.