Bound Setting I: Base Variables
Track 1 - Foundations · Module 1.6
All analysts
Course home
Learning ObjectivesModule 1.6 · ~45 min
Set defensible contribution bands for price, distribution, promo and macro variables using the program's heuristic ladder, conditioned on market position.
Map an EDA correlation into a contribution band, and apply the plus-minus 15% levy and final bound widths correctly.
Read the Target Bounds Calcs template: the factor method and the CONCAT assembly of config-ready bound strings.
What bound setting is

Bound setting is the program's proprietary craft: before the constrained model search runs, every variable receives an allowable coefficient range (LB/UB). The convention: base variables are bounded on contribution; media and other incremental factors are bounded on ROI (module 1.7). Two disciplines frame everything:

  • Everything must add back to 100%. The % volume contribution column across all drivers, intercept included, totals 100. Size the intercept first - ~45-50% for a very well-established brand - and you immediately know how little room remains for everything else. The intercept is high because brand equity, category effects and everything unmodelled live there (it later feeds the MDS split, Track 2.4).
  • Let the model speak inside the bounds. The first run at every level is unconstrained apart from signs - factors can swing to absurd magnitudes, but that run gives direction and relative size. Bounds then give the model a corridor, not a script. Reverse-engineering bounds from the due-to targets you want is a named pitfall: it takes the freedom out of the model.

Order of operations: intercept, then the base ladder below starting from the biggest driver per the EDA (usually distribution for an established CPG brand), then media, then competitor and halo, macro last and small.

The heuristic ladder

Each band comes with its condition and its reason. The bands are method, not client data - they travel across engagements.

VariableBandConditionWhy the rule exists
Price
-7% to -15% generalAbsolute price, never an indexPrice sits inside the 30-40% that price + promo + distribution jointly claim; an index masks how fast you cut vs the competitor
• leader~ -7%≥ ~50% share, no close competitorBuyers are accustomed and the brand dictates category price - small changes barely move volume
• mid-pack~ -10% to -12%Decent 15-20% shareReal substitutes exist, so sensitivity is moderate
• niche / new variant-17%, -18%, up to -20%Newly launched or premium-nicheNothing anchors loyalty yet - price is the easiest reason to walk away
Competitor avg price
50-70% of own price impact, positive sign≤ 50% max if you lead; ~70% if weak (4th of 5); can exceed 50% mid-packIt is a shadow of own-price sensitivity: if your price does not matter, your competitor's cannot either
Distribution (TDP)
30-35% typical leader; 20-45% observed across engagementsJudge from yearly volume-vs-TDP behaviourOn-shelf presence is the single biggest lever for an established brand: if the product is on the shelf, people buy it
Promo TDP
70-80% of the TDP contributionPromo-heavy brand; never exceeds TDPPromo distribution is a subset of distribution - visibility on top of reach, so it cannot out-contribute the reach itself
Promo price
50-60% of the total price contributionDiagnose from YoY promo-volume deltasPromo discounts are one slice of total price movement, not all of it
Macro (total)
2-5%, top variable ~2-2.5%Monthly data: only 1-2 macro variables; weekly allows moreMacros are slow-moving and mutually correlated (inflation and fuel prices together make no sense); degrees of freedom are scarce
Intercept
~45-50% established brandCan run 10-60% by category and maturityBrand equity plus unmodelled category effects carry the baseline; it must be sized before anything else can be
Check with SMERajesh Kumar Yerra
The mid-pack price default of -10% to -12% comes from a garbled transcript passage ("10 to 12"), interpreted as a starting magnitude for a mid-position brand - confirm the intended band before teaching it as a fixed rule.

Two cross-checks close the base side. The promo-intensity efficiency check: promo intensity = promo sales volume over own sales volume; total promo contribution (promo price + promo TDP together) should land at roughly 50% efficiency against it - a brand with 40% promo intensity should show total promo contribution near 18-20%, never the full 40. And the base-vs-incremental top-down check: when total media ASSR is around 4%, base-driven contribution should be at least ~80-85% - a mature brand's investments maintain awareness, they do not create the business.

From correlation to contribution

The EDA correlations (module 1.4) feed the bands through a simple mapping in the Target bounds theory sheet:

