Syntha Lab RU

Merchandise plan traffic light

Compares actuals with the plan on key merchandise-plan metrics and colors each green, amber or red by your thresholds. Shows what to look at first. The default thresholds are neutral (“an example”): there is no single Russian benchmark, set them from your own past seasons and targets.

Buying budget and cash For whom: Category managers, buyers and finance people checking actuals against the merchandise plan.

Calculate on your data →

At a glance

What question does it answer?
Which plan metrics are already outside the tolerated deviation and where to look first.
What data is needed?
Per metric: plan, actual, the adverse direction, the deviation type and two thresholds.
How to read the result?
Default example: 2 red (maintained markup MMU: −6 pp against a red threshold of 3; unit sales: −15.8% against 15), 4 amber and 2 green. Look first at MMU. The queue is built by the share of the red threshold reached; red comes above amber. Example on the default values: Red metrics — 2; Amber metrics — 4; Green metrics — 2; Look first — 6 pp · Maintained margin (MMU), % (red).

Why and how to reason

A merchandise plan has many indicators, and a manager must grasp in a minute what to look at. The traffic light compares actual with plan and colors each indicator by thresholds: an adverse deviation below the amber threshold is green, between amber and red is amber, above red is red. Direction matters: for sales below plan is bad, for the share of discounts above plan is bad. Deviation can be relative (percent) or absolute (points). Example: sales 49.4 against a plan of 52 million, −5%, thresholds amber 3% and red 8%: amber. Share of discounts 20.5% against 18%, +2.5 points at thresholds of 2 and 5: amber. Initial margin 57 against 58: −1 point, amber. Sustained margin 44 against 50: −6 points at a red threshold of 3: red. In total 2 red, 4 amber, 2 green; look first at the indicator with the largest ratio to its red threshold.

When to use it

Use it for weekly and monthly control of the merchandise plan: sales, discounts, margin, stock, turnover. Thresholds in the example are illustrative: there is no single norm, set them from your past seasons and by which error is critical for you. It does not fit without a plan or for indicators without clear thresholds. A traffic light does not explain cause: it says what to look at, and for the cause go to the calculation on this topic.

How to read the result

Start with reds and with indicators near the red threshold. Sustained margin of 44% against a plan of 50% is red: check whether it is caused by deep discounts (share of discounts above plan) and early price cuts, i.e. a red indicator may follow from an amber one. If many ambers appear at once, look for a common cause (season, weather, supply). Decision on a red: name an owner and a deadline, on an amber: watch next week. Agree who answers red indicators and when: the traffic light helps only together with a regular meeting where each red gets a cause and an action.

Common mistakes

The usual mistakes: coloring by absolute numbers for indicators of different scale; setting thresholds too narrow (everything red) or too wide (everything green); mixing direction; changing the plan after the fact. Revisit thresholds once a season, not to fit the current result. Do not add indicators for which there is no plan or thresholds.

What data is needed?

  • Per metric: plan, actual, the adverse direction, the deviation type and two thresholds.
  • You set the thresholds from your own past seasons; in the example they are illustrative.

How it is calculated

StepFormula
Deviationactual − plan; in percent: (actual − plan) ÷ |plan| × 100
Adverse deviationdirection × deviation (positive means worse than plan)
Statusred if adverse ≥ red threshold; amber if ≥ amber threshold; otherwise green
Queuered and amber first, within them by the share of the red threshold

Worked numbers

Default values from the app; in the interactive version you enter your own.

Red metrics
2
Amber metrics
4
Green metrics
2
Look first
6 pp · Maintained margin (MMU), % (red)

What to look at first

MetricPlanActualDeviationAmber / red thresholdStatus
Maintained margin (MMU), %5044−6 pp1 / 3red
Sales, pcs per week120101−15.8 %5 / 15red
Sales, RUB million5249.4−5 %3 / 8amber
Share of discounted sales, %1820.52.5 pp2 / 5amber
Supplier fill rate, %9896.5−1.5 pp1 / 3amber
Initial margin (IMU), %5857−1 pp1 / 3amber
Forward weeks of supply (FWOS)109.5−0.5 weeks1 / 3green
Sell-through at the control week, %45472 pp2 / 5green

The thresholds and values in the example are illustrative. Set thresholds from your own past seasons and goals; in the US consultants and planning-software vendors publish thresholds of this kind, but that is a reference and not a standard for the Russian market.

Nuances and limits

  • Taking the example thresholds for a standard: there is no single Russian benchmark.
  • Mixing up the direction: for the discount share above plan is bad, for sales below.
  • Reading the color as the cause: a traffic light shows where to look.

Terms used

Calculate on your data →