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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Margin when selling at full price | % | 58 | Initial margin in the price excl. VAT: (price − cost) ÷ price. |
| Target for the maintained margin | % | 54 | Margin of the plan after all discounts. A rule of thumb, replace with yours. |
| At most promotion weeks per month | weeks | 2 | The gap rule: weeks without promotions are needed for the reference price to recover. Empty: no check. |
How it is calculated
| Step | Formula |
|---|---|
| Discount budget | revenue 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 depth | permitted 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
| Month | Revenue at full price | Discount budget | Plan margin | Permitted depth | Weeks |
|---|---|---|---|---|---|
| January | 7 m ₽ | 840,000 ₽ | 52.3 % ▼ | 21.7 % | 3 ▲ |
| February | 6 m ₽ | 180,000 ₽ | 56.7 % | 58 % | 1 |
| March | 8.5 m ₽ | 340,000 ₽ | 56.2 % | 43.5 % | 1 |
| April | 8 m ₽ | 120,000 ₽ | 57.4 % | 87 % | 1 |
| May | 7.5 m ₽ | 225,000 ₽ | 56.7 % | 58 % | 1 |
| June | 7 m ₽ | 525,000 ₽ | 54.6 % | 29 % | 2 |
| July | 6.5 m ₽ | 780,000 ₽ | 52.3 % ▼ | 21.7 % | 3 ▲ |
| August | 8 m ₽ | 240,000 ₽ | 56.7 % | 58 % | 1 |
| September | 9.5 m ₽ | 142,500 ₽ | 57.4 % | 87 % | 1 |
| October | 10 m ₽ | 300,000 ₽ | 56.7 % | 58 % | 1 |
| November | 14 m ₽ | 1.47 m ₽ | 53.1 % ▼ | 24.8 % | 3 ▲ |
| December | 16 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.