Price Variance and Hidden Revenue Loss

Price Variance: When Portfolio Averages Conceal Transaction Differences

City Shift Finance Commentary

A stable average selling price can conceal sharply different outcomes across comparable transactions, leaving commercial leaders with an incomplete account of where negotiated terms change realized revenue.

A commercial review shows that average selling price has held steady, even as account managers report increasingly difficult renewals and finance sees uneven revenue performance across customer groups. The portfolio result appears reassuring because higher prices on some transactions offset lower prices on others; the underlying records, however, may contain materially different outcomes for customers purchasing comparable products under similar commercial conditions. A stable average can therefore coexist with a change in the transactions that produce it.

The financial consequence emerges when that aggregate result becomes the basis for the next pricing decision. Management may conclude that the current price position is holding, although individual accounts have accepted different discounts, credits or contractual terms; subsequent increases then begin from an uneven commercial base, and the expected revenue improvement depends on which transactions can actually be repriced. The average describes the portfolio outcome, while the distribution determines where the next price action will encounter resistance.

Transaction comparisons require a consistent basis because a difference in realized selling price can reflect legitimate variation in product specification, order size, service commitments, delivery conditions or contractual duration. The relevant comparison groups transactions with similar economic characteristics, then separates differences attributable to defined commercial terms from those that remain unexplained. Without that discipline, an account receiving a lower price for a larger purchasing commitment can appear equivalent to one receiving an additional concession without a corresponding commitment.

Within revenue management, the issue becomes more consequential when the portfolio contains several routes to market. Direct accounts, distributors and negotiated enterprise contracts may carry different commercial adjustments, while rebates and credits can change the measured endpoint after invoicing. Combining those transactions before establishing a common price definition can make a change in channel composition look like a change in pricing performance, even when the price achieved within each channel has remained relatively stable.

The same problem can develop inside a single customer relationship. An account may receive one set of terms for its core purchases and another for incremental orders, while a renewal preserves concessions originally attached to a narrower commitment. The resulting transaction differences can persist beneath an apparently unchanged account average; whether those differences remain intentional depends on the agreement, purchasing record and approval history, which cannot be established from the price distribution alone.

Recurring pricing concessions introduce a further complication because a transaction that began as an exception may gradually influence subsequent negotiations. When a customer uses the exceptional price as a reference for future orders, the lower outcome can spread across a larger purchasing base; the commercial effect becomes apparent only when transactions are compared over time and the terms attached to each price are retained alongside the invoice record. A lower observed price is a signal for investigation, with the contract and approval evidence determining its significance.

Averages can also move because the mix of transactions changes. Growth among lower-priced products or channels may reduce the portfolio average even when like-for-like prices improve; conversely, a shift toward higher-priced transactions can conceal deterioration within a comparable customer or product group. Separating mix movement from like-for-like transaction differences prevents leadership from attributing the entire portfolio result to commercial execution, particularly when the same reporting period contains both pricing changes and shifts in purchasing behavior.

The distinction is especially important when rebate commitments alter the amount retained after an invoice is issued. Two transactions with similar invoice prices can reach different pocket-price outcomes because their contractual deductions differ; an analysis limited to the invoice can therefore understate variation in the economics the business has chosen to measure. Comparisons need a consistent endpoint and a documented treatment of any rebates allocated across multiple transactions.

The decision facing leadership concerns the transactions that deserve commercial attention before another portfolio-wide increase is approved. Where comparable orders show persistent differences after legitimate terms and mix effects have been accounted for, the business has a defined set of contracts, approvals and account conditions to investigate; where the differences reflect deliberate exchanges of value, those economics can be preserved in the pricing decision. The portfolio average remains useful for reporting, but the transaction record determines which price positions can support the next commercial commitment.

City Shift Finance Analyst Team

Contact Us

Create your account

Continue your analyses, email calculation records, and return to your work from one account.

Have an account?

Contact us

Contact us

Contact

Topics of Interest:

Sign up to download