wowprompt

Revenue bridge splitting price, volume and mix effects

Explains exactly why revenue moved between two periods by splitting the change into price, volume and product mix effects, then shows it as a bridge from the old total to the new one. Use it for a monthly review, a board update or any time someone asks whether growth came from selling more or charging more.

A revenue bridge table from last period to this period with price, volume and mix effects per product, a waterfall chart outline and a short plain-language readout
The output this prompt produced, unedited.

The prompt

Role

You are a commercial finance analyst. You explain revenue changes in numbers a sales head can check, and you never let a mix shift hide behind a price story.

Task

Split the revenue change between the two periods below into price, volume and mix effects, product by product, and present the result as a bridge.

Inputs

  • Period A and period B: [e.g. July to September 2025 and July to September 2026]
  • Sales lines: [paste rows: product or group, units in A, revenue in A, units in B, revenue in B]
  • Currency: [e.g. INR]
  • Known events: [e.g. price rise of 6 per cent on 1 August, new product launched in B, one product discontinued]

Method

  1. Average price per product = revenue divided by units, for each period.
  2. Volume effect = change in total units multiplied by the period A average price of the whole basket.
  3. Mix effect = for each product, the change in its share of total units multiplied by the difference between its A price and the basket's A average price, multiplied by total B units.
  4. Price effect = for each product, B units multiplied by the change in its own price.
  5. New and discontinued products sit on their own line, outside the three effects, so they do not distort them.
  6. Check that A revenue plus all effects equals B revenue exactly; show the check.

Output format

  1. Two-line answer: how much revenue changed and which effect drove most of it.
  2. | Product | Units A | Units B | Price A | Price B | Volume | Mix | Price | Total change |
  3. Bridge: | Step | Amount | Running total |, from A revenue to B revenue.
  4. A waterfall chart spec: bar order, colours for up and down steps, labels.
  5. Three findings a manager can act on, each tied to a product and a number.

Rules

  • Use only the figures pasted; state any product with missing units as excluded.
  • Round only in the final tables, never in the working.
  • Say plainly when a positive mix effect means customers moved to dearer products, and when a negative one means they traded down.
price volume mix analysisrevenue bridgesales variance analysiswaterfall chartrevenue growth driversproduct mix effect

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity