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.
Each band comes with its condition and its reason. The bands are method, not client data - they travel across engagements.
| Variable | Band | Condition | Why the rule exists |
|---|---|---|---|
Price | -7% to -15% general | Absolute price, never an index | Price 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 competitor | Buyers are accustomed and the brand dictates category price - small changes barely move volume |
| • mid-pack | ~ -10% to -12% | Decent 15-20% share | Real substitutes exist, so sensitivity is moderate |
| • niche / new variant | -17%, -18%, up to -20% | Newly launched or premium-niche | Nothing 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-pack | It 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 engagements | Judge from yearly volume-vs-TDP behaviour | On-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 contribution | Promo-heavy brand; never exceeds TDP | Promo 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 contribution | Diagnose from YoY promo-volume deltas | Promo 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 more | Macros are slow-moving and mutually correlated (inflation and fuel prices together make no sense); degrees of freedom are scarce |
Intercept | ~45-50% established brand | Can run 10-60% by category and maturity | Brand equity plus unmodelled category effects carry the baseline; it must be sized before anything else can be |
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.
The EDA correlations (module 1.4) feed the bands through a simple mapping in the Target bounds theory sheet:
| Variable | Correlation with sales | Expected % contribution |
|---|---|---|
Distribution | > 60% | 35-45% |
| < 60% | < 35% | |
Price | > 40% | 7-10% |
| < 40% | 3-7% | |
CPI | > 50% | ~2% |
| < 50% | ~1% |
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.
Targets become config-ready coefficient bounds through a small factor method, one row per variable:
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.
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.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 practiceUL - 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 pitfallMathCo Methodology Understanding_UL.xlsxsheetsTarget bounds theory(correlation-to-contribution mapping) andTarget Bounds Calcs(factor method, 0.85/1.15 levy formulas, CONCAT config-string assembly - structure only) and sheetProcesssteps 6-9 (the bounds-iteration loop)- Real exhibit, reference only:
Onboarding Docs\knorr_bounds 4.xlsxsheetOverall(no values reproduced)