Free Planning Calculator

Trade Spend Gross-to-Net Calculator for Food Brands

Enter one price, unit volume, pack size, off-invoice rate, per-case promotional fee, slotting fee, and co-op contribution on a consistent scenario basis.

Review one defined scenario

Keep every input on the same SKU, period, channel, pack, and unit basis described below.

Scenario inputs

Entered retailer selling price for one individual unit before modeled trade spend. Unit: USD per unit.

Positive whole number of individual units included in this defined period or promotion. Unit: individual units.

Positive whole pack count used to convert individual units into equivalent cases. Unit: units per case.

Entered percentage discount applied to gross revenue for this defined scenario. Unit: percent.

Entered retailer promotional fee applied to each equivalent case. Unit: USD per case.

Entered one-time slotting or placement amount for the defined scenario; enter zero if none is included. Unit: USD per scenario.

Entered co-op advertising contribution for the defined scenario; enter zero if none is included. Unit: USD per scenario.

Planning outputs

Enter one price, volume, pack, and trade-spend scenario on a consistent basis.

Gross revenue before modeled trade spend

Not recognized revenue or cash received.

Off-invoice discount

Not an actual reconciled retailer deduction.

Promotional fees and contributions

Includes only entered per-case, slotting, and co-op assumptions.

Total modeled trade spend

Not a reconciled ledger amount or complete deduction record.

Net revenue after modeled trade spend

Not profit, contribution, recognized revenue, or cash.

Trade spend as a percentage of gross revenue

Not a target, benchmark, or recommendation.

Effective net price per unit

Not margin or a pricing recommendation.

Formula

Formula ID: TRADE-SPEND-GROSS-TO-NET-V1

Multiply price by units for gross revenue, convert units into equivalent cases without rounding, apply the entered discount and per-case fees, then subtract total modeled trade spend.

  1. Confirm price, unit volume, pack size, rates, and fees refer to one defined scenario.
  2. Multiply base price per unit by individual units for gross revenue.
  3. Divide individual units by units per case without rounding.
  4. Calculate off-invoice dollars and per-case plus scenario-level promotional fees.
  5. Subtract total modeled trade spend from gross revenue and divide by positive units for effective net price.

What this page does—and does not—show

This calculator models the deductions you enter. It does not determine whether a retailer payment is for a distinct service, prescribe revenue recognition, reconcile actual deductions, or calculate profit.

This page owns gross-to-net deduction arithmetic; the Trade Spend Scenario Planner owns a separate incremental contribution-versus-spend scenario.

Evidence and review boundary

Tier B. This calculator models the deductions you enter. It does not determine whether a retailer payment is for a distinct service, prescribe revenue recognition, reconcile actual deductions, or calculate profit.

Compare the entered contract terms, pack size, fee basis, and actual deductions with retailer records and obtain qualified accounting review before reporting decisions.

Sources reviewed

Related tools and next steps

Help shape the operations platform for food brands.

Guidance is being rebuilt with CPG design partners to connect these planning steps to a shared operating model. That connected product workflow is not available for live product demonstrations today. This standalone browser page does not connect to a Guidance account, product data, or a live operating workflow.

Apply as a Design Partner