margin-decomposition

Decompose P&L margin changes into price, volume, mix, and cost drivers.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/wassemgtk/skills-testing --skill margin-decomposition
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: margin-decomposition
Source: https://github.com/wassemgtk/skills-testing/tree/main/cpg-retail/strategy-exec/margin-decomposition
Command: npx skills add https://github.com/wassemgtk/skills-testing --skill margin-decomposition

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps businesses understand the exact reasons behind changes in their profit margins, pinpointing whether increases or decreases are due to pricing, costs, volume, or other factors.

Core Features & Use Cases

  • Detailed Margin Analysis: Breaks down margin changes across Gross Revenue, Gross Profit, Net Gross Profit, and Contribution Margin.
  • Driver Identification: Quantifies the impact of price, volume, mix, input costs, trade spend, and operational efficiencies.
  • Use Case: A CPG company notices a 2% drop in gross margin. This Skill can analyze the P&L data to reveal that the drop was primarily caused by a 1.5% increase in raw material costs and a 1% negative mix effect from a new product launch, while pricing actions partially offset these.

Quick Start

Use the margin-decomposition skill to analyze the Q3 margin change compared to Q2 using the provided P&L and volume data.

Frequently Asked Questions about margin-decomposition

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

FAQPage Schema
How do I analyze margin erosion and identify the root causes of profit changes?▼

Margin decomposition identifies root causes of profit changes by breaking down profitability across P&L layers. It uses waterfall analysis and contribution margin bridges to isolate the exact financial impact of pricing, volume, input costs, and trade spend.

What is a contribution margin bridge and how does it explain gross profit variance?▼

A contribution margin bridge explains gross profit variance by quantifying the individual impacts of price, volume, and mix changes. It visually bridges the gap between current and prior period profitability to show exactly where margin expansion or erosion occurred.

How do I perform a DuPont analysis on CPG P&L data to measure profitability drivers?▼

You perform a DuPont analysis on CPG P&L data by feeding detailed current and prior period financials, including revenue, COGS, and trade spend, into a decomposition framework. This isolates operational efficiencies and pricing actions impacting overall profitability.

What CPG financial data is required to decompose net gross profit and trade spend impact?▼

Decomposing net gross profit requires detailed current and prior period data for revenue, COGS, volume, pricing, cost, mix, and trade spend. This comprehensive P&L data is necessary to accurately quantify the specific drivers behind margin changes.

Can I use this margin analysis approach for a CPG company with complex trade spend and A&P structures?▼

Yes, this margin analysis approach is designed specifically for CPG companies with complex trade spend and A&P structures. It analyzes these specific P&L layers to pinpoint how promotional spending and advertising impact overall contribution margin.