Overview

Price-volume-mix analysis is vital in understanding the changes in sales and profits between two periods, between budget and actual or between model scenarios.

This comprehensive full-scope model allows to:

  1. Compare total prices, volumes, revenues and gross profit by product between two periods
  2. Figure out which products experienced the highest price, volume, revenue and profit changes, both positive and negative
  3. Visualize mix changes by products and by periods
  4. Determine which products affected the change in revenues (profits) and to what extent
  5. Build revenue and gross profit bridges for a particular product
  6. Split the revenue and gross profit changes into three components: price effect, mix effect and volume effect
  7. Calculate price-volume correlations

The model handles ten product and five annual periods (which can be amended to your requirements rather quickly). Every sheet allows selecting periods for the analysis independently from other sheets. You will most probably want to compare two consecutive periods but those can really be any two periods you choose.

The model uses professionally designed magazine-quality charts and mini-dashboards, such as horizontal waterfall chart or a ‘broken line’ (or ‘stepped line’) chart. Another feature of this model is the use of form controls (check boxes, list boxes, drop-down lists) to quickly select periods and products.

To make sure you can work with such charts and controls, I am providing detailed appendices with full instructions. Use them in your models and presentations to impress your clients, managers and colleagues!

The model contains 18 worksheets and uses no macros. It is accompanied by a detailed text guide.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
HR Analytics and Dashboard
551
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
1,176
85
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cap Table with Investor Returns, Derivative Instruments and Charts
1,216
1
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cost-Volume-Profit (Breakeven) Analysis
1,376
101
Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…
“Budget-versus-Actual” Charts
1,170
6
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
Due Diligence Tools and Methods
1,757
2
A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…
See All