Template · Finance close · Opening soon

Price-volume-mix analysis, product by product

Split the change in revenue between two periods into price, volume and mix for every product, with a total row. The three effects always add up to the change.

Book a demo

You bring

Previous period39 rows

ProductPrevious unitsPrevious revenue

Current period48 rows

Current productCurrent unitsCurrent revenue

Mammoth does the work

You get

One table8 rows

The change in revenue for each product, split into price, volume and mix.

ProductPrevious revenueCurrent revenueChangePrice effectVolume effectMix effect

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Price-volume-mix analysis: the resultSample data8 rows

Product	Previous revenue	Current revenue	Change	Price effect	Volume effect	Mix effect
All products	43,120	49,265	6,145	365	6,234.67	-454.67
Team plan	0	8,940	8,940	0	0	8,940
Setup service	10,000	5,500	-4,500	0	1,445.89	-5,945.89
Legacy bundle	4,200	0	-4,200	0	607.27	-4,807.27
Plus plan	10,140	12,870	2,730	0	1,466.13	1,263.87
Pro plan	8,010	10,080	2,070	-600	1,158.16	1,511.84
Add-on seats	2,790	3,895	1,105	205	403.40	496.60
Basic plan	7,980	7,980	0	760	1,153.82	-1,913.82

8 rows in the result · made from Previous period (39 rows) and Current period (48 rows). Sample data: illustrative figures, not business results.

What is price volume mix analysis?

Price-volume-mix (PVM) analysis explains why revenue changed: how much came from charging different prices, how much from selling more or fewer units in total, and how much from selling a different mix of products.

How it works

How to use the price-volume-mix analysis template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Sales lines from two periods: product, units, revenue (2 tables)

Previous period

Product
Previous units
Previous revenue

Current period

Current product
Current units
Current revenue

The steps it runs

1Match columns: Previous period
2Match columns: Current period
3Total this period by product
4Total last period by product
5Line up both periods by product
6Price, volume and mix

Every step is an ordinary Mammoth step you can open and change.

Price-volume-mix analysis: questions

How are the three effects worked out?

Volume is the change in total units at last period's mix and prices. Mix is the shift in each product's share of units, at last period's prices. Price is each product's price change on this period's units.

What about a product sold in only one period?

A new or dropped product has one price, so its whole change counts as mix.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.