Syntha Lab RU

Promotion calendar and discount budget

Turns a monthly promotion plan into a discount budget in money, calculates the maintained margin of the plan and the permitted depth at your target, and flags months overloaded with promotions and months below the target margin.

Discount mechanics and the promotion calendar For whom: Category managers, chain directors, brand heads and finance staff building the annual plan.

Calculate on your data →

At a glance

What question does it answer?
What discount budget and how many promotion weeks our margin can bear.
What data is needed?
Margin when selling at full price and the target for the maintained margin.
How to read the result?
By default the yearly budget is 6.16 m (5.7% of full-price revenue of 108 m) and the maintained margin of the plan is 55.5% against a 54% target. The permitted budget is 9.39 m. But January, July and November on their own are below the target (52.3%, 52.3% and 53.1%) and have 3 promotion weeks each against a limit of 2: the annual average hides the peaks. Example on the default values: Discount budget for the period — 6.16 m RUB; Budget as a share of full-price revenue — 5.7%; Share of sales on discount — 22.8%; Average depth (weighted) — 25.1%.

Why and how to reason

A promotion plan by month should be seen in roubles, because percentages hide scale. Monthly discount budget = full-price revenue × share of sales on promotion × depth. For example RUB 7 million in January, 40% of sales on promotion, depth 30% gives 7 × 0.4 × 0.3 = 840 thousand ₽. Summing by month: RUB 6.16 million, which is 5.7% of full-price revenue. Sustained margin of the plan: full margin 58% minus the effect of discounts, (0.58 − x) ÷ (1 − x), where x is the budget share of revenue: (0.58 − 0.057) ÷ 0.943 = 55.5%. The 54% goal is met with room. Allowed budget at the goal (0.58 − 0.54) ÷ 0.46 = 8.7% of revenue: RUB 9.39 million. But the average hides the months: three are below the goal and three have too many promotion weeks.

When to use it

It is meant for annual promotion planning and before agreeing a calendar with marketplaces and chains. Assumption: share in promotions and depth are estimated from past years. It does not fit a brand with no promotion history nor a calendar where promotions are imposed by a platform with no right to decline (there, count the consequences). Set the limit of promotion weeks from your experience: frequent promotions train buyers to wait for discounts.

How to read the result

Look at three things: sustained margin against the goal, the list of months below the goal and months with too many promotions. The allowed depth of a month hints where you can give more and where not. A discount budget of RUB 6.16 million against an allowed 9.39 million: there is room but it is uneven. Decision: move depth from weak months, cut promotion weeks in overloaded months, keep discounts for months where sales will not move without them. Align the calendar with purchase and marketing plans: a promotion without stock or advertising gives less than calculated, and an extra promotion in a weak month eats the margin of the whole year.

Common mistakes

The usual mistakes: taking the promotion share from discounted revenue instead of full price; computing average depth without weighting; ignoring returns that rise in promotions; planning promotions back to back with no pause. Remember sustained margin is the result of the whole year, not each month. Do not enter monthly revenue net of discounts: full-price revenue is needed.

What data is needed?

  • Margin when selling at full price and the target for the maintained margin.
  • By month: revenue at full price excl. VAT, share in promotions, average depth.
  • Optional: number of promotion weeks and their limit per month.

Inputs

FieldUnitValue in the exampleMeaning
Margin when selling at full price%58Initial margin in the price excl. VAT: (price − cost) ÷ price.
Target for the maintained margin%54Margin of the plan after all discounts. A rule of thumb, replace with yours.
At most promotion weeks per monthweeks2The gap rule: weeks without promotions are needed for the reference price to recover. Empty: no check.

How it is calculated

StepFormula
Discount budgetrevenue at full price × share in promotions × average depth
Maintained margin(full-price margin − x) ÷ (1 − x), where x = share × depth
Permitted budget share(full-price margin − target) ÷ (1 − target)
Permitted depthpermitted budget share ÷ share in promotions

Worked numbers

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

Discount budget for the period
6.16 m ₽Revenue at full price × share in promotions × depth, by month.
Budget as a share of full-price revenue
5.7 %
Share of sales on discount
22.8 %
Average depth (weighted)
25.1 %
Maintained margin of the plan
55.5 % · target 54 %
Permitted budget at the target
9.39 m ₽ · headroom 3.23 m ₽
Promotion weeks in total
20
Months below the target margin
3
Months overloaded with promotions
3More promotion weeks than the limit set.

Budget and margin by month

MonthRevenue at full priceDiscount budgetPlan marginPermitted depthWeeks
January7 m ₽840,000 ₽52.3 % ▼21.7 %3 ▲
February6 m ₽180,000 ₽56.7 %58 %1
March8.5 m ₽340,000 ₽56.2 %43.5 %1
April8 m ₽120,000 ₽57.4 %87 %1
May7.5 m ₽225,000 ₽56.7 %58 %1
June7 m ₽525,000 ₽54.6 %29 %2
July6.5 m ₽780,000 ₽52.3 % ▼21.7 %3 ▲
August8 m ₽240,000 ₽56.7 %58 %1
September9.5 m ₽142,500 ₽57.4 %87 %1
October10 m ₽300,000 ₽56.7 %58 %1
November14 m ₽1.47 m ₽53.1 % ▼24.8 %3 ▲
December16 m ₽1 m ₽55.2 %34.8 %2

3 month(s) below the target: January, July, November. The annual figure hides the discount peaks.

A yearly frame: 2–4 big events, 1–2 calendar ones, the rest local. Do not promote what you cannot reorder; keep new arrivals, drops and bestsellers on a closed list. Replace the norms with yours.

Nuances and limits

  • Look at months, not only the year.
  • Promotions without gaps: the customer gets used to them and the reference price falls.
  • Do not promote what cannot be reordered, or new arrivals, drops and bestsellers.
  • Thresholds (the limit of weeks, the margin target) are guides: replace with yours.

Terms used

Calculate on your data →