# Contribution Margin by Product Worksheet > Source: https://netray.co/tools/contribution-margin-by-product-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Compare products by contribution margin per unit, per product line and as a percentage of revenue, then export the table to Excel. ## Category cost-finance ## Audience - Controller - Cost accountant - Sales operations ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Product **Key:** product **Type:** text #### Units sold **Key:** units **Type:** number #### Net price per unit **Key:** price **Type:** number **Format:** currency #### Variable cost per unit **Key:** vc **Type:** number **Format:** currency #### Revenue **Key:** rev **Type:** number **Expr:** units * price **Format:** currency #### Margin per unit **Key:** cm_unit **Type:** number **Expr:** price - vc **Format:** currency #### Contribution margin **Key:** cm **Type:** number **Expr:** units * (price - vc) **Format:** currency #### Margin % **Key:** cm_pct **Type:** number **Expr:** if(gt(rev,0), cm / rev * 100, 0) **Format:** percent **Rows:** #### Hydraulic manifold HM-210 **Units:** 1800 **Price:** 142 **Vc:** 96 #### Valve body VB-40 **Units:** 5200 **Price:** 38.5 **Vc:** 29.8 #### Mounting bracket MB-7 **Units:** 24000 **Price:** 6.2 **Vc:** 5.1 #### Custom fixture (job) **Units:** 35 **Price:** 2150 **Vc:** 1490 #### Spare seal kit SK-12 **Units:** 9000 **Price:** 11.4 **Vc:** 4.9 **Totals:** #### Total revenue **Key:** rev **Agg:** sum **Format:** currency #### Total contribution margin **Key:** cm **Agg:** sum **Format:** currency **Summary:** #### Blended margin % **Key:** blended **Expr:** if(gt(sum_rev,0), sum_cm / sum_rev * 100, 0) **Format:** percent **Primary:** true **Description:** Total contribution margin divided by total revenue. #### Highest margin per unit **Key:** best **Expr:** max_cm_unit **Format:** currency **Notes:** Use net price after rebates and discounts, and variable cost that moves with volume: material, direct labor paid by the piece, freight out, commissions and variable overhead. Leave fixed costs such as rent and salaried supervision out of the unit cost. ## Content **Intro:** Contribution margin shows how much each product adds toward fixed cost and profit after variable costs are paid. This worksheet computes margin per unit, total margin and margin percent for each product, so you can see which lines carry the business and which ones only look busy. **Sections:** #### How to use it **Body:** List each product or product family, then enter units sold for the period, the average net selling price and the variable cost per unit. The sheet calculates revenue, margin per unit, total contribution and margin percent for every row, and totals the blended result at the bottom. Replace the sample rows with your own and export to Excel for the monthly pack. **Bullets:** - Use net price after discounts, rebates and freight allowed. - Include material, direct labor that varies with output, packaging and freight out. - Exclude depreciation, rent and fixed salaries from variable cost. - Group very small items into one family to keep the table readable. #### The formula **Body:** Contribution margin per unit is price minus variable cost per unit. Total contribution is units multiplied by that margin. Contribution margin ratio is total contribution divided by revenue. Unlike gross margin, it does not include fixed overhead absorbed into the standard cost, so it answers the question of what happens to profit if one more unit is sold or dropped. Fixed costs are then covered by the sum of the contributions, which is the basis of break-even and mix decisions. #### Reading the table **Body:** Sort mentally by total contribution, not by revenue. A bracket with a low percent but huge volume may give more dollars than a custom fixture with a high percent. Check the blended margin against the level you need to cover fixed costs. If a product has a positive contribution but a negative gross margin under full absorption, dropping it will usually lower profit unless the capacity it uses can be sold at a better margin. Constrained machines make the margin per machine hour a better ranking than margin per unit. #### Common mistakes **Body:** Using standard cost from the ERP as variable cost mixes in fixed overhead, which understates margin on high-volume items. Using list price rather than net price overstates it. Averaging across products with very different mixes hides the real picture, so keep the unit of analysis at the product or family that you can actually price or cut. Finally, remember the numbers are a snapshot, and a change in mix will shift the blended percent even if no price changes. **Cta:** If you want contribution margin by product pulled straight from your ERP sales and cost data, we can set up a read-only report that refreshes monthly. **Faq:** #### What is contribution margin? **Answer:** It is selling price minus variable cost per unit. It shows the amount each unit contributes toward fixed costs and profit. Summed across products it tells you how much revenue is left to cover overhead once the cost of making and selling the goods is paid. #### How is it different from gross margin? **Answer:** Gross margin deducts the full absorbed cost of goods sold, including fixed overhead allocated per unit. Contribution margin deducts only variable cost. It is better for volume, mix and make-or-drop decisions, while gross margin is what appears on the income statement. #### Should I drop a product with low margin percent? **Answer:** Not by percent alone. If the contribution is positive and the capacity would otherwise sit idle, the product still helps cover fixed cost. Drop it when the capacity or sales effort can earn more elsewhere, or when the contribution is negative. #### Which costs are variable? **Answer:** Direct material, piece-rate or output-driven labor, packaging, freight out, sales commissions and the variable part of utilities and tooling. Costs that stay the same across the relevant range, such as rent, insurance and salaried staff, are fixed. ## Search terms contribution margin by product worksheet, contribution margin analysis excel, product profitability worksheet, contribution margin template, margin by product line, variable costing worksheet, product mix margin analysis, contribution margin ratio table --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json