Contribution Margin per SKU: A Working Model

Contribution Margin per SKU: A Working Model

A contribution margin per SKU model answers one question that revenue reporting never does: after production, shipping, platform fees, and a share of acquisition cost, how many dollars does this product leave behind? Build it as a spreadsheet with one row per SKU and a fixed set of cost columns, subtract those columns from the sale price, and you get a figure you can rank. That ranking, not total revenue, decides which products stay in the catalogue.

Most sellers calculate contribution margin at store level and never at SKU level. The store number hides the products that quietly lose money on every order. A hoodie that sells well can sit near zero once you load its true parcel weight and the fee percentage it attracts, while a lower-volume accessory carries real margin. Only a per-SKU contribution margin view separates the two, and the build takes an afternoon.

What Belongs in the Contribution Margin Line

Four cost groups belong in the model, and nothing else. Production cost covers the blank, the decoration, and any packaging you add. Fulfilment cost covers outbound shipping plus the pick and pack fee. Channel cost covers the marketplace or platform percentage plus payment processing. Acquisition cost is the blended ad or affiliate spend that brought the order in. Subtract all four from the sale price and the remainder is your contribution margin.

Two rules keep that number honest. First, use the fee percentage the SKU attracts in practice instead of a store-wide average, because categories and price bands are billed differently. Second, spread acquisition cost by the traffic each product earns rather than evenly. If one hero product absorbs most of your ad budget, a flat allocation will flatter everything around it and distort the contribution margin ranking you are about to act on.

Building the Model Column by Column

Set up the sheet with SKU name, sale price, and then one column per cost group. Add a column for units sold in the period so you can weight results, and a final column that subtracts the four cost groups from price. Format that last column as currency and sort on it. Anything landing below your floor goes to a review list rather than straight into the bin. The measuring print on demand unit economics breakdown covers which cost lines belong where when you build the sheet for the first time.

Keep the sheet in the same units as your accounting. If production invoices arrive in another currency, convert at the rate on the invoice date and note it in a cell. That note matters later, because it explains why a re-run of the contribution margin report moved even though nothing about the product changed.

A Worked Example at Three Price Points

Take a tee at 24 dollars, a hoodie at 52, and a tote at 19. The tee might carry production near 11, fulfilment near 6, channel fees near 3.4, and acquisition near 3, leaving under a dollar. The hoodie supports a higher price but a heavier parcel can push fulfilment toward 9, so a premium product does not automatically produce a healthier contribution margin. Published POD profit margin benchmarks by product type give you a sanity range to compare against before you trust your own sheet.

Reading the Output: Which SKUs to Prune

Sort ascending and read the bottom decile first. A SKU that ranks last on contribution margin but sells in volume is worse than a slow mover with a healthy margin, because every order compounds the loss. Raise the price on the first group and watch the effect for two weeks before deciding anything. Products that cannot carry a price rise without losing sales are the ones to retire, and a clean barcode and SKU system for custom products makes that retirement painless because every variant maps to one record.

Keep the ranking visible to whoever plans the catalogue. A contribution margin list that lives in one person's spreadsheet gets ignored at the next product meeting. A shared sheet with a monthly refresh changes the conversation from what looks good to what pays, and it gives the person cutting products a defensible number to point at.

Where Contribution Margin Models Drift

Three inputs move under you. Carrier rates shift with parcel dimensions and annual revisions. Platform fees change with policy updates. Acquisition cost swings with auction pressure in peak season. Re-run the contribution margin sheet monthly and again within a week of any fee announcement, because a stale model produces confident decisions from old numbers. Comparing print on demand versus dropshipping models is useful here, since the two carry very different fixed cost floors.

Seasonal products need their own treatment. A holiday item may hold a strong contribution margin in November and turn negative in January once storage and returns land on the ledger. A worked example of that swing appears in this Christmas ornaments print on demand profit guide. Score seasonal items across the whole season rather than the current month, so a contribution margin that looks ugly in a quiet week does not send a good product to the bin. If you would rather build the model on costs you can verify, start from the custom product catalogue and price the range before you commit to a product mix.

Related Articles

Print on Demand Business Models Compared for 2026

Profit and Loss Templates for POD Sellers

Sticker Business Startup Guide for POD Sellers