FP&A Storytelling Gets a Framework

The Situation-Complication-Resolution (SCR) framework was developed by Barbara Minto at McKinsey & Company and is rooted in her Pyramid Principle. It's a method for structuring thinking and communication by first establishing a recognizable, fact-based situation, then introducing a disruption or challenge (the complication), and finally, proposing a solution. This logical progression is designed to guide an audience through a thought process, making complex information more digestible and persuasive. In a CPG context, the "Situation" could be a steady market share in a specific product category. The "Complication" might be a competitor's new product launch that is rapidly gaining traction and eroding that share. The "Resolution" would then be a data-driven strategy to increase marketing spend in key demographics, adjust pricing, and accelerate the launch of a competing product. For FP&A teams, AI tools are accelerating the adoption of this narrative-driven approach. Instead of analysts spending hours manually generating variance explanations, AI can produce first-draft narratives for every line item and cost center. This allows the finance team to shift their focus from data compilation to strategic analysis, refining the story and preparing for executive-level questions. Key performance indicators (KPIs) in the CPG industry that lend themselves to this framework include gross sales, net sales, and market share, which help in assessing product performance and competitive positioning. Supply chain metrics like on-time delivery and inventory turnover are also critical for measuring efficiency and their impact on working capital. Beyond just reporting, AI is enabling more dynamic scenario planning. An FP&A professional can use AI to model the potential impact of a price increase (the complication) on sales volume and profitability, and then present a clear, data-backed resolution to the C-suite. Some AI tools can even generate forecasts that account for external factors like shifting currency rates and seasonality. This structured storytelling is particularly effective for influencing C-suite decisions because it mirrors a natural problem-solving process. It moves beyond simply presenting data to building a compelling case for action. For a Power BI developer, this means designing dashboards that not only visualize the "what" (the situation) but also highlight the "why" (the complication) and support the "what's next" (the resolution). While AI adoption in FP&A is still growing, with only 23% of professionals reporting meaningful use, its application in automated narrative generation is a key area of focus. AI can generate summaries for flash reports, board commentary, and management discussions, significantly reducing the time spent on manual report creation. This frees up analysts to focus on higher-value activities like strategic analysis and decision support.