Contribution margin calculator
Contribution margin calculator
Enter each SKU on each channel with its price, units, cost, fees, fulfillment, returns and ad spend. You get contribution margin per SKU, per channel and in total, before and after ads, with the arithmetic printed. It all runs in your browser. Nothing is uploaded, and there is no email to give.
1. Your SKUs on each channel
Contribution margin = net sales − COGS − fees − fulfillment − ads
One row for each SKU on each channel, all for the same period (a month works). Type over the sample, or copy rows from a spreadsheet and paste them into the first cell.
| SKUor product name | ChannelAmazon, Shopify… | Price$ per unit | Units soldin the period | Unit cost$ landed COGS | Fees %of the price | Fee $per unit | Fulfillment$ per unit | Returns %of sales refunded | Ad spend$ in the period | Remove |
|---|---|---|---|---|---|---|---|---|---|---|
Price is what the customer paid per unit, before tax, including any shipping they paid. Fees % is the marketplace or payment fee as a share of the price. Fee $ is a flat fee per unit, such as the $0.30 card fee on a one-unit order. Fulfillment is pick, pack, postage or the FBA fee per unit.
2. Ad spend not tied to one SKU (optional)
Brand campaigns or a Meta budget that sells the whole store. Each amount is split across that channel's rows by their net sales.
Contribution margin after ads
Before ads
Per unit sold
Channels
Where the sales go
| Channel | Units | Net sales | COGS | Fees | Fulfillment | Before ads | Ads | After ads | Margin % | Per unit | Break-even ROAS | ROAS |
|---|
The arithmetic
What contribution margin is
Contribution margin is what a sale leaves over after the costs that come with it. Sell one more unit and you pay for one more unit of stock, one more marketplace fee, one more box and label. Those are variable costs. Rent, salaries and software do not change with that one sale. They are fixed costs, and contribution margin is the money that pays for them. Whatever is left after that is profit.
The formula has three common forms:
- Contribution margin = sales − variable costs
- Contribution margin per unit = price − variable cost per unit
- Contribution margin ratio = contribution margin ÷ sales
A product that sells for $50 and costs $30 a unit in stock, fees and shipping has a contribution margin of $20 a unit. Its ratio is 20 ÷ 50 = 40%: every dollar of sales leaves 40 cents to cover fixed costs. Sell 1,000 of them and the total contribution margin is $20,000.
For an online seller, the variable costs are the product (COGS, at landed cost), the marketplace or payment fee, fulfillment, refunds, and the ads that sold it. So the version this calculator uses is net sales − COGS − fees − fulfillment − ad spend, with net sales being sales minus refunds.
Why work it out per SKU and per channel
One product does not earn the same everywhere. Amazon takes a referral fee that Shopify does not, fulfillment costs differ, return rates differ, and the ads cost differently on each. Gross margin hides all of that, because it only takes off the cost of the product, and that cost is the same on every channel. A single contribution margin for the whole business hides it too, because a strong channel covers for a weak one.
Working it out per SKU on each channel shows which ones actually pay their way. A SKU that loses money before ads needs a price or cost change. One that loses money only after ads needs its ad spend looked at.
How to use the calculator
- Pick a period. A month is easiest. Every number in a row has to cover the same period.
- Fill one row per SKU per channel. Units and sales by product come from Shopify's Analytics, Reports, "Total sales by product", and from Amazon's Business Reports, "Detail Page Sales and Traffic by Child Item". Divide sales by units if your price changed in the month.
- Unit cost is what one unit cost you to land, freight and duty included. The landed cost calculator works it out from a purchase order.
- Fees. Use your plan's payment rate on Shopify, and the referral fee rate for the product's category on Amazon or Walmart. Put flat per-unit fees in Fee $. The FBA fulfillment fee goes under Fulfillment; Amazon's Fee Preview report lists it per ASIN.
- Returns % is the share of sales you refunded. Ad spend is what you spent on ads for that SKU on that channel, for example from the advertised product report in Amazon's Campaign Manager. Spend that is not tied to a SKU, such as a brand campaign, goes in the second card and is shared out by net sales.
To paste many rows at once, copy them from a spreadsheet in the same column order and paste into the first SKU cell. A header row is skipped.
A worked example
The sample is a made-up candle brand selling three products on Shopify, Amazon and Walmart for a month. Net sales come to $48,620.40. After COGS, fees and fulfillment, $17,028.00 is left, a contribution margin of 35.0% before ads. After $5,020.00 of ads, $12,008.00 is left, or 24.7%.
Take the oak diffuser on Amazon. It sells 180 units at $46.00, which is $8,280.00. Refunds at 11% take $910.80, leaving $7,369.20 of net sales. The diffusers cost $14.20 each to land, so COGS is $2,556.00, and the gross margin is $4,813.20, or 65.3%. That looks healthy. Then the 15% referral fee takes $1,242.00 and fulfillment at $9.95 a unit takes $1,791.00. That leaves $1,780.20 before ads, or 24.2%. The ads cost $1,950.00, so the diffuser on Amazon ends the month $169.80 down, or 94 cents lost on every unit.
The same diffuser on Shopify keeps 33.8% of its sales after ads. The product is fine. The Amazon ads are what lose the money: the row needs a ROAS of 4.14 to break even and gets 3.78.
Break-even ROAS
Return on ad spend (ROAS) is net sales divided by ad spend. Break-even ROAS is net sales divided by contribution margin before ads, which is one over the contribution margin ratio. A SKU that keeps 25% before ads needs $4 of sales for every $1 of ads, a ROAS of 4.0, just to break even. Below that, each ad dollar costs more than the sale it brings in leaves over. A SKU that loses money before ads has no break-even ROAS at all, because no ad return can fix it.
What it leaves out
Fixed costs, by definition. Storage fees, subscriptions and software are monthly costs, not per-sale costs, so they sit below contribution margin. If you want them on a channel, our ecommerce chart of accounts shows how to carry costs down to contribution margin by channel and what changes when you start allocating overhead.
Fees are taken on gross sales and refunded units keep their cost, which is the cautious reading: a marketplace gives back only part of a fee on a refund, and a refund does not say whether the stock came back to sell again. Per-order fees have to be entered per unit, so divide by the units in a typical order. Enter prices after discounts and before sales tax, and use one currency for every row. Sales tax is left out.
This works for a monthly review. It gets slow once you have many SKUs on several channels, because the fees, refunds and costs change on every order. Working it out from the orders themselves, with the fees the marketplace actually charged, is what sku.io's reporting does.
Questions people ask
What is contribution margin?
What a sale leaves over after the costs that come with it: the product, the marketplace or payment fee, fulfillment, and the ads that sold it. That money is what pays for rent, salaries and software, and what is left after those is profit.
What is the contribution margin formula?
Contribution margin = sales − variable costs. For an online seller that is net sales − COGS − fees − fulfillment − ad spend. Per unit, it is the price minus the variable cost of one unit: a $50 product with $30 of variable cost has a contribution margin of $20 a unit.
How do you calculate the contribution margin ratio?
Divide contribution margin by sales. The $50 product with $20 of contribution margin has a ratio of 20 ÷ 50 = 40%. In the example on this page the whole business keeps $12,008.00 of $48,620.40 net sales after ads, a ratio of 24.7%.
What is the difference between contribution margin and gross margin?
Gross margin only takes off the cost of the product. Contribution margin also takes off the costs each sale brings with it, such as fees, fulfillment and ads. In the example, the oak diffuser on Amazon has a 65.3% gross margin and loses $169.80 after ads.
Does contribution margin include fixed costs?
No. Fixed costs such as rent, salaries and software stay the same when you sell one more unit, so they are left out. Contribution margin is the money that has to cover them.
Should ad spend be in contribution margin?
For an online seller, yes. Ads that drive the sale grow and shrink with it, so they behave like a variable cost. The calculator shows contribution margin before and after ads, so you can see both, along with the ROAS at which the ads break even.
Want this on every order, without the spreadsheet?
Bring last month's sales by channel to a call. I'll show you how sku.io works out contribution margin on each order from the real fees and landed costs, then rolls it up by SKU and by channel.
Book a DemoFounder-led demo · 2-day onboarding · no onboarding fees