Blog · Finance metrics and formulas
Compare realized selling prices, units and contribution by product and customer segment. A worked sales-export example shows how to turn observed differences into a pricing review without claiming to measure price elasticity.
Marketing analytics pricing strategies and price analytics compare the prices customers actually paid with units sold and contribution earned. Start with a sales export, keep comparable products together, and review the result by customer segment. A high selling price is useful only when the associated volume and cost leave an attractive contribution.
The question is which offers and customer groups earn enough contribution at their observed prices. That is different from selecting analytics software or comparing software subscription prices.
Use three measures together: net selling price per unit, units sold, and contribution before marketing. Define contribution here as net revenue less the variable product and delivery costs finance has assigned to those sales. It is not operating profit because fixed overhead and marketing spending remain outside this example.
Net selling price per unit = Net revenue / Net units sold
Contribution before marketing = Net revenue - Matched variable costs
Contribution margin = Contribution before marketing / Net revenue
A segment comparison supplies evidence about your own transactions. Market context still matters: the SBA's market research guidance includes what customers pay for alternatives among the questions a business should investigate. Neither that research nor a sales average proves the price a particular customer will accept.
Export invoice-line ID, transaction date, customer ID, segment, product, quantity, net revenue and matched variable cost. Use a common reporting cutoff and USD throughout. Keep credit memos associated with their original sales where the review requires a cohort view.
Normalize quantities before calculating a price. A case and an individual unit must not share a denominator unless you have an explicit conversion. Returns need consistent signs for both quantity and revenue; a credit with no returned quantity may instead be a price adjustment.
Choose the segment definition before reviewing the result. Here, small accounts and enterprise accounts are existing commercial classifications. Do not define the segments from the price being tested, because that would guarantee a price difference by construction.
Keep unmatched costs visible. An invoice line with no cost lookup is incomplete, rather than a sale with no delivery expense. Reconcile the selected revenue to the sales ledger before using the comparison in a pricing meeting.
An illustrative US office-supply distributor compares two products across two segments for a completed quarter. Both products use the same standardized unit, although their specifications differ. The following rows are summaries of matched invoice lines, with discounts and credits already reflected in revenue.
| Product | Segment | Units | Net revenue (USD) | Variable costs (USD) | Net unit price (USD) | Contribution (USD) | Contribution margin |
|---|---|---|---|---|---|---|---|
| Standard | Small accounts | 1,000 | 100,000 | 65,000 | 100.00 | 35,000 | 35.0% |
| Standard | Enterprise | 1,500 | 135,000 | 93,000 | 90.00 | 42,000 | 31.1% |
| Premium | Small accounts | 500 | 75,000 | 42,000 | 150.00 | 33,000 | 44.0% |
| Premium | Enterprise | 800 | 112,000 | 68,800 | 140.00 | 43,200 | 38.6% |
| Total | 3,800 | 422,000 | 268,800 | 111.05 | 153,200 | 36.3% |
Prices are rounded to cents and margins to one decimal place. Calculations use the unrounded underlying values.
For Standard enterprise sales, $135,000 / 1,500 gives a $90.00 unit price. Subtracting $93,000 leaves $42,000 of contribution; $42,000 / $135,000 gives 31.1% when rounded. Its contribution exceeds Standard small-account contribution even though its unit price and margin are lower, because more units were sold.
Premium enterprise sales have a lower unit price than Premium small-account sales. That is a review question, not evidence of an unauthorized discount. Agreements, order sizes and delivery requirements may explain it. Use price realization by customer for the separate list-price comparison, and the invoiced versus contracted price method when an effective contract price is the relevant reference.
Put the table's first data row in spreadsheet row 2, with units in C, revenue in D and variable costs in E. In Excel, the calculated columns are:
F2 = D2/C2
G2 = D2-E2
H2 = G2/D2
Fill them through row 5. Flag a zero denominator for review before dividing. Calculate the totals from dollars and units:
F6 = SUM(D2:D5)/SUM(C2:C5)
G6 = SUM(D2:D5)-SUM(E2:E5)
H6 = SUM(G2:G5)/SUM(D2:D5)
The price check is a unit-weighted average. Microsoft documents SUMPRODUCT as multiplying corresponding array entries and summing the products, so the following must equal total revenue:
=SUMPRODUCT(C2:C5,F2:F5)
The proof is $422,000 - $268,800 = $153,200, and $153,200 / $422,000 rounds to 36.3%. Summing the product-segment contributions also gives $153,200. Separately, the simple average of the four prices is $120.00; the correct combined price is $422,000 / 3,800 = $111.05. Even that weighted combined price changes with product mix, so use product-level comparisons for pricing decisions.
Suppose the pricing owner considers changing only Premium enterprise unit price from $140.00 to $145.00. Hold units at 800 and variable costs at $68,800 as explicit scenario assumptions.
| Measure | Observed | Price scenario |
|---|---|---|
| Units | 800 | 800 |
| Unit price (USD) | 140.00 | 145.00 |
| Revenue (USD) | 112,000 | 116,000 |
| Variable costs (USD) | 68,800 | 68,800 |
| Contribution (USD) | 43,200 | 47,200 |
The arithmetic is 800 × $145.00 = $116,000, then $116,000 - $68,800 = $47,200. Contribution increases by $4,000 under those assumptions. This is a scenario, not a forecast: the table contains no evidence that volume would stay unchanged.
Marketing owns the offer context, sales checks customer commitments, and finance checks the cost assumptions. The pricing owner decides whether to test the change. For changes between reporting periods, use the existing price-volume-mix bridge, which separates the movements without treating them as causal elasticity.
Covirage is not affiliated with Microsoft.
Bring a sales export with quantities, net revenue, customer segments and matched costs. Covirage maps the columns, and its tools compute and check the price and contribution comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See customer profitability for the contribution context behind the pricing decision.
Start with invoice-line identifiers, product codes, customer segments, quantities, net revenue and matched variable costs. Keep transaction dates, unit definitions and currency. Add dated price agreements when checking compliance, and separate missing costs from genuine zero costs.
Sales history shows the prices, quantities and margins observed under past conditions. Customers, promotions and product mix may have changed together. Use those results to frame a test or a commercial review, rather than treating a historical association as a demand response.
Commercial finance should own the contribution definition and reconciliations. Marketing supplies the segment and offer context, sales checks agreements and customer commitments, and the pricing owner approves any change. Assign one person to resolve disputed classifications before comparing results.