Model affiliate contribution
Enter net sales and product costs in USD, the commission rate, and other variable costs. Fixed overhead and income tax are excluded.
- Result
- $4,000.00
- Result
- $1,500.00
How this estimate works: Use your own store data before making a commercial decision. All monetary amounts are USD.
Start with net sales and actual product costs
Use merchandise sales after the discounts and refunds relevant to your scenario. Enter product costs as a separate dollar amount for the items represented in those sales. Do not enter a margin percentage into the product-cost field. For example, 1,000 of net sales and 400 of product cost leave 600 before commission and other expenses. Keep the revenue and cost figures within the same reporting period and currency.
A customer discount lowers revenue while the physical cost of the product generally remains. Reflect that discount in net sales instead of deducting it a second time as another expense. Use the actual promoted product mix: a storewide cost ratio can overstate profitability if partners mainly recommend lower-margin items. When projecting a future period, record how you estimated both sales and the corresponding goods cost.
Understand what contribution does and does not mean
The worksheet subtracts product costs, percentage commission on entered net sales, and the other variable costs you provide. This is contribution, not a complete accounting profit. Fixed program expenses, business overhead, and income tax remain outside the result. Use the other-variable-cost field for expenses that belong to the modeled sales, such as payment processing, shipping subsidies, packaging, or other order-related costs not already included in product costs.
Keep a separate note of recurring software, campaign administration, or other fixed commitments that this calculation excludes. A positive displayed result may still be insufficient to cover those expenses. Conversely, do not deduct packaging or fulfillment twice by including it in both product costs and other variable costs. Document your cost definitions and retain them across scenarios so improvements reflect business changes rather than inconsistent inputs.
Use scenarios to make an offer decision
Run a conservative sales total, a central case based on observed performance, and a higher-volume scenario with the corresponding product and variable costs. Change one input at a time first: this exposes whether the plan is most sensitive to commission, product costs, or demand. Then test a combined downside case, such as lower order value alongside fewer orders. None of these scenarios predicts how many customers a creator will actually bring.
A positive contribution is also different from incremental profit. Some referred buyers may have purchased without the partnership. Compare customer mix, campaign timing, and changes in other channels before attributing the entire result to the program. Start with an offer that leaves room for unmodeled costs, review actual eligible orders after a complete return period, and update the worksheet from reconciled data.
Worked example · illustrative scenario
Worked example: contribution before fixed overhead
An illustrative period has 1,800 in net sales after discounts, 800 in product costs, a 10% commission rate, and 100 in other variable costs. Commission is 180, leaving 720 of contribution. A separate fixed program expense of 150 would reduce the amount available after that expense to 570; the tool itself excludes fixed costs.
Frequently asked questions
Is the result my store’s net profit?
No. It is contribution after the inputs modeled here. Full net profit also depends on expenses, adjustments, and accounting treatments that this worksheet does not include.
Should commissions be included in product costs?
No. The calculator computes commission separately from net sales and the entered rate. Include product costs once, and put other order-related expenses in the variable-cost field.
What does a negative result mean?
The entered sales do not cover the modeled product, commission, and other variable costs. Review the offer and cost structure before expanding; a larger loss-making volume can increase the total loss.
Put your Shopify affiliate plan into practice
Use Afivio to organize your affiliate campaigns, partners and commission records. Review the integration guide and current app listing before choosing your setup.