Blog · Board and management reporting · Consumer goods
Compare promotional volume with a stated baseline, then calculate contribution after product and promotion costs. A worked US consumer goods example shows why higher sales can still leave less contribution.
A promotion dashboard compares actual promotional sales with a stated baseline and shows what remains after product costs and promotion spending. Put observed lift beside contribution change, keep the baseline visible, and distinguish a commercial comparison from evidence that the promotion caused the result.
A commercial review needs to answer whether volume increased, whether the extra business paid for its concessions and spending, and what should change for the next event. A sales chart alone cannot answer the second question.
Use a common event key across the promotion calendar, sales file, cost file, and trade-spend register. A useful row identifies the account, product, event dates, sales basis, and baseline version. Report events that still have missing claims or incomplete sales separately from closed events.
Keep the unit basis consistent. If the dashboard uses consumer sell-out units, use the manufacturer's realized revenue and product cost attributable to those same units, with any allocation documented. A shipment-based view can also be useful, but sell-in against sell-out explains why retailer inventory movement can make the two views disagree.
Finance should approve the cost treatment. Credits and allowances need to reduce the relevant sales amount; the IRS discussion of sales returns and allowances likewise describes their deduction from gross sales in arriving at net sales. That supports the revenue convention here, rather than prescribing a company's full financial reporting policy.
Observed unit lift = Actual units − Baseline units
Observed unit lift percentage = Observed unit lift / Baseline units
Contribution after promotion costs = Net revenue − Product cost − Separate promotion costs
Contribution change = Actual contribution after promotion costs − Baseline contribution
The contribution definition here is a management measure before general overhead. It is not net income, and it should not be compared with a ledger margin that includes different costs. The gross margin and contribution margin comparison explains the boundary.
Separate promotion costs include event-specific fees or media spending that have not already reduced net revenue. Price concessions already appear in the realized price. Preserve that distinction in both the input file and the dashboard labels.
Prairie Shelf Brands reviews two completed retail events for September 2026. Each event covers a different product, so the product costs and normal prices differ. Both baselines are approved planning assumptions for the same event windows, not a claim of experimentally established demand.
All units below are comparable selling units. Revenue is the manufacturer's realized amount attributable to those units; product cost excludes the separate promotional spending shown in the last column. The example has no additional delivery or servicing cost changes.
| Event | Baseline units | Actual units | Baseline price per unit (USD) | Actual price per unit (USD) | Product cost per unit (USD) | Separate promotion costs (USD) |
|---|---|---|---|---|---|---|
| Endcap | 10,000 | 15,000 | 5.00 | 4.50 | 3.00 | 4,000 |
| Coupon | 8,000 | 10,000 | 6.00 | 5.50 | 3.50 | 3,000 |
Calculate the unit lift from these inputs, rather than averaging the event percentages.
| Event | Baseline units | Actual units | Observed lift units | Observed lift |
|---|---|---|---|---|
| Endcap | 10,000 | 15,000 | 5,000 | 50.00% |
| Coupon | 8,000 | 10,000 | 2,000 | 25.00% |
| Total | 18,000 | 25,000 | 7,000 | 38.89% |
The total is (25000 − 18000) / 18000 = 38.89%. Percentage results are displayed to two decimal places; calculations retain full precision.
Now work the money. Endcap revenue is 15,000 × 4.50 = $67,500, and its product cost is 15,000 × 3.00 = $45,000. Its baseline contribution is 10,000 × (5.00 − 3.00) = $20,000. Coupon follows the same calculation.
| Event | Actual revenue (USD) | Actual product cost (USD) | Separate promotion costs (USD) | Actual contribution (USD) | Baseline contribution (USD) | Contribution change (USD) |
|---|---|---|---|---|---|---|
| Endcap | 67,500 | 45,000 | 4,000 | 18,500 | 20,000 | -1,500 |
| Coupon | 55,000 | 35,000 | 3,000 | 17,000 | 20,000 | -3,000 |
| Total | 122,500 | 80,000 | 7,000 | 35,500 | 40,000 | -4,500 |
Baseline revenue is 10,000 × 5.00 + 8,000 × 6.00 = $98,000. Actual revenue is $24,500 higher, yet contribution is $4,500 lower. Actual contribution margin is 35,500 / 122,500 = 28.98%, compared with baseline contribution margin of 40,000 / 98,000 = 40.82%.
Hold unit product cost fixed as in the input table. Split the contribution change into extra units at baseline contribution per unit, the price concession on all actual units, and separate promotion spending.
| Event | Volume effect (USD) | Price effect (USD) | Separate cost effect (USD) | Total change (USD) |
|---|---|---|---|---|
| Endcap | 5,000 × (5.00 − 3.00) = 10,000 | 15,000 × (4.50 − 5.00) = -7,500 | -4,000 | -1,500 |
| Coupon | 2,000 × (6.00 − 3.50) = 5,000 | 10,000 × (5.50 − 6.00) = -5,000 | -3,000 | -3,000 |
| Total | 15,000 | -12,500 | -7,000 | -4,500 |
The independent check is $40,000 + $15,000 − $12,500 − $7,000 = $35,500. That equals the contribution calculated directly from actual revenue and costs. If unit costs change, add a separately calculated cost effect instead of hiding the difference in volume.
Reconcile actual revenue to the event's attributed sales rows, units to the retailer's event-period totals, and spend to the claims register plus documented unbilled accruals. A settled claim must replace its accrual, not sit beside it as another expense.
The endcap event has the smaller contribution shortfall. As a sensitivity check, reduce only its separate promotion cost from $4,000 to $1,500. Contribution becomes 67,500 − 45,000 − 1,500 = $21,000, or $1,000 above baseline. This shows the effect of a lower fee under fixed sales assumptions; it does not establish that a retailer would offer the same event for less.
The account manager owns commercial terms, finance owns the contribution bridge and spending reconciliation, and the category team owns the baseline assumptions. Review closed events together before agreeing the next calendar.
Do not label observed lift as caused by the promotion. Availability, distribution gains, seasonality, and competitor activity can all change the comparison. NIST's introduction to experimental design explains planning changes to inputs and accounting for other factors when studying their effects; this dashboard by itself supplies no such design.
The net lift worked example covers the post-event dip in depth. Add that view before interpreting a temporary sales spike as lasting growth, and check weeks of cover when channel inventory rises.
Upload a sample of your own event calendar, sales, baseline, and promotion-cost files; Covirage maps the columns and its tools compute and check the supplied 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 export.
See Covirage for consumer goods brands for the industry context.
Include the promotion dates, account, product, baseline units, actual units, realized revenue, product cost, and promotional spend. Show observed unit lift beside contribution after costs. Include the baseline method and data completeness so a reviewer can judge whether events are comparable.
Choose a documented estimate of sales without the event, using comparable nonpromotion periods or an approved planning estimate. Account for availability, seasonality, and distribution changes. Retain the original baseline and its approval date so later revisions cannot silently improve the reported result.
No. Lift describes a unit or revenue difference against a baseline. Incremental contribution also reflects selling prices, product costs, and event spending. Even that comparison depends on the baseline's credibility and should not be presented as proven causal profit without an appropriate evaluation design.
Only when they represent different costs. A discount already included in realized revenue must not be deducted again as trade spend. Reconcile claims, accruals, and invoice deductions to the event, and assign each amount to a single treatment before calculating contribution.