VariableCorrelation with salesExpected % contribution
Distribution
> 60%35-45%
< 60%< 35%
Price
> 40%7-10%
< 40%3-7%
CPI
> 50%~2%
< 50%~1%
Check with SMERajesh Kumar Yerra
The theory sheet's high-correlation distribution band (35-45%) sits above the KT session's typical leader set-point (30-35%, observed 20-45) - confirm which anchors current practice, and whether the promised correlation-by-market-position dictionary supersedes both.

Use correlation with judgement, not as a formula input. Its best use in KT practice is dispersion: set the national/total-sub-brand bound as the median, then push regions above or below it by their correlations. Across different sub-brands, correlation transfer is invalid - investment strategies and sales shares differ. And two correlations are explicitly untrustworthy: aggregated competitor price and aggregated competitor spends (spurious by construction; use the category snapshot instead).

The levy and the final widths

Once a contribution is set, the bound is not a point - it gets a plus-minus 15% levy around the set value (so a -7% price contribution becomes a band of roughly -6.5% to -8%). At the final model stage the widths settle at base variables plus-minus 20% and media plus-minus 5 to 7.5%: base gets more room because the EDA evidence behind it is strong and its share is large; media is held tighter because its expectations are benchmark-anchored to ASSR and small errors there distort ROI stories directly.

The Target Bounds Calcs template (structure only)

Targets become config-ready coefficient bounds through a small factor method, one row per variable:

factor = target / current   →   LB = 0.85 × factor × coefficient,  UB = 1.15 × factor × coefficient
the plus-minus 15% levy, applied around a rescaled current coefficient

Reading it: current is what the last model run delivered for this variable, target is what the ladder says it should deliver; their ratio rescales the current coefficient toward the target, and the levy opens a corridor around it. A CONCAT column then assembles the literal string pasted into the config - contrib_<variable>: [LB, UB] - flipping LB and UB order when the coefficient is negative so the smaller number always leads. The long-term block repeats the identical pattern three times, once per MDS pillar. This loop (model run → compare to targets → recompute factors → new bounds → re-run) is the Validations-Modeling handoff cycle in the Process SOP, and it continues until targets are met.

Real exhibit: open Onboarding Docs\knorr_bounds 4.xlsx, sheet Overall - a live instantiation of exactly this template on a real cell. Study its structure and formulas; its values are client data and are never quoted in course material.
Check Yourself
A brand leads its category at ~55% volume share with no close second; price correlation with sales is modest. Where does the ladder start its price contribution?
Why: the market-leader condition caps price sensitivity at the low end of the -7 to -15 band. The -17 to -20 zone belongs to niche and newly launched variants where nothing anchors loyalty.
You have set distribution (TDP) at 32% for a promo-heavy brand. Which promo TDP contribution is defensible?
Why: promo TDP is a subset of TDP - it can never contribute more than the distribution it rides on. For a promo-heavy brand the ratio rule puts it at 70-80% of the TDP figure.
A monthly-data cell has five candidate macro variables, all decently correlated with volume. What does the ladder say?
Why: monthly data means few data points, so degrees of freedom cap macro count at 1-2; correlated macros (inflation plus fuel price) must not coexist; and even the winning macro only earns ~2-2.5%, with the model picking the precise decimal.
Sources
Authored from:
  • UL - KT (2).docx (15 Jun session, Rajesh Kumar Yerra): the full base-variable ladder - price bands by market position, competitor-price ratios, TDP 30-35% (20-45 observed), promo TDP 70-80% of TDP, promo price 50-60% of price, promo-intensity ~50% efficiency check, macro 2-5% and the degrees-of-freedom cap, intercept 45-50%, the plus-minus 15 levy and final base ±20 / media ±5-7.5 widths, correlation-as-dispersion practice
  • UL - KT (4).docx (25 Jun session): unconstrained first run, contribution-vs-ROI bounding convention, the everything-adds-to-100% discipline, the reverse-engineering-from-due-tos pitfall
  • MathCo Methodology Understanding_UL.xlsx sheets Target bounds theory (correlation-to-contribution mapping) and Target Bounds Calcs (factor method, 0.85/1.15 levy formulas, CONCAT config-string assembly - structure only) and sheet Process steps 6-9 (the bounds-iteration loop)
  • Real exhibit, reference only: Onboarding Docs\knorr_bounds 4.xlsx sheet Overall (no values reproduced)