FMCG Joint Business Plan Value Gap Diagnostic
Evaluate trade spend efficiency, promotional lift, and margin sharing to close growth gaps in tier-one grocery retail accounts.
Use this analysis when preparing annual joint business planning (JBP) renegotiations with major supermarket or hypermarket chains. It identifies structural revenue shortfalls, off-shelf execution leakage, and misaligned margin targets.
Role: Senior Key Account Director specializing in enterprise FMCG commercial partnerships and retail joint business planning.
Context
- Target Retail Account: {{retailer_partner_name}}
- Focused Category: {{fmcg_category}}
- Current Trade Spend Intensity: {{historical_trade_spend_pct}}
- Historical Promotional Response: {{promo_lift_baseline}}
- Joint Annual Growth Ambition: {{current_growth_target_pct}}
- Vendor Fulfillment Performance: {{supply_chain_sla_score}}
Task
Generate a comprehensive JBP value gap analysis that evaluates revenue drivers, margin leakage, and promotional effectiveness to build a defensible renegotiation strategy for {{retailer_partner_name}} in the {{fmcg_category}} portfolio.
Method
- Baseline the current financial relationship by reconciling {{historical_trade_spend_pct}} against category sell-out velocity.
- Calculate the incremental volume efficiency by benchmarking {{promo_lift_baseline}} against retailer-funded price promotions.
- Identify operational friction by correlating {{supply_chain_sla_score}} with merchant penalties and lost off-shelf revenue.
- Map the gap between the baseline run rate and {{current_growth_target_pct}} across core distribution, new product development (NPD), and promotional intensity.
- Stress-test margin parity across the manufacturer and retailer P&L under varying promotional discount depth scenarios.
- Formulate three commercial trade-offs (e.g., conditional rebates, digital retail media credits, supply chain tolerance shifts) to bridge the financial gap.
- Detail risk mitigation steps for retailer pushback regarding private label prioritization or listing fee demands.
Constraints
- Analysis MUST explicitly isolate net revenue realization from gross volume gains.
- Recommendations MUST NOT propose unconditional baseline price reductions.
- Must tie all trade funding reallocation directly to measurable volume milestones.
- Tone must remain objective, commercially rigorous, and negotiation-ready.
Output format
Provide the analysis in four structured sections:
- Executive Summary: 3-4 sentence commercial health check.
- Joint Value Bridge: Itemized breakdown quantifying the path to {{current_growth_target_pct}} across core volume, NPD, and trade mechanics.
- Promotional ROI and Margin Diagnostic: 3-5 bulleted evaluations of current trade funding vs. category volume returns.
- Commercial Negotiation Levers: Exactly three structured bargaining plays formatted with Offer, Retailer Ask, and Fallback Position.
Self-review
- Confirm all six contextual variables are explicitly addressed in the calculations and recommendations.
- Check that trade spend efficiency is mathematically linked to the growth gap.
- Verify no unstructured boilerplate text is included.
Explicit role, a named task, and discrete steps the model can follow.
Background, inputs and variables the model needs before it starts.
Hard boundaries — what the model must and must not do.
A named, field-level shape for the response.
Ordered work items that force analysis before an answer.
Length and structure that travel across frontier models.
Signal density — instruction weight without padding.
Documented variables so the scaffold adapts to new inputs.
Quality bar, assumptions and behaviour when inputs are thin.
How much real usage the template has behind it.