Intermediate

Sales variance: price-volume-mix with segment insights

Creates a PV/M decomposition for sales and highlights segment-level drivers. Useful for commercial leaders and board packs.

Perform sales variance analysis for {period}.

Inputs:
- Sales by product/segment: {sales_by_segment}
- Prices and discounts: {pricing_discounts}
- Units/volume: {units_volume}
- Prior period and/or budget: {comparison_basis}

Output:
1) PV/M table by segment: Price, Volume, Mix effects.
2) Top drivers (top 5) with quantified impact.
3) Commentary on discounting, churn, and expansion (if inputs included).
4) Recommendations for next period focus.

Include a “data limitations” note if segmentation is incomplete.

Related Prompts

Management Accounting & FP&A

Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

172

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

169

Management Accounting & FP&A

Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet

160