Account plans
AuraScore 81/100

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.

Template

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

  1. Baseline the current financial relationship by reconciling {{historical_trade_spend_pct}} against category sell-out velocity.
  2. Calculate the incremental volume efficiency by benchmarking {{promo_lift_baseline}} against retailer-funded price promotions.
  3. Identify operational friction by correlating {{supply_chain_sla_score}} with merchant penalties and lost off-shelf revenue.
  4. Map the gap between the baseline run rate and {{current_growth_target_pct}} across core distribution, new product development (NPD), and promotional intensity.
  5. Stress-test margin parity across the manufacturer and retailer P&L under varying promotional discount depth scenarios.
  6. Formulate three commercial trade-offs (e.g., conditional rebates, digital retail media credits, supply chain tolerance shifts) to bridge the financial gap.
  7. 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:

  1. Executive Summary: 3-4 sentence commercial health check.
  2. Joint Value Bridge: Itemized breakdown quantifying the path to {{current_growth_target_pct}} across core volume, NPD, and trade mechanics.
  3. Promotional ROI and Margin Diagnostic: 3-5 bulleted evaluations of current trade funding vs. category volume returns.
  4. 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.
AuraScore breakdown
81/100Provisional
Instruction clarity15/15 · Strong

Explicit role, a named task, and discrete steps the model can follow.

Context architecture12/12 · Strong

Background, inputs and variables the model needs before it starts.

Constraint engineering10/12 · Adequate

Hard boundaries — what the model must and must not do.

Output specification6/14 · Thin

A named, field-level shape for the response.

Reasoning structure10/10 · Strong

Ordered work items that force analysis before an answer.

Model compatibility10/10 · Strong

Length and structure that travel across frontier models.

Token efficiency5/10 · Thin

Signal density — instruction weight without padding.

Reusability7/7 · Strong

Documented variables so the scaffold adapts to new inputs.

Robustness5/5 · Strong

Quality bar, assumptions and behaviour when inputs are thin.

Observed performance1/5 · Thin

How much real usage the template has behind it.

sales
sales-account-plans
retail-consumer-goods
retail
fmcg
trade-spend