RGMAcademy
Talk to us
Free tool · no login required

Source-of-Volume Decomposer

Decompose promotional volume into its four standard sources (Switching / Expansion / Pantry / Consumption), surface the dominant source, and read the Event Margin against the durability-weighted Durable Value before signing the trade plan. The same interactive model the full RGM Academy course uses for TPO Lesson 2, no auth, no paywall.

Updated 23 April 2026Extracted from the Trade Promotion Optimization module, lesson 2: Source of Volume Decomposition
Loading calculator…
Guided walkthrough

Explore the tool, from setup to common mistakes

Five short sections explain the scenario, what each control does, how to read the output, and the mistakes to avoid. Open whichever helps. The tool above works without them.

5.1Scenario setup

The starting SKU, market, and assumptions the model makes.

You are the Trade Marketing Director on a mainstream biscuit brand. Your Q4 trade plan has a 20%-off feature‑and‑display event on the 250g SKU, $4.99 to $3.99 RSP. Sales delivered: total promoted volume was 15K units versus a 5K/week baseline, so the gross incremental uplift was 10K units. The Sales team wants to run the event again in Q1. Finance has asked for the source‑of‑volume decomposition before signing off. They want to know whether the 10K uplift was genuine growth or whether it was mostly pantry loading and loyal‑buyer subsidy.

Your job by Friday: decompose the 10K uplift into its four standard sources (Brand Switching / Category Expansion / Pantry Loading / Consumption Increase), calculate the Productivity Ratio, the Event Margin, and the Durable Value, and return a GOLDEN / PRODUCTIVE / MIXED / UNPRODUCTIVE verdict to Finance. Then stress‑test whether a deeper (30%) discount or a shallower (15%) discount would move the mix in a better direction.

Your objective

Use the decomposer to diagnose the current mix, identify the dominant source, classify the event, and test one mix-improvement hypothesis before committing the Q1 trade plan.

Key assumptions

  • The four sources are mutually exclusive and sum to 100% of gross incremental uplift. Consumption Increase is the 100‑residual. It is NOT a separate slider. This matches the lesson sandbox exactly; it also means the three sliders (switching / expansion / pantry) cannot sum above 100% (an overAllocated warning fires if they do, and the tool clamps consumption to 0).

  • Productive volume = Switching + Expansion + Consumption. Pantry is the only source treated as unproductive. That reflects the practitioner reality: switching 'steals' share (productive for the manufacturer, durable if shoppers stay), expansion brings genuinely new category demand (productive, durable), and consumption increase reflects habit‑change (productive if the habit sticks, but it collapses back into baseline if not). Pantry is pure timing shift (bought now instead of next week, creating a post‑promo dip).

  • Two headline numbers. The Event Margin is the flat event‑window cash: productive volume x $1.89 promo margin, minus the $1.00/unit pantry cost. The Durable Value weights each productive source for how much survives once the promo ends (Category Expansion 1.0, Consumption Increase 0.8, Brand Switching 0.25) before subtracting the same pantry cost. Durable Value is always at or below Event Margin, and the gap is the volume that banks cash now but will not last. Pantry volume costs $1.00/unit, the gap between the full margin ($2.89) and the promo margin ($1.89), because that volume WAS coming anyway. This split is the core economic claim the framework rests on.

  • The SoV Quality verdict lands on one of four bands. GOLDEN needs productivity 70% or higher and expansion share 25% or more of total uplift (the mutual‑growth event the retailer cannot say no to). PRODUCTIVE is productivity 70% or higher but expansion share under 25%. MIXED is productivity 50 to 69%. UNPRODUCTIVE is productivity below 50%. The 25% expansion threshold is what separates a 'good for the manufacturer' event from a 'good for BOTH' event.

  • The scenario fixtures are fixed in this sandbox (one 250g biscuit SKU, $4.99 to $3.99, $2.89 to $1.89 margin). For a real‑world decomposition, the SKU, RSP, discount depth, and margin structure all vary; this tool teaches the STRUCTURE and the verdict gates, not the exact dollar math for your specific category.

5.2Controls & toggles

Every input the calculator exposes, its range, and what it changes.

ControlRangeDefaultWhat it changes
Total Promotional Uplift slider2,000 to 25,000 units (500-unit step)10,000 units (mid-range self-demo)Total incremental units beyond baseline. Scales every dollar metric linearly; productivity ratio and SoV quality are driven by MIX, not scale. So moving this slider changes both the Event Margin and the Durable Value proportionally without moving the quality verdict.
Brand Switching %0 to 80% (5% step)30% (3,000 units at 10K uplift)Productive source. Volume stolen from competitor brands. Counts toward the 70%+ productivity threshold; does NOT count toward the 25% Expansion threshold for the GOLDEN band (so a pure-switching event is PRODUCTIVE but never GOLDEN).
Category Expansion %0 to 50% (5% step)15% (1,500 units at 10K uplift)Productive source AND the GOLDEN-trigger. At expansion share 25% or more of total uplift, the quality verdict flips to GOLDEN (assuming productivity 70% or higher). The single most valuable source. Retailers measure their own category growth on this line.
Pantry Loading %0 to 70% (5% step)35% (3,500 units at 10K uplift, the dominant source at seed)Unproductive source. Costs $1.00/unit (full margin minus promo margin). Creates the post-promo volume dip. The single biggest net-value destroyer; reducing pantry share is the highest-leverage mix improvement.
Consumption Increase % (residual)Auto-computed = max(0, 100 - sw - ex - pl)20% at the seedProductive source IF the habit forms. Cannot be directly set. Derived as the 100-residual of the other three sliders. If the other three sum above 100, an overAllocated warning fires and consumption clamps to 0.
Productivity Ratio tile0% to 100%65% at seed (MIXED verdict)The summary metric. Colored green at 70% or higher, amber 50 to 69%, red below 50%. Combined with the expansion-share threshold, it sets the SoV quality verdict.
Event Margin and Durable Value tilesNegative to +$30K+ (Durable Value always at or below Event Margin)Event Margin +$8,785, Durable Value +$3,776.50 at seedThe Event Margin is the flat event-window cash; the Durable Value weights each source for how much survives, then subtracts the pantry cost. A wide gap between the two means the event is banking cash that will not last. Durable Value is green if positive, red if negative; negative means the event destroyed value even though total volume went up.
5.3Step-by-step exploration

7-step guided exploration of the scenario.

  1. Read the default seed, a MIXED event with net-positive value

    Leave every control at default. Read the four KPI tiles and identify the dominant source.

    Expected outcome: Switching 3,000, Expansion 1,500, Pantry 3,500 (dominant), Consumption 2,000. Productive volume 6,500 (65%); Unproductive 3,500. Productivity Ratio 65%, a MIXED band (colored amber). Event Margin +$8,785, but Durable Value only +$3,776.50, because the mix leans on switching (weighted 0.25) and pantry. The event is net-positive on both, but the gap between the two numbers, and the 35% pantry, tell you most of the headline cash will not last.
  2. Find the dominant source and understand why it matters

    Look at each of the four source‑volume tiles (Switching 3K, Expansion 1.5K, Pantry 3.5K, Consumption 2K). The highest is the 'dominant source'.

    Expected outcome: Pantry Loading is dominant at 3,500 units (35% of total). This is the event's single biggest economic problem: pantry volume doesn't generate new demand; it just borrows from the future. A dominant-pantry event tells you the promo mechanic (20% off, featured price) is being fished predominantly by existing loyal buyers. The trade plan is subsidising a purchase that would have happened anyway.
  3. Shift toward the GOLDEN quadrant, the trade plan you want

    Drag Switching to 0%, Expansion to 50%, Pantry to 0% (Consumption auto‑fills to 50%).

    Expected outcome: Expansion 5,000 + Consumption 5,000 = productive volume 10,000 (100%). Productivity Ratio 100% AND Expansion share = 50% of total uplift (well above the 25% GOLDEN threshold). Event Margin = 10,000 x $1.89 = **$18,900**, and because almost all of it survives, Durable Value is **$17,010**, close behind. SoV Quality is GOLDEN. This is the mutual-growth scenario the whole TPO framework aims for. The retailer grows their category, the manufacturer gains share, and the margin math works because no pantry cost eats into it.
  4. Force the UNPRODUCTIVE verdict, the event that destroys value

    Drag Switching to 0%, Expansion to 0%, Pantry to 70% (Consumption auto‑fills to 30%).

    Expected outcome: Pantry 7,000, Consumption 3,000. Productive volume 3,000 (30%). Event Margin = 3,000 x $1.89 - 7,000 x $1.00 = **-$1,330** (negative, colored red). Durable Value is worse still at **-$2,464**, because even the 3,000 consumption units are weighted 0.8. SoV Quality is UNPRODUCTIVE. The event raises total volume on the surface but destroys value underneath. Classic pantry-loading trap, the category of event where 'over one-third of promotions show negative net uplift after cannibalization' comes from.
  5. Test the switching-only hypothesis, PRODUCTIVE but NOT GOLDEN

    Reset. Then drag Switching to 80%, Expansion to 0%, Pantry to 0% (Consumption auto‑fills to 20%).

    Expected outcome: Switching 8,000 + Consumption 2,000 = productive 10,000. Productivity Ratio 100%. The Event Margin = 10,000 x $1.89 = **$18,900**, exactly the same event cash as Step 3's GOLDEN case, but the Durable Value is only **$6,804**, well under half of GOLDEN's $17,010, because switching is weighted 0.25 (switchers rarely stay). The SoV Quality verdict is **PRODUCTIVE**, not GOLDEN, because the expansion share is 0%. Same headline cash, very different durable outcome, and a very different retailer story: pure switching wins share from a competitor and does not grow the CATEGORY, so the category manager sees no net new shoppers.
  6. Scale test, does 2.5x the volume deliver 2.5x the value?

    Reset. Drag Total Uplift from 10,000 to 25,000 (2.5x the base). Leave the mix at default (30 / 15 / 35, Consumption 20).

    Expected outcome: Switching 7,500; Expansion 3,750; Pantry 8,750; Consumption 5,000. Productive volume 16,250 (still 65%, the mix is unchanged). Event Margin = **$21,962.50** and Durable Value = **$9,441.25**, each exactly 2.5x the 10K seed ($8,785 and $3,776.50). Both scale LINEARLY with total uplift IF the mix is held constant. The leverage is in shifting the mix, not in chasing more uplift at the same mix.
  7. Map back to the Net Incremental Profit Bridge and Pricing cross-references

    Open the related‑concept links (Promo ROI, Promo Baseline, Promo Mechanics, 13 TPO Levers). Cross‑reference the Promo ROI Calculator at the same scenario.

    Expected outcome: Understanding that the SoV decomposer is the DIAGNOSTIC lens. It tells you WHERE the volume came from. The [Promo ROI Calculator](/tools/promo-roi-calculator) is the MONEY equation that takes the SoV output as input and returns the Net Incremental Profit Bridge verdict (BEST / GOOD / REVIEW / STOP). The two tools are complementary: SoV explains WHY a promo event scored the way it did on Promo ROI; Promo ROI quantifies the dollar impact of the SoV mix. Cross-lesson: only Category Expansion cleanly clears the Pricing Lesson 2 "+11.1% operating profit per 1% price lift" opportunity-cost hurdle. Everything else is borrowing from competitors, from future purchases, or from habit-elasticity that may not stick.
5.4Reading the output

Every KPI, the formula behind it, and how to interpret a positive or negative value.

KPIFormulaHow to read it
Productive VolumeSwitching + Expansion + ConsumptionUnits that justify the promo spend, either new demand (Expansion), stolen competitor demand (Switching), or durable habit change (Consumption). The numerator of the productivity ratio.
Unproductive VolumePantry (loading) onlyUnits bought now that would have been bought later at full price. Creates the post-promo dip. Costs $1.00/unit (full margin minus promo margin), pure subsidy on already-captured demand.
Productivity RatioProductive Volume / Total Uplift x 100Green at 70% or higher, amber 50 to 69%, red below 50%, matched to the SoV-quality verdict bands (PRODUCTIVE 70% or higher, MIXED 50 to 69%, UNPRODUCTIVE below 50%). The single most important summary number; drives the SoV quality verdict in combination with Expansion share.
Event MarginProductive Volume x $1.89 - Pantry x ($2.89 - $1.89)Flat event-window cash, every productive unit at the promo margin, minus the pantry cost. What the promo banks during the event, before any durability discount.
Durable Value(1.0 x Expansion + 0.8 x Consumption + 0.25 x Switching) x $1.89 - Pantry x $1.00The same cash after each source is weighted for how much survives. Green if positive, red if negative; negative means the event destroyed value even though total volume went up. Always at or below Event Margin, and the CFO line every trade plan must clear.
SoV Quality verdictverdict bands over productivity + expansion shareGOLDEN (70%+ productivity AND 25%+ expansion share), PRODUCTIVE (70%+ productivity), MIXED (50 to 69%), UNPRODUCTIVE (below 50%). The one-word summary for a review deck.
Dominant Sourceargmax over {switching, expansion, pantry, consumption}The single largest source by units. A dominant-pantry event is the archetype bad promo; a dominant-expansion event is the archetype GOLDEN promo; switching- or consumption-dominant events need case-by-case judgement on durability.

Read Productivity Ratio first. That's the gate on whether the event crosses the 50% threshold into the viable zone. Then read Expansion share. That's the gate on whether it crosses the 25% threshold into GOLDEN. Then read the Durable Value. That's the dollar outcome that actually lasts. Finally, read Dominant Source. That's the single‑word diagnosis of what kind of promo mechanic this is: 'a switching event', 'an expansion event', 'a pantry‑loading event', 'a consumption‑building event'. Each has a different trade‑marketing narrative and a different durability horizon.

5.55 common mistakes to avoid

Diagnostic patterns that catch most misuse of this calculator in practice.

  1. Mistake 1Treating the Event Margin as the only decision metric
    Symptom: A Step 5-style scenario (switching 80%, Event Margin $18,900, the same as GOLDEN, but Durable Value only $6,804) gets approved on the headline cash, and the retailer category manager pushes back hard in the next cycle because "our category did not grow."
    Fix: The Event Margin is the manufacturer-side cash. The Durable Value and the SoV Quality (GOLDEN vs PRODUCTIVE vs MIXED) are the durability-and-relationship read. Always use both. A high-Event-Margin PRODUCTIVE event still banks cash for YOU, but a low Durable Value means little of it lasts, and it is not a retailer-shareable story. Events that hold the retailer relationship long-term need the GOLDEN verdict, which requires Category Expansion 25% or more of total uplift, achieved with a mechanic and communication combo (display plus sampling plus a genuine category claim, not just a price-off).
  2. Mistake 2Confusing gross incremental uplift with net incremental uplift
    Symptom: A trade plan claims +10,000 incremental units and gets approved; Q+1 analysis shows baseline dipped 3,500 units for 3 weeks afterward, so the REAL net gain was ~6,500 units.
    Fix: Pantry loading creates a post-promo dip roughly equal to the pantry-loaded volume (3,500 units in our default = 3,500 unit dip spread over 1-4 weeks). The SoV decomposer's `unproductive` tile is an early-warning signal for this dip. Always report net-incremental-after-dip, not gross-incremental. The Promo Baseline Estimator (Tool #10) quantifies the baseline-shift signal directly.
  3. Mistake 3Over-indexing on Brand Switching as 'productive'
    Symptom: The switching share is the biggest source, and the trade plan declares victory. Then in Q+2, the same shoppers switch back to the competitor's counter-promo and the share gain evaporates.
    Fix: Switching is productive ONLY if the switched shopper stays. Durability depends on (a) whether the switched shopper experiences a loyalty trigger (e.g. the product is genuinely better, or the promo buys one-time trial of a new item), (b) whether the competitor runs a counter-promo within 4-8 weeks. For "switching-dominant" events, always pair the SoV decomposition with a post-promo repeat-purchase cohort analysis; switching without repeat-purchase is a temporary share lift, not a durable win.
  4. Mistake 4Ignoring the Consumption Increase share because 'it's the residual'
    Symptom: Trade plan commentary treats Consumption as 'whatever is left' and doesn't design for it. Result: Consumption share stays low (0-15%), and the habit-forming opportunity is missed.
    Fix: Consumption Increase is productive volume IF the trigger that caused it persists post-promo. Designing for Consumption means the mechanic has a habit-forming element: subscribe-and-save, buy-more-use-more multi-packs, usage-occasion claims on pack ('great for lunchboxes'). The Consumption lever is under-invested in most FMCG trade plans. Events that deliberately design for Consumption Increase tend to outperform at the 12-month window even when their immediate Event Margin is lower than a pure-Switching event.
  5. Mistake 5Using the 20%-off scenario math to make decisions about a 10%-off event
    Symptom: A 10%-off shallow-discount event gets scored using the same productivity-ratio thresholds as the 20%-off default, and a PRODUCTIVE verdict turns out to be MIXED at shipped calibration.
    Fix: The thresholds (productivity 70% or higher, expansion 25% or more) are relatively stable across discount depths, but the ABSOLUTE numbers are not. A shallower discount typically shifts mix: less pantry loading (shoppers stockpile less at 10% off than 20% off), more switching (the 10% is usually too shallow to attract category expanders). The tool fixes scenario inputs at 20% off / $1.89 promo margin. To use it as a decision aid for other discount depths, you need to re-derive the promo margin mentally and adjust the mix expectations. For a real multi-depth comparison, cross-reference the [Promo ROI Calculator](/tools/promo-roi-calculator) which lets depth vary.
Related concepts

Go deeper on the theory

Continue with the lessons

Go further inside Trade Promotion Optimization

This calculator is the sandbox slice of Lesson 2: Source of Volume Decomposition. Each of the other 7 Trade Promotion Optimization lessons teaches a complementary concept that sharpens how you read the output above.

See Source-of-Volume Decomposer inside the full lesson

RGM Academy lets you pull every commercial lever yourself inside a senior-practitioner simulator, with the AI RGM Strategist coaching every decision you make.

Open the full Source of Volume Decomposition lesson

Or see what a team rollout includes