Separate price-linked charges from fixed order costs
Product cost, quoted fulfilment, packaging and other fixed order expenses stay as cash amounts within this scenario. The advertising input is a percentage of gross product sales, so its cash cost changes when the solver changes price. Platform and eligible creator percentages also move with their defined sales bases.
The simple formula below assumes no buyer-paid shipping, no discounts, no returns, a single VAT rate and price-linked charges calculated on gross item sales. Let v be VAT, f the platform rate, a the creator rate, q the eligible affiliate revenue share, d the advertising rate and C all fixed non-percentage costs. For a target margin m on gross sales, subtract m from the denominator as well.
Break-even gross price = C / [1 / (1 + v) − f − a × q − d]; target-margin gross price = C / [1 / (1 + v) − f − a × q − d − m]Illustrative example: a €44.18 floor with 10% advertising
Assume France's 20% standard VAT, a 9% platform fee, a 10% creator rate on all sales and advertising at 10% of gross product sales. Fixed costs are €24: €18 goods, €5 fulfilment and €1 packaging. There are no refunds, buyer-paid shipping or other costs. At the initial €60 price, advertising is €6; the price solver recalculates that cash amount as price changes.
The break-even denominator is 1 / 1.20 − 0.09 − 0.10 − 0.10 = 0.543333. Dividing €24 by it gives €44.1718, so the minimum cent price is €44.18. Selecting a 10% target margin gives €54.1353, rounded upward to €54.14. A 15% target gives €61.0169, rounded upward to €61.02. Recheck a commercially rounded price using the same percentage assumptions.
| Selected objective | Unrounded price | Minimum cent price |
|---|---|---|
| Break-even, 0% target | €44.1718 | €44.18 |
| 10% contribution / gross sales | €54.1353 | €54.14 |
| 15% contribution / gross sales | €61.0169 | €61.02 |
Find the discount budget from the solved floor
Compare the intended campaign price after seller-funded discounts with the solved target price. For an illustrative €60 list price and a €54.14 floor at a 10% target, seller-funded discount headroom is €5.86, or about 9.77% of list price. A 10% markdown to €54 would narrowly miss that target under the stated percentage-advertising assumptions.
Platform-funded offers need separate treatment. Do not assume every customer coupon reduces seller revenue by the face value, and do not assume it leaves commission unchanged. Use the funded amounts in the campaign terms and confirm a settled order when an unfamiliar promotion begins.
Seller-funded discount headroom = list price − required transaction price; discount % = headroom / list priceRecognise when the algebra has no commercial solution
A zero or negative denominator means the price-linked deductions and requested margin absorb all the revenue generated by a higher price. No positive finite price can then cover the fixed costs under this model. Lower the percentage costs, change the economics or review the target; zero is not a valid profitable selling price.
Returns, partial inventory recovery, buyer-paid shipping and other entered costs require the calculator's full scenario rather than the simplified equation. Select the target margin, inspect both the zero-contribution floor and the target price, and validate the final rounded offer by entering it back into the order model. A mathematical solution does not establish customer willingness to pay.
- Confirm fixed costs, tax treatment and percentage advertising input.
- Use the applicable post-launch commission and eligible creator revenue share.
- Select zero margin for break-even or the gross-sales margin you require.
- Round the resulting price upward to a valid currency increment.
- Re-enter the final price and verify contribution before testing the offer.
Should a promotion ever go below the floor?
A deliberate acquisition loss requires a separate, evidenced business case. Later repeat purchases, bundle attachment or inventory clearance can matter, but they should not be inserted as guaranteed revenue into a single-order calculator. Keep the loss visible and set a finite budget for the experiment.
If every market requires a price above what buyers accept, reconsider the product, pack size or supply arrangement. The floor identifies the cost structure's constraint; it does not establish willingness to pay.