Blog · Territory, capacity and quota planning · Consumer goods
Build a CPG operating plan from units, invoice prices, trade spending and product costs. Work through a plan-versus-actual contribution bridge and test a supplied promotion scenario.
A CPG financial model connects product units, invoice prices, trade spending and costs to contribution and operating profit. Build the workbook by product and customer, then compare actual results with the drivers in your supplied plan. The useful answer is why profit changed, not simply whether shipments increased.
For a US consumer packaged goods brand, export invoice lines with period, customer, product, unit of measure, quantity, gross sales and credit references. Add the promotion plan, trade accrual register, retailer deduction file and product cost schedule. Use recognized sales for the period; shipments, customer orders and retailer checkout sales answer different questions.
Standardize packs and cases before calculating a price per unit. Preserve the conversion used for each product so finance and sales can reproduce the quantity total. Keep customer deductions linked to the promotion and selling period that created them, even when settlement happens later.
Define the product-cost boundary with the controller. For purchased merchandise, the IRS describes cost as invoice price less appropriate discounts plus transportation or other acquisition charges. That tax guidance illustrates why acquisition freight belongs in a documented cost definition; it does not determine every financial reporting classification.
Keep delivery to customers separate in this example. The distinction between gross profit and contribution margin matters because the two measures can include different costs. This article uses contribution after product costs and variable outbound delivery, before fixed operating expenses.
Consider a fictional US snack brand selling multipacks to retailers. One unit means one multipack throughout. Column A contains row labels, B is plan, C is actual and D is a supplied trade-spend scenario. All included trade spending reduces revenue under the example's stated policy; there are no additional returns or discounts.
| Row and measure | Plan B (USD unless stated) | Actual C (USD unless stated) | Scenario D (USD unless stated) |
|---|---|---|---|
| 2: Sales units, count | 100,000 | 110,000 | 110,000 |
| 3: Gross invoice price per unit | 5.00 | 5.00 | 5.00 |
| 4: Trade spend as share of gross sales | 10.0% | 14.0% | 12.0% |
| 5: Product cost per unit | 2.40 | 2.50 | 2.50 |
| 6: Outbound delivery per unit | 0.20 | 0.20 | 0.20 |
| 7: Fixed operating expenses | 100,000 | 105,000 | 105,000 |
| 8: Gross invoice sales | 500,000 | 550,000 | 550,000 |
| 9: Trade spend | 50,000 | 77,000 | 66,000 |
| 10: Net revenue | 450,000 | 473,000 | 484,000 |
| 11: Product costs | 240,000 | 275,000 | 275,000 |
| 12: Outbound delivery | 20,000 | 22,000 | 22,000 |
| 13: Contribution | 190,000 | 176,000 | 187,000 |
| 14: Contribution margin | 42.2% | 37.2% | 38.6% |
| 15: Operating profit | 90,000 | 71,000 | 82,000 |
Enter these Excel formulas in B8 through B15, respectively, then copy across. Monetary outputs are rounded to whole dollars; displayed contribution margins are rounded to one decimal place.
=B2*B3
=B8*B4
=B8-B9
=B2*B5
=B2*B6
=B10-SUM(B11:B12)
=B13/B10
=B13-B7
Microsoft's SUM documentation supports adding the cost range in B13. Covirage is not affiliated with Microsoft.
Use gross invoice sales as the trade-rate denominator because that is the assumption in row 4. Use net revenue as the contribution-margin denominator in row 14. Confusing those denominators makes an otherwise correct workbook disagree with the commercial plan.
Net revenue increased by $23,000, but contribution fell by $14,000. Product and delivery costs grew faster than net sales. A driver bridge shows how that happened without blaming volume for a trade-rate change.
Apply volume at planned unit economics, then apply the actual trade rate and actual unit costs to actual units. Fixed expense changes come last.
| Driver | Calculation | Operating profit movement (USD) |
|---|---|---|
| Additional units at planned contribution | (110,000 - 100,000) × (5 × 90% - 2.40 - 0.20) | 19,000 |
| Higher trade rate | -550,000 × (14% - 10%) | -22,000 |
| Higher product cost | -110,000 × (2.50 - 2.40) | -11,000 |
| Higher fixed expenses | -(105,000 - 100,000) | -5,000 |
| Total change | Sum of movements | -19,000 |
The check is $90,000 + $19,000 - $22,000 - $11,000 - $5,000 = $71,000. No delivery-rate movement is needed because the rate stayed unchanged; the extra delivery cost is already included in the volume step. Preserve this bridge order across reporting periods.
The wider FP&A process sets ownership of assumptions and review dates. A manufacturing financial model addresses production capacity and factory drivers when the brand makes its own products.
Scenario D changes only the trade rate, from 14% to 12%. Spending falls by $11,000, so contribution and operating profit each increase by $11,000. Units stay unchanged deliberately: this is a sensitivity, not evidence that promotion reductions will leave demand unaffected. Sales must supply a separate volume assumption if the promotion change is expected to affect demand.
Trade expense and retailer deductions are not interchangeable. Suppose the actual trade register has these balances:
| Trade accrual movement | Amount (USD) |
|---|---|
| Opening accrual | 18,000 |
| Current-period trade expense | 77,000 |
| Claims settled against the accrual | -65,000 |
| Closing accrual | 30,000 |
The reconciliation is $18,000 + $77,000 - $65,000 = $30,000. Match the closing balance to the trade register and ledger. Settled claims consume an existing accrual; subtracting them again from the $473,000 net revenue would double count spending. Keep disputed or unmatched deductions visible for review.
For inventory and collection timing beyond this contribution review, use the FMCG financial model cash schedule.
Bring your planning workbook, invoice export, trade register and cost schedule to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains contribution differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for CPG brands for the industry context.
Include product and customer identifiers, recognized sales units, invoice price, discounts and trade accruals, product costs, delivery costs and fixed operating expenses. Retain promotion identifiers so finance can connect planned spending with retailer claims and settlement records.
Follow the company's approved accounting policy and the substance of each arrangement. This example treats all included trade spending as a revenue reduction. Keep services purchased from retailers identifiable so the controller can determine their appropriate treatment.
Contribution deducts the variable costs included in the management definition, which can include delivery and selling costs outside reported cost of goods sold. Gross profit uses the company's financial reporting definition of revenue and cost of goods sold. State both definitions before comparing them.