Revenue Variance Deep Dive AI Prompt

Decompose the revenue variance between two periods into price, volume, and mix effects.

Period A data: {{period_a_data}} (product/segment, units sold, average price)
Period B data: {{period_b_data}}

1. Total revenue variance:
   Total Variance = Revenue_B - Revenue_A (absolute and % change)

2. Three-way variance decomposition:

   Volume variance:
   = (Total Volume_B - Total Volume_A) x Average Price_A
   What revenue would have changed if only volume changed (price and mix held constant)?

   Price variance:
   = (Average Price_B - Average Price_A) x Total Volume_B
   What revenue changed because we charged more or less per unit?

   Mix variance:
   = (Actual mix revenue at Period A prices) - (Expected mix revenue at Period A prices)
   What revenue changed because the product/segment mix shifted toward higher or lower value items?

   Verify: Volume Variance + Price Variance + Mix Variance = Total Revenue Variance

3. Product/segment level detail:
   For each product or segment:
   - Revenue Period A, Period B
   - Volume change, price change
   - Contribution to total volume/price/mix variance

4. Mix analysis:
   - Which products gained share of revenue mix? Which lost share?
   - Did mix shift toward higher-margin or lower-margin products?
   - Revenue at period A prices if mix were held constant: how much did mix cost or add?

5. Strategic implications:
   - Is revenue growth coming from volume (sustainable, market share driven) or price (possible unsustainable if it drives churn)?
   - Is the mix shift favorable (premiumization) or unfavorable (commoditization)?

Return: three-way decomposition table, product-level detail, mix shift analysis, and strategic implications.