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
Beginner

Construction: Retainage & Cash Flow

Manages the 'held back' portion of construction payments.

GPT-4oGemini 1.5 Pro
0
0
41
Management Accounting & FP&A
Intermediate

SaaS: Churn Analysis & Retention Bridge

Explains the walk from Opening ARR to Closing ARR.

GPT-4oClaude 3.5 Sonnet
0
0
53
Management Accounting & FP&A
Beginner

Monthly variance analysis: budget vs actual with bridges

Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
49