margin-decomposition

Decompose CPG margin changes across P&L layers with waterfall analysis.

1|1|Updated Feb 19, 2026
One-click install
npx skills add https://github.com/GoldenZero/skills --skill margin-decomposition-goldenzero
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: margin-decomposition
Source: https://github.com/GoldenZero/skills/tree/main/skills/margin-decomposition
Command: npx skills add https://github.com/GoldenZero/skills --skill margin-decomposition-goldenzero

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps CPG companies systematically identify and quantify the drivers behind changes in their profit margins, enabling better strategic decision-making.

Core Features & Use Cases

  • Waterfall Analysis: Decomposes margin changes across P&L layers (Gross Revenue, Gross Profit, Contribution Margin, Operating Profit).
  • Driver Quantification: Isolates the impact of price, mix, volume, input costs, trade spend, and structural shifts.
  • Use Case: A CPG brand manager needs to explain a 2% drop in gross margin to leadership. This Skill can pinpoint whether the decline was due to rising commodity prices, unfavorable product mix, increased trade promotions, or other factors, and quantify each.

Quick Start

Analyze my Q3 margin performance against Q2, detailing the key drivers of change.

Frequently Asked Questions about margin-decomposition

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I decompose CPG margin changes to explain profitability trends to leadership?

To decompose CPG margin changes, you can use waterfall analysis and the DuPont framework to isolate the specific impacts of price, volume, mix, input costs, and trade spend on your profitability trends. This requires detailed current and prior period P&L data.

What is the best way to quantify drivers of gross margin erosion in a CPG business?

The best way to quantify gross margin erosion drivers is through contribution margin bridges and waterfall analysis across P&L layers. This approach pinpoints whether declines stem from rising commodity prices, unfavorable product mix, or increased trade promotions, and quantifies each factor.

How does a waterfall analysis work for investigating cost structure shifts?

Waterfall analysis for cost structure shifts works by sequentially decomposing margin changes across P&L layers, from gross revenue down to operating profit. It isolates and quantifies the individual financial impact of structural shifts, input costs, and trade spend.

What data do I need to perform a DuPont analysis on CPG margin performance?

To perform a DuPont analysis on CPG margin performance, you need detailed P&L, volume, pricing, cost, mix, and trade spend data for both current and prior periods. This comprehensive dataset enables accurate driver quantification and margin deep-dives.

Can I use contribution margin bridges to analyze trade spend effectiveness for CPG brands?

Yes, contribution margin bridges can analyze trade spend effectiveness by isolating its specific impact on overall margin changes. By decomposing the P&L layers, the analysis quantifies how increased trade promotions affect gross profit and operating margins.

Why does my CPG margin drop despite stable sales volume?

A CPG margin drop despite stable volume often results from unfavorable product mix, rising input costs, or increased trade spend. Margin decomposition isolates these specific drivers, explaining exactly how structural shifts and pricing impact overall profitability.