Blog · Board and management reporting
A price volume mix analysis dashboard shows which revenue changes come from pricing, unit growth, and the sales blend. This worked example covers the dashboard layout, scope controls, product exceptions, and the reconciliation that makes the review useful.
A price volume mix analysis dashboard turns a revenue change into a bridge that adds up, with price, volume, and mix shown beside the rows that explain them. The useful design combines a company result, a short bridge, and a product or customer exception table. Its first control is a zero reconciliation residual under a clearly stated reporting scope.
For a commercial finance review, the question is usually whether growth came from stronger realized prices, more units, or a shift toward higher-priced products. Those explanations lead to different follow-up work: pricing review, capacity planning, or investigation of the sales blend.
US public-company reporting provides a related reason to examine these drivers. Item 303 of Regulation S-K calls for discussion of the extent to which material net-sales changes reflect prices, volume, or new products and services. An internal bridge makes those commercial explanations measurable; it does not replace the company's reporting judgments.
Use the established price volume mix formulas for the calculation method. This page focuses on the review layout and controls, so the dashboard does not become a second formula manual.
Cedar Works Supply, an illustrative US fixtures distributor, compares August and September 2026. It sells Basic and Deluxe fixtures in comparable individual units, all in USD. Its net-sales export includes product, invoice date, quantity, and net revenue after credits and discounts.
Use invoice-line identifiers to prevent duplicate rows. Add customer and region only when those fields are present and consistent in both periods. Match products by stable codes rather than descriptions that may have changed.
| Product | August units | August price (USD) | August revenue (USD) | September units | September price (USD) | September revenue (USD) |
|---|---|---|---|---|---|---|
| Basic | 1,000 | 20.00 | 20,000 | 900 | 22.00 | 19,800 |
| Deluxe | 500 | 50.00 | 25,000 | 900 | 50.00 | 45,000 |
| Total | 1,500 | 45,000 | 1,800 | 64,800 |
Each revenue is units times price. Total revenue rose by 64,800 - 45,000 = $19,800, or 19,800 / 45,000 = 44.0%. Unit totals are 1,000 + 500 = 1,500 and 900 + 900 = 1,800. Dollars are exact here; percentages are displayed to one decimal place.
The declared convention values price changes at current units and volume and mix at prior prices. August's average price is 45,000 / 1,500 = $30.00. At September's total volume and August's proportions, the expected quantities would be 1,200 Basic and 600 Deluxe.
| Product | Price effect (USD) | Volume effect (USD) | Mix effect (USD) | Revenue change (USD) |
|---|---|---|---|---|
| Basic | +1,800 | +4,000 | -6,000 | -200 |
| Deluxe | 0 | +5,000 | +15,000 | +20,000 |
| Total | +1,800 | +9,000 | +9,000 | +19,800 |
The price effect is (22 - 20) x 900 = $1,800 for Basic and zero for Deluxe. The volume effect is (1,800 - 1,500) x 30 = $9,000, allocated using August's product proportions and prices. That produces $4,000 for Basic and $5,000 for Deluxe.
Mix is (900 - 1,200) x 20 = -$6,000 for Basic and (900 - 600) x 50 = $15,000 for Deluxe. Its total is $9,000. The price volume mix glossary gives the short definition to place beside a review pack.
The proof is 45,000 + 1,800 + 9,000 + 9,000 = $64,800. Each product also ties: Basic's 1,800 + 4,000 - 6,000 = -$200 equals 19,800 - 20,000; Deluxe's 0 + 5,000 + 15,000 = $20,000 equals 45,000 - 25,000. The residual is zero at both levels.
| Dashboard area | What it displays | What the reviewer learns |
|---|---|---|
| Scope strip | August versus September; USD; individual units; matched products; valuation convention | Which comparison the figures describe |
| Headline | Revenue 45,000 to 64,800; change +19,800; growth 44.0% | The size of the movement |
| Main bridge | Start 45,000; price +1,800; volume +9,000; mix +9,000; end 64,800 | The drivers that explain the change |
| Product table | The effect rows above, ranked by revenue change | Deluxe explains the gain; Basic declined |
| Check strip | Source revenue tie; product contribution tie; residual 0 | Whether the explanation is complete |
A waterfall is suitable because it displays the running balance after each effect. Microsoft's waterfall chart guidance explains this presentation and how to mark the starting and ending columns as totals in Excel. Keep dollar labels visible and use the same effect names in the table and chart.
Do not assign pricing performance from the bridge alone. A changed realized price may reflect discounts, contractual terms, or credits. Follow the relevant accounts with price realization by customer before attributing a cause.
Raise September's Basic price from $22.00 to $23.00, leaving every quantity and other price unchanged. Basic revenue becomes 900 x 23 = $20,700. Its price effect becomes (23 - 20) x 900 = $2,700; its volume and mix contributions stay unchanged.
| Measure | Original (USD) | Revised (USD) |
|---|---|---|
| September Basic revenue | 19,800 | 20,700 |
| September total revenue | 64,800 | 65,700 |
| Total price effect | 1,800 | 2,700 |
| Total volume effect | 9,000 | 9,000 |
| Total mix effect | 9,000 | 9,000 |
| Total revenue change | 19,800 | 20,700 |
The revised check is 45,000 + 2,700 + 9,000 + 9,000 = $65,700. This isolates the input that moved: the price bar and ending revenue change while the quantity-based bars remain stable.
A product table can show each product's contribution to the company bridge, as above. A fresh bridge calculated only for Basic answers a different question. With only one product, mix is zero; Basic's price effect is $1,800 and its volume effect is (900 - 1,000) x 20 = -$2,000, still totaling -$200.
Both readings reconcile, but the attribution changes. Label a selected view either as a contribution to the company bridge or as a recalculated bridge within the selection. Customer and region selections need the same discipline. Do not sum independently recalculated mix effects and expect them to reproduce a bridge built on different proportions.
Use a price volume mix analysis template to define the review columns, or the Excel template method for spreadsheet preparation. Businesses selling hours or service rates should use the appropriate unit basis described in rate volume mix analysis.
Covirage is not affiliated with Microsoft.
Bring a file or Google Sheet containing comparable quantities, net revenue, products, and periods: Covirage maps the columns, and its tools compute and check the figures from the supplied rows. The external AI model explains the results with every figure traced to its rows, so the discussion starts from a reconciled comparison. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.
See revenue driver analysis for the supporting approach.
Include prior and current revenue, the total change, a bridge of the contributing effects, and an exception table. Show the period, currency, unit definition, and calculation method beside them. Keep the reconciliation visible so reviewers can distinguish a complete explanation from an unfinished analysis.
Mix depends on the comparison group's prior sales proportions. Recalculating after a selection changes that reference group. State whether a view shows contributions to the original company bridge or a new bridge within the selection, and keep that choice consistent across panels.
Revenue alone supports a revenue-change comparison, but it cannot separate price from units and mix. Obtain comparable quantities and net revenue for each product in both periods. Keep unmatched products visible rather than filling a missing prior price with zero.