Build a contribution-margin sheet for each product

A contribution sheet shows what remains from a sale after the variable costs you have defined. That remainder helps cover fixed costs and, after all relevant expenses, may contribute to profit.

It is not automatically the amount you can withdraw. Use consistent accounting treatment and get professional advice for tax or reporting questions. The numbers below are hypothetical.

Start with the selling amount actually received

Use the price after discounts on the chosen revenue basis. Do not calculate from a crossed-out list price when customers pay less.

Record delivery income separately if you charge it. You can then compare it with the associated delivery cost rather than losing the subsidy inside product revenue.

Keep taxes handled consistently with your accounting method. Do not mix unlike bases simply because the dashboard displays one inclusive total.

List variable costs by cause

Include the costs that change with the sale under your model: product or material cost, relevant production labour, packaging, applicable payment charges and shipping subsidy.

Avoid adding a general allowance without explaining what it covers. If a return or failure allowance is included, label its evidence or scenario basis.

Fixed monthly subscriptions normally belong in a separate overhead section rather than being subtracted again from every order without an allocation rule.

Work through one order

Suppose a product sells for ₹900. The defined costs are ₹300 materials, ₹180 direct labour, ₹40 packaging, ₹27 payment charge and ₹50 delivery subsidy.

Those costs total ₹597. Contribution is ₹900 − ₹597 = ₹303.

Contribution as a share of revenue is ₹303 ÷ ₹900, or about 33.67%. The payment rate in this example is hypothetical; use your applicable schedule.

Explain what remains outside

The ₹303 is not net profit if software, rent, administration or other expenses remain uncovered.

Add a note beside the result naming important exclusions. This is more useful than presenting a large percentage without context.

If you allocate overhead per order for another purpose, show that as a separate calculation so the same cost is not counted twice.

Keep quantity logic explicit

Some costs repeat per item, while others repeat per order. A second item may require another product cost but not another full outer box.

Model the actual packing arrangement. Do not multiply every cost by quantity indiscriminately.

For a bundle or multi-item basket, calculate the combined variable cost and contribution instead of assuming the single-item percentage stays unchanged.

Add a comparison column

Use a second column for a proposed discount, new supplier price or different packaging. Change only the relevant inputs first.

This makes the effect visible. If several assumptions change at once, you may not know which caused the result.

Do not use the sheet to claim that a price increase will leave demand unchanged. It calculates contribution at a given sale, not the customer's willingness to buy.

Reconcile with actual records

Periodically compare the model with invoices, packaging use and applicable fees. Investigate differences rather than treating the initial estimate as permanent.

Separate unusual one-off costs from recurring patterns. A single damaged parcel does not establish a reliable return rate, but it may reveal a missing cost category.

Keep the date and source of each important input so another person can update the sheet.

Make the output decision-ready

Use clear columns: revenue, each variable cost, contribution, contribution percentage and excluded overhead. Add a note identifying whether figures are observed or assumed.

Check the ₹900 example as a known test: costs ₹597, contribution ₹303. A formula error should be caught before the sheet guides a promotion.

Use contribution to compare offers and cover fixed costs, not as a substitute for complete accounts. The value of the worksheet is transparency: it shows which assumptions create the apparent room for a discount or additional spending.

For the distinction between percentages, read markup versus margin. Naming the measure correctly makes the next pricing decision easier to explain.