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
BeginnerKPI tree: link strategy to drivers and metrics
Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
40
Management Accounting & FP&A
BeginnerMonthly 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
47
Management Accounting & FP&A
IntermediateCost allocation model: shared services and drivers
Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
66