Explain a revenue change by price, volume and mix

Prompt that splits a revenue change into price, volume and mix effects and explains the biggest drivers. Paste it into an AI tool of your choice, which then splits the revenue change.

Topic: Spreadsheets & data
Type: Prompt
Level: Advanced
Time: about 15 min

Results depend on the tool, the model and what you enter.

Result preview

Example: written by our editors, not real AI output.

Fill in

What you type stays in this browser window. We store and send nothing.

ChangeWhat changed?

DataWhich data do you have?

AudienceWho gets the explanation?

Your prompt

Help me explain the following revenue change.
Change: [Change]
Data: [Data]
Audience: [Audience]
Approach: 1. Check that both periods contain the same products or groups and the same units; list any differences. 2. Calculate per product the volume effect at old prices, the price effect on the new volume and the mix effect from the shift between products. 3. Show that the effects add up to the total change; name any remainder and why it remains. 4. Name the two or three biggest drivers in plain words. 5. Suggest one chart that shows the bridge from the old to the new figure. 6. Mark where the data is too thin for a firm statement.
Output: table of effects per product, bridge from old to new total, three key sentences for the audience.

Take particular care to make the effects add up to the total change and check units first.

Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.

Help me explain the following revenue change.
Change: [Change]
Data: [Data]
Audience: [Audience]
Approach: 1. Check that both periods contain the same products or groups and the same units; list any differences. 2. Calculate per product the volume effect at old prices, the price effect on the new volume and the mix effect from the shift between products. 3. Show that the effects add up to the total change; name any remainder and why it remains. 4. Name the two or three biggest drivers in plain words. 5. Suggest one chart that shows the bridge from the old to the new figure. 6. Mark where the data is too thin for a firm statement.
Output: table of effects per product, bridge from old to new total, three key sentences for the audience.

Take particular care to make the effects add up to the total change and check units first.

Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.

This is an instruction for an AI, not the result itself.

Where this prompt works

These AI tools are a good fit for this prompt:

How to use it

Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
Copy the finished prompt into an AI tool of your choice.
Calculate the bridge once by hand for your largest product; if your numbers and the AI's numbers differ, check the units first.

Why does this work?

A single revenue figure hides opposite movements. Splitting it into price, volume and mix shows whether a change comes from what customers pay, how much they buy or what they buy.

Tips

Remove customer names before pasting invoice data; products and figures are enough.

You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use

Explain a revenue change by price, volume and mix

Result preview

Fill in

Your prompt

Where this prompt works

How to use it

Why does this work?

Tips

Also a good fit

Spot mix effects in averages New

Find cardinality explosions in metrics New

Estimate customer lifetime value simply New