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

159

Management Accounting & FP&A

Intermediate

SaaS Rule of 40 Performance Review

Calculates the balance between growth and profitability for technology companies.

GPT-4oClaude 3.5 Sonnet

178

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

164