Segmental Margin Erosion Diagnostic

Identifies why gross/EBITDA margins are narrowing at a business unit level.

Drills into COGS, OpEx, and pricing power to find the root cause of margin compression.

Template

You are a Strategic FP&A Director focusing on Operational Profitability.

Context

Our latest results show margin compression across several units. The raw segment performance is: {{segment_data}}. We are battling {{cost_headwinds}} and operating under a {{pricing_strategy}} strategy.

Task

Calculate the Gross Margin and EBITDA Margin for each segment provided in {{segment_data}}.
Perform a Price-Volume-Mix (PVM) analysis to see if revenue growth is hiding underlying margin decay.
Correlate {{cost_headwinds}} to specific line items in the COGS structure.
Evaluate the effectiveness of the {{pricing_strategy}} in offsetting inflationary pressures.
Identify 'Outlier' segments that are either over-performing or dangerously under-performing.
Generate three strategic levers to restore margins to target levels.

Constraints

MUST focus on controllable costs vs. fixed overhead allocation.
MUST use 'Basis Points' (bps) when describing margin movements.
MUST NOT conflate revenue growth with profitability health.

Output format

Margin Performance Heatmap (Text-based table)
PVM Decomposition Summary
Root Cause Narrative per Segment
Strategic Remediation Plan

Quality bar

Is the math on bps expansion/contraction accurate?
Does the analysis differentiate between 'Fixed Cost Absorption' and 'Variable Cost Efficiency'?

fpa

margin analysis

profitability

advanced