Product analysis dashboard: sales, margin and demand

A product analysis dashboard compares net revenue, contribution and sales mix across SKUs, customer segments and periods. Use it to identify which products generated more dollars and whether the growth improved the economics of the business.

This page covers commercial product sales from order, invoice and cost exports. Software usage telemetry and manufacturing production measures require different records and definitions.

Start with sales rows that can be reconciled

Bring an invoice-line export containing invoice ID, line ID, posting date, SKU, customer ID, customer segment, quantity, sales amount, discount and credit amount. Bring matched product and variable selling costs for those lines. Preserve the document identifiers so a total can be traced back to its source.

Use net sales after discounts and credits. The IRS discussion of sales returns and allowances explains that customer credits for returned merchandise and other sales allowances reduce gross sales when figuring net sales. The operational point is straightforward: a reversed sale cannot remain in the dashboard as revenue earned.

Agree on the cost boundary with finance. In the example below, variable cost contains merchandise cost and variable order handling attributable to the sold units. It excludes fixed occupancy, salaried administration and financing. Contribution therefore does not mean net profit or a formal accounting gross margin.

The Small Business Administration's break-even explanation uses price less variable cost as the amount available per unit toward fixed costs. That is the basis for contribution here:

Contribution = Net sales − Matched variable costs

Contribution rate = Contribution / Net sales

Product revenue mix = Product net sales / Total net sales

Keep SKU assignments stable across periods. The existing product taxonomy guide explains which measures belong at SKU, family and line level; use it to resolve classification questions before comparing totals.

A worked example: a US office-furniture distributor

Consider an illustrative Arizona distributor reviewing July and August 2026. It sells desks and chairs to business customers and dealers. Each row below summarizes matched invoice and cost lines for one product and segment. Prices are net realized prices; variable cost per unit follows the agreed definition above.

The example assumes no unmatched returns or unallocated variable costs. Actual reviews should display those exceptions separately until resolved.

For each row, multiply units by net price to get revenue, and by variable unit cost to get total variable cost. Subtract the latter from revenue to get contribution.

August revenue increased by 85,200 − 67,000 = $18,200, or 18,200 / 67,000 = 27.2%. Contribution increased by 26,340 − 21,700 = $4,640, or 4,640 / 21,700 = 21.4%.

Contribution grew more slowly than sales. The contribution rate declined from 21,700 / 67,000 = 32.4% to 26,340 / 85,200 = 30.9%. Percentages are rounded to one decimal place after calculation from the original amounts.

Explain the mix before blaming the price

The unit prices and variable unit costs did not change between these months. The difference comes from what was sold and to whom.

Desks take a larger share of revenue. Within desks, the larger dealer volume also matters: dealer desks contribute (180 − 135) / 180 = 25.0% of revenue, against (200 − 140) / 200 = 30.0% for business desks. A dashboard grouped only by product would hide that segment movement.

Use product mix analysis for the deeper decomposition. This dashboard's job is to make the affected SKU and segment visible, then let the commercial owner investigate discounts, order economics and customer needs.

Change one input: dealer desk price

Suppose the August dealer desk price changes from $180 to $190, with its quantity, variable unit cost and every other row unchanged.

The revised contribution rate is 28,140 / 87,000 = 32.3%. The price change adds $1,800 to both revenue and contribution because the example holds units and variable cost constant. It is a sensitivity calculation, not evidence that customers would accept the price without changing their orders.

Give each measure an owner and a proof

Put revenue, contribution dollars and contribution rate above a product-by-segment table. Show the comparison period and cost definition beside the totals. Sales owns the customer explanation, product management reviews assortment choices, and finance owns the reconciliation and cost policy.

For August, the control identity is $85,200 − $58,860 = $26,340. Product totals and segment totals must each reproduce that same company amount. Match revenue to the approved sales ledger after credits, and match variable costs to their source reports. List any unmatched costs rather than leaving them out of the calculation silently.

Invoice quantities measure fulfilled sales. If the question is unmet demand, bring open-order and cancellation records alongside them. Do not infer lost orders from a sales decline alone. For a wider assessment of product condition, the neighboring product health dashboard covers a different question.

Where it goes wrong

• Returns reduce dollars but not units. Realized price becomes inconsistent. Define the quantity treatment for credits and partial returns.
• SKU changes look like growth. A renamed or regrouped item appears new unless the product mapping preserves continuity.
• Variable costs change scope. Adding handling this month when it was excluded last month creates an artificial contribution movement.
• Percentages are averaged. The total contribution rate is summed contribution divided by summed revenue, never an average of row percentages.
• Invoices become a demand forecast. Fulfilled sales alone cannot distinguish weak customer demand from unavailable stock or delayed delivery.

Analyze your own product file in Covirage

Bring invoice lines, credits, product mappings and matched cost records in files or a Google Sheet. Covirage maps the columns; its tools compute and check product revenue, contribution and mix, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See revenue driver analysis for the supporting commercial approach.