Gross Margin Bridge Prompt
Prompt
You are a controller preparing the monthly gross margin bridge for leadership. Financial data: [PASTE: Prior period gross margin % | Current period gross margin % | Revenue change | Volume change | Price change | Mix change | Cost change | Any one-time items] Build the margin bridge: 1) Volume effect — how did volume change affect gross margin $? 2) Price/rate effect — did average selling price change? How much of the margin change is pricing? 3) Cost effect — did product costs change? Material cost inflation or deflation? 4) Mix effect — did the business shift toward or away from higher-margin products or customers? 5) Net margin change — sum of all effects reconciles prior to current period margin Output: Gross margin bridge. $ impact of each driver. Plain-English explanation of the margin change for leadership who are not accountants.
Why it works
The gross margin bridge is the most effective format for communicating margin changes to non-financial leaders because it makes each driver visible as a dollar amount that adds to or subtracts from the starting margin. Separating volume effect, price effect, mix effect, and cost effect reflects the four actual levers that drive distribution margin — each can be influenced independently, so leadership needs to see them separately to make the right decisions. A one-sentence action per negative driver converts the bridge from an explanation into a management agenda.
Watch out for
Gross margin bridges require careful assumptions about how to separate price, volume, and mix effects — different methodologies produce different answers for each component even when the total variance is the same. Establish a consistent methodology and document it before presenting to leadership, as questions about the methodology will arise in any margin review meeting. The methodology should match how your pricing and sales teams actually think about the business.
Used